From c4a098e3f88bc5071e36b92b9e5dcceb51129957 Mon Sep 17 00:00:00 2001
From: puzhibing <393733352@qq.com>
Date: 星期四, 01 六月 2023 23:25:07 +0800
Subject: [PATCH] 同步后台代码

---
 management/guns-admin/src/main/java/com/stylefeng/guns/modular/system/controller/general/TDriverController.java |  274 +++++++++++++++++++++++++++++++++++++++++++++---------
 1 files changed, 226 insertions(+), 48 deletions(-)

diff --git a/management/guns-admin/src/main/java/com/stylefeng/guns/modular/system/controller/general/TDriverController.java b/management/guns-admin/src/main/java/com/stylefeng/guns/modular/system/controller/general/TDriverController.java
index f139140..bfc2786 100644
--- a/management/guns-admin/src/main/java/com/stylefeng/guns/modular/system/controller/general/TDriverController.java
+++ b/management/guns-admin/src/main/java/com/stylefeng/guns/modular/system/controller/general/TDriverController.java
@@ -1,44 +1,56 @@
 package com.stylefeng.guns.modular.system.controller.general;
 
-import cn.hutool.core.util.CreditCodeUtil;
+import com.alibaba.fastjson.JSON;
 import com.alibaba.fastjson.JSONObject;
 import com.baomidou.mybatisplus.mapper.EntityWrapper;
+import com.baomidou.mybatisplus.mapper.Wrapper;
 import com.stylefeng.guns.core.base.controller.BaseController;
 import com.stylefeng.guns.core.base.tips.SuccessTip;
+import com.stylefeng.guns.core.log.LogObjectHolder;
 import com.stylefeng.guns.core.shiro.ShiroKit;
 import com.stylefeng.guns.core.shiro.ShiroUser;
 import com.stylefeng.guns.modular.system.controller.resp.TDriverCommissionResp;
 import com.stylefeng.guns.modular.system.controller.resp.TDriverResp;
-import com.stylefeng.guns.modular.system.controller.util.*;
+import com.stylefeng.guns.modular.system.controller.util.ExcelUtil;
+import com.stylefeng.guns.modular.system.controller.util.HttpUtils;
+import com.stylefeng.guns.modular.system.controller.util.TokenUtils;
+import com.stylefeng.guns.modular.system.controller.util.UUIDUtil;
+import com.stylefeng.guns.modular.system.dao.AccountChangeDetailMapper;
 import com.stylefeng.guns.modular.system.enums.UserTypeEnum;
 import com.stylefeng.guns.modular.system.model.*;
 import com.stylefeng.guns.modular.system.service.*;
+import com.stylefeng.guns.modular.system.util.DateUtil;
+import com.stylefeng.guns.modular.system.util.RedisUtil;
 import io.swagger.annotations.ApiImplicitParam;
 import io.swagger.annotations.ApiImplicitParams;
-import io.swagger.annotations.ApiModelProperty;
 import io.swagger.annotations.ApiOperation;
-import org.apache.logging.log4j.core.util.UuidUtil;
 import org.apache.poi.hssf.usermodel.HSSFWorkbook;
 import org.apache.shiro.subject.Subject;
+import org.slf4j.Logger;
+import org.slf4j.LoggerFactory;
 import org.springframework.beans.BeanUtils;
+import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.data.redis.core.RedisTemplate;
 import org.springframework.stereotype.Controller;
 import org.springframework.transaction.annotation.Transactional;
-import org.springframework.util.StringUtils;
-import org.springframework.web.bind.annotation.RequestMapping;
-import org.springframework.web.bind.annotation.ResponseBody;
 import org.springframework.ui.Model;
+import org.springframework.util.StringUtils;
 import org.springframework.web.bind.annotation.PathVariable;
-import org.springframework.beans.factory.annotation.Autowired;
-import com.stylefeng.guns.core.log.LogObjectHolder;
+import org.springframework.web.bind.annotation.RequestMapping;
 import org.springframework.web.bind.annotation.RequestParam;
+import org.springframework.web.bind.annotation.ResponseBody;
+import org.springframework.web.multipart.MultipartFile;
 
