一張任務卡走完「交證據 → 主管審 → 顧問審 → 結案」

%%{init: {'theme':'base','themeVariables':{'primaryColor':'#E2F0F1','primaryTextColor':'#14201F','primaryBorderColor':'#0E7C86','secondaryColor':'#EEF2F3','secondaryTextColor':'#14201F','tertiaryColor':'#FBFCFC','tertiaryTextColor':'#14201F','lineColor':'#4A5A5C','textColor':'#14201F','mainBkg':'#E2F0F1','nodeBorder':'#0E7C86','nodeTextColor':'#14201F','edgeLabelBackground':'#FBFCFC','titleColor':'#14201F','clusterBkg':'#FBFCFC','clusterBorder':'#E4EAEB','actorBkg':'#E2F0F1','actorTextColor':'#14201F','actorBorder':'#0E7C86','actorLineColor':'#C7D1D2','signalColor':'#4A5A5C','signalTextColor':'#14201F','labelBoxBkgColor':'#EEF2F3','labelBoxBorderColor':'#C7D1D2','labelTextColor':'#14201F','loopTextColor':'#14201F','noteBkgColor':'#F6EBD5','noteTextColor':'#14201F','noteBorderColor':'#9C6B12','activationBkgColor':'#EEF2F3','activationBorderColor':'#C7D1D2','sequenceNumberColor':'#FFFFFF'}}}%%
flowchart LR
    C1[① 任務卡關卡列<br/>送審／核可／退回／歷程] --> C2[② 待辦任務頁]
    C1 --> C3[③ 任務關卡樣板設定]
    C3 --> C4[④ 規劃頁套流程<br/>套用到其他任務]
    C1 --> C5[⑤ 退回重開與結案接線]
    C4 --> C5

%%{init: {'theme':'base','themeVariables':{'primaryColor':'#E2F0F1','primaryTextColor':'#14201F','primaryBorderColor':'#0E7C86','secondaryColor':'#EEF2F3','secondaryTextColor':'#14201F','tertiaryColor':'#FBFCFC','tertiaryTextColor':'#14201F','lineColor':'#4A5A5C','textColor':'#14201F','mainBkg':'#E2F0F1','nodeBorder':'#0E7C86','nodeTextColor':'#14201F','edgeLabelBackground':'#FBFCFC','titleColor':'#14201F','clusterBkg':'#FBFCFC','clusterBorder':'#E4EAEB','actorBkg':'#E2F0F1','actorTextColor':'#14201F','actorBorder':'#0E7C86','actorLineColor':'#C7D1D2','signalColor':'#4A5A5C','signalTextColor':'#14201F','labelBoxBkgColor':'#EEF2F3','labelBoxBorderColor':'#C7D1D2','labelTextColor':'#14201F','loopTextColor':'#14201F','noteBkgColor':'#F6EBD5','noteTextColor':'#14201F','noteBorderColor':'#9C6B12','activationBkgColor':'#EEF2F3','activationBorderColor':'#C7D1D2','sequenceNumberColor':'#FFFFFF'}}}%%
erDiagram
    review_step_groups ||--o{ review_step_group_items : "一組多關（公司設定）"
    job_executions ||--o{ job_review_steps : "套組時複製成快照"
    job_executions ||--o{ job_review_step_logs : "每次推進／退回一筆"
    job_review_steps ||--o{ job_review_step_assignees : "PM 在規劃頁指派每關的人（可多人）"
    review_step_groups {
        int id PK
        int tenant_id "租戶"
        string name "組名稱"
        text description
        bool is_default "公司預設"
    }
    review_step_group_items {
        int group_id FK
        int seq "順序"
        string name "關卡名稱（自由文字）"
        text description
        int[] back_to_seqs "允許退回到哪幾關"
    }
    job_executions {
        int review_step_no "目前第幾關；null=沒套"
        int review_group_id "來源組，只記錄"
    }
    job_review_steps {
        int job_execution_id FK
        int seq
        string name
        text description
        int[] back_to_seqs
    }
    job_review_step_assignees {
        int job_execution_id FK
        int seq "第幾關"
        int user_id "可多人"
    }
    job_review_step_logs {
        int job_execution_id FK
        int seq "在哪一關"
        string action "submit / approve / reject / reopen"
        int to_seq "退回到哪關"
        int user_id
        text note
        timestamptz created_at
    }

%%{init: {'theme':'base','themeVariables':{'primaryColor':'#E2F0F1','primaryTextColor':'#14201F','primaryBorderColor':'#0E7C86','secondaryColor':'#EEF2F3','secondaryTextColor':'#14201F','tertiaryColor':'#FBFCFC','tertiaryTextColor':'#14201F','lineColor':'#4A5A5C','textColor':'#14201F','mainBkg':'#E2F0F1','nodeBorder':'#0E7C86','nodeTextColor':'#14201F','edgeLabelBackground':'#FBFCFC','titleColor':'#14201F','clusterBkg':'#FBFCFC','clusterBorder':'#E4EAEB','actorBkg':'#E2F0F1','actorTextColor':'#14201F','actorBorder':'#0E7C86','actorLineColor':'#C7D1D2','signalColor':'#4A5A5C','signalTextColor':'#14201F','labelBoxBkgColor':'#EEF2F3','labelBoxBorderColor':'#C7D1D2','labelTextColor':'#14201F','loopTextColor':'#14201F','noteBkgColor':'#F6EBD5','noteTextColor':'#14201F','noteBorderColor':'#9C6B12','activationBkgColor':'#EEF2F3','activationBorderColor':'#C7D1D2','sequenceNumberColor':'#FFFFFF'}}}%%
sequenceDiagram
    participant PM as 專案管理者
    participant EX as 執行人
    participant MG as 主管（第 2 關）
    participant CS as 顧問（第 3 關）
    participant BE as 後端
    participant WF as BPMN 引擎
    PM->>BE: 規劃頁套「標準三關」（複製快照、cur=1）
    Note over WF: 專案啟動，方塊實體化成 PROCESSING（既有）
    BE-->>EX: 通知「待你處理」（既有 notify_user_todo_job）
    EX->>BE: 上傳證據、按「送審」
    BE->>BE: cur=2、寫歷程 submit
    BE-->>MG: 通知「待你審核」
    MG->>BE: 看同一張卡的證據與留言，按「退回 → 第 1 關」＋理由
    BE->>BE: cur=1、寫歷程 reject
    BE-->>EX: 通知「被退回」＋理由
    EX->>BE: 補證據、再送審
    BE-->>MG: 通知
    MG->>BE: 核可
    BE->>BE: cur=3、寫歷程 approve
    BE-->>CS: 通知
    CS->>BE: 核可並結案
    BE->>BE: cur=4（最後一關）
    BE->>WF: complete_job()（既有）
    WF->>WF: 下一方塊實體化、通知其執行人（既有）