yxm
2024-07-10 64efb56977af46db4218a7be59720e218c2554b2
施工上报-审批进度审核sql优化
1 files modified
3 ■■■■■ changed files
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/mapper/SgProgressReportMapper.xml 3 ●●●●● patch | view | raw | blame | history
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/mapper/SgProgressReportMapper.xml
@@ -68,6 +68,9 @@
        report.report_time,
        report.create_time,
        report.gx_progress,
        report.remark,
        DBMS_LOB.SUBSTR(report.images_urls),
        DBMS_LOB.SUBSTR(report.video_urls),
        de.device_name,
        de.device_type,
       <!-- userR.approval_status, -->