temp-tickets/ectms-tickets-2025
10
0
Code Issues 24 Packages Projects Wiki

2025-02-10 义乌妇幼 内镜 数据高铁问题，数据更新时间造成对方查询问题 #42

New Issue
Closed
opened 2025-02-10 17:55:01 +08:00 by bigtran · 0 comments
bigtran commented 2025-02-10 17:55:01 +08:00
Owner
Copy Link
Copy Source

image

修改前

select '1233078247177175XE' AS `tyshxydm`,'47177175X33078211G1001' AS `yljgdm`,'义乌市妇幼保健院' AS `yljgmc`,'01' AS `yqdm`,'总院' AS `yqmc`,substring_index(substring_index(`sjgt_qc_prepare`.`result_in_one`,'|',1),'|',-(1)) AS `njzklsh`,'330024738' AS `qgwym`,`endoscope_disinfe_process`.`njbh` AS `njbh`,`endoscope_disinfe_process`.`njmc` AS `njmc`,`endoscope_disinfe_process`.`njlx` AS `njlx`,`endoscope_disinfe_process`.`qxlcbh` AS `qxlcbh`,NULL AS `mxpbnd`,substring_index(substring_index(`sjgt_qc_prepare`.`result_in_one`,'|',2),'|',-(1)) AS `xdmjjpbpcbh`,substring_index(substring_index(`sjgt_qc_prepare`.`result_in_one`,'|',3),'|',-(1)) AS `xdjzl`,substring_index(substring_index(`sjgt_qc_prepare`.`result_in_one`,'|',4),'|',-(1)) AS `xdjhmjjnd`,substring_index(substring_index(`sjgt_qc_prepare`.`result_in_one`,'|',5),'|',-(1)) AS `szzp`,date_format(substring_index(substring_index(`sjgt_qc_prepare`.`result_in_one`,'|',6),'|',-(1)),'%Y%m%d%H%i%s') AS `jcjgscsj`,NULL AS `xdhmjjjcpc`,substring_index(substring_index(`sjgt_qc_prepare`.`result_in_one`,'|',7),'|',-(1)) AS `xdhmjjjcjg`,`endoscope_disinfe_process`.`qxrybh` AS `xdmjrybh`,`endoscope_disinfe_process`.`qxryxm` AS `xdmjryxm`,substring_index(substring_index(`sjgt_qc_prepare`.`result_in_one`,'|',8),'|',-(1)) AS `xdmjjpcbh`,'2898' AS `zssbbh`,1 AS `zssbzt`,NULL AS `sdlxysl`,`endoscope_disinfe_process`.`qxxdjdypt` AS `qxxdjdypt`,NULL AS `njccgbh`,date_format(substring_index(substring_index(`sjgt_qc_prepare`.`result_in_one`,'|',6),'|',-(1)),'%Y%m%d%H%i%s') AS `jlrqsj`,0 AS `scbz`,date_format(now(),'%Y%m%d%H%i%s') AS `sjgxsj` from (`endoscope_disinfe_process` left join `sjgt_qc_prepare` on((`endoscope_disinfe_process`.`njxdlsh` = `sjgt_qc_prepare`.`njxdlsh`)))

修改后

