湖北水库项目
parent: 64efb569 | patch | commit | ignore whitespace
yxm
2024-07-10 b343796b84a371d1af18778af85f00e5f9bd096b 
施工上报-审批进度审核sql优化v0.1
1 files modified
4 ■■■■■ changed files
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/mapper/SgProgressReportMapper.xml 4 ●●●●● patch | view | raw | blame | history 
 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/mapper/SgProgressReportMapper.xml


@@ -69,8 +69,8 @@


        report.create_time,


        report.gx_progress,


        report.remark,


        DBMS_LOB.SUBSTR(report.images_urls),


        DBMS_LOB.SUBSTR(report.video_urls),


        DBMS_LOB.SUBSTR(report.images_urls) imagesUrls ,


        DBMS_LOB.SUBSTR(report.video_urls) videoUrls,


        de.device_name,


        de.device_type,


       <!-- userR.approval_status, -->