fix(mapper): 修正ProductWorkOrderMapper中设备字段的表别名

buhuazhen

2026-04-21 676bf75ce7b296ddf0a79cd4c276085e09e254c6

fix(mapper): 修正ProductWorkOrderMapper中设备字段的表别名

- 将设备ID和设备名称的字段别名由ppm修改为pp
- 修正查询中的表连接别名，确保字段引用正确
- 更新GROUP BY子句中相关字段的别名一致性
- 保证查询结果字段与表结构匹配，避免潜在错误

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

@@ -60,8 +60,8 @@
            po.nps_no AS productOrderNpsNo,
            ROUND(pwo.complete_quantity / pwo.plan_quantity * 100, 2) AS completionStatus,
            sum(ppo.scrap_qty) scrapQty,
            ppm.device_id,
            ppm.device_name
            pp.device_id,
            pp.device_name
        FROM
            product_work_order pwo
                LEFT JOIN product_process_route_item ppri ON ppri.id = pwo.product_process_route_item_id
@@ -73,8 +73,8 @@
                LEFT JOIN product p ON p.id = pm.product_id
        WHERE pwo.id = #{id}
        GROUP BY pwo.id, pwo.product_process_route_item_id, pwo.create_time, pwo.update_time, pwo.work_order_no, pwo.plan_start_time, pwo.plan_end_time, pwo.actual_start_time, pwo.actual_end_time, pwo.status, pwo.tenant_id, pwo.plan_quantity, pwo.product_order_id, pwo.complete_quantity,
                 ppm.device_id,
                 ppm.device_name,
                 pp.device_id,
                 pp.device_name,
                 pp.NAME ,
                 pm.model,
                 pm.unit,