华夏ERP官网

 找回密码
 立即注册
搜索
查看: 622|回复: 4

v3.0无法添加采购订单

[复制链接]

1

主题

0

好友

17

积分

新手上路

Rank: 1

发表于 2021-12-31 00:04:27 |显示全部楼层
错误日志:
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

12a6264e08fbb6df9cac70f6190c9cc.png
0fccd22e7b4b13868f4a39c8a73d43d.png
回复

使用道具 举报

2

主题

0

好友

26

积分

新手上路

Rank: 1

发表于 2022-2-20 14:15:58 |显示全部楼层
是的,我的搭建了,无法新增采购订单
回复

使用道具 举报

8

主题

0

好友

188

积分

注册会员

Rank: 2

发表于 2022-2-23 15:48:20 |显示全部楼层
有可能是redis 没有设置好吧
回复

使用道具 举报

55

主题

0

好友

1116

积分

管理员

Rank: 9Rank: 9Rank: 9

发表于 2022-2-24 23:10:41 |显示全部楼层
这个日志是DEBUG,常规打印,不是错误日志,不好排查啊
回复

使用道具 举报

1

主题

0

好友

17

积分

新手上路

Rank: 1

发表于 2022-3-3 17:02:28 |显示全部楼层
jishenghua 发表于 2022-2-24 23:10
这个日志是DEBUG,常规打印,不是错误日志,不好排查啊

数据库问题,已经解决了
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

QQ|QQ群:732152262|Archiver|华夏ERP官网

GMT+8, 2022-7-7 21:32 , Processed in 0.024967 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部