From 568e38a95cb6fb20fe16b53d17f610aefc6f744f Mon Sep 17 00:00:00 2001
From: rk <94314517@qq.com>
Date: 星期四, 09 十月 2025 18:29:29 +0800
Subject: [PATCH] 钉钉通知 与钥匙柜开发

---
 server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/CarUseBookServiceImpl.java |  439 +++++++++++++++++++++++++++++++++++++++++++-----------
 1 files changed, 348 insertions(+), 91 deletions(-)

diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/CarUseBookServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/CarUseBookServiceImpl.java
index 2479504..e4fcb35 100644
--- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/CarUseBookServiceImpl.java
+++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/CarUseBookServiceImpl.java
@@ -1,41 +1,52 @@
 package com.doumee.service.business.impl;
 
+import com.alibaba.fastjson.JSONObject;
 import com.doumee.biz.system.SystemDictDataBiz;
 import com.doumee.core.constants.ResponseStatus;
 import com.doumee.core.exception.BusinessException;
-import com.doumee.core.model.LoginUserInfo;
-import com.doumee.core.model.PageData;
-import com.doumee.core.model.PageWrap;
-import com.doumee.core.utils.Constants;
-import com.doumee.core.utils.DESUtil;
-import com.doumee.core.utils.DateUtil;
-import com.doumee.core.utils.Utils;
-import com.doumee.dao.business.CarUseBookMapper;
-import com.doumee.dao.business.CarsMapper;
+import com.doumee.dao.business.dao.UserActionMapper;
+import com.doumee.service.business.third.model.LoginUserInfo;
+import com.doumee.service.business.third.model.PageData;
+import com.doumee.service.business.third.model.PageWrap;
+import com.doumee.core.utils.*;
+import com.doumee.core.wx.wxPlat.WxPlatConstants;
+import com.doumee.core.wx.wxPlat.WxPlatNotice;
+import com.doumee.dao.business.*;
+import com.doumee.dao.business.dao.MemberMapper;
+import com.doumee.dao.business.dao.SmsConfigMapper;
+import com.doumee.dao.business.dao.SmsEmailMapper;
+import com.doumee.dao.business.join.ApproveJoinMapper;
 import com.doumee.dao.business.join.CarUseBookJoinMapper;
 import com.doumee.dao.business.model.*;
+import com.doumee.dao.business.vo.ApproveDataVO;
 import com.doumee.dao.business.vo.DateIntervalVO;
+
+import com.doumee.dao.business.model.Member;
+import com.doumee.dao.system.SystemUserMapper;
+import com.doumee.dao.system.join.NoticesJoinMapper;
+import com.doumee.dao.system.model.Notices;
 import com.doumee.dao.system.model.SystemDictData;
+import com.doumee.dao.system.model.SystemUser;
+import com.doumee.service.business.ApproveService;
 import com.doumee.service.business.CarUseBookService;
 import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
 import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
 import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.doumee.service.business.third.EmayService;
 import com.github.yulichang.wrapper.MPJLambdaWrapper;
 import org.apache.commons.lang3.StringUtils;
+import org.checkerframework.checker.units.qual.C;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
 import org.springframework.util.CollectionUtils;
 
 import java.time.LocalDateTime;
 import java.time.ZoneId;
 import java.time.format.DateTimeFormatter;
-import java.time.temporal.ChronoUnit;
+import java.util.*;
 import java.util.Date;
