| 123456789101112131415 |
- TYPE=VIEW
- query=select `heatwatch`.`cow`.`varCowCode` AS `varCowCode`,if((`heatwatch`.`cow`.`intCurBar` > 0),`heatwatch`.`cow`.`intCurBarName`,\'待分配\') AS `intCurBarName`,`heatwatch`.`cow`.`intCurFetal` AS `intCurFetal`,date_format(`heatwatch`.`cow`.`productionDate`,\'%m-%d\') AS `productionDate`,`heatwatch`.`cow`.`intPastureId` AS `intPastureId`,`heatwatch`.`cow`.`sireClass` AS `sireClass` from (`heatwatch`.`cow` join `heatwatch`.`bar` on(((`heatwatch`.`cow`.`intCurBar` = `heatwatch`.`bar`.`varBarCode`) and (`heatwatch`.`cow`.`intPastureId` = `heatwatch`.`bar`.`intPastureId`)))) where (((to_days(`heatwatch`.`cow`.`productionDate`) - to_days(curdate())) < 7) and isnull(`heatwatch`.`cow`.`dateLeave`) and (`heatwatch`.`cow`.`sireClass` = \'已孕\'))
- md5=c93a13cf8e55f8531c9b2c4845d59620
- updatable=1
- algorithm=0
- definer_user=roo
- definer_host=%
- suid=1
- with_check_option=0
- timestamp=2022-12-14 10:07:39
- create-version=1
- source=select `cow`.`varCowCode` AS `varCowCode`,if(`cow`.`intCurBar` > 0,`cow`.`intCurBarName`,\'待分配\') AS `intCurBarName`,`cow`.`intCurFetal` AS `intCurFetal`,date_format(`cow`.`productionDate`,\'%m-%d\') AS `productionDate`,`cow`.`intPastureId` AS `intPastureId`,`cow`.`sireClass` AS `sireClass` from (`cow` join `bar` on(`cow`.`intCurBar` = `bar`.`varBarCode` and `cow`.`intPastureId` = `bar`.`intPastureId`)) where to_days(`cow`.`productionDate`) - to_days(curdate()) < 7 and `cow`.`dateLeave` is null and `cow`.`sireClass` = \'已孕\'
- client_cs_name=utf8
- connection_cl_name=utf8_general_ci
- view_body_utf8=select `heatwatch`.`cow`.`varCowCode` AS `varCowCode`,if((`heatwatch`.`cow`.`intCurBar` > 0),`heatwatch`.`cow`.`intCurBarName`,\'待分配\') AS `intCurBarName`,`heatwatch`.`cow`.`intCurFetal` AS `intCurFetal`,date_format(`heatwatch`.`cow`.`productionDate`,\'%m-%d\') AS `productionDate`,`heatwatch`.`cow`.`intPastureId` AS `intPastureId`,`heatwatch`.`cow`.`sireClass` AS `sireClass` from (`heatwatch`.`cow` join `heatwatch`.`bar` on(((`heatwatch`.`cow`.`intCurBar` = `heatwatch`.`bar`.`varBarCode`) and (`heatwatch`.`cow`.`intPastureId` = `heatwatch`.`bar`.`intPastureId`)))) where (((to_days(`heatwatch`.`cow`.`productionDate`) - to_days(curdate())) < 7) and isnull(`heatwatch`.`cow`.`dateLeave`) and (`heatwatch`.`cow`.`sireClass` = \'已孕\'))
|
