shanxia2.0/backend/scripts/migration_20260712_add_finance_dept.sql

-- =============================================================================
-- 新增财务部门（shanxia2.0 租户）
-- 执行库：shanxia2.0
-- 日期：2026-07-12
--
-- 部门树（执行后）：
--   安庆市山峡化工有限公司（根）
--   ├── 销售部
--   ├── 财务部门  ← 本脚本新增
--   ├── 人力资源部
--   └── 生产现场部
--
-- 可重复执行：已存在同 ID 部门则跳过插入
-- =============================================================================

SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci;
SET collation_connection = 'utf8mb4_unicode_ci';

SET @tenant_no := 'shanxia2.0';
SET @admin_user_id := 'd3000000000000000000000000000001';
SET @dept_root_id := 'b13c2be2-4e71-11f1-9f47-00163e3bdd96';
SET @dept_finance_id := 'F65CAAE057914CCCAE2A81BE627A43EF';

START TRANSACTION;

INSERT INTO sys_dept (
  id, parent_id, dept_name, dept_category_code, status,
  leader, leader_phone, tenant_no, order_num, remark,
  create_by, create_dept_id, create_time, update_by, update_time, del_flag
)
SELECT
  @dept_finance_id,
  @dept_root_id,
  '财务部门',
  'bm',
  '1',
  NULL,
  NULL,
  @tenant_no,
  15,
  '用户迁移前新增',
  @admin_user_id,
  @dept_root_id,
  NOW(),
  @admin_user_id,
  NOW(),
  0
FROM DUAL
WHERE NOT EXISTS (
  SELECT 1
  FROM sys_dept
  WHERE id = @dept_finance_id COLLATE utf8mb4_unicode_ci
    AND tenant_no = @tenant_no COLLATE utf8mb4_unicode_ci
    AND del_flag = 0
);

COMMIT;

SELECT id, parent_id, dept_name, dept_category_code, order_num, status
FROM sys_dept
WHERE tenant_no = @tenant_no COLLATE utf8mb4_unicode_ci
  AND del_flag = 0
ORDER BY parent_id, order_num, dept_name;