From 7b51c9e1abc198a501f7858599da9c116130fd6f Mon Sep 17 00:00:00 2001
From: jiangping <jp@doumee.com>
Date: 星期四, 27 三月 2025 16:47:51 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master'

---
 server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/PlatformJobServiceImpl.java |   40 ++++++++++++-
 server/visits/dmvisit_service/src/main/java/com/doumee/service/business/PlatformJobService.java          |    1 
 server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/VisitReasonServiceImpl.java |    1 
 server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/admin/PlatformJobCloudController.java         |   10 +++
 server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/thrid/BoardServiceImpl.java |   28 +++++----
 server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/VisitsServiceImpl.java      |   39 ++++++++----
 server/visits/dmvisit_service/src/main/java/com/doumee/service/business/VisitsService.java               |    1 
 server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/web/VisitorWebController.java                 |   16 +++++
 server/visits/dmvisit_service/src/main/java/com/doumee/core/wx/wxPlat/WxPlatNotice.java                  |   38 ++++++++++++
 9 files changed, 141 insertions(+), 33 deletions(-)

diff --git a/server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/admin/PlatformJobCloudController.java b/server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/admin/PlatformJobCloudController.java
index 0732768..4dc5a74 100644
--- a/server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/admin/PlatformJobCloudController.java
+++ b/server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/admin/PlatformJobCloudController.java
@@ -19,6 +19,7 @@
 import com.mchange.v2.beans.BeansUtils;
 import io.swagger.annotations.Api;
 import io.swagger.annotations.ApiOperation;
+import io.swagger.models.auth.In;
 import org.springframework.beans.BeanUtils;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.web.bind.annotation.*;
@@ -152,4 +153,13 @@
         platformJobService.signIn(signInDTO);
         return ApiResponse.success("鎿嶄綔鎴愬姛");
     }
+
+
+
+    @ApiOperation("鎵嬪姩瀹屾垚浣滀笟")
+    @PostMapping("/dealJobFinish")
+    public ApiResponse  dealJobFinish (@RequestBody List<Integer> list, @RequestHeader(Constants.HEADER_USER_TOKEN) String token){
+        platformJobService.dealJobFinish(list);
+        return ApiResponse.success("鎿嶄綔鎴愬姛");
+    }
 }
diff --git a/server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/web/VisitorWebController.java b/server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/web/VisitorWebController.java
index 2323e35..e99d61c 100644
--- a/server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/web/VisitorWebController.java
+++ b/server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/web/VisitorWebController.java
@@ -111,5 +111,21 @@
     }
 
 
+    /**
+     * 2025-3-25 14:14:34  鍔犲叆鍙栨秷棰勭害 寰呭鎵广�佸鎵逛腑銆佸凡瀹℃壒
+     * @param visitId
+     * @return
+     */
+    @ApiOperation("鍙栨秷棰勭害")
+    @GetMapping("/visitsSelfCancel")
+    public ApiResponse visitsSelfCancel(@RequestParam Integer visitId,@RequestParam Integer memberId){
+        if(Objects.isNull(memberId)){
+            memberId = Constants.ZERO;
+        }
+        visitsService.visitsSelfCancel(visitId,memberId);
+        return ApiResponse.success(null);
+    }
+
+
 
 }
diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/core/wx/wxPlat/WxPlatNotice.java b/server/visits/dmvisit_service/src/main/java/com/doumee/core/wx/wxPlat/WxPlatNotice.java
index 408a033..fdf6301 100644
--- a/server/visits/dmvisit_service/src/main/java/com/doumee/core/wx/wxPlat/WxPlatNotice.java
+++ b/server/visits/dmvisit_service/src/main/java/com/doumee/core/wx/wxPlat/WxPlatNotice.java
@@ -627,7 +627,7 @@
                 }
             }
         }catch (Exception e){
-
+            e.printStackTrace();
         }
     }
 
