From b5ca4fa6acd8c7ea8ed1400b133eb2eb6b5cb8ba Mon Sep 17 00:00:00 2001 From: gaoluyang <2820782392@qq.com> Date: 星期三, 14 十月 2026 15:22:16 +0800 Subject: [PATCH] feat(hrm): 社保公积金方案支持按部门绑定，修比例输入精度 --- docs/sql/config_export_all_20260928.sql | 22 ++++++++++++++++++++-- 1 files changed, 20 insertions(+), 2 deletions(-) diff --git a/docs/sql/config_export_all_20260928.sql b/docs/sql/config_export_all_20260928.sql index 30be983..92c7e74 100644 --- a/docs/sql/config_export_all_20260928.sql +++ b/docs/sql/config_export_all_20260928.sql @@ -2508,8 +2508,8 @@ CREATE TABLE `crm_invoice` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'ID', `no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '寮�绁ㄧ紪鍙�', - `customer_id` bigint NOT NULL COMMENT '瀹㈡埛缂栧彿', - `contract_id` bigint NOT NULL COMMENT '鍚堝悓缂栧彿', + `customer_id` bigint DEFAULT NULL COMMENT '瀹㈡埛缂栧彿', + `contract_id` bigint DEFAULT NULL COMMENT '鍚堝悓缂栧彿', `owner_user_id` bigint NOT NULL COMMENT '璐熻矗浜虹紪鍙�', `invoice_type` int NOT NULL COMMENT '鍙戠エ绫诲瀷锛堝瓧鍏� crm_invoice_type锛�', `invoice_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '鍙戠エ鍙风爜', @@ -3674,6 +3674,8 @@ `maternity_ratio` decimal(5,4) NOT NULL DEFAULT '0.0050' COMMENT '鐢熻偛淇濋櫓浼佷笟缂寸撼姣斾緥', `housing_fund_company_ratio` decimal(5,4) NOT NULL DEFAULT '0.1200' COMMENT '鍏Н閲戜紒涓氱即绾虫瘮渚�', `housing_fund_personal_ratio` decimal(5,4) NOT NULL DEFAULT '0.1200' COMMENT '鍏Н閲戜釜浜虹即绾虫瘮渚�', + `default_social_security_base` decimal(12,2) DEFAULT NULL COMMENT '榛樿绀句繚缂磋垂鍩烘暟锛堢┖鍒欑敤鍛樺伐鍩烘湰宸ヨ祫锛�', + `default_housing_fund_base` decimal(12,2) DEFAULT NULL COMMENT '榛樿鍏Н閲戠即璐瑰熀鏁帮紙绌烘垨 0 鍒欑敤绀句繚缂磋垂鍩烘暟锛�', `status` tinyint NOT NULL DEFAULT '0' COMMENT '鐘舵�侊細0-鍚敤锛�1-绂佺敤', `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '澶囨敞', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鍒涘缓鑰�', @@ -3685,6 +3687,22 @@ KEY `idx_effective_date` (`effective_date`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='HRM绀句繚鍏Н閲戞柟妗堣〃'; +-- ============ 琛細hrm_social_security_scheme_dept锛堜粎 DDL锛屾棤鏁版嵁锛� ============ +DROP TABLE IF EXISTS `hrm_social_security_scheme_dept`; +CREATE TABLE `hrm_social_security_scheme_dept` ( + `id` bigint NOT NULL AUTO_INCREMENT COMMENT '涓婚敭', + `scheme_id` bigint NOT NULL COMMENT '绀句繚鍏Н閲戞柟妗圛D', + `dept_id` bigint NOT NULL COMMENT '閫傜敤閮ㄩ棬ID', + `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鍒涘缓鑰�', + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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`) USING BTREE, + KEY `idx_scheme_id` (`scheme_id`) USING BTREE, + KEY `idx_dept_id` (`dept_id`) USING BTREE +) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='HRM绀句繚鍏Н閲戞柟妗堥�傜敤閮ㄩ棬琛�'; + -- ============ 琛細hrm_tax_rate_config锛堜粎 DDL锛屾棤鏁版嵁锛� ============ DROP TABLE IF EXISTS `hrm_tax_rate_config`; CREATE TABLE `hrm_tax_rate_config` ( -- Gitblit v1.9.3