-import java.util.ArrayList;
-import java.util.List;
-import java.util.Objects;
-import java.util.stream.Collectors;
 
 /**
  * 杞﹁締_鐢ㄨ溅鐢宠淇℃伅琛⊿ervice瀹炵幇
@@ -47,7 +58,11 @@
 
     @Autowired
     private CarUseBookMapper carUseBookMapper;
+    @Autowired
+    private ApproveMapper approveMapper;
 
+    @Autowired
+    private UserActionMapper userActionMapper;
     @Autowired
     private CarUseBookJoinMapper carUseBookJoinMapper;
 
@@ -57,15 +72,45 @@
     @Autowired
     private SystemDictDataBiz systemDictDataBiz;
 
+    @Autowired
+    private ApproveJoinMapper approveJoinMapper;
+
+    @Autowired
+    private NoticesJoinMapper noticesJoinMapper;
+
+    @Autowired
+    private ApproveService approveService;
+
+    @Autowired
+    private CarDriverMapper carDriverMapper;
+
+    @Autowired
+    private MemberMapper memberMapper;
+
+
+    @Autowired
+    private SmsConfigMapper smsConfigMapper;
+
+    @Autowired
+    private SmsEmailMapper smsEmailMapper;
+
+    @Autowired
+    private EmayService emayService;
+
+    @Autowired
+    private WxNoticeConfigMapper wxNoticeConfigMapper;
+
+    @Autowired
+    private SystemUserMapper systemUserMapper;
 
     @Override
-    public Integer create(CarUseBook carUseBook) {
+    @Transactional(rollbackFor = {Exception.class,BusinessException.class})
+    public Integer create(CarUseBook carUseBook)  throws Exception {
         if(Objects.isNull(carUseBook)
             || Objects.isNull(carUseBook.getCarId())
                 || Objects.isNull(carUseBook.getStartTime())
                 || Objects.isNull(carUseBook.getEndTime())
                 || Objects.isNull(carUseBook.getCreator())
-                || Objects.isNull(carUseBook.getMemberId())
                 || Objects.isNull(carUseBook.getPlanUseDate())
                 || Objects.isNull(carUseBook.getType())
                 || StringUtils.isEmpty(carUseBook.getMemberIds())
@@ -75,34 +120,53 @@
         ){
             throw new BusinessException(ResponseStatus.BAD_REQUEST);
         }
+        if(Objects.nonNull(carUseBook.getCreator())&&Objects.isNull(carUseBook.getMemberId())){
+            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"褰撳墠鐧诲綍鐢ㄦ埛鏃犳硶杩涜璇ユ搷浣�!");
+        }
+        if(carUseBook.getEndTime().getTime()<=System.currentTimeMillis()){
+//            throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"閫夋嫨鏃ユ湡寮傚父[缁撴潫鏃堕棿灏忎簬褰撳墠鏃堕棿],璇峰埛鏂伴噸璇�");
+        }
+        if(!(DateUtil.getDateFromString(carUseBook.getPlanUseDate()+":00").getTime()>=carUseBook.getStartTime().getTime()
+                && DateUtil.getDateFromString(carUseBook.getPlanUseDate() +":00").getTime()<= carUseBook.getEndTime().getTime())
+         ){
+            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"鍑哄彂鏃堕棿閿欒");
+        }
         carUseBook.setStatus(Constants.ZERO);
         carUseBook.setCreateDate(new Date());
+        carUseBook.setIsdeleted(Constants.ZERO);
         Cars cars = carsMapper.selectById(carUseBook.getCarId());
-        if(Objects.isNull(cars)||!cars.getType().equals(Constants.ONE)){
+        if(Objects.isNull(cars)||!cars.getType().equals(Constants.ZERO)){
             throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"杞﹁締淇℃伅寮傚父");
         }
-        //鏌ヨ杞﹁締鎻愪氦鏃堕棿鏄惁瀛樺湪鍐茬獊鐨勯绾﹁褰�
-        List<CarUseBook> carUseBookList = carUseBookJoinMapper.selectJoinList(CarUseBook.class,
-                new MPJLambdaWrapper<CarUseBook>()
-                        .selectAll(CarUseBook.class)
-                        .selectAs(Member::getName,CarUseBook::getMemberName)
-                        .selectAs(Member::getPhone,CarUseBook::getMemberMobile)
-                        .leftJoin(Member.class,Member::getId,CarUseBook::getMemberId)
-                        .eq(CarUseBook::getId,carUseBook.getCarId())
-                        .in(CarUseBook::getStatus,0,1,2)
-                        .and(i->i.and(j->j.lt(CarUseBook::getStartTime,carUseBook.getStartTime()).gt(CarUseBook::getStartTime,carUseBook.getStartTime()))
-                                .or()
-                                .and(j->j.lt(CarUseBook::getEndTime,carUseBook.getEndTime()).gt(CarUseBook::getEndTime,carUseBook.getStartTime()))
-                                .or()
-                                .and(j->j.gt(CarUseBook::getStartTime,carUseBook.getStartTime()).lt(CarUseBook::getEndTime,carUseBook.getEndTime()))
-                                .or()
-                                .and(j->j.lt(CarUseBook::getStartTime,carUseBook.getStartTime()).gt(CarUseBook::getEndTime,carUseBook.getEndTime()))
-                        )
+        carUseBook.setCarCode(cars.getCode());
+        //鏍规嵁杞﹁締鏌ヨ鍙告満淇℃伅
+        CarDriver carDriver = carDriverMapper.selectOne(new QueryWrapper<CarDriver>().lambda()
+                .eq(CarDriver::getCarId,cars.getId())
+                .eq(CarDriver::getIsdeleted,Constants.ZERO)
+//                .eq(CarDriver::getStatus,Constants.ZERO)
+                .last( " limit 1 ")
         );
-        if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(carUseBookList)){
+        if(Objects.nonNull(carDriver)&&Objects.nonNull(carDriver.getMemberId())){
+            carUseBook.setDriverId(carDriver.getMemberId());
+        }
+        //鏌ヨ杞﹁締鎻愪氦鏃堕棿鏄惁瀛樺湪鍐茬獊鐨勯绾﹁褰�
+        if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(this.carUseBookList(carUseBook))){
             throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀛樺湪杞﹁締棰勭害鏃堕棿涓庡凡棰勭害鏃堕棿鍐茬獊~");
         }
         carUseBookMapper.insert(carUseBook);
+        //鐢ㄨ溅鐢宠 瀹℃壒璁板綍鍒涘缓
+        approveService.createApproveFlow(carUseBook.getType()==0?3:4,carUseBook.getId(),carUseBook.getMemberId(),null);
+        //鍙戦�佸井淇″叕浼楀彿閫氱煡
+        //鍙戦�佸井淇″叕浼楀彿閫氱煡
+        WxPlatNotice wxPlatNotice = new WxPlatNotice();
+        SystemUser systemUser = systemUserMapper.selectById(carUseBook.getCreator());
+        if(Objects.nonNull(systemUser) && StringUtils.isNotBlank(systemUser.getOpenid())){
+            carUseBook.setMemberName(systemUser.getRealname());
+            wxPlatNotice.sendCarUseBookTemplateNotice(systemDictDataBiz,
+                    wxNoticeConfigMapper,carUseBook,
+                    WxPlatConstants.carUseBookContent.carUseBookUpload,
+                    Arrays.asList(systemUser.getOpenid().split(",")),0);
+        }
         return carUseBook.getId();
     }
 
@@ -110,7 +174,38 @@
     public void deleteById(Integer id) {
         carUseBookMapper.deleteById(id);
     }
+    @Override
+    @Transactional(rollbackFor = {BusinessException.class,Exception.class})
+    public  void deleteById(Integer id,LoginUserInfo user) {
+        Date date = new Date();
+        MPJLambdaWrapper<CarUseBook>  queryWrapper = new MPJLambdaWrapper<>();
+        queryWrapper.selectAll(CarUseBook.class);
+        queryWrapper.select("t1.name",CarUseBook::getMemberName);
+        queryWrapper.leftJoin(Member.class,Member::getId,CarUseBook::getMemberId)
+                .eq(CarUseBook::getId,id)
+                .eq(CarUseBook::getIsdeleted,Constants.ZERO)
+                .last("limit 1"  );
+        CarUseBook model = carUseBookMapper.selectJoinOne(CarUseBook.class,queryWrapper);
+        if(model==null ||Constants.equalsInteger(Constants.ONE,model.getIsdeleted())){
+            throw new BusinessException(ResponseStatus.DATA_EMPTY);
+        }
+        carUseBookMapper.update(null,new UpdateWrapper<CarUseBook>().lambda()
+                .set(CarUseBook::getIsdeleted,Constants.ONE)
+                .set(CarUseBook::getEditDate,date)
+                .set(CarUseBook::getEditor,user.getId())
+                .eq(CarUseBook::getId,id));
+        String[] params = new String[3];
+        params[0] = user.getRealname();
+        params[1]=DateUtil.getPlusTime2(date);
+        params[2]=model.getCarCode()+"-銆愪箻杞︿汉锛�"+model.getMemberNames()+" 銆�-銆愰绾︿汉锛�"+model.getMemberName()+"銆�-銆愭椂闂达細"+DateUtil.getPlusTime2(model.getStartTime())+"-"+DateUtil.getPlusTime2(model.getEndTime())+"銆�";
+        //璁板綍鍒犻櫎鏃ュ織
+        UserActionServiceImpl.saveUserActionBiz(user,id,Constants.UserActionType.CAR_BOOK_DEL,userActionMapper,date,params, JSONObject.toJSONString(model));
 
+        VisitsServiceImpl.dealCancelNoticesData(noticesJoinMapper,approveMapper,"绯荤粺鍒犻櫎",model.getId(),
+                Constants.equalsInteger(model.getType(),Constants.ZERO)?Constants.approveObjectType.cityUseCar:Constants.approveObjectType.unCityUseCar,
+                Constants.noticesObjectType.useCar
+        );
+    }
     @Override
     public void delete(CarUseBook carUseBook) {
         UpdateWrapper<CarUseBook> deleteWrapper = new UpdateWrapper<>(carUseBook);
@@ -140,22 +235,79 @@
         }
     }
 
+    /**
+     *
+     * @param id 涓婚敭
+     * @param memberId
+     * @return
+     */
     @Override
