$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'];
$array_rooms["items"] = array();
$complex_report_room_items_array = $complex_report_room_items_object->getAll("WHERE room_id = " . $complex_report_rooms_array[$i]['id'] . " ORDER BY room_template_item_id");
for ($j = 0; $j < count($complex_report_room_items_array); $j++) {
$array_room_items['itemId'] = $complex_report_room_items_array[$j]['id'];
$array_room_items['itemTemplateId'] = $complex_report_room_items_array[$j]['room_template_item_id'];
$array_room_items['itemName'] = $complex_report_room_items_array[$j]['name'];
$array_room_items['statusId'] = $complex_report_room_items_array[$j]['status_id'];
$array_room_items['work_category_id'] = $complex_report_room_items_array[$j]['work_category_id'];
$array_room_items['statusClass'] = $array_report_status[$complex_report_room_items_array[$j]['status_id']]['class'];
$array_room_items['statusName'] = $array_report_status[$complex_report_room_items_array[$j]['status_id']]['name'];
$array_room_items['comment_thread'] = array();
<?php
require_once dirname(dirname(dirname(__FILE__))) . '/modules/Report.class.php';
require_once dirname(dirname(dirname(__FILE__))) . '/modules/Dynamo.class.php';
$reportId = isset($_GET['reportId']) ? $_GET['reportId'] : 0;
if ($reportId != 0) {
$reportObj = new Report();
$usersObj = new Dynamo("users");
$array_users = $usersObj->getAllWithId_default(false, "id");
$subContractorsObj = new Dynamo("sub_contractors");
$array_sub_contractors = $subContractorsObj->getAllWithId_default(false, "id");
$reportInfo = $reportObj->getReportDetails($reportId, false, $array_users, $array_sub_contractors);
$report_images = new Dynamo("report_images");
$array_report_images_count = $report_images->getAll("WHERE property_id = " . $reportInfo['propertyId']);
$array_report_images = $report_images->getAllWithId_default("WHERE property_id = " . $reportInfo['propertyId'], 'room_item_id');
for ($i = 0; $i < count($array_report_images_count); $i++) {
$array_report_images[$array_report_images_count[$i]['room_item_id']]['count'] += 1;
if ($array_report_images_count[$i]['image_name'] != $array_report_images[$array_report_images_count[$i]['room_item_id']]['image_name']) {
$array_report_images[$array_report_images_count[$i]['room_item_id']]['extra_images'] .= $array_report_images_count[$i]['image_name'] . ",";
}
}
$main_image_array = $report_images->getAll("WHERE property_image = 1 AND property_id = " . $reportInfo['propertyId']);
if (count($main_image_array) > 0) {
$main_image_array = $main_image_array[0];
}
?>
<form method="POST" class="form-horizontal" id="addReportForm" onsubmit="return false">
<input type="hidden" id="_BASENAME" name="baseName" value="<?php
echo __BASENAME__;
?>
<?php
require_once dirname(dirname(dirname(__FILE__))) . '/modules/Dynamo.class.php';
$sub_contractors = new Dynamo("sub_contractors");
$work_categories = new Dynamo("work_categories");
if ($_SESSION['user_type'] == 5) {
$readonly = true;
} else {
$readonly = false;
}
$work_categories_array = $work_categories->getAll("WHERE parent_id = 0");
$sub_contractor_work_category = new Dynamo("sub_contractor_work_category");
if (trim($_REQUEST['id']) != '') {
$array_sub_contractor = $sub_contractors->getOne();
if (count($array_sub_contractor) > 0) {
$array_sub_work = $sub_contractor_work_category->getAllWithId_default("WHERE sub_contractor_id = " . $_REQUEST['id'], "work_category_id");
?>
<form method="POST" class="form-horizontal" id="addSubContractorForm" onSubmit="return false;">
<input type="hidden" id="baseName" name="baseName" value="<?php
echo __BASENAME__;
?>
" />
<input type="hidden" id="id" name="id" value="<?php
print $_REQUEST['id'];
?>
" />
<div class="pull-left"><h4>View SubContractor</h4></div>
<div class="pull-right"><button class="btn btn-warning" type="submit">Submit Changes</button> <?php
if ($_SESSION['user_type'] != 5) {
?>
$propertyId = isset($_GET['propertyId']) ? $_GET['propertyId'] : 0;
$report_images = new Dynamo("report_images");
if ($propertyId != 0) {
$propertyObj = new Property();
$propertyInfo = $propertyObj->getPropertyInfo($propertyId, false);
$estimates_obj = new Dynamo("estimates");
$estimatesArray = $estimates_obj->getAll("WHERE property_id = " . $propertyId . " AND is_saved = 1");
$estimatesArray = $estimatesArray[0];
$reportObj = new Report();
$estimatesObj = new Estimates();
$usersObj = new Dynamo("users");
$array_users = $usersObj->getAllWithId_default(false, "id");
$subContractorsObj = new Dynamo("sub_contractors");
$array_sub_contractors = $subContractorsObj->getAllWithId_default(false, "id");
$companiesObj = new Dynamo("companies");
$array_companies = $companiesObj->getAllWithId_default(false, "id");
$dailyLogsObj = new Dynamo("daily_logs");
/*$reportObj = new Report();
$reports = $reportObj->getReportsSummary($propertyId, false,$array_users,$array_sub_contractors,$array_companies);**/
$reports = $reportObj->getReportsSummary($propertyId, false, $array_users, $array_sub_contractors, $array_companies);
$estimates = $estimatesObj->getEstimatesSummary($propertyId, false, $array_users, $array_companies);
$daily_logs = $dailyLogsObj->getAll("WHERE property_id = " . $propertyId . " ORDER BY timestamp DESC");
$array_reports_estimates = array();
for ($i = 0; $i < count($reports); $i++) {
$reports[$i]['report'] = true;
$array_reports_estimates[strtotime($reports[$i]['dateReported'])] = $reports[$i];
}
for ($i = 0; $i < count($estimates); $i++) {
$array_reports_estimates[strtotime($estimates[$i]['dateReported'])] = $estimates[$i];
}
for ($i = 0; $i < count($daily_logs); $i++) {
require_once __ROOT__ . '/modules/Dynamo.class.php';
$result['success'] = false;
$result['message'] = '';
$work_category_estimates_obj = new Dynamo("work_category_estimates");
$estimate_room_items_units_obj = new Dynamo("estimate_room_items_units");
$unitsObj = new Dynamo("units");
$room_template_items_obj = new Dynamo("room_template_items");
$sub_contractors_obj = new Dynamo("sub_contractors");
$subcontractors_assign_obj = new Dynamo("subcontractors_assign");
$unitsArray = $unitsObj->getAllWithId();
if (trim($_POST['edit_off']) != '') {
$edit_off = true;
}
if (trim($_POST['roomTemplateItemsId']) != '' && trim($_POST['estimate_id']) != '' && trim($_POST['room_id']) != '' && trim($_POST['work_category_id']) != '') {
$array_work_category_estimates = $work_category_estimates_obj->getAll("WHERE work_category_id = " . $_POST['work_category_id'] . " ORDER BY item_name");
$array_estimate_room_items_units = $estimate_room_items_units_obj->getAllWithId_default("WHERE estimate_id = " . $_POST['estimate_id'] . " AND room_id = " . $_POST['room_id'], "work_category_estimates_id");
//get subcontractors
$room_template_items_array = $room_template_items_obj->getAll("WHERE id = " . $_POST['roomTemplateItemsId']);
if (count($room_template_items_array) > 0) {
$query = "SELECT sub_contractor_work_category.sub_contractor_id,sub_contractors.first_name,sub_contractors.last_name FROM sub_contractor_work_category INNER JOIN sub_contractors ON sub_contractors.id = sub_contractor_work_category.sub_contractor_id WHERE sub_contractor_work_category.work_category_id = " . $room_template_items_array[0]['work_category_id'];
$subcontractor_array = $sub_contractors_obj->customFetchQuery($query);
}
if (count($array_work_category_estimates) > 0) {
$result['success'] = true;
//$result['message'] = $array_work_category_estimates;
$result['message'] = '<div id="accordion" class="panel-group">';
for ($i = 0; $i < count($array_work_category_estimates); $i++) {
$units_of_measure = $unitsArray[$array_work_category_estimates[$i]['unit_of_measure']]["estimate_unit"];
$result['message'] .= '<div class="panel panel-default">
<div class="panel-heading">
<h4 class="panel-title">