@@ -665,7 +665,7 @@
                 thing2.put("value",platformJob.getDriverName());
                 //绛惧埌鏃堕棿
                 Map<String, Object> time5 = new HashMap<String,Object>();
-                time5.put("value", DateUtil.getFomartDate(platformJob.getSignDate(),"yyyy骞碝M鏈坉d鏃� HH:mm:ss"));
+                time5.put("value", DateUtil.getFomartDate(new Date(),"yyyy骞碝M鏈坉d鏃� HH:mm:ss"));
 
                 dataMap.put("car_number1",car_number1);
                 dataMap.put("thing2",thing2);
@@ -690,6 +690,40 @@
         }
     }
 
+
+    public static void main(String[] args) {
+        String postUrL = "https://api.weixin.qq.com/cgi-bin/message/template/send?access_token=90_8_a3QDclSc8HTcbgXhSVnijiQdRf4dG5wme29riDIyt3UIi7FpZ_HJyqyEIY-_e2A29jH2fLBKgtuBKtq-cy7DteFg5l9EawoxAwiRis8BMnEl-u01ITtCUVU90XCIjADASXD";
+        //鏁翠綋鍙傛暟map
+        Map<String, Object> paramMap = new HashMap<String, Object>();
+        //娑堟伅涓婚鏄剧ず鐩稿叧map
+        Map<String, Object> dataMap = new HashMap<String, Object>();
+        //杞︾墝鍙�
+        Map<String, Object> car_number1 = new HashMap<String,Object>();
+        car_number1.put("value","鐨朅12345");
+        //鍙告満濮撳悕
+        Map<String, Object> thing2 = new HashMap<String,Object>();
+        thing2.put("value","灏忛樋姝�");
+        //绛惧埌鏃堕棿
+        Map<String, Object> time5 = new HashMap<String,Object>();
+        time5.put("value", DateUtil.getFomartDate(new Date(),"yyyy骞碝M鏈坉d鏃� HH:mm:ss"));
+
+        dataMap.put("car_number1",car_number1);
+        dataMap.put("thing2",thing2);
+        dataMap.put("time5",time5);
+        paramMap.clear();
+        paramMap.put("template_id", "ZYhHg5eJJim0LR3FLVaqKcVqW3p8GQk8qrTO40ffHXI");
+        paramMap.put("touser", "ovmre6RUJJZCDtCyLxWYKSMgt7u8");
+        paramMap.put("data", dataMap);
+        String response = HttpsUtil.postJson(postUrL, JSONObject.toJSONString(paramMap));
+        log.error("路==++--路鎺ㄩ�佸井淇℃ā鏉夸俊鎭唴瀹癸細{}", JSONObject.toJSONString(paramMap));
+        if(StringUtils.isBlank(response)){
+            log.error("路==++--路鎺ㄩ�佸井淇℃ā鏉夸俊鎭細{}路--++==路", "澶辫触");
+        }else{
+            JSONObject json = JSONObject.parseObject(response);
+            log.error("路==++--路鎺ㄩ�佸井淇℃ā鏉夸俊鎭細{}路--++==路", Constants.equalsInteger(json.getInteger("errcode"),Constants.ZERO)?"鎴愬姛":"澶辫触"+json.getString("errmsg"));
+        }
+    }
+
     public void  sendUnFinishNotice(WxNoticeConfigMapper wxNoticeConfigMapper,Integer unFinishNum,String objCode,String token,
                                            List<String> openIds){
         try{
diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/PlatformJobService.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/PlatformJobService.java
index 9faa572..6b2b9b2 100644
--- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/PlatformJobService.java
+++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/PlatformJobService.java
@@ -256,4 +256,5 @@
      */
     void sendUnFinishNotice();
 
+    void dealJobFinish(List<Integer> jobIdList);
 }
diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/VisitsService.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/VisitsService.java
index b07700a..945014b 100644
--- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/VisitsService.java
+++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/VisitsService.java
@@ -145,6 +145,7 @@
      * 澶勭悊寰呭鏍搞�佸鏍镐腑銆佸凡瀹℃牳鐨勬暟鎹彇娑堜笟鍔�
      * 2025骞�3鏈�25鏃�14:10:10
       */
+    void  visitsSelfCancel(Integer visitId,Integer memberId);
     void  visitsCancel(Integer visitId,LoginUserInfo loginUserInfo);
     void resetPassword(ResetPasswordDTO resetPasswordDTO);
 
diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/PlatformJobServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/PlatformJobServiceImpl.java
index 494e10b..62f6a40 100644
--- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/PlatformJobServiceImpl.java
+++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/PlatformJobServiceImpl.java
@@ -688,10 +688,13 @@
         savePlatformLog(Constants.PlatformJobLogType.SIGN.getKey(),oldPlatformJob,platformJob,
                 Constants.PlatformJobLogType.SIGN.getInfo());
         //绛惧埌寰俊閫氱煡 2025骞�3鏈�26鏃�14:25:00
-        if(!Constants.equalsInteger(platformJob.getSingType(),Constants.TWO)&&StringUtils.isNotBlank(platformGroup.getSignInNoticeUsers())){
+        logger.info("绛惧埌寰俊閫氱煡=========================>寮�濮�====绛惧埌绫诲瀷=>"+signInDTO.getSignType()+"===>浜哄憳涓婚敭=>"+platformGroup.getSignInNoticeUsers());
+        if(!Constants.equalsInteger(signInDTO.getSignType(),Constants.TWO)&&
+                StringUtils.isNotBlank(platformGroup.getSignInNoticeUsers())){
+            logger.info("绛惧埌寰俊閫氱煡=========================>杩涘叆");
             List<SystemUser> systemUserList = systemUserMapper.selectList(new QueryWrapper<SystemUser>().lambda()
                     .eq(SystemUser::getDeleted,Constants.ZERO).eq(SystemUser::getStatus,Constants.ZERO).isNotNull(SystemUser::getOpenid)
-                    .in(SystemUser::getId,Arrays.asList(platformGroup.getSignInNoticeUsers().split(",")))
+                    .in(SystemUser::getMemberId,Arrays.asList(platformGroup.getSignInNoticeUsers().split(",")))
             );
             if (com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(systemUserList)) {
                 WxPlatNotice wxPlatNotice = new WxPlatNotice();
@@ -702,6 +705,7 @@
                 );
             }
         }
+        logger.info("绛惧埌寰俊閫氱煡=========================>缁撴潫");
     }
 
 