-    public CarUseBook findById(Integer id) {
+    public CarUseBook findById(Integer id,Integer memberId) {
         MPJLambdaWrapper<CarUseBook>  queryWrapper = new MPJLambdaWrapper<>();
         queryWrapper.selectAll(CarUseBook.class);
         queryWrapper.select("t1.name",CarUseBook::getMemberName);
         queryWrapper.select("t1.phone",CarUseBook::getMemberPhone);
         queryWrapper.select("t2.name",CarUseBook::getDriverName);
-        queryWrapper.select("t3.phone",CarUseBook::getDriverPhone);
+        queryWrapper.select("t2.phone",CarUseBook::getDriverPhone);
         queryWrapper.select("t4.company_name_path",CarUseBook::getCompanyName);
         queryWrapper.leftJoin(Member.class,Member::getId,CarUseBook::getMemberId)
-                .leftJoin("company t4 on t1.company_id=t4.id")
                 .leftJoin(Member.class,Member::getId,CarUseBook::getDriverId)
+                .leftJoin("company t4 on t1.company_id=t4.id")
                 .eq(CarUseBook::getId,id)
+                .eq(CarUseBook::getIsdeleted,Constants.ZERO)
                 .last("limit 1"  );
         CarUseBook model = carUseBookMapper.selectJoinOne(CarUseBook.class,queryWrapper);
+        if(Objects.isNull(model)){
+            throw new BusinessException(ResponseStatus.DATA_EMPTY);
+        }
+        model.setApproveDateVO(getApproveDataVO(memberId,model));
+        List<Approve> approveList = model.getApproveDateVO().getApproveList();
+        if(Constants.equalsInteger(model.getStatus(),Constants.FOUR)){
+            String path = systemDictDataBiz.queryByCode(Constants.FTP,Constants.FTP_RESOURCE_PATH).getCode()
+                    +systemDictDataBiz.queryByCode(Constants.FTP,Constants.MEMBER_IMG).getCode();
+            Member member1 = memberMapper.selectById(model.getCancelUser());
+
+            Approve approve = new Approve();
+            approve.setApproveType(Constants.ZERO);
+            approve.setCreateDate(model.getCancelTime());
+            approve.setTitle("鎾ら攢浜�");
+            approve.setStatusInfo("宸叉挙閿�");
+            approve.setStatus(Constants.FOUR);
+            approve.setType(Constants.ZERO);
+            if(member1!=null) {
+                approve.setMemberName(member1.getName());
+                if (StringUtils.isNotBlank(member1.getFaceImg())) {
+                    approve.setFaceImg(path + member1.getFaceImg());
+                }
+            }
+            approve.setCheckInfo(model.getCancelInfo());
+            approve.setCheckDate(model.getCancelTime());
+            approveList.add(approve);
+        }
+
+        Notices notices = noticesJoinMapper.selectOne(new QueryWrapper<Notices>().lambda()
+                .eq(Notices::getObjId,id)
+                .eq(Notices::getType,Constants.noticesObjectType.useCar)
+                .eq(Notices::getUserId,memberId)
+                .eq(Notices::getSendacopy,Constants.ZERO)
+                .orderByDesc(Notices::getId).last(" limit 1 "));
+        if(Objects.nonNull(notices)){
+            if(Constants.equalsInteger(notices.getStatus(),Constants.ZERO)){
+                model.setInfo("寰呮垜澶勭悊");
+            }else{
+                model.setInfo(notices.getInfo());
+            }
+        }
+
+
         return  model;
+    }
+
+    private ApproveDataVO getApproveDataVO( Integer memberId,CarUseBook model) {
+        ApproveDataVO approveDataVO = approveService.arrangeApprovedData(model.getId(),
+                Constants.equalsInteger(model.getType(),Constants.ZERO)?3:4,
+                memberId);
+        return approveDataVO;
     }
 
     @Override
@@ -180,11 +332,23 @@
         queryWrapper.select("t1.name",CarUseBook::getMemberName);
         queryWrapper.select("t1.phone",CarUseBook::getMemberPhone);
         queryWrapper.select("t2.name",CarUseBook::getDriverName);
-        queryWrapper.select("t3.phone",CarUseBook::getDriverPhone);
+        queryWrapper.select("t2.phone",CarUseBook::getDriverPhone);
         queryWrapper.select("t4.company_name_path",CarUseBook::getCompanyName);
         queryWrapper.leftJoin(Member.class,Member::getId,CarUseBook::getMemberId)
-                    .leftJoin("company t4 on t1.company_id=t4.id")
-                    .leftJoin(Member.class,Member::getId,CarUseBook::getDriverId);
+                    .leftJoin(Member.class,Member::getId,CarUseBook::getDriverId)
+                    .leftJoin("company t4 on t1.company_id=t4.id");
+        //鏁版嵁鏉冮檺寮�濮�--------------------start----------------
+        LoginUserInfo userInfo =pageWrap.getModel().getLoginUserInfo();
+        if(userInfo!=null && userInfo.getCompanyIdList()!=null){
+            if( userInfo.getCompanyIdList().size() ==0){
+                //鍙兘鐪嬭嚜宸�
+                queryWrapper.eq(CarUseBook::getCreator,userInfo.getId());
+            }else{
+                queryWrapper.in("t1.company_id" ,userInfo.getCompanyIdList());
+            }
+        }
+        //鏁版嵁鏉冮檺寮�濮�--------------------end----------------
+
         queryWrapper
                 .eq(pageWrap.getModel().getId() != null, CarUseBook::getId, pageWrap.getModel().getId())
                 .eq(pageWrap.getModel().getCreator() != null, CarUseBook::getCreator, pageWrap.getModel().getCreator())
@@ -207,10 +371,8 @@
                 .le(pageWrap.getModel().getCheckDate() != null, CarUseBook::getCheckDate, Utils.Date.getEnd(pageWrap.getModel().getCheckDate()))
                 .eq(pageWrap.getModel().getCheckUserId() != null, CarUseBook::getCheckUserId, pageWrap.getModel().getCheckUserId())
                 .eq(pageWrap.getModel().getCheckInfo() != null, CarUseBook::getCheckInfo, pageWrap.getModel().getCheckInfo())
-                .ge(pageWrap.getModel().getCancelType() != null, CarUseBook::getCancelType, Utils.Date.getStart(pageWrap.getModel().getCancelType()))
-                .le(pageWrap.getModel().getCancelType() != null, CarUseBook::getCancelType, Utils.Date.getEnd(pageWrap.getModel().getCancelType()))
-                .ge(pageWrap.getModel().getCancelStatus() != null, CarUseBook::getCancelStatus, Utils.Date.getStart(pageWrap.getModel().getCancelStatus()))
-                .le(pageWrap.getModel().getCancelStatus() != null, CarUseBook::getCancelStatus, Utils.Date.getEnd(pageWrap.getModel().getCancelStatus()))
+                .eq(pageWrap.getModel().getCancelType() != null, CarUseBook::getCancelType,  pageWrap.getModel().getCancelType())
+                .eq(pageWrap.getModel().getCancelStatus() != null, CarUseBook::getCancelStatus, pageWrap.getModel().getCancelStatus())
                 .ge(pageWrap.getModel().getCancelTime() != null, CarUseBook::getCancelTime, Utils.Date.getStart(pageWrap.getModel().getCancelTime()))
                 .le(pageWrap.getModel().getCancelTime() != null, CarUseBook::getCancelTime, Utils.Date.getEnd(pageWrap.getModel().getCancelTime()))
                 .eq(pageWrap.getModel().getCancelUser() != null, CarUseBook::getCancelUser, pageWrap.getModel().getCancelUser())
@@ -222,19 +384,12 @@
                 .eq(pageWrap.getModel().getAddr() != null, CarUseBook::getAddr, pageWrap.getModel().getAddr())
                 .eq(pageWrap.getModel().getMemberId() != null, CarUseBook::getMemberId, pageWrap.getModel().getMemberId())
                 .eq(pageWrap.getModel().getDriverId() != null, CarUseBook::getDriverId, pageWrap.getModel().getDriverId())
-                .and(StringUtils.isNotBlank(pageWrap.getModel().getQueryDate()),
-                        i->i.and(j->j.lt(CarUseBook::getStartTime,pageWrap.getModel().getQueryDate() +"00:00:00").gt(CarUseBook::getStartTime,pageWrap.getModel().getQueryDate() +"23:59:59"))
-                        .or()
-                        .and(j->j.lt(CarUseBook::getEndTime,pageWrap.getModel().getQueryDate() +"23:59:59").gt(CarUseBook::getEndTime,pageWrap.getModel().getQueryDate() +"00:00:00"))
-                        .or()
-                        .and(j->j.gt(CarUseBook::getStartTime,pageWrap.getModel().getQueryDate() +"00:00:00").lt(CarUseBook::getEndTime,pageWrap.getModel().getQueryDate() +"23:59:59"))
-                        .or()
-                        .and(j->j.lt(CarUseBook::getStartTime,pageWrap.getModel().getQueryDate() +"00:00:00").gt(CarUseBook::getEndTime,pageWrap.getModel().getQueryDate() +"23:59:59"))
-                )
+                .apply(pageWrap.getModel().getCompanyName() != null, "t4.company_name_path like '%"+pageWrap.getModel().getCompanyName()+"%'")
+
                 .and(StringUtils.isNotBlank(pageWrap.getModel().getMemberName()), ms->ms.like(Member::getName,pageWrap.getModel().getMemberName())
                         .or().like(Member::getPhone,pageWrap.getModel().getMemberName()))
-                .ge(Objects.nonNull(pageWrap.getModel().getQueryStartTime()), Empower::getCreateDate,pageWrap.getModel().getQueryStartTime())
-                .le(Objects.nonNull(pageWrap.getModel().getQueryEndTime()),Empower::getCreateDate,pageWrap.getModel().getQueryEndTime())
+                .ge(Objects.nonNull(pageWrap.getModel().getQueryStartTime()), CarUseBook::getCreateDate,pageWrap.getModel().getQueryStartTime())
+                .le(Objects.nonNull(pageWrap.getModel().getQueryEndTime()),CarUseBook::getCreateDate,pageWrap.getModel().getQueryEndTime())
                 .orderByDesc(Visits::getCreateDate)
         ;
         for(PageWrap.SortData sortData: pageWrap.getSorts()) {
@@ -244,7 +399,13 @@
                 queryWrapper.orderByAsc(sortData.getProperty());
             }
         }
