Compare commits
2
Commits
| Author | SHA1 | Date | |
|---|---|---|---|
|
|
ef4d687d03 | ||
|
|
f5ab0c3167 |
No files matched your search
@@ -1,46 +0,0 @@
|
||||
-- =============================================================================
|
||||
-- 弱密码刷新说明:111111 → Zkxw@123
|
||||
-- 日期:2026-10-16
|
||||
-- =============================================================================
|
||||
--
|
||||
-- 重要:sys_user.password 存储 bcrypt 哈希(每次盐随机),
|
||||
-- 不能用下列语句命中弱密码用户:
|
||||
-- WHERE password = '111111' -- 无效
|
||||
-- WHERE password LIKE '%111111%' -- 无效
|
||||
--
|
||||
-- 推荐:用 Python 脚本,并通过变量指定目标库(勿依赖本机默认 .env 误连生产)。
|
||||
--
|
||||
-- cd backend && source venv/bin/activate
|
||||
--
|
||||
-- # 方式 A:完整 URL
|
||||
-- python scripts/reset_weak_password_111111.py \
|
||||
-- --database-url 'mysql+pymysql://USER:PASS@HOST:3306/DBNAME' --dry-run
|
||||
--
|
||||
-- # 方式 B:分项变量
|
||||
-- python scripts/reset_weak_password_111111.py \
|
||||
-- --db-host HOST --db-port 3306 --db-user USER --db-password 'PASS' --db-name DBNAME --dry-run
|
||||
--
|
||||
-- # 方式 C:指定环境文件
|
||||
-- python scripts/reset_weak_password_111111.py --env-file ./.env.test --dry-run
|
||||
--
|
||||
-- # 正式写入:去掉 --dry-run
|
||||
--
|
||||
-- 脚本行为:校验 del_flag=0 的用户口令是否为明文 111111(含停用账号),
|
||||
-- 命中则更新为 Zkxw@123 的新 bcrypt 哈希。
|
||||
--
|
||||
-- =============================================================================
|
||||
-- 以下仅为「已知单个用户 id」时的手工 UPDATE 模板。
|
||||
-- 哈希由本机生成示例(明文 Zkxw@123,bcrypt cost 12),部署前请用 Python 重新生成:
|
||||
-- python -c "from app.core.security import get_password_hash; print(get_password_hash('Zkxw@123'))"
|
||||
-- =============================================================================
|
||||
|
||||
-- 示例哈希(仅供手工单用户更新参考;批量请用脚本):
|
||||
-- $2b$12$ULvPCr6g9IUmI8K7nlGU5emk7hupaAz4WgFdEoQBe935Wh1pVYKCK
|
||||
|
||||
-- UPDATE sys_user
|
||||
-- SET password = '$2b$12$ULvPCr6g9IUmI8K7nlGU5emk7hupaAz4WgFdEoQBe935Wh1pVYKCK',
|
||||
-- update_time = NOW()
|
||||
-- WHERE id = '<user_id>'
|
||||
-- AND del_flag = 0;
|
||||
|
||||
-- 执行前请备份 sys_user;执行后通知用户使用新密码并建议登录后自行修改。
|
||||
@@ -1335,59 +1335,6 @@ export const sqxpAdminRoutes: AppRouteRecord[] = [
|
||||
]
|
||||
},
|
||||
|
||||
// ═══════════════════════════════════════════════════════════════════════════
|
||||
// 3b. 实验室样本处理数据 (menu:lab-sample-processing)
|
||||
// ═══════════════════════════════════════════════════════════════════════════
|
||||
{
|
||||
id: 'TOP0000000000000000000000000000L1',
|
||||
name: 'LabSampleProcessing',
|
||||
path: '/lab-sample-processing',
|
||||
component: '/index/index',
|
||||
meta: {
|
||||
title: '实验室样本处理数据',
|
||||
icon: 'ri:test-tube-line',
|
||||
keepAlive: false,
|
||||
isTopMenu: true,
|
||||
menuCode: 'menu:lab-sample-processing',
|
||||
roles: ['admin']
|
||||
},
|
||||
children: [
|
||||
{
|
||||
id: 'LAB00000000000000000000000000001',
|
||||
name: 'LabSampleProcessingHsc',
|
||||
path: 'hsc',
|
||||
component: '/lab-sample-processing/hsc/index',
|
||||
meta: {
|
||||
title: '造血干细胞数据',
|
||||
keepAlive: true,
|
||||
menuCode: 'lab:sample-processing:list'
|
||||
}
|
||||
},
|
||||
{
|
||||
id: 'LAB00000000000000000000000000002',
|
||||
name: 'LabSampleProcessingUbmc',
|
||||
path: 'ubmc',
|
||||
component: '/lab-sample-processing/ubmc/index',
|
||||
meta: {
|
||||
title: '单个核数据',
|
||||
keepAlive: true,
|
||||
menuCode: 'lab:sample-processing:list'
|
||||
}
|
||||
},
|
||||
{
|
||||
id: 'LAB00000000000000000000000000003',
|
||||
name: 'LabSampleProcessingMsc',
|
||||
path: 'msc',
|
||||
component: '/lab-sample-processing/msc/index',
|
||||
meta: {
|
||||
title: '脐带间充质干细胞数据',
|
||||
keepAlive: true,
|
||||
menuCode: 'lab:sample-processing:list'
|
||||
}
|
||||
}
|
||||
]
|
||||
},
|
||||
|
||||
// ═══════════════════════════════════════════════════════════════════════════
|
||||
// 4. 运营支撑 (menu:operations)
|
||||
// 二级菜单:系统基础信息、运营支撑
|
||||
|
||||
Reference in new issue
Block a user