|  |  | 
 |  |  |                 .selectAs(YwPatrolScheme::getCode,YwPatrolTask::getPlanCode) | 
 |  |  |                 .selectAs(YwPatrolScheme::getTitle,YwPatrolTask::getPlanTitle) | 
 |  |  |                 .selectAs(SystemUser::getRealname,YwPatrolTask::getUserName) | 
 |  |  |                 .select(" ( select count(1) from yw_patrol_task_record ytr where ytr.TASK_ID = t.id  and t.ISDELETED = 0  ) ",YwPatrolTask::getPatrolNum) | 
 |  |  |                 .select(" ( select count(1) from yw_patrol_task_record ytr where ytr.TASK_ID = t.id  and t.STATUS = 1 and t.ISDELETED = 0) ",YwPatrolTask::getFinishNum) | 
 |  |  |                 .select(" ( select count(1) from yw_patrol_task_record ytr where ytr.TASK_ID = t.id  and ytr.ISDELETED = 0  ) ",YwPatrolTask::getPatrolNum) | 
 |  |  |                 .select(" ( select count(1) from yw_patrol_task_record ytr where ytr.TASK_ID = t.id  and ytr.STATUS = 1 and ytr.ISDELETED = 0) ",YwPatrolTask::getFinishNum) | 
 |  |  |                 .leftJoin(SystemUser.class,SystemUser::getId,YwPatrolTask::getDealUserId) | 
 |  |  |                 .leftJoin(YwPatrolScheme.class,YwPatrolScheme::getId,YwPatrolTask::getSchemeId) | 
 |  |  |                 .eq(YwPatrolTask::getIsdeleted, Constants.ZERO) | 
 |  |  |                 .eq(YwPatrolTask::getId,id) | 
 |  |  |                 .last(" limit 1 ")) | 
 |  |  |         ; | 
 |  |  |         if(Constants.equalsInteger(ywPatrolTask.getStatus(),Constants.TWO) && | 
 |  |  |         if((Constants.equalsInteger(ywPatrolTask.getStatus(),Constants.ZERO) || Constants.equalsInteger(ywPatrolTask.getStatus(),Constants.ONE) ) && | 
 |  |  |                 ywPatrolTask.getEndDate().getTime()<System.currentTimeMillis()){ | 
 |  |  |             ywPatrolTask.setStatus(Constants.TWO); | 
 |  |  |         } | 
 |  |  | 
 |  |  |                 .selectAs(YwPatrolScheme::getCode,YwPatrolTask::getPlanCode) | 
 |  |  |                 .selectAs(YwPatrolScheme::getTitle,YwPatrolTask::getPlanTitle) | 
 |  |  |                 .selectAs(SystemUser::getRealname,YwPatrolTask::getUserName) | 
 |  |  |                 .select(" ( select count(1) from yw_patrol_task_record ytr where ytr.TASK_ID = t.id  and t.ISDELETED = 0  ) ",YwPatrolTask::getPatrolNum) | 
 |  |  |                 .select(" ( select count(1) from yw_patrol_task_record ytr where ytr.TASK_ID = t.id  and t.STATUS = 1 and t.ISDELETED = 0) ",YwPatrolTask::getFinishNum) | 
 |  |  |                 .select(" ( select count(1) from yw_patrol_task_record ytr where ytr.TASK_ID = t.id  and ytr.ISDELETED = 0  ) ",YwPatrolTask::getPatrolNum) | 
 |  |  |                 .select(" ( select count(1) from yw_patrol_task_record ytr where ytr.TASK_ID = t.id  and ytr.STATUS = 1 and ytr.ISDELETED = 0) ",YwPatrolTask::getFinishNum) | 
 |  |  |                 .leftJoin(SystemUser.class,SystemUser::getId,YwPatrolTask::getDealUserId) | 
 |  |  |                 .leftJoin(YwPatrolScheme.class,YwPatrolScheme::getId,YwPatrolTask::getSchemeId) | 
 |  |  |                 .eq(YwPatrolTask::getIsdeleted, Constants.ZERO) | 
 |  |  | 
 |  |  |         ; | 
 |  |  |         IPage<YwPatrolTask> iPage = ywPatrolTaskMapper.selectJoinPage(page,YwPatrolTask.class,queryWrapper); | 
 |  |  |         for (YwPatrolTask ywPatrolTask:iPage.getRecords()) { | 
 |  |  |             if(Constants.equalsInteger(ywPatrolTask.getStatus(),Constants.TWO) && | 
 |  |  |              ywPatrolTask.getEndDate().getTime()<System.currentTimeMillis()){ | 
 |  |  |             if((Constants.equalsInteger(ywPatrolTask.getStatus(),Constants.ZERO) || Constants.equalsInteger(ywPatrolTask.getStatus(),Constants.ONE) ) && | 
 |  |  |                     ywPatrolTask.getEndDate().getTime()<System.currentTimeMillis()){ | 
 |  |  |                 ywPatrolTask.setStatus(Constants.TWO); | 
 |  |  |             } | 
 |  |  |         } |