From c5a0ff2661fe362dddbe88c6a28d19c48c24c39b Mon Sep 17 00:00:00 2001
From: jiangping <jp@doumee.com>
Date: 星期一, 21 十月 2024 20:39:32 +0800
Subject: [PATCH] 最新版本541200007

---
 server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/PlatformGroupServiceImpl.java |   29 +++++++++++++++++++++++------
 1 files changed, 23 insertions(+), 6 deletions(-)

diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/PlatformGroupServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/PlatformGroupServiceImpl.java
index 5a4765b..6f5dc78 100644
--- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/PlatformGroupServiceImpl.java
+++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/PlatformGroupServiceImpl.java
@@ -255,10 +255,12 @@
                             .select(" ( select pl.CREATE_DATE from platform_log pl where t.id = pl.obj_id and pl.OBJ_TYPE = 5 order by pl.CREATE_DATE desc  limit 1  ) as newStartDate  ")
                             .select(" ( select pl.CREATE_DATE from platform_log pl where t.id = pl.obj_id and pl.OBJ_TYPE = 4 order by pl.CREATE_DATE desc  limit 1  ) as newCallDate  ")
                             .selectAs(PlatformWmsJob::getCarrierName,PlatformJob::getCarrierName)
-                            .leftJoin(PlatformWmsJob.class,PlatformWmsJob::getCarryBillCode,PlatformJob::getBillCode)
+                            .selectAs(PlatformBooks::getId,PlatformJob::getBookId)
                             .leftJoin(Platform.class,Platform::getId,PlatformJob::getPlatformId)
+                            .leftJoin(PlatformWmsJob.class,PlatformWmsJob::getCarryBillCode,PlatformJob::getBillCode)
+                            .leftJoin(PlatformBooks.class,PlatformBooks::getJobId,PlatformJob::getId)
                             .eq(PlatformJob::getIsdeleted,Constants.ZERO)
-                            .eq(Platform::getIsdeleted,Constants.ZERO)
+                            .apply(" ( t1.isdeleted = 0 or t.PLATFORM_ID is null  ) ")
                             .in(PlatformJob::getStatus,
                                     Constants.PlatformJobStatus.WAIT_CALL.getKey(),
                                     Constants.PlatformJobStatus.IN_WAIT.getKey(),
@@ -302,19 +304,34 @@
                 platformWorkVO.setCallNum(
                         platformJobs.stream().filter(i->Constants.equalsInteger(i.getPlatformId(),platform.getId())  && Constants.equalsInteger(i.getStatus(),Constants.PlatformJobStatus.CALLED.getKey())).collect(Collectors.toList()).size()
                 );
+                System.out.printf(String.valueOf(platformJobs.stream().filter(i->
+                        Constants.equalsInteger(i.getStatus(),Constants.PlatformJobStatus.WAIT_CALL.getKey())
+                ).collect(Collectors.toList()).size())
+                );
+                System.out.printf(String.valueOf(platformJobList.stream().filter(i->
+                                Constants.equalsInteger(i.getStatus(),Constants.PlatformJobStatus.IN_WAIT.getKey()) ||
+                                        ( Constants.equalsInteger(platform.getId(),i.getPlatformId()) &&
+                                                Constants.equalsInteger(i.getStatus(),Constants.PlatformJobStatus.TRANSFERING.getKey())
+                                        )
+                        ).collect(Collectors.toList()).size())
+                );
 
                 platformWorkVO.setWaitNum(
+
                         platformJobs.stream().filter(i->
                                  Constants.equalsInteger(i.getStatus(),Constants.PlatformJobStatus.WAIT_CALL.getKey())
                         ).collect(Collectors.toList()).size()
                         +
-                        platformJobList.stream().filter(i->Constants.equalsInteger(platform.getId(),i.getPlatformId())
-                                && (Constants.equalsInteger(i.getStatus(),Constants.PlatformJobStatus.IN_WAIT.getKey()) ||  Constants.equalsInteger(i.getStatus(),Constants.PlatformJobStatus.TRANSFERING.getKey())
+                        platformJobList.stream().filter(i->
+                                (  Constants.equalsInteger(i.getStatus(),Constants.PlatformJobStatus.IN_WAIT.getKey()) && Constants.equalsInteger(i.getPlatformGroupId(),platform.getGroupId()) )||
+                                 ( Constants.equalsInteger(platform.getId(),i.getPlatformId()) &&
+                                 Constants.equalsInteger(i.getStatus(),Constants.PlatformJobStatus.TRANSFERING.getKey())
                                )
                         ).collect(Collectors.toList()).size()
                 );
                 platformWorkVO.setExceptionNum(
-                        platformJobs.stream().filter(i->Constants.equalsInteger(i.getStatus(),Constants.PlatformJobStatus.EXCEPTION.getKey())).collect(Collectors.toList()).size()
+                        platformJobs.stream().filter(i->Constants.equalsInteger(platform.getId(),i.getPlatformId())
+                                && Constants.equalsInteger(i.getStatus(),Constants.PlatformJobStatus.EXCEPTION.getKey())).collect(Collectors.toList()).size()
                 );
                 platformWorkVO.setPlatformJobList(platformJobs.stream().filter(
                         i->Constants.equalsInteger(platform.getId(),i.getPlatformId()) && !Constants.equalsInteger(i.getStatus(),Constants.PlatformJobStatus.WAIT_CALL.getKey())
@@ -341,7 +358,7 @@
         platformGroupWorkVO.setWaitNum(platformJobJoinMapper.selectJoinCount(new MPJLambdaWrapper<PlatformJob>()
                         .leftJoin(Platform.class,Platform::getId,PlatformJob::getPlatformId)
                         .eq(PlatformJob::getIsdeleted,Constants.ZERO)
-                        .eq(Platform::getIsdeleted,Constants.ZERO)
+                        .apply(" ( t1.isdeleted = 0 or t.PLATFORM_ID is null  ) ")
                         .eq(PlatformJob::getPlatformGroupId,platformGroupId)
                         .and( i->i.eq(PlatformJob::getStatus,Constants.PlatformJobStatus.WAIT_CALL.getKey()).or()
                                         .eq(PlatformJob::getStatus,Constants.PlatformJobStatus.IN_WAIT.getKey()).or()

--
Gitblit v1.9.3