# 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.