{ "app": "Gigora", "version": 1, "exported_at": "2026-10-31T20:35:25+00:00", "tables": { "admins": [ { "id": 2, "name": "Gigora Demo Manager", "email": "demo@gigora.local", "password_hash": "$2y$10$u.38fBEifWC1cPyjCTY4ouSq9\/McJCC2CHIthnpMUCgsHUj4khLeS", "role": "agency_manager", "default_charge_rate_pence": 0, "default_pay_rate_pence": 0, "calendar_colour": "#116a7b", "terms_accepted_version": null, "terms_accepted_at": null, "terms_accepted_ip": null, "active": 1, "created_at": "2026-05-06 11:39:51", "skills": "" }, { "id": 41, "name": "Maya Stone", "email": "maya.demo@gigora.local", "password_hash": "$2y$10$tftVz2gpTJRBwdW4gLS4\/eyj2WIZsURPQWyl02QVvGp3gVtfhkA4i", "role": "dj", "default_charge_rate_pence": 0, "default_pay_rate_pence": 0, "calendar_colour": "#116a7b", "terms_accepted_version": null, "terms_accepted_at": null, "terms_accepted_ip": null, "active": 1, "created_at": "2026-10-31 18:55:04", "skills": "" }, { "id": 42, "name": "Leo Grant", "email": "leo.demo@gigora.local", "password_hash": "$2y$10$te7wMjFUAojLw0iksFozSO1xphwyDAeGiQJih4k\/0CHyckDx2nYsq", "role": "dj", "default_charge_rate_pence": 0, "default_pay_rate_pence": 0, "calendar_colour": "#116a7b", "terms_accepted_version": null, "terms_accepted_at": null, "terms_accepted_ip": null, "active": 1, "created_at": "2026-10-31 18:55:04", "skills": "" } ], "venues": [ { "id": 1, "name": "Willowmere Hall", "address": "12 Fictional Lane, Exampletown EX1 1AA", "map_url": "", "latitude": null, "longitude": null, "created_at": "2026-10-31 18:55:04" }, { "id": 2, "name": "The Crescent Suite", "address": "8 Placeholder Avenue, Demo City DC2 2BB", "map_url": "", "latitude": null, "longitude": null, "created_at": "2026-10-31 18:55:04" }, { "id": 3, "name": "Neon Loft", "address": "Unit 5, Sample Yard, Mockford MK3 3CC", "map_url": "", "latitude": null, "longitude": null, "created_at": "2026-10-31 18:55:04" }, { "id": 4, "name": "Oakridge Barn", "address": "44 Test Valley Road, Fableton FB4 4DD", "map_url": "", "latitude": null, "longitude": null, "created_at": "2026-10-31 18:55:04" } ], "packages": [ { "id": 1, "name": "Essential", "description": "Core evening DJ coverage with planning portal.", "price_pence": 95000, "is_agency_package": 0, "agency_commission_percent": "0.00", "active": 1 }, { "id": 2, "name": "Signature Wedding", "description": "Full wedding package with ceremony support and evening party.", "price_pence": 145000, "is_agency_package": 0, "agency_commission_percent": "0.00", "active": 1 }, { "id": 3, "name": "Agency Club Night", "description": "Agency booking with DJ commission tracking.", "price_pence": 80000, "is_agency_package": 1, "agency_commission_percent": "20.00", "active": 1 } ], "upsells": [ { "id": 1, "name": "Ceremony audio", "description": "Microphones and music playback for ceremony.", "price_pence": 15000, "active": 1, "required_skill": "" }, { "id": 2, "name": "Confetti cannon moment", "description": "Two cannons for a first dance or room reveal.", "price_pence": 8000, "active": 1, "required_skill": "" }, { "id": 3, "name": "Extra hour", "description": "Additional performance hour.", "price_pence": 12500, "active": 1, "required_skill": "" }, { "id": 4, "name": "Mood lighting", "description": "Wireless uplighters for the room.", "price_pence": 18000, "active": 1, "required_skill": "" } ], "bookings": [ { "id": 1, "client_name": "enc:v1:ueFRrrVqHXd8+soE6bviPXOXJhBg\/BZws3KfYEFgN5RNwUXC8kgHhkECGw==", "client_email": "enc:v1:NiXQDLipJ14wK93T\/2lW0rKpBVjh5BWQ5aE5OzU3bBC6qz6w+YkDsEDLeN\/mC4hPW\/IsXRZw4A==", "client_phone": "enc:v1:H2R2NPs2NpeXqsPfKOs3oPb1FEa5jTT8cGPOCfeWBBvcfd7xZ1fPPQ9MgA==", "client_address": null, "search_index": "alex and jordan alex.jordan@example.invalid +44 7000 000101 willowmere hall 12 fictional lane exampletown ex1 1aa signature wedding final balance due elegant wedding with ceremony support and a high-energy evening finish. 2026-11-03 03\/11\/2026 tuesday 3rd november 2026 16 00 00 00 00 00", "event_date": "2026-11-03", "start_time": "16:00:00", "finish_time": "00:00:00", "venue_id": 1, "package_id": 2, "assigned_admin_id": 41, "dj_response_status": "pending", "dj_responded_at": null, "dj_pay_pence": 0, "residency_id": null, "external_source_instance": null, "external_source_reference": null, "external_source_business": null, "external_role_label": null, "external_offer_payload": null, "external_accepted_at": null, "external_declined_at": null, "custom_price_pence": 0, "status": "final_balance_due", "notes": "Elegant wedding with ceremony support and a high-energy evening finish.", "first_dance": "", "meeting_url": "", "couple_notes": "Demo planning notes for Alex and Jordan.", "client_token": "877b684a385739cbe4a18a1e62a76ad67300568abc9ea8b4", "package_price_pence": 145000, "upsell_total_pence": 33000, "total_pence": 178000, "agency_fee_pence": 0, "net_pence": 178000, "deposit_required": 1, "deposit_override_pence": null, "deposit_paid": 0, "balance_paid": 0, "invoice_terms": "default", "invoice_due_days": 14, "deposit_pence": 25000, "balance_pence": 153000, "spotify_playlist_url_day": null, "spotify_playlist_url_evening": null, "spotify_playlist_url_general": "", "spotify_playlist_url_do_not_play": "", "spotify_playlist_url_essential": "", "spotify_playlist_url_requests": null, "spotify_error": null, "contract_body_snapshot": "Booking Contract\n\nClient: Alex and Jordan\nAddress: \nEvent date: Tuesday 3rd November 2026\nStart time: 16:00\nFinish time: 00:00\nVenue: Willowmere Hall\nTotal: \u00a31,780.00\nDeposit: \u00a3250.00\nBalance: \u00a31,530.00\n\nBy typing your name and drawing your signature in the client portal, you confirm acceptance of these terms.", "contract_generated_at": "2026-10-31 19:45:38", "contract_template_id": 1, "quote_accepted_at": null, "quote_accepted_ip": null, "quote_accepted_document_id": null, "signed_name": null, "signed_signature_data": null, "signed_at": null, "signed_ip": null, "created_at": "2026-10-31 18:55:04", "updated_at": "2026-10-31 19:45:38", "assigned_collaborator_id": null }, { "id": 2, "client_name": "enc:v1:C8bO0iOHnrSXNbMXpWV\/la\/9VfPfw8chSgG03ld5aygKnIs9yy6I1cTGGps=", "client_email": "enc:v1:haCA76rX7LlbJLKD7YhudH13KwTuerNT8HRehKy98WEH0t9iw49mGjteOXLuFd1fwkpIkdqqlJ0=", "client_phone": "enc:v1:mkWETEXOndY6RubBJGSKjxzdL6wKiWzYKFoyEtt2PgNY7MZjw2bEoFdq3A==", "client_address": null, "search_index": "casey and morgan casey.morgan@example.invalid +44 7000 000102 the crescent suite 8 placeholder avenue demo city dc2 2bb signature wedding deposit paid client loves indie motown and modern pop. avoid heavy dance early evening. 2026-11-18 18\/11\/2026 wednesday 18th november 2026 18 30 00 01 00 00", "event_date": "2026-11-18", "start_time": "18:30:00", "finish_time": "01:00:00", "venue_id": 2, "package_id": 2, "assigned_admin_id": 42, "dj_response_status": "pending", "dj_responded_at": null, "dj_pay_pence": 0, "residency_id": null, "external_source_instance": null, "external_source_reference": null, "external_source_business": null, "external_role_label": null, "external_offer_payload": null, "external_accepted_at": null, "external_declined_at": null, "custom_price_pence": 0, "status": "deposit_paid", "notes": "Client loves indie, Motown, and modern pop. Avoid heavy dance early evening.", "first_dance": "", "meeting_url": "", "couple_notes": "Demo planning notes for Casey and Morgan.", "client_token": "bf66d424ef2e3413b3636a14910127ec9086dbc950053137", "package_price_pence": 145000, "upsell_total_pence": 8000, "total_pence": 153000, "agency_fee_pence": 0, "net_pence": 153000, "deposit_required": 1, "deposit_override_pence": null, "deposit_paid": 0, "balance_paid": 0, "invoice_terms": "default", "invoice_due_days": 14, "deposit_pence": 25000, "balance_pence": 128000, "spotify_playlist_url_day": null, "spotify_playlist_url_evening": null, "spotify_playlist_url_general": "", "spotify_playlist_url_do_not_play": "", "spotify_playlist_url_essential": "", "spotify_playlist_url_requests": null, "spotify_error": null, "contract_body_snapshot": "Booking Contract\n\nClient: Casey and Morgan\nAddress: \nEvent date: Wednesday 18th November 2026\nStart time: 18:30\nFinish time: 01:00\nVenue: The Crescent Suite\nTotal: \u00a31,530.00\nDeposit: \u00a3250.00\nBalance: \u00a31,280.00\n\nBy typing your name and drawing your signature in the client portal, you confirm acceptance of these terms.", "contract_generated_at": "2026-10-31 19:45:14", "contract_template_id": 1, "quote_accepted_at": null, "quote_accepted_ip": null, "quote_accepted_document_id": null, "signed_name": null, "signed_signature_data": null, "signed_at": null, "signed_ip": null, "created_at": "2026-10-31 18:55:04", "updated_at": "2026-10-31 19:45:14", "assigned_collaborator_id": null }, { "id": 3, "client_name": "enc:v1:Iy2oiO26rQjkgZMAeRl7faP1zmpvUWti4Om46PcUQWSx\/SKvWXk2wXfliHqveg6wnw==", "client_email": "enc:v1:28+YOykfbwnjRoKQLssIqCCex14L70CGir35ucNsIzvVPc\/7iU30Mq\/Z2w\/OYl8hVeA=", "client_phone": "enc:v1:cmdu5FEVyYk2P2LkvLTu9Td9sqfVG0ggMesD8kgNJuy67m+K83OjPJrBgg==", "client_address": null, "search_index": "northside social club events@example.invalid +44 7000 000103 neon loft unit 5 sample yard mockford mk3 3cc agency club night confirmed monthly club residency demo booking. 2026-11-25 25\/11\/2026 wednesday 25th november 2026 21 00 00 02 00 00", "event_date": "2026-11-25", "start_time": "21:00:00", "finish_time": "02:00:00", "venue_id": 3, "package_id": 3, "assigned_admin_id": 41, "dj_response_status": "pending", "dj_responded_at": null, "dj_pay_pence": 0, "residency_id": null, "external_source_instance": null, "external_source_reference": null, "external_source_business": null, "external_role_label": null, "external_offer_payload": null, "external_accepted_at": null, "external_declined_at": null, "custom_price_pence": 0, "status": "confirmed", "notes": "Monthly club residency demo booking.", "first_dance": "", "meeting_url": "", "couple_notes": "Demo planning notes for Northside Social Club.", "client_token": "1a05b364297034467312f047f8336667e1592b7f05d83a7b", "package_price_pence": 80000, "upsell_total_pence": 0, "total_pence": 80000, "agency_fee_pence": 16000, "net_pence": 64000, "deposit_required": 1, "deposit_override_pence": null, "deposit_paid": 0, "balance_paid": 0, "invoice_terms": "default", "invoice_due_days": 14, "deposit_pence": 25000, "balance_pence": 80000, "spotify_playlist_url_day": null, "spotify_playlist_url_evening": null, "spotify_playlist_url_general": "", "spotify_playlist_url_do_not_play": "", "spotify_playlist_url_essential": "", "spotify_playlist_url_requests": null, "spotify_error": null, "contract_body_snapshot": null, "contract_generated_at": null, "contract_template_id": null, "quote_accepted_at": null, "quote_accepted_ip": null, "quote_accepted_document_id": null, "signed_name": null, "signed_signature_data": null, "signed_at": null, "signed_ip": null, "created_at": "2026-10-31 18:55:04", "updated_at": "2026-10-31 18:55:04", "assigned_collaborator_id": null }, { "id": 4, "client_name": "enc:v1:Z2LQwBdM0nUBy\/eEr1KiO71I0ai0qhsWyNldBHzJc9C3G9mASh21TAh5GRI=", "client_email": "enc:v1:whIfdXDqyTfv+AY5bd1ceTyefRIKE+jemxOfJk479qrNgejkAYv0gVSsAinc3T+WcUb3tpy9kKM=", "client_phone": "enc:v1:06\/UymBXli1yrAbsZGiiCr1496lKAIjIrGv\/deAELyNpvs7uDf9BUjQmPA==", "client_address": null, "search_index": "taylor and riley taylor.riley@example.invalid +44 7000 000104 oakridge barn 44 test valley road fableton fb4 4dd essential lead lead enquiry for a summer wedding. quote sent awaiting confirmation. 2026-12-15 15\/12\/2026 tuesday 15th december 2026 15 00 00 00 30 00", "event_date": "2026-12-15", "start_time": "15:00:00", "finish_time": "00:30:00", "venue_id": 4, "package_id": 1, "assigned_admin_id": 42, "dj_response_status": "pending", "dj_responded_at": null, "dj_pay_pence": 0, "residency_id": null, "external_source_instance": null, "external_source_reference": null, "external_source_business": null, "external_role_label": null, "external_offer_payload": null, "external_accepted_at": null, "external_declined_at": null, "custom_price_pence": 0, "status": "lead", "notes": "Lead enquiry for a summer wedding. Quote sent, awaiting confirmation.", "first_dance": "", "meeting_url": "", "couple_notes": "Demo planning notes for Taylor and Riley.", "client_token": "491074424da7695fef2e9d6f1bc436be341a69d9b93d7c9d", "package_price_pence": 95000, "upsell_total_pence": 12500, "total_pence": 107500, "agency_fee_pence": 0, "net_pence": 107500, "deposit_required": 1, "deposit_override_pence": null, "deposit_paid": 0, "balance_paid": 0, "invoice_terms": "default", "invoice_due_days": 14, "deposit_pence": 25000, "balance_pence": 107500, "spotify_playlist_url_day": null, "spotify_playlist_url_evening": null, "spotify_playlist_url_general": "", "spotify_playlist_url_do_not_play": "", "spotify_playlist_url_essential": "", "spotify_playlist_url_requests": null, "spotify_error": null, "contract_body_snapshot": null, "contract_generated_at": null, "contract_template_id": null, "quote_accepted_at": null, "quote_accepted_ip": null, "quote_accepted_document_id": null, "signed_name": null, "signed_signature_data": null, "signed_at": null, "signed_ip": null, "created_at": "2026-10-31 18:55:04", "updated_at": "2026-10-31 18:55:04", "assigned_collaborator_id": null }, { "id": 5, "client_name": "enc:v1:t0uKD8NGuHTuOoQSDQBvz4VpUP2DR6HZYJ4\/HQDlVpyui97q9ACCwphoD0UfQgDG", "client_email": "enc:v1:4m1yxhW\/vhK0PBxlcySrld7T2cktEKLlEGJfCrjqS4d8dkosUvvUujd0\/ek7\/BhMMHE=", "client_phone": "enc:v1:VCbj9OhLzOcRmxm3TQIsfvjNKuvKFgzXfSRn7OYq2u6nPm0zoL+Zjuwe7w==", "client_address": null, "search_index": "example awards night awards@example.invalid +44 7000 000105 the crescent suite 8 placeholder avenue demo city dc2 2bb final balance paid completed corporate event with custom amount. 2026-10-24 24\/10\/2026 saturday 24th october 2026 19 00 00 23 30 00", "event_date": "2026-10-24", "start_time": "19:00:00", "finish_time": "23:30:00", "venue_id": 2, "package_id": null, "assigned_admin_id": 2, "dj_response_status": "pending", "dj_responded_at": null, "dj_pay_pence": 0, "residency_id": null, "external_source_instance": null, "external_source_reference": null, "external_source_business": null, "external_role_label": null, "external_offer_payload": null, "external_accepted_at": null, "external_declined_at": null, "custom_price_pence": 120000, "status": "final_balance_paid", "notes": "Completed corporate event with custom amount.", "first_dance": "", "meeting_url": "", "couple_notes": "Demo planning notes for Example Awards Night.", "client_token": "6231c6edacba5124850222dae1e43e679f872932289e5b15", "package_price_pence": 120000, "upsell_total_pence": 18000, "total_pence": 138000, "agency_fee_pence": 0, "net_pence": 138000, "deposit_required": 1, "deposit_override_pence": null, "deposit_paid": 0, "balance_paid": 0, "invoice_terms": "default", "invoice_due_days": 14, "deposit_pence": 25000, "balance_pence": 0, "spotify_playlist_url_day": null, "spotify_playlist_url_evening": null, "spotify_playlist_url_general": "", "spotify_playlist_url_do_not_play": "", "spotify_playlist_url_essential": "", "spotify_playlist_url_requests": null, "spotify_error": null, "contract_body_snapshot": null, "contract_generated_at": null, "contract_template_id": null, "quote_accepted_at": null, "quote_accepted_ip": null, "quote_accepted_document_id": null, "signed_name": null, "signed_signature_data": null, "signed_at": null, "signed_ip": null, "created_at": "2026-10-31 18:55:04", "updated_at": "2026-10-31 18:55:04", "assigned_collaborator_id": null } ], "booking_upsells": [ { "booking_id": 1, "upsell_id": 1 }, { "booking_id": 1, "upsell_id": 4 }, { "booking_id": 2, "upsell_id": 2 }, { "booking_id": 4, "upsell_id": 3 }, { "booking_id": 5, "upsell_id": 4 } ], "booking_prep_items": [ { "id": 1, "booking_id": 3, "item_label": "Laptop charged", "completed_at": null, "created_at": "2026-05-11 03:10:30" }, { "id": 2, "booking_id": 3, "item_label": "Controller packed", "completed_at": null, "created_at": "2026-05-11 03:10:30" }, { "id": 3, "booking_id": 3, "item_label": "Power cables packed", "completed_at": null, "created_at": "2026-05-11 03:10:30" }, { "id": 4, "booking_id": 3, "item_label": "Backup music ready", "completed_at": null, "created_at": "2026-05-11 03:10:30" }, { "id": 5, "booking_id": 3, "item_label": "Speaker\/PA checked", "completed_at": null, "created_at": "2026-05-11 03:10:30" }, { "id": 6, "booking_id": 3, "item_label": "Lighting checked", "completed_at": null, "created_at": "2026-05-11 03:10:30" }, { "id": 7, "booking_id": 3, "item_label": "Microphone checked", "completed_at": null, "created_at": "2026-05-11 03:10:30" }, { "id": 8, "booking_id": 3, "item_label": "Arrive with setup time confirmed", "completed_at": null, "created_at": "2026-05-11 03:10:30" }, { "id": 9, "booking_id": 1, "item_label": "Laptop charged", "completed_at": null, "created_at": "2026-05-11 03:11:24" }, { "id": 10, "booking_id": 1, "item_label": "Controller packed", "completed_at": null, "created_at": "2026-05-11 03:11:24" }, { "id": 11, "booking_id": 1, "item_label": "Power cables packed", "completed_at": null, "created_at": "2026-05-11 03:11:24" }, { "id": 12, "booking_id": 1, "item_label": "Backup music ready", "completed_at": null, "created_at": "2026-05-11 03:11:24" }, { "id": 13, "booking_id": 1, "item_label": "Speaker\/PA checked", "completed_at": null, "created_at": "2026-05-11 03:11:24" }, { "id": 14, "booking_id": 1, "item_label": "Lighting checked", "completed_at": null, "created_at": "2026-05-11 03:11:24" }, { "id": 15, "booking_id": 1, "item_label": "Microphone checked", "completed_at": null, "created_at": "2026-05-11 03:11:24" }, { "id": 16, "booking_id": 1, "item_label": "Arrive with setup time confirmed", "completed_at": null, "created_at": "2026-05-11 03:11:24" }, { "id": 17, "booking_id": 2, "item_label": "Laptop charged", "completed_at": null, "created_at": "2026-05-11 03:12:15" }, { "id": 18, "booking_id": 2, "item_label": "Controller packed", "completed_at": null, "created_at": "2026-05-11 03:12:15" }, { "id": 19, "booking_id": 2, "item_label": "Power cables packed", "completed_at": null, "created_at": "2026-05-11 03:12:15" }, { "id": 20, "booking_id": 2, "item_label": "Backup music ready", "completed_at": null, "created_at": "2026-05-11 03:12:15" }, { "id": 21, "booking_id": 2, "item_label": "Speaker\/PA checked", "completed_at": null, "created_at": "2026-05-11 03:12:15" }, { "id": 22, "booking_id": 2, "item_label": "Lighting checked", "completed_at": null, "created_at": "2026-05-11 03:12:15" }, { "id": 23, "booking_id": 2, "item_label": "Microphone checked", "completed_at": null, "created_at": "2026-05-11 03:12:15" }, { "id": 24, "booking_id": 2, "item_label": "Arrive with setup time confirmed", "completed_at": null, "created_at": "2026-05-11 03:12:15" }, { "id": 25, "booking_id": 5, "item_label": "Laptop charged", "completed_at": null, "created_at": "2026-05-11 03:13:04" }, { "id": 26, "booking_id": 5, "item_label": "Controller packed", "completed_at": null, "created_at": "2026-05-11 03:13:04" }, { "id": 27, "booking_id": 5, "item_label": "Power cables packed", "completed_at": null, "created_at": "2026-05-11 03:13:04" }, { "id": 28, "booking_id": 5, "item_label": "Backup music ready", "completed_at": null, "created_at": "2026-05-11 03:13:04" }, { "id": 29, "booking_id": 5, "item_label": "Speaker\/PA checked", "completed_at": null, "created_at": "2026-05-11 03:13:04" }, { "id": 30, "booking_id": 5, "item_label": "Lighting checked", "completed_at": null, "created_at": "2026-05-11 03:13:04" }, { "id": 31, "booking_id": 5, "item_label": "Microphone checked", "completed_at": null, "created_at": "2026-05-11 03:13:04" }, { "id": 32, "booking_id": 5, "item_label": "Arrive with setup time confirmed", "completed_at": null, "created_at": "2026-05-11 03:13:04" }, { "id": 33, "booking_id": 4, "item_label": "Laptop charged", "completed_at": null, "created_at": "2026-05-11 03:19:39" }, { "id": 34, "booking_id": 4, "item_label": "Controller packed", "completed_at": null, "created_at": "2026-05-11 03:19:39" }, { "id": 35, "booking_id": 4, "item_label": "Power cables packed", "completed_at": null, "created_at": "2026-05-11 03:19:39" }, { "id": 36, "booking_id": 4, "item_label": "Backup music ready", "completed_at": null, "created_at": "2026-05-11 03:19:39" }, { "id": 37, "booking_id": 4, "item_label": "Speaker\/PA checked", "completed_at": null, "created_at": "2026-05-11 03:19:39" }, { "id": 38, "booking_id": 4, "item_label": "Lighting checked", "completed_at": null, "created_at": "2026-05-11 03:19:39" }, { "id": 39, "booking_id": 4, "item_label": "Microphone checked", "completed_at": null, "created_at": "2026-05-11 03:19:39" }, { "id": 40, "booking_id": 4, "item_label": "Arrive with setup time confirmed", "completed_at": null, "created_at": "2026-05-11 03:19:39" }, { "id": 1345, "booking_id": 9, "item_label": "Laptop charged", "completed_at": null, "created_at": "2026-10-23 21:28:54" }, { "id": 1346, "booking_id": 9, "item_label": "Controller packed", "completed_at": null, "created_at": "2026-10-23 21:28:54" }, { "id": 1347, "booking_id": 9, "item_label": "Power cables packed", "completed_at": null, "created_at": "2026-10-23 21:28:54" }, { "id": 1348, "booking_id": 9, "item_label": "Backup music ready", "completed_at": null, "created_at": "2026-10-23 21:28:54" }, { "id": 1349, "booking_id": 9, "item_label": "Speaker\/PA checked", "completed_at": null, "created_at": "2026-10-23 21:28:54" }, { "id": 1350, "booking_id": 9, "item_label": "Lighting checked", "completed_at": null, "created_at": "2026-10-23 21:28:54" }, { "id": 1351, "booking_id": 9, "item_label": "Microphone checked", "completed_at": null, "created_at": "2026-10-23 21:28:54" }, { "id": 1352, "booking_id": 9, "item_label": "Arrive with setup time confirmed", "completed_at": null, "created_at": "2026-10-23 21:28:54" }, { "id": 1425, "booking_id": 10, "item_label": "Laptop charged", "completed_at": null, "created_at": "2026-10-27 23:19:43" }, { "id": 1426, "booking_id": 10, "item_label": "Controller packed", "completed_at": null, "created_at": "2026-10-27 23:19:43" }, { "id": 1427, "booking_id": 10, "item_label": "Power cables packed", "completed_at": null, "created_at": "2026-10-27 23:19:43" }, { "id": 1428, "booking_id": 10, "item_label": "Backup music ready", "completed_at": null, "created_at": "2026-10-27 23:19:43" }, { "id": 1429, "booking_id": 10, "item_label": "Speaker\/PA checked", "completed_at": null, "created_at": "2026-10-27 23:19:43" }, { "id": 1430, "booking_id": 10, "item_label": "Lighting checked", "completed_at": null, "created_at": "2026-10-27 23:19:43" }, { "id": 1431, "booking_id": 10, "item_label": "Microphone checked", "completed_at": null, "created_at": "2026-10-27 23:19:43" }, { "id": 1432, "booking_id": 10, "item_label": "Arrive with setup time confirmed", "completed_at": null, "created_at": "2026-10-27 23:19:43" }, { "id": 1433, "booking_id": 12, "item_label": "Laptop charged", "completed_at": null, "created_at": "2026-10-27 23:19:44" }, { "id": 1434, "booking_id": 12, "item_label": "Controller packed", "completed_at": null, "created_at": "2026-10-27 23:19:44" }, { "id": 1435, "booking_id": 12, "item_label": "Power cables packed", "completed_at": null, "created_at": "2026-10-27 23:19:44" }, { "id": 1436, "booking_id": 12, "item_label": "Backup music ready", "completed_at": null, "created_at": "2026-10-27 23:19:44" }, { "id": 1437, "booking_id": 12, "item_label": "Speaker\/PA checked", "completed_at": null, "created_at": "2026-10-27 23:19:44" }, { "id": 1438, "booking_id": 12, "item_label": "Lighting checked", "completed_at": null, "created_at": "2026-10-27 23:19:44" }, { "id": 1439, "booking_id": 12, "item_label": "Microphone checked", "completed_at": null, "created_at": "2026-10-27 23:19:44" }, { "id": 1440, "booking_id": 12, "item_label": "Arrive with setup time confirmed", "completed_at": null, "created_at": "2026-10-27 23:19:44" }, { "id": 1449, "booking_id": 11, "item_label": "Laptop charged", "completed_at": null, "created_at": "2026-10-27 23:31:25" }, { "id": 1450, "booking_id": 11, "item_label": "Controller packed", "completed_at": null, "created_at": "2026-10-27 23:31:25" }, { "id": 1451, "booking_id": 11, "item_label": "Power cables packed", "completed_at": null, "created_at": "2026-10-27 23:31:25" }, { "id": 1452, "booking_id": 11, "item_label": "Backup music ready", "completed_at": null, "created_at": "2026-10-27 23:31:25" }, { "id": 1453, "booking_id": 11, "item_label": "Speaker\/PA checked", "completed_at": null, "created_at": "2026-10-27 23:31:25" }, { "id": 1454, "booking_id": 11, "item_label": "Lighting checked", "completed_at": null, "created_at": "2026-10-27 23:31:25" }, { "id": 1455, "booking_id": 11, "item_label": "Microphone checked", "completed_at": null, "created_at": "2026-10-27 23:31:25" }, { "id": 1456, "booking_id": 11, "item_label": "Arrive with setup time confirmed", "completed_at": null, "created_at": "2026-10-27 23:31:25" }, { "id": 1457, "booking_id": 13, "item_label": "Laptop charged", "completed_at": null, "created_at": "2026-10-27 23:34:23" }, { "id": 1458, "booking_id": 13, "item_label": "Controller packed", "completed_at": null, "created_at": "2026-10-27 23:34:23" }, { "id": 1459, "booking_id": 13, "item_label": "Power cables packed", "completed_at": null, "created_at": "2026-10-27 23:34:23" }, { "id": 1460, "booking_id": 13, "item_label": "Backup music ready", "completed_at": null, "created_at": "2026-10-27 23:34:23" }, { "id": 1461, "booking_id": 13, "item_label": "Speaker\/PA checked", "completed_at": null, "created_at": "2026-10-27 23:34:23" }, { "id": 1462, "booking_id": 13, "item_label": "Lighting checked", "completed_at": null, "created_at": "2026-10-27 23:34:23" }, { "id": 1463, "booking_id": 13, "item_label": "Microphone checked", "completed_at": null, "created_at": "2026-10-27 23:34:23" }, { "id": 1464, "booking_id": 13, "item_label": "Arrive with setup time confirmed", "completed_at": null, "created_at": "2026-10-27 23:34:23" }, { "id": 1545, "booking_id": 7, "item_label": "Laptop charged", "completed_at": null, "created_at": "2026-10-28 01:55:18" }, { "id": 1546, "booking_id": 7, "item_label": "Controller packed", "completed_at": null, "created_at": "2026-10-28 01:55:18" }, { "id": 1547, "booking_id": 7, "item_label": "Power cables packed", "completed_at": null, "created_at": "2026-10-28 01:55:18" }, { "id": 1548, "booking_id": 7, "item_label": "Backup music ready", "completed_at": null, "created_at": "2026-10-28 01:55:18" }, { "id": 1549, "booking_id": 7, "item_label": "Speaker\/PA checked", "completed_at": null, "created_at": "2026-10-28 01:55:18" }, { "id": 1550, "booking_id": 7, "item_label": "Lighting checked", "completed_at": null, "created_at": "2026-10-28 01:55:18" }, { "id": 1551, "booking_id": 7, "item_label": "Microphone checked", "completed_at": null, "created_at": "2026-10-28 01:55:18" }, { "id": 1552, "booking_id": 7, "item_label": "Arrive with setup time confirmed", "completed_at": null, "created_at": "2026-10-28 01:55:18" } ], "residencies": [ { "id": 1, "title": "Neon Fridays", "venue_id": 3, "assigned_admin_id": 41, "package_id": 3, "custom_price_pence": 0, "start_date": "2026-10-31", "end_date": "2027-01-23", "day_of_week": 5, "start_time": "21:00:00", "finish_time": "02:00:00", "status": "confirmed", "notes": "Demo recurring club residency.", "active": 1, "created_at": "2026-10-31 18:55:04" } ], "calendar_events": [ { "id": 1, "booking_id": 1, "event_type": "playlisting_meeting", "title": "Playlisting call - Alex and Jordan", "starts_at": "2026-11-01 19:00:00", "ends_at": "2026-11-01 19:30:00", "assigned_admin_id": 41, "notify_24h": 1, "notify_minutes": 1440, "notes": "Confirm essentials and do-not-play list.", "created_at": "2026-10-31 18:55:04" }, { "id": 2, "booking_id": 4, "event_type": "selling_meeting", "title": "Selling meeting - Taylor and Riley", "starts_at": "2026-11-02 18:30:00", "ends_at": "2026-11-02 19:00:00", "assigned_admin_id": 42, "notify_24h": 1, "notify_minutes": 60, "notes": "Talk through package options.", "created_at": "2026-10-31 18:55:04" } ], "calendar_shares": [], "external_collaborators": [], "booking_collaborators": [], "document_templates": [ { "id": 1, "title": "Standard contract", "document_type": "contract", "body": "Booking Contract\n\nClient: {{client_name}}\nAddress: {{client_address}}\nEvent date: {{event_date}}\nStart time: {{start_time}}\nFinish time: {{finish_time}}\nVenue: {{venue}}\nTotal: {{total}}\nDeposit: {{deposit}}\nBalance: {{balance}}\n\nBy typing your name and drawing your signature in the client portal, you confirm acceptance of these terms.", "active": 1, "created_at": "2026-05-06 11:38:00", "updated_at": "2026-05-06 11:38:00" }, { "id": 2, "title": "Quote", "document_type": "quote", "body": "Quote\n\nClient: {{client_name}}\nAddress: {{client_address}}\nEvent date: {{event_date}}\nPackage: {{package}}\nTotal: {{total}}\nDeposit: {{deposit}}\nBalance: {{balance}}", "active": 1, "created_at": "2026-05-06 11:38:00", "updated_at": "2026-05-06 11:38:00" }, { "id": 3, "title": "Order of the Day", "document_type": "order_of_day", "body": "Order of the Day\n\n12:00 Supplier access \/ setup\n14:00 Guests arrive\n15:00 Ceremony \/ main event\n18:00 Evening room ready\n19:30 First dance \/ playlist\n00:00 Finish and pack down", "active": 1, "created_at": "2026-05-06 11:38:00", "updated_at": "2026-05-06 11:38:00" }, { "id": 4, "title": "Invoice", "document_type": "invoice", "body": "Invoice\n\n{{business_name}}\n{{business_address}}\n\nBill to: {{client_name}}\n{{client_address}}\nEmail: {{client_email}}\nEvent date: {{event_date}}\nVenue: {{venue}}\n\nPackage: {{package}}\nTotal: {{total}}\nDeposit: {{deposit}}\nBalance due: {{balance}}\n\nPayment terms\n{{payment_terms}}\n\nBank details\n{{bank_details}}", "active": 1, "created_at": "2026-05-06 11:38:00", "updated_at": "2026-05-06 11:38:00" } ], "documents": [ { "id": 1, "booking_id": 1, "template_id": 2, "title": "Quote for Alex and Jordan", "document_type": "quote", "invoice_kind": null, "invoice_amount_pence": null, "invoice_due_date": null, "payment_status": "unpaid", "paid_at": null, "body_snapshot": "Quote for Alex and Jordan\n\nThis is demo document content.", "file_path": null, "original_filename": null, "mime_type": null, "created_at": "2026-10-31 18:55:04" }, { "id": 2, "booking_id": 1, "template_id": 4, "title": "Invoice for Alex and Jordan", "document_type": "invoice", "invoice_kind": null, "invoice_amount_pence": null, "invoice_due_date": null, "payment_status": "unpaid", "paid_at": null, "body_snapshot": "Invoice for Alex and Jordan\n\nThis is demo document content.", "file_path": null, "original_filename": null, "mime_type": null, "created_at": "2026-10-31 18:55:04" }, { "id": 3, "booking_id": 2, "template_id": 1, "title": "Contract for Casey and Morgan", "document_type": "contract", "invoice_kind": null, "invoice_amount_pence": null, "invoice_due_date": null, "payment_status": "unpaid", "paid_at": null, "body_snapshot": "Contract for Casey and Morgan\n\nThis is demo document content.", "file_path": null, "original_filename": null, "mime_type": null, "created_at": "2026-10-31 18:55:04" }, { "id": 4, "booking_id": 3, "template_id": 4, "title": "Invoice for Northside Social Club", "document_type": "invoice", "invoice_kind": null, "invoice_amount_pence": null, "invoice_due_date": null, "payment_status": "unpaid", "paid_at": null, "body_snapshot": "Invoice for Northside Social Club\n\nThis is demo document content.", "file_path": null, "original_filename": null, "mime_type": null, "created_at": "2026-10-31 18:55:04" }, { "id": 5, "booking_id": 2, "template_id": 1, "title": "Signed contract \u00b7 Standard contract", "document_type": "contract", "invoice_kind": null, "invoice_amount_pence": null, "invoice_due_date": null, "payment_status": "unpaid", "paid_at": null, "body_snapshot": "Booking Contract\n\nClient: Casey and Morgan\nAddress: \nEvent date: Wednesday 18th November 2026\nStart time: 18:30\nFinish time: 01:00\nVenue: The Crescent Suite\nTotal: \u00a31,530.00\nDeposit: \u00a3250.00\nBalance: \u00a31,280.00\n\nBy typing your name and drawing your signature in the client portal, you confirm acceptance of these terms.", "file_path": null, "original_filename": null, "mime_type": null, "created_at": "2026-10-31 19:45:14" }, { "id": 6, "booking_id": 1, "template_id": 1, "title": "Signed contract \u00b7 Standard contract", "document_type": "contract", "invoice_kind": null, "invoice_amount_pence": null, "invoice_due_date": null, "payment_status": "unpaid", "paid_at": null, "body_snapshot": "Booking Contract\n\nClient: Alex and Jordan\nAddress: \nEvent date: Tuesday 3rd November 2026\nStart time: 16:00\nFinish time: 00:00\nVenue: Willowmere Hall\nTotal: \u00a31,780.00\nDeposit: \u00a3250.00\nBalance: \u00a31,530.00\n\nBy typing your name and drawing your signature in the client portal, you confirm acceptance of these terms.", "file_path": null, "original_filename": null, "mime_type": null, "created_at": "2026-10-31 19:45:38" } ], "emails": [], "push_subscriptions": [], "admin_notification_preferences": [], "notification_deliveries": [], "lead_submissions": [], "settings": [ { "name": "app_mode", "value": "agency" }, { "name": "auto_complete_bookings", "value": "0" }, { "name": "auto_complete_delay_days", "value": "1" }, { "name": "auto_complete_last_run_date", "value": "" }, { "name": "bank_account_name", "value": "Gigora Events Demo" }, { "name": "bank_account_number", "value": "12345678" }, { "name": "bank_details", "value": "Account name: Gigora Events Demo\nSort code: 12-34-56\nAccount number: 12345678" }, { "name": "bank_iban", "value": "" }, { "name": "bank_sort_code", "value": "12-34-56" }, { "name": "business_address", "value": "42 Demo House\nSample Street\nPX1 1AA" }, { "name": "business_logo_path", "value": "" }, { "name": "business_name", "value": "Gigora Events Demo" }, { "name": "calendar_full_feed_token", "value": "db65f7cda3a1c94c4b8e37efaaa6ae5bba0e73acb34dcb31" }, { "name": "calendar_share_token", "value": "56159cc3ccdb612d9874ab69971444654b80" }, { "name": "collaboration_api_token", "value": "52200bd5cd2bf091d3e40fe6e4592be41997a6f870bc0d97" }, { "name": "confirmation_email_body", "value": "Hi {{client_name}},\n\nYour booking is confirmed for {{event_date}} at {{venue}}.\n\nStart time: {{start_time}}\nFinish time: {{finish_time}}\nTotal: {{total}}\nDeposit: {{deposit}}\nBalance: {{balance}}\n\nYour planning portal is here:\n{{planning_link}}\n\nKind regards,\n{{business_name}}" }, { "name": "confirmation_email_subject", "value": "Booking confirmed for {{event_date}}" }, { "name": "contract_email_body", "value": "Hi {{client_name}},\n\nYour contract is ready to review and sign in your planning portal:\n{{contract_link}}\n\nKind regards,\n{{business_name}}" }, { "name": "contract_email_subject", "value": "Your booking contract" }, { "name": "customer_install", "value": "0" }, { "name": "default_invoice_due_days", "value": "14" }, { "name": "default_invoice_terms", "value": "before_event" }, { "name": "demo_data_seeded", "value": "1" }, { "name": "deposit_fixed_pence", "value": "25000" }, { "name": "deposit_payment_terms", "value": "" }, { "name": "deposit_percent", "value": "25" }, { "name": "deposit_type", "value": "fixed" }, { "name": "email_body", "value": "Hi {{client_name}},\n\nYour planning portal is ready here: {{planning_link}}\n\nTotal: {{total}}\nDeposit: {{deposit}}\nBalance: {{balance}}" }, { "name": "email_subject", "value": "Your Gigora planning portal" }, { "name": "followup_auto_enabled", "value": "" }, { "name": "followup_delay_days", "value": "0" }, { "name": "followup_email_body", "value": "Hi {{client_name}},\n\nThank you for having us at your event. It was a pleasure to be part of it.\n\nKind regards,\n{{business_name}}" }, { "name": "followup_email_subject", "value": "Thank you from {{business_name}}" }, { "name": "from_email", "value": "bookings@gigora-demo.co.uk" }, { "name": "inbox_enabled", "value": "0" }, { "name": "inbox_imap_encryption", "value": "ssl" }, { "name": "inbox_imap_folder", "value": "INBOX" }, { "name": "inbox_imap_host", "value": "" }, { "name": "inbox_imap_password", "value": "" }, { "name": "inbox_imap_port", "value": "993" }, { "name": "inbox_imap_username", "value": "" }, { "name": "inbox_storage_limit", "value": "100" }, { "name": "invoice_email_body", "value": "Hi {{client_name}},\n\nPlease find your invoice attached for {{event_date}}.\n\nBalance due: {{balance}}\n\nPayment details:\n{{bank_details}}\n\nKind regards,\n{{business_name}}" }, { "name": "invoice_email_subject", "value": "Invoice for your booking" }, { "name": "lead_form_border_colour", "value": "#d9e0e7" }, { "name": "lead_form_button", "value": "Send enquiry" }, { "name": "lead_form_card_colour", "value": "#ffffff" }, { "name": "lead_form_enabled", "value": "1" }, { "name": "lead_form_field_colour", "value": "#ffffff" }, { "name": "lead_form_intro", "value": "Tell us about your event and we will come back to you." }, { "name": "lead_form_muted_colour", "value": "#667085" }, { "name": "lead_form_primary_colour", "value": "#116a7b" }, { "name": "lead_form_text_colour", "value": "#17202a" }, { "name": "lead_form_title", "value": "Check availability" }, { "name": "lead_form_transparent_card", "value": "" }, { "name": "lead_form_updated_at", "value": "1792787460" }, { "name": "licence_addon_serato_companion", "value": "0" }, { "name": "licence_checked_at", "value": "2026-05-06 10:38:00" }, { "name": "licence_grace_until", "value": "" }, { "name": "licence_key", "value": "gigora_live_9e2ae68dae6c8b63950400ab10dc345b4406" }, { "name": "licence_message", "value": "Instance provisioned from the Gigora licence hub." }, { "name": "licence_plan", "value": "pro" }, { "name": "licence_server_url", "value": "https:\/\/licences.gigora.co.uk" }, { "name": "licence_status", "value": "active" }, { "name": "notification_cron_key", "value": "ccc3d483eb3994a9565ef5ae29ebb683ba67" }, { "name": "notification_daily_time", "value": "08:00" }, { "name": "onboarding_complete", "value": "1" }, { "name": "openrouteservice_api_key", "value": "" }, { "name": "payment_terms", "value": "Deposit due on booking. Final balance due 14 days before the event." }, { "name": "portal_email_body", "value": "Hi {{client_name}},\n\nYour planning portal is ready here:\n{{planning_link}}\n\nKind regards,\n{{business_name}}" }, { "name": "portal_email_subject", "value": "Your planning portal" }, { "name": "prep_checklist_items", "value": "Laptop charged\nController packed\nPower cables packed\nBackup music ready\nSpeaker\/PA checked\nLighting checked\nMicrophone checked\nArrive with setup time confirmed" }, { "name": "push_vapid_private_pem", "value": "-----BEGIN PRIVATE KEY-----\nMIGHAgEAMBMGByqGSM49AgEGCCqGSM49AwEHBG0wawIBAQQgePxGoSkglE0k2PiE\nUUXglZCQFmE9yjTaCvQ2S+Z14J+hRANCAASXlZKDgBeR12Yo1vWv4ndsUe9Qgd9S\nBbljDYkl5vS3lTCkV\/QDbFtTuIfrw0vXxKRPPIkCUCs7ik8RTlDQSNZx\n-----END PRIVATE KEY-----\n" }, { "name": "push_vapid_public_key", "value": "BJeVkoOAF5HXZijW9a_id2xR71CB31IFuWMNiSXm9LeVMKRX9ANsW1O4h-vDS9fEpE88iQJQKzuKTxFOUNBI1nE" }, { "name": "quote_email_body", "value": "Hi {{client_name}},\n\nPlease find your quote attached for {{event_date}}.\n\nTotal: {{total}}\nDeposit: {{deposit}}\nBalance: {{balance}}\n\nYou can also view your planning portal here:\n{{planning_link}}\n\nKind regards,\n{{business_name}}" }, { "name": "quote_email_subject", "value": "Quote for your booking" }, { "name": "smtp_enabled", "value": "0" }, { "name": "smtp_encryption", "value": "ssl" }, { "name": "smtp_host", "value": "" }, { "name": "smtp_password", "value": "" }, { "name": "smtp_port", "value": "465" }, { "name": "smtp_username", "value": "" }, { "name": "spotify_client_id", "value": "" }, { "name": "spotify_client_secret", "value": "" }, { "name": "support_access_enabled", "value": "0" }, { "name": "support_access_until", "value": "" }, { "name": "team_dj_skill_migrated", "value": "1" }, { "name": "temporary_password_active", "value": "0" }, { "name": "terms_required_version", "value": "2026-05-15-major-update" }, { "name": "terms_url", "value": "https:\/\/gigora.co.uk\/terms-and-conditions.html" }, { "name": "update_notice_ack_version", "value": "2026-10-automatic-gig-completion" }, { "name": "v2_welcome_seen_2", "value": "1" } ] }, "files": [] }