package com.ruoyi.system.service.impl; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.toolkit.Wrappers; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.ruoyi.common.basic.PageInfo; import com.ruoyi.common.constant.Constants; import com.ruoyi.common.constant.OrderNumConstants; import com.ruoyi.common.core.redis.RedisCache; import com.ruoyi.common.exception.ServiceException; import com.ruoyi.common.utils.CodeGenerateUtils; import com.ruoyi.common.utils.DateUtils; import com.ruoyi.system.domain.*; import com.ruoyi.system.dto.OrderMealGeneratorCountDTO; import com.ruoyi.system.dto.OrderMealGeneratorDTO; import com.ruoyi.system.dto.OrderSaleGeneratorDTO; import com.ruoyi.system.mapper.TDataGeneratorMapper; import com.ruoyi.system.query.*; import com.ruoyi.system.service.*; import com.ruoyi.system.vo.*; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Propagation; import org.springframework.transaction.annotation.Transactional; import org.springframework.util.CollectionUtils; import java.math.BigDecimal; import java.math.RoundingMode; import java.text.ParseException; import java.text.SimpleDateFormat; import java.time.LocalDate; import java.util.*; import java.util.stream.Collectors; /** *

* 营业数据生成 服务实现类 *

* * @author xiaochen * @since 2024-08-27 */ @Service public class TDataGeneratorServiceImpl extends ServiceImpl implements TDataGeneratorService { @Autowired private TBoardService boardService; @Autowired private TFoundationConfigService foundationConfigService; @Autowired private TFoundationPersonService foundationPersonService; @Autowired private TGoodsService goodsService; @Autowired private TOrderMealService orderMealService; @Autowired private TOrderMealGoodsService orderMealGoodsService; @Autowired private TOrderSaleService orderSaleService; @Autowired private TOrderSaleGoodsService orderSaleGoodsService; @Autowired private TOrderStockService orderStockService; @Autowired private TOrderStockGoodsService orderStockGoodsService; @Autowired private TStockDataSetService stockDataSetService; @Autowired private TGoodsTypeService goodsTypeService; @Autowired private TShopService shopService; @Autowired private RedisCache redisCache; @Transactional(rollbackFor = Exception.class,propagation = Propagation.REQUIRED) @Override public void mealDataGenerator(OrderMealGeneratorDTO dto) { // 存储数据生成数据 TDataGenerator dataGenerator = new TDataGenerator(); dataGenerator.setUserId(dto.getUserId()); dataGenerator.setUserName(dto.getNickName()); dataGenerator.setShopId(dto.getShopId()); dataGenerator.setStartTime(dto.getStartTime()); dataGenerator.setEndTime(dto.getEndTime()); dataGenerator.setMinMoney(dto.getMinMoney()); dataGenerator.setMaxMoney(dto.getMaxMoney()); dataGenerator.setStatus(2); dataGenerator.setOrderType(1); dataGenerator.setWeiXinPay(dto.getWeiXinProportion()); dataGenerator.setAliPay(dto.getAliProportion()); dataGenerator.setCardPay(dto.getCardProportion()); dataGenerator.setMoneyPay(dto.getMoneyProportion()); dataGenerator.setOtherPay(dto.getOtherProportion()); this.save(dataGenerator); long start = System.currentTimeMillis(); TShop shop = shopService.getById(dto.getShopId()); List foundationConfigs = foundationConfigService.getList(shop.getMealType()); if(CollectionUtils.isEmpty(foundationConfigs)){ throw new ServiceException("请先添加中餐或火锅用餐标准"); } // 查询所有桌子 List boards = boardService.list(Wrappers.lambdaQuery(TBoard.class) .eq(TBoard::getShopId,dto.getShopId())); if(CollectionUtils.isEmpty(boards)){ throw new ServiceException("请先添加该店铺桌台信息"); } // 查询所有菜品 List goods = goodsService.list(Wrappers.lambdaQuery(TGoods.class) .eq(TGoods::getShopId,dto.getShopId())); if(CollectionUtils.isEmpty(goods)){ throw new ServiceException("请先添加该店铺菜品信息"); } // 循环待生成订单列表,添加到集合中,批量插入 List orderMealGeneratorCountDTOS = dto.getOrderMealGeneratorCountDTOS(); List orderMeals = new ArrayList<>(); for (OrderMealGeneratorCountDTO orderMealGeneratorCountDTO : orderMealGeneratorCountDTOS) { TBoard board = boards.stream().filter(e -> e.getId().equals(orderMealGeneratorCountDTO.getBoardId())).findFirst().orElse(null); if(Objects.isNull(board)){ throw new ServiceException("该桌台信息不存在"); } Integer orderCount = orderMealGeneratorCountDTO.getOrderCount(); if(orderCount == 0){ continue; } // 查询当前桌的用餐人数 for (int i = 1; i <= orderCount; i++) { int random = getRandom(board.getMinPerson(), board.getMaxPerson()); TOrderMeal orderMeal = new TOrderMeal(); orderMeal.setBoardId(board.getId()); orderMeal.setMealType(1); orderMeal.setMealPerson(random); orderMeal.setMealTime(orderMealGeneratorCountDTO.getTime()); String num = OrderNumConstants.MEAL + CodeGenerateUtils.generateVolumeSn(); // long count1 = orderMealService.count(Wrappers.lambdaQuery(TOrderMeal.class) // .eq(TOrderMeal::getOrderNum, num)); // if(count1>0){ // num = CodeGenerateUtils.generateVolumeSn(); // } orderMeal.setOrderNum(num); orderMeal.setStatus(2); List orderMealGoods = new ArrayList<>(); // 获取当前桌的菜品 List foundationConfigVOS = foundationConfigs.stream().filter(e -> e.getMealCount().equals(random)).collect(Collectors.toList()); if(CollectionUtils.isEmpty(foundationConfigVOS)){ throw new ServiceException("桌台"+random+"人餐,人数配置不存在"); } // 每种菜品分类需要几个菜的生成 foundationConfigVOS.forEach(e -> { int random1 = getRandom(e.getMinCount(), e.getMaxCount()); List typeGoodsList = goods.stream().filter(m -> e.getTypeId().equals(m.getTypeId())).collect(Collectors.toList()); List typeGoods = randomSelection(typeGoodsList, random1); if(typeGoods.size() != random1){ List goods1 = randomSelection(typeGoodsList, random1 - typeGoods.size()); typeGoods.addAll(goods1); } for (TGoods typeGood : typeGoods) { int count = 0; for (TOrderMealGoods good : orderMealGoods) { if (good.getGoodsNum().equals(typeGood.getGoodsNum())) { count+=1; good.setGoodsCount(good.getGoodsCount() + 1); // good.setGoodsSalePrice(good.getGoodsSalePrice().add(typeGood.getSalePrice())); break; // 找到后直接跳出循环 } } if (count==0) { TOrderMealGoods tOrderMealGoods = new TOrderMealGoods(); tOrderMealGoods.setGoodsNum(typeGood.getGoodsNum()); tOrderMealGoods.setGoodsName(typeGood.getGoodsName()); tOrderMealGoods.setGoodsPicture(typeGood.getGoodsPicture()); tOrderMealGoods.setGoodsSalePrice(typeGood.getSalePrice()); tOrderMealGoods.setGoodsCount(1); tOrderMealGoods.setTypeId(typeGood.getTypeId()); tOrderMealGoods.setGoodsId(typeGood.getId()); orderMealGoods.add(tOrderMealGoods); } } }); if(!CollectionUtils.isEmpty(orderMealGoods)){ orderMeal.setMealOrderGoods(orderMealGoods); orderMeal.setOrderMoney(orderMealGoods.stream().map(good->good.getGoodsSalePrice().multiply(new BigDecimal(good.getGoodsCount()))).reduce(BigDecimal::add).get()); orderMeal.setPayMoney(orderMealGoods.stream().map(good->good.getGoodsSalePrice().multiply(new BigDecimal(good.getGoodsCount()))).reduce(BigDecimal::add).get()); orderMeals.add(orderMeal); } } } BigDecimal sumMoney = orderMeals.stream().map(TOrderMeal::getPayMoney).reduce(BigDecimal::add).get(); if(sumMoney.compareTo(dto.getMinMoney()) >= 0 && sumMoney.compareTo(dto.getMaxMoney()) <= 0){ int weiXin = getRandomPayType(orderMeals.size(), dto.getWeiXinProportion()); int ali = getRandomPayType(orderMeals.size(), dto.getAliProportion()); int card = getRandomPayType(orderMeals.size(), dto.getCardProportion()); int money = getRandomPayType(orderMeals.size(), dto.getMoneyProportion()); int other = getRandomPayType(orderMeals.size(), dto.getOtherProportion()); switch (orderMeals.size()-(weiXin+ali+card+money+other)){ case 1: weiXin += 1; break; case 2: weiXin += 1; ali += 1; break; case 3: weiXin += 1; ali += 1; card += 1; break; case 4: weiXin += 1; ali += 1; card += 1; money += 1; break; case 5: weiXin += 1; ali += 1; card += 1; money += 1; other += 1; break; } List weiXinOrderMeals = orderMeals.subList(0, weiXin); List aliOrderMeals = orderMeals.subList(weiXin, weiXin+ali); List cardOrderMeals = orderMeals.subList(weiXin+ali, weiXin+ali+card); List moneyOrderMeals = orderMeals.subList(weiXin+ali+card, weiXin+ali+card+money); List otherOrderMeals = orderMeals.subList(weiXin+ali+card+money, weiXin+ali+card+money+other); weiXinOrderMeals.forEach(e->e.setPayType(3)); aliOrderMeals.forEach(e->e.setPayType(2)); cardOrderMeals.forEach(e->e.setPayType(4)); moneyOrderMeals.forEach(e->e.setPayType(1)); otherOrderMeals.forEach(e->e.setPayType(5)); List allOrderMeals = new ArrayList<>(); allOrderMeals.addAll(weiXinOrderMeals); allOrderMeals.addAll(aliOrderMeals); allOrderMeals.addAll(cardOrderMeals); allOrderMeals.addAll(moneyOrderMeals); allOrderMeals.addAll(otherOrderMeals); allOrderMeals.forEach(e->{ e.setIsCover(0); e.setShopId(dataGenerator.getShopId()); e.setGeneratorId(dataGenerator.getId()); }); // 判断是否进行了终止操作 if(redisCache.hasKey(OrderNumConstants.MEAL+"_"+dto.getShopId())){ redisCache.deleteObject(OrderNumConstants.MEAL+"_"+dto.getShopId()); return; } orderMealService.saveBatch(allOrderMeals); for (TOrderMeal orderMeal : allOrderMeals) { orderMeal.getMealOrderGoods().forEach(e->e.setOrderId(orderMeal.getId())); } List list = goodsTypeService.list(); List collect = allOrderMeals.stream().map(TOrderMeal::getMealOrderGoods).flatMap(Collection::stream).collect(Collectors.toList()); collect.forEach(e->e.setTypeName(list.stream().filter(m->m.getId().equals(e.getTypeId())).findFirst().get().getTypeName())); orderMealGoodsService.saveBatch(collect); // 存储 long end = System.currentTimeMillis() - start; System.err.println("相差时间========="+end); }else { // 生成失败 进行重试 String key = dto.getShopId()+"_fail"; if(redisCache.hasKey(key)){ Object cacheObject = redisCache.getCacheObject(key); int i = Integer.parseInt(cacheObject.toString()); if(i == 10){ this.removeById(dataGenerator); redisCache.deleteObject(key); throw new ServiceException("多次匹配数据不成功,请调整营业额范围"); }else { this.removeById(dataGenerator); redisCache.setCacheObject(key,i+1); this.mealDataGenerator(dto); } }else { this.removeById(dataGenerator); redisCache.setCacheObject(key,1); this.mealDataGenerator(dto); } } } @Transactional(rollbackFor = Exception.class,propagation = Propagation.REQUIRED) @Override public void saleDataGenerator(OrderSaleGeneratorDTO dto) { // 查询上一次的数据生成时间 TDataGenerator lastDataGenerator = this.getOne(new LambdaQueryWrapper().eq(TDataGenerator::getShopId, dto.getShopId()).orderByDesc(TDataGenerator::getCreateTime).last("limit 1")); if(Objects.nonNull(lastDataGenerator) && lastDataGenerator.getEndTime().isAfter(dto.getStartTime())){ throw new ServiceException("数据生成时间不能小于上次生成时间"); } // 查询上次生成最后一次的时间 后续涛哥不用这个类,可以改成TOrderStock的最后一条数据 TStockDataSet stockDataSet = stockDataSetService.getOne(new LambdaQueryWrapper() .eq(TStockDataSet::getShopId, dto.getShopId()) .orderByDesc(TStockDataSet::getStockDate) .last("limit 1")); // 存储数据生成数据 TDataGenerator dataGenerator = new TDataGenerator(); dataGenerator.setUserId(dto.getUserId()); dataGenerator.setUserName(dto.getNickName()); dataGenerator.setShopId(dataGenerator.getShopId()); dataGenerator.setStartTime(dto.getStartTime()); dataGenerator.setEndTime(dto.getEndTime()); dataGenerator.setStatus(2); dataGenerator.setShopId(dto.getShopId()); dataGenerator.setOrderType(2); this.save(dataGenerator); // 存储进货数据设置 List stockDataSets = dto.getStockDataSets(); stockDataSets.forEach(e->e.setGeneratorId(dataGenerator.getId())); stockDataSetService.saveBatch(stockDataSets); // 添加销售订单数 List orderSales = dto.getOrderSales(); orderSales.forEach(e->{ e.setGeneratorId(dataGenerator.getId()); e.setOrderNum(OrderNumConstants.SALE + CodeGenerateUtils.generateVolumeSn()); e.setIsCover(0); e.setStatus(2); }); List orderSaleGoods = orderSales.stream().map(TOrderSale::getOrderSaleGoods).flatMap(Collection::stream).collect(Collectors.toList()); TOrderStock orderStockLast = orderStockService.getOne(Wrappers.lambdaQuery(TOrderStock.class) .eq(TOrderStock::getShopId, dto.getShopId()) .orderByDesc(TOrderStock::getStockTime) .last("LIMIT 1")); // 生成进货数据 List stockList = new ArrayList<>(); stockDataSets.stream().sorted(Comparator.comparing(TStockDataSet::getStockDate)); for (int i = 0; i < stockDataSets.size(); i++) { TStockDataSet start = stockDataSets.get(i); LocalDate startTime = start.getStockDate(); if(i==stockDataSets.size()-1){ // 最后一次 LocalDate endTime = LocalDate.now(); List collect = orderSales.stream().filter(e -> e.getOrderTime().compareTo(startTime) >= 0 && e.getOrderTime().compareTo(endTime) <= 0).collect(Collectors.toList()); List orderSaleGoodsList = new ArrayList<>(); collect.forEach(e->orderSaleGoodsList.addAll(e.getOrderSaleGoods())); // 根据商品新生成一条数据 TOrderStock orderStock = new TOrderStock(); orderStock.setStockNum(OrderNumConstants.STOCK + CodeGenerateUtils.generateVolumeSn()); orderStock.setStockTime(startTime); orderStock.setIsCover(0); orderStock.setGeneratorId(dataGenerator.getId()); orderStock.setShopId(dto.getShopId()); Map> goodsList = orderSaleGoodsList.stream().collect(Collectors.groupingBy(TOrderSaleGoods::getGoodsName)); List orderStockGoods = new ArrayList<>(); goodsList.forEach((k,v)->{ TOrderStockGoods tOrderStockGoods = new TOrderStockGoods(); tOrderStockGoods.setGoodsName(k); tOrderStockGoods.setGoodsNum(v.get(0).getGoodsNum()); tOrderStockGoods.setCostPrice(v.get(0).getGoodsCostPrice()); tOrderStockGoods.setSalePrice(v.get(0).getGoodsSalePrice()); // tOrderStockGoods.setThisCostPrice(v.get(0).getThisSalePrice()); tOrderStockGoods.setGoodsPicture(v.get(0).getGoodsPicture()); tOrderStockGoods.setGoodsId(v.get(0).getGoodsId()); int sum = v.stream().mapToInt(TOrderSaleGoods::getGoodsCount).sum(); BigDecimal rate = new BigDecimal(100).subtract(start.getLossRate()).divide(new BigDecimal(100)).setScale(2, BigDecimal.ROUND_HALF_UP); BigDecimal bigDecimal = new BigDecimal(sum).divide(rate,2,BigDecimal.ROUND_HALF_UP).setScale(0, BigDecimal.ROUND_HALF_UP); tOrderStockGoods.setStockCount(Integer.parseInt(bigDecimal.toString().split("\\.")[0])); orderStockGoods.add(tOrderStockGoods); }); orderStock.setOrderStockGoods(orderStockGoods); stockList.add(orderStock); }else if(i==0 && Objects.nonNull(stockDataSet)){ if(Objects.nonNull(orderStockLast)){ // 查询商品进价 List orderStockGoodsList = orderStockGoodsService.list(Wrappers.lambdaQuery(TOrderStockGoods.class).eq(TOrderStockGoods::getOrderId, orderStockLast.getId())); // 第一次 第一次的进货时间为上一次的结束时间 开始时间为上一次的开始时间 LocalDate startTime1 = stockDataSet.getStockDate(); List collect = orderSales.stream().filter(e -> e.getOrderTime().compareTo(startTime) < 0).collect(Collectors.toList()); List orderSaleGoodsList = new ArrayList<>(); collect.forEach(e->orderSaleGoodsList.addAll(e.getOrderSaleGoods())); // 查询上一次开始之后的订单数据 List orderSales1 = orderSaleService.list(new LambdaQueryWrapper().gt(TOrderSale::getOrderTime, startTime1)); List saleIds1 = orderSales1.stream().map(TOrderSale::getId).collect(Collectors.toList()); List list; if(CollectionUtils.isEmpty(saleIds1)){ // 查询上一次的商品 list = orderSaleGoodsService.list(new LambdaQueryWrapper().in(TOrderSaleGoods::getOrderId, saleIds1)); // 结合上次最后一次的数据 list.addAll(orderSaleGoodsList); }else { list = orderSaleGoodsList; } // 删除上一次的数据生成 新生成一条数据 TOrderStock orderStock = new TOrderStock(); orderStock.setStockNum(OrderNumConstants.STOCK + CodeGenerateUtils.generateVolumeSn()); orderStock.setStockTime(orderStockLast.getStockTime()); orderStock.setIsCover(0); orderStock.setGeneratorId(orderStockLast.getGeneratorId()); orderStock.setShopId(dto.getShopId()); Map> goodsList = list.stream().collect(Collectors.groupingBy(TOrderSaleGoods::getGoodsName)); List orderStockGoods = new ArrayList<>(); goodsList.forEach((k,v)->{ TOrderStockGoods tOrderStockGoods = new TOrderStockGoods(); tOrderStockGoods.setGoodsName(k); tOrderStockGoods.setGoodsNum(v.get(0).getGoodsNum()); tOrderStockGoods.setCostPrice(v.get(0).getGoodsCostPrice()); tOrderStockGoods.setSalePrice(v.get(0).getGoodsSalePrice()); TOrderStockGoods orderStockGoods1 = orderStockGoodsList.stream().filter(e -> e.getGoodsName().equals(k)).findFirst().orElse(null); if(Objects.nonNull(orderStockGoods1)){ tOrderStockGoods.setThisCostPrice(orderStockGoods1.getThisCostPrice()); } tOrderStockGoods.setGoodsPicture(v.get(0).getGoodsPicture()); tOrderStockGoods.setGoodsId(v.get(0).getGoodsId()); int sum = v.stream().mapToInt(TOrderSaleGoods::getGoodsCount).sum(); BigDecimal rate = new BigDecimal(100).subtract(start.getLossRate()).divide(new BigDecimal(100)).setScale(2, BigDecimal.ROUND_HALF_UP); BigDecimal bigDecimal = new BigDecimal(sum).divide(rate,2,BigDecimal.ROUND_HALF_UP).setScale(0, BigDecimal.ROUND_HALF_UP); tOrderStockGoods.setStockCount(Integer.parseInt(bigDecimal.toString().split("\\.")[0])); orderStockGoods.add(tOrderStockGoods); }); orderStock.setOrderStockGoods(orderStockGoods); stockList.add(orderStock); } // 处理第一次到下一次的数据 TStockDataSet end = stockDataSets.get(i + 1); LocalDate endTime = end.getStockDate(); List collect1 = orderSales.stream().filter(e -> e.getOrderTime().compareTo(startTime) >= 0 && e.getOrderTime().compareTo(endTime) < 0).collect(Collectors.toList()); List orderSaleGoodsList2 = new ArrayList<>(); collect1.forEach(e->orderSaleGoodsList2.addAll(e.getOrderSaleGoods())); // 根据商品新生成一条数据 TOrderStock orderStock1 = new TOrderStock(); orderStock1.setStockNum(OrderNumConstants.STOCK + CodeGenerateUtils.generateVolumeSn()); orderStock1.setStockTime(startTime); orderStock1.setIsCover(0); orderStock1.setGeneratorId(dataGenerator.getId()); orderStock1.setShopId(dto.getShopId()); Map> goodsList1 = orderSaleGoodsList2.stream().collect(Collectors.groupingBy(TOrderSaleGoods::getGoodsName)); List orderStockGoods1 = new ArrayList<>(); goodsList1.forEach((k,v)->{ TOrderStockGoods tOrderStockGoods = new TOrderStockGoods(); tOrderStockGoods.setGoodsName(k); tOrderStockGoods.setGoodsNum(v.get(0).getGoodsNum()); tOrderStockGoods.setCostPrice(v.get(0).getGoodsCostPrice()); tOrderStockGoods.setSalePrice(v.get(0).getGoodsSalePrice()); // tOrderStockGoods.setThisCostPrice(v.get(0).getThisSalePrice()); tOrderStockGoods.setGoodsPicture(v.get(0).getGoodsPicture()); tOrderStockGoods.setGoodsId(v.get(0).getGoodsId()); int sum = v.stream().mapToInt(TOrderSaleGoods::getGoodsCount).sum(); BigDecimal rate = new BigDecimal(100).subtract(start.getLossRate()).divide(new BigDecimal(100)).setScale(2, BigDecimal.ROUND_HALF_UP); BigDecimal bigDecimal = new BigDecimal(sum).divide(rate,2,BigDecimal.ROUND_HALF_UP).setScale(0, BigDecimal.ROUND_HALF_UP); tOrderStockGoods.setStockCount(Integer.parseInt(bigDecimal.toString().split("\\.")[0])); orderStockGoods1.add(tOrderStockGoods); }); orderStock1.setOrderStockGoods(orderStockGoods1); stockList.add(orderStock1); }else { TStockDataSet end = stockDataSets.get(i + 1); LocalDate endTime = end.getStockDate(); List collect = orderSales.stream().filter(e -> e.getOrderTime().compareTo(startTime) >= 0 && e.getOrderTime().compareTo(endTime) < 0).collect(Collectors.toList()); List orderSaleGoodsList = new ArrayList<>(); collect.forEach(e->orderSaleGoodsList.addAll(e.getOrderSaleGoods())); // 根据商品新生成一条数据 TOrderStock orderStock = new TOrderStock(); orderStock.setStockNum(OrderNumConstants.STOCK + CodeGenerateUtils.generateVolumeSn()); orderStock.setStockTime(startTime); orderStock.setIsCover(0); orderStock.setGeneratorId(dataGenerator.getId()); orderStock.setShopId(dto.getShopId()); Map> goodsList = orderSaleGoodsList.stream().collect(Collectors.groupingBy(TOrderSaleGoods::getGoodsName)); List orderStockGoods = new ArrayList<>(); goodsList.forEach((k,v)->{ TOrderStockGoods tOrderStockGoods = new TOrderStockGoods(); tOrderStockGoods.setGoodsName(k); tOrderStockGoods.setGoodsNum(v.get(0).getGoodsNum()); tOrderStockGoods.setCostPrice(v.get(0).getGoodsCostPrice()); tOrderStockGoods.setSalePrice(v.get(0).getGoodsSalePrice()); // tOrderStockGoods.setThisCostPrice(v.get(0).getThisSalePrice()); tOrderStockGoods.setGoodsPicture(v.get(0).getGoodsPicture()); tOrderStockGoods.setGoodsId(v.get(0).getGoodsId()); int sum = v.stream().mapToInt(TOrderSaleGoods::getGoodsCount).sum(); BigDecimal rate = new BigDecimal(100).subtract(start.getLossRate()).divide(new BigDecimal(100)).setScale(2, BigDecimal.ROUND_HALF_UP); BigDecimal bigDecimal = new BigDecimal(sum).divide(rate,2,BigDecimal.ROUND_HALF_UP).setScale(0, BigDecimal.ROUND_HALF_UP); tOrderStockGoods.setStockCount(Integer.parseInt(bigDecimal.toString().split("\\.")[0])); orderStockGoods.add(tOrderStockGoods); }); orderStock.setOrderStockGoods(orderStockGoods); stockList.add(orderStock); } } // 判断是否进行了终止操作 if(redisCache.hasKey(OrderNumConstants.STOCK+"_"+dto.getShopId())){ redisCache.deleteObject(OrderNumConstants.STOCK+"_"+dto.getShopId()); return; } // 删除上一次的数据生成 if(Objects.nonNull(orderStockLast) && Objects.nonNull(stockDataSet) && stockDataSets.size() > 1){ orderStockService.removeById(orderStockLast); } orderSaleService.saveBatch(orderSales); for (TOrderSale orderSale : orderSales) { orderSale.getOrderSaleGoods().forEach(e->e.setOrderId(orderSale.getId())); } List list = goodsTypeService.list(); // orderSaleGoods.forEach(e->e.setTypeName(list.stream().filter(m->m.getId().equals(e.getTypeId())).findFirst().get().getTypeName())); orderSaleGoods.forEach(e->{ e.setId(null); e.setGoodsCostPrice(null); }); orderSaleGoodsService.saveBatch(orderSaleGoods); // 添加数据 orderStockService.saveBatch(stockList); for (TOrderStock stock : stockList) { stock.getOrderStockGoods().forEach(e->e.setOrderId(stock.getId())); } List orderStockGoods = stockList.stream().map(TOrderStock::getOrderStockGoods).flatMap(Collection::stream).collect(Collectors.toList()); orderStockGoodsService.saveBatch(orderStockGoods); } @Override public PageInfo pageList(TDataGeneratorQuery query) { PageInfo pageInfo = new PageInfo<>(query.getPageNum(), query.getPageSize()); List list = this.baseMapper.pageList(query,pageInfo); List ids = list.stream().map(TDataGeneratorVO::getId).collect(Collectors.toList()); if(CollectionUtils.isEmpty(ids)){ return new PageInfo<>(); } if(query.getOrderType() == 1){ List orderMeals = orderMealService.list(Wrappers.lambdaQuery(TOrderMeal.class) .in(TOrderMeal::getGeneratorId, ids)); List mealIds = orderMeals.stream().map(TOrderMeal::getId).collect(Collectors.toList()); if(!CollectionUtils.isEmpty(mealIds)){ // List mealGoods = orderMealGoodsService.list(Wrappers.lambdaQuery(TOrderMealGoods.class) // .in(TOrderMealGoods::getOrderId, mealIds)); for (TDataGeneratorVO tDataGeneratorVO : list) { // List collect = orderMeals.stream().filter(e -> e.getGeneratorId().equals(tDataGeneratorVO.getId())).map(TOrderMeal::getId).collect(Collectors.toList()); // BigDecimal money = mealGoods.stream().filter(e -> collect.contains(e.getOrderId())) // .reduce(BigDecimal.ZERO, (x, y) -> x.add(y.getGoodsSalePrice().multiply(new BigDecimal(y.getGoodsCount()))), BigDecimal::add); BigDecimal money = orderMeals.stream().filter(e -> e.getGeneratorId().equals(tDataGeneratorVO.getId())) .map(TOrderMeal::getPayMoney).reduce(BigDecimal.ZERO, BigDecimal::add); tDataGeneratorVO.setTotalRevenue(money); } } }else { List orderSales = orderSaleService.list(Wrappers.lambdaQuery(TOrderSale.class) .in(TOrderSale::getGeneratorId, ids)); // List saleIds = orderSales.stream().map(TOrderSale::getId).collect(Collectors.toList()); // List orderSaleGoods = orderSaleGoodsService.list(Wrappers.lambdaQuery(TOrderSaleGoods.class) // .in(TOrderSaleGoods::getOrderId, saleIds)); for (TDataGeneratorVO tDataGeneratorVO : list) { // List collect = orderSales.stream().filter(e -> e.getGeneratorId().equals(tDataGeneratorVO.getId())).map(TOrderSale::getId).collect(Collectors.toList()); // BigDecimal money = orderSaleGoods.stream().filter(e -> collect.contains(e.getOrderId())) // .reduce(BigDecimal.ZERO, (x, y) -> x.add(y.getGoodsCostPrice().multiply(new BigDecimal(y.getGoodsCount()))), BigDecimal::add); if(!CollectionUtils.isEmpty(orderSales)){ List collect = orderSales.stream().filter(e -> e.getGeneratorId().equals(tDataGeneratorVO.getId())).collect(Collectors.toList()); BigDecimal money = BigDecimal.ZERO; if(!CollectionUtils.isEmpty(collect)){ money = collect.stream().map(TOrderSale::getPayMoney).reduce(BigDecimal::add).get(); } tDataGeneratorVO.setTotalRevenue(money); } } } pageInfo.setRecords(list); return pageInfo; } @Override public void dataCoverage(Long id) { TDataGenerator dataGenerator = this.getOne(Wrappers.lambdaQuery(TDataGenerator.class) .eq(TDataGenerator::getId, id)); if(dataGenerator.getOrderType() == 1){ // 删除时间段的数据 orderMealService.remove(Wrappers.lambdaQuery(TOrderMeal.class) .ge(TOrderMeal::getMealTime, dataGenerator.getStartTime()) .le(TOrderMeal::getMealTime, dataGenerator.getEndTime()) .eq(TOrderMeal::getIsCover,1)); // 修改覆盖类型为已覆盖 orderMealService.update(Wrappers.lambdaUpdate(TOrderMeal.class).set(TOrderMeal::getIsCover, 1).eq(TOrderMeal::getGeneratorId, id)); }else { List list = orderStockService.list(Wrappers.lambdaQuery(TOrderStock.class) .eq(TOrderStock::getGeneratorId, id)); List stockIds = list.stream().map(TOrderStock::getId).collect(Collectors.toList()); if(!CollectionUtils.isEmpty(stockIds)){ List list1 = orderStockGoodsService.list(Wrappers.lambdaQuery(TOrderStockGoods.class) .in(TOrderStockGoods::getOrderId, stockIds)); // 判断集合中的进价是否为0 for (TOrderStockGoods tOrderStockGoods : list1) { if(tOrderStockGoods.getThisCostPrice().compareTo(BigDecimal.ZERO) == 0){ throw new ServiceException("进价不能为0"); } } } // 删除时间段的数据 orderSaleService.remove(Wrappers.lambdaQuery(TOrderSale.class) .ge(TOrderSale::getOrderTime, dataGenerator.getStartTime()) .le(TOrderSale::getOrderTime, dataGenerator.getEndTime()) .eq(TOrderSale::getIsCover,1)); // 修改覆盖类型为已覆盖 orderSaleService.update(Wrappers.lambdaUpdate(TOrderSale.class).set(TOrderSale::getIsCover, 1).eq(TOrderSale::getGeneratorId, id)); // 删除时间段的数据 orderStockService.remove(Wrappers.lambdaQuery(TOrderStock.class) .ge(TOrderStock::getStockTime, dataGenerator.getStartTime()) .le(TOrderStock::getStockTime, dataGenerator.getEndTime()) .eq(TOrderStock::getIsCover,1)); // 修改覆盖类型为已覆盖 orderStockService.update(Wrappers.lambdaUpdate(TOrderStock.class).set(TOrderStock::getIsCover, 1).eq(TOrderStock::getGeneratorId, id)); } dataGenerator.setStatus(3); this.updateById(dataGenerator); } @Override public TDataGeneratorMealDetailVO mealGeneratorDataDetail(TDataGeneratorMealQuery query) { // 查询餐饮数据生成详情 TDataGenerator dataGenerator = this.getById(query.getGeneratorId()); TDataGeneratorMealDetailVO data = new TDataGeneratorMealDetailVO(); BeanUtils.copyProperties(dataGenerator,data); // 查询店铺 TShop shop = shopService.getById(dataGenerator.getShopId()); if(Objects.nonNull(shop)){ data.setShopName(shop.getShopName()); } // 查询订单 PageInfo pageInfo = orderMealService.pageListGenerator(query); data.setOrderMealList(pageInfo); // 统计支付金额 Map map = orderMealService.getDataGeneratorMealDetail(query); BigDecimal money = new BigDecimal(map.get("moneyPay")).setScale(2,BigDecimal.ROUND_HALF_UP); BigDecimal card = new BigDecimal(map.get("cardPay")).setScale(2,BigDecimal.ROUND_HALF_UP); BigDecimal weiXin = new BigDecimal(map.get("weiXinPay")).setScale(2,BigDecimal.ROUND_HALF_UP); BigDecimal ali = new BigDecimal(map.get("aliPay")).setScale(2,BigDecimal.ROUND_HALF_UP); BigDecimal other = new BigDecimal(map.get("otherPay")).setScale(2,BigDecimal.ROUND_HALF_UP); data.setMoneyPayAmount(money); data.setCardPayAmount(card); data.setWeiXinPayAmount(weiXin); data.setAliPayAmount(ali); data.setOtherPayAmount(other); return data; } @Override public TDataGeneratorSaleDetailVO saleGeneratorDataDetail(TDataGeneratorSaleQuery query) { // 查询餐饮数据生成详情 TDataGeneratorSaleDetailVO data = new TDataGeneratorSaleDetailVO(); // 查询订单 TOrderSaleQuery orderSaleQuery = new TOrderSaleQuery(); orderSaleQuery.setTimeType(query.getTimeType()); orderSaleQuery.setPayType(query.getPayType()); orderSaleQuery.setOrderNum(query.getOrderNum()); orderSaleQuery.setGeneratorId(query.getGeneratorId()); try { if (Objects.nonNull(query.getStartTime()) && Objects.nonNull(query.getEndTime())){ orderSaleQuery.setStartTime(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").parse(query.getStartTime())); orderSaleQuery.setEndTime(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").parse(query.getEndTime())); } } catch (ParseException e) { throw new ServiceException(e.getMessage()); } PageInfo pageInfo = orderSaleService.pageList(orderSaleQuery); data.setOrderMealList(pageInfo); // 统计支付金额 Map map = orderSaleService.getDataGeneratorSaleDetail(query); BigDecimal money = new BigDecimal(map.get("moneyPay")).setScale(2,BigDecimal.ROUND_HALF_UP); BigDecimal card = new BigDecimal(map.get("cardPay")).setScale(2,BigDecimal.ROUND_HALF_UP); BigDecimal weiXin = new BigDecimal(map.get("weiXinPay")).setScale(2,BigDecimal.ROUND_HALF_UP); BigDecimal ali = new BigDecimal(map.get("aliPay")).setScale(2,BigDecimal.ROUND_HALF_UP); BigDecimal other = new BigDecimal(map.get("otherPay")).setScale(2,BigDecimal.ROUND_HALF_UP); data.setMoneyPayAmount(money); data.setCardPayAmount(card); data.setWeiXinPayAmount(weiXin); data.setAliPayAmount(ali); data.setOtherPayAmount(other); return data; } @Override public TDataGeneratorStockDetailVO stockGeneratorDataDetail(TDataGeneratorStockQuery query) { // 查询餐饮数据生成详情 TDataGeneratorStockDetailVO data = new TDataGeneratorStockDetailVO(); // 查询订单 TOrderStockQuery orderStockQuery = new TOrderStockQuery(); orderStockQuery.setGeneratorId(query.getGeneratorId()); orderStockQuery.setTimeType(query.getTimeType()); orderStockQuery.setStockNum(query.getOrderNum()); try { if(Objects.nonNull(query.getStartTime()) && Objects.nonNull(query.getEndTime())){ orderStockQuery.setStartTime(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").parse(query.getStartTime())); orderStockQuery.setEndTime(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").parse(query.getEndTime())); } } catch (ParseException e) { throw new ServiceException(e.getMessage()); } PageInfo pageInfo = orderStockService.pageList(orderStockQuery); data.setOrderStockVOList(pageInfo); // 统计支付金额 Map map = orderStockService.getDataGeneratorStockDetail(query); Integer totalStock = Integer.parseInt(map.get("totalStock").toString()); // BigDecimal stockAmountSum = new BigDecimal(map.get("stockAmountSum").toString()); data.setTotalStock(totalStock); List list = orderStockService.list(Wrappers.lambdaQuery(TOrderStock.class) .eq(TOrderStock::getGeneratorId, query.getGeneratorId())); if(CollectionUtils.isEmpty(list)){ data.setStockAmountSum(BigDecimal.ZERO); }else { data.setStockAmountSum(list.stream().filter(e->Objects.nonNull(e.getStockTotalPrice())).map(TOrderStock::getStockTotalPrice).reduce(BigDecimal.ZERO, BigDecimal::add)); } return data; } @Override public List mealGeneratorExport(TDataGeneratorMealQuery query) { return null; } @Override public void deleteByShopId(Long shopId) { this.baseMapper.deleteByShopId(shopId); } private int getRandomPayType(Integer size,BigDecimal count) { BigDecimal bigDecimal = new BigDecimal(size).multiply(count.divide(new BigDecimal(100))).setScale(0, BigDecimal.ROUND_FLOOR); return Integer.parseInt(bigDecimal.toString()); } private int getRandom(int min,int max) { // 生成一个min到max之间的随机数 return new Random().nextInt(max - min + 1) + min; } private static List randomSelection(List list, int size) { List selected = new ArrayList<>(); int length = list.size(); for (int i = 0; i < size; i++) { Collections.shuffle(list); // 如果需求的大小超过了集合的长度,则只能取到集合的全部元素 int subListSize = Math.min(size - selected.size(), length); selected.addAll(list.subList(0, subListSize)); } return selected; } }