-        return PageData.from(carUseBookMapper.selectJoinPage(page, CarUseBook.class, queryWrapper));
+        PageData<CarUseBook> result =PageData.from(carUseBookMapper.selectJoinPage(page, CarUseBook.class, queryWrapper));
+        if(result!=null && result.getRecords()!=null){
+            for(CarUseBook carUseBook:result.getRecords()){
+                carUseBook.setHasRole(getHasBackRoleBiz(carUseBook,pageWrap.getModel().getLoginUserInfo()));
+            }
+        }
+        return result;
     }
 
     @Override
@@ -260,7 +421,7 @@
      * @return
      */
     @Override
-    public List<CarUseBook> carUseBookList(CarUseBook carUseBook){
+    public List<CarUseBook> carUseBookList(CarUseBook carUseBook) throws Exception {
         if(Objects.isNull(carUseBook)
             || Objects.isNull(carUseBook.getCarId())
             || Objects.isNull(carUseBook.getStartTime())
@@ -273,16 +434,16 @@
                         .selectAs(Member::getName,CarUseBook::getMemberName)
                         .selectAs(Member::getPhone,CarUseBook::getMemberMobile)
                         .leftJoin(Member.class,Member::getId,CarUseBook::getMemberId)
-                        .eq(CarUseBook::getId,carUseBook.getCarId())
+                        .eq(CarUseBook::getIsdeleted,Constants.ZERO)
+                        .eq(CarUseBook::getCarId,carUseBook.getCarId())
                         .in(CarUseBook::getStatus,0,1,2)
-                        .and(i->i.and(j->j.lt(CarUseBook::getStartTime,carUseBook.getStartTime()).gt(CarUseBook::getStartTime,carUseBook.getStartTime()))
-                                .or()
-                                .and(j->j.lt(CarUseBook::getEndTime,carUseBook.getStartTime()).gt(CarUseBook::getEndTime,carUseBook.getStartTime()))
-                                .or()
-                                .and(j->j.gt(CarUseBook::getStartTime,carUseBook.getStartTime()).lt(CarUseBook::getEndTime,carUseBook.getEndTime()))
-                                .or()
-                                .and(j->j.lt(CarUseBook::getStartTime,carUseBook.getStartTime()).gt(CarUseBook::getEndTime,carUseBook.getEndTime()))
-                        )
+                        .apply(" ( " +
+                                " '"+DateUtil.getPlusTime(carUseBook.getStartTime())+"'  <= t.start_time AND t.start_time < '"+DateUtil.getPlusTime(carUseBook.getEndTime())+"' " +
+                                " or " +
+                                "  ( '"+DateUtil.getPlusTime(carUseBook.getStartTime())+"' < t.end_time AND t.end_time < '"+DateUtil.getPlusTime(carUseBook.getEndTime())+"' )  " +
+                                " or " +
+                                " ( '"+DateUtil.getPlusTime(carUseBook.getStartTime())+"' > t.start_time AND '"+DateUtil.getPlusTime(carUseBook.getEndTime())+"' < t.end_time )" +
+                                " ) " )
         );
         return carUseBookList;
     }
@@ -307,8 +468,8 @@
             ||Objects.isNull(interval.getCode())){
             throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"閰嶇疆閿欒锛岃鑱旂郴绠$悊鍛�");
         }
