From cdaec80a5ffa474f69e5c36f0312be3c0abf2210 Mon Sep 17 00:00:00 2001
From: gaoluyang <2820782392@qq.com>
Date: 星期四, 05 十一月 2026 18:31:11 +0800
Subject: [PATCH] feat(crm): 投标保证金迁移到销售管理并关联销售台账
---
docs/sql/config_export_all_20261104.sql | 62 +++++++++++++++++++++++++++++++
1 files changed, 62 insertions(+), 0 deletions(-)
diff --git a/docs/sql/config_export_all_20261104.sql b/docs/sql/config_export_all_20261104.sql
index 8aab023..8121ea0 100644
--- a/docs/sql/config_export_all_20261104.sql
+++ b/docs/sql/config_export_all_20261104.sql
@@ -10421,3 +10421,65 @@
(1065505, 5, '璐ㄤ繚閲�', '5', 'crm_payment_stage', 0, 'danger', '', '', '1', NOW(), '1', NOW(), b'0')
ON DUPLICATE KEY UPDATE `sort` = VALUES(`sort`), `label` = VALUES(`label`), `value` = VALUES(`value`),
`status` = VALUES(`status`), `color_type` = VALUES(`color_type`), `deleted` = b'0';
+
+-- ==================== 2026-11-05 鎶曟爣淇濊瘉閲戣縼绉诲埌 CRM 閿�鍞鐞� ====================
+-- =====================================================
+-- 鎶曟爣淇濊瘉閲戜粠銆屼緵搴斿晢绠＄悊锛圫RM锛夈�嶈縼绉诲埌銆岄攢鍞鐞嗭紙CRM锛夈��
+-- 1. 鏂板缓 crm_bid_bond 琛細鎸夊鎴凤紙鎷涙爣鏂癸級鐧昏锛岃褰曚腑鏍囩粨鏋滀笌閫�娆捐繘搴︼紝鍙叧鑱旈攢鍞鍗曪紙閿�鍞彴璐︼級
+-- 2. 鑿滃崟 602630 鍙婃寜閽� 602631~602634 杩佺Щ鍒伴攢鍞鐞嗘牴鑿滃崟 2617锛�
+-- 鏉冮檺涓茬敱 srm:bid-bond:* 鏀逛负 crm:bid-bond:*锛涙部鐢ㄥ師鑿滃崟 id锛岃鑹叉巿鏉冧笉涓㈠け
+-- 3. 骞傜瓑锛氬彲閲嶅鎵ц
+-- =====================================================
+
+CREATE TABLE IF NOT EXISTS `crm_bid_bond` (
+ `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '鎶曟爣淇濊瘉閲慖D',
+ `no` VARCHAR(32) NOT NULL COMMENT '淇濊瘉閲戝崟鍙�',
+ `customer_id` BIGINT NOT NULL COMMENT '瀹㈡埛ID锛堟嫑鏍囨柟锛�',
+ `project_name` VARCHAR(255) DEFAULT NULL COMMENT '椤圭洰鍚嶇О',
+ `tender_no` VARCHAR(64) DEFAULT NULL COMMENT '鎷涙爣缂栧彿',
+ `sale_order_id` BIGINT DEFAULT NULL COMMENT '鍏宠仈閿�鍞鍗旾D锛堥攢鍞彴璐︼級',
+ `sale_order_no` VARCHAR(64) DEFAULT NULL COMMENT '鍏宠仈閿�鍞鍗曞彿蹇収',
+ `bond_amount` DECIMAL(24,6) NOT NULL DEFAULT 0 COMMENT '淇濊瘉閲戦噾棰�',
+ `pay_date` DATE DEFAULT NULL COMMENT '缂寸撼鏃ユ湡',
+ `bid_result` TINYINT NOT NULL DEFAULT 0 COMMENT '涓爣缁撴灉锛�0寰呭紑鏍� 1宸蹭腑鏍� 2鏈腑鏍�',
+ `refund_status` TINYINT NOT NULL DEFAULT 0 COMMENT '閫�鍥炵姸鎬侊細0鏈��鍥� 1閮ㄥ垎閫�鍥� 2宸查��鍥� 3鏃犻渶閫�鍥�',
+ `refund_amount` DECIMAL(24,6) DEFAULT NULL COMMENT '閫�鍥為噾棰�',
+ `refund_date` DATE DEFAULT NULL COMMENT '閫�鍥炴棩鏈�',
+ `remark` VARCHAR(500) DEFAULT NULL 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 ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿',
+ `deleted` BIT(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `uk_no` (`no`),
+ KEY `idx_customer_id` (`customer_id`),
+ KEY `idx_sale_order_id` (`sale_order_id`),
+ KEY `idx_bid_result` (`bid_result`),
+ KEY `idx_refund_status` (`refund_status`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='CRM鎶曟爣淇濊瘉閲戝彴璐�';
+
+-- 鑿滃崟锛氫粠閲囪喘绠＄悊 2602 绉诲埌閿�鍞鐞� 2617
+INSERT INTO `system_menu` (`id`, `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`,
+ `component`, `component_name`, `status`, `visible`, `keep_alive`, `always_show`,
+ `creator`, `create_time`, `updater`, `update_time`, `deleted`)
+VALUES (602630, '鎶曟爣淇濊瘉閲�', '', 2, 62, 2617, 'bid-bond', 'ep:money',
+ 'crm/bidBond/index', 'CrmBidBond', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0')
+ON DUPLICATE KEY UPDATE `name` = VALUES(`name`), `parent_id` = VALUES(`parent_id`), `path` = VALUES(`path`),
+ `icon` = VALUES(`icon`), `component` = VALUES(`component`),
+ `component_name` = VALUES(`component_name`), `sort` = VALUES(`sort`),
+ `status` = VALUES(`status`), `visible` = VALUES(`visible`), `deleted` = b'0';
+
+INSERT INTO `system_menu` (`id`, `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`,
+ `component`, `component_name`, `status`, `visible`, `keep_alive`, `always_show`,
+ `creator`, `create_time`, `updater`, `update_time`, `deleted`)
+VALUES
+(602631, '鎶曟爣淇濊瘉閲戞煡璇�', 'crm:bid-bond:query', 3, 1, 602630, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'),
+(602632, '鎶曟爣淇濊瘉閲戝垱寤�', 'crm:bid-bond:create', 3, 2, 602630, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'),
+(602633, '鎶曟爣淇濊瘉閲戞洿鏂�', 'crm:bid-bond:update', 3, 3, 602630, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'),
+(602634, '鎶曟爣淇濊瘉閲戝垹闄�', 'crm:bid-bond:delete', 3, 4, 602630, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0')
+ON DUPLICATE KEY UPDATE `name` = VALUES(`name`), `permission` = VALUES(`permission`),
+ `parent_id` = VALUES(`parent_id`), `sort` = VALUES(`sort`),
+ `status` = VALUES(`status`), `deleted` = b'0';
+
+-- 鑿滃崟 id 淇濇寔涓嶅彉锛屽巻鍙� system_role_menu 鎺堟潈缁х画鏈夋晥锛涙柊搴撶敱瓒呯鍦ㄣ�岃鑹茬鐞嗐�嶄腑鎺堟潈
--
Gitblit v1.9.3