select '1233078247177175XE' AS `tyshxydm`,'47177175X33078211G1001' AS `yljgdm`,'义乌市妇幼保健院' AS `yljgmc`,'01' AS `yqdm`,'总院' AS `yqmc`,substring_index(substring_index(`sjgt_qc_prepare`.`result_in_one`,'|',1),'|',-(1)) AS `njzklsh`,'330024738' AS `qgwym`,`endoscope_disinfe_process`.`njbh` AS `njbh`,`endoscope_disinfe_process`.`njmc` AS `njmc`,`endoscope_disinfe_process`.`njlx` AS `njlx`,`endoscope_disinfe_process`.`qxlcbh` AS `qxlcbh`,NULL AS `mxpbnd`,substring_index(substring_index(`sjgt_qc_prepare`.`result_in_one`,'|',2),'|',-(1)) AS `xdmjjpbpcbh`,substring_index(substring_index(`sjgt_qc_prepare`.`result_in_one`,'|',3),'|',-(1)) AS `xdjzl`,substring_index(substring_index(`sjgt_qc_prepare`.`result_in_one`,'|',4),'|',-(1)) AS `xdjhmjjnd`,substring_index(substring_index(`sjgt_qc_prepare`.`result_in_one`,'|',5),'|',-(1)) AS `szzp`,date_format(substring_index(substring_index(`sjgt_qc_prepare`.`result_in_one`,'|',6),'|',-(1)),'%Y%m%d%H%i%s') AS `jcjgscsj`,NULL AS `xdhmjjjcpc`,substring_index(substring_index(`sjgt_qc_prepare`.`result_in_one`,'|',7),'|',-(1)) AS `xdhmjjjcjg`,`endoscope_disinfe_process`.`qxrybh` AS `xdmjrybh`,`endoscope_disinfe_process`.`qxryxm` AS `xdmjryxm`,substring_index(substring_index(`sjgt_qc_prepare`.`result_in_one`,'|',8),'|',-(1)) AS `xdmjjpcbh`,'2898' AS `zssbbh`,1 AS `zssbzt`,NULL AS `sdlxysl`,`endoscope_disinfe_process`.`qxxdjdypt` AS `qxxdjdypt`,NULL AS `njccgbh`,date_format(substring_index(substring_index(`sjgt_qc_prepare`.`result_in_one`,'|',6),'|',-(1)),'%Y%m%d%H%i%s') AS `jlrqsj`,0 AS `scbz`,date_format(`endoscope_disinfe_process`.`sjgxsj`,'%Y%m%d%H%i%s') AS `sjgxsj` from (`endoscope_disinfe_process` left join `sjgt_qc_prepare` on((`endoscope_disinfe_process`.`njxdlsh` = `sjgt_qc_prepare`.`njxdlsh`)))
![image](/attachments/848a6147-5cb8-40af-ba18-537fdfe4efff) ## 修改前 ``` select '1233078247177175XE' AS `tyshxydm`,'47177175X33078211G1001' AS `yljgdm`,'义乌市妇幼保健院' AS `yljgmc`,'01' AS `yqdm`,'总院' AS `yqmc`,substring_index(substring_index(`sjgt_qc_prepare`.`result_in_one`,'|',1),'|',-(1)) AS `njzklsh`,'330024738' AS `qgwym`,`endoscope_disinfe_process`.`njbh` AS `njbh`,`endoscope_disinfe_process`.`njmc` AS `njmc`,`endoscope_disinfe_process`.`njlx` AS `njlx`,`endoscope_disinfe_process`.`qxlcbh` AS `qxlcbh`,NULL AS `mxpbnd`,substring_index(substring_index(`sjgt_qc_prepare`.`result_in_one`,'|',2),'|',-(1)) AS `xdmjjpbpcbh`,substring_index(substring_index(`sjgt_qc_prepare`.`result_in_one`,'|',3),'|',-(1)) AS `xdjzl`,substring_index(substring_index(`sjgt_qc_prepare`.`result_in_one`,'|',4),'|',-(1)) AS `xdjhmjjnd`,substring_index(substring_index(`sjgt_qc_prepare`.`result_in_one`,'|',5),'|',-(1)) AS `szzp`,date_format(substring_index(substring_index(`sjgt_qc_prepare`.`result_in_one`,'|',6),'|',-(1)),'%Y%m%d%H%i%s') AS `jcjgscsj`,NULL AS `xdhmjjjcpc`,substring_index(substring_index(`sjgt_qc_prepare`.`result_in_one`,'|',7),'|',-(1)) AS `xdhmjjjcjg`,`endoscope_disinfe_process`.`qxrybh` AS `xdmjrybh`,`endoscope_disinfe_process`.`qxryxm` AS `xdmjryxm`,substring_index(substring_index(`sjgt_qc_prepare`.`result_in_one`,'|',8),'|',-(1)) AS `xdmjjpcbh`,'2898' AS `zssbbh`,1 AS `zssbzt`,NULL AS `sdlxysl`,`endoscope_disinfe_process`.`qxxdjdypt` AS `qxxdjdypt`,NULL AS `njccgbh`,date_format(substring_index(substring_index(`sjgt_qc_prepare`.`result_in_one`,'|',6),'|',-(1)),'%Y%m%d%H%i%s') AS `jlrqsj`,0 AS `scbz`,date_format(now(),'%Y%m%d%H%i%s') AS `sjgxsj` from (`endoscope_disinfe_process` left join `sjgt_qc_prepare` on((`endoscope_disinfe_process`.`njxdlsh` = `sjgt_qc_prepare`.`njxdlsh`))) ``` ## 修改后 ``` select '1233078247177175XE' AS `tyshxydm`,'47177175X33078211G1001' AS `yljgdm`,'义乌市妇幼保健院' AS `yljgmc`,'01' AS `yqdm`,'总院' AS `yqmc`,substring_index(substring_index(`sjgt_qc_prepare`.`result_in_one`,'|',1),'|',-(1)) AS `njzklsh`,'330024738' AS `qgwym`,`endoscope_disinfe_process`.`njbh` AS `njbh`,`endoscope_disinfe_process`.`njmc` AS `njmc`,`endoscope_disinfe_process`.`njlx` AS `njlx`,`endoscope_disinfe_process`.`qxlcbh` AS `qxlcbh`,NULL AS `mxpbnd`,substring_index(substring_index(`sjgt_qc_prepare`.`result_in_one`,'|',2),'|',-(1)) AS `xdmjjpbpcbh`,substring_index(substring_index(`sjgt_qc_prepare`.`result_in_one`,'|',3),'|',-(1)) AS `xdjzl`,substring_index(substring_index(`sjgt_qc_prepare`.`result_in_one`,'|',4),'|',-(1)) AS `xdjhmjjnd`,substring_index(substring_index(`sjgt_qc_prepare`.`result_in_one`,'|',5),'|',-(1)) AS `szzp`,date_format(substring_index(substring_index(`sjgt_qc_prepare`.`result_in_one`,'|',6),'|',-(1)),'%Y%m%d%H%i%s') AS `jcjgscsj`,NULL AS `xdhmjjjcpc`,substring_index(substring_index(`sjgt_qc_prepare`.`result_in_one`,'|',7),'|',-(1)) AS `xdhmjjjcjg`,`endoscope_disinfe_process`.`qxrybh` AS `xdmjrybh`,`endoscope_disinfe_process`.`qxryxm` AS `xdmjryxm`,substring_index(substring_index(`sjgt_qc_prepare`.`result_in_one`,'|',8),'|',-(1)) AS `xdmjjpcbh`,'2898' AS `zssbbh`,1 AS `zssbzt`,NULL AS `sdlxysl`,`endoscope_disinfe_process`.`qxxdjdypt` AS `qxxdjdypt`,NULL AS `njccgbh`,date_format(substring_index(substring_index(`sjgt_qc_prepare`.`result_in_one`,'|',6),'|',-(1)),'%Y%m%d%H%i%s') AS `jlrqsj`,0 AS `scbz`,date_format(`endoscope_disinfe_process`.`sjgxsj`,'%Y%m%d%H%i%s') AS `sjgxsj` from (`endoscope_disinfe_process` left join `sjgt_qc_prepare` on((`endoscope_disinfe_process`.`njxdlsh` = `sjgt_qc_prepare`.`njxdlsh`))) ```
bigtran changed title from 2025-02-10 义乌妇幼 内镜 数据高铁问题 to 2025-02-10 义乌妇幼 内镜 数据高铁问题，数据更新时间造成对方查询问题 2025-02-10 17:57:46 +08:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
1-feature
2-bug
Something is not working
 3-enhancement
New feature
 4-document
5-bloody-version-diff
搞死人的版本差异
 6-now-commit-to-fix
下定决心解决，用行动证明，用结果证明
 duplicate
This issue or pull request already exists
 invalid
Something is wrong
 wontfix
This won't be fixed
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
bigtran (张大川) chenyingjie fanjc huangyanxue liuning panzs qilisong yanyanyan
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: temp-tickets/ectms-tickets-2025#42
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?