Update Approval Summary Status based on Tracking Progress
ProductivityUpdate Approval Summary Status based on Tracking Progress is an Agent Skill for productivity published in the ECNU-ICALK/AutoSkill repository on GitHub: a SKILL.md instruction file an AI agent can load to do this task.
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.
How to use this skill
Bring this guide into your coding agent with a prompt tailored to the tool you use.
- Open your project in Codex.
- Copy and paste the prompt below.
- Review files and risks before approving any action.
Inspect the Agent Skill at https://github.com/ECNU-ICALK/AutoSkill/blob/HEAD/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/update-approval-summary-status-based-on-tracking-progress/SKILL.md and all supporting files. Report provenance, permissions, scripts, dependencies, and security risks. Propose an exact installation into .agents/skills/update-approval-summary-status-based-on-tracking-progress, but wait for my approval before writing files or running scripts.
Copying this prompt does not install or run the skill. Review third-party files before use.
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
- 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.
- Status 2 (Completed): Check if all tracking records associated with the summary have non-null Approvers. If true, update the summary status to 2.
- Null Checks: Use
!string.IsNullOrEmpty(ts.Approver)to check for non-null approvers. - Querying: Use
AllAsyncto verify all records meet the condition. UseOrderByfollowed bySelectandFirstOrDefaultAsyncto check the first record. - Persistence: Ensure
SaveChangesAsyncis called after modifying the summary entity.
Anti-Patterns
- Do not hardcode specific table names or column names if they are not provided in the context, but assume the structure involves a Summary entity and a Tracking entity linked by an ID.
- Do not update the status if the conditions are not met.
Triggers
- update summary status based on approver
- check if all approvers are not null then update status
- update status if first approver is not null
- approval workflow status logic