| | |
| | | and t1.id in(${terms.unitIds}) |
| | | </if> |
| | | |
| | | <if test="terms.infoStatus != null and terms.infoStatus !=''"> |
| | | and t3.status = #{terms.infoStatus} |
| | | </if> |
| | | |
| | | </if> |
| | | </sql> |
| | | |
| | |
| | | count(case when (t2.node_id = 'ZJ_DSL' or t2.node_id = 'QJ_DSL' or t2.node_id = 'SJ_DSL' or t2.node_id = 'DSL') |
| | | and ((t2.overtime_status = 1 and t2.status = 2)) then t2.id end) as |
| | | slcs |
| | | count(case when (t2.node_id = 'BLFK') |
| | | and ((t2.overtime_status = 1 and t2.status = 2) or (sysdate > expire_time and t2.status = 1)) then t2.id end) as |
| | | blcs |
| | | </if> |
| | | <if test="terms.taskStatus != null and terms.taskStatus == 0"> |
| | | count(case when (t2.node_id = 'ZJ_DFP' or t2.node_id = 'QJ_DFP' or t2.node_id = 'SJ_DFP' or t2.node_id = 'DFP') |
| | |
| | | count(case when (t2.node_id = 'ZJ_DSL' or t2.node_id = 'QJ_DSL' or t2.node_id = 'SJ_DSL' or t2.node_id = 'DSL') |
| | | and ((sysdate > expire_time and t2.status = 1)) then t2.id end) as |
| | | slcs |
| | | count(case when (t2.node_id = 'BLFK') |
| | | and ((t2.overtime_status = 1 and t2.status = 2) or (sysdate > expire_time and t2.status = 1)) then t2.id end) as |
| | | blcs |
| | | </if> |
| | | <if test="terms.taskStatus == null or terms.taskStatus ==''"> |
| | | count(case when (t2.node_id = 'ZJ_DFP' or t2.node_id = 'QJ_DFP' or t2.node_id = 'SJ_DFP' or t2.node_id = 'DFP') |
| | |
| | | count(case when (t2.node_id = 'ZJ_DSL' or t2.node_id = 'QJ_DSL' or t2.node_id = 'SJ_DSL' or t2.node_id = 'DSL') |
| | | and ((t2.overtime_status = 1 and t2.status = 2) or (sysdate > expire_time and t2.status = 1)) then t2.id end) as |
| | | slcs |
| | | count(case when (t2.node_id = 'BLFK') |
| | | and ((t2.overtime_status = 1 and t2.status = 2) or (sysdate > expire_time and t2.status = 1)) then t2.id end) as |
| | | blcs |
| | | </if> |
| | | |
| | | |
| | |
| | | </if> |
| | | <if test="terms.unitIds != null and terms.unitIds !=''"> |
| | | and t1.id in(${terms.unitIds}) |
| | | </if> |
| | | <if test="terms.infoStatus != null and terms.infoStatus !=''"> |
| | | and t3.status = #{terms.infoStatus} |
| | | </if> |
| | | </sql> |
| | | |
| | |
| | | </if> |
| | | <if test="terms.unitIds != null and terms.unitIds !=''"> |
| | | and t1.id in(${terms.unitIds}) |
| | | </if> |
| | | <if test="terms.infoStatus != null and terms.infoStatus !=''"> |
| | | and t3.status = #{terms.infoStatus} |
| | | </if> |
| | | |
| | | </sql> |
| | |
| | | and (t2.close_time <![CDATA[ >= ]]> #{terms.closeStart} |
| | | and t2.close_time <![CDATA[ <= ]]> #{terms.closeEnd}) |
| | | </if> |
| | | <if test="terms.infoStatus != null and terms.infoStatus !=''"> |
| | | and t3.status = #{terms.infoStatus} |
| | | </if> |
| | | </if> |
| | | </sql> |
| | | |