1.7K Star 11.7K Fork 5.3K

GVP季圣华 / 华夏ERP

 / 详情

采购订单的sql有问题

已完成
创建于  
2020-09-19 16:19

正常的构造应该下面这个逻辑, 应该去掉distinct

SELECT 
	s.supplier supplier_name, 
	dh.number as check_number,
	(
	SELECT	GROUP_CONCAT(concat( jsh_material.`Name`, ' ', jsh_material.Model )) AS mName 
    FROM jsh_depot_item
	 INNER JOIN jsh_material ON jsh_material.tenant_id = 63 
	                        AND jsh_depot_item.material_id = jsh_material.Id 
													AND ifnull( jsh_material.delete_Flag, '0' ) != '1' 
	WHERE	jsh_depot_item.tenant_id = 63 
		AND jsh_depot_item.header_id = dh.id 
		AND ifnull( jsh_depot_item.delete_flag, '0' ) != '1'
	) as name,
	dh.create_time,
	u.username userName, 
	dh.total_price,
	a.name AccountName
FROM jsh_depot_head dh
	LEFT JOIN jsh_supplier s ON s.tenant_id = 63 AND dh.organ_id = s.id AND ifnull( s.delete_Flag, '0' ) != '1'
	LEFT JOIN jsh_user u ON u.tenant_id = 63 	AND dh.creator = u.id AND ifnull( u.STATUS, '0' ) = '0'
	LEFT JOIN jsh_account a ON a.tenant_id = 63 AND dh.account_id = a.id 	AND ifnull( a.delete_Flag, '0' ) != '1'
-- 	LEFT JOIN jsh_depot_item di ON di.tenant_id = 63 	AND dh.id = di.header_id 	AND ifnull( di.delete_flag, '0' ) != '1'
-- 	LEFT JOIN jsh_material m ON m.tenant_id = 63 	AND di.material_id = m.id AND ifnull( m.delete_flag, '0' ) != '1' 
WHERE	dh.tenant_id = 63 
	AND dh.type = '其它' 
	AND dh.sub_type = '采购订单' 
	AND ifnull( dh.delete_flag, '0' ) != '1'```

评论 (1)

林贵南 创建了任务
林贵南 关联仓库设置为季圣华/华夏ERP
展开全部操作日志

这样没法按仓库查询了,仓库在子表里面

季圣华 任务状态待办的 修改为已完成

登录 后才可以发表评论

状态
负责人
里程碑
Pull Requests
关联的 Pull Requests 被合并后可能会关闭此 issue
分支
开始日期   -   截止日期
-
置顶选项
优先级
参与者(2)
852955 jishenghua 1652086470
Java
1
https://gitee.com/jishenghua/JSH_ERP.git
git@gitee.com:jishenghua/JSH_ERP.git
jishenghua
JSH_ERP
华夏ERP

搜索帮助

14c37bed 8189591 565d56ea 8189591