msumshk/TakeoutSaaS.Docs
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity

Compare commits

base: msumshk:feature/finance-report-1to1-docs
Branches Tags
msumshk:main msumshk:feature/finance-report-1to1-docs msumshk:feature/member-points-mall-1to1
..
compare: msumshk:feature/member-points-mall-1to1
Branches Tags
msumshk:feature/finance-report-1to1-docs msumshk:feature/member-points-mall-1to1 msumshk:main

1 Commits
feature/fi ... feature/me

Author SHA1 Message Date
MSuMshk
2bceb20bae docs(member): add points mall and message reach permission seeds 2026-03-04 13:34:24 +08:00
3 changed files with 72 additions and 130 deletions
Expand all files Collapse all files

13
deploy/postgres/README.md
View File

@@ -13,8 +13,7 @@
- `seed_tenant_customer_permissions.sql`：补齐租户端客户管理权限码、菜单权限与角色授权映射（可重复执行）。 - `seed_tenant_customer_permissions.sql`：补齐租户端客户管理权限码、菜单权限与角色授权映射（可重复执行）。
- `seed_tenant_member_permissions.sql`：补齐租户端会员管理权限码、菜单权限与角色授权映射（可重复执行）。 - `seed_tenant_member_permissions.sql`：补齐租户端会员管理权限码、菜单权限与角色授权映射（可重复执行）。
- `seed_tenant_member_stored_card_permissions.sql`：补齐租户端会员储值卡权限码、菜单权限与角色授权映射（可重复执行）。 - `seed_tenant_member_stored_card_permissions.sql`：补齐租户端会员储值卡权限码、菜单权限与角色授权映射（可重复执行）。
- `seed_tenant_finance_permissions.sql`：补齐租户端财务中心交易流水与到账查询权限码、菜单权限与角色授权映射（可重复执行）。 - `seed_tenant_member_points_mall_permissions.sql`：补齐租户端积分商城权限码、菜单权限与角色授权映射（可重复执行）。
- `seed_tenant_finance_invoice_permissions.sql`：补齐租户端财务中心发票管理权限码、菜单权限与角色授权映射（可重复执行）。
## 前置条件 ## 前置条件
@@ -145,19 +144,19 @@ psql -h <host> -p <port> -U identity_user -d takeout_identity_db -f .\seed_tenan
2. 更新会员储值卡菜单 (`/member/stored-card/index`) 的 `RequiredPermissions`、`MetaPermissions` 与 `AuthListJson`。 2. 更新会员储值卡菜单 (`/member/stored-card/index`) 的 `RequiredPermissions`、`MetaPermissions` 与 `AuthListJson`。
3. 按订单列表权限映射补齐会员储值卡权限的角色模板与租户角色授权。 3. 按订单列表权限映射补齐会员储值卡权限的角色模板与租户角色授权。
## 财务中心交易流水/到账权限补齐 ## 积分商城权限补齐
在 `takeout_identity_db` 执行： 在 `takeout_identity_db` 执行：
```powershell ```powershell
psql -h <host> -p <port> -U identity_user -d takeout_identity_db -f .\seed_tenant_finance_permissions.sql psql -h <host> -p <port> -U identity_user -d takeout_identity_db -f .\seed_tenant_member_points_mall_permissions.sql
``` ```
脚本会完成： 脚本会完成：
1. 新增/修正 `tenant:finance:transaction:*` 与 `tenant:finance:settlement:*` 权限码。 1. 新增/修正 `tenant:member:points-mall:*` 权限码（view/manage）。
2. 更新财务中心菜单 `TransactionFlow` (`/finance/transaction/index`) 与 `SettlementQuery` (`/finance/settlement/index`) 的 `RequiredPermissions`、`MetaPermissions` 与 `AuthListJson`。 2. 更新积分商城菜单 (`/member/points-mall/index`) 的 `RequiredPermissions`、`MetaPermissions` 与 `AuthListJson`。
3. 按旧财务权限（`income/statement`）映射补齐角色模板与租户角色授权。 3. 按会员模块权限映射补齐积分商城权限的角色模板与租户角色授权。
## 常见问题 ## 常见问题

