v3.0无法添加采购订单

错误日志：
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

是的，我的搭建了，无法新增采购订单

有可能是redis 没有设置好吧

这个日志是DEBUG，常规打印，不是错误日志，不好排查啊

jishenghua 发表于 2022-2-24 23:10
这个日志是DEBUG，常规打印，不是错误日志，不好排查啊

数据库问题，已经解决了