From 4f45f29e6b53f4c01b414409c5000ff4e212b3d9 Mon Sep 17 00:00:00 2001
From: huminmin <mac@MacBook-Pro.local>
Date: 星期五, 05 六月 2026 13:36:54 +0800
Subject: [PATCH] 增加eip

---
 ruoyi-admin/src/main/resources/report_chart_sql.sql |  177 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 177 insertions(+), 0 deletions(-)

diff --git a/ruoyi-admin/src/main/resources/report_chart_sql.sql b/ruoyi-admin/src/main/resources/report_chart_sql.sql
new file mode 100644
index 0000000..90bdbc6
--- /dev/null
+++ b/ruoyi-admin/src/main/resources/report_chart_sql.sql
@@ -0,0 +1,177 @@
+-- =====================================================
+-- 鎶ヨ〃鍥捐〃绠＄悊妯″潡鏁版嵁搴撹剼鏈�
+-- 鎵ц鍓嶈澶囦唤鏁版嵁搴�
+-- 鍒涘缓鏃堕棿: 2026-06-04
+-- =====================================================
+
+-- =============================================
+-- 1. 璇煶鎾姤闃熷垪琛� (voice_queue) - 鏂板
+-- =============================================
+DROP TABLE IF EXISTS `voice_queue`;
+CREATE TABLE `voice_queue` (
+  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '涓婚敭ID',
+  `event_type` varchar(50) NOT NULL COMMENT '浜嬩欢绫诲瀷(sample_receive/task_assign/report_submit/emergency)',
+  `event_name` varchar(100) NOT NULL COMMENT '浜嬩欢鍚嶇О',
+  `details` varchar(500) DEFAULT '' COMMENT '浜嬩欢璇︽儏',
+  `voice_text` varchar(500) NOT NULL COMMENT '璇煶鎾姤鏂囨湰',
+  `priority` int DEFAULT 0 COMMENT '浼樺厛绾�(0鏅��/1閲嶈/2绱ф��)',
+  `status` tinyint DEFAULT 0 COMMENT '鐘舵��(0寰呮挱鎶�/1宸叉挱鎶�/2宸插彇娑�)',
+  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿',
+  PRIMARY KEY (`id`),
+  KEY `idx_status_priority` (`status`, `priority`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='璇煶鎾姤闃熷垪琛�';
+
+-- =============================================
+-- 2. 鎶ヨ〃閰嶇疆琛�
+-- =============================================
+DROP TABLE IF EXISTS `report_config`;
+CREATE TABLE `report_config` (
+  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '涓婚敭ID',
+  `report_name` varchar(100) NOT NULL COMMENT '鎶ヨ〃鍚嶇О',
+  `report_code` varchar(50) NOT NULL COMMENT '鎶ヨ〃缂栫爜',
+  `report_type` varchar(20) NOT NULL COMMENT '鎶ヨ〃绫诲瀷(sample_progress/test_item/sample_record/device_record/dashboard)',
+  `query_config` text COMMENT '鏌ヨ鏉′欢閰嶇疆JSON',
+  `column_config` text COMMENT '鍒楅厤缃甁SON',
+  `chart_config` text COMMENT '鍥捐〃閰嶇疆JSON',
+  `status` tinyint DEFAULT 1 COMMENT '鐘舵��(1鍚敤/0鍋滅敤)',
+  `create_by` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�',
+  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+  `update_by` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�',
+  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿',
+  `remark` varchar(500) DEFAULT '' COMMENT '澶囨敞',
+  PRIMARY KEY (`id`),
+  UNIQUE KEY `uk_report_code` (`report_code`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='鎶ヨ〃閰嶇疆琛�';
+
+-- =============================================
+-- 3. 鍥捐〃閰嶇疆琛�
+-- =============================================
+DROP TABLE IF EXISTS `chart_config`;
+CREATE TABLE `chart_config` (
+  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '涓婚敭ID',
+  `chart_name` varchar(100) NOT NULL COMMENT '鍥捐〃鍚嶇О',
+  `chart_code` varchar(50) NOT NULL COMMENT '鍥捐〃缂栫爜',
+  `chart_type` varchar(20) NOT NULL COMMENT '鍥捐〃绫诲瀷(bar/line/pie/radar/spc/normal)',
+  `data_source` varchar(100) NOT NULL COMMENT '鏁版嵁婧怱QL鎴栨帴鍙ｆ爣璇�',
+  `x_axis_field` varchar(50) COMMENT 'X杞村瓧娈�',
+  `y_axis_field` varchar(100) COMMENT 'Y杞村瓧娈�(JSON鏁扮粍)',
+  `query_params` text COMMENT '鏌ヨ鍙傛暟閰嶇疆JSON',
+  `chart_options` text COMMENT 'ECharts閰嶇疆JSON',
+  `status` tinyint DEFAULT 1 COMMENT '鐘舵��(1鍚敤/0鍋滅敤)',
+  `create_by` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�',
+  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+  `update_by` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�',
+  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿',
+  `remark` varchar(500) DEFAULT '' COMMENT '澶囨敞',
+  PRIMARY KEY (`id`),
+  UNIQUE KEY `uk_chart_code` (`chart_code`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='鍥捐〃閰嶇疆琛�';
+
+-- =============================================
+-- 4. 鐪嬫澘閰嶇疆琛�
+-- =============================================
+DROP TABLE IF EXISTS `dashboard_config`;
+CREATE TABLE `dashboard_config` (
+  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '涓婚敭ID',
+  `dashboard_name` varchar(100) NOT NULL COMMENT '鐪嬫澘鍚嶇О',
+  `dashboard_code` varchar(50) NOT NULL COMMENT '鐪嬫澘缂栫爜',
+  `layout_config` text COMMENT '甯冨眬閰嶇疆JSON',
+  `components` text COMMENT '缁勪欢閰嶇疆JSON',
+  `voice_config` text COMMENT '璇煶鎾姤閰嶇疆JSON',
+  `refresh_interval` int DEFAULT 30 COMMENT '鍒锋柊闂撮殧(绉�)',
+  `status` tinyint DEFAULT 1 COMMENT '鐘舵��(1鍚敤/0鍋滅敤)',
+  `create_by` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�',
+  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+  `update_by` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�',
+  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿',
+  `remark` varchar(500) DEFAULT '' COMMENT '澶囨敞',
+  PRIMARY KEY (`id`),
+  UNIQUE KEY `uk_dashboard_code` (`dashboard_code`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='鐪嬫澘閰嶇疆琛�';
+
+-- =============================================
+-- 5. 鑿滃崟鏉冮檺閰嶇疆
+-- =============================================
+-- 鎶ヨ〃鍥捐〃绠＄悊锛堜竴绾х洰褰曪級- 鎺掑湪鏈�鍚庯紝order_num = 21
+INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `is_rersonal_button`) VALUES
+(3000, '鎶ヨ〃鍥捐〃绠＄悊', 0, 21, 'reportChart', '', NULL, '', 1, 0, 'M', '0', '0', '', 'chart', 'admin', NOW(), '', NULL, '鎶ヨ〃鍥捐〃绠＄悊鐩綍', 0),
+
+-- 鏁板瓧鍖栬闊崇湅鏉匡紙浜岀骇鐩綍锛�
+(3001, '鏁板瓧鍖栬闊崇湅鏉�', 3000, 1, 'dashboard', '', NULL, '', 1, 0, 'M', '0', '0', '', 'monitor', 'admin', NOW(), '', NULL, '鏁板瓧鍖栬闊崇湅鏉跨洰褰�', 0),
+
+-- 璇曢獙澶у巺
+(3002, '璇曢獙澶у巺', 3001, 1, 'testHall', 'report/dashboard/index', NULL, '', 1, 0, 'C', '0', '0', 'report:dashboard:list', 'monitor', 'admin', NOW(), '', NULL, '璇曢獙澶у巺鑿滃崟', 0),
+
+-- 鎶ヨ〃绠＄悊锛堜簩绾х洰褰曪級
+(3010, '鎶ヨ〃绠＄悊', 3000, 2, 'report', '', NULL, '', 1, 0, 'M', '0', '0', '', 'form', 'admin', NOW(), '', NULL, '鎶ヨ〃绠＄悊鐩綍', 0),
+
+-- 鏍峰搧杩涘害鎶ヨ〃
+(3011, '鏍峰搧杩涘害鎶ヨ〃', 3010, 1, 'sampleProgress', 'report/sampleProgress/index', NULL, '', 1, 0, 'C', '0', '0', 'report:sampleProgress:list', 'table', 'admin', NOW(), '', NULL, '鏍峰搧杩涘害鎶ヨ〃鑿滃崟', 0),
+
+-- 妫�娴嬮」鐩暟鎹�
+(3012, '妫�娴嬮」鐩暟鎹�', 3010, 2, 'testItemData', 'report/testItemData/index', NULL, '', 1, 0, 'C', '0', '0', 'report:testItemData:list', 'table', 'admin', NOW(), '', NULL, '妫�娴嬮」鐩暟鎹彍鍗�', 0),
+
+-- 鏍峰搧棰嗘牱璁板綍
+(3013, '鏍峰搧棰嗘牱璁板綍', 3010, 3, 'sampleRecord', 'report/sampleRecord/index', NULL, '', 1, 0, 'C', '0', '0', 'report:sampleRecord:list', 'table', 'admin', NOW(), '', NULL, '鏍峰搧棰嗘牱璁板綍鑿滃崟', 0),
+
+-- 璁惧浣跨敤璁板綍
+(3014, '璁惧浣跨敤璁板綍', 3010, 4, 'deviceRecord', 'report/deviceRecord/index', NULL, '', 1, 0, 'C', '0', '0', 'report:deviceRecord:list', 'table', 'admin', NOW(), '', NULL, '璁惧浣跨敤璁板綍鑿滃崟', 0),
+
+-- 鏅鸿兘鍥捐〃锛堜簩绾х洰褰曪級
+(3020, '鏅鸿兘鍥捐〃', 3000, 3, 'chart', '', NULL, '', 1, 0, 'M', '0', '0', '', 'chart', 'admin', NOW(), '', NULL, '鏅鸿兘鍥捐〃鐩綍', 0),
+
+-- 宸ヤ綔缁熻
+(3021, '宸ヤ綔缁熻', 3020, 1, 'workStatistics', 'report/workStatistics/index', NULL, '', 1, 0, 'C', '0', '0', 'chart:workStatistics:list', 'peoples', 'admin', NOW(), '', NULL, '宸ヤ綔缁熻鑿滃崟', 0),
+
+-- 鍚堟牸鐜囩粺璁�
+(3022, '鍚堟牸鐜囩粺璁�', 3020, 2, 'passRate', 'report/passRate/index', NULL, '', 1, 0, 'C', '0', '0', 'chart:passRate:list', 'chart', 'admin', NOW(), '', NULL, '鍚堟牸鐜囩粺璁¤彍鍗�', 0),
+
+-- SPC鎺у埗鍥�
+(3023, 'SPC鎺у埗鍥�', 3020, 3, 'spcChart', 'report/spcChart/index', NULL, '', 1, 0, 'C', '0', '0', 'chart:spcChart:list', 'chart', 'admin', NOW(), '', NULL, 'SPC鎺у埗鍥捐彍鍗�', 0),
+
+-- 姝ｆ�佸垎甯冨浘
+(3024, '姝ｆ�佸垎甯冨浘', 3020, 4, 'normalDistribution', 'report/normalDistribution/index', NULL, '', 1, 0, 'C', '0', '0', 'chart:normalDistribution:list', 'chart', 'admin', NOW(), '', NULL, '姝ｆ�佸垎甯冨浘鑿滃崟', 0);
+
+-- =============================================
+-- 6. 鍒濆鍖栫湅鏉块厤缃暟鎹�
+-- =============================================
+INSERT INTO `dashboard_config` (`dashboard_name`, `dashboard_code`, `layout_config`, `components`, `voice_config`, `refresh_interval`, `status`, `create_by`) VALUES
+('璇曢獙澶у巺鐪嬫澘', 'test_hall',
+'[{"i":"history","x":0,"y":0,"w":8,"h":4},{"i":"future","x":8,"y":0,"w":4,"h":4},{"i":"ranking","x":0,"y":4,"w":6,"h":3},{"i":"status","x":6,"y":4,"w":6,"h":3},{"i":"result","x":0,"y":7,"w":12,"h":3}]',
+'[{"id":"history","type":"calendar","title":"鍘嗗彶15澶╂娴嬩换鍔�","api":"/report/dashboard/history15Days"},{"id":"future","type":"calendar","title":"鏈潵15澶╂娴嬩换鍔�","api":"/report/dashboard/future15Days"},{"id":"ranking","type":"ranking","title":"鎻愪氦鎺掕","api":"/report/dashboard/ranking"},{"id":"status","type":"stat","title":"寰呭鐞嗙粺璁�","api":"/report/dashboard/overview"},{"id":"result","type":"chart","title":"妫�楠岀粨鏋滅粺璁�","api":"/report/dashboard/insResult"}]',
+'{"enabled":true,"events":["sample_receive","task_assign","report_submit","emergency"],"template":"绱ф�ラ�氱煡锛歿eventName}锛寋details}"}',
+30, 1, 'admin');
+
+-- =============================================
+-- 7. 鍒濆鍖栨姤琛ㄩ厤缃暟鎹�
+-- =============================================
+INSERT INTO `report_config` (`report_name`, `report_code`, `report_type`, `query_config`, `status`, `create_by`) VALUES
+('鏍峰搧杩涘害鎶ヨ〃', 'sample_progress', 'sample_progress', '[{"field":"entrustCode","label":"濮旀墭缂栧彿","type":"input"},{"field":"sampleCode","label":"鏍峰搧缂栧彿","type":"input"},{"field":"sampleName","label":"鏍峰搧鍚嶇О","type":"input"},{"field":"insState","label":"妫�娴嬬姸鎬�","type":"select","options":[{"value":0,"label":"寰呮"},{"value":1,"label":"妫�楠屼腑"},{"value":5,"label":"宸插畬鎴�"}]}]', 1, 'admin'),
+('妫�娴嬮」鐩暟鎹�', 'test_item_data', 'test_item', '[{"field":"productionOrder","label":"鐢熶骇璁㈠崟","type":"input"},{"field":"batchNo","label":"鎵规鍙�","type":"input"},{"field":"sampleCode","label":"鏍峰搧缂栧彿","type":"input"},{"field":"itemName","label":"妫�娴嬮」鐩�","type":"input"}]', 1, 'admin'),
+('鏍峰搧棰嗘牱璁板綍', 'sample_record', 'sample_record', '[{"field":"sampleCode","label":"鏍峰搧缂栧彿","type":"input"},{"field":"operateUser","label":"鎿嶄綔浜�","type":"input"},{"field":"startTime","label":"寮�濮嬫椂闂�","type":"date"},{"field":"endTime","label":"缁撴潫鏃堕棿","type":"date"}]', 1, 'admin'),
+('璁惧浣跨敤璁板綍', 'device_record', 'device_record', '[{"field":"deviceCode","label":"璁惧缂栧彿","type":"input"},{"field":"deviceName","label":"璁惧鍚嶇О","type":"input"},{"field":"useUser","label":"浣跨敤浜�","type":"input"}]', 1, 'admin');
+
+-- =============================================
+-- 8. 鍒濆鍖栧浘琛ㄩ厤缃暟鎹�
+-- =============================================
+INSERT INTO `chart_config` (`chart_name`, `chart_code`, `chart_type`, `data_source`, `x_axis_field`, `y_axis_field`, `status`, `create_by`) VALUES
+('宸ヤ綔缁熻鍥�', 'work_statistics', 'bar', '/chart/workStatistics/byUser', 'userName', '[{"field":"sampleCount","name":"鏍峰搧鏁伴噺"},{"field":"itemCount","name":"椤圭洰鏁伴噺"}]', 1, 'admin'),
+('鍙婃椂鐜囩粺璁�', 'timely_rate', 'line', '/chart/workStatistics/timelyRate', 'userName', '[{"field":"timelyRate","name":"鍙婃椂鐜�(%)"}]', 1, 'admin'),
+('鍘熸潗鏂欏悎鏍肩巼', 'raw_material_pass_rate', 'bar', '/chart/passRate/rawMaterial', 'sampleName', '[{"field":"passRate","name":"鍚堟牸鐜�(%)"}]', 1, 'admin'),
+('甯曠疮鎵樺浘', 'pareto', 'bar', '/chart/passRate/pareto', 'itemName', '[{"field":"unqualifiedCount","name":"涓嶅悎鏍兼暟"},{"field":"cumulativePercent","name":"绱鐧惧垎姣�"}]', 1, 'admin'),
+('宸ュ簭鍚堟牸鐜�', 'process_pass_rate', 'pie', '/chart/passRate/process', 'processName', '[{"field":"passRate","name":"鍚堟牸鐜�(%)"}]', 1, 'admin'),
+('SPC鎺у埗鍥�', 'spc_chart', 'line', '/chart/spc/analyze', 'subgroup', '[{"field":"xBar","name":"X-Bar"},{"field":"ucl","name":"UCL"},{"field":"lcl","name":"LCL"}]', 1, 'admin'),
+('姝ｆ�佸垎甯冨浘', 'normal_distribution', 'line', '/chart/normalDistribution/analyze', 'value', '[{"field":"frequency","name":"棰戠巼"},{"field":"normalCurve","name":"姝ｆ�佹洸绾�"}]', 1, 'admin');
+
+-- =============================================
+-- 9. 鍒濆鍖栬闊虫挱鎶ユ祴璇曟暟鎹�
+-- =============================================
+INSERT INTO `voice_queue` (`event_type`, `event_name`, `details`, `voice_text`, `priority`, `status`) VALUES
+('sample_receive', '鏍峰搧鎺ユ敹', '鏍峰搧A001宸插埌杈惧疄楠屽', '鏍峰搧A001宸插埌杈惧疄楠屽锛岃鍙婃椂棰嗗彇', 0, 0),
+('task_assign', '浠诲姟鍒嗛厤', '妫�娴嬩换鍔″凡鍒嗛厤缁欏紶涓�', '妫�娴嬩换鍔″凡鍒嗛厤缁欏紶涓夛紝璇峰敖蹇紑濮嬫娴�', 1, 0),
+('emergency', '绱ф�ラ�氱煡', '璁惧鏁呴殰闇�瑕佺淮淇�', '绱ф�ラ�氱煡锛氬叧閿娴嬭澶囧嚭鐜版晠闅滐紝璇风珛鍗宠仈绯荤淮淇汉鍛�', 2, 0);
+
+-- =====================================================
+-- 鎵ц瀹屾垚
+-- =====================================================
\ No newline at end of file

--
Gitblit v1.9.3