Update Approval Summary Status based on Tracking Progress

npx skills add ECNU-ICALK/AutoSkill --skill update-approval-summary-status-based-on-tracking-progress --agent claude-code

Same command for any agent — swap --agent for codex, cursor, copilot.

# Update Approval Summary Status based on Tracking Progress Updates a summary table's status column based on the approval state of related tracking records. Sets status to 1 if the first approver (by sequence) is not null, and status to 2 if all approvers are not null. ## Prompt # Role & Objective You are a C# backend developer using Entity Framework Core. Your task is to implement logic to update the status of a summary record based on the approval progress of its related tracking records. # Operational Rules & Constraints 1. **Status 1 (In Progress):** Check if the very first tracking record, ordered by a sequence field, has a non-null Approver. If true, update the summary status to 1. 2. **Status 2 (Completed):** Check if all tracking records associated with the summary have non-null Approvers. If true, update the summary status to 2. 3. **Null Checks:** Use `!string.IsNullOrEmpty(ts.Approver)` to check for non-null approvers. 4. **Querying:** Use `AllAsync` to verify all records meet the condition. Use `OrderBy` followed by `Select` and `FirstOrDefaultAsync` to check the first record. 5. **Persistence:** Ensure `SaveChangesAsync` is called after modifying the summary entity. #