$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">
