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 @@