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 d71b282..bd40879 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 @@ -37,99 +37,75 @@ NODE_LIMITTIME AS nodeLimittime from assess_view where 1=1 --- 开始日期 and DATE_FORMAT(CREATE_TIME,'%Y-%m-%d') >= #{condition.beginDate} --- 结束日期 and DATE_FORMAT(CREATE_TIME,'%Y-%m-%d') <= #{condition.endDate} --- 上报人员 and REPORT_SUPERVISOR_ID = #{condition.reportSupervisorId} --- 有效立案状态 and EB_CASE_STATE = #{condition.ebCaseState} --- 有效立案状态2,用于查询快速上报案卷 and (EB_CASE_STATE = #{condition.ebCaseState} or EB_CASE_STATE = #{condition.ebCaseState2}) --- 核实人员 and VERIFY_PERSON_ID = #{condition.verifyPersonId} --- 是否核实超时 and IS_VERIFY_OVERTIME = #{condition.isVerifyOvertime} --- 核查人员 and CHECK_PERSON_ID = #{condition.checkPersonId} --- 是否核查超时 and IS_CHECK_OVERTIME = #{condition.isCheckOvertime} --- 立案人员 and REGISTER_ID = #{condition.registerId} --- 是否立案超时 and IS_REGISTER_OVERTIME = #{condition.isRegisterOvertime} --- 发送核实人员 and DISTRIBUTE_VERIFY_PERSONID = #{condition.distributeVerifyPersonid} --- 是否发送核实超时 and IS_DISVERIFY_OVERTIME = #{condition.isDisverifyOvertime} --- 发送核查人员 and DISTRIBUTE_CHECK_PERSONID = #{condition.distributeCheckPersonid} --- 是否发送核查超时 and IS_DISCHECK_OVERTIME = #{condition.isDischeckOvertime} --- 结案人员 and CLOSE_CASE_PERSONID = #{condition.closeCasePersonid} --- 是否结案超时 and IS_CLOSE_OVERTIME = #{condition.isCloseOvertime} --- 派遣人员 and DISTRIBUTE_PERSON_ID = #{condition.distributePersonId} --- 是否派遣超时 and IS_DISTRIBUTE_OVERTIME = #{condition.isDistributeOvertime} --- 是否调整 and IS_ADJUST = #{condition.isAdjust} --- 处理审核人员 and PROCESS_AUDIT_PERSONID = #{condition.processAuditPersonid} --- 是否处理审核超时 and IS_PROCESSAUDIT_OVERTIME = #{condition.isProcessauditOvertime} --- 调整人员 and ADJUST_PERSON_ID = #{condition.adjustPersonId} --- 是否调整超时 and IS_ADJUST_OVERTIME = #{condition.isAdjustOvertime} @@ -140,99 +116,75 @@ select count(*) as num from assess_view where 1=1 - -- 开始日期 and DATE_FORMAT(CREATE_TIME,'%Y-%m-%d') >= #{countCondition.beginDate} - -- 结束日期 and DATE_FORMAT(CREATE_TIME,'%Y-%m-%d') <= #{countCondition.endDate} - -- 区域id and AREA_CODE = #{countCondition.areaId} - -- 案件来源 and SOURCE = #{countCondition.source} - -- 群众上报 and (SOURCE = 11 or SOURCE = 12) - -- 立案状态 and EB_CASE_STATE= #{countCondition.ebCaseState} - -- 处置状态 and PROCESS_STATE= #{countCondition.processState} - -- 是否处置超时 and IS_PROCESS_OVERTIME= #{countCondition.isProcessOvertime} - -- 已结案 and CLOSE_CASE_PERSONID is not null - -- 是否结案超时 and IS_CLOSE_OVERTIME = #{countCondition.isCloseOvertime}