@@ -734,7 +738,7 @@
                     if(Objects.nonNull(platformGroup)){
                         List<SystemUser> systemUserList = systemUserMapper.selectList(new QueryWrapper<SystemUser>().lambda()
                                 .eq(SystemUser::getDeleted,Constants.ZERO).eq(SystemUser::getStatus,Constants.ZERO).isNotNull(SystemUser::getOpenid)
-                                .in(SystemUser::getId,Arrays.asList(platformGroup.getUnFinishNoticeUsers().split(",")))
+                                .in(SystemUser::getMemberId,Arrays.asList(platformGroup.getUnFinishNoticeUsers().split(",")))
                         );
                         if (com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(systemUserList)) {
                             WxPlatNotice wxPlatNotice = new WxPlatNotice();
@@ -1652,7 +1656,7 @@
         platformJob.setPlatformName(platform.getName());
         this.broadcastAndLEed(platformJob,
                 //Constants.PlatformLedContent.DONE.getInfo(),
-                Constants.PlatformLedContent.IDEL_CONTNET.getInfo(),
+                StringUtils.isBlank(platform.getLedContent())?Constants.PlatformLedContent.IDEL_CONTNET.getInfo():platform.getLedContent(),
                 Constants.PlatformBroadcastContent.DONE.getInfo());
         return platformJob;
     }
@@ -2426,5 +2430,33 @@
     }
 
 
