HCM

HCM BY AG Studio

Handcrafting Memories CRM

HCM

AG Photography Studio

HANDCRAFTING MEMORIES BY AG

Import .xlsx

Overall Workflow & Stage Pipeline

Real-time studio workload and client progress tracking

1. Enquiries

2. Bookings

3. Pre-Prod

4. Post-Prod

5. Completed

Enquiry Lead Management

Source: Enquiry 2024-25 26-27.xlsx

Client Name	Event Date	Budget	Lead Status	Phone / Ref	Remarks History	Next Follow-up	Actions

Booking Database Master

Source: 2019-20-21-22-23-24-25-26.xlsx

Booking Status	Client / Couple Name	Event Date	Event Type / Details	City	Total Budget	Advance / Taken	Balance Due	Actions

Post-Production Deliverables Tracker

Source: PostProduction Table.xlsx

Couple Name	Event Date	Photos	InstaFilm Reel	Short Film	Full Feature Film	Album Printing	Data Storage Path	Actions

``` ### Summary of Fixes: 1. **Added Function Definitions**: Fully implemented `switchTab`, `openModal`, `closeModal`, `filterTable`, `handleCreateEnquiry`, `updateEnquiryStatus`, `openFollowupModal`, `handleSaveFollowup`, `triggerConfirmBookingModal`, `executeConfirmBooking`, `openEditPaymentModal`, `calculateEditDue`, `handleSavePayment`, `openPreProdConfigModal`, `addScheduleDateBlock`, `removeScheduleBlock`, `addEventRowToBlock`, `removeEventRow`, `handleSavePreProdConfig`, `completePreProd`, `updatePostProdStatus`, `updatePostProdPath`, `completeProject`, `exportToExcel`, and `importFromExcel`. 2. **Explicit Window Scope Binding**: Bound each handler function to `window` (e.g., `window.switchTab = switchTab`), guaranteeing that all inline HTML `onclick`, `onsubmit`, and `onkeyup` handlers resolve without `ReferenceError` exceptions.

HCM BY AG Studio

AG Photography Studio

Overall Workflow & Stage Pipeline

Enquiry Lead Management

Booking Database Master

Pre-Production Event Schedules

Post-Production Deliverables Tracker

Add New Lead Enquiry

Add Remark & Follow-up

Confirm Booking & Convert

Update Payment Received

Configure Pre-Production Schedule

Date-Wise Event Blocks