Index: Wedding_Planner.html =================================================================== --- Wedding_Planner.html (revision b7d8a4d7876853de88e2a8615a368abdc4c6981b) +++ Wedding_Planner.html (revision 768ae811a034ab3c265e9486739c51c17f335b91) @@ -339,4 +339,84 @@ let ATTENDANCE = []; let RSVPS = []; +let BUDGET_STATUS = null; // { predefined_budget, total_cost, exceeded, over_by, ... } + +// ============================================================= +// COUPLE NAMES (local-only, used for invitation emails) +// Stored in localStorage — never sent to/stored in the database. +// ============================================================= +const COUPLE_NAMES_KEY = 'wp_couple_names'; +function getCoupleNames(){ + try { + const raw = localStorage.getItem(COUPLE_NAMES_KEY); + if(!raw) return { bride_name:'', groom_name:'' }; + const parsed = JSON.parse(raw); + return { bride_name: parsed.bride_name || '', groom_name: parsed.groom_name || '' }; + } catch(e){ return { bride_name:'', groom_name:'' }; } +} +function saveCoupleNames(bride_name, groom_name){ + localStorage.setItem(COUPLE_NAMES_KEY, JSON.stringify({ bride_name, groom_name })); +} + +// Show alert + toast when a booking pushes total spending over the predefined budget +function showBudgetAlert(budget) { + if (!budget || !budget.exceeded) return; + const over = Number(budget.over_by).toLocaleString(undefined, { minimumFractionDigits: 2, maximumFractionDigits: 2 }); + const spent = Number(budget.total_cost).toLocaleString(undefined, { minimumFractionDigits: 2, maximumFractionDigits: 2 }); + const predefined = Number(budget.predefined_budget).toLocaleString(undefined, { minimumFractionDigits: 2, maximumFractionDigits: 2 }); + const msg = `⚠️ Budget Exceeded!\n\nPredefined budget: $${predefined}\nSpent so far: $${spent}\nOver by: $${over}`; + showToast(`Budget exceeded by $${over}`, 'danger'); + alert(msg); +} + +// ============================================================= +// BUDGET CALCULATION (runs entirely from already-loaded data) +// Venue : guests × price_per_guest (per confirmed booking) +// Band : hours × price_per_hour (booking_cost from server) +// Photo : hours × price_per_hour (booking_cost from server) +// ============================================================= +function calcBudgetSpent() { + const guestCount = GUESTS.length; + + const venueCost = VENUE_BOOKINGS.reduce((sum, b) => { + const venue = VENUES.find(v => String(v.venue_id) === String(b.venue_id)); + const ppg = venue ? Number(venue.price_per_guest || 0) : 0; + return sum + ppg * guestCount; + }, 0); + + // Calculate hours from time strings "HH:MM" or "HH:MM:SS" + const toHours = (start, end) => { + const toMin = t => { const p = String(t).split(':').map(Number); return p[0]*60+(p[1]||0); }; + return Math.max(0, (toMin(end) - toMin(start)) / 60); + }; + + const bandCost = BAND_BOOKINGS.reduce((sum, b) => { + const hours = b.hours ? Number(b.hours) : toHours(b.start_time, b.end_time); + return sum + hours * Number(b.price_per_hour || 0); + }, 0); + + const photoCost = PHOTOGRAPHER_BOOKINGS.reduce((sum, b) => { + const hours = b.hours ? Number(b.hours) : toHours(b.start_time, b.end_time); + return sum + hours * Number(b.price_per_hour || 0); + }, 0); + + const total = venueCost + bandCost + photoCost; + const predefined = CURRENT_WEDDING ? Number(CURRENT_WEDDING.budget || 0) : 0; + const exceeded = predefined > 0 && total > predefined; + + return { venueCost, bandCost, photoCost, total, predefined, exceeded, over_by: exceeded ? +(total - predefined).toFixed(2) : 0 }; +} + +// Check and show alert if budget is exceeded — call after any operation that changes cost/guests +function checkBudgetAndAlert() { + if (!CURRENT_WEDDING || !CURRENT_WEDDING.budget) return; + const s = calcBudgetSpent(); + if (s.exceeded) { + const over = Number(s.over_by).toLocaleString(undefined, { minimumFractionDigits: 2, maximumFractionDigits: 2 }); + const spent = Number(s.total).toLocaleString(undefined, { minimumFractionDigits: 2, maximumFractionDigits: 2 }); + const predefined = Number(s.predefined).toLocaleString(undefined, { minimumFractionDigits: 2, maximumFractionDigits: 2 }); + showToast(`⚠️ Budget exceeded by $${over}`, 'danger'); + alert(`⚠️ Budget Exceeded!\n\nPredefined budget: $${predefined}\nSpent so far: $${spent}\nOver by: $${over}\n\nBreakdown:\n Venue: $${Number(s.venueCost).toLocaleString()}\n Band: $${Number(s.bandCost).toLocaleString()}\n Photographer: $${Number(s.photoCost).toLocaleString()}`); + } +} // ============================================================= @@ -406,4 +486,7 @@ if (cbR && cbR.ok) CHURCH_BOOKINGS = await cbR.json(); if (attR && attR.ok) ATTENDANCE = await attR.json(); + // Load budget status (predefined vs spent) + const budR = await api('GET', `/api/weddings/${wid}/budget`); + if (budR && budR.ok) BUDGET_STATUS = await budR.json(); } @@ -468,4 +551,7 @@ const rsvpR = await api('GET', `/api/weddings/${wid}/rsvp`); if (rsvpR && rsvpR.ok) RSVPS = await rsvpR.json(); + // Refresh budget status + const budR = await api('GET', `/api/weddings/${wid}/budget`); + if (budR && budR.ok) BUDGET_STATUS = await budR.json(); renderApp(); } @@ -806,6 +892,6 @@
Budget
-
$${w.budget ? (w.budget/1000).toFixed(0)+'k' : '—'}
-
Total budget
+
${w.budget ? '$'+(w.budget/1000).toFixed(0)+'k' : '—'}
+
Predefined budget
@@ -835,4 +921,25 @@
Date${w.date}
Budget${w.budget ? '$'+Number(w.budget).toLocaleString() : 'Not set'}
+ ${(() => { + const s = calcBudgetSpent(); + if (!s.predefined && !s.total) return ''; + const pct = s.predefined > 0 ? Math.min((s.total / s.predefined) * 100, 100) : 0; + const spentFmt = '$' + Number(s.total).toLocaleString(undefined, { minimumFractionDigits: 2, maximumFractionDigits: 2 }); + const barColor = s.exceeded ? 'var(--rose)' : pct > 80 ? '#f59e0b' : '#22c55e'; + return `
+
+ Budget Spent + ${spentFmt}${s.exceeded ? ' ⚠️ Over!' : ''} +
+ ${s.predefined > 0 ? `
+
+
+
+ ${pct.toFixed(0)}% of $${Number(s.predefined).toLocaleString()} used + ${s.exceeded ? ' — over by $'+Number(s.over_by).toLocaleString(undefined,{minimumFractionDigits:2,maximumFractionDigits:2}) : ''} +  ·  Venue $${Number(s.venueCost).toLocaleString()} · Band $${Number(s.bandCost).toLocaleString()} · Photo $${Number(s.photoCost).toLocaleString()} +
` : ''} +
`; + })()}
Notes${w.notes || '—'}
Photographers${PHOTOGRAPHER_BOOKINGS.length} booked
@@ -988,5 +1095,6 @@ showModal('Import Guests from CSV', body, async () => { const sendEmails = document.getElementById('csvSendEmails').checked; - const res = await api('POST', `/api/weddings/${CURRENT_WEDDING.wedding_id}/guests/bulk`, { guests: rows, sendEmails }); + const couple = getCoupleNames(); + const res = await api('POST', `/api/weddings/${CURRENT_WEDDING.wedding_id}/guests/bulk`, { guests: rows, sendEmails, bride_name: couple.bride_name, groom_name: couple.groom_name }); if(res && res.ok){ const d = await res.json(); closeModal(); showToast(`${d.inserted} guests imported.`,'success'); await reload(); } else { const d = await res.json().catch(()=>null); showToast((d&&d.error) || 'Error importing guests.','danger'); } @@ -1095,9 +1203,12 @@ const first = document.getElementById('gFirst').value.trim(); if(!first){ showToast('First name is required.','danger'); return; } + const couple = getCoupleNames(); const res = await api('POST',`/api/weddings/${CURRENT_WEDDING.wedding_id}/guests`,{ first_name: first, last_name: document.getElementById('gLast').value.trim(), email: document.getElementById('gEmail').value.trim(), - role: document.getElementById('gRole').value + role: document.getElementById('gRole').value, + bride_name: couple.bride_name, + groom_name: couple.groom_name }); if(res && res.ok){ @@ -1106,4 +1217,5 @@ showToast(d.emailSent ? 'Guest added & invitation email sent! 📧' : 'Guest added (no email provided).','success'); await reload(); + checkBudgetAndAlert(); } else showToast('Could not add guest.','danger'); } @@ -1279,5 +1391,10 @@ }); if(res && res.ok){ closeModal(); showToast('Guest assigned to table!','success'); await reload(); } - else { const d=await res.json(); showToast(d.error||'Error assigning guest.','danger'); } + else { + const d=await res.json(); + const msg = d.error||'Error assigning guest.'; + showToast(msg,'danger'); + alert(msg); + } } ); @@ -1310,5 +1427,10 @@ }); if(res && res.ok){ closeModal(); showToast('Seating updated!','success'); await reload(); } - else showToast('Error updating seating.','danger'); + else { + const d=await res.json().catch(()=>({})); + const msg = d.error||'Error updating seating.'; + showToast(msg,'danger'); + alert(msg); + } } ); @@ -1384,5 +1506,10 @@ status: 'confirmed' }); - if(res && res.ok){ closeModal(); showToast('Venue booked!','success'); await reload(); } + if(res && res.ok){ + closeModal(); + showToast('Venue booked!','success'); + await reload(); + checkBudgetAndAlert(); + } else { const d=await res.json(); showToast(d.error||'Error booking venue.','danger'); } } @@ -1452,5 +1579,10 @@ status: 'confirmed' }); - if(res && res.ok){ closeModal(); showToast('Band booked!','success'); await reload(); } + if(res && res.ok){ + closeModal(); + showToast('Band booked!','success'); + await reload(); + checkBudgetAndAlert(); + } else { const d=await res.json(); showToast(d.error||'Error booking band.','danger'); } } @@ -1520,5 +1652,10 @@ status: 'confirmed' }); - if(res && res.ok){ closeModal(); showToast('Photographer booked!','success'); await reload(); } + if(res && res.ok){ + closeModal(); + showToast('Photographer booked!','success'); + await reload(); + checkBudgetAndAlert(); + } else { const d=await res.json(); showToast(d.error||'Error booking photographer.','danger'); } } @@ -1671,4 +1808,5 @@ function renderSettingsPage(container){ const u = CURRENT_USER; + const couple = getCoupleNames(); const wrap = document.createElement('div'); wrap.innerHTML = ` @@ -1702,6 +1840,25 @@
+ +
+

💍 Invitation Names

+
+

These names are used on guest invitations

+
+
+
+
+
+ +
`; container.appendChild(wrap); + + wrap.querySelector('#btnSaveCoupleNames').addEventListener('click', () => { + const bride_name = document.getElementById('sBrideName').value.trim(); + const groom_name = document.getElementById('sGroomName').value.trim(); + saveCoupleNames(bride_name, groom_name); + showToast('Invitation names saved on this device!','success'); + }); wrap.querySelector('#btnSaveProfile').addEventListener('click', async () => {