库存管理列表增加产品规格和批号搜索

huminmin

6 天以前 1211a84c12136d4929d18d478d7e7560050cd74b

库存管理列表增加产品规格和批号搜索

 src/main/java/com/ruoyi/stock/dto/StockInventoryDto.java

@@ -79,4 +79,7 @@

    @Schema(description = "产品id")
    private Long productId;

    @Schema(description = "批次号")
    private String batchNo;
}

 src/main/resources/mapper/stock/StockInventoryMapper.xml

@@ -209,6 +209,12 @@
            <if test="ew.topParentProductId != null and ew.topParentProductId > 0">
                and combined.product_id in (select id from product_tree)
            </if>
            <if test="ew.model != null and ew.model !=''">
                and combined.model like concat('%',#{ew.model},'%')
            </if>
            <if test="ew.batchNo != null and ew.batchNo !=''">
                and combined.batch_no like concat('%',#{ew.batchNo},'%')
            </if>
        </where>
        group by
        product_model_id,