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