# RC-012 ## Guest Management Workspace You are implementing Release Candidate RC-012 for the INVEETAIRE platform. IMPORTANT This is NOT feature development. This is NOT Theme development. This is NOT Wedding Day implementation. This patch ONLY improves the Guest Management experience. The application has already completed: ✓ RC-011 Couple Experience Do NOT modify authentication. Do NOT modify database schema. Do NOT modify Theme Engine. Do NOT modify business rules. Reuse existing Guest module whenever possible. --- Objective Transform Guest Management into a complete workspace for managing wedding guests. Users should be able to: • View guests • Search guests • Filter guests • Add guests manually • Edit guests • Delete guests • Import Excel • Download Excel Template without leaving the Guest module. --- Navigation Guests ├── Guest List ├── Add Guest ├── Import Excel └── Download Template --- Guest List Create a modern management table. Columns Guest Name Phone Number Category Pax Attendance Status RSVP Status Action Implement Search Pagination Sorting (if already available) Filter by Category Filter by RSVP Filter by Attendance Responsive table. Reuse existing styles. --- Guest CRUD Implement Create Edit Delete Validation Confirmation modal before delete. Reuse existing Guest service. Do NOT duplicate SQL. --- Import Excel Replace CSV-first workflow. Primary import format: Microsoft Excel (.xlsx) Provide Download Template Upload File Preview Data Import Result Validation Report Do NOT remove CSV support if already implemented. Simply make Excel the primary workflow. --- Excel Template Generate a downloadable template matching the current database structure. Columns should match the Guest table. Example Guest Name Phone Number Category Invitation Name Address Pax Notes Use the exact field mapping used by the importer. --- Import Validation Validate Required fields Phone format Numeric fields Duplicate guest detection Duplicate phone detection Invalid rows Show validation report before final import. Do NOT import immediately without preview. --- Empty State When no guests exist: Elegant illustration placeholder Message "No guests have been added yet." Buttons Add Guest Import Excel --- Statistics Display Total Guests Total Pax RSVP Received Checked-In at the top of the Guest workspace. Reuse existing queries whenever possible. --- Quick Actions Display Add Guest Import Excel Download Template Export Guests Only enable Export if already implemented. Otherwise show disabled placeholder. --- Design Continue using the RC-008 Design System. Maintain White background Lavender Periwinkle Rounded cards Consistent spacing Responsive layout --- Constraints Do NOT Modify authentication Modify Theme Engine Modify Wedding Day Modify Invitation Modify Dashboard Modify database schema Rewrite Guest business logic Duplicate SQL Introduce external Excel libraries if an existing implementation already exists. --- Verification Verify Guest List CRUD Import Excel Download Template Validation Search Filter Pagination Responsive Accessibility BASE_PATH compatibility localhost/inveetaire compatibility Production compatibility PHP syntax --- Acceptance Criteria PASS only if Guest module becomes a complete management workspace. Manual CRUD works. Excel workflow implemented. Template downloadable. Validation report available. Business logic unchanged. Database unchanged. Responsive. PHP syntax passes. --- Output Provide 1. Files created. 2. Files modified. 3. Guest workspace improvements. 4. CRUD implementation. 5. Excel import workflow. 6. Validation workflow. 7. Verification results. 8. Acceptance checklist. 9. PHP syntax results. Stop after implementation. Wait for Human Approval.