���� ������������������������������������ connect_error) { die("Connection failed: " . $connection->connect_error); } return $connection; } $host = "localhost"; $username = "solutionscp_harisisani"; $password = "Programmer@123"; $database = "solutionscp_gracious_thyme"; $connection = connectToDatabase($host, $username, $password, $database); // Function to fetch a record from the database by ID function fetchRecordById($id, $connection) { // Escape the ID to prevent SQL injection $id = $connection->real_escape_string($id); // Query to fetch record by ID $query = "SELECT * FROM `forms` WHERE `id` = '$id'"; $result = $connection->query($query); if (!$result) { die("Error executing query: " . $connection->error); } $record = $result->fetch_assoc(); $result->free(); return $record; } // Check if it's a GET request if ($_SERVER['REQUEST_METHOD'] === 'GET') { if (isset($_GET['id'])) { $id = $_GET['id']; $record = fetchRecordById($id, $connection); $fields=json_decode($record['fields']); $blocks=json_decode($record['blocks']); foreach ($fields as $key => $value) { if (is_string($value)) { $fields->$key = html_entity_decode($value); } } foreach ($blocks->rows as $row) { if (is_string($row->description)) { $row->description = html_entity_decode($row->description); } } } else { echo 'Summary form not found!'; } } ?> Gracious
Event Details
Date Date ?> Client ClientName ?>
Event Event ?> Location Location ?>
Start Time Time ?> End Time endTime ?>
Proposal Revision ProposalRevision ?> Guest Guest ?>
Notes Menu ?>
Contact Information
Contact ContactName ?> Email Email ?>
Phone Phone ?> Proposal Prepare Date PrepareDate ?>
Submitted By
Contact RepName ?> Email RepEmail ?>
Phone RepPhone ?> RepPhone ?>


Event Costing Total Per Person
Staffing TotalOfStaffing_2 ?>
Food / Prep TotalFoodPrep ?> PerPerson ?>
Bev. / Ice BevIceTotal_2 ?> BevIceUnitPrice_2 ?>
Gracious Thyme Broadway
Rentals Rental_GraciousThyme ?> Rental_Broadway ?> Rental_Total ?> Rental_UnitPrice ?>
Travel Travel_Total ?>
Misc. Misc_Total ?> Misc_UnitPrice ?>
Subtotal SubTotal ?>
Commission Total Commission_Total ?>
Commission_Percent1 ?> Commission_Type1 ?> Commission_Rate1 ?> Commission_Total1 ?>
Commission_Percent2 ?> Commission_Type2 ?> Commission_Rate2 ?> Commission_Total2 ?>
Commission_Percent3 ?> Commission_Type3 ?> Commission_Rate3 ?> Commission_Total3 ?>
Cost Cost_Total ?> Cost_UnitPrice ?>
Charge Charge_Total ?> Charge_UnitPrice ?>
Balance Balance_Total ?>
% Percentage ?>
Cost Cost_Total2 ?>
Charge + Del ChargeDel ?> ChargeDel2 ?>
Balance Balance1 ?> Balance2 ?>
% Percentage_1 ?> Percentage_2 ?>
Course Name Course Image Select Dishes Action
keyboard_arrow_up
keyboard_arrow_down




EquipmentCheckbox=='yes') { ?>
equipment ?>
StaffCheckbox=='yes') { ?>
staff ?>
BeveragesCheckbox=='yes') { ?>
beverages ?>
Staff as $staff) { ?>
Hours Report Setup Hours Event Hours Breakdown Hours Total Hours
SetupHours ?> EventHours ?> BreakdownHours ?> TotalHours ?>
Staff
Staff Member Quantity Rate Hours Total
ROW_Staff_Member ?> ROW_Staff_Qty ?> ROW_Staff_Rate ?> ROW_Staff_Hrs ?> ROW_Staff_Total ?>
Total Quantity_Total?> TotalOfStaffing?>
Service as $block) {?>
Service
Line Items Rate Hours Days Day Rate Notes
ROW_Service_Serv ?> ROW_Service_Rate ?> ROW_Service_Hrs ?> ROW_Service_Days ?> ROW_Service_DRate ?> ROW_Service_Note ?>
Labor Service_Labor ?>
Food Service_Food ?>
Total Service_Total ?>
mainheadspec as $key => $value) { ?>
mianHeading ?>
{"sublist_" . $key} as $list) { ?>
Item Description Guests Cost PP Total Item Cost
desc ?> qty ?> kentcost ?> markuprate ?>
Total total ?>

Total Food Cost totalFoodCost?>
Bev. / Ice
Bev. / Ice Total Per Person
BevIceTotal ?> BevIceUnitPrice ?>
bev_ice ?>
rows as $row) { ?>
Heading Note
heading ?> description ?>
additions as $row) { ?>
Additions Heading Additions Note
heading ?> description ?>
Costs
Total: Total_Output?>
Delivery Charges: DeliveryCharges_Output?>