From 11214e3074266a23fe61e8eebbce647fdb7305ef Mon Sep 17 00:00:00 2001 From: 云 <2163098428@qq.com> Date: 星期五, 12 六月 2026 18:02:03 +0800 Subject: [PATCH] 报价单修改-优化，增加导入记录，降价历史 --- docs/sales_quotation_price_history.sql | 56 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 56 insertions(+), 0 deletions(-) diff --git a/docs/sales_quotation_price_history.sql b/docs/sales_quotation_price_history.sql new file mode 100644 index 0000000..e69de81 --- /dev/null +++ b/docs/sales_quotation_price_history.sql @@ -0,0 +1,56 @@ +-- ============================================================ +-- 閿�鍞姤浠烽檷浠疯褰曡〃 +-- 閫傜敤鍦烘櫙锛氳褰曟姤浠峰崟椤圭洰鐨勫巻鍙蹭环鏍煎彉鍖� +-- 鐢熸垚鏃ユ湡锛�2026-06-12 +-- ============================================================ + +-- 閿�鍞姤浠烽檷浠疯褰曡〃 +CREATE TABLE `sales_quotation_price_history` ( + `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '涓婚敭ID', + `quotation_id` BIGINT NOT NULL COMMENT '鎶ヤ环鍗旾D', + `quotation_product_id` BIGINT NOT NULL COMMENT '鎶ヤ环鍟嗗搧ID', + `product_name` VARCHAR(200) DEFAULT NULL COMMENT '鍟嗗搧鍚嶇О锛堝啑浣欏瓨鍌級', + `specification` VARCHAR(200) DEFAULT NULL COMMENT '鍟嗗搧瑙勬牸锛堝啑浣欏瓨鍌級', + `old_price` DECIMAL(24, 4) DEFAULT NULL COMMENT '鍘熷崟浠�', + `new_price` DECIMAL(24, 4) DEFAULT NULL COMMENT '鏂板崟浠�', + `price_change` DECIMAL(24, 4) DEFAULT NULL COMMENT '浠锋牸鍙樺姩锛堟柊-鏃э紝璐熸暟琛ㄧず闄嶄环锛�', + `change_reason` VARCHAR(500) DEFAULT NULL COMMENT '鍙樺姩鍘熷洜', + `import_batch` VARCHAR(50) DEFAULT NULL COMMENT '瀵煎叆鎵规鍙�', + `import_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '瀵煎叆鏃堕棿', + `create_user` BIGINT DEFAULT NULL COMMENT '鎿嶄綔浜篒D', + `create_user_name` VARCHAR(100) DEFAULT NULL COMMENT '鎿嶄綔浜哄鍚�', + `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + `tenant_id` BIGINT DEFAULT NULL COMMENT '绉熸埛ID', + `dept_id` BIGINT DEFAULT NULL COMMENT '閮ㄩ棬ID', + PRIMARY KEY (`id`), + KEY `idx_quotation_id` (`quotation_id`), + KEY `idx_quotation_product_id` (`quotation_product_id`), + KEY `idx_import_batch` (`import_batch`), + KEY `idx_import_time` (`import_time`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='閿�鍞姤浠烽檷浠疯褰曡〃'; + +-- 閿�鍞姤浠峰鍏ヨ褰曡〃 +CREATE TABLE `sales_quotation_import_log` ( + `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '涓婚敭ID', + `batch_no` VARCHAR(50) NOT NULL COMMENT '瀵煎叆鎵规鍙�', + `file_name` VARCHAR(200) DEFAULT NULL COMMENT '瀵煎叆鏂囦欢鍚�', + `total_count` INT DEFAULT 0 COMMENT '鎬昏褰曟暟', + `success_count` INT DEFAULT 0 COMMENT '鎴愬姛璁板綍鏁�', + `update_count` INT DEFAULT 0 COMMENT '鏇存柊璁板綍鏁�', + `new_count` INT DEFAULT 0 COMMENT '鏂板璁板綍鏁�', + `fail_count` INT DEFAULT 0 COMMENT '澶辫触璁板綍鏁�', + `status` VARCHAR(20) DEFAULT 'pending' COMMENT '鐘舵�侊細pending-寰呭鏍�, approved-宸查�氳繃, rejected-宸叉嫆缁�', + `remark` VARCHAR(500) DEFAULT NULL COMMENT '澶囨敞', + `create_user` BIGINT DEFAULT NULL COMMENT '鎿嶄綔浜篒D', + `create_user_name` VARCHAR(100) DEFAULT NULL COMMENT '鎿嶄綔浜哄鍚�', + `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '瀵煎叆鏃堕棿', + `audit_user` BIGINT DEFAULT NULL COMMENT '瀹℃牳浜篒D', + `audit_user_name` VARCHAR(100) DEFAULT NULL COMMENT '瀹℃牳浜哄鍚�', + `audit_time` DATETIME DEFAULT NULL COMMENT '瀹℃牳鏃堕棿', + `tenant_id` BIGINT DEFAULT NULL COMMENT '绉熸埛ID', + `dept_id` BIGINT DEFAULT NULL COMMENT '閮ㄩ棬ID', + PRIMARY KEY (`id`), + UNIQUE KEY `uk_batch_no` (`batch_no`), + KEY `idx_status` (`status`), + KEY `idx_create_time` (`create_time`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='閿�鍞姤浠峰鍏ヨ褰曡〃'; -- Gitblit v1.9.3