From ea0698e0384aa60d3e2bad7da5efd7ea4fb8cf71 Mon Sep 17 00:00:00 2001
From: jiangping <jp@doumee.com>
Date: 星期四, 08 五月 2025 15:39:42 +0800
Subject: [PATCH] 最新版本541200007

---
 server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/thrid/BoardServiceImpl.java |   44 +++++++++++++++++++++++++-------------------
 1 files changed, 25 insertions(+), 19 deletions(-)

diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/thrid/BoardServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/thrid/BoardServiceImpl.java
index 17a669b..126b630 100644
--- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/thrid/BoardServiceImpl.java
+++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/thrid/BoardServiceImpl.java
@@ -1026,10 +1026,11 @@
         Date lastYear = DateUtil.addYearToDate(year,-1);//鍘诲勾
         List<PlatformJob>  monthNum = platformJobMapper.selectJoinList(PlatformJob.class,
                     new MPJLambdaWrapper<PlatformJob>()
-                        .selectAs(PlatformJob::getId,PlatformJob::getId)
-                        .select(PlatformJob::getType,PlatformJob::getType)
-                        .select(PlatformJob::getTotalNum,PlatformJob::getTotalNum)
-                        .select(PlatformJob::getStatus,PlatformJob::getStatus)
+                            .selectAs(PlatformJob::getId,PlatformJob::getId)
+                            .selectAs(PlatformJob::getTotalNum,PlatformJob::getTotalNum)
+                            .selectAs(PlatformJob::getDoneDate,PlatformJob::getDoneDate)
+                            .select(PlatformJob::getStatus,PlatformJob::getStatus)
+                            .select(PlatformJob::getType,PlatformJob::getType)
                         .eq(PlatformJob::getIsdeleted,Constants.ZERO)
                         .in(PlatformJob::getType,Constants.ONE,Constants.THREE)
                         .in(PlatformJob::getStatus,Constants.PlatformJobStatus.DONE.getKey(),
@@ -1225,15 +1226,19 @@
         }
         if(CollectionUtils.isNotEmpty(jobList)){
             //鑾峰彇浠诲姟鏁版嵁
-            List<String> jobDataList = list.stream().filter(i->Objects.nonNull(i.getDoneDate())).map(i->DateUtil.formatDate(i.getDoneDate(),"yyyy-MM-dd")).collect(Collectors.toList());
-            for (String jobDate:jobDataList) {
-                //杩囨护褰撳ぉ鐨勬暟鎹�
-                List<PlatformJob> platformJobList = list.stream().
-                        filter(i->jobDate.equals(DateUtil.formatDate(i.getDoneDate(),"yyyy-MM-dd"))).collect(Collectors.toList());
-                if(CollectionUtils.isNotEmpty(platformJobList)){
-                    //鑾峰彇浠婂ぉ鐨�
-                    r = r.add(this.getDayTotalRata(getSumTotalByList(platformJobList,type,null),jobDate));
+            List<String> jobDataList = jobList.stream().filter(i->Objects.nonNull(i.getDoneDate()))
+                    .map(i->DateUtil.formatDate(i.getDoneDate(),"yyyy-MM-dd")).collect(Collectors.toList());
+            if(CollectionUtils.isNotEmpty(jobDataList)){
+                for (String jobDate:jobDataList) {
+                    //杩囨护褰撳ぉ鐨勬暟鎹�
+                    List<PlatformJob> platformJobList = list.stream().
+                            filter(i->jobDate.equals(DateUtil.formatDate(i.getDoneDate(),"yyyy-MM-dd"))).collect(Collectors.toList());
+                    if(CollectionUtils.isNotEmpty(platformJobList)){
+                        //鑾峰彇浠婂ぉ鐨�
+                        r = r.add(this.getDayTotalRata(getSumTotalByList(platformJobList,type,null),jobDate));
+                    }
                 }
+                r = r.divide(new BigDecimal(Integer.toString(jobList.size())),2,BigDecimal.ROUND_HALF_UP);
             }
         }
         return r;
@@ -1245,7 +1250,7 @@
         //鏌ヨ浠婃棩鏈�鏃�/鏈�鏅氱殑浣滀笟鏁版嵁
         List<PlatformLog> platformLogList = platformLogMapper.selectList(new QueryWrapper<PlatformLog>()
                 .lambda()
-                .apply(" ( to_days(param1) =  '"+today+"' or to_days(param2) =  '"+today+"' ) ")
+                .apply(" (  DATE_FORMAT( param1 ,'%Y-%m-%d' ) =  '"+today+"' or DATE_FORMAT( param2 ,'%Y-%m-%d' )  =  '"+today+"' ) ")
         );
         if(totalAmount.compareTo(BigDecimal.ZERO)==0||CollectionUtils.isEmpty(platformLogList)){
             return BigDecimal.ZERO;
@@ -2779,17 +2784,18 @@
                     t =new WholeProvinceMapVO();
                     t.setMonthNum( Constants.formatBigdecimal0Float(model.getMonthOutboundQuantity()));
                     t.setYearNum( Constants.formatBigdecimal0Float(model.getYearOutboundQuantity()));
-
-                    if(Constants.UNIT_TYPE == 1) {
-                        //澶勭悊鍗曚綅鎴愨�滅鈥濓紝涓�绠�=5涓囨敮
-                        t.setMonthNum(Constants.formatBigdecimal(t.getMonthNum()).divide(new BigDecimal(5), 2, BigDecimal.ROUND_HALF_UP));
-                        t.setYearNum(Constants.formatBigdecimal(t.getYearNum()).divide(new BigDecimal(5), 2, BigDecimal.ROUND_HALF_UP));
-                    }
                     t.setProvinceCode(model.getToProvinceCode());
                     t.setProvinceName(model.getToProvinceName());
                     result.add(t);
                 }
             }
+            if(Constants.UNIT_TYPE == 1) {
+             for(WholeProvinceMapVO t : result){
+                    //澶勭悊鍗曚綅鎴愨�滅鈥濓紝涓�绠�=5涓囨敮
+                    t.setMonthNum(Constants.formatBigdecimal(t.getMonthNum()).divide(new BigDecimal(5), 2, BigDecimal.ROUND_HALF_UP));
+                    t.setYearNum(Constants.formatBigdecimal(t.getYearNum()).divide(new BigDecimal(5), 2, BigDecimal.ROUND_HALF_UP));
+                }
+            }
         }
         return result;
     }

--
Gitblit v1.9.3