From 263b034b4058bb7a36c709278abdc88ca1ba26c1 Mon Sep 17 00:00:00 2001
From: gongchunyi <deslre0381@gmail.com>
Date: 星期一, 30 三月 2026 18:01:25 +0800
Subject: [PATCH] feat: 生产成本导入数据入库
---
doc/宁夏-中盛建材.sql | 44 +++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 43 insertions(+), 1 deletions(-)
diff --git "a/doc/\345\256\201\345\244\217-\344\270\255\347\233\233\345\273\272\346\235\220.sql" "b/doc/\345\256\201\345\244\217-\344\270\255\347\233\233\345\273\272\346\235\220.sql"
index 9f95867..3593ec5 100644
--- "a/doc/\345\256\201\345\244\217-\344\270\255\347\233\233\345\273\272\346\235\220.sql"
+++ "b/doc/\345\256\201\345\244\217-\344\270\255\347\233\233\345\273\272\346\235\220.sql"
@@ -468,4 +468,46 @@
KEY `idx_order_id` (`order_id`) USING BTREE
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4
- COLLATE = utf8mb4_0900_ai_ci COMMENT ='鐢熶骇璁㈠崟缁戝畾鐨勫伐鑹鸿矾绾胯〃';
\ No newline at end of file
+ COLLATE = utf8mb4_0900_ai_ci COMMENT ='鐢熶骇璁㈠崟缁戝畾鐨勫伐鑹鸿矾绾胯〃';
+
+CREATE TABLE `production_settlement_batches`
+(
+ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '涓婚敭ID',
+ `period_time` date DEFAULT NULL COMMENT '鏍哥畻褰掑睘鏈堜唤',
+ `batch_name` varchar(255) DEFAULT NULL COMMENT '鎵规鍚嶇О',
+ `status` int DEFAULT '0' COMMENT '鐘舵�侊細0-浠呴绠楋紝1-缁撶畻璁＄畻涓紝2-宸插畬鎴愮粨绠楋紝3-宸查攣瀹�',
+ `create_user` varchar(255) DEFAULT NULL COMMENT '瀵煎叆鐢ㄦ埛',
+ `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃ユ湡',
+ `tenant_id` bigint DEFAULT NULL COMMENT '绉熸埛ID',
+ PRIMARY KEY (`id`),
+ KEY `idx_period` (`period_time`)
+) ENGINE = InnoDB
+ DEFAULT CHARSET = utf8mb4 COMMENT ='鐢熶骇鎴愭湰鏍哥畻鎵规涓昏〃';
+
+CREATE TABLE `production_settlement_details`
+(
+ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '涓婚敭ID',
+ `batch_id` bigint NOT NULL COMMENT '鍏宠仈鏍哥畻鎵规琛↖D',
+ `product_id` bigint DEFAULT NULL COMMENT '浜у搧ID',
+ `product_type` varchar(100) DEFAULT NULL COMMENT '浜у搧绫诲瀷鍚嶇О',
+ `category` varchar(100) DEFAULT NULL COMMENT '璐圭敤绫诲埆',
+ `subject_name` varchar(100) DEFAULT NULL COMMENT '绉戠洰鍚嶇О',
+
+ `budget_qty` decimal(20, 15) DEFAULT '0.000000000000000' COMMENT '棰勭畻鑰楅噺',
+ `budget_price` decimal(20, 15) DEFAULT '0.000000000000000' COMMENT '棰勭畻鍗曚环',
+ `budget_total` decimal(20, 15) DEFAULT '0.000000000000000' COMMENT '棰勭畻鎬绘垚鏈�',
+
+ `actual_qty` decimal(20, 15) DEFAULT '0.000000000000000' COMMENT '瀹為檯鑰楅噺',
+ `actual_price` decimal(20, 15) DEFAULT '0.000000000000000' COMMENT '瀹為檯鍗曚环',
+ `actual_total` decimal(20, 15) DEFAULT '0.000000000000000' COMMENT '瀹為檯鎬绘垚鏈�',
+
+ `diff_qty` decimal(20, 15) DEFAULT '0.000000000000000' COMMENT '鑰楅噺宸紓',
+ `diff_price` decimal(20, 15) DEFAULT '0.000000000000000' COMMENT '鍗曚环宸紓',
+ `diff_total` DECIMAL(20, 15) DEFAULT '0.000000000000000' COMMENT '鎬绘垚鏈樊寮�',
+
+ `tenant_id` bigint DEFAULT NULL COMMENT '绉熸埛ID',
+ PRIMARY KEY (`id`),
+ KEY `idx_batch_id` (`batch_id`),
+ KEY `idx_product_id` (`product_id`) COMMENT '鏂逛究鎸変骇鍝佹煡璇㈠巻鍙叉垚鏈姣�'
+) ENGINE = InnoDB
+ DEFAULT CHARSET = utf8mb4 COMMENT ='鐢熶骇鎴愭湰鏍哥畻瀵规瘮鏄庣粏琛�';
\ No newline at end of file
--
Gitblit v1.9.3