115
deploy/postgres/seed_tenant_finance_permissions.sql → deploy/postgres/seed_tenant_member_message_reach_permissions.sql
View File

@@ -1,16 +1,13 @@
-- 文件职责：补齐 Tenant 端财务中心交易流水与到账查询权限、菜单绑定与角色授权映射（可重复执行）。 -- 文件职责：补齐 Tenant 端会员消息触达权限与菜单绑定（可重复执行）。
-- 执行范围：takeout_identity 数据库（Portal=1，Tenant 端）。 -- 执行范围：takeout_identity 数据库（Portal=1，Tenant 端）。
BEGIN; BEGIN;
-- 1) 新增/修正财务中心交易流水与到账查询权限码 -- 1) 新增/修正会员消息触达权限码
WITH finance_permissions(code, name, sort_order) AS ( WITH message_reach_permissions(code, name, sort_order) AS (
VALUES VALUES
('tenant:finance:transaction:view', '查看交易流水', 51), ('tenant:member:message-reach:view', '查看会员消息触达', 48),
('tenant:finance:transaction:detail', '查看交易流水详情', 52), ('tenant:member:message-reach:manage', '管理会员消息触达', 49)
('tenant:finance:transaction:export', '导出交易流水', 53),
('tenant:finance:settlement:view', '查看到账查询', 54),
('tenant:finance:settlement:export', '导出到账查询', 55)
), ),
missing AS ( missing AS (
SELECT SELECT
@@ -18,7 +15,7 @@ missing AS (
source.name, source.name,
source.sort_order, source.sort_order,
ROW_NUMBER() OVER (ORDER BY source.sort_order, source.code) AS rn ROW_NUMBER() OVER (ORDER BY source.sort_order, source.code) AS rn
FROM finance_permissions source FROM message_reach_permissions source
LEFT JOIN public.permissions existing LEFT JOIN public.permissions existing
ON existing."Code" = source.code ON existing."Code" = source.code
WHERE existing."Id" IS NULL WHERE existing."Id" IS NULL
@@ -30,24 +27,18 @@ base AS (
parent AS ( parent AS (
SELECT COALESCE( SELECT COALESCE(
( (
SELECT "ParentId" SELECT "Id"
FROM public.permissions FROM public.permissions
WHERE "Code" = 'tenant:finance:income:view' WHERE "Code" = 'tenant:member:view'
LIMIT 1 LIMIT 1
), ),
( (
SELECT "ParentId" SELECT "ParentId"
FROM public.permissions FROM public.permissions
WHERE "Code" = 'tenant:finance:statement:view' WHERE "Code" = 'tenant:order:list:view'
LIMIT 1 LIMIT 1
), ),
( 820000000000000004
SELECT "ParentId"
FROM public.permissions
WHERE "Code" = 'tenant:finance:transaction:view'
LIMIT 1
),
820000000000000006
) AS parent_id ) AS parent_id
) )
INSERT INTO public.permissions INSERT INTO public.permissions
@@ -74,35 +65,26 @@ FROM missing
CROSS JOIN base CROSS JOIN base
CROSS JOIN parent; CROSS JOIN parent;
WITH finance_permissions(code, name, sort_order) AS ( WITH message_reach_permissions(code, name, sort_order) AS (
VALUES VALUES
('tenant:finance:transaction:view', '查看交易流水', 51), ('tenant:member:message-reach:view', '查看会员消息触达', 48),
('tenant:finance:transaction:detail', '查看交易流水详情', 52), ('tenant:member:message-reach:manage', '管理会员消息触达', 49)
('tenant:finance:transaction:export', '导出交易流水', 53),
('tenant:finance:settlement:view', '查看到账查询', 54),
('tenant:finance:settlement:export', '导出到账查询', 55)
), ),
parent AS ( parent AS (
SELECT COALESCE( SELECT COALESCE(
( (
SELECT "ParentId" SELECT "Id"
FROM public.permissions FROM public.permissions
WHERE "Code" = 'tenant:finance:income:view' WHERE "Code" = 'tenant:member:view'
LIMIT 1 LIMIT 1
), ),
( (
SELECT "ParentId" SELECT "ParentId"
FROM public.permissions FROM public.permissions
WHERE "Code" = 'tenant:finance:statement:view' WHERE "Code" = 'tenant:order:list:view'
LIMIT 1 LIMIT 1
), ),
( 820000000000000004
SELECT "ParentId"
FROM public.permissions
WHERE "Code" = 'tenant:finance:transaction:view'
LIMIT 1
),
820000000000000006
) AS parent_id ) AS parent_id
) )
UPDATE public.permissions target UPDATE public.permissions target
@@ -115,48 +97,30 @@ SET
"DeletedAt" = NULL, "DeletedAt" = NULL,
"DeletedBy" = NULL, "DeletedBy" = NULL,
"UpdatedAt" = NOW() "UpdatedAt" = NOW()
FROM finance_permissions source FROM message_reach_permissions source
CROSS JOIN parent CROSS JOIN parent
WHERE target."Code" = source.code; WHERE target."Code" = source.code;
-- 2) 绑定交易流水菜单权限 -- 2) 绑定会员消息触达菜单权限
UPDATE public.menu_definitions UPDATE public.menu_definitions
SET SET
"RequiredPermissions" = 'tenant:finance:transaction:view', "RequiredPermissions" = 'tenant:member:message-reach:view',
"MetaPermissions" = 'tenant:finance:transaction:view,tenant:finance:transaction:detail,tenant:finance:transaction:export', "MetaPermissions" = 'tenant:member:message-reach:view,tenant:member:message-reach:manage',
"AuthListJson" = '[{"title":"详情","authMark":"tenant:finance:transaction:detail"},{"title":"导出","authMark":"tenant:finance:transaction:export"}]', "AuthListJson" = '[{"title":"编辑","authMark":"tenant:member:message-reach:manage"}]',
"UpdatedAt" = NOW() "UpdatedAt" = NOW()
WHERE WHERE
"Portal" = 1 "Portal" = 1
AND ( AND (
"Name" = 'TransactionFlow' "Name" = 'MessageReach'
OR "Path" = 'transaction' OR "Path" = 'message-reach'
OR "Component" = '/finance/transaction/index' OR "Component" = '/member/message-reach/index'
); );
-- 3) 绑定到账查询菜单权限 -- 3) 给角色模板补齐会员消息触达权限（按会员模块权限映射）
UPDATE public.menu_definitions
SET
"RequiredPermissions" = 'tenant:finance:settlement:view',
"MetaPermissions" = 'tenant:finance:settlement:view,tenant:finance:settlement:export',
"AuthListJson" = '[{"title":"导出","authMark":"tenant:finance:settlement:export"}]',
"UpdatedAt" = NOW()
WHERE
"Portal" = 1
AND (
"Name" = 'SettlementQuery'
OR "Path" = 'settlement'
OR "Component" = '/finance/settlement/index'
);
-- 4) 给角色模板补齐新权限（按旧财务权限映射）
WITH code_mapping(source_code, target_code) AS ( WITH code_mapping(source_code, target_code) AS (
VALUES VALUES
('tenant:finance:income:view', 'tenant:finance:transaction:view'), ('tenant:member:view', 'tenant:member:message-reach:view'),
('tenant:finance:income:view', 'tenant:finance:transaction:detail'), ('tenant:member:manage', 'tenant:member:message-reach:manage')
('tenant:finance:income:export', 'tenant:finance:transaction:export'),
('tenant:finance:statement:view', 'tenant:finance:settlement:view'),
('tenant:finance:statement:export', 'tenant:finance:settlement:export')
), ),
candidates AS ( candidates AS (
SELECT DISTINCT SELECT DISTINCT
@@ -204,11 +168,8 @@ CROSS JOIN base;
WITH code_mapping(source_code, target_code) AS ( WITH code_mapping(source_code, target_code) AS (
VALUES VALUES
('tenant:finance:income:view', 'tenant:finance:transaction:view'), ('tenant:member:view', 'tenant:member:message-reach:view'),
('tenant:finance:income:view', 'tenant:finance:transaction:detail'), ('tenant:member:manage', 'tenant:member:message-reach:manage')
('tenant:finance:income:export', 'tenant:finance:transaction:export'),
('tenant:finance:statement:view', 'tenant:finance:settlement:view'),
('tenant:finance:statement:export', 'tenant:finance:settlement:export')
) )
UPDATE public.role_template_permissions target UPDATE public.role_template_permissions target
SET SET
@@ -222,14 +183,11 @@ WHERE
source."RoleTemplateId" = target."RoleTemplateId" source."RoleTemplateId" = target."RoleTemplateId"
AND target."PermissionCode" = mapping.target_code; AND target."PermissionCode" = mapping.target_code;
-- 5) 给租户角色补齐新权限（按旧财务权限映射） -- 4) 给租户角色补齐会员消息触达权限（按会员模块权限映射）
WITH code_mapping(source_code, target_code) AS ( WITH code_mapping(source_code, target_code) AS (
VALUES VALUES
('tenant:finance:income:view', 'tenant:finance:transaction:view'), ('tenant:member:view', 'tenant:member:message-reach:view'),
('tenant:finance:income:view', 'tenant:finance:transaction:detail'), ('tenant:member:manage', 'tenant:member:message-reach:manage')
('tenant:finance:income:export', 'tenant:finance:transaction:export'),
('tenant:finance:statement:view', 'tenant:finance:settlement:view'),
('tenant:finance:statement:export', 'tenant:finance:settlement:export')
), ),
source_rows AS ( source_rows AS (
SELECT DISTINCT SELECT DISTINCT
@@ -301,11 +259,8 @@ CROSS JOIN base;
WITH code_mapping(source_code, target_code) AS ( WITH code_mapping(source_code, target_code) AS (
VALUES VALUES
('tenant:finance:income:view', 'tenant:finance:transaction:view'), ('tenant:member:view', 'tenant:member:message-reach:view'),
('tenant:finance:income:view', 'tenant:finance:transaction:detail'), ('tenant:member:manage', 'tenant:member:message-reach:manage')
('tenant:finance:income:export', 'tenant:finance:transaction:export'),
('tenant:finance:statement:view', 'tenant:finance:settlement:view'),
('tenant:finance:statement:export', 'tenant:finance:settlement:export')
) )
UPDATE public.role_permissions target UPDATE public.role_permissions target
SET SET

74
deploy/postgres/seed_tenant_finance_invoice_permissions.sql → deploy/postgres/seed_tenant_member_points_mall_permissions.sql
View File

@@ -1,15 +1,13 @@
-- 文件职责：补齐 Tenant 端财务中心发票管理权限与菜单权限绑定（可重复执行）。 -- 文件职责：补齐 Tenant 端积分商城权限与菜单绑定（可重复执行）。
-- 执行范围：takeout_identity 数据库（Portal=1，Tenant 端）。 -- 执行范围：takeout_identity 数据库（Portal=1，Tenant 端）。
BEGIN; BEGIN;
-- 1) 新增/修正发票管理权限码 -- 1) 新增/修正积分商城权限码
WITH invoice_permissions(code, name, sort_order) AS ( WITH points_mall_permissions(code, name, sort_order) AS (
VALUES VALUES
('tenant:finance:invoice:view', '查看发票管理', 63), ('tenant:member:points-mall:view', '查看积分商城', 50),
('tenant:finance:invoice:issue', '发票开票', 64), ('tenant:member:points-mall:manage', '管理积分商城', 51)
('tenant:finance:invoice:void', '发票作废', 65),
('tenant:finance:invoice:settings', '发票设置', 66)
), ),
missing AS ( missing AS (
SELECT SELECT
@@ -17,7 +15,7 @@ missing AS (
source.name, source.name,
source.sort_order, source.sort_order,
ROW_NUMBER() OVER (ORDER BY source.sort_order, source.code) AS rn ROW_NUMBER() OVER (ORDER BY source.sort_order, source.code) AS rn
FROM invoice_permissions source FROM points_mall_permissions source
LEFT JOIN public.permissions existing LEFT JOIN public.permissions existing
ON existing."Code" = source.code ON existing."Code" = source.code
WHERE existing."Id" IS NULL WHERE existing."Id" IS NULL
@@ -29,9 +27,9 @@ base AS (
parent AS ( parent AS (
SELECT COALESCE( SELECT COALESCE(
( (
SELECT "ParentId" SELECT "Id"
FROM public.permissions FROM public.permissions
WHERE "Code" = 'tenant:finance:transaction:view' WHERE "Code" = 'tenant:member:view'
LIMIT 1 LIMIT 1
), ),
( (
@@ -67,19 +65,17 @@ FROM missing
CROSS JOIN base CROSS JOIN base
CROSS JOIN parent; CROSS JOIN parent;
WITH invoice_permissions(code, name, sort_order) AS ( WITH points_mall_permissions(code, name, sort_order) AS (
VALUES VALUES
('tenant:finance:invoice:view', '查看发票管理', 63), ('tenant:member:points-mall:view', '查看积分商城', 50),
('tenant:finance:invoice:issue', '发票开票', 64), ('tenant:member:points-mall:manage', '管理积分商城', 51)
('tenant:finance:invoice:void', '发票作废', 65),
('tenant:finance:invoice:settings', '发票设置', 66)
), ),
parent AS ( parent AS (
SELECT COALESCE( SELECT COALESCE(
( (
SELECT "ParentId" SELECT "Id"
FROM public.permissions FROM public.permissions
WHERE "Code" = 'tenant:finance:transaction:view' WHERE "Code" = 'tenant:member:view'
LIMIT 1 LIMIT 1
), ),
( (
@@ -101,32 +97,30 @@ SET
"DeletedAt" = NULL, "DeletedAt" = NULL,
"DeletedBy" = NULL, "DeletedBy" = NULL,
"UpdatedAt" = NOW() "UpdatedAt" = NOW()
FROM invoice_permissions source FROM points_mall_permissions source
CROSS JOIN parent CROSS JOIN parent
WHERE target."Code" = source.code; WHERE target."Code" = source.code;
-- 2) 绑定发票管理菜单权限 -- 2) 绑定积分商城菜单权限
UPDATE public.menu_definitions UPDATE public.menu_definitions
SET SET
"RequiredPermissions" = 'tenant:finance:invoice:view', "RequiredPermissions" = 'tenant:member:points-mall:view',
"MetaPermissions" = 'tenant:finance:invoice:view,tenant:finance:invoice:issue,tenant:finance:invoice:void,tenant:finance:invoice:settings', "MetaPermissions" = 'tenant:member:points-mall:view,tenant:member:points-mall:manage',
"AuthListJson" = '[{"title":"开票","authMark":"tenant:finance:invoice:issue"},{"title":"作废","authMark":"tenant:finance:invoice:void"},{"title":"设置","authMark":"tenant:finance:invoice:settings"}]', "AuthListJson" = '[{"title":"编辑","authMark":"tenant:member:points-mall:manage"}]',
"UpdatedAt" = NOW() "UpdatedAt" = NOW()
WHERE WHERE
"Portal" = 1 "Portal" = 1
AND ( AND (
"Name" = 'InvoiceMgmt' "Name" = 'PointsMall'
OR "Path" = 'invoice' OR "Path" = 'points-mall'
OR "Component" = '/finance/invoice/index' OR "Component" = '/member/points-mall/index'
); );
-- 3) 给角色模板补齐发票管理权限（按交易流水权限映射） -- 3) 给角色模板补齐积分商城权限（按会员模块权限映射）
WITH code_mapping(source_code, target_code) AS ( WITH code_mapping(source_code, target_code) AS (
VALUES VALUES
('tenant:finance:transaction:view', 'tenant:finance:invoice:view'), ('tenant:member:view', 'tenant:member:points-mall:view'),
('tenant:finance:transaction:export', 'tenant:finance:invoice:issue'), ('tenant:member:manage', 'tenant:member:points-mall:manage')
('tenant:finance:transaction:export', 'tenant:finance:invoice:void'),
('tenant:finance:transaction:export', 'tenant:finance:invoice:settings')
), ),
candidates AS ( candidates AS (
SELECT DISTINCT SELECT DISTINCT
@@ -174,10 +168,8 @@ CROSS JOIN base;
WITH code_mapping(source_code, target_code) AS ( WITH code_mapping(source_code, target_code) AS (
VALUES VALUES
('tenant:finance:transaction:view', 'tenant:finance:invoice:view'), ('tenant:member:view', 'tenant:member:points-mall:view'),
('tenant:finance:transaction:export', 'tenant:finance:invoice:issue'), ('tenant:member:manage', 'tenant:member:points-mall:manage')
('tenant:finance:transaction:export', 'tenant:finance:invoice:void'),
('tenant:finance:transaction:export', 'tenant:finance:invoice:settings')
) )
UPDATE public.role_template_permissions target UPDATE public.role_template_permissions target
SET SET
@@ -191,13 +183,11 @@ WHERE
source."RoleTemplateId" = target."RoleTemplateId" source."RoleTemplateId" = target."RoleTemplateId"
AND target."PermissionCode" = mapping.target_code; AND target."PermissionCode" = mapping.target_code;
-- 4) 给租户角色补齐发票管理权限（按交易流水权限映射） -- 4) 给租户角色补齐积分商城权限（按会员模块权限映射）
WITH code_mapping(source_code, target_code) AS ( WITH code_mapping(source_code, target_code) AS (
VALUES VALUES
('tenant:finance:transaction:view', 'tenant:finance:invoice:view'), ('tenant:member:view', 'tenant:member:points-mall:view'),
('tenant:finance:transaction:export', 'tenant:finance:invoice:issue'), ('tenant:member:manage', 'tenant:member:points-mall:manage')
('tenant:finance:transaction:export', 'tenant:finance:invoice:void'),
('tenant:finance:transaction:export', 'tenant:finance:invoice:settings')
), ),
source_rows AS ( source_rows AS (
SELECT DISTINCT SELECT DISTINCT
@@ -269,10 +259,8 @@ CROSS JOIN base;
WITH code_mapping(source_code, target_code) AS ( WITH code_mapping(source_code, target_code) AS (
VALUES VALUES
('tenant:finance:transaction:view', 'tenant:finance:invoice:view'), ('tenant:member:view', 'tenant:member:points-mall:view'),
('tenant:finance:transaction:export', 'tenant:finance:invoice:issue'), ('tenant:member:manage', 'tenant:member:points-mall:manage')
('tenant:finance:transaction:export', 'tenant:finance:invoice:void'),
('tenant:finance:transaction:export', 'tenant:finance:invoice:settings')
) )
UPDATE public.role_permissions target UPDATE public.role_permissions target
SET SET