+import javax.annotation.Resource;
 import javax.servlet.http.HttpServletResponse;
 import java.io.File;
+import java.io.IOException;
 import java.io.OutputStream;
 import java.math.BigDecimal;
 import java.text.DateFormat;
 import java.text.SimpleDateFormat;
+import java.time.LocalDate;
+import java.time.Period;
 import java.util.ArrayList;
 import java.util.Date;
 import java.util.List;
@@ -75,7 +87,19 @@
     @Autowired
     private TokenUtils tokenUtils;
     @Autowired
+    private ITDriverWorkService tDriverWorkService;
+    @Autowired
+    private RedisUtil redisUtil;
+    @Autowired
     private ITRechargeRecordService tRechargeRecordService;
+
+    @Autowired
+    private ITSystemConfigService systemConfigService;
+
+    @Resource
+    private AccountChangeDetailMapper accountChangeDetailMapper;
+
+    private Logger log = LoggerFactory.getLogger(this.getClass());
 
     /**
      * 跳转到首页
@@ -184,8 +208,7 @@
      * @return
      */
     @RequestMapping("/auditPage")
-    public String auditPage( Integer id,
-                                       Model model) {
+    public String auditPage( Integer id,Model model) {
         tDriverService.auditPage(id,model);
         return PREFIX + "tDriverAudit.html";
     }
@@ -203,8 +226,8 @@
      * 佣金跳转详情页面
      */
     @RequestMapping("/commission/driverCommissionDetail")
-    public String driverCommissionDetail(Integer tDriverId, Model model) {
-        tDriverService.driverCommissionDetail(tDriverId,model);
+    public String driverCommissionDetail(Integer tDriverId,Integer levelFlag, Model model) {
+        tDriverService.driverCommissionDetail(tDriverId,levelFlag,model);
         return PREFIX + "tDriverCommissionDetail.html";
     }
 
@@ -236,7 +259,7 @@
 
         // 查询区
         List<Integer> cityIds = tRegions1.stream().map(TRegion::getId).collect(Collectors.toList());
-        List<TRegion> tRegions2 = tRegionService.selectList(new EntityWrapper<TRegion>().in("parent_id", cityIds));
+        List<TRegion> tRegions2 = tRegionService.selectList(new EntityWrapper<TRegion>().in("parent_id", split1[1]));
         model.addAttribute("districtList",tRegions2);
 
         return PREFIX + "tDriverAreaUpdate.html";
@@ -250,15 +273,15 @@
         String[] split1 = areaId.split("/");
         List<TRegion> tRegions = tRegionService.selectList(new EntityWrapper<TRegion>().eq("parent_id", 0));
         model.addAttribute("provinceList",tRegions);
-        List<Integer> provinceIds = tRegions.stream().map(TRegion::getId).collect(Collectors.toList());
-        // 查询市
-        List<TRegion> tRegions1 = tRegionService.selectList(new EntityWrapper<TRegion>().eq("parent_id", split1[0]));
-        model.addAttribute("cityList",tRegions1);
-
-        // 查询区
-        List<Integer> cityIds = tRegions1.stream().map(TRegion::getId).collect(Collectors.toList());
-        List<TRegion> tRegions2 = tRegionService.selectList(new EntityWrapper<TRegion>().in("parent_id", cityIds));
-        model.addAttribute("districtList",tRegions2);
+//        List<Integer> provinceIds = tRegions.stream().map(TRegion::getId).collect(Collectors.toList());
+//        // 查询市
+//        List<TRegion> tRegions1 = tRegionService.selectList(new EntityWrapper<TRegion>().eq("parent_id", split1[0]));
+//        model.addAttribute("cityList",tRegions1);
+//
+//        // 查询区
+//        List<Integer> cityIds = tRegions1.stream().map(TRegion::getId).collect(Collectors.toList());
+//        List<TRegion> tRegions2 = tRegionService.selectList(new EntityWrapper<TRegion>().in("parent_id", cityIds));
+//        model.addAttribute("districtList",tRegions2);
 
         if(StringUtils.hasLength(area) && StringUtils.hasLength(areaId)){
             String[] split = area.split("/");
@@ -277,7 +300,17 @@
             }else {
                 model.addAttribute("districtId", "");
             }
+
+            List<TRegion> tRegions1 = tRegionService.selectList(new EntityWrapper<TRegion>().eq("parent_id", split1[0]));
+            model.addAttribute("cityList",tRegions1);
+
+            // 查询区
+            List<TRegion> tRegions2 = tRegionService.selectList(new EntityWrapper<TRegion>().in("parent_id", split1[1]));
+            model.addAttribute("districtList",tRegions2);
         }else {
+            model.addAttribute("cityList",new ArrayList<>());
+            model.addAttribute("districtList",new ArrayList<>());
+
             model.addAttribute("provinceName","");
             model.addAttribute("cityName","split[1]");
             model.addAttribute("districtName","");
@@ -296,10 +329,33 @@
     @ResponseBody
     public Object list(String createTime,String phone,Integer status) {
         EntityWrapper<TDriver> wrapper = tDriverService.getPageList(createTime,phone,status);
-        wrapper.ne("isException",2);
         wrapper.orderBy("createTime",false);
         List<TDriver> tDrivers = tDriverService.selectList(wrapper);
-        return tDriverService.getTDriverResp(tDrivers);
+        List<TDriverResp> tDriverResp = tDriverService.getTDriverResp(tDrivers);
+        for (TDriverResp driverResp : tDriverResp) {
+            TDriverWork tDriverWork = tDriverWorkService.selectOne(new EntityWrapper<TDriverWork>()
+                    .eq("driverId", driverResp.getId())
+                    .orderBy("workTime", false)
+                    .last("LIMIT 1"));
+            if(Objects.nonNull(tDriverWork)){
+                // 如果是下班状态,计算未上线天数,,如果为上班状态,则设置为0
+                if(tDriverWork.getStatus() == 1){
+                    driverResp.setNotOnlineCount(0);
+                }else {
+                    Period period = Period.between(DateUtil.dateToLocalDate(tDriverWork.getOffWorkTime()), LocalDate.now());
+                    driverResp.setNotOnlineCount(period.getYears()*365 + period.getMonths()*30 + Math.abs(period.getDays()));
+                }
+            }else {
+                if(Objects.nonNull(driverResp.getApprovalTime())){
+                    // 没有上班记录,计算审核时间
+                    Period period = Period.between(DateUtil.dateToLocalDate(driverResp.getApprovalTime()), LocalDate.now());
+                    driverResp.setNotOnlineCount(period.getYears()*365 + period.getMonths()*30 + Math.abs(period.getDays()));
+                }else {
+                    driverResp.setNotOnlineCount(0);
+                }
+            }
+        }
+        return tDriverResp;
     }
     /**
      * 获取佣金列表
@@ -309,7 +365,11 @@
     public Object commissionList(String name,String phone,Integer status) {
         EntityWrapper<TDriver> wrapper = tDriverService.getCommissionPageList(name,phone,status);
         List<TDriver> tDrivers = tDriverService.selectList(wrapper);
-        return tDriverService.getTDriverCommissionResp(tDrivers);
+        List<TDriverCommissionResp> commissionResp = tDriverService.getTDriverCommissionResp(tDrivers);
+        for (TDriverCommissionResp tDriverCommissionResp : commissionResp) {
+            tDriverCommissionResp.setLevelFlag(0);
+        }
+        return commissionResp;
     }
     /**
      * 获取异常列表
@@ -321,7 +381,31 @@
         wrapper.eq("isException",2);
         wrapper.orderBy("createTime",false);
         List<TDriver> tDrivers = tDriverService.selectList(wrapper);
-        return tDriverService.getTDriverResp(tDrivers);
+        List<TDriverResp> tDriverResp = tDriverService.getTDriverResp(tDrivers);
+        for (TDriverResp driverResp : tDriverResp) {
+            TDriverWork tDriverWork = tDriverWorkService.selectOne(new EntityWrapper<TDriverWork>()
+                    .eq("driverId", driverResp.getId())
+                    .orderBy("workTime", false)
+                    .last("LIMIT 1"));
+            if(Objects.nonNull(tDriverWork)){
+                // 如果是下班状态,计算未上线天数,,如果为上班状态,则设置为0
+                if(tDriverWork.getStatus() == 1){
+                    driverResp.setNotOnlineCount(0);
+                }else {
+                    Period period = Period.between(DateUtil.dateToLocalDate(tDriverWork.getOffWorkTime()), LocalDate.now());
+                    driverResp.setNotOnlineCount(period.getYears()*365 + period.getMonths()*30 + Math.abs(period.getDays()));
+                }
+            }else {
+                if(Objects.nonNull(driverResp.getApprovalTime())){
+                    // 没有上班记录,计算审核时间
+                    Period period = Period.between(DateUtil.dateToLocalDate(driverResp.getApprovalTime()), LocalDate.now());
+                    driverResp.setNotOnlineCount(period.getYears()*365 + period.getMonths()*30 + Math.abs(period.getDays()));
+                }else {
+                    driverResp.setNotOnlineCount(0);
+                }
+            }
+        }
+        return tDriverResp;
     }
 
     /**
@@ -329,8 +413,7 @@
      */
     @RequestMapping(value = "/commission/connect/list")
     @ResponseBody
-    public Object commissionConnectList(String driverId) {
-
+    public Object commissionConnectList(String driverId,Integer levelFlag) {
         // 查询当前用户的用户信息
         TDriver tDriver = tDriverService.selectById(driverId);
 
@@ -340,12 +423,30 @@
         }
         wrapper.orderBy("createTime",false);
         List<TDriver> list = tDriverService.selectList(wrapper);
-        List<TDriverCommissionResp> commissionResp = tDriverService.getTDriverCommissionResp(list);
-        for (TDriverCommissionResp tDriverCommissionResp : commissionResp) {
-            if(Objects.nonNull(tDriver)){
-                tDriverCommissionResp.setInviterName(tDriver.getName());
-                tDriverCommissionResp.setInviterPhone(tDriver.getPhone());
+        List<TDriverCommissionResp> commissionResp = new ArrayList<>();
+        try{
+            commissionResp = tDriverService.getTDriverCommissionResp(list);
+            for (TDriverCommissionResp tDriverCommissionResp : commissionResp) {
+                if(Objects.nonNull(tDriver)){
+                    tDriverCommissionResp.setInviterName(tDriver.getName());
+                    tDriverCommissionResp.setInviterPhone(tDriver.getPhone());
+                    if(levelFlag == 0){
+                        tDriverCommissionResp.setLevelFlag(1);
+                        tDriverCommissionResp.setLevel("一级");
+                    }
+                    if(levelFlag == 1){
+                        tDriverCommissionResp.setLevelFlag(2);
+                        tDriverCommissionResp.setLevel("二级");
+                    }
+                    if(levelFlag == 2){
+                        tDriverCommissionResp.setLevelFlag(3);
+                        tDriverCommissionResp.setLevel("三级");
+                    }
+
+                }
             }
+        }catch (Exception e){
+            e.printStackTrace();
         }
         return commissionResp;
     }
@@ -363,7 +464,7 @@
      */
     @RequestMapping(value = "/ocr")
     @ResponseBody
-    public Object ocr(String imgUrl) {
+    public JSONObject ocr(MultipartFile multipartFile) {
         /*String accessToken = redisTemplate.opsForValue().get(TokenUtils.ACCESS_TOKEN_CACHE_KEY);
         if (!StringUtils.hasLength(accessToken)) {
             accessToken = tokenUtils.getSimpleAccessToken();
@@ -374,7 +475,19 @@
         JSONObject jsonObject = JSONObject.parseObject(result);
         System.err.println(jsonObject);
         return jsonObject;*/
-        return tDriverService.ocr(imgUrl);
+        String originalFilename = multipartFile.getOriginalFilename();
+        String[] filename = originalFilename.split("\\.");
+        log.info("tupian::"+filename[0]+"//"+filename[1]);
+        File file= null;
+        try {
+            file = File.createTempFile(filename[0], "."+filename[1]);
+            multipartFile.transferTo(file);
+            file.deleteOnExit();
+            log.info("file:"+file.getName());
+        } catch (IOException e) {
+            log.error("ocr识别失败:{}",e.getMessage());
+        }
+        return tDriverService.ocr(file);
     }
 
     /**
@@ -392,6 +505,28 @@
         tDriver.setApprovalUserId(shiroUser.getId());
         tDriver.setApprovalTime(new Date());
         tDriverService.updateById(tDriver);
+
+        //增加积分奖励
+        if(approvalStatus == 2 &&  null != tDriver.getInviterId()){
+            TSystemConfig systemConfig = systemConfigService.selectOne(new EntityWrapper<TSystemConfig>().eq("type", 4));
+            Integer num7 = JSON.parseObject(systemConfig.getContent()).getInteger("num7");
+            TDriver tDriver1 = tDriverService.selectById(tDriver.getInviterId());
+
+            AccountChangeDetail accountChangeDetail = new AccountChangeDetail();
+            accountChangeDetail.setCode(System.currentTimeMillis() + UUIDUtil.getNumberRandom(3));
+            accountChangeDetail.setUserType(2);
+            accountChangeDetail.setUserId(tDriver1.getId());
+            accountChangeDetail.setType(2);
+            accountChangeDetail.setChangeType(10);
+            accountChangeDetail.setOldData(tDriver1.getIntegral().doubleValue());
+            tDriver1.setIntegral(tDriver1.getIntegral() + num7);
+            accountChangeDetail.setNewData(tDriver1.getIntegral().doubleValue());
+            accountChangeDetail.setExplain("推荐奖励");
+            accountChangeDetail.setCreateTime(new Date());
+            accountChangeDetailMapper.insert(accountChangeDetail);
+            tDriverService.updateById(tDriver1);
+        }
+
         return SUCCESS_TIP;
     }
 
@@ -411,6 +546,8 @@
             return o;
         }
         // 默认值板块
+        tDriver.setName(tDriver.getName().replace(" ",""));
+        tDriver.setEmergencyContact(tDriver.getEmergencyContact().replace(" ",""));
         tDriver.setCode(UUIDUtil.getNumberRandom(16));
         tDriver.setBalance(BigDecimal.ZERO);
         tDriver.setBackgroundBalance(BigDecimal.ZERO);
@@ -439,6 +576,19 @@
         TDriver tDriver = tDriverService.selectById(id);
         if(1 == status){
             tDriver.setStatus(2);
+            String value = redisUtil.getValue("DRIVER_" + tDriver.getPhone());
+            redisUtil.remove(value);
+            redisUtil.remove("DRIVER_" + tDriver.getPhone());
+            TDriverWork tDriverWork = tDriverWorkService.selectOne(new EntityWrapper<TDriverWork>()
+                    .eq("driverId", tDriver.getId())
+                    .eq("status", 1)
+                    .orderBy("workTime", false)
+                    .last("LIMIT 1"));
+            if(Objects.nonNull(tDriverWork)){
+                tDriverWork.setStatus(2);
+                tDriverWork.setOffWorkTime(new Date());
+                tDriverWorkService.updateById(tDriverWork);
+            }
         }
         if(2 == status){
             tDriver.setStatus(1);
@@ -470,7 +620,8 @@
         tRechargeRecord.setPayTime(new Date());
         tRechargeRecord.setPayStatus(2);
         tRechargeRecord.setCreateTime(new Date());
-        tRechargeRecord.setAgentId(Objects.requireNonNull(ShiroKit.getUser()).getId());
+        Integer id1 = Objects.requireNonNull(ShiroKit.getUser()).getObjectId();
+        tRechargeRecord.setAgentId(id1);
         tRechargeRecordService.insert(tRechargeRecord);
         return SUCCESS_TIP;
     }
@@ -492,6 +643,8 @@
         if(Objects.nonNull(o)){
             return o;
         }
+        tDriver.setName(tDriver.getName().replace(" ",""));
+        tDriver.setEmergencyContact(tDriver.getEmergencyContact().replace(" ",""));
         tDriverService.updateById(tDriver);
         return SUCCESS_TIP;
     }
@@ -536,12 +689,11 @@
             String time1 = format.format(date);
             String fileName = "DriverInfo"+time1+".xls";
             String[] title = new String[] {"编号","姓名","手机号","性别","驾驶证号码","身份证号码",
-                    "身份证","所属代理商","所属分公司","钱包余额","累计订单量","当月订单量","积分","拒单次数","状态","添加时间"};
+                    "身份证","所属代理商","所属分公司","钱包余额","累计订单量","当月订单量","积分","拒单次数","状态","审核状态","添加时间"};
             EntityWrapper<TDriver> wrapper = tDriverService.getPageList(createTime,phone,status);
-            // 是否异常
-            List<TDriver> list = tDriverService.selectList(wrapper);
-
-            List<TDriverResp> tDriverResp = tDriverService.getTDriverResp(list);
+            wrapper.orderBy("createTime",false);
+            List<TDriver> tDrivers = tDriverService.selectList(wrapper);
+            List<TDriverResp> tDriverResp = tDriverService.getTDriverResp(tDrivers);
 
             String[][] values = new String[tDriverResp.size()][];
             for (int i = 0; i < tDriverResp.size(); i++) {
@@ -580,7 +732,15 @@
                 }else {
                     values[i][14] = "删除";
                 }
-                values[i][15] = new SimpleDateFormat("yyyy/MM/dd HH:mm:ss").format(d.getCreateTime());
+                Integer approvalStatus = d.getApprovalStatus();
+                if(1 == approvalStatus){
+                    values[i][15] = "待审核";
+                }else if(2 == approvalStatus){
+                    values[i][15] = "已同意";
+                }else {
+                    values[i][15] = "已拒绝";
+                }
+                values[i][16] = new SimpleDateFormat("yyyy/MM/dd HH:mm:ss").format(d.getCreateTime());
             }
             HSSFWorkbook wb = ExcelUtil.getHSSFWorkbook("Variance"+time1, title, values, null);
             ExcelUtil.setResponseHeader(response, fileName);
@@ -609,10 +769,28 @@
                     "身份证","累计订单量","当月订单量","积分","连续未上线(天)","状态","添加时间"};
             EntityWrapper<TDriver> wrapper = tDriverService.getPageList(createTime,phone,status);
             wrapper.eq("isException",2);
-            // 是否异常
-            List<TDriver> list = tDriverService.selectList(wrapper);
-
-            List<TDriverResp> tDriverResp = tDriverService.getTDriverResp(list);
+            wrapper.orderBy("createTime",false);
+            List<TDriver> tDrivers = tDriverService.selectList(wrapper);
+            List<TDriverResp> tDriverResp = tDriverService.getTDriverResp(tDrivers);
+            for (TDriverResp driverResp : tDriverResp) {
+                TDriverWork tDriverWork = tDriverWorkService.selectOne(new EntityWrapper<TDriverWork>()
+                        .eq("driverId", driverResp.getId())
+                        .orderBy("workTime", false)
+                        .last("LIMIT 1"));
+                if(Objects.nonNull(tDriverWork)){
+                    // 如果是下班状态,计算未上线天数,,如果为上班状态,则设置为0
+                    if(tDriverWork.getStatus() == 1){
+                        driverResp.setNotOnlineCount(0);
+                    }else {
+                        Period period = Period.between(DateUtil.dateToLocalDate(tDriverWork.getOffWorkTime()), LocalDate.now());
+                        driverResp.setNotOnlineCount(Math.abs(period.getDays()));
+                    }
+                }else {
+                    // 没有上班记录,计算审核时间
+                    Period period = Period.between(DateUtil.dateToLocalDate(driverResp.getApprovalTime()), LocalDate.now());
+                    driverResp.setNotOnlineCount(Math.abs(period.getDays()));
+                }
+            }
 
             String[][] values = new String[tDriverResp.size()][];
             for (int i = 0; i < tDriverResp.size(); i++) {
@@ -653,7 +831,7 @@
             e.printStackTrace();
         }
     }
-    @ApiOperation(value = "导出司机异常列表",notes="导出司机异常列表")
+    @ApiOperation(value = "导出司机佣金列表",notes="导出司机佣金列表")
     @ApiImplicitParams({
             @ApiImplicitParam(name = "Authorization", value = "用户token(Bearer +token)", required = true, dataType = "String", paramType = "header", defaultValue = "Bearer eyJhbGciOiJIUzUxMiJ9....."),
     })

--
Gitblit v1.7.1