首页 发现 帮助
注册 登录
xuyiping
/
docker-compose
1
0
派生 0
文件 工单管理 0 合并请求 0 Wiki
分支: master
分支列表 标签列表
docker-compose
/
mysql5.7
/
mysql
/
data
/
heatwatch
/
v_diseaseregistry.frm

v_diseaseregistry.frm 3.3 KB
永久链接 文件历史 原始文件

123456789101112131415 
  1. TYPE=VIEW
    2. 

  2. 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`
    3. 

  3. md5=2d21dd660ad7193ea93c09e8c6858cfd
    4. 

  4. updatable=0
    5. 

  5. algorithm=0
    6. 

  6. definer_user=roo
    7. 

  7. definer_host=%
    8. 

  8. suid=1
    9. 

  9. with_check_option=0
    10. 

  10. timestamp=2022-12-14 10:07:39
    11. 

  11. create-version=1
    12. 

  12. 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`
    13. 

  13. client_cs_name=utf8
    14. 

  14. connection_cl_name=utf8_general_ci
    15. 

  15. 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`
    16.