阜宁运维项目
blame | 历史 | 补丁 | 提交 | 提交对比 | 忽略空白
liukangdong
2024-12-23 7c23d914bcce65cfa3450b119d3ffcf0556c6145 
 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::getPatrolNum)


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


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