diff --git a/casic-service-assess/src/main/java/com/casic/missiles/modular/assess/dao/mapping/AssessFactorMapper.xml b/casic-service-assess/src/main/java/com/casic/missiles/modular/assess/dao/mapping/AssessFactorMapper.xml
index bd40879..3c97f70 100644
--- a/casic-service-assess/src/main/java/com/casic/missiles/modular/assess/dao/mapping/AssessFactorMapper.xml
+++ b/casic-service-assess/src/main/java/com/casic/missiles/modular/assess/dao/mapping/AssessFactorMapper.xml
@@ -202,7 +202,7 @@
and DATE_FORMAT(CREATE_TIME,'%Y-%m-%d') <= #{countCondition.endDate}
- and AREA_CODE = #{countCondition.areaId}
+ and GRID_ID = #{countCondition.areaId}
and SOURCE = #{countCondition.source}
diff --git a/casic-service-assess/src/main/java/com/casic/missiles/modular/assess/dao/mapping/AssessFactorMapper.xml b/casic-service-assess/src/main/java/com/casic/missiles/modular/assess/dao/mapping/AssessFactorMapper.xml
index bd40879..3c97f70 100644
--- a/casic-service-assess/src/main/java/com/casic/missiles/modular/assess/dao/mapping/AssessFactorMapper.xml
+++ b/casic-service-assess/src/main/java/com/casic/missiles/modular/assess/dao/mapping/AssessFactorMapper.xml
@@ -202,7 +202,7 @@
and DATE_FORMAT(CREATE_TIME,'%Y-%m-%d') <= #{countCondition.endDate}
- and AREA_CODE = #{countCondition.areaId}
+ and GRID_ID = #{countCondition.areaId}
and SOURCE = #{countCondition.source}
diff --git a/casic-service-assess/src/main/java/com/casic/missiles/modular/assess/dao/mapping/DepartmentAssessMapper.xml b/casic-service-assess/src/main/java/com/casic/missiles/modular/assess/dao/mapping/DepartmentAssessMapper.xml
index 6b54419..db6ebbd 100644
--- a/casic-service-assess/src/main/java/com/casic/missiles/modular/assess/dao/mapping/DepartmentAssessMapper.xml
+++ b/casic-service-assess/src/main/java/com/casic/missiles/modular/assess/dao/mapping/DepartmentAssessMapper.xml
@@ -28,13 +28,14 @@
SELECT COUNT(*) AS CurrentCheckNum,s.FULLNAME AS departName FROM dcm_cws_case c
RIGHT JOIN sys_dept s ON s.ID=c.ONEDEPTID
RIGHT JOIN dcm_cws_status d ON d.ID=c.ID
+ RIGHT JOIN dcm_cws_process_detail p ON c.ID= p.ID
WHERE c.DEL_FlAG=0
AND s.status=0
- AND date_format(d.NODE_LIMITTIME,'%Y-%m-%d')>= #{beg}
+ AND date_format(p.DISTRIBUTE_TIME,'%Y-%m-%d')>= #{beg}
- AND date_format(d.NODE_LIMITTIME,'%Y-%m-%d') <= #{end}
+ AND date_format(p.DISTRIBUTE_TIME,'%Y-%m-%d') <= #{end}
AND d.PROCESS_STATE IN(1,2)
@@ -68,10 +69,11 @@
SELECT COUNT(*) AS lastCheckNum,s.FULLNAME AS departName FROM dcm_cws_case c
RIGHT JOIN sys_dept s ON s.ID=c.ONEDEPTID
RIGHT JOIN dcm_cws_status d ON d.ID=c.ID
+ left JOIN dcm_cws_process_detail p ON c.ID= p.ID
WHERE c.DEL_FlAG=0 AND d.PROCESS_STATE =1
AND s.status=0
- AND date_format(d.NODE_LIMITTIME,'%Y-%m-%d') < #{beg}
+ AND date_format(p.DISTRIBUTE_TIME,'%Y-%m-%d') < #{beg}
GROUP BY s.FULLNAME
@@ -85,10 +87,10 @@
AND P.CLOSE_CASE_PERSONID IS NULL
AND d.PROCESS_STATE IN(1,2)
- AND date_format(d.NODE_LIMITTIME,'%Y-%m-%d')>= #{beg}
+ AND date_format(p.DISTRIBUTE_TIME,'%Y-%m-%d')>= #{beg}
- AND date_format(d.NODE_LIMITTIME,'%Y-%m-%d') <= #{end}
+ AND date_format(p.DISTRIBUTE_TIME,'%Y-%m-%d') <= #{beg}
GROUP BY s.FULLNAME
@@ -104,10 +106,11 @@
RIGHT JOIN sys_dept s ON s.ID=c.ONEDEPTID
RIGHT JOIN dcm_cws_status d ON d.ID=c.ID
LEFT JOIN sys_dict sd ON sd.code=c.CASE_STATE
+ LEFT JOIN dcm_cws_process_detail p ON c.ID= p.ID
WHERE c.DEL_FlAG=0 AND d.PROCESS_STATE =1
AND sd.pid=91 AND s.status=0
- AND date_format(d.NODE_LIMITTIME,'%Y-%m-%d') < #{beg}
+ AND date_format(p.DISTRIBUTE_TIME,'%Y-%m-%d') < #{beg}
AND c.ONEDEPTID=#{depId}
@@ -126,12 +129,13 @@
RIGHT JOIN sys_dept s ON s.ID=c.ONEDEPTID
RIGHT JOIN dcm_cws_status d ON d.ID=c.ID
LEFT JOIN sys_dict sd ON sd.code=c.CASE_STATE
+ LEFT JOIN dcm_cws_process_detail p ON c.ID= p.ID
WHERE c.DEL_FlAG=0 AND sd.pid=91 AND s.status=0
- AND date_format(d.NODE_LIMITTIME,'%Y-%m-%d')>= #{beg}
+ AND date_format(p.DISTRIBUTE_TIME,'%Y-%m-%d')>= #{beg}
- AND date_format(d.NODE_LIMITTIME,'%Y-%m-%d') <= #{end}
+ AND date_format(p.DISTRIBUTE_TIME,'%Y-%m-%d') <= #{end}
AND d.PROCESS_STATE IN(1,2)
@@ -172,10 +176,10 @@
AND P.CLOSE_CASE_PERSONID IS NULL
AND d.PROCESS_STATE IN(1,2)
- AND date_format(d.NODE_LIMITTIME,'%Y-%m-%d')>= #{beg}
+ AND date_format(p.DISTRIBUTE_TIME,'%Y-%m-%d')>= #{beg}
- AND date_format(d.NODE_LIMITTIME,'%Y-%m-%d') <= #{end}
+ AND date_format(p.DISTRIBUTE_TIME,'%Y-%m-%d') <= #{end}
diff --git a/casic-service-assess/src/main/java/com/casic/missiles/modular/assess/dao/mapping/AssessFactorMapper.xml b/casic-service-assess/src/main/java/com/casic/missiles/modular/assess/dao/mapping/AssessFactorMapper.xml
index bd40879..3c97f70 100644
--- a/casic-service-assess/src/main/java/com/casic/missiles/modular/assess/dao/mapping/AssessFactorMapper.xml
+++ b/casic-service-assess/src/main/java/com/casic/missiles/modular/assess/dao/mapping/AssessFactorMapper.xml
@@ -202,7 +202,7 @@
and DATE_FORMAT(CREATE_TIME,'%Y-%m-%d') <= #{countCondition.endDate}
- and AREA_CODE = #{countCondition.areaId}
+ and GRID_ID = #{countCondition.areaId}
and SOURCE = #{countCondition.source}
diff --git a/casic-service-assess/src/main/java/com/casic/missiles/modular/assess/dao/mapping/DepartmentAssessMapper.xml b/casic-service-assess/src/main/java/com/casic/missiles/modular/assess/dao/mapping/DepartmentAssessMapper.xml
index 6b54419..db6ebbd 100644
--- a/casic-service-assess/src/main/java/com/casic/missiles/modular/assess/dao/mapping/DepartmentAssessMapper.xml
+++ b/casic-service-assess/src/main/java/com/casic/missiles/modular/assess/dao/mapping/DepartmentAssessMapper.xml
@@ -28,13 +28,14 @@
SELECT COUNT(*) AS CurrentCheckNum,s.FULLNAME AS departName FROM dcm_cws_case c
RIGHT JOIN sys_dept s ON s.ID=c.ONEDEPTID
RIGHT JOIN dcm_cws_status d ON d.ID=c.ID
+ RIGHT JOIN dcm_cws_process_detail p ON c.ID= p.ID
WHERE c.DEL_FlAG=0
AND s.status=0
- AND date_format(d.NODE_LIMITTIME,'%Y-%m-%d')>= #{beg}
+ AND date_format(p.DISTRIBUTE_TIME,'%Y-%m-%d')>= #{beg}
- AND date_format(d.NODE_LIMITTIME,'%Y-%m-%d') <= #{end}
+ AND date_format(p.DISTRIBUTE_TIME,'%Y-%m-%d') <= #{end}
AND d.PROCESS_STATE IN(1,2)
@@ -68,10 +69,11 @@
SELECT COUNT(*) AS lastCheckNum,s.FULLNAME AS departName FROM dcm_cws_case c
RIGHT JOIN sys_dept s ON s.ID=c.ONEDEPTID
RIGHT JOIN dcm_cws_status d ON d.ID=c.ID
+ left JOIN dcm_cws_process_detail p ON c.ID= p.ID
WHERE c.DEL_FlAG=0 AND d.PROCESS_STATE =1
AND s.status=0
- AND date_format(d.NODE_LIMITTIME,'%Y-%m-%d') < #{beg}
+ AND date_format(p.DISTRIBUTE_TIME,'%Y-%m-%d') < #{beg}
GROUP BY s.FULLNAME
@@ -85,10 +87,10 @@
AND P.CLOSE_CASE_PERSONID IS NULL
AND d.PROCESS_STATE IN(1,2)
- AND date_format(d.NODE_LIMITTIME,'%Y-%m-%d')>= #{beg}
+ AND date_format(p.DISTRIBUTE_TIME,'%Y-%m-%d')>= #{beg}
- AND date_format(d.NODE_LIMITTIME,'%Y-%m-%d') <= #{end}
+ AND date_format(p.DISTRIBUTE_TIME,'%Y-%m-%d') <= #{beg}
GROUP BY s.FULLNAME
@@ -104,10 +106,11 @@
RIGHT JOIN sys_dept s ON s.ID=c.ONEDEPTID
RIGHT JOIN dcm_cws_status d ON d.ID=c.ID
LEFT JOIN sys_dict sd ON sd.code=c.CASE_STATE
+ LEFT JOIN dcm_cws_process_detail p ON c.ID= p.ID
WHERE c.DEL_FlAG=0 AND d.PROCESS_STATE =1
AND sd.pid=91 AND s.status=0
- AND date_format(d.NODE_LIMITTIME,'%Y-%m-%d') < #{beg}
+ AND date_format(p.DISTRIBUTE_TIME,'%Y-%m-%d') < #{beg}
AND c.ONEDEPTID=#{depId}
@@ -126,12 +129,13 @@
RIGHT JOIN sys_dept s ON s.ID=c.ONEDEPTID
RIGHT JOIN dcm_cws_status d ON d.ID=c.ID
LEFT JOIN sys_dict sd ON sd.code=c.CASE_STATE
+ LEFT JOIN dcm_cws_process_detail p ON c.ID= p.ID
WHERE c.DEL_FlAG=0 AND sd.pid=91 AND s.status=0
- AND date_format(d.NODE_LIMITTIME,'%Y-%m-%d')>= #{beg}
+ AND date_format(p.DISTRIBUTE_TIME,'%Y-%m-%d')>= #{beg}
- AND date_format(d.NODE_LIMITTIME,'%Y-%m-%d') <= #{end}
+ AND date_format(p.DISTRIBUTE_TIME,'%Y-%m-%d') <= #{end}
AND d.PROCESS_STATE IN(1,2)
@@ -172,10 +176,10 @@
AND P.CLOSE_CASE_PERSONID IS NULL
AND d.PROCESS_STATE IN(1,2)
- AND date_format(d.NODE_LIMITTIME,'%Y-%m-%d')>= #{beg}
+ AND date_format(p.DISTRIBUTE_TIME,'%Y-%m-%d')>= #{beg}
- AND date_format(d.NODE_LIMITTIME,'%Y-%m-%d') <= #{end}
+ AND date_format(p.DISTRIBUTE_TIME,'%Y-%m-%d') <= #{end}
diff --git a/casic-service-cws/casic-cws-flow/src/main/java/com/casic/missiles/modular/flowable/service/impl/CaseFlowServiceImpl.java b/casic-service-cws/casic-cws-flow/src/main/java/com/casic/missiles/modular/flowable/service/impl/CaseFlowServiceImpl.java
index 1e83cde..dc3387c 100644
--- a/casic-service-cws/casic-cws-flow/src/main/java/com/casic/missiles/modular/flowable/service/impl/CaseFlowServiceImpl.java
+++ b/casic-service-cws/casic-cws-flow/src/main/java/com/casic/missiles/modular/flowable/service/impl/CaseFlowServiceImpl.java
@@ -147,17 +147,17 @@
int count = 0;
FlowNextnode autoNode = null;
for (FlowNextnode nextnode : flowNextnodes) {
- if (Const.ONE.equals(nextnode.getIsAuto())) {
- count++;
- autoNode = nextnode;
- }
+// if (Const.ONE.equals(nextnode.getIsAuto())) {
+// count++;
+// autoNode = nextnode;
+// }
}
if (count == 1) {
//执行自动流转 流程处理handler中会进行推送处理
dto.setCurrState(autoNode.getState());
dto.setChangeState(autoNode.getNextState());
if (ToolUtil.isEmpty(dto.getIsPush())) {
- dto.setIsPush(autoNode.getIsPush());
+// dto.setIsPush(autoNode.getIsPush());
}
this.completeCaseTask(dto);
}