Trang chủ Khám phá Trợ giúp
Đăng ký Đăng nhập
zhuhongbin
/
TMRWatchNew
1
0
Fork 0
Các tập tin Các vấn đề 0 Yêu cầu khéo về 0 Wiki
Branch: dev
Branches Tags
TMRWatchNew
/
linux安装方法
/
TMRWatch
/
data
/
mysql
/
tmrwatch
/
newesttmrweighttime.frm

newesttmrweighttime.frm 6.6 KB
Permalink Lịch sử Raw

12345678910111213141516 
  1. TYPE=VIEW
    2. 

  2. query=select `dtl2_bar`.`BNAME` AS `BNAME`,`dtl2_bar`.`ID` AS `dtl2ID`,`dtl1_feed`.`FNAME` AS `fname`,`dtl1_feed`.`ID` AS `fdtl1.id`,`tmrwatch`.`tmr`.`TNAME` AS `TNAME`,`tmrwatch`.`tmr`.`ID` AS `tmrID`,`tmrwatch`.`tmr`.`DataCaptureNo` AS `DataCaptureNo`,`tmrwatch`.`recbutton`.`ID` AS `recbuttonID`,`tmrwatch`.`recbutton`.`ObjAddr` AS `ObjAddr`,`tmrwatch`.`recbutton`.`SrcAddr` AS `SrcAddr`,`tmrwatch`.`recbutton`.`InTime` AS `InTime`,`tmrwatch`.`recbutton`.`ButtonType` AS `ButtonType`,`tmrwatch`.`recbutton`.`ProjTodayID` AS `ProjTodayID`,`tmrwatch`.`downloadedplan`.`Pid` AS `Pid`,`tmrwatch`.`downloadedplan`.`id` AS `downloadedplanid`,`tmrwatch`.`downloadedplan`.`Mydate` AS `Mydate`,`tmrwatch`.`downloadedplan`.`TodayID` AS `TodayID`,`tmrwatch`.`downloadedplan`.`ProjName` AS `ProjName`,`tmrwatch`.`downloadedplan`.`Minutes` AS `Minutes`,`tmrwatch`.`downloadedplan`.`ItemNum` AS `ItemNum`,`tmrwatch`.`downloadedplan`.`MobileMacNo` AS `MobileMacNo`,`tmrwatch`.`recbutton`.`FeedItemID` AS `FeedItemID`,case when `tmrwatch`.`recbutton`.`FeedItemID` >= 32768 then `dtl2_bar`.`BarName2` when `tmrwatch`.`recbutton`.`FeedItemID` = 0 then \'计划已开始\' else `dtl1_feed`.`Feedname2` end AS `OperateName`,case when `tmrwatch`.`recbutton`.`FeedItemID` >= 32768 then -`dtl2_bar`.`LWEIGHT` when `tmrwatch`.`recbutton`.`FeedItemID` = 0 then 0 else `dtl1_feed`.`LWEIGHT` end AS `OperateWeight` from ((((`tmrwatch`.`tmr` join `tmrwatch`.`recbutton` on(`tmrwatch`.`tmr`.`DataCaptureNo` = `tmrwatch`.`recbutton`.`SrcAddr` or `tmrwatch`.`tmr`.`MobileMacNo` = `tmrwatch`.`recbutton`.`SrcAddr`)) join `tmrwatch`.`downloadedplan` on(cast(`tmrwatch`.`recbutton`.`InTime` as date) = cast(`tmrwatch`.`downloadedplan`.`Mydate` as date) and `tmrwatch`.`recbutton`.`ProjTodayID` = `tmrwatch`.`downloadedplan`.`TodayID` and (`tmrwatch`.`downloadedplan`.`DataCaptureNo` = `tmrwatch`.`recbutton`.`SrcAddr` or `tmrwatch`.`downloadedplan`.`MobileMacNo` = `tmrwatch`.`recbutton`.`SrcAddr`))) left join `tmrwatch`.`dtl2_bar` on(`tmrwatch`.`recbutton`.`FeedItemID` = `dtl2_bar`.`FBarID` + 32768 and `tmrwatch`.`downloadedplan`.`Pid` = `dtl2_bar`.`PID`)) left join `tmrwatch`.`dtl1_feed` on(`tmrwatch`.`recbutton`.`FeedItemID` = `dtl1_feed`.`FID` and `tmrwatch`.`downloadedplan`.`Pid` = `dtl1_feed`.`PID`)) where `tmrwatch`.`tmr`.`ENABLE` = 1
    3. 

  3. md5=91b7ab972fc3b1a592b2acdba3fc6d43
    4. 

  4. updatable=0
    5. 

  5. algorithm=0
    6. 

  6. definer_user=root
    7. 

  7. definer_host=localhost
    8. 

  8. suid=1
    9. 

  9. with_check_option=0
    10. 

  10. timestamp=2021-12-05 04:06:49
    11. 

  11. create-version=2
    12. 

  12. source=select `dtl2_bar`.`BNAME` AS `BNAME`,`dtl2_bar`.`ID` AS `dtl2ID`,`dtl1_feed`.`FNAME` AS `fname`,`dtl1_feed`.`ID` AS `fdtl1.id`,`tmr`.`TNAME` AS `TNAME`,`tmr`.`ID` AS `tmrID`,`tmr`.`DataCaptureNo` AS `DataCaptureNo`,`recbutton`.`ID` AS `recbuttonID`,`recbutton`.`ObjAddr` AS `ObjAddr`,`recbutton`.`SrcAddr` AS `SrcAddr`,`recbutton`.`InTime` AS `InTime`,`recbutton`.`ButtonType` AS `ButtonType`,`recbutton`.`ProjTodayID` AS `ProjTodayID`,`downloadedplan`.`Pid` AS `Pid`,`downloadedplan`.`id` AS `downloadedplanid`,`downloadedplan`.`Mydate` AS `Mydate`,`downloadedplan`.`TodayID` AS `TodayID`,`downloadedplan`.`ProjName` AS `ProjName`,`downloadedplan`.`Minutes` AS `Minutes`,`downloadedplan`.`ItemNum` AS `ItemNum`,`downloadedplan`.`MobileMacNo` AS `MobileMacNo`,`recbutton`.`FeedItemID` AS `FeedItemID`,(case when (`recbutton`.`FeedItemID` >= 32768) then `dtl2_bar`.`BarName2` when (`recbutton`.`FeedItemID` = 0) then \'计划已开始\' else `dtl1_feed`.`Feedname2` end) AS `OperateName`,(case when (`recbutton`.`FeedItemID` >= 32768) then -(`dtl2_bar`.`LWEIGHT`) when (`recbutton`.`FeedItemID` = 0) then 0 else `dtl1_feed`.`LWEIGHT` end) AS `OperateWeight` from ((((`tmr` join `recbutton` on(((`tmr`.`DataCaptureNo` = `recbutton`.`SrcAddr`) or (`tmr`.`MobileMacNo` = `recbutton`.`SrcAddr`)))) join `downloadedplan` on(((cast(`recbutton`.`InTime` as date) = cast(`downloadedplan`.`Mydate` as date)) and (`recbutton`.`ProjTodayID` = `downloadedplan`.`TodayID`) and ((`downloadedplan`.`DataCaptureNo` = `recbutton`.`SrcAddr`) or (`downloadedplan`.`MobileMacNo` = `recbutton`.`SrcAddr`))))) left join `dtl2_bar` on(((`recbutton`.`FeedItemID` = (`dtl2_bar`.`FBarID` + 32768)) and (`downloadedplan`.`Pid` = `dtl2_bar`.`PID`)))) left join `dtl1_feed` on(((`recbutton`.`FeedItemID` = `dtl1_feed`.`FID`) and (`downloadedplan`.`Pid` = `dtl1_feed`.`PID`)))) where (`tmr`.`ENABLE` = 1)
    13. 

  13. client_cs_name=utf8
    14. 

  14. connection_cl_name=utf8_general_ci
    15. 

  15. view_body_utf8=select `dtl2_bar`.`BNAME` AS `BNAME`,`dtl2_bar`.`ID` AS `dtl2ID`,`dtl1_feed`.`FNAME` AS `fname`,`dtl1_feed`.`ID` AS `fdtl1.id`,`tmrwatch`.`tmr`.`TNAME` AS `TNAME`,`tmrwatch`.`tmr`.`ID` AS `tmrID`,`tmrwatch`.`tmr`.`DataCaptureNo` AS `DataCaptureNo`,`tmrwatch`.`recbutton`.`ID` AS `recbuttonID`,`tmrwatch`.`recbutton`.`ObjAddr` AS `ObjAddr`,`tmrwatch`.`recbutton`.`SrcAddr` AS `SrcAddr`,`tmrwatch`.`recbutton`.`InTime` AS `InTime`,`tmrwatch`.`recbutton`.`ButtonType` AS `ButtonType`,`tmrwatch`.`recbutton`.`ProjTodayID` AS `ProjTodayID`,`tmrwatch`.`downloadedplan`.`Pid` AS `Pid`,`tmrwatch`.`downloadedplan`.`id` AS `downloadedplanid`,`tmrwatch`.`downloadedplan`.`Mydate` AS `Mydate`,`tmrwatch`.`downloadedplan`.`TodayID` AS `TodayID`,`tmrwatch`.`downloadedplan`.`ProjName` AS `ProjName`,`tmrwatch`.`downloadedplan`.`Minutes` AS `Minutes`,`tmrwatch`.`downloadedplan`.`ItemNum` AS `ItemNum`,`tmrwatch`.`downloadedplan`.`MobileMacNo` AS `MobileMacNo`,`tmrwatch`.`recbutton`.`FeedItemID` AS `FeedItemID`,case when `tmrwatch`.`recbutton`.`FeedItemID` >= 32768 then `dtl2_bar`.`BarName2` when `tmrwatch`.`recbutton`.`FeedItemID` = 0 then \'计划已开始\' else `dtl1_feed`.`Feedname2` end AS `OperateName`,case when `tmrwatch`.`recbutton`.`FeedItemID` >= 32768 then -`dtl2_bar`.`LWEIGHT` when `tmrwatch`.`recbutton`.`FeedItemID` = 0 then 0 else `dtl1_feed`.`LWEIGHT` end AS `OperateWeight` from ((((`tmrwatch`.`tmr` join `tmrwatch`.`recbutton` on(`tmrwatch`.`tmr`.`DataCaptureNo` = `tmrwatch`.`recbutton`.`SrcAddr` or `tmrwatch`.`tmr`.`MobileMacNo` = `tmrwatch`.`recbutton`.`SrcAddr`)) join `tmrwatch`.`downloadedplan` on(cast(`tmrwatch`.`recbutton`.`InTime` as date) = cast(`tmrwatch`.`downloadedplan`.`Mydate` as date) and `tmrwatch`.`recbutton`.`ProjTodayID` = `tmrwatch`.`downloadedplan`.`TodayID` and (`tmrwatch`.`downloadedplan`.`DataCaptureNo` = `tmrwatch`.`recbutton`.`SrcAddr` or `tmrwatch`.`downloadedplan`.`MobileMacNo` = `tmrwatch`.`recbutton`.`SrcAddr`))) left join `tmrwatch`.`dtl2_bar` on(`tmrwatch`.`recbutton`.`FeedItemID` = `dtl2_bar`.`FBarID` + 32768 and `tmrwatch`.`downloadedplan`.`Pid` = `dtl2_bar`.`PID`)) left join `tmrwatch`.`dtl1_feed` on(`tmrwatch`.`recbutton`.`FeedItemID` = `dtl1_feed`.`FID` and `tmrwatch`.`downloadedplan`.`Pid` = `dtl1_feed`.`PID`)) where `tmrwatch`.`tmr`.`ENABLE` = 1
    16. 

  16. mariadb-version=100511
    17.