错误日志:
2021/12/30-23:59:26 DEBUG [http-nio-9999-exec-5] com.jsh.erp.datasource.mappers.DepotItemMapperEx.getStockByParamWithDepotList - ==> Preparing: SELECT sum(CASE WHEN dh.type = '入库' AND di.depot_id IN (?) THEN di.basic_number ELSE 0 END) AS inTotal, sum(CASE WHEN dh.type = '出库' AND dh.sub_type != '调拨' AND di.depot_id IN (?) THEN di.basic_number ELSE 0 END) AS outTotal, sum(CASE WHEN dh.sub_type = '调拨' AND di.another_depot_id IN (?) THEN di.basic_number ELSE 0 END) AS transfInTotal, sum(CASE WHEN dh.sub_type = '调拨' AND di.depot_id IN (?) THEN di.basic_number ELSE 0 END) AS transfOutTotal, sum(CASE WHEN dh.sub_type = '组装单' AND di.material_type = '组合件' AND di.depot_id IN (?) THEN di.basic_number ELSE 0 END) AS assemInTotal, sum(CASE WHEN dh.sub_type = '组装单' AND di.material_type = '普通子件' AND di.depot_id IN (?) THEN di.basic_number ELSE 0 END) AS assemOutTotal, sum(CASE WHEN dh.sub_type = '拆卸单' AND di.material_type = '普通子件' AND di.depot_id IN (?) THEN di.basic_number ELSE 0 END) AS disAssemInTotal, sum(CASE WHEN dh.sub_type = '拆卸单' AND di.material_type = '组合件' AND di.depot_id IN (?) THEN di.basic_number ELSE 0 END) AS disAssemOutTotal FROM jsh_depot_head dh LEFT JOIN jsh_depot_item di ON di.tenant_id = 63 AND dh.id = di.header_id AND ifnull(di.delete_flag, '0') != '1' WHERE dh.tenant_id = 63 AND 1 = 1 AND ifnull(dh.delete_flag, '0') != '1' AND di.material_id = ?
2021/12/30-23:59:26 DEBUG [http-nio-9999-exec-5] com.jsh.erp.datasource.mappers.DepotItemMapperEx.getStockByParamWithDepotList - ==> Parameters: 14(Long), 14(Long), 14(Long), 14(Long), 14(Long), 14(Long), 14(Long), 14(Long), 587(Long)
2021/12/30-23:59:26 DEBUG [http-nio-9999-exec-5] com.jsh.erp.datasource.mappers.DepotItemMapperEx.getStockByParamWithDepotList - <== Total: 1
Time:16 ms - ID:com.jsh.erp.datasource.mappers.DepotItemMapperEx.getStockByParamWithDepotList
Execute SQL:SELECT sum(CASE WHEN dh.type = '入库' AND di.depot_id IN (14) THEN di.basic_number ELSE 0 END) AS inTotal, sum(CASE WHEN dh.type = '出库' AND dh.sub_type != '调拨' AND di.depot_id IN (14) THEN di.basic_number ELSE 0 END) AS outTotal, sum(CASE WHEN dh.sub_type = '调拨' AND di.another_depot_id IN (14) THEN di.basic_number ELSE 0 END) AS transfInTotal, sum(CASE WHEN dh.sub_type = '调拨' AND di.depot_id IN (14) THEN di.basic_number ELSE 0 END) AS transfOutTotal, sum(CASE WHEN dh.sub_type = '组装单' AND di.material_type = '组合件' AND di.depot_id IN (14) THEN di.basic_number ELSE 0 END) AS assemInTotal, sum(CASE WHEN dh.sub_type = '组装单' AND di.material_type = '普通子件' AND di.depot_id IN (14) THEN di.basic_number ELSE 0 END) AS assemOutTotal, sum(CASE WHEN dh.sub_type = '拆卸单' AND di.material_type = '普通子件' AND di.depot_id IN (14) THEN di.basic_number ELSE 0 END) AS disAssemInTotal, sum(CASE WHEN dh.sub_type = '拆卸单' AND di.material_type = '组合件' AND di.depot_id IN (14) THEN di.basic_number ELSE 0 END) AS disAssemOutTotal FROM jsh_depot_head dh LEFT JOIN jsh_depot_item di ON di.tenant_id = 63 AND dh.id = di.header_id AND ifnull(di.delete_flag, '0') != '1' WHERE dh.tenant_id = 63 AND 1 = 1 AND ifnull(dh.delete_flag, '0') != '1' AND di.material_id = 587
|