From c12019a820f2b06cf7aae214e1e5dd70f623d1ac Mon Sep 17 00:00:00 2001 From: xuhy <3313886187@qq.com> Date: 星期五, 10 三月 2023 18:15:21 +0800 Subject: [PATCH] 财务管理 --- management/guns-admin/src/main/java/com/stylefeng/guns/modular/system/service/impl/TDriverServiceImpl.java | 295 ++++++++++++++++++++++++++++++++++++++++++++++++++++++---- 1 files changed, 271 insertions(+), 24 deletions(-) diff --git a/management/guns-admin/src/main/java/com/stylefeng/guns/modular/system/service/impl/TDriverServiceImpl.java b/management/guns-admin/src/main/java/com/stylefeng/guns/modular/system/service/impl/TDriverServiceImpl.java index 65a23b0..ad9e895 100644 --- a/management/guns-admin/src/main/java/com/stylefeng/guns/modular/system/service/impl/TDriverServiceImpl.java +++ b/management/guns-admin/src/main/java/com/stylefeng/guns/modular/system/service/impl/TDriverServiceImpl.java @@ -1,13 +1,20 @@ package com.stylefeng.guns.modular.system.service.impl; +import com.alibaba.fastjson.JSONObject; import com.baomidou.mybatisplus.mapper.EntityWrapper; +import com.stylefeng.guns.core.base.tips.SuccessTip; +import com.stylefeng.guns.core.shiro.ShiroKit; import com.stylefeng.guns.core.util.DateUtil; +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.HttpUtils; +import com.stylefeng.guns.modular.system.controller.util.UUIDUtil; import com.stylefeng.guns.modular.system.dao.*; import com.stylefeng.guns.modular.system.enums.OrderStateEnum; import com.stylefeng.guns.modular.system.model.*; import com.stylefeng.guns.modular.system.service.ITDriverService; import com.baomidou.mybatisplus.service.impl.ServiceImpl; +import com.stylefeng.guns.modular.system.service.ITRegionService; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; @@ -15,6 +22,8 @@ import org.springframework.util.CollectionUtils; import org.springframework.util.StringUtils; +import java.io.File; +import java.math.BigDecimal; import java.text.SimpleDateFormat; import java.time.LocalDate; import java.time.Period; @@ -23,6 +32,7 @@ import java.util.Date; import java.util.List; import java.util.Objects; +import java.util.concurrent.atomic.AtomicInteger; import java.util.stream.Collectors; /** @@ -49,6 +59,12 @@ private TAppUserMapper tAppUserMapper; @Autowired private TOrderRefusalMapper tOrderRefusalMapper; + @Autowired + private TRegionMapper tRegionMapper; + @Autowired + private ITRegionService itRegionService; + @Autowired + private HttpUtils httpUtils; @Override public EntityWrapper<TDriver> getPageList(String createTime, String phone, Integer status) { @@ -69,6 +85,15 @@ wrapper.between("createTime",startTime,endTime); } wrapper.orderBy(true,"approvalStatus"); + // 判断是否为代理商或者分公司 + if(Objects.requireNonNull(ShiroKit.getUser()).getRoleType() == 2){ + // 分公司 + wrapper.eq("branchOfficeId",ShiroKit.getUser().getObjectId()); + } + if(Objects.requireNonNull(ShiroKit.getUser()).getRoleType() == 3){ + // 代理商 + wrapper.eq("agentId",ShiroKit.getUser().getObjectId()); + } return wrapper; } @@ -84,8 +109,10 @@ TDriverResp tDriverResp = new TDriverResp(); BeanUtils.copyProperties(tDriver,tDriverResp); - // 设置余额 - tDriverResp.setBalance(tDriver.getBackgroundBalance().add(tDriver.getBalance())); + if(Objects.nonNull(tDriver.getBackgroundBalance()) && Objects.nonNull(tDriver.getBalance())){ + // 设置余额 + tDriverResp.setBalance(tDriver.getBackgroundBalance().add(tDriver.getBalance())); + } // 所属代理商 TAgent tAgent = tAgentMapper.selectById(tDriver.getAgentId()); @@ -98,11 +125,11 @@ tDriverResp.setBranchName(tBranchOffice.getPrincipal()); } //累计订单量 - List<TOrder> cumulativeOrderCount = tOrders.stream().filter(order -> order.getDriverId().equals(tDriver.getId()) + List<TOrder> cumulativeOrderCount = tOrders.stream().filter(order -> tDriver.getId().equals(order.getDriverId()) && order.getState().equals(OrderStateEnum.WAIT_EVALUATED.getCode()) && order.getState().equals(OrderStateEnum.FINISH.getCode())).collect(Collectors.toList()); tDriverResp.setCumulativeOrderCount(cumulativeOrderCount.size()); //当月订单量 - List<TOrder> monthOrderCount = tOrders.stream().filter(order -> order.getDriverId().equals(tDriver.getId()) + List<TOrder> monthOrderCount = tOrders.stream().filter(order -> tDriver.getId().equals(order.getDriverId()) && order.getState().equals(OrderStateEnum.WAIT_EVALUATED.getCode()) && order.getState().equals(OrderStateEnum.FINISH.getCode()) && new SimpleDateFormat("yyyyMM").format(order.getCreateTime()).equals(monthDate)).collect(Collectors.toList()); tDriverResp.setMonthOrderCount(monthOrderCount.size()); @@ -123,6 +150,7 @@ model.addAttribute("id",tDriver.getId()); model.addAttribute("code",tDriver.getCode()); model.addAttribute("name",tDriver.getName()); + model.addAttribute("avatar",tDriver.getAvatar()); model.addAttribute("phone",tDriver.getPhone()); model.addAttribute("sex",tDriver.getSex()); model.addAttribute("driverLicenseNumber",tDriver.getDriverLicenseNumber()); @@ -135,6 +163,8 @@ model.addAttribute("provinceName",tDriver.getProvinceName()); model.addAttribute("cityName",tDriver.getCityName()); model.addAttribute("areaName",tDriver.getAreaName()); + model.addAttribute("integral",tDriver.getIntegral()); + model.addAttribute("score",tDriver.getScore()); model.addAttribute("createTime",new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(tDriver.getCreateTime())); // 计算驾龄 @@ -152,8 +182,13 @@ String monthDate = new SimpleDateFormat("yyyyMM").format(new Date()); - // 设置余额 - tDriver.setBalance(tDriver.getBackgroundBalance().add(tDriver.getBalance())); + if(Objects.nonNull(tDriver.getBackgroundBalance()) && Objects.nonNull(tDriver.getBalance())){ + // 设置余额 + tDriver.setBalance(tDriver.getBackgroundBalance().add(tDriver.getBalance())); + model.addAttribute("balance",tDriver.getBalance()); + }else { + model.addAttribute("balance",BigDecimal.ZERO); + } // 所属代理商 TAgent tAgent = tAgentMapper.selectById(tDriver.getAgentId()); @@ -170,18 +205,30 @@ model.addAttribute("principal",""); } - // 查询邀请人 - if(Objects.nonNull(tDriver.getInviterType()) && 1 == tDriver.getInviterType()){ - TAppUser tAppUser = tAppUserMapper.selectById(tDriver.getInviterId()); - model.addAttribute("inviterName",tAppUser.getNickname()); - model.addAttribute("inviterPhone",tAppUser.getPhone()); - }else if(Objects.nonNull(tDriver.getInviterType()) && 2 == tDriver.getInviterType()){ - TDriver tDriver1 = tDriverMapper.selectById(tDriver.getInviterId()); - model.addAttribute("inviterName",tDriver1.getName()); - model.addAttribute("inviterPhone",tDriver1.getPhone()); + if(Objects.nonNull(tDriver.getInviterId())){ + // 查询邀请人 + if(Objects.nonNull(tDriver.getInviterType()) && 1 == tDriver.getInviterType()){ + TAppUser tAppUser = tAppUserMapper.selectById(tDriver.getInviterId()); + model.addAttribute("inviterName",tAppUser.getNickname()); + model.addAttribute("inviterPhone",tAppUser.getPhone()); + }else if(Objects.nonNull(tDriver.getInviterType()) && 2 == tDriver.getInviterType()){ + TDriver tDriver1 = tDriverMapper.selectById(tDriver.getInviterId()); + model.addAttribute("inviterName",tDriver1.getName()); + model.addAttribute("inviterPhone",tDriver1.getPhone()); + }else { + model.addAttribute("inviterName",""); + model.addAttribute("inviterPhone",""); + } + } + + // 查询当前用户邀请了哪些人 + List<TDriver> list = tDriverMapper.selectList(new EntityWrapper<TDriver>().eq("inviterId", tDriver.getId())); + if(!CollectionUtils.isEmpty(list)){ + model.addAttribute("inviterCount",list.size()); + model.addAttribute("inviterCommission",0); }else { - model.addAttribute("inviterName",""); - model.addAttribute("inviterPhone",""); + model.addAttribute("inviterCommission",0); + model.addAttribute("inviterCount",0); } if(!CollectionUtils.isEmpty(tOrders)){ @@ -197,17 +244,217 @@ // 拒单次数 List<TOrderRefusal> driverRefusalList = tOrderRefusalMapper.selectList(new EntityWrapper<TOrderRefusal>().eq("driver_id", tDriver.getId())); model.addAttribute("refusalCount",driverRefusalList.size()); + // todo 累计收入 + model.addAttribute("cumulativeIncome",0); }else { - model.addAttribute("cumulativeOrderCount",""); - model.addAttribute("monthOrderCount",""); - model.addAttribute("refusalCount",""); + model.addAttribute("cumulativeOrderCount",0); + model.addAttribute("monthOrderCount",0); + model.addAttribute("refusalCount",0); + // 累计收入 + model.addAttribute("cumulativeIncome",0); } } @Override - public void detail(Integer tDriverId, Model model) { - auditPage(tDriverId,model); - // TODO 查询司机 - TDriver tDriver = tDriverMapper.selectById(tDriverId); + public JSONObject ocr(String imgUrl) { + File file = new File(imgUrl); + String result = httpUtils.ocr("2", file); + JSONObject jsonObject = JSONObject.parseObject(result); + return jsonObject; + } + + @Override + public Object addOrUpdate(TDriver tDriver) { + // 对省市区做处理 + String[] split = tDriver.getAreaId().split("/"); + // 查询省市 + // 黑龙江省/大兴安岭地区 + // 702/852 + TRegion province = tRegionMapper.selectById(split[0]); + tDriver.setProvinceName(province.getName()); + tDriver.setProvinceCode(province.getCode()); + + TRegion city = tRegionMapper.selectById(split[1]); + if(Objects.isNull(city)){ + city = itRegionService.selectOne(new EntityWrapper<TRegion>().eq("name",split[1])); + } + tDriver.setCityName(city.getName()); + tDriver.setCityCode(city.getCode()); + + TRegion area = tRegionMapper.selectById(split[2]); + if(Objects.isNull(area)){ + area = itRegionService.selectOne(new EntityWrapper<TRegion>().eq("name",split[2])); + } + tDriver.setAreaName(area.getName()); + tDriver.setAreaCode(area.getCode()); + + // 通过省市查询代理商 + List<TAgent> tAgent = tAgentMapper.selectList(new EntityWrapper<TAgent>().eq("provinceCode", province.getCode()) + .eq("cityCode", city.getCode()) + .eq("status", 1) + .last("LIMIT 1")); + if(!CollectionUtils.isEmpty(tAgent)){ + tDriver.setAgentId(tAgent.get(0).getId()); + }else { + return new SuccessTip(500, "该区域代理商被冻结或不存在"); + } + if(StringUtils.hasLength(tDriver.getInviterPhone())){ + // 查询邀约人(司机端) + List<TDriver> emergencyDriver = tDriverMapper.selectList(new EntityWrapper<TDriver>().eq("phone", tDriver.getInviterPhone()) + .last("LIMIT 1")); + if(!CollectionUtils.isEmpty(emergencyDriver)){ + tDriver.setInviterId(emergencyDriver.get(0).getId()); + tDriver.setInviterType(2); + }else { + return new SuccessTip(500, "该邀约人:"+tDriver.getInviterName()+"不存在"); + } + } + // 通过省市区查询分公司 + List<TBranchOffice> tBranchOffice = tBranchOfficeMapper.selectList(new EntityWrapper<TBranchOffice>().eq("provinceCode", province.getCode()) + .eq("cityCode", city.getCode()) + .eq("status", 1) + .eq("districtCode", area.getCode()) + .last("LIMIT 1")); + if(!CollectionUtils.isEmpty(tBranchOffice)){ + tDriver.setBranchOfficeId(tBranchOffice.get(0).getId()); + }else { + return new SuccessTip(500, "该区域分公司被冻结或不存在"); + } + + // ocr识别 +// JSONObject ocr = this.ocr("E:\\071bf986db0b00355c0ed190bbd3b16.png"); +// System.err.println(ocr); + return null; + } + + @Override + public EntityWrapper<TDriver> getCommissionPageList(String name, String phone, Integer status) { + EntityWrapper<TDriver> wrapper = new EntityWrapper<>(); + // 手机号 + if(StringUtils.hasLength(phone)){ + wrapper.like("phone",phone); + } + // 状态 + if(Objects.nonNull(status)){ + wrapper.eq("status",status); + } + // 姓名 + if(StringUtils.hasLength(name)){ + wrapper.like("name",name); + } + wrapper.orderBy(true,"approvalStatus"); + // 判断是否为代理商或者分公司 + if(Objects.requireNonNull(ShiroKit.getUser()).getRoleType() == 2){ + // 分公司 + wrapper.eq("branchOfficeId",ShiroKit.getUser().getObjectId()); + } + if(Objects.requireNonNull(ShiroKit.getUser()).getRoleType() == 3){ + // 代理商 + wrapper.eq("agentId",ShiroKit.getUser().getObjectId()); + } + return wrapper; + } + + @Override + public List<TDriverCommissionResp> getTDriverCommissionResp(List<TDriver> drivers) { + List<TDriverCommissionResp> commissionRespList = new ArrayList<>(drivers.size()); + for (TDriver driver : drivers) { + TDriverCommissionResp commissionResp = new TDriverCommissionResp(); + BeanUtils.copyProperties(driver,commissionResp); + + // 查询代理商 + // 所属代理商 + TAgent tAgent = tAgentMapper.selectById(driver.getAgentId()); + if(Objects.nonNull(tAgent)){ + commissionResp.setAgentName(tAgent.getPrincipal()); + } + + // 关联人数 + AtomicInteger connectedPersons = new AtomicInteger(0); + + List<TDriver> inviterTwoList = tDriverMapper.selectList(new EntityWrapper<TDriver>().eq("inviterId", driver.getId())); + if(!CollectionUtils.isEmpty(inviterTwoList)){ + // 推广人数 + commissionResp.setNumberPromoters(inviterTwoList.size()); + List<Integer> inviterTwoIds = inviterTwoList.stream().map(TDriver::getId).collect(Collectors.toList()); + connectedPersons.addAndGet(inviterTwoList.size()); + // 查询三级 + List<TDriver> inviterThreeList = tDriverMapper.selectList(new EntityWrapper<TDriver>().in("inviterId", inviterTwoIds)); + if(!CollectionUtils.isEmpty(inviterThreeList)){ + List<Integer> inviterThreeIds = inviterThreeList.stream().map(TDriver::getId).collect(Collectors.toList()); + connectedPersons.addAndGet(inviterThreeList.size()); + // 查询四级 + List<TDriver> inviterFourList = tDriverMapper.selectList(new EntityWrapper<TDriver>().in("inviterId", inviterThreeIds)); + connectedPersons.addAndGet(inviterFourList.size()); + + } + } + + commissionResp.setConnectedPersons(connectedPersons.get()); + + // 已提现佣金 查询该司机的佣金提现记录 + commissionResp.setWithdrawnAmount(BigDecimal.ZERO); + + // 累计佣金 可提现佣金+已提现佣金 + commissionResp.setAccumulatedCommission(BigDecimal.ZERO); + + commissionRespList.add(commissionResp); + + } + return commissionRespList; + } + + @Override + public void driverCommissionDetail(Integer tDriverId, Model model) { + + // 查询司机 + TDriver driver = tDriverMapper.selectById(tDriverId); + + // 司机信息封装 + model.addAttribute("driverId",tDriverId); + model.addAttribute("name",driver.getName()); + model.addAttribute("phone",driver.getPhone()); + model.addAttribute("sex",driver.getSex()); + model.addAttribute("status",driver.getStatus()); + model.addAttribute("commission",driver.getCommission()); + model.addAttribute("startTimeToEndTime",new SimpleDateFormat("yyyy-MM-dd").format(driver.getCreateTime()).replace("-",".")+"-"+ + new SimpleDateFormat("yyyy-MM-dd").format(new Date()).replace("-",".")); + + // 所属代理商 + TAgent tAgent = tAgentMapper.selectById(driver.getAgentId()); + if(Objects.nonNull(tAgent)){ + model.addAttribute("agentName",tAgent.getPrincipal()); + }else { + model.addAttribute("agentName",""); + } + + // 关联人数 + AtomicInteger connectedPersons = new AtomicInteger(0); + // 推广人数 + List<TDriver> inviterTwoList = tDriverMapper.selectList(new EntityWrapper<TDriver>().eq("inviterId", driver.getId())); + if(!CollectionUtils.isEmpty(inviterTwoList)){ + model.addAttribute("numberPromoters",inviterTwoList.size()); + List<Integer> inviterTwoIds = inviterTwoList.stream().map(TDriver::getId).collect(Collectors.toList()); + connectedPersons.addAndGet(inviterTwoList.size()); + // 查询三级 + List<TDriver> inviterThreeList = tDriverMapper.selectList(new EntityWrapper<TDriver>().in("inviterId", inviterTwoIds)); + if(!CollectionUtils.isEmpty(inviterThreeList)){ + List<Integer> inviterThreeIds = inviterThreeList.stream().map(TDriver::getId).collect(Collectors.toList()); + connectedPersons.addAndGet(inviterThreeList.size()); + // 查询四级 + List<TDriver> inviterFourList = tDriverMapper.selectList(new EntityWrapper<TDriver>().in("inviterId", inviterThreeIds)); + connectedPersons.addAndGet(inviterFourList.size()); + } + }else { + model.addAttribute("numberPromoters",0); + } + model.addAttribute("connectedPersons",connectedPersons.get()); + // 已提现佣金 查询该司机的佣金提现记录 + model.addAttribute("withdrawnAmount",BigDecimal.ZERO); +// commissionResp.setWithdrawnAmount(BigDecimal.ZERO); + // 累计佣金 可提现佣金+已提现佣金 + model.addAttribute("accumulatedCommission",BigDecimal.ZERO); +// commissionResp.setAccumulatedCommission(BigDecimal.ZERO); + } } -- Gitblit v1.7.1