From 65bf12d8c871308e36fff97d985f49ad6bce6adc Mon Sep 17 00:00:00 2001
From: gongchunyi <deslre0381@gmail.com>
Date: 星期二, 07 四月 2026 16:01:09 +0800
Subject: [PATCH] feat: 支持个人对私录入销售订单；支持个人采购；供应商、客户档案、销售采购导入导出修改
---
doc/长治-烜曌工贸.sql | 27 ++++++++++++++++++++++++++-
1 files changed, 26 insertions(+), 1 deletions(-)
diff --git "a/doc/\351\225\277\346\262\273-\347\203\234\346\233\214\345\267\245\350\264\270.sql" "b/doc/\351\225\277\346\262\273-\347\203\234\346\233\214\345\267\245\350\264\270.sql"
index a676ef0..ebf5818 100644
--- "a/doc/\351\225\277\346\262\273-\347\203\234\346\233\214\345\267\245\350\264\270.sql"
+++ "b/doc/\351\225\277\346\262\273-\347\203\234\346\233\214\345\267\245\350\264\270.sql"
@@ -12,4 +12,29 @@
MODIFY COLUMN `supplier_type` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '渚涘簲鍟嗙被鍨嬶紙瀵瑰叕/瀵圭锛�' AFTER `company_address`;
ALTER TABLE `product-inventory-management-xzgm`.`sales_ledger`
- ADD COLUMN `sales_type` varchar(255) NULL COMMENT '鍙拌处绫诲瀷锛堝鍏�/瀵圭锛�' AFTER `delivery_date`;
\ No newline at end of file
+ ADD COLUMN `sales_type` varchar(255) NULL COMMENT '鍙拌处绫诲瀷锛堝鍏�/瀵圭锛�' AFTER `delivery_date`;
+
+ALTER TABLE `sales_ledger_product`
+ ADD COLUMN `unit_price` decimal(18, 2) DEFAULT NULL COMMENT '瀵圭-鍗曚环',
+ ADD COLUMN `freight` decimal(18, 2) DEFAULT 0.00 COMMENT '瀵圭-杩愯垂',
+ ADD COLUMN `price_with_freight` decimal(18, 2) DEFAULT NULL COMMENT '瀵圭-鍚繍璐瑰崟浠�(鍗曚环+杩愯垂)',
+ ADD COLUMN `total_price` decimal(18, 2) DEFAULT NULL COMMENT '瀵圭-鎬讳环(鍚繍璐瑰崟浠�*鏁伴噺)';
+
+ALTER TABLE `product-inventory-management-xzgm`.`customer`
+ MODIFY COLUMN `customer_type` int NOT NULL COMMENT '瀹㈡埛鍒嗙被锛�1-瀵瑰叕锛�2-瀵圭' AFTER `bank_code`;
+
+ALTER TABLE `product-inventory-management-xzgm`.`sales_ledger`
+ MODIFY COLUMN `sales_type` int NULL DEFAULT NULL COMMENT '鍙拌处绫诲瀷锛�1-瀵瑰叕,2-瀵圭锛�' AFTER `delivery_date`;
+
+ALTER TABLE `product-inventory-management-xzgm`.`supplier_manage`
+ MODIFY COLUMN `supplier_type` int NULL DEFAULT NULL COMMENT '渚涘簲鍟嗙被鍨嬶紙1-瀵瑰叕/2-瀵圭锛�' AFTER `company_address`;
+
+ALTER TABLE `product-inventory-management-xzgm`.`purchase_ledger_template`
+ MODIFY COLUMN `template_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '妯℃澘鍚嶇О' AFTER `execution_date`,
+ ADD COLUMN `template_type` int NULL COMMENT '妯℃澘绫诲瀷(1-瀵瑰叕/2-瀵圭)' AFTER `template_name`;
+
+ALTER TABLE `sales_ledger_product_template`
+ ADD COLUMN `unit_price` decimal(18, 2) DEFAULT NULL COMMENT '鍗曚环锛堝绉佷笓鐢級',
+ ADD COLUMN `total_price` decimal(18, 2) DEFAULT NULL COMMENT '鎬讳环锛堝绉佷笓鐢級',
+ ADD COLUMN `freight` decimal(18, 2) DEFAULT 0.00 COMMENT '杩愯垂',
+ ADD COLUMN `price_with_freight` decimal(18, 2) DEFAULT NULL COMMENT '鍚繍璐瑰崟浠�';
\ No newline at end of file
--
Gitblit v1.9.3