+    /**
+     * 鎵嬪姩瀹屾垚浣滀笟
+     * @param jobIdList
+     */
+    @Override
+    public void dealJobFinish(List<Integer> jobIdList){
+        if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(jobIdList)){
+            List<PlatformJob> platformJobList = platformJobMapper.selectList(new QueryWrapper<PlatformJob>().lambda()
+                    .eq(PlatformJob::getIsdeleted,Constants.ZERO)
+                    .in(PlatformJob::getStatus,Constants.PlatformJobStatus.WAIT_CONFIRM,Constants.PlatformJobStatus.WART_SIGN_IN)
+                    .in(PlatformJob::getId,jobIdList)
+            );
+            if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(platformJobList)){
+
+                platformJobMapper.update(null,new UpdateWrapper<PlatformJob>().lambda()
+                        .set(PlatformJob::getStatus,Constants.PlatformJobStatus.DONE.getKey())
+                        .set(PlatformJob::getDoneDate,new Date())
+                        .in(PlatformJob::getStatus,Constants.PlatformJobStatus.WAIT_CONFIRM,Constants.PlatformJobStatus.WART_SIGN_IN)
+                        .eq(PlatformJob::getIsdeleted,Constants.ZERO)
+                        .in(PlatformJob::getId,platformJobList.stream().map(i->i.getId()).collect(Collectors.toList())));
+
+            }
+
+        }
+
+
+    }
+
 
 }
diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/VisitReasonServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/VisitReasonServiceImpl.java
index 94f76ad..ce342e3 100644
--- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/VisitReasonServiceImpl.java
+++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/VisitReasonServiceImpl.java
@@ -99,6 +99,7 @@
     public List<VisitReason> findList(VisitReason visitReason) {
         QueryWrapper<VisitReason> wrapper = new QueryWrapper<>(visitReason);
         wrapper.eq("isdeleted",Constants.ZERO);
+        wrapper.orderByAsc("sortnum");
         return visitReasonMapper.selectList(wrapper);
     }
   
diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/VisitsServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/VisitsServiceImpl.java
index 6360447..bb5e871 100644
--- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/VisitsServiceImpl.java
+++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/VisitsServiceImpl.java
@@ -1574,28 +1574,41 @@
     }
 
 
-
-    /**
-     * 澶勭悊寰呭鏍搞�佸鏍镐腑銆佸凡瀹℃牳鐨勬暟鎹彇娑堜笟鍔�
-     * 2025骞�3鏈�25鏃�14:10:10
-     */
     @Override
