| | |
| | | import com.ruoyi.production.bean.dto.ProductionPlanDto; |
| | | import com.ruoyi.production.bean.dto.ProductionPlanImportDto; |
| | | import com.ruoyi.production.bean.vo.ProductionPlanVo; |
| | | import com.ruoyi.production.enums.ProductOrderStatusEnum; |
| | | import com.ruoyi.production.mapper.ProductionOrderMapper; |
| | | import com.ruoyi.production.mapper.ProductionPlanMapper; |
| | | import com.ruoyi.production.pojo.ProductionOrder; |
| | | import com.ruoyi.production.pojo.ProductionPlan; |
| | | import com.ruoyi.production.service.ProductionOrderService; |
| | | import com.ruoyi.production.service.ProductionPlanService; |
| | | import jakarta.servlet.http.HttpServletResponse; |
| | | import lombok.RequiredArgsConstructor; |
| | |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | import org.springframework.web.multipart.MultipartFile; |
| | | |
| | | import java.math.BigDecimal; |
| | | import java.time.LocalDateTime; |
| | | import java.util.ArrayList; |
| | | import java.util.HashSet; |
| | | import java.util.List; |
| | | import java.util.Set; |
| | | import java.util.*; |
| | | import java.util.stream.Collectors; |
| | | |
| | | @Service |
| | | @RequiredArgsConstructor |
| | | public class ProductionPlanServiceImpl extends ServiceImpl<ProductionPlanMapper, ProductionPlan> implements ProductionPlanService { |
| | | |
| | | private final ProductionPlanMapper productionPlanMapper; |
| | | private static final int PLAN_STATUS_WAIT = 0; |
| | | private static final int PLAN_STATUS_PARTIAL = 1; |
| | | private static final int PLAN_STATUS_ISSUED = 2; |
| | | |
| | | private final ProductionPlanMapper productionPlanMapper; |
| | | private final ProductionOrderMapper productionOrderMapper; |
| | | private final ProductionOrderService productionOrderService; |
| | | |
| | | @Override |
| | | public IPage<ProductionPlanVo> listPage(Page<ProductionPlanDto> page, ProductionPlanDto productionPlanDto) { |
| | | |
| | | IPage<ProductionPlanVo> planVoIPage = productionPlanMapper.listPage(page, productionPlanDto) |
| | | .convert(dto -> { |
| | | ProductionPlanVo vo = new ProductionPlanVo(); |
| | | BeanUtils.copyProperties(dto, vo); |
| | | return vo; |
| | | }); |
| | | return planVoIPage; |
| | | return productionPlanMapper.listPage(page, productionPlanDto); |
| | | } |
| | | |
| | | /** |
| | | * 合并生产计划 |
| | | * 合并生产计划并下发生产订单。 |
| | | * 业务约束: |
| | | * 1. 仅允许同一产品型号的计划合并; |
| | | * 2. 已下发或部分下发的计划禁止再次合并; |
| | | * 3. 下发数量不能大于所选计划需求总量; |
| | | * 4. 订单创建统一复用 ProductionOrderService.saveProductionOrder,确保工艺/BOM/领料主单等后续逻辑一致。 |
| | | */ |
| | | @Override |
| | | @Transactional(rollbackFor = Exception.class) |
| | | public boolean combine(ProductionPlanDto productionPlanDto) { |
| | | if (productionPlanDto.getIds() == null || productionPlanDto.getIds().isEmpty()) { |
| | | if (productionPlanDto == null || productionPlanDto.getIds() == null || productionPlanDto.getIds().isEmpty()) { |
| | | return false; |
| | | } |
| | | |
| | | // 查询主生产计划 |
| | | List<ProductionPlanDto> plans = productionPlanMapper.selectWithMaterialByIds(productionPlanDto.getIds()); |
| | | |
| | | if (plans == null || plans.isEmpty()) { |
| | | throw new ServiceException("下发失败,生产计划不存在"); |
| | | List<Long> planIds = productionPlanDto.getIds().stream() |
| | | .filter(Objects::nonNull) |
| | | .distinct() |
| | | .collect(Collectors.toList()); |
| | | if (planIds.isEmpty()) { |
| | | throw new ServiceException("下发失败,未选择生产计划"); |
| | | } |
| | | |
| | | // 校验是否存在不同的产品名称 |
| | | String firstProductName = plans.get(0).getProductName(); |
| | | if (plans.stream().anyMatch(p -> p.getProductName() == null || !p.getProductName().equals(firstProductName))) { |
| | | throw new BaseException("合并失败,存在不同的产品名称"); |
| | | List<ProductionPlanDto> plans = productionPlanMapper.selectWithMaterialByIds(planIds); |
| | | if (plans == null || plans.isEmpty() || plans.size() != planIds.size()) { |
| | | throw new ServiceException("下发失败,生产计划不存在或已被删除"); |
| | | } |
| | | |
| | | // 校验是否存在不同的产品规格 |
| | | String firstProductSpec = plans.get(0).getModel(); |
| | | if (plans.stream().anyMatch(p -> p.getModel() == null || !p.getModel().equals(firstProductSpec))) { |
| | | throw new BaseException("合并失败,存在不同的产品规格"); |
| | | ProductionPlanDto firstPlan = plans.getFirst(); |
| | | if (firstPlan.getProductModelId() == null) { |
| | | throw new ServiceException("下发失败,生产计划缺少产品型号"); |
| | | } |
| | | |
| | | // 创建生产订单 |
| | | boolean hasDifferentModel = plans.stream() |
| | | .anyMatch(item -> !Objects.equals(item.getProductModelId(), firstPlan.getProductModelId())); |
| | | if (hasDifferentModel) { |
| | | throw new BaseException("合并失败,所选生产计划的产品型号不一致"); |
| | | } |
| | | |
| | | boolean hasIssuedPlan = plans.stream() |
| | | .anyMatch(item -> item.getStatus() != null && item.getStatus() != PLAN_STATUS_WAIT); |
| | | if (hasIssuedPlan) { |
| | | throw new BaseException("合并失败,所选生产计划存在已下发或部分下发数据"); |
| | | } |
| | | |
| | | BigDecimal totalRequiredQuantity = plans.stream() |
| | | .map(ProductionPlan::getQtyRequired) |
| | | .filter(Objects::nonNull) |
| | | .reduce(BigDecimal.ZERO, BigDecimal::add); |
| | | if (totalRequiredQuantity.compareTo(BigDecimal.ZERO) <= 0) { |
| | | throw new ServiceException("下发失败,所选生产计划需求总量必须大于0"); |
| | | } |
| | | |
| | | BigDecimal assignedQuantity = productionPlanDto.getTotalAssignedQuantity(); |
| | | if (assignedQuantity == null || assignedQuantity.compareTo(BigDecimal.ZERO) <= 0) { |
| | | throw new ServiceException("下发失败,下发数量必须大于0"); |
| | | } |
| | | if (assignedQuantity.compareTo(totalRequiredQuantity) > 0) { |
| | | throw new ServiceException("下发失败,下发数量不能大于计划需求总量"); |
| | | } |
| | | |
| | | ProductionOrder productionOrder = new ProductionOrder(); |
| | | productionOrder.setQuantity(productionPlanDto.getTotalAssignedQuantity()); |
| | | productionOrder.setProductionPlanIds(formatPlanIds(planIds)); |
| | | productionOrder.setProductModelId(firstPlan.getProductModelId()); |
| | | productionOrder.setQuantity(assignedQuantity); |
| | | productionOrder.setPlanCompleteTime(productionPlanDto.getPlanCompleteTime()); |
| | | productionOrder.setStatus(ProductOrderStatusEnum.WAIT.getCode()); |
| | | productionOrder.setStrength(productionPlanDto.getStrength()); |
| | | |
| | | boolean saved = productionOrderService.saveProductionOrder(productionOrder); |
| | | if (!saved) { |
| | | throw new ServiceException("下发失败,生产订单保存失败"); |
| | | } |
| | | |
| | | int targetStatus = assignedQuantity.compareTo(totalRequiredQuantity) < 0 ? PLAN_STATUS_PARTIAL : PLAN_STATUS_ISSUED; |
| | | List<ProductionPlan> updates = planIds.stream().map(id -> { |
| | | ProductionPlan update = new ProductionPlan(); |
| | | update.setId(id); |
| | | update.setStatus(targetStatus); |
| | | return update; |
| | | }).collect(Collectors.toList()); |
| | | if (!updates.isEmpty()) { |
| | | this.updateBatchById(updates); |
| | | } |
| | | return true; |
| | | } |
| | | |
| | |
| | | } |
| | | checkApplyNoUnique(dto.getApplyNo(), null); |
| | | |
| | | dto.setStatus(0); |
| | | dto.setStatus(PLAN_STATUS_WAIT); |
| | | return productionPlanMapper.insert(dto) > 0; |
| | | } |
| | | |
| | |
| | | @Transactional(rollbackFor = Exception.class) |
| | | public boolean update(ProductionPlanDto dto) { |
| | | if (dto == null || dto.getId() == null) { |
| | | throw new ServiceException("编辑失败,数据不能为空"); |
| | | throw new ServiceException("编辑失败,数据不能为空"); |
| | | } |
| | | |
| | | ProductionPlan old = getById(dto.getId()); |
| | | if (old == null) { |
| | | throw new ServiceException("编辑失败,主生产计划不存在"); |
| | | throw new ServiceException("编辑失败,生产计划不存在"); |
| | | } |
| | | |
| | | // 状态校验 |
| | | if (old.getStatus() != 0) { |
| | | throw new BaseException("编辑失败,该生产计划已下发或部分下发状态,禁止编辑"); |
| | | if (old.getStatus() != PLAN_STATUS_WAIT) { |
| | | throw new BaseException("编辑失败,该生产计划已下发或部分下发,禁止编辑"); |
| | | } |
| | | |
| | | // applyNo变更才校验 |
| | | if (StringUtils.isNotBlank(dto.getApplyNo()) |
| | | && !dto.getApplyNo().equals(old.getApplyNo())) { |
| | | if (StringUtils.isNotBlank(dto.getApplyNo()) && !dto.getApplyNo().equals(old.getApplyNo())) { |
| | | checkApplyNoUnique(dto.getApplyNo(), dto.getId()); |
| | | } |
| | | |
| | |
| | | private void checkApplyNoUnique(String applyNo, Long excludeId) { |
| | | LambdaQueryWrapper<ProductionPlan> wrapper = Wrappers.lambdaQuery(); |
| | | wrapper.eq(ProductionPlan::getApplyNo, applyNo); |
| | | |
| | | if (excludeId != null) { |
| | | wrapper.ne(ProductionPlan::getId, excludeId); |
| | | } |
| | | |
| | | if (productionPlanMapper.selectCount(wrapper) > 0) { |
| | | throw new ServiceException("申请单编号 " + applyNo + " 已存在"); |
| | | } |
| | |
| | | @Override |
| | | @Transactional(rollbackFor = Exception.class) |
| | | public boolean delete(List<Long> ids) { |
| | | // 如果存在已下发的计划,则不能删除 |
| | | if (productionPlanMapper.selectList(Wrappers.<ProductionPlan>lambdaQuery().in(ProductionPlan::getId, ids)).stream().anyMatch(p -> p.getStatus() == 1 || p.getStatus() == 2)) { |
| | | if (productionPlanMapper.selectList(Wrappers.<ProductionPlan>lambdaQuery().in(ProductionPlan::getId, ids)) |
| | | .stream() |
| | | .anyMatch(p -> p.getStatus() == PLAN_STATUS_PARTIAL || p.getStatus() == PLAN_STATUS_ISSUED)) { |
| | | throw new BaseException("删除失败,存在已下发或部分下发的计划"); |
| | | } |
| | | // 如果有关联订单,则不能删除 |
| | | if (productionOrderMapper.selectList(Wrappers.<ProductionOrder>lambdaQuery().in(ProductionOrder::getProductionPlanIds, ids)).stream().anyMatch(p -> p.getId() != null)) { |
| | | throw new BaseException("删除失败,存在关联订单"); |
| | | |
| | | if (productionOrderMapper.selectList(Wrappers.<ProductionOrder>lambdaQuery().in(ProductionOrder::getProductionPlanIds, ids)) |
| | | .stream() |
| | | .anyMatch(p -> p.getId() != null)) { |
| | | throw new BaseException("删除失败,存在关联生产订单"); |
| | | } |
| | | |
| | | return productionPlanMapper.deleteBatchIds(ids) > 0; |
| | |
| | | if (file == null || file.isEmpty()) { |
| | | throw new ServiceException("导入数据不能为空"); |
| | | } |
| | | |
| | | ExcelUtil<ProductionPlanImportDto> excelUtil = new ExcelUtil<>(ProductionPlanImportDto.class); |
| | | List<ProductionPlanImportDto> list; |
| | | try { |
| | | list = excelUtil.importExcel(file.getInputStream()); |
| | | } catch (Exception e) { |
| | | log.error("生产需求Excel导入失败", e); |
| | | throw new ServiceException("Excel解析失败"); |
| | | } |
| | | |
| | |
| | | throw new ServiceException("导入失败:第 " + (i + 2) + " 行申请单编号不能为空"); |
| | | } |
| | | if (!applyNos.add(applyNo)) { |
| | | throw new ServiceException("导入失败:Excel 中存在重复的申请单编号: " + applyNo); |
| | | throw new ServiceException("导入失败:Excel 中存在重复的申请单编号 " + applyNo); |
| | | } |
| | | if (StringUtils.isEmpty(materialCode)) { |
| | | throw new ServiceException("导入失败:第 " + (i + 2) + " 行物料编码不能为空"); |
| | | } |
| | | |
| | | String strength = dto.getStrength(); |
| | | if (StringUtils.isNotEmpty(strength)) { |
| | | if (!"A3.5".equals(strength) && !"A5.0".equals(strength)) { |
| | | throw new ServiceException("导入失败:第 " + (i + 2) + " 行强度只能是 A3.5 或 A5.0"); |
| | | } |
| | | if (StringUtils.isNotEmpty(strength) && !"A3.5".equals(strength) && !"A5.0".equals(strength)) { |
| | | throw new ServiceException("导入失败:第 " + (i + 2) + " 行强度只能是 A3.5 或 A5.0"); |
| | | } |
| | | |
| | | materialCodes.add(materialCode); |
| | | } |
| | | |
| | | // 申请单编号是否已存在 |
| | | Long existApplyNoCount = baseMapper.selectCount(Wrappers.<ProductionPlan>lambdaQuery() |
| | | .in(ProductionPlan::getApplyNo, applyNos)); |
| | | if (existApplyNoCount > 0) { |
| | | List<String> existApplyNos = baseMapper.selectList(Wrappers.<ProductionPlan>lambdaQuery() |
| | | .in(ProductionPlan::getApplyNo, applyNos)) |
| | | .stream().map(ProductionPlan::getApplyNo).collect(Collectors.toList()); |
| | | .stream() |
| | | .map(ProductionPlan::getApplyNo) |
| | | .collect(Collectors.toList()); |
| | | throw new ServiceException("导入失败,申请单编号已存在: " + String.join(", ", existApplyNos)); |
| | | } |
| | | |
| | |
| | | List<ProductionPlan> entityList = list.stream().map(dto -> { |
| | | ProductionPlan entity = new ProductionPlan(); |
| | | BeanUtils.copyProperties(dto, entity); |
| | | entity.setStatus(0); |
| | | entity.setStatus(PLAN_STATUS_WAIT); |
| | | entity.setCreateTime(now); |
| | | entity.setUpdateTime(now); |
| | | return entity; |
| | |
| | | ExcelUtil<ProductionPlanImportDto> util = new ExcelUtil<>(ProductionPlanImportDto.class); |
| | | util.exportExcel(response, exportList, "销售生产需求数据"); |
| | | } |
| | | |
| | | private String formatPlanIds(List<Long> planIds) { |
| | | return planIds.stream() |
| | | .filter(Objects::nonNull) |
| | | .distinct() |
| | | .map(String::valueOf) |
| | | .collect(Collectors.joining(",", "[", "]")); |
| | | } |
| | | } |