메뉴
Use when user asks to generate an Excel / xlsx — attendance report, roster, financial breakdown, grade sheet, 'báo cáo điểm danh', 'xuất Excel'. Wave 5 ships weekly attendance report only; additional templates land in later waves per GAP-047 roadmap.
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
SOC 직업 분류 기준
Dùng khi user nói 'start new session', 'bắt đầu session mới', '/start-session', 'what's the state?', 'tình trạng hiện tại', hoặc khi cần load context sau khi /clear. Load: CLAUDE.md digest, current wave, open PRs, failing CI, active blockers. Output: single summary block. Cũng check session-lock conflicts khi chạy parallel agents.
Dùng khi user nói 'plan wave', 'cluster gaps', 'wave-pack', 'next wave', hoặc khi cần group ≥3 disjoint gaps thành 1 wave-pack chạy parallel agents. Output: wave plan markdown (foundation PR-ready) + file-overlap matrix + 3-5 agent prompts. Codify pattern từ Wave Observability 2026-04-28 (3 gaps trong ~75 min vs ~6h serial = 5x speedup).
Use when PR touches kitehub-email templates (*.html under templates/emails/), kiteclass-gateway email templates, any new customer-facing email, phrases 'review email', 'kiểm tra email template', 'gửi email cho tenant', 'trial-expiry email', 'welcome email'. Enforces brand/legal/i18n/mobile/GDPR-PDPL gate before customer send per output-review-mandate §5.7.
Dùng khi 'kit parity', 'kit production parity', 'review Track 2 port', 'port theo ui kit', 'kit vs production', 'back-port kit', hoặc trước khi merge PR port kit → production / production → kit. Verifies 4-layer V-model parity (要件定義 / 基本設計 / 詳細設計 / コンポーネント設計) giữa HTML kit prototype và production Next.js code. Bidirectional: kit→production port AND production→kit back-port (production led). Output report /4-layer to documents/04-quality/audits/parity/.
Dùng khi PR thay đổi AI Branding behavior — model swap (Ollama → Bedrock, Llama → Gemma), prompt template change, AIClient/Step interface, ContentModerationService, InstanceQualityReviewer logic, 5 *QualityCheck classes. Auto-trigger qua audit-gate khi files match `kiteclass/kiteclass-core/src/main/java/com/kiteclass/core/module/{ai,branding,instance,quality,moderation,provisioning}/**/*.java`. Manual checklist mode (5 sections × scoring) + delta-vs-baseline rubric. Output: `documents/04-quality/audits/ai-branding/YYYY-MM-DD-<change>.md`.
Dùng khi user nói 'security audit', 'pentest', 'kiểm tra bảo mật', 'dependency scan', hoặc trước production deploy. Deep security check /100 — vượt xa quality-audit §2. v2 audit format mandatory per GAP-564: mỗi control bind với evidence block (Command run + Output + Verdict + Evidence artifact ID).
| name | document-generation-excel |
| description | Use when user asks to generate an Excel / xlsx — attendance report, roster, financial breakdown, grade sheet, 'báo cáo điểm danh', 'xuất Excel'. Wave 5 ships weekly attendance report only; additional templates land in later waves per GAP-047 roadmap. |
Excel strategy for com.kiteclass.core.module.document.DocumentGenerationService (ADR-019 Facade + Strategy). Auto-wired via Spring's List<Generator> injection.
templateId = "attendance" onlyPrefer SUMIF / COUNTIF / SUM / IFERROR formulas over pre-computed values. Users editing a cell (e.g. changing a P to A) MUST see totals + percentages auto-update. If a value can be derived, write a formula.
Color convention:
DocumentRequest(format=XLSX, templateId, tenantId, data) to facade.XlsxGenerator routes by templateId; attendance → AttendanceReportBuilder.XSSFWorkbook:
COUNTIF / IFERROR formulasTổng cộng summary with SUM + column COUNTIF formulasDocumentResponse(bytes, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, "attendance-{weekStart}.xlsx").Thứ 2 through Thứ 7 (Monday–Saturday). Do NOT localise with Locale.of("vi") — hardcode these in the header row; POI renders label text literally, not via DateFormatSymbols.Nguyễn Phạm Hồng Ánh Tuấn) need ~40+ chars; set column width ≥ 8000 units (≈ 24 Excel chars).0.00% not 0%. Attendance rate of 83.33% should not truncate to "83%".#,##0\ "đ" — note the \ (backslash-space) escapes the literal space.reference/excel-formula-patterns.md — VN financial / academic formula catalogattendance (GAP-208, Wave 7).