| skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/patrol/mapper/PatrolTaskMapper.xml | ●●●●● patch | view | raw | blame | history |
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/patrol/mapper/PatrolTaskMapper.xml
@@ -273,7 +273,7 @@ <!--行政区统计列表--> <select id="getRegionReportList" resultType="cn.gistack.sm.patrol.vo.PatrolTaskReport"> select * from ( select "ad_name","ad_grad","order_id", #{patrolTaskReport.startTime} AS startTime,#{patrolTaskReport.endTime} AS endTime, select "ad_name" AS adName ,"guid" AS adCode,"order_id", #{patrolTaskReport.startTime} AS startTime,#{patrolTaskReport.endTime} AS endTime, ( select count(*) from YWXT.SM_PATROL_TASK spt left join SJZT_MD."att_res_base" a on (spt.project_id = a."guid")
