From 5d34bdd3c426bb2ca5f6627424ae67984f745603 Mon Sep 17 00:00:00 2001 From: liu <2021943741@qq.com> Date: 星期三, 21 十月 2026 18:28:59 +0800 Subject: [PATCH] feat: 新增资产/用车/采购模块，完善课题、会员、财务与企微功能 --- docs/sql/wxcp_module.sql | 67 ++++++++++++++++++++++++++++++++- 1 files changed, 65 insertions(+), 2 deletions(-) diff --git a/docs/sql/wxcp_module.sql b/docs/sql/wxcp_module.sql index 8f2a542..b27c5da 100644 --- a/docs/sql/wxcp_module.sql +++ b/docs/sql/wxcp_module.sql @@ -3,9 +3,11 @@ -- 鐩爣搴擄細mom-jssm锛�36.213.150.237:10000锛� -- 璇存槑锛氶」鐩笉浣跨敤澶氱鎴凤紝鍥犳涓嶅惈 tenant_id 瀛楁 -- --- 娲诲姩灏侀潰銆佹姤鍚嶆彁浜ょ殑鍥剧墖/闄勪欢閮戒笉钀芥湰妯″潡鐨勮〃锛� +-- 娲诲姩灏侀潰銆佽鎯呭浘鐗囥�佹姤鍚嶆彁浜ょ殑鍥剧墖/闄勪欢閮戒笉钀芥湰妯″潡鐨勮〃锛� -- 缁熶竴璧� system_storage_attachment 涓棿琛紝 --- 娲诲姩灏侀潰 record_type = 'wxcp_activity'锛屾姤鍚嶉檮浠� record_type = 'wxcp_activity_signup' +-- 娲诲姩灏侀潰 record_type = 'wxcp_activity'锛屾椿鍔ㄨ鎯呭浘鐗� record_type = 'wxcp_activity_detail'锛� +-- 鍥剧墖閫氱煡 record_type = 'wxcp_activity_image'锛岄檮浠堕�氱煡 record_type = 'wxcp_activity_file'锛� +-- 鎶ュ悕闄勪欢 record_type = 'wxcp_activity_signup' -- ============================================================ -- ---------------------------- @@ -14,7 +16,12 @@ CREATE TABLE IF NOT EXISTS `wxcp_activity` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', `title` varchar(128) NOT NULL COMMENT '娲诲姩鏍囬', + `activity_type` tinyint NOT NULL DEFAULT 5 COMMENT '娲诲姩妯℃澘锛�1绾�氱煡 2鍗曟潯娑堟伅 3鍥剧墖閫氱煡 4闄勪欢閫氱煡 5鏁版嵁閲囬泦/璇勪环', `content` text COMMENT '娲诲姩璇︽儏', + `button_text` varchar(32) DEFAULT NULL COMMENT '鍗＄墖鎸夐挳鏂囨', + `rating_enabled` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁寮�鍚瘎浠�', + `rating_title` varchar(128) DEFAULT NULL COMMENT '璇勪环鏍囬', + `rating_max` int NOT NULL DEFAULT 5 COMMENT '璇勪环鏈�楂樻槦绾�', `location` varchar(255) DEFAULT '' COMMENT '娲诲姩鍦扮偣', `start_time` datetime DEFAULT NULL COMMENT '娲诲姩寮�濮嬫椂闂�', `end_time` datetime DEFAULT NULL COMMENT '娲诲姩缁撴潫鏃堕棿', @@ -51,6 +58,7 @@ `mobile` varchar(32) DEFAULT '' COMMENT '鎵嬫満鍙�', `dept_name` varchar(255) DEFAULT '' COMMENT '閮ㄩ棬鍚嶇О', `content` text COMMENT '鍙備笌璇存槑锛堟垚鍛樻彁浜ょ殑鏂囧瓧鍐呭锛�', + `rating_score` int DEFAULT NULL COMMENT '璇勪环鏄熺骇', `status` tinyint NOT NULL DEFAULT 0 COMMENT '鐘舵�侊細0宸叉姤鍚� 1宸插彇娑� 2宸茬鍒�', `signup_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鎶ュ悕鏃堕棿', `check_in_time` datetime DEFAULT NULL COMMENT '绛惧埌鏃堕棿', @@ -72,6 +80,13 @@ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', `title` varchar(128) NOT NULL COMMENT '閫氱煡鏍囬', `content` text COMMENT '閫氱煡姝ｆ枃', + `notice_type` tinyint NOT NULL DEFAULT 1 COMMENT '閫氱煡妯℃澘锛�1绾枃鏈� 2鍥炬枃鍗＄墖(濉姤/閾炬帴) 3鏂囦欢閫氱煡 4鍥炬枃娑堟伅', + `summary` varchar(512) DEFAULT NULL COMMENT '鎽樿锛堝浘鏂囧崱鐗�/鍥炬枃娑堟伅锛�', + `link_url` varchar(1024) DEFAULT NULL COMMENT '璺宠浆閾炬帴锛堝～鎶�/璇︽儏锛�', + `link_btn_text` varchar(32) DEFAULT NULL COMMENT '閾炬帴鎸夐挳鏂囨', + `cover_url` varchar(1024) DEFAULT NULL COMMENT '鍥炬枃娑堟伅灏侀潰鍥惧湴鍧�', + `file_blob_id` bigint DEFAULT NULL COMMENT '鏂囦欢閫氱煡鐨勯檮浠� Blob ID', + `file_name` varchar(255) DEFAULT NULL COMMENT '鏂囦欢閫氱煡鐨勯檮浠舵枃浠跺悕', `status` tinyint NOT NULL DEFAULT 0 COMMENT '鐘舵�侊細0鑽夌 1宸插彂甯� 2宸叉挙鍥�', `push_scope` tinyint NOT NULL DEFAULT 0 COMMENT '鎺ㄩ�佽寖鍥达細0鍏ㄥ憳 1鎸囧畾閮ㄩ棬 2鎸囧畾鎴愬憳', `push_target` varchar(1024) DEFAULT '' COMMENT '鎺ㄩ�佺洰鏍囷細閮ㄩ棬ID鎴栨垚鍛樿处鍙凤紝澶氫釜鐢ㄩ�楀彿鍒嗛殧', @@ -100,3 +115,51 @@ PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; + +-- ============================================================ +-- 娲诲姩鑷畾涔夐噰闆嗗瓧娈碉紙鏁版嵁閲囬泦/璇勪环妯℃澘浣跨敤锛� +-- ============================================================ +CREATE TABLE IF NOT EXISTS `wxcp_activity_field` ( + `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', + `activity_id` bigint NOT NULL COMMENT '娲诲姩缂栧彿', + `field_label` varchar(128) NOT NULL COMMENT '瀛楁鍚嶇О', + `field_type` varchar(32) NOT NULL DEFAULT 'text' COMMENT '瀛楁绫诲瀷锛歵ext/textarea/number/date/select/radio/checkbox/rating', + `field_options` varchar(1000) DEFAULT NULL COMMENT '閫夐」锛屽涓敤鑻辨枃閫楀彿鍒嗛殧', + `required` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁蹇呭～', + `placeholder` varchar(255) DEFAULT NULL COMMENT '杈撳叆鎻愮ず', + `sort_no` int NOT NULL DEFAULT 0 COMMENT '鎺掑簭鍙�', + `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', + `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', + PRIMARY KEY (`id`), + KEY `idx_activity_id` (`activity_id`) +) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COMMENT = '浼佷笟寰俊娲诲姩閲囬泦瀛楁'; + +-- ============================================================ +-- 鎶ュ悕閲囬泦鍊� +-- ============================================================ +CREATE TABLE IF NOT EXISTS `wxcp_activity_signup_value` ( + `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', + `signup_id` bigint NOT NULL COMMENT '鎶ュ悕璁板綍缂栧彿', + `activity_id` bigint NOT NULL COMMENT '娲诲姩缂栧彿', + `field_id` bigint NOT NULL COMMENT '瀛楁缂栧彿', + `field_label` varchar(128) NOT NULL COMMENT '瀛楁鍚嶇О锛堝揩鐓э級', + `field_type` varchar(32) DEFAULT NULL COMMENT '瀛楁绫诲瀷锛堝揩鐓э級', + `field_value` varchar(2000) DEFAULT NULL COMMENT '瀛楁鍊硷紝澶氶�夌敤鑻辨枃閫楀彿鍒嗛殧', + `sort_no` int NOT NULL DEFAULT 0 COMMENT '鎺掑簭鍙�', + `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', + `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', + PRIMARY KEY (`id`), + KEY `idx_signup_id` (`signup_id`), + KEY `idx_activity_id` (`activity_id`) +) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COMMENT = '浼佷笟寰俊娲诲姩鎶ュ悕閲囬泦鍊�'; + +-- ============================================================ +-- 鍗囩骇鑴氭湰锛氭椿鍔ㄥ妯℃澘瀛楁锛堝凡寤哄簱鐜鎵ц锛屾柊搴撴棤闇�鎵ц锛� +-- 鍏蜂綋瑙� docs/sql/wxcp_activity_templates_20261021.sql +-- ============================================================ -- Gitblit v1.9.3