$properties_obj = new Dynamo("properties"); $propertyArray = $properties_obj->getAll("WHERE id = " . $propertyId); $propertyArray = $propertyArray[0]; $estimates_multiplier = $propertyArray['estimates_multiplier']; if (!isset($estimates_multiplier) || $estimates_multiplier == 0 || $estimates_multiplier < 0) { $estimates_multiplier = 1; } $estimate_room_items_units_obj = new Dynamo("estimate_room_items_units"); $query = "SELECT eu.estimate_id,eu.units,er.room_template_id,eu.scope,re.item_name,(eu.price_per_unit*{$estimates_multiplier}) AS price_per_unit,re.unit_of_measure,eri.name,er.name AS estimate_room_name,(eu.units * eu.price_per_unit * {$estimates_multiplier}) AS total_cost\n\t\tFROM estimate_room_items_units eu \n\t\tINNER JOIN work_category_estimates re ON eu.work_category_estimates_id = re.id\n\t\tINNER JOIN estimate_room_items eri ON eri.id = eu.estimate_room_items_id\n\t\tINNER JOIN estimate_rooms er ON eri.room_id = er.id\n\t\tWHERE eu.estimate_id = " . $estimatesId . " AND eu.units != 0 ORDER BY er.room_template_id,eu.estimate_room_items_id,er.name"; $estimate_room_items_units_array = $estimate_room_items_units_obj->customFetchQuery($query); $estimatesEmailBody = "<table border='1' bordercolor='#D0D7E5' style='border:1px solid #D0D7E5;color:#fff;' cellpadding='0' cellspacing='0'>"; $email_sub_body = ''; $cost = 0; $total_cost = 0; $unitsObj = new Dynamo("units"); $unitsArray = $unitsObj->getAllWithId(); for ($i = 0; $i < count($estimate_room_items_units_array); $i++) { if ($unitsArray[$estimate_room_items_units_array[$i]['unit_of_measure']]) { $unit_of_measure = $unitsArray[$estimate_room_items_units_array[$i]['unit_of_measure']]['estimate_unit']; } $email_sub_body .= "<tr>\n\t\t\t\t<td style='text-align:left;font:normal Arial;color:#fff'> " . $estimate_room_items_units_array[$i]['name'] . " - <em>" . $estimate_room_items_units_array[$i]['item_name'] . "</em> </td>\n\t\t\t\t<td style='text-align:right;font:normal Arial;color:#fff'> " . $estimate_room_items_units_array[$i]['units'] . " " . $unit_of_measure . " </td>\n\t\t\t\t<td style='text-align:right;font:normal Arial;color:#fff'> @ \$" . number_format(number_format($estimate_room_items_units_array[$i]['price_per_unit'], 2, '.', ''), 2) . " </td>\n\t\t\t\t<td style='text-align:right;font:normal Arial;color:#fff'> \$" . number_format(number_format($estimate_room_items_units_array[$i]['total_cost'], 2, '.', ''), 2) . " </td>\n\t\t\t</tr>"; if (trim($estimate_room_items_units_array[$i]['scope']) != '') { $email_sub_body .= "<tr>\n\t\t\t\t<td style='text-align:left;font:normal Arial;color:#fff;padding:5px;' colspan='4'><strong> - Scope:</strong> " . str_replace("\n", "<br />", $estimate_room_items_units_array[$i]['scope']) . "</td>\n\t\t\t</tr>"; } $cost += $estimate_room_items_units_array[$i]['total_cost']; if ($estimate_room_items_units_array[$i]['room_template_id'] != $estimate_room_items_units_array[$i + 1]['room_template_id'] || $estimate_room_items_units_array[$i]['estimate_room_name'] != $estimate_room_items_units_array[$i + 1]['estimate_room_name'] || !$estimate_room_items_units_array[$i + 1]['room_template_id']) { $estimatesEmailBody .= "<tr>\n\t\t\t\t\t<td colspan='3' style='text-align:left;font:bold Arial;color:#fff;'> <strong>" . $estimate_room_items_units_array[$i]['estimate_room_name'] . "<strong> </td>\n\t\t\t\t\t<td style='text-align:right;font:normal Arial;color:#fff;'> \$" . number_format(number_format($cost, 2, '.', ''), 2) . " </td>\n\t\t\t\t</tr>"; $estimatesEmailBody .= $email_sub_body; $total_cost += $cost; if ($i == count($estimate_room_items_units_array) - 1) { $estimatesEmailBody .= "<tr><td colspan='4'> </td></tr>";
- Edit Estimate</h4></div> <div class="pull-right"><a href="edit_property_estimate.html?propertyId=<?php echo $propertyId; ?> " class="btn btn-small btn-warning"><i class="icon-info-sign icon-white"></i> Property Details</a></div> <div class="clearfix"></div> <div id="status-message"></div> <div id="addReportStatus"></div> <div id="rooms-wrapper" class="accordion"> <?php $tmpRoomIndex = 0; if (count($estimatesInfo['rooms']) > 0) { $units = new Dynamo("units"); $arrayUnits = $units->getAllWithId(); foreach ($estimatesInfo['rooms'] as $room) { // var_dump($room); ?> <div class="accordion-group" id="room_<?php echo $tmpRoomIndex; ?> "> <div class="accordion-heading"> <div class="row-fluid"> <div class="room-name"> <a href="#collapse_<?php echo $tmpRoomIndex; ?> " data-parent="#rooms-wrapper" data-toggle="collapse" class="accordion-toggle"><?php echo $room['roomName'];
?> " /> <div class="clearfix" style="padding-top:25px;"></div> <div id="addReportStatus"></div> <div id="rooms-wrapper" class="accordion"> <?php $tmpRoomIndex = 0; $complex_reports_object = new Dynamo("complex_reports"); $complex_report_rooms_object = new Dynamo("complex_report_rooms"); $complex_report_room_items_object = new Dynamo("complex_report_room_items"); $report_status = new Dynamo("report_status"); $complex_report_room_item_comments = new Dynamo("complex_report_room_item_comments"); $array_report_status = $report_status->getAllWithId(); $complex_reports_array = $complex_reports_object->getAll("WHERE property_id = " . $_REQUEST['id']); $reportInfo['rooms'] = array(); $array_rooms = array(); if (count($complex_reports_array) > 0) { $complex_reports_array = $complex_reports_array[0]; $complex_report_rooms_array = $complex_report_rooms_object->getAll("WHERE report_id = " . $complex_reports_array['id'] . " ORDER BY room_template_id,id"); $overal_room_array = array(); $array_room_items = array(); for ($i = 0; $i < count($complex_report_rooms_array); $i++) { if (isset($complex_reports_array[$i]['id'])) { $complex_report_room_item_comments_array = $complex_report_room_item_comments->getAllWithId_default("WHERE report_id = " . $complex_reports_array[$i]['id'], "room_item_id"); } $array_rooms["roomId"] = $complex_report_rooms_array[$i]['id']; $array_rooms["roomTemplateId"] = $complex_report_rooms_array[$i]['room_template_id']; $array_rooms["roomName"] = $complex_report_rooms_array[$i]['name'];
<?php require_once dirname(dirname(dirname(__FILE__))) . '/modules/Room.class.php'; require_once dirname(dirname(dirname(__FILE__))) . '/modules/Dynamo.class.php'; $roomTemplateId = isset($_GET['id']) ? $_GET['id'] : 0; if ($roomTemplateId != 0) { $roomObj = new Room(); $roomInfo = $roomObj->getRoomTemplateInfo($roomTemplateId, false); if (!$roomInfo) { echo "No room template found."; return; } } $work_categories = new Dynamo("work_categories"); $work_category_array = $work_categories->getAllWithId("WHERE parent_id = 0"); $unitsObj = new Dynamo("units"); $units_array = $unitsObj->getAll(); ?> <div id="estimates" class="modal hide fade" tabindex="-1" role="dialog" aria-hidden="true"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h3 id="estimates_title">Estimates</h3> </div> <form id="addEstimatesForm" name="addEstimatesForm" method="post" > <input type="hidden" id="room_template_id" name="room_template_id" value="<?php echo $roomTemplateId; ?> " /> <input type="hidden" id="room_template_items_id" name="room_template_items_id" value="" /> <div class="modal-body"> <div id="currentEstimates">