| src/main/resources/mapper/stock/StockInRecordMapper.xml | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
src/main/resources/mapper/stock/StockInRecordMapper.xml
@@ -21,9 +21,9 @@ pm.unit, u.nick_name as createBy, CASE WHEN #{params.topParentProductId} = 278 AND TRIM(sir.record_type) = '7' THEN WHEN TRIM(sir.record_type) = '7' THEN COALESCE(pl_by_product.purchase_contract_number, pl_direct.purchase_contract_number) WHEN #{params.topParentProductId} = 278 AND TRIM(sir.record_type) = '10' THEN WHEN TRIM(sir.record_type) = '10' THEN pl_by_quality.purchase_contract_number WHEN #{params.topParentProductId} = 276 THEN CASE