-        Date startTime = DateUtil.StringToDate(dateDay + workStart.getCode(),"yyyy-MM-dd HH:mm:ss");
-        Date endTime = DateUtil.StringToDate(dateDay + workEnd.getCode(),"yyyy-MM-dd HH:mm:ss");
+        Date startTime = DateUtil.StringToDate((dateDay + " " +workStart.getCode()),"yyyy-MM-dd HH:mm:ss");
+        Date endTime = DateUtil.StringToDate(dateDay + " " + workEnd.getCode(),"yyyy-MM-dd HH:mm:ss");
         Long intervalTime = Long.valueOf(interval.getCode());
         LocalDateTime localStartTime = startTime.toInstant()
                 .atZone(ZoneId.systemDefault())
@@ -322,29 +483,33 @@
                         .eq(CarUseBook::getIsdeleted,Constants.ZERO)
                         .eq(CarUseBook::getCarId,cars)
                         .in(CarUseBook::getStatus,0,1,2)
-                .and(i->i.like(CarUseBook::getStartTime,dateDay).or().like(CarUseBook::getEndTime,dateDay)
+                .and(i->i.like(CarUseBook::getStartTime,dateDay)
+                        .or().like(CarUseBook::getEndTime,dateDay)
                         .or().apply("  START_TIME < '"+dateDay+" 00:00:00' and END_TIME  > '"+dateDay+" 23:59:59'  "))
         );
