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` = \'已孕\'))
