Página Principal Explorar Ajuda
Registe-se Iniciar Sessão
xuyiping
/
docker-compose
1
0
Fork 0
Ficheiros Problemas 0 Pull Requests 0 Wiki
Ramo: master
Ramos Etiquetas
docker-compose
/
mysql5.7
/
mysql
/
data
/
heatwatch
/
v_weight.frm

v_weight.frm 2.7 KB
Link permanente Histórico Em bruto

123456789101112131415 
  1. TYPE=VIEW
    2. 

  2. query=select `heatwatch`.`cow`.`varCowCode` AS `varCowCode`,if((`heatwatch`.`cow`.`intCurBar` > 0),`heatwatch`.`cow`.`intCurBarName`,\'待分配\') AS `intCurBarName`,floor(`heatwatch`.`cow`.`monthAge`) AS `sort`,concat(\'出生日期：\',`heatwatch`.`cow`.`dateBirthDate`) AS `DESCRIB`,`heatwatch`.`cow`.`intPastureId` AS `intPastureId` from (`heatwatch`.`cow` left join `heatwatch`.`weight` on(((`heatwatch`.`cow`.`intCowId` = `heatwatch`.`weight`.`intCowId`) and (floor(`heatwatch`.`cow`.`monthAge`) = `heatwatch`.`weight`.`intWeightClass`)))) where (find_in_set(floor(`heatwatch`.`cow`.`monthAge`),(select `heatwatch`.`manageparam`.`varVal` from `heatwatch`.`manageparam` where ((`heatwatch`.`manageparam`.`varDiscribe` = \'体尺月龄\') and (`heatwatch`.`manageparam`.`intPastureId` = `heatwatch`.`cow`.`intPastureId`)))) and isnull(`heatwatch`.`weight`.`intCowId`)) order by `heatwatch`.`cow`.`intCurBar`,`heatwatch`.`cow`.`varCowCode`
    3. 

  3. md5=2be65d977761b5325dbf5c9205caac3d
    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`,floor(`cow`.`monthAge`) AS `sort`,concat(\'出生日期：\',`cow`.`dateBirthDate`) AS `DESCRIB`,`cow`.`intPastureId` AS `intPastureId` from (`cow` left join `weight` on(`cow`.`intCowId` = `weight`.`intCowId` and floor(`cow`.`monthAge`) = `weight`.`intWeightClass`)) where find_in_set(floor(`cow`.`monthAge`),(select `manageparam`.`varVal` from `manageparam` where `manageparam`.`varDiscribe` = \'体尺月龄\' and `manageparam`.`intPastureId` = `cow`.`intPastureId`)) and `weight`.`intCowId` is null order by `cow`.`intCurBar`,`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`,floor(`heatwatch`.`cow`.`monthAge`) AS `sort`,concat(\'出生日期：\',`heatwatch`.`cow`.`dateBirthDate`) AS `DESCRIB`,`heatwatch`.`cow`.`intPastureId` AS `intPastureId` from (`heatwatch`.`cow` left join `heatwatch`.`weight` on(((`heatwatch`.`cow`.`intCowId` = `heatwatch`.`weight`.`intCowId`) and (floor(`heatwatch`.`cow`.`monthAge`) = `heatwatch`.`weight`.`intWeightClass`)))) where (find_in_set(floor(`heatwatch`.`cow`.`monthAge`),(select `heatwatch`.`manageparam`.`varVal` from `heatwatch`.`manageparam` where ((`heatwatch`.`manageparam`.`varDiscribe` = \'体尺月龄\') and (`heatwatch`.`manageparam`.`intPastureId` = `heatwatch`.`cow`.`intPastureId`)))) and isnull(`heatwatch`.`weight`.`intCowId`)) order by `heatwatch`.`cow`.`intCurBar`,`heatwatch`.`cow`.`varCowCode`
    16.