-        if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(carUseBookList)){
-            for (DateIntervalVO dateIntervalVO:dateIntervalVOList) {
-                if(
-                carUseBookList.stream().filter(
-                        i->
-                                ( i.getStartTime().getTime()<DateUtil.stringToDate(dateIntervalVO.getStartTime(),"yyyy-MM-dd HH:mm:ss ").getTime()
-                        && i.getEndTime().getTime() >  DateUtil.stringToDate(dateIntervalVO.getStartTime(),"yyyy-MM-dd HH:mm:ss ").getTime())
-                        ||
-                        ( i.getStartTime().getTime()<DateUtil.stringToDate(dateIntervalVO.getEndTime(),"yyyy-MM-dd HH:mm:ss ").getTime()
-                                && i.getEndTime().getTime() > DateUtil.stringToDate(dateIntervalVO.getEndTime(),"yyyy-MM-dd HH:mm:ss ").getTime())
-                        ||
-                        ( DateUtil.stringToDate(dateIntervalVO.getStartTime(),"yyyy-MM-dd HH:mm:ss ").getTime() < i.getStartTime().getTime()
-                                &&  DateUtil.stringToDate(dateIntervalVO.getStartTime(),"yyyy-MM-dd HH:mm:ss ").getTime() > i.getStartTime().getTime())
-                        ||
-                        ( DateUtil.stringToDate(dateIntervalVO.getStartTime(),"yyyy-MM-dd HH:mm:ss ").getTime() < i.getEndTime().getTime()
-                                &&  DateUtil.stringToDate(dateIntervalVO.getStartTime(),"yyyy-MM-dd HH:mm:ss ").getTime() > i.getEndTime().getTime())
-
-                ).collect(Collectors.toList()).size()>Constants.ZERO){
-                    dateIntervalVO.setIsUse(Constants.ONE);
-                };
+        for (DateIntervalVO dateIntervalVO:dateIntervalVOList) {
+            if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(carUseBookList)){
+                for (CarUseBook i:carUseBookList  ) {
+                    if(
+                            (DateUtil.getDateFromString(dateIntervalVO.getStartTime()).getTime() <= i.getStartTime().getTime() &&
+                                    i.getStartTime().getTime() < DateUtil.getDateFromString(dateIntervalVO.getEndTime()).getTime())
+                                    ||
+                                    (DateUtil.getDateFromString(dateIntervalVO.getStartTime()).getTime() < i.getEndTime().getTime() &&
+                                            i.getEndTime().getTime() <= DateUtil.getDateFromString(dateIntervalVO.getEndTime()).getTime())
+                                    ||
+                                    (DateUtil.getDateFromString(dateIntervalVO.getStartTime()).getTime() >= i.getStartTime().getTime() &&
+                                            DateUtil.getDateFromString(dateIntervalVO.getEndTime()).getTime() <= i.getEndTime().getTime())
+                    ){
+                        dateIntervalVO.setCarUseBookId(i.getId());
+                        dateIntervalVO.setIsUse(Constants.ONE);
+                        break;
+                    }
+                }
+            }
+            //鍒ゆ柇鏃堕棿鏄惁澶т簬褰撳墠
+            if(Constants.equalsInteger(dateIntervalVO.getIsUse(),Constants.ZERO)  && DateUtil.getDateFromString(dateIntervalVO.getEndTime()).getTime()<=System.currentTimeMillis()){
+//                dateIntervalVO.setIsUse(Constants.ONE);
+                continue;
             }
         }
         return dateIntervalVOList;
@@ -372,16 +537,108 @@
             dateIntervalVO.setStartTime(startTime);
             dateIntervalVO.setEndTime(endTime);
             dateIntervalVO.setIsUse(Constants.ZERO);
+            dateIntervalVOList.add(dateIntervalVO);
         }
         return dateIntervalVOList;
     }
 
 
