TYPE=VIEW
query=select `heatwatch`.`cow`.`varCowCode` AS `varCowCode`,if((`heatwatch`.`cow`.`intCurBar` > 0),`heatwatch`.`cow`.`intCurBarName`,\'待分配\') AS `intCurBarName`,\'人工报告\' AS `sort`,concat(if((`heatwatch`.`assist`.`sort` = 3),\'乳房炎：\',if((`heatwatch`.`assist`.`sort` = 4),\'蹄病：\',\'疾病：\')),`heatwatch`.`assist`.`describing`,\'，报告人：\',ifnull(`heatwatch`.`employee`.`varEmployeeName`,\'\'),\'DIM:\',`heatwatch`.`cow`.`lactationDays`,\'天。\') AS `DISCRIBE`,`heatwatch`.`cow`.`intPastureId` AS `intPastureId`,1 AS `rtype` from ((`heatwatch`.`cow` join `heatwatch`.`assist` on(((`heatwatch`.`cow`.`intCowId` = `heatwatch`.`assist`.`intCowId`) and (`heatwatch`.`assist`.`sort` in (3,4,5)) and ((to_days(curdate()) - to_days(`heatwatch`.`assist`.`eventDateTime`)) < 3) and isnull(`heatwatch`.`assist`.`checkDateTime`)))) left join `heatwatch`.`employee` on(((`heatwatch`.`assist`.`intEmployeeId` = `heatwatch`.`employee`.`intEmployeeId`) and (`heatwatch`.`assist`.`intPastureId` = `heatwatch`.`employee`.`intPastureId`)))) order by `heatwatch`.`cow`.`intCurBarName`,`heatwatch`.`cow`.`varCowCode`
md5=2d21dd660ad7193ea93c09e8c6858cfd
updatable=0
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`,\'人工报告\' AS `sort`,concat(if(`assist`.`sort` = 3,\'乳房炎：\',if(`assist`.`sort` = 4,\'蹄病：\',\'疾病：\')),`assist`.`describing`,\'，报告人：\',ifnull(`employee`.`varEmployeeName`,\'\'),\'DIM:\',`cow`.`lactationDays`,\'天。\') AS `DISCRIBE`,`cow`.`intPastureId` AS `intPastureId`,1 AS `rtype` from ((`cow` join `assist` on(`cow`.`intCowId` = `assist`.`intCowId` and `assist`.`sort` in (3,4,5) and to_days(curdate()) - to_days(`assist`.`eventDateTime`) < 3 and `assist`.`checkDateTime` is null)) left join `employee` on(`assist`.`intEmployeeId` = `employee`.`intEmployeeId` and `assist`.`intPastureId` = `employee`.`intPastureId`)) order by `cow`.`intCurBarName`,`cow`.`varCowCode`
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`,\'人工报告\' AS `sort`,concat(if((`heatwatch`.`assist`.`sort` = 3),\'乳房炎：\',if((`heatwatch`.`assist`.`sort` = 4),\'蹄病：\',\'疾病：\')),`heatwatch`.`assist`.`describing`,\'，报告人：\',ifnull(`heatwatch`.`employee`.`varEmployeeName`,\'\'),\'DIM:\',`heatwatch`.`cow`.`lactationDays`,\'天。\') AS `DISCRIBE`,`heatwatch`.`cow`.`intPastureId` AS `intPastureId`,1 AS `rtype` from ((`heatwatch`.`cow` join `heatwatch`.`assist` on(((`heatwatch`.`cow`.`intCowId` = `heatwatch`.`assist`.`intCowId`) and (`heatwatch`.`assist`.`sort` in (3,4,5)) and ((to_days(curdate()) - to_days(`heatwatch`.`assist`.`eventDateTime`)) < 3) and isnull(`heatwatch`.`assist`.`checkDateTime`)))) left join `heatwatch`.`employee` on(((`heatwatch`.`assist`.`intEmployeeId` = `heatwatch`.`employee`.`intEmployeeId`) and (`heatwatch`.`assist`.`intPastureId` = `heatwatch`.`employee`.`intPastureId`)))) order by `heatwatch`.`cow`.`intCurBarName`,`heatwatch`.`cow`.`varCowCode`
