feat(stock): 出库批次下拉增加客户与合同号信息展示

gaoluyang

9 小时以前 7a58bc3ae9cccf4ee69821a3c7e45f98f1b41114

feat(stock): 出库批次下拉增加客户与合同号信息展示

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

@@ -148,4 +148,7 @@
    // 列表返回为JSON字符串
    private Object loadingPhotos;
    private Object outPoundPhotos;

    // 批次来源（入库记录）绑定的销售台账合同号：油品出库「出库批次」下拉展示用
    private String salesContractNo;
}

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

@@ -736,6 +736,16 @@
        order by sir.id desc
        limit 1
        ) as oil_product,
        <!-- 批次来源的合同：入库记录绑定的销售台账（sales_ledger_id）合同号；客户名称上方 customer_name 已带出 -->
        (
        select sl.sales_contract_no
        from stock_in_record sir
        inner join sales_ledger sl on sl.id = sir.sales_ledger_id
        where sir.product_model_id = combined.product_model_id
        and (sir.batch_no = combined.batch_no or (combined.batch_no is null and sir.batch_no is null))
        order by sir.id desc
        limit 1
        ) as sales_contract_no,
        (
        select sir.tank_inspection_status
        from stock_in_record sir