fix: 工艺路线子集SQL去除产品查询

gongchunyi

6 小时以前 285fa628a51ccc480ee946d2a1ee5bd13e9ae65a

fix: 工艺路线子集SQL去除产品查询

 src/main/java/com/ruoyi/production/controller/ProductOrderController.java

@@ -19,7 +19,7 @@
import java.math.BigDecimal;
import java.util.List;

@RequestMapping("productOrder")
@RequestMapping("/productOrder")
@RestController
@Api(tags = "生产订单")
public class ProductOrderController {
@@ -29,7 +29,7 @@


    @ApiOperation("分页查询")
    @GetMapping("page")
    @GetMapping("/page")
    public R page(ProductOrderDto productOrder, Page<ProductOrder> page) {
        return R.ok(productOrderService.pageProductOrder(page, productOrder));
    }

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

@@ -17,18 +17,12 @@
        select pri.*,
               pr.description,
               pp.name                             as process_name,
               pms.product_id,
               pms.model,
               pm.product_name,
               pm.unit,
               (SELECT COUNT(1)
                FROM process_route_item_param prip
                WHERE prip.route_item_id = pri.id) as paramCount
        from process_route_item pri
                 left join process_route pr on pr.id = pri.route_id
                 left join product_process pp on pp.id = pri.process_id
                 left join product_material_sku pms on pms.id = pri.product_model_id
                 left join product_material pm on pm.id = pms.product_id
        where pri.route_id = #{c.routeId}
        order by pri.drag_sort
    </select>