郭庆泰
67be5345ad
- mapper: selectFields 加 COALESCE(bp.name, u.user_name), LEFT JOIN biz_person (uk_person_user_id 防笛卡尔积) - mapper: insert 补 7 字段 (plan_name/plan_direction/plan_category/project_form/design_file_url/is_settled/project_no), plan_name NOT NULL 缺默认 - SQL: 紧急迁移脚本 add submitter_id + idx + biz_person UNIQUE (ALTER, 不 DROP) - SubmissionNew: page-card + breadcrumb + max-width 1200px, accept=.pdf/.png/.jpg/.jpeg, __silentError 防双 toast - SubmissionNew: el-upload drag 模式 A (对齐 Meetings.vue, 删 design-uploader 自定义 CSS) - SubmissionDetail: 删状态/投稿人/投稿时间/审计, 改 Preview 组件展示设计文件
31 lines
1.4 KiB
SQL
31 lines
1.4 KiB
SQL
-- ============================================================
|
|
-- 紧急修复: 医生首页报 Unknown column 'p.submitter_id'
|
|
-- 时间: 2026-08-18
|
|
-- 说明:
|
|
-- biz_project_plan 加 submitter_id 列 + 索引 (代码已先行, DB 跟上)
|
|
-- biz_person.user_id 加 UNIQUE (LEFT JOIN 1:1 保证, 避免笛卡尔积)
|
|
-- ⚠️ 不 DROP 任何表 (DROP 走单独决策)
|
|
-- ============================================================
|
|
|
|
USE guoju0808;
|
|
|
|
-- ALTER 1: 给 biz_project_plan 加投稿人字段
|
|
ALTER TABLE biz_project_plan
|
|
ADD COLUMN submitter_id BIGINT NULL COMMENT '投稿人用户ID (医生侧投稿归属, 经理/admin 录入为 NULL)';
|
|
|
|
-- ALTER 2: 给 submitter_id 加索引 (加速 WHERE 过滤)
|
|
CREATE INDEX idx_plan_submitter ON biz_project_plan(submitter_id);
|
|
|
|
-- ALTER 3: biz_person.user_id 加 UNIQUE (1:1 LEFT JOIN 无笛卡尔积)
|
|
-- 当前 dump 已确认 biz_person.user_id 无重复 (12 条数据, user_id 非空 2 条且 user_id=106/107 各一条)
|
|
ALTER TABLE biz_person
|
|
ADD UNIQUE KEY uk_person_user_id (user_id);
|
|
|
|
-- 验证
|
|
SELECT 'biz_project_plan.submitter_id' AS check_item, COUNT(*) AS col_exists
|
|
FROM information_schema.COLUMNS
|
|
WHERE TABLE_SCHEMA='guoju0808' AND TABLE_NAME='biz_project_plan' AND COLUMN_NAME='submitter_id';
|
|
|
|
SELECT 'biz_person.uk_person_user_id' AS check_item, COUNT(*) AS idx_exists
|
|
FROM information_schema.STATISTICS
|
|
WHERE TABLE_SCHEMA='guoju0808' AND TABLE_NAME='biz_person' AND INDEX_NAME='uk_person_user_id'; |