修改报工审批查询

huminmin

19 小时以前 c9cd6e47dbdf173060496f3d8ce0f228f6a17cda

修改报工审批查询

 src/main/java/com/ruoyi/production/bean/dto/ProductionProductMainDto.java

@@ -54,6 +54,12 @@
    @Schema(description = "数量")
    private BigDecimal quantity;

    @Schema(description = "排产数量")
    private BigDecimal schedulingNum;

    @Schema(description = "待生产数量")
    private BigDecimal pendingNum;

    @Schema(description = "报废数量")
    private BigDecimal scrapQty;


 src/main/java/com/ruoyi/production/service/impl/ProductionProductMainServiceImpl.java

@@ -459,10 +459,28 @@
        formConfig.put("summaryPlaceholder", "报工审批");
        formConfig.put("approvalType", "production_report");

        ProductionOperationTask task = productionOperationTaskMapper.selectById(productionProductMain.getProductionOperationTaskId());
        ProductionProductOutput output = productionProductOutputMapper.selectOne(
                Wrappers.<ProductionProductOutput>lambdaQuery()
                        .eq(ProductionProductOutput::getProductionProductMainId, productionProductMain.getId())
                        .last("limit 1"));
        BigDecimal schedulingNum = task == null ? BigDecimal.ZERO : defaultDecimal(task.getPlanQuantity());
        BigDecimal finishedNum = output == null ? BigDecimal.ZERO : defaultDecimal(output.getQuantity());
        BigDecimal scrapQty = output == null ? BigDecimal.ZERO : defaultDecimal(output.getScrapQty());
        BigDecimal pendingNum = schedulingNum.subtract(finishedNum);
        if (pendingNum.compareTo(BigDecimal.ZERO) < 0) {
            pendingNum = BigDecimal.ZERO;
        }

        List<Map<String, Object>> fields = new ArrayList<>();
        fields.add(buildReportField("productNo", "报工单号", "text", productionProductMain.getProductNo()));
        fields.add(buildReportField("userName", "报工人员", "text", productionProductMain.getUserName()));
        fields.add(buildReportField("teamInfo", "班组信息", "text", productionProductMain.getUserName()));
        fields.add(buildReportField("workOrderNo", "工单编号", "text", resolveWorkOrderNo(productionProductMain.getProductionOperationTaskId())));
        fields.add(buildReportField("schedulingNum", "排产数量", "number", schedulingNum));
        fields.add(buildReportField("pendingNum", "待生产数量", "number", pendingNum));
        fields.add(buildReportField("finishedNum", "生产合格数量", "number", finishedNum));
        fields.add(buildReportField("scrapQty", "报废数量", "number", scrapQty));
        fields.add(buildReportField("reportType", "报工结果", "select", resolveReportTypeLabel(productionProductMain.getReportType())));
        fields.add(buildReportField("workHour", "工时", "number", productionProductMain.getWorkHour()));
        fields.add(buildReportField("auditStatus", "审核状态", "select", resolveAuditStatusLabel(productionProductMain.getAuditStatus())));
@@ -472,7 +490,12 @@
        Map<String, Object> formPayload = new LinkedHashMap<>();
        formPayload.put("productNo", productionProductMain.getProductNo());
        formPayload.put("userName", productionProductMain.getUserName());
        formPayload.put("teamInfo", productionProductMain.getUserName());
        formPayload.put("workOrderNo", resolveWorkOrderNo(productionProductMain.getProductionOperationTaskId()));
        formPayload.put("schedulingNum", schedulingNum);
        formPayload.put("pendingNum", pendingNum);
        formPayload.put("finishedNum", finishedNum);
        formPayload.put("scrapQty", scrapQty);
        formPayload.put("reportType", resolveReportTypeLabel(productionProductMain.getReportType()));
        formPayload.put("workHour", productionProductMain.getWorkHour());
        formPayload.put("auditStatus", resolveAuditStatusLabel(productionProductMain.getAuditStatus()));

 src/main/resources/mapper/production/ProductionProductMainMapper.xml

@@ -34,6 +34,14 @@
                   else '未知'
                   end as auditStatusName,
               pot.work_order_no as workOrderNo,
               ifnull(pot.plan_quantity, 0) as schedulingNum,
               cast(
                   case
                       when ifnull(pot.plan_quantity, 0) - ifnull(ppo.quantity, 0) &lt; 0 then 0
                       else ifnull(pot.plan_quantity, 0) - ifnull(ppo.quantity, 0)
                   end
                   as decimal(18,4)
               ) as pendingNum,
               case pot.status
                   when 1 then '待确认'
                   when 2 then '待生产'
@@ -131,6 +139,14 @@
                   else '未知'
                   end as auditStatusName,
               pot.work_order_no as workOrderNo,
               ifnull(pot.plan_quantity, 0) as schedulingNum,
               cast(
                   case
                       when ifnull(pot.plan_quantity, 0) - ifnull(ppo.quantity, 0) &lt; 0 then 0
                       else ifnull(pot.plan_quantity, 0) - ifnull(ppo.quantity, 0)
                   end
                   as decimal(18,4)
               ) as pendingNum,
               p.product_name as productName,
               ifnull(p.standard_quantity, 0) as productStandardQuantity,
               pm.model as productModelName,