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