package cn.iocoder.yudao.module.mes.controller.admin.pro.mps;
|
|
import cn.hutool.core.collection.CollUtil;
|
import cn.hutool.core.collection.ListUtil;
|
import cn.iocoder.yudao.framework.apilog.core.annotation.ApiAccessLog;
|
import cn.iocoder.yudao.framework.common.pojo.CommonResult;
|
import cn.iocoder.yudao.framework.common.pojo.PageParam;
|
import cn.iocoder.yudao.framework.common.pojo.PageResult;
|
import cn.iocoder.yudao.framework.common.util.collection.MapUtils;
|
import cn.iocoder.yudao.framework.common.util.object.BeanUtils;
|
import cn.iocoder.yudao.framework.excel.core.util.ExcelUtils;
|
import cn.iocoder.yudao.module.mes.controller.admin.pro.mps.vo.MesProMpsAuditReqVO;
|
import cn.iocoder.yudao.module.mes.controller.admin.pro.mps.vo.MesProMpsPageReqVO;
|
import cn.iocoder.yudao.module.mes.controller.admin.pro.mps.vo.MesProMpsRespVO;
|
import cn.iocoder.yudao.module.mes.controller.admin.pro.mps.vo.MesProMpsSaveReqVO;
|
import cn.iocoder.yudao.module.mes.controller.admin.pro.workorder.vo.MesProWorkOrderItemRespVO;
|
import cn.iocoder.yudao.module.crm.api.customer.CrmCustomerApi;
|
import cn.iocoder.yudao.module.crm.api.customer.dto.CrmCustomerRespDTO;
|
import cn.iocoder.yudao.module.mes.dal.dataobject.md.item.MesMdItemDO;
|
import cn.iocoder.yudao.module.mes.dal.dataobject.md.unitmeasure.MesMdUnitMeasureDO;
|
import cn.iocoder.yudao.module.mes.dal.dataobject.pro.mps.MesProMpsDO;
|
import cn.iocoder.yudao.module.mes.enums.pro.MesProMpsStatusEnum;
|
import cn.iocoder.yudao.module.mes.service.md.item.MesMdItemService;
|
import cn.iocoder.yudao.module.mes.service.md.unitmeasure.MesMdUnitMeasureService;
|
import cn.iocoder.yudao.module.mes.service.pro.mps.MesProMpsService;
|
import cn.iocoder.yudao.module.system.api.user.AdminUserApi;
|
import cn.iocoder.yudao.module.system.api.user.dto.AdminUserRespDTO;
|
import io.swagger.v3.oas.annotations.Operation;
|
import io.swagger.v3.oas.annotations.Parameter;
|
import io.swagger.v3.oas.annotations.tags.Tag;
|
import jakarta.annotation.Resource;
|
import jakarta.servlet.http.HttpServletResponse;
|
import jakarta.validation.Valid;
|
import org.springframework.security.access.prepost.PreAuthorize;
|
import org.springframework.validation.annotation.Validated;
|
import org.springframework.web.bind.annotation.*;
|
|
import java.io.IOException;
|
import java.math.BigDecimal;
|
import java.math.RoundingMode;
|
import java.time.Duration;
|
import java.time.LocalDateTime;
|
import java.util.Collections;
|
import java.util.List;
|
import java.util.Map;
|
|
import static cn.iocoder.yudao.framework.apilog.core.enums.OperateTypeEnum.EXPORT;
|
import static cn.iocoder.yudao.framework.common.pojo.CommonResult.success;
|
import static cn.iocoder.yudao.framework.common.util.collection.CollectionUtils.convertSet;
|
|
@Tag(name = "管理后台 - MES 生产主计划")
|
@RestController
|
@RequestMapping("/mes/pro-mps")
|
@Validated
|
public class MesProMpsController {
|
|
@Resource
|
private MesProMpsService mpsService;
|
@Resource
|
private MesMdItemService itemService;
|
@Resource
|
private MesMdUnitMeasureService unitMeasureService;
|
@Resource
|
private CrmCustomerApi customerApi;
|
@Resource
|
private AdminUserApi adminUserApi;
|
|
@PostMapping("/create")
|
@Operation(summary = "创建生产主计划")
|
@PreAuthorize("@ss.hasPermission('mes:pro-mps:create')")
|
public CommonResult<Long> createMps(@Valid @RequestBody MesProMpsSaveReqVO createReqVO) {
|
return success(mpsService.createMps(createReqVO));
|
}
|
|
@PutMapping("/update")
|
@Operation(summary = "更新生产主计划")
|
@PreAuthorize("@ss.hasPermission('mes:pro-mps:update')")
|
public CommonResult<Boolean> updateMps(@Valid @RequestBody MesProMpsSaveReqVO updateReqVO) {
|
mpsService.updateMps(updateReqVO);
|
return success(true);
|
}
|
|
@DeleteMapping("/delete")
|
@Operation(summary = "删除生产主计划")
|
@Parameter(name = "id", description = "编号", required = true)
|
@PreAuthorize("@ss.hasPermission('mes:pro-mps:delete')")
|
public CommonResult<Boolean> deleteMps(@RequestParam("id") Long id) {
|
mpsService.deleteMps(id);
|
return success(true);
|
}
|
|
@GetMapping("/get")
|
@Operation(summary = "获得生产主计划")
|
@Parameter(name = "id", description = "编号", required = true, example = "1024")
|
public CommonResult<MesProMpsRespVO> getMps(@RequestParam("id") Long id) {
|
MesProMpsDO mps = mpsService.getMps(id);
|
if (mps == null) {
|
return success(null);
|
}
|
return success(buildMpsRespVOList(ListUtil.of(mps)).get(0));
|
}
|
|
@GetMapping("/page")
|
@Operation(summary = "获得生产主计划分页")
|
public CommonResult<PageResult<MesProMpsRespVO>> getMpsPage(@Valid MesProMpsPageReqVO pageReqVO) {
|
PageResult<MesProMpsDO> pageResult = mpsService.getMpsPage(pageReqVO);
|
return success(new PageResult<>(buildMpsRespVOList(pageResult.getList()), pageResult.getTotal()));
|
}
|
|
@GetMapping("/export-excel")
|
@Operation(summary = "导出生产主计划 Excel")
|
@PreAuthorize("@ss.hasPermission('mes:pro-mps:export')")
|
@ApiAccessLog(operateType = EXPORT)
|
public void exportMpsExcel(@Valid MesProMpsPageReqVO pageReqVO,
|
HttpServletResponse response) throws IOException {
|
pageReqVO.setPageSize(PageParam.PAGE_SIZE_NONE);
|
List<MesProMpsDO> list = mpsService.getMpsPage(pageReqVO).getList();
|
List<MesProMpsRespVO> voList = buildMpsRespVOList(list);
|
ExcelUtils.write(response, "生产主计划.xls", "数据", MesProMpsRespVO.class, voList);
|
}
|
|
@PostMapping("/issue")
|
@Operation(summary = "下发生产主计划")
|
@Parameter(name = "id", description = "MPS 编号", required = true)
|
@PreAuthorize("@ss.hasPermission('mes:pro-mps:issue')")
|
public CommonResult<Long> issueMps(@RequestParam("id") Long id) {
|
return success(mpsService.issueMps(id));
|
}
|
|
@PostMapping("/merge-issue")
|
@Operation(summary = "合并下发生产主计划")
|
@PreAuthorize("@ss.hasPermission('mes:pro-mps:merge-issue')")
|
public CommonResult<Long> mergeAndIssueMps(@RequestBody List<Long> mpsIds) {
|
return success(mpsService.mergeAndIssueMps(mpsIds));
|
}
|
|
@PostMapping("/cancel")
|
@Operation(summary = "取消生产主计划")
|
@Parameter(name = "id", description = "MPS 编号", required = true)
|
@PreAuthorize("@ss.hasPermission('mes:pro-mps:cancel')")
|
public CommonResult<Boolean> cancelMps(@RequestParam("id") Long id) {
|
mpsService.cancelMps(id);
|
return success(true);
|
}
|
|
@PostMapping("/submit")
|
@Operation(summary = "提交生产主计划审核")
|
@Parameter(name = "id", description = "MPS 编号", required = true)
|
@PreAuthorize("@ss.hasPermission('mes:pro-mps:submit')")
|
public CommonResult<Boolean> submitMps(@RequestParam("id") Long id) {
|
mpsService.submitMps(id);
|
return success(true);
|
}
|
|
@PostMapping("/audit")
|
@Operation(summary = "审核生产主计划")
|
@PreAuthorize("@ss.hasPermission('mes:pro-mps:audit')")
|
public CommonResult<Boolean> auditMps(@Valid @RequestBody MesProMpsAuditReqVO reqVO) {
|
mpsService.auditMps(reqVO);
|
return success(true);
|
}
|
|
@GetMapping("/item-list")
|
@Operation(summary = "获得生产主计划辅料需求列表")
|
@Parameter(name = "id", description = "MPS 编号", required = true)
|
public CommonResult<List<MesProWorkOrderItemRespVO>> getMpsItemList(@RequestParam("id") Long id) {
|
return success(mpsService.getMpsItemList(id));
|
}
|
|
@PostMapping("/generate-purchase-request")
|
@Operation(summary = "根据生产主计划辅料缺口生成采购申请单")
|
@Parameter(name = "id", description = "MPS 编号", required = true)
|
@PreAuthorize("@ss.hasPermission('mes:pro-mps:generate-purchase')")
|
public CommonResult<Long> generatePurchaseRequest(@RequestParam("id") Long id) {
|
return success(mpsService.generatePurchaseRequest(id));
|
}
|
|
// ==================== 拼接 VO ====================
|
|
private List<MesProMpsRespVO> buildMpsRespVOList(List<MesProMpsDO> list) {
|
if (CollUtil.isEmpty(list)) {
|
return Collections.emptyList();
|
}
|
// 1. 批量获取关联数据
|
Map<Long, MesMdItemDO> itemMap = itemService.getItemMap(
|
convertSet(list, MesProMpsDO::getProductId));
|
Map<Long, MesMdUnitMeasureDO> unitMap = unitMeasureService.getUnitMeasureMap(
|
convertSet(itemMap.values(), MesMdItemDO::getUnitMeasureId));
|
Map<Long, CrmCustomerRespDTO> clientMap = customerApi.getCustomerMap(
|
convertSet(list, MesProMpsDO::getClientId));
|
Map<Long, AdminUserRespDTO> auditUserMap = adminUserApi.getUserMap(
|
convertSet(list, MesProMpsDO::getAuditUserId));
|
// 2. 拼接 VO
|
return BeanUtils.toBean(list, MesProMpsRespVO.class, vo -> {
|
MapUtils.findAndThen(itemMap, vo.getProductId(), item -> {
|
vo.setProductName(item.getName())
|
.setProductCode(item.getCode())
|
.setProductSpecification(item.getSpecification());
|
MapUtils.findAndThen(unitMap, item.getUnitMeasureId(),
|
unit -> vo.setUnitMeasureName(unit.getName()));
|
});
|
MapUtils.findAndThen(clientMap, vo.getClientId(),
|
client -> vo.setClientName(client.getName()));
|
MapUtils.findAndThen(auditUserMap, vo.getAuditUserId(),
|
user -> vo.setAuditUserName(user.getNickname()));
|
vo.setProgressWarning(buildProgressWarning(vo));
|
});
|
}
|
|
/**
|
* 计算执行进度预警：已下发计划按“工期已过比例 - 实际完成比例”判断，偏差达到 20% 提示
|
*/
|
private String buildProgressWarning(MesProMpsRespVO vo) {
|
if (!MesProMpsStatusEnum.ISSUED.getStatus().equals(vo.getStatus())) {
|
return null;
|
}
|
LocalDateTime start = vo.getIssueDate() != null ? vo.getIssueDate() : vo.getPlanStartDate();
|
LocalDateTime end = vo.getRequestDate();
|
if (start == null || end == null || !end.isAfter(start)) {
|
return null;
|
}
|
long totalMinutes = Duration.between(start, end).toMinutes();
|
long elapsedMinutes = Duration.between(start, LocalDateTime.now()).toMinutes();
|
double plannedRatio = Math.min(1D, Math.max(0D, (double) elapsedMinutes / totalMinutes));
|
BigDecimal quantity = vo.getQuantity() != null ? vo.getQuantity() : BigDecimal.ZERO;
|
BigDecimal produced = vo.getQuantityProduced() != null ? vo.getQuantityProduced() : BigDecimal.ZERO;
|
double producedRatio = quantity.compareTo(BigDecimal.ZERO) > 0
|
? Math.min(1D, produced.divide(quantity, 4, RoundingMode.HALF_UP).doubleValue())
|
: 0D;
|
if (plannedRatio - producedRatio < 0.2D) {
|
return null;
|
}
|
return String.format("工期已过 %d%%，实际完成 %d%%，存在进度偏差，请排查瓶颈工序",
|
Math.round(plannedRatio * 100), Math.round(producedRatio * 100));
|
}
|
|
}
|
