product-inventory-management-after.git

			@@ -127,7 +127,7 @@
			id AS root_id,
			product_name AS root_name
			FROM product
			WHERE product_name IN ('原料', '半成品', '成品')
			WHERE product_name IN ('原材料', '半成品', '成品')
			UNION ALL
			SELECT p.id,
			p.parent_id,
			@@ -137,7 +137,7 @@
			FROM product p
			INNER JOIN product_tree pt ON p.parent_id = pt.id)
			SELECT CASE pt.root_name
			WHEN '原料' THEN 0
			WHEN '原材料' THEN 0
			WHEN '半成品' THEN 1
			WHEN '成品' THEN 2
			END AS modelType,
			@@ -159,12 +159,12 @@
			WITH RECURSIVE product_tree AS (SELECT id,
			product_name,
			CASE product_name
			WHEN '原料' THEN 0
			WHEN '原材料' THEN 0
			WHEN '半成品' THEN 1
			WHEN '成品' THEN 2
			END AS modelType
			FROM product
			WHERE product_name IN ('原料', '半成品', '成品')
			WHERE product_name IN ('原材料', '半成品', '成品')

			UNION ALL

			@@ -215,12 +215,12 @@
			product_tree AS (SELECT id,
			product_name,
			CASE product_name
			WHEN '原料' THEN 0
			WHEN '原材料' THEN 0
			WHEN '半成品' THEN 1
			WHEN '成品' THEN 2
			END AS modelType
			FROM product
			WHERE product_name IN ('原料', '半成品', '成品')
			WHERE product_name IN ('原材料', '半成品', '成品')

			UNION ALL

			@@ -283,12 +283,12 @@
			product_tree AS (SELECT id,
			product_name,
			CASE product_name
			WHEN '原料' THEN 0
			WHEN '原材料' THEN 0
			WHEN '半成品' THEN 1
			WHEN '成品' THEN 2
			END AS modelType
			FROM product
			WHERE product_name IN ('原料', '半成品', '成品')
			WHERE product_name IN ('原材料', '半成品', '成品')

			UNION ALL

			@@ -333,7 +333,7 @@
			WHERE month_num < 12),
			product_tree AS (SELECT id, product_name AS root_name
			FROM product
			WHERE product_name IN ('原料', '半成品', '成品')
			WHERE product_name IN ('原材料', '半成品', '成品')

			UNION ALL

			@@ -355,7 +355,7 @@
			WHEN 12 THEN '十二月'
			END AS month,

			COALESCE(SUM(CASE WHEN pt.root_name = '原料' THEN qi.quantity ELSE 0 END), 0) AS rawMaterialCount,
			COALESCE(SUM(CASE WHEN pt.root_name = '原材料' THEN qi.quantity ELSE 0 END), 0) AS rawMaterialCount,

			COALESCE(SUM(CASE WHEN pt.root_name = '半成品' THEN qi.quantity ELSE 0 END), 0) AS processCount,

			@@ -380,7 +380,7 @@
			root_node AS (SELECT id, product_name
			FROM product
			WHERE (
			(#{modelType} = 1 AND product_name = '原料')
			(#{modelType} = 1 AND product_name = '原材料')
			OR (#{modelType} = 2 AND product_name = '半成品')
			OR (#{modelType} = 3 AND product_name = '成品')
			)),
			@@ -392,11 +392,11 @@
			INNER JOIN target_ids ti ON p.parent_id = ti.id),
			parameter_counts AS (SELECT qip.parameter_item AS name,
			COUNT(*) AS count
			FROM quality_inspect_param qip
			JOIN quality_inspect qi ON qip.inspect_id = qi.id
			WHERE qi.inspect_state = 1
			AND qi.product_id IN (SELECT id FROM target_ids)
			GROUP BY qip.parameter_item),
			FROM quality_inspect_param qip
			JOIN quality_inspect qi ON qip.inspect_id = qi.id
			WHERE qi.inspect_state = 1
			AND qi.product_id IN (SELECT id FROM target_ids)
			GROUP BY qip.parameter_item),
			ranked AS (SELECT name, count, ROW_NUMBER() OVER (ORDER BY count DESC) AS rn
			FROM parameter_counts),
			total AS (SELECT SUM(count) AS total_count