From 13a3236249d21e1ed1a0f1e8ae20a29d6bf3913a Mon Sep 17 00:00:00 2001 From: xuhy <3313886187@qq.com> Date: 星期五, 26 九月 2025 17:49:11 +0800 Subject: [PATCH] 修改 --- ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TDataGeneratorServiceImpl.java | 175 +++++++++++++++++++++++++++++++++++++++------------------- 1 files changed, 118 insertions(+), 57 deletions(-) diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TDataGeneratorServiceImpl.java b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TDataGeneratorServiceImpl.java index 1255135..b5428c7 100644 --- a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TDataGeneratorServiceImpl.java +++ b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TDataGeneratorServiceImpl.java @@ -49,6 +49,8 @@ @Autowired private TFoundationConfigService foundationConfigService; @Autowired + private TFoundationPersonService foundationPersonService; + @Autowired private TGoodsService goodsService; @Autowired private TOrderMealService orderMealService; @@ -92,10 +94,10 @@ dataGenerator.setOtherPay(dto.getOtherProportion()); this.save(dataGenerator); long start = System.currentTimeMillis(); - // 查询所有的人数用餐标准 - List<TFoundationConfigVO> foundationConfigs = foundationConfigService.getList(dto.getShopId()); + TShop shop = shopService.getById(dto.getShopId()); + List<TFoundationConfigVO> foundationConfigs = foundationConfigService.getList(shop.getMealType()); if(CollectionUtils.isEmpty(foundationConfigs)){ - throw new ServiceException("请先添加该店铺用餐标准"); + throw new ServiceException("请先添加中餐或火锅用餐标准"); } // 查询所有桌子 List<TBoard> boards = boardService.list(Wrappers.lambdaQuery(TBoard.class) @@ -113,8 +115,14 @@ List<OrderMealGeneratorCountDTO> orderMealGeneratorCountDTOS = dto.getOrderMealGeneratorCountDTOS(); List<TOrderMeal> orderMeals = new ArrayList<>(); for (OrderMealGeneratorCountDTO orderMealGeneratorCountDTO : orderMealGeneratorCountDTOS) { - TBoard board = boards.stream().filter(e -> e.getId().equals(orderMealGeneratorCountDTO.getBoardId())).findFirst().get(); + 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()); @@ -123,23 +131,36 @@ orderMeal.setMealType(1); orderMeal.setMealPerson(random); orderMeal.setMealTime(orderMealGeneratorCountDTO.getTime()); - orderMeal.setOrderNum(OrderNumConstants.MEAL + CodeGenerateUtils.generateVolumeSn()); + 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<TOrderMealGoods> orderMealGoods = new ArrayList<>(); // 获取当前桌的菜品 List<TFoundationConfigVO> 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<TGoods> typeGoods = goods.stream().filter(m -> e.getTypeId().equals(m.getTypeId())).collect(Collectors.toList()); - typeGoods = randomSelection(typeGoods, random1); + List<TGoods> typeGoodsList = goods.stream().filter(m -> e.getTypeId().equals(m.getTypeId())).collect(Collectors.toList()); + List<TGoods> typeGoods = randomSelection(typeGoodsList, random1); + if(typeGoods.size() != random1){ + List<TGoods> 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())); +// good.setGoodsSalePrice(good.getGoodsSalePrice().add(typeGood.getSalePrice())); break; // 找到后直接跳出循环 } } @@ -149,6 +170,7 @@ tOrderMealGoods.setGoodsName(typeGood.getGoodsName()); tOrderMealGoods.setGoodsPicture(typeGood.getGoodsPicture()); tOrderMealGoods.setGoodsSalePrice(typeGood.getSalePrice()); + tOrderMealGoods.setCostPrice(typeGood.getCostPrice()); tOrderMealGoods.setGoodsCount(1); tOrderMealGoods.setTypeId(typeGood.getTypeId()); tOrderMealGoods.setGoodsId(typeGood.getId()); @@ -298,9 +320,13 @@ e.setGeneratorId(dataGenerator.getId()); e.setOrderNum(OrderNumConstants.SALE + CodeGenerateUtils.generateVolumeSn()); e.setIsCover(0); + e.setStatus(2); }); List<TOrderSaleGoods> 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<TOrderStock> stockList = new ArrayList<>(); stockDataSets.stream().sorted(Comparator.comparing(TStockDataSet::getStockDate)); @@ -342,45 +368,57 @@ stockList.add(orderStock); }else if(i==0 && Objects.nonNull(stockDataSet)){ - // 第一次 第一次的进货时间为上一次的结束时间 开始时间为上一次的开始时间 - LocalDate startTime1 = stockDataSet.getStockDate(); - List<TOrderSale> collect = orderSales.stream().filter(e -> e.getOrderTime().compareTo(startTime) < 0).collect(Collectors.toList()); - List<TOrderSaleGoods> orderSaleGoodsList = new ArrayList<>(); - collect.forEach(e->orderSaleGoodsList.addAll(e.getOrderSaleGoods())); - // 查询上一次开始之后的订单数据 - List<TOrderSale> orderSales1 = orderSaleService.list(new LambdaQueryWrapper<TOrderSale>().gt(TOrderSale::getOrderTime, startTime1)); - List<Long> saleIds1 = orderSales1.stream().map(TOrderSale::getId).collect(Collectors.toList()); - // 查询上一次的商品 - List<TOrderSaleGoods> list = orderSaleGoodsService.list(new LambdaQueryWrapper<TOrderSaleGoods>().in(TOrderSaleGoods::getOrderId, saleIds1)); - // 结合上次最后一次的数据 - list.addAll(orderSaleGoodsList); - // 删除上一次的数据生成 新生成一条数据 - TOrderStock orderStock = new TOrderStock(); - orderStock.setStockNum(OrderNumConstants.STOCK + CodeGenerateUtils.generateVolumeSn()); - orderStock.setStockTime(startTime); - orderStock.setIsCover(0); - orderStock.setGeneratorId(dataGenerator.getId()); - orderStock.setShopId(dto.getShopId()); + if(Objects.nonNull(orderStockLast)){ + // 查询商品进价 + List<TOrderStockGoods> orderStockGoodsList = orderStockGoodsService.list(Wrappers.lambdaQuery(TOrderStockGoods.class).eq(TOrderStockGoods::getOrderId, orderStockLast.getId())); + // 第一次 第一次的进货时间为上一次的结束时间 开始时间为上一次的开始时间 + LocalDate startTime1 = stockDataSet.getStockDate(); + List<TOrderSale> collect = orderSales.stream().filter(e -> e.getOrderTime().compareTo(startTime) < 0).collect(Collectors.toList()); + List<TOrderSaleGoods> orderSaleGoodsList = new ArrayList<>(); + collect.forEach(e->orderSaleGoodsList.addAll(e.getOrderSaleGoods())); + // 查询上一次开始之后的订单数据 + List<TOrderSale> orderSales1 = orderSaleService.list(new LambdaQueryWrapper<TOrderSale>().gt(TOrderSale::getOrderTime, startTime1)); + List<Long> saleIds1 = orderSales1.stream().map(TOrderSale::getId).collect(Collectors.toList()); + List<TOrderSaleGoods> list; + if(CollectionUtils.isEmpty(saleIds1)){ + // 查询上一次的商品 + list = orderSaleGoodsService.list(new LambdaQueryWrapper<TOrderSaleGoods>().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<String, List<TOrderSaleGoods>> goodsList = list.stream().collect(Collectors.groupingBy(TOrderSaleGoods::getGoodsName)); - List<TOrderStockGoods> 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); + Map<String, List<TOrderSaleGoods>> goodsList = list.stream().collect(Collectors.groupingBy(TOrderSaleGoods::getGoodsName)); + List<TOrderStockGoods> 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); @@ -457,18 +495,17 @@ return; } // 删除上一次的数据生成 - TOrderStock orderStock = orderStockService.getOne(Wrappers.lambdaQuery(TOrderStock.class) - .eq(TOrderStock::getShopId, dto.getShopId()) - .orderByDesc(TOrderStock::getStockTime) - .last("LIMIT 1")); - if(Objects.nonNull(orderStock)){ - orderStockService.removeById(orderStock); + 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<TGoodsType> list = goodsTypeService.list(); + // 查询店铺下的商品 + List<TGoods> goodsList = goodsService.list(Wrappers.lambdaQuery(TGoods.class) + .in(TGoods::getShopId,dto.getShopId())); +// List<TGoodsType> 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); @@ -481,6 +518,12 @@ stock.getOrderStockGoods().forEach(e->e.setOrderId(stock.getId())); } List<TOrderStockGoods> orderStockGoods = stockList.stream().map(TOrderStock::getOrderStockGoods).flatMap(Collection::stream).collect(Collectors.toList()); + if(!CollectionUtils.isEmpty(orderStockGoods)){ + for (TOrderStockGoods orderStockGood : orderStockGoods) { + goodsList.stream().filter(e->e.getId().equals(orderStockGood.getGoodsId())) + .findFirst().ifPresent(e->orderStockGood.setThisCostPrice(e.getCostPrice())); + } + } orderStockGoodsService.saveBatch(orderStockGoods); } @@ -519,7 +562,11 @@ // 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)){ - BigDecimal money = orderSales.stream().map(TOrderSale::getPayMoney).reduce(BigDecimal::add).get(); + List<TOrderSale> 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); } } @@ -537,6 +584,7 @@ orderMealService.remove(Wrappers.lambdaQuery(TOrderMeal.class) .ge(TOrderMeal::getMealTime, dataGenerator.getStartTime()) .le(TOrderMeal::getMealTime, dataGenerator.getEndTime()) + .eq(TOrderMeal::getShopId, dataGenerator.getShopId()) .eq(TOrderMeal::getIsCover,1)); // 修改覆盖类型为已覆盖 orderMealService.update(Wrappers.lambdaUpdate(TOrderMeal.class).set(TOrderMeal::getIsCover, 1).eq(TOrderMeal::getGeneratorId, id)); @@ -558,6 +606,7 @@ orderSaleService.remove(Wrappers.lambdaQuery(TOrderSale.class) .ge(TOrderSale::getOrderTime, dataGenerator.getStartTime()) .le(TOrderSale::getOrderTime, dataGenerator.getEndTime()) + .eq(TOrderSale::getShopId, dataGenerator.getShopId()) .eq(TOrderSale::getIsCover,1)); // 修改覆盖类型为已覆盖 orderSaleService.update(Wrappers.lambdaUpdate(TOrderSale.class).set(TOrderSale::getIsCover, 1).eq(TOrderSale::getGeneratorId, id)); @@ -565,6 +614,7 @@ orderStockService.remove(Wrappers.lambdaQuery(TOrderStock.class) .ge(TOrderStock::getStockTime, dataGenerator.getStartTime()) .le(TOrderStock::getStockTime, dataGenerator.getEndTime()) + .eq(TOrderStock::getShopId, dataGenerator.getShopId()) .eq(TOrderStock::getIsCover,1)); // 修改覆盖类型为已覆盖 orderStockService.update(Wrappers.lambdaUpdate(TOrderStock.class).set(TOrderStock::getIsCover, 1).eq(TOrderStock::getGeneratorId, id)); @@ -659,9 +709,15 @@ // 统计支付金额 Map<String, Object> map = orderStockService.getDataGeneratorStockDetail(query); Integer totalStock = Integer.parseInt(map.get("totalStock").toString()); - BigDecimal stockAmountSum = new BigDecimal(map.get("stockAmountSum").toString()); +// BigDecimal stockAmountSum = new BigDecimal(map.get("stockAmountSum").toString()); data.setTotalStock(totalStock); - data.setStockAmountSum(stockAmountSum); + List<TOrderStock> 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; } @@ -670,6 +726,11 @@ 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()); -- Gitblit v1.7.1