fix(stock):库存展示数量大于0的

liding

2026-05-22 c3551de690694ea9cb44702b289c0d1539676c44

fix(stock):库存展示数量大于0的

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

@@ -203,6 +203,7 @@
            </if>
        </where>
        group by product_model_id, model, unit, product_name, product_id, unQualifiedBatchNo, materialCode, processCategory, voltage
        having SUM(qualifiedQuantity) > 0 or SUM(unQualifiedQuantity) > 0
    </select>

    <select id="listStockInventoryExportData" resultType="com.ruoyi.stock.execl.StockInventoryExportData">
@@ -296,6 +297,7 @@
            </if>
        </where>
        group by product_model_id, model, unit, product_name, unQualifiedBatchNo, materialCode, processCategory, voltage
        having SUM(qualifiedQuantity) > 0 or SUM(unQualifiedQuantity) > 0
    </select>
    <select id="stockInventoryPage" resultType="com.ruoyi.stock.dto.StockInRecordDto">
        select sir.*,si.qualitity as current_stock,