阜宁运维项目
blame | 历史 | 补丁 | 提交 | 提交对比 | 忽略空白
MrShi
2025-01-17 78d03fa48defaf77c2b533dc4616a210088ab49c 
 server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwPatrolTaskServiceImpl.java


@@ -86,8 +86,8 @@


                .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)


@@ -140,8 +140,8 @@


                .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)