-    public void  visitsCancel(Integer visitId,LoginUserInfo loginUserInfo){
+    public void  visitsSelfCancel(Integer visitId,Integer memberId){
         Visits visits = visitsMapper.selectById(visitId);
         if(Objects.isNull(visits)){
             throw new BusinessException(ResponseStatus.DATA_EMPTY);
         }
-        if(!(Constants.equalsInteger(loginUserInfo.getMemberId(),visits.getMemberId()) ||
-                Constants.equalsInteger(loginUserInfo.getMemberId(),visits.getCreateMemberId()) ||
-                ( CollectionUtils.isNotEmpty(loginUserInfo.getPermissions()) &&
-            loginUserInfo.getPermissions().stream().filter(i->i.equals("business:visits:cancel")).collect(Collectors.toList()).size()>0))){
+        if(!(Constants.equalsInteger(memberId,visits.getMemberId()))){
             throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"鏃犳鎿嶄綔鏉冮檺");
         }
+        this.visitsCancelBiz(visits);
+    }
+
+    @Override
+    public void  visitsCancel(Integer visitId,LoginUserInfo loginUserInfo) {
+        Visits visits = visitsMapper.selectById(visitId);
+        if (Objects.isNull(visits)) {
+            throw new BusinessException(ResponseStatus.DATA_EMPTY);
+        }
+        if(!(
+                 CollectionUtils.isNotEmpty(loginUserInfo.getPermissions()) &&
+                        loginUserInfo.getPermissions().stream().filter(i->i.equals("business:visits:cancel")).collect(Collectors.toList()).size()>0)){
+            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"鏃犳鎿嶄綔鏉冮檺");
+        }
+        this.visitsCancelBiz(visits);
+    }
+    /**
+     * 澶勭悊寰呭鏍搞�佸鏍镐腑銆佸凡瀹℃牳鐨勬暟鎹彇娑堜笟鍔�
+     * 2025骞�3鏈�25鏃�14:10:10
+     */
+    public void  visitsCancelBiz(Visits visits){ 
         UpdateWrapper<Visits> updateWrapper = new UpdateWrapper();
         updateWrapper.lambda().set(Visits::getStatus,Constants.VisitStatus.cancel)
                 .set(Visits::getEditDate,DateUtil.getCurrDateTime())
-                .set(Visits::getEditor,loginUserInfo.getId())
-                .eq(Visits::getId,visitId);
+                .set(Visits::getEditor,visits.getEditor())
+                .eq(Visits::getId,visits.getId());
         //璁垮鎶ュ
         if(Constants.equalsInteger(visits.getType(),Constants.TWO)){
             if(!(Constants.equalsInteger(visits.getStatus(),Constants.VisitStatus.waitCheck)||Constants.equalsInteger(visits.getStatus(),Constants.VisitStatus.submitCheck)
@@ -1670,7 +1683,6 @@
                             .set(Notices::getInfo,"鎵嬪姩鍙栨秷")
 //                        .set(Notices::getStatus,Constants.ONE)
                             .set(Notices::getParam2,Constants.FOUR)//宸插彇娑�
-                            .eq(Notices::getIsdeleted,Constants.ZERO)
                             .eq(Notices::getStatus,Constants.ZERO)
                             .eq(Notices::getParam2,Constants.ZERO)//寰呭鐞�
                             .eq(Notices::getObjId,visits.getId())
@@ -2076,7 +2088,6 @@
                             .set(Notices::getEditDate,new Date())
                             .set(Notices::getInfo,info)
                             .set(Notices::getParam2,Constants.FOUR)//宸插彇娑�
-                            .eq(Notices::getIsdeleted,Constants.ZERO)
                             .eq(Notices::getStatus,Constants.ZERO)
                             .eq(Notices::getParam2,Constants.ZERO)//寰呭鐞�
                             .eq(Notices::getObjId,objId)
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 c9d09d6..afa0558 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
@@ -151,7 +151,7 @@
                 List<PlatformJob> jobs = platformJobMapper.selectList (new MPJLambdaWrapper<PlatformJob>()
                         .select(PlatformJob::getTotalNum)
                         .eq(PlatformJob::getIsdeleted,Constants.ZERO)
-                        .eq(PlatformJob::getOrigin,Constants.ZERO)
+                                .apply(" ( origin = 0 or origin is null)  ")
                         .eq(PlatformJob::getPlatformGroupId,platformGroupId)
                         .apply("to_days(done_date) = to_days(now())")
                         .in(PlatformJob::getStatus, Constants.PlatformJobStatus.DONE.getKey()
@@ -962,6 +962,18 @@
                                 Constants.PlatformJobStatus.LEAVED.getKey(),
                                 Constants.PlatformJobStatus.AUTHED_LEAVE.getKey())
                         .apply("year(done_date) = year('"+DateUtil.getPlusTime2(month)+"') and month(done_date) = month('"+DateUtil.getPlusTime2(month)+"') "));
+
+        List<PlatformJob>  yearNum = platformJobMapper.selectJoinList(PlatformJob.class,
+                new MPJLambdaWrapper<PlatformJob>()
+                        .selectAs(PlatformJob::getId,PlatformJob::getId)
+                        .selectAs(PlatformJob::getTotalNum,PlatformJob::getTotalNum)
+                        .select(PlatformJob::getStatus,PlatformJob::getStatus)
+                        .select(PlatformJob::getType,PlatformJob::getType)
+//                        .selectCount(PlatformJob::getPlatformId,PlatformJob::getCountum)
+                        .eq(PlatformJob::getIsdeleted,Constants.ZERO)
+                        .in(PlatformJob::getType,Constants.ONE,Constants.THREE)
+                        .in(PlatformJob::getStatus,Constants.PlatformJobStatus.DONE.getKey(),Constants.PlatformJobStatus.LEAVED.getKey(),Constants.PlatformJobStatus.AUTHED_LEAVE.getKey())
+                        .apply("year(done_date) = year('"+DateUtil.getPlusTime2(year)+"')   and done_date<=  now()  "));
         List<PlatformJob>  monthLastNum = platformJobMapper.selectJoinList(PlatformJob.class,
                 new MPJLambdaWrapper<PlatformJob>()
                         .selectAs(PlatformJob::getId,PlatformJob::getId)
@@ -974,17 +986,7 @@
                         .in(PlatformJob::getStatus,Constants.PlatformJobStatus.DONE.getKey(),Constants.PlatformJobStatus.LEAVED.getKey(),Constants.PlatformJobStatus.AUTHED_LEAVE.getKey())
                         .apply("year(done_date) = year('"+DateUtil.getPlusTime2(lastMonth)+"') and month(done_date) = month('"+DateUtil.getPlusTime2(lastMonth)+"') and  done_date<= '"
                                 +DateUtil.getPlusTime2(lastMonth)+"'"));
-        List<PlatformJob>  yearNum = platformJobMapper.selectJoinList(PlatformJob.class,
-                new MPJLambdaWrapper<PlatformJob>()
-                        .selectAs(PlatformJob::getId,PlatformJob::getId)
-                        .selectAs(PlatformJob::getTotalNum,PlatformJob::getTotalNum)
-                        .select(PlatformJob::getStatus,PlatformJob::getStatus)
-                        .select(PlatformJob::getType,PlatformJob::getType)
-//                        .selectCount(PlatformJob::getPlatformId,PlatformJob::getCountum)
-                        .eq(PlatformJob::getIsdeleted,Constants.ZERO)
-                        .in(PlatformJob::getType,Constants.ONE,Constants.THREE)
-                        .in(PlatformJob::getStatus,Constants.PlatformJobStatus.DONE.getKey(),Constants.PlatformJobStatus.LEAVED.getKey(),Constants.PlatformJobStatus.AUTHED_LEAVE.getKey())
-                        .apply("year(done_date) = year('"+DateUtil.getPlusTime2(year)+"')   and done_date<= '"+DateUtil.getPlusTime2(year)+"'"));
+        
         List<PlatformJob> yearLastNum = platformJobMapper.selectJoinList(PlatformJob.class,
                 new MPJLambdaWrapper<PlatformJob>()
                         .selectAs(PlatformJob::getId,PlatformJob::getId)
@@ -994,7 +996,7 @@
                         .eq(PlatformJob::getIsdeleted,Constants.ZERO)
                         .in(PlatformJob::getType,Constants.ONE,Constants.THREE)
                         .in(PlatformJob::getStatus,Constants.PlatformJobStatus.DONE.getKey(),Constants.PlatformJobStatus.LEAVED.getKey(),Constants.PlatformJobStatus.AUTHED_LEAVE.getKey())
-                        .apply("year(done_date) = year('"+DateUtil.getPlusTime2(lastYear)+"')  and done_date<= '"+DateUtil.getPlusTime2(lastYear)+"'"));
+                        .apply("year(done_date) = year('"+DateUtil.getPlusTime2(lastYear)+"')  and done_date<=  now()  "));
 
         data.setMonthOutTotal(getSumTotalByList(monthNum,0,null));//鏈湀鍑哄簱閲�
         data.setMonthLastOutTotal(getSumTotalByList(monthLastNum,null,null) );//涓婃湀鍑哄簱閲�

--
Gitblit v1.9.3