-    public void revoke(Integer id, LoginUserInfo loginUserInfo){
+    @Override
+    public void revoke(Integer id, String info, LoginUserInfo loginUserInfo){
        CarUseBook carUseBook = carUseBookMapper.selectById(id);
+        if(Objects.isNull(carUseBook) || Constants.equalsInteger(carUseBook.getIsdeleted(),Constants.ONE)){
+            throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"鏈煡璇㈠埌鐢ㄨ溅鐢宠淇℃伅");
+        }
+        if(getHasBackRoleBiz(carUseBook,loginUserInfo) == Constants.ZERO){
+            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀵逛笉璧凤紝鏃犳潈闄愯鎾ら攢鎿嶄綔锛�");
+        }
+       carUseBook.setCancelInfo(info);
+       carUseBook.setCancelTime(new Date());
+       carUseBook.setCancelStatus(Constants.ONE);
+       carUseBook.setStatus(Constants.FOUR);
+       carUseBook.setCancelUser(loginUserInfo.getMemberId());
+       carUseBook.setCancelType(Constants.ONE);
+       if(loginUserInfo.getId().equals(carUseBook.getCreator())){
+           carUseBook.setCancelType(Constants.ZERO);
+       }
+       carUseBookMapper.updateById(carUseBook);
+       //澶勭悊瀹℃壒璁板綍
+       approveJoinMapper.update(null,new UpdateWrapper<Approve>()
+                .lambda()
+                .set(Approve::getIsdeleted,Constants.ONE)
+                .set(Approve::getStatus,Constants.FOUR)
+                .set(Approve::getCheckInfo,"鐢ㄨ溅鐢宠鍙栨秷")
+                .in(Approve::getStatus,Constants.ZERO,Constants.ONE)
+                .in(Approve::getObjType,Constants.approveObjectType.cityUseCar,Constants.approveObjectType.unCityUseCar)
+                .eq(Approve::getObjId,id)
+        );
+
+        //澶勭悊寰呭姙淇℃伅
+        noticesJoinMapper.update(null,new UpdateWrapper<Notices>().lambda()
+                .set(Notices::getStatus,Constants.ONE)
+                .set(Notices::getInfo,"宸插彇娑�")
+                .eq(Notices::getType,Constants.TWO)
+                .eq(Notices::getObjId,carUseBook.getId())
+        );
 
 
+        SystemUser systemUser = systemUserMapper.selectById(carUseBook.getCreator());
+        if(Objects.nonNull(systemUser)&&StringUtils.isNotBlank(systemUser.getMobile())){
+            //鐢ㄨ溅鐢宠鍙栨秷
+            SmsEmailServiceImpl.sendCarUseSms(systemDictDataBiz,
+                    emayService,smsEmailMapper,smsConfigMapper,carUseBookMapper,carUseBook.getId(),
+                    SmsConstants.carUseBookContent.carUseBookCancel,
+                    info, Arrays.asList(systemUser.getMobile().split(","))
+            );
+            if(StringUtils.isNotBlank(systemUser.getOpenid())){
+                carUseBook.setMemberName(systemUser.getRealname());
+                WxPlatNotice wxPlatNotice = new WxPlatNotice();
+                wxPlatNotice.sendCarUseBookTemplateNotice(systemDictDataBiz,
+                        wxNoticeConfigMapper,
+                        carUseBook,
+                        WxPlatConstants.carUseBookContent.carUseBookCancel,
+                        Arrays.asList(systemUser.getOpenid().split(",")),
+                        Constants.TWO);
+            }
 
+        }
+    }
+
+    /**
+     * 鏌ヨ褰撳墠鐧婚檰鐢ㄦ埛鏄惁鍏锋湁閫�鍥炵敵璇风殑鏉冮檺
+     * 鐢宠浜哄彧鑳藉湪寰呭鏍镐箣鍓嶆挙閿�锛屾淳杞﹀憳鍙互鍦ㄥ緟瀹℃牳銆佸鏍镐腑銆佸鎵归�氳繃杩涜鎾ら攢
+     * @param carUseBook
+     * @param loginUserInfo
+     * @return
+     */
+    private int getHasBackRoleBiz(CarUseBook carUseBook, LoginUserInfo loginUserInfo) {
+        if(Constants.equalsInteger(carUseBook.getCreator(),loginUserInfo.getId())
+                && Constants.equalsInteger(carUseBook.getStatus(),Constants.ZERO)){
+            //鐢宠浜哄彲浠ユ挙閿�鑷繁鐢宠涓殑鐢宠璁板綍
+            return  Constants.ONE;
+        }
+        if(Constants.equalsInteger(carUseBook.getStatus(),Constants.TWO)
+                 && carUseBook.getStartTime()!=null
+                 && System.currentTimeMillis() >= carUseBook.getStartTime().getTime()){
+            //瀹℃壒閫氳繃锛屼絾鏄� 宸插埌鍙戣溅鏃堕棿锛屼笉鍙互鎾ら攢
+            return Constants.ZERO;
+        }
+        if((Constants.equalsInteger(carUseBook.getStatus(),Constants.ZERO))
+                ||Constants.equalsInteger(carUseBook.getStatus(),Constants.ONE)
+                ||Constants.equalsInteger(carUseBook.getStatus(),Constants.TWO)){
+            //瀹℃壒浜哄彲浠ユ挙閿� 鑷繁瀹℃壒鐨勭敵璇疯褰�
+            Approve approve = approveJoinMapper.selectOne(new QueryWrapper<Approve>().lambda()
+                    .eq(Approve::getIsdeleted,Constants.ZERO)
+                    .ge(Approve::getLevel,Constants.ZERO)
+                    .eq(Approve::getChekorId,loginUserInfo.getMemberId())
+                    .eq(Approve::getObjId,carUseBook.getId())
+                    .eq(Approve::getObjType,carUseBook.getType()==0?3:4)
+                    .last("limit 1"));
+            if(approve!=null){
+                return Constants.ONE;
+            }
+        }
+        return Constants.ZERO;
     }
 
 

--
Gitblit v1.9.3