{ "app": "Gigora", "version": 1, "exported_at": "2026-06-26T10:53:24+01: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" }, { "id": 23, "name": "Maya Stone", "email": "maya.demo@gigora.local", "password_hash": "$2y$10$DEDltl\/Nh\/gb4SpygVxpLOzRH7qhtjU8RtYp8JlnsYTLgyyRb025O", "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-06-26 09:43:40" }, { "id": 24, "name": "Leo Grant", "email": "leo.demo@gigora.local", "password_hash": "$2y$10$a2lRM8b6mvGmCJCd9Fy.G.bxZOezM\/HooEL5EifP7DTiLJQtsaYGa", "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-06-26 09:43:40" } ], "venues": [ { "id": 1, "name": "Willowmere Hall", "address": "12 Fictional Lane, Exampletown EX1 1AA", "map_url": "", "latitude": null, "longitude": null, "created_at": "2026-06-26 09:43:40" }, { "id": 2, "name": "The Crescent Suite", "address": "8 Placeholder Avenue, Demo City DC2 2BB", "map_url": "", "latitude": null, "longitude": null, "created_at": "2026-06-26 09:43:40" }, { "id": 3, "name": "Neon Loft", "address": "Unit 5, Sample Yard, Mockford MK3 3CC", "map_url": "", "latitude": null, "longitude": null, "created_at": "2026-06-26 09:43:40" }, { "id": 4, "name": "Oakridge Barn", "address": "44 Test Valley Road, Fableton FB4 4DD", "map_url": "", "latitude": null, "longitude": null, "created_at": "2026-06-26 09:43:40" } ], "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 }, { "id": 2, "name": "Confetti cannon moment", "description": "Two cannons for a first dance or room reveal.", "price_pence": 8000, "active": 1 }, { "id": 3, "name": "Extra hour", "description": "Additional performance hour.", "price_pence": 12500, "active": 1 }, { "id": 4, "name": "Mood lighting", "description": "Wireless uplighters for the room.", "price_pence": 18000, "active": 1 } ], "bookings": [ { "id": 1, "client_name": "enc:v1:LqEwPW6U+k4ug1zU\/qUl+B57foZkC6Ml58ZghNuAovG6JmrumAp7k\/lVBQ==", "client_email": "enc:v1:UCwYFEk63PQVDuQr0ruf6Tmq6aVyoPqVQKlwRZRGTzsYu\/FIAGqjarIV1d\/FSUNlpyW42FQ9Rw==", "client_phone": "enc:v1:FlklHdWh20JgxXOo0FqGAEFURlQI2mSN5RfQNlkGOSSNNNNLhMpAW+JHVQ==", "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-06-29 29\/06\/2026 monday 29th june 2026 16 00 00 00 00 00", "event_date": "2026-06-29", "start_time": "16:00:00", "finish_time": "00:00:00", "venue_id": 1, "package_id": 2, "assigned_admin_id": 23, "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": "f2e653c2ee2bdc6b9d5201275042c237ddc29f637a9289b4", "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_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-06-26 09:43:40", "updated_at": "2026-06-26 09:43:40" }, { "id": 2, "client_name": "enc:v1:UVrNmDYIquoj5aPqdW8HT2m+iQ+QUdcFNyrbH6Oir69ouq7vZTKhlMvAOCs=", "client_email": "enc:v1:mqFoZOueB3NGufi\/H9cRnVLYfD45DQPe\/gRw5TW91PZ1yiPLZSCFVu8GqtOhH1gKcqmBEAg7O0k=", "client_phone": "enc:v1:sUTJUttAte1rfgyaGMIUQunB6j4QAwnjBX5dig8sqtQP+MfPHbBVY9nfHQ==", "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-07-14 14\/07\/2026 tuesday 14th july 2026 18 30 00 01 00 00", "event_date": "2026-07-14", "start_time": "18:30:00", "finish_time": "01:00:00", "venue_id": 2, "package_id": 2, "assigned_admin_id": 24, "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": "2a4e7e609bdf43dbc70c7bd26a567ddd14c2d0ee63470c15", "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_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-06-26 09:43:40", "updated_at": "2026-06-26 09:43:40" }, { "id": 3, "client_name": "enc:v1:xNx\/QcdgSNZLdTnBvm7Sg6grsPwGDtQZKQHyZbRkMnlQ+s9ck\/5u+6fEIPVoQkgeOQ==", "client_email": "enc:v1:Ypd443dLfKD1B01aH1bKe0PFn4HdlKgjG90pcuynVU8AwNOb1G3sYniW4JQMJCbDwKg=", "client_phone": "enc:v1:l0khXXhHka8jz4d\/ctXU2Mz1PwihCl3XKfjeOIqC4WXLKSV4wDU2c+Unpw==", "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-07-21 21\/07\/2026 tuesday 21st july 2026 21 00 00 02 00 00", "event_date": "2026-07-21", "start_time": "21:00:00", "finish_time": "02:00:00", "venue_id": 3, "package_id": 3, "assigned_admin_id": 23, "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": "25772a00aa28929cbc5451436f0257c2904d76f4d5edefff", "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_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-06-26 09:43:40", "updated_at": "2026-06-26 09:43:40" }, { "id": 4, "client_name": "enc:v1:I1oU0DkSFoBpPc6VERWEkEmMP\/O9ayPZR\/89x1rcPOwRdoNNgpakiPfYKxI=", "client_email": "enc:v1:sXdW4MCST4R3v\/+blH1dIjchkMA7NaNq3DpCbKWXMnBH3JlXpYtsFA07bBWg71xCHxubYT5KtPs=", "client_phone": "enc:v1:OFa+GyVxStGG0S4GDyba\/1G583Yr6\/SaojNGrM5lD\/Aau5sWAAKdL1b49Q==", "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-08-10 10\/08\/2026 monday 10th august 2026 15 00 00 00 30 00", "event_date": "2026-08-10", "start_time": "15:00:00", "finish_time": "00:30:00", "venue_id": 4, "package_id": 1, "assigned_admin_id": 24, "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": "0ca6173628b322bc0548642c56fb19536f5d4f6e16e10821", "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_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-06-26 09:43:40", "updated_at": "2026-06-26 09:43:40" }, { "id": 5, "client_name": "enc:v1:7w5MyfjrJV5mZ9pYaSUcTMtLt7K6cq4cXojvmuX6FzqLTIkOz5qWlV82yPK\/vj\/B", "client_email": "enc:v1:jOse5LNT34fr4TUM1+ikflOHsOWE+HzxZKmCfvnNc2mYUyzHgBMGf6KhwIMCFGlwAxI=", "client_phone": "enc:v1:OHxZVyrqyHgJID+R5SoCOgWtx0HiPZRh6VbmXxrpC4H3x64FdPInkM6abw==", "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-06-19 19\/06\/2026 friday 19th june 2026 19 00 00 23 30 00", "event_date": "2026-06-19", "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": "c7ba29ff601cfba2ea4573cbfb903a69605ddb01a1a14f19", "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_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-06-26 09:43:40", "updated_at": "2026-06-26 09:43:40" } ], "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" } ], "residencies": [ { "id": 1, "title": "Neon Fridays", "venue_id": 3, "assigned_admin_id": 23, "package_id": 3, "custom_price_pence": 0, "start_date": "2026-06-26", "end_date": "2026-09-18", "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-06-26 09:43:40" } ], "calendar_events": [ { "id": 1, "booking_id": 1, "event_type": "playlisting_meeting", "title": "Playlisting call - Alex and Jordan", "starts_at": "2026-06-27 19:00:00", "ends_at": "2026-06-27 19:30:00", "assigned_admin_id": 23, "notify_24h": 1, "notify_minutes": 1440, "notes": "Confirm essentials and do-not-play list.", "created_at": "2026-06-26 09:43:40" }, { "id": 2, "booking_id": 4, "event_type": "selling_meeting", "title": "Selling meeting - Taylor and Riley", "starts_at": "2026-06-28 18:30:00", "ends_at": "2026-06-28 19:00:00", "assigned_admin_id": 24, "notify_24h": 1, "notify_minutes": 60, "notes": "Talk through package options.", "created_at": "2026-06-26 09:43:40" } ], "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, "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-06-26 09:43:40" }, { "id": 2, "booking_id": 1, "template_id": 4, "title": "Invoice for Alex and Jordan", "document_type": "invoice", "invoice_kind": null, "invoice_amount_pence": 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-06-26 09:43:40" }, { "id": 3, "booking_id": 2, "template_id": 1, "title": "Contract for Casey and Morgan", "document_type": "contract", "invoice_kind": null, "invoice_amount_pence": 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-06-26 09:43:40" }, { "id": 4, "booking_id": 3, "template_id": 4, "title": "Invoice for Northside Social Club", "document_type": "invoice", "invoice_kind": null, "invoice_amount_pence": 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-06-26 09:43:40" } ], "emails": [], "push_subscriptions": [], "admin_notification_preferences": [], "notification_deliveries": [], "lead_submissions": [], "settings": [ { "name": "app_mode", "value": "agency" }, { "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": "f4c899d3d77b6152e062f09db2b870d81784" }, { "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_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": "0" }, { "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": "0" }, { "name": "lead_form_updated_at", "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": "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-05-major-update-terms-email-darkmode" } ] }, "files": [] }