Files
usdt/sql/rent_withdraw_menu.sql
lu7213 f837befe99 提交冻结USDT,同一用户全网络仅允许一笔进行中提现。
支持后台、Telegram审核;拒绝后释放冻结。
支持管理员填写Hash核验到账、链上监听自动到账,记录到账方式和操作日志。
严格核对网络、付款方、收款方、金额及审核后交易时间,防止重复扣款。
已补齐前端申请、记录、审核、扫描状态和交易明细页面。
2026-10-30 03:44:03 -04:00

29 lines
2.6 KiB
SQL

-- 先执行rent_menu.sql及rent_withdraw_migration.sql;不自动授予业务角色管理/审核权限。
START TRANSACTION;
-- 当前初始化脚本使用rental;兼容已安装系统的proxyRent目录,优先复用现有工作台父目录。
SET @withdraw_parent=COALESCE(
(SELECT parent_id FROM sys_menu WHERE perms='rent:portal:view' AND parent_id<>0 ORDER BY menu_id LIMIT 1),
(SELECT menu_id FROM sys_menu WHERE parent_id=0 AND path IN ('rental','proxyRent') ORDER BY menu_id LIMIT 1));
INSERT INTO sys_menu(menu_name,parent_id,order_num,path,component,is_frame,is_cache,menu_type,visible,status,perms,icon,create_by,create_time)
SELECT '租赁提现审核',@withdraw_parent,30,'withdraw','rental/withdrawManage',1,0,'C','0','0','rent:withdraw:list','money','admin',NOW()
WHERE @withdraw_parent IS NOT NULL AND NOT EXISTS(SELECT 1 FROM sys_menu WHERE perms='rent:withdraw:list');
SET @withdraw_menu=(SELECT menu_id FROM sys_menu WHERE perms='rent:withdraw:list' LIMIT 1);
INSERT INTO sys_menu(menu_name,parent_id,order_num,path,is_frame,is_cache,menu_type,visible,status,perms,icon,create_by,create_time)
SELECT p.label,COALESCE(@withdraw_menu,@withdraw_parent),99,'#',1,0,'F','0','0',p.perm,'#','admin',NOW()
FROM (SELECT '申请本人提现' label,'rent:withdraw:create' perm
UNION ALL SELECT '审核租赁提现','rent:withdraw:review'
UNION ALL SELECT '手动核验提现到账','rent:withdraw:execute') p
WHERE @withdraw_parent IS NOT NULL AND NOT EXISTS(SELECT 1 FROM sys_menu WHERE perms=p.perm);
-- 本人申请权限挂在资金账户菜单下,避免普通用户因按钮父菜单获得管理员入口。
SET @withdraw_account=(SELECT menu_id FROM sys_menu WHERE component IN ('system/rentAccount/user/index','system/rentAccount/index') ORDER BY menu_id LIMIT 1);
UPDATE sys_menu SET parent_id=COALESCE(@withdraw_account,@withdraw_parent) WHERE perms='rent:withdraw:create';
INSERT INTO sys_role_menu(role_id,menu_id)
SELECT r.role_id,m.menu_id FROM sys_role r JOIN sys_menu m ON m.perms='rent:withdraw:create'
WHERE r.role_key IN ('PROXY_ACCOUNT','PROXY_SUPPLIER')
AND NOT EXISTS(SELECT 1 FROM sys_role_menu x WHERE x.role_id=r.role_id AND x.menu_id=m.menu_id);
-- 超级管理员角色自动获管理权限;其他运营角色通过角色管理显式分配,Telegram映射用户亦需review权限。
INSERT INTO sys_role_menu(role_id,menu_id)
SELECT r.role_id,m.menu_id FROM sys_role r JOIN sys_menu m ON m.perms IN ('rent:withdraw:list','rent:withdraw:review','rent:withdraw:execute')
WHERE r.role_key='admin' AND NOT EXISTS(SELECT 1 FROM sys_role_menu x WHERE x.role_id=r.role_id AND x.menu_id=m.menu_id);
COMMIT;