<?php
require_once dirname(dirname(dirname(__FILE__))) . '/modules/Dynamo.class.php';
if (trim($_REQUEST['id']) != '') {
$unitsObj = new Dynamo("units");
$unit_array = $unitsObj->getOne();
if (count($unit_array) > 0) {
?>
<form method="POST" class="form-horizontal" id="unitForm">
<input type="hidden" id="baseName" name="baseName" value="<?php
echo __BASENAME__;
?>
" />
<input type="hidden" id="id" name="id" value="<?php
print $unit_array['id'];
?>
" />
<div class="pull-left"><h4>Edit Unit</h4></div>
<div class="pull-right"><button class="btn btn-warning" type="submit">Submit Changes</button> <a href="units.html" class="btn btn-default">Cancel</a></div>
<div class="clearfix"></div>
<div id="status-message"></div>
<div class="control-group">
<label for="email" class="control-label">Estimate Unit</label>
<div class="controls">
<input type="text" name="estimate_unit" id="estimate_unit" class="form-control" placeholder="Estimate Unit" value="<?php
print $unit_array['estimate_unit'];
?>
" data-validation="required" data-validation-error-msg="Please enter a unit name." />
</div>
public function getReportDetails($reportId, $isJson = true, $array_users = false, $array_sub_contractors = false)
{
$result['success'] = false;
$result['message'] = '';
$result['data'] = '';
$data = array();
$mysqli = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
if ($mysqli->connect_errno) {
$result['message'] = "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}
$propertyId = 0;
$sql = "SELECT\t\n\t\t\t properties.id\n\t\t\t,properties.name\n\t\t\t,properties.address\n\t\t\t,properties.city\n\t\t\t,properties.state\n\t\t\t,properties.map_link\n\t\t\t,properties.emails\n\t\t\t,properties.property_type\n\t\t\t,properties.job_type\n\t\t\t,properties.community\n\t\t\t,reports.status_id\n\t\t\t,reports.date_reported\n\t\t\t,reports.reported_by\n\t\t\t,reports.subcontractor\n\t\tFROM reports\n\t\t\tINNER JOIN properties ON properties.id = reports.property_id\n\t\tWHERE reports.id = ?\n\t\t";
$placeholder = $reportId;
if ($stmt = $mysqli->prepare($sql)) {
$stmt->bind_param("i", $placeholder);
if ($stmt->execute()) {
$stmt->bind_result($propertyId, $propertyName, $propertyAddress, $propertyCity, $propertyState, $propertyMapLink, $propertyEmails, $propertyType, $propertyJobType, $propertyCommunity, $reportStatusId, $reportDate, $reported_by, $subcontractor);
while ($stmt->fetch()) {
if ($subcontractor == 1) {
$data = array('propertyId' => $propertyId, 'propertyName' => $propertyName, 'propertyAddress' => $propertyAddress, 'propertyCity' => $propertyCity, 'propertyState' => $propertyState, 'propertyMapLink' => $propertyMapLink, 'propertyEmails' => $propertyEmails, 'propertyType' => $propertyType, 'propertyJobType' => $propertyJobType, 'propertyCommunity' => $propertyCommunity, 'reportStatusId' => $reportStatusId, 'firstName' => $array_sub_contractors[$reported_by]['first_name'], 'lastName' => $array_sub_contractors[$reported_by]['last_name'], 'reportDate' => $reportDate, 'reported_by' => $reported_by, 'subcontractor' => $subcontractor);
} else {
$data = array('propertyId' => $propertyId, 'propertyName' => $propertyName, 'propertyAddress' => $propertyAddress, 'propertyCity' => $propertyCity, 'propertyState' => $propertyState, 'propertyMapLink' => $propertyMapLink, 'propertyEmails' => $propertyEmails, 'propertyType' => $propertyType, 'propertyJobType' => $propertyJobType, 'propertyCommunity' => $propertyCommunity, 'reportStatusId' => $reportStatusId, 'firstName' => $array_users[$reported_by]['first_name'], 'lastName' => $array_users[$reported_by]['last_name'], 'reportDate' => $reportDate, 'reported_by' => $reported_by, 'subcontractor' => $subcontractor);
}
}
}
if ($propertyId == 0) {
$propertyId = $_REQUEST['propertyId'];
if (trim($propertyId) != '') {
$placeholder = $propertyId;
$sql = "SELECT\t\n\t\t\t\t\t\t\t\t properties.id\n\t\t\t\t\t\t\t\t,properties.name\n\t\t\t\t\t\t\t\t,properties.address\n\t\t\t\t\t\t\t\t,properties.city\n\t\t\t\t\t\t\t\t,properties.state\n\t\t\t\t\t\t\t\t,properties.map_link\n\t\t\t\t\t\t\t\t,properties.emails\n\t\t\t\t\t\t\t\t,properties.property_type\n\t\t\t\t\t\t\t\t,properties.job_type\n\t\t\t\t\t\t\t\t,properties.community\n\t\t\t\t\t\t\t\t,reports.status_id\n\t\t\t\t\t\t\t\t,reports.date_reported\n\t\t\t\t\t\t\t\t,reports.reported_by\n\t\t\t\t\t\t\t\t,reports.subcontractor\n\t\t\t\t\t\t\tFROM reports\n\t\t\t\t\t\t\tINNER JOIN properties ON properties.id = reports.property_id\n\t\t\t\t\t\t\tWHERE properties.id = ?\n\t\t\t\t\t\t\t";
$placeholder = $propertyId;
if ($stmt = $mysqli->prepare($sql)) {
$stmt->bind_param("i", $placeholder);
if ($stmt->execute()) {
$stmt->bind_result($propertyId, $propertyName, $propertyAddress, $propertyCity, $propertyState, $propertyMapLink, $propertyEmails, $propertyType, $propertyJobType, $propertyCommunity, $reportStatusId, $reportDate, $reported_by, $subcontractor);
while ($stmt->fetch()) {
if ($subcontractor == 1) {
$data = array('propertyId' => $propertyId, 'propertyName' => $propertyName, 'propertyAddress' => $propertyAddress, 'propertyCity' => $propertyCity, 'propertyState' => $propertyState, 'propertyMapLink' => $propertyMapLink, 'propertyEmails' => $propertyEmails, 'propertyType' => $propertyType, 'propertyJobType' => $propertyJobType, 'propertyCommunity' => $propertyCommunity, 'reportStatusId' => $reportStatusId, 'firstName' => $array_sub_contractors[$reported_by]['first_name'], 'lastName' => $array_sub_contractors[$reported_by]['last_name'], 'reportDate' => $reportDate, 'reported_by' => $reported_by, 'subcontractor' => $subcontractor);
} else {
$data = array('propertyId' => $propertyId, 'propertyName' => $propertyName, 'propertyAddress' => $propertyAddress, 'propertyCity' => $propertyCity, 'propertyState' => $propertyState, 'propertyMapLink' => $propertyMapLink, 'propertyEmails' => $propertyEmails, 'propertyType' => $propertyType, 'propertyJobType' => $propertyJobType, 'propertyCommunity' => $propertyCommunity, 'reportStatusId' => $reportStatusId, 'firstName' => $array_users[$reported_by]['first_name'], 'lastName' => $array_users[$reported_by]['last_name'], 'reportDate' => $reportDate, 'reported_by' => $reported_by, 'subcontractor' => $subcontractor);
}
}
}
}
}
}
$stmt->close();
//get estimates
$query = "SELECT MAX(id) AS id FROM estimates WHERE property_id = " . $data['propertyId'];
$estimatesObj = new Dynamo("estimates");
$arrayEstimate = $estimatesObj->customFetchOne($query);
$estimateId = $arrayEstimate['id'];
//GET ROOMS AND ITEMS
$rooms = array();
$roomsSql = "SELECT\n\t\t\t\t\t\t\t report_rooms.id AS roomId\n\t\t\t\t\t\t\t,report_rooms.room_template_id\n\t\t\t\t\t\t\t,report_rooms.name AS roomName\n\t\t\t\t\t\tFROM report_rooms\n\t\t\t\t\t\tWHERE report_rooms.report_id = " . $reportId . "\n\t\t\t\t\t\tORDER BY report_rooms.id\n\t\t\t\t\t";
$rooms = array();
$dynamo = new Dynamo("report_rooms");
//all room information
$rooms = $dynamo->customFetchQuery($roomsSql);
if (count($rooms) > 0) {
//get room ids
$arrayRoomIds = array();
for ($i = 0; $i < count($rooms); $i++) {
$rooms[$i]['roomTemplateId'] = $rooms[$i]['room_template_id'];
$arrayRoomIds[] = $rooms[$i]['roomId'];
$arrayRoomName[] = $rooms[$i]['roomName'];
}
$stringRoomIds = implode(",", $arrayRoomIds);
$stringRoomName = "\"" . implode("\",\"", $arrayRoomName) . "\"";
//get room items
$roomItems = array();
$itemsSql = "SELECT\n\t\t\t\t\t\t\t\t report_room_items.id AS itemId\n\t\t\t\t\t\t\t\t,report_room_items.room_id\n\t\t\t\t\t\t\t\t,report_room_items.room_template_item_id AS itemTemplateId\n\t\t\t\t\t\t\t\t,report_room_items.name AS itemName\n\t\t\t\t\t\t\t\t,report_room_items.status_id AS statusId\n\t\t\t\t\t\t\t\t,report_room_items.is_estimate AS isEstimate\n\t\t\t\t\t\t\t\t,report_status.class AS statusClass\n\t\t\t\t\t\t\t\t,report_status.name AS statusName\n\t\t\t\t\t\t\t\t,room_template_items.work_category_id AS work_category_id\n\t\t\t\t\t\t\tFROM report_room_items\n\t\t\t\t\t\t\t LEFT JOIN report_status \n\t\t\t\t\t\t\t\t\t\t ON report_status.id = report_room_items.status_id\n\t\t\t\t\t\t\tINNER JOIN room_template_items ON room_template_items.id = report_room_items.room_template_item_id\n\t\t\t\t\t\t\tWHERE report_room_items.room_id IN (" . $stringRoomIds . ")\n\t\t\t\t\t\t\tORDER BY report_room_items.name\n\t\t\t\t\t\t";
$roomItems = $dynamo->customFetchQuery($itemsSql);
if (count($roomItems) > 0) {
$query = '';
$itemIdArray = array();
$arrayRoomName = array();
$arrayTemplateId = array();
for ($i = 0; $i < count($roomItems); $i++) {
$itemIdArray[] = $roomItems[$i]['itemId'];
$itemNameArray[] = $roomItems[$i]['itemName'];
$arrayTemplateId[] = $roomItems[$i]['itemTemplateId'];
if ($estimateId > 0 && $roomItems[$i]['isEstimate'] == 0) {
for ($j = 0; $j < count($rooms); $j++) {
if ($rooms[$j]['roomId'] == $roomItems[$i]['room_id']) {
$arrayRoomName[] = $rooms[$j]['roomName'];
//break;
}
}
}
}
if (count($arrayRoomName) > 0) {
//Get estimate line items
$query = "SELECT estimate_room_items_units.id AS estimate_room_items_units_id,\n\t\t\t\t\t\testimate_room_items_units.status_id,room_template_estimates.item_name, \n\t\t\t\t\t\testimate_room_items.room_id,estimate_room_items.room_template_item_id\n\t\t\t\t\t\tFROM estimate_room_items_units INNER JOIN estimate_room_items \n\t\t\t\t\t\tON estimate_room_items_units.estimate_room_items_id = estimate_room_items.id\n\t\t\t\t\t\tINNER JOIN room_template_estimates \n\t\t\t\t\t\tON room_template_estimates.id = estimate_room_items_units.room_template_estimates_id\n\t\t\t\t\t\tINNER JOIN estimate_rooms ON estimate_rooms.id = estimate_room_items_units.room_id\n\t\t\t\t\t\tWHERE estimate_room_items.room_template_item_id IN(" . implode(",", $arrayTemplateId) . ") \n\t\t\t\t\t\tAND estimate_room_items.estimate_id = " . $estimateId . " \n\t\t\t\t\t\tAND estimate_room_items_units.estimate_id = " . $estimateId . " \n\t\t\t\t\t\tAND estimate_rooms.name IN(\"" . implode("\",\"", $arrayRoomName) . "\")";
$array_room_items_unit = array();
$array_room_items_unit = $dynamo->customFetchQuery($query);
for ($i = 0; $i < count($array_room_items_unit); $i++) {
for ($j = 0; $j < count($roomItems); $j++) {
if ($array_room_items_unit[$i]['room_template_item_id'] == $roomItems[$j]['itemTemplateId'] && $roomItems[$j]['itemName'] != $array_room_items_unit[$i]['item_name']) {
//if($array_room_items_unit[$i]['room_template_item_id'] == $roomItems[$j]['itemTemplateId'])
$roomItems[$j]['arrayRoomItemsUnits'][] = $array_room_items_unit[$i];
}
}
}
}
$itemIdString = implode(",", $itemIdArray);
$itemNameString = "\"" . implode("\",\"", $itemNameArray) . "\"";
//GET THE LAST ITEM COMMENT
$commentsSql = "SELECT\n\t\t\t\t\t\t\t\t\t\t report_room_item_comments.id\n\t\t\t\t\t\t\t\t\t\t,report_room_item_comments.comment\n\t\t\t\t\t\t\t\t\t\t,report_room_item_comments.date AS commentDate\n\t\t\t\t\t\t\t\t\t\t,report_room_item_comments.room_item_id\n\t\t\t\t\t\t\t\t\t\t,report_room_item_comments.order\n\t\t\t\t\t\t\t\t\tFROM report_room_item_comments\n\t\t\t\t\t\t\t\t\tWHERE report_room_item_comments.room_item_id IN(" . $itemIdString . ")\n\t\t\t\t\t\t\t\t\tORDER BY report_room_item_comments.`order`";
$arrComments = $dynamo->customFetchQuery($commentsSql);
if (count($arrComments) > 0) {
for ($i = 0; $i < count($arrComments); $i++) {
for ($j = 0; $j < count($roomItems); $j++) {
if ($arrComments[$i]['room_item_id'] == $roomItems[$j]['itemId']) {
$arrComments[$i]['comment'] = str_replace("\"", "'", $arrComments[$i]['comment']);
$arrComments[$i][1] = str_replace("\"", "'", $arrComments[$i][1]);
$roomItems[$j]['comments'][] = $arrComments[$i];
}
}
}
}
//GET THE LAST ITEM IMAGE
$commentsSql = "SELECT\n\t\t\t\t\t\t\t\t\t\t image_name\n\t\t\t\t\t\t\t\t\t\t,date AS imageUploadDate\n\t\t\t\t\t\t\t\t\t\t,room_item_id\n\t\t\t\t\t\t\t\t\t\t,`order`\n\t\t\t\t\t\t\t\t\tFROM report_images\n\t\t\t\t\t\t\t\t\tWHERE room_item_id IN(" . $itemIdString . ")\n\t\t\t\t\t\t\t\t\tORDER BY `order`";
$arrComments = $dynamo->customFetchQuery($commentsSql);
if (count($arrComments) > 0) {
for ($i = 0; $i < count($arrComments); $i++) {
for ($j = 0; $j < count($roomItems); $j++) {
if ($arrComments[$i]['room_item_id'] == $roomItems[$j]['itemId']) {
$roomItems[$j]['images'][$arrComments[$i]['order']][] = $arrComments[$i];
}
}
}
}
$roomNameArray = array();
for ($i = 0; $i < count($roomItems); $i++) {
for ($j = 0; $j < count($rooms); $j++) {
if ($rooms[$j]['roomId'] == $roomItems[$i]['room_id']) {
$roomNameArray[] = $rooms[$j]['roomName'];
}
}
}
if (count($roomNameArray) > 0) {
$roomNameString = "\"" . implode("\",\"", $roomNameArray) . "\"";
//GET ALL THE COMMENTS PER ITEM
$commentsSql = "SELECT\n\t\t\t\t\t\t\t\t\t\t c.id AS itemId\n\t\t\t\t\t\t\t\t\t\t ,i.id AS roomItemId\n\t\t\t\t\t\t\t\t\t\t,i.name AS itemName\n\t\t\t\t\t\t\t\t\t\t,c.comment AS comment\n\t\t\t\t\t\t\t\t\t\t,c.order AS `order`\n\t\t\t\t\t\t\t\t\t\t,c.date AS commentDate\n\t\t\t\t\t\t\t\t\t\t,u.first_name AS firstName\n\t\t\t\t\t\t\t\t\t\t,u.last_name AS lastName\n\t\t\t\t\t\t\t\t\t\t,i.room_template_item_id AS room_template_item_id\n\t\t\t\t\t\t\t\t\t\t,rm.name AS room_name\n\t\t\t\t\t\t\t\t\tFROM report_room_item_comments c\n\t\t\t\t\t\t\t\t\t\t INNER JOIN report_room_items i ON i.id = c.room_item_id\n\t\t\t\t\t\t\t\t\t\t INNER JOIN report_rooms rm ON rm.id = i.room_id\n\t\t\t\t\t\t\t\t\t\t INNER JOIN reports r ON r.id = rm.report_id\n\t\t\t\t\t\t\t\t\t\t INNER JOIN users u ON u.id = c.user_id\n\t\t\t\t\t\t\t\t\tWHERE r.property_id = " . $propertyId . "\n\t\t\t\t\t\t\t\t\t AND i.room_template_item_id IN( " . implode(",", $arrayTemplateId) . ")\n\t\t\t\t\t\t\t\t\t AND r.is_submitted = 1\n\t\t\t\t\t\t\t\t\t AND i.name IN(" . $itemNameString . ")\n\t\t\t\t\t\t\t\t\t AND rm.name IN(" . $roomNameString . ") \n\t\t\t\t\t\t\t\t\t ORDER BY c.order";
$arrComments = $dynamo->customFetchQuery($commentsSql);
if (count($arrComments) > 0) {
for ($i = 0; $i < count($arrComments); $i++) {
for ($j = 0; $j < count($roomItems); $j++) {
if ($arrComments[$i]['room_template_item_id'] == $roomItems[$j]["itemTemplateId"]) {
$arrComments[$i]['commentDate'] = date('m/d/Y g:ia', strtotime($arrComments[$i]['commentDate']));
$roomItems[$j]['comment_thread'][] = $arrComments[$i];
}
}
}
}
$imageSql = "SELECT\n\t\t\t\t\t\t\t\t\t\t\t c.id AS itemId\n\t\t\t\t\t\t\t\t\t\t\t,c.room_item_id AS roomItemId\n\t\t\t\t\t\t\t\t\t\t\t,i.name AS itemName\n\t\t\t\t\t\t\t\t\t\t\t,c.image_name AS imageName\n\t\t\t\t\t\t\t\t\t\t\t,c.order AS `order`\n\t\t\t\t\t\t\t\t\t\t\t,c.date\n\t\t\t\t\t\t\t\t\t\t\t,u.first_name AS firstName\n\t\t\t\t\t\t\t\t\t\t\t,u.last_name AS lastName\n\t\t\t\t\t\t\t\t\t\t\t,i.room_template_item_id AS room_template_item_id\n\t\t\t\t\t\t\t\t\t\t\t,rm.name AS room_name\n\t\t\t\t\t\t\t\t\t\tFROM report_images c\n\t\t\t\t\t\t\t\t\t\t\t INNER JOIN report_room_items i ON i.id = c.room_item_id\n\t\t\t\t\t\t\t\t\t\t\t INNER JOIN report_rooms rm ON rm.id = i.room_id\n\t\t\t\t\t\t\t\t\t\t\t INNER JOIN reports r ON r.id = rm.report_id\n\t\t\t\t\t\t\t\t\t\t\t INNER JOIN users u ON u.id = c.user_id\n\t\t\t\t\t\t\t\t\t\tWHERE r.property_id = " . $propertyId . "\n\t\t\t\t\t\t\t\t\t\t AND i.room_template_item_id IN( " . implode(",", $arrayTemplateId) . ")\n\t\t\t\t\t\t\t\t\t\t AND r.is_submitted = 1\n\t\t\t\t\t\t\t\t\t\t AND i.name IN(" . $itemNameString . ")\n\t\t\t\t\t\t\t\t\t\t AND rm.name IN(" . $roomNameString . ")\n\t\t\t\t\t\t\t\t\t\t ORDER BY c.order";
$arrComments = $dynamo->customFetchQuery($imageSql);
if (count($arrComments) > 0) {
for ($i = 0; $i < count($arrComments); $i++) {
for ($j = 0; $j < count($roomItems); $j++) {
if ($arrComments[$i]['room_template_item_id'] == $roomItems[$j]["itemTemplateId"]) {
$arrComments[$i]['imageUploadDate'] = date('m/d/Y g:ia', strtotime($arrComments[$i]['date']));
$roomItems[$j]['image_thread'][] = $arrComments[$i];
}
}
}
}
}
for ($i = 0; $i < count($roomItems); $i++) {
for ($j = 0; $j < count($rooms); $j++) {
if ($rooms[$j]['roomId'] == $roomItems[$i]['room_id']) {
if (!$roomItems[$i]['arrayRoomItemsUnits']) {
$roomItems[$i]['arrayRoomItemsUnits'] = array();
}
if (!$roomItems[$i]['comments']) {
$roomItems[$i]['comments'] = array();
}
if (!$roomItems[$i]['images']) {
$roomItems[$i]['images'] = array();
}
if (!$roomItems[$i]['comment_thread']) {
$roomItems[$i]['comment_thread'] = array();
}
if (!$roomItems[$i]['image_thread']) {
$roomItems[$i]['image_thread'] = array();
}
$rooms[$j]['items'][] = $roomItems[$i];
}
}
}
}
$data['rooms'] = $rooms;
}
//GET REPORT COMMENTS
$sqlReportComment = "SELECT\t\n\t\t\t\t\t\t\t\t\t report_comments.id,\n\t\t\t\t\t\t\t\t\t report_comments.comment,\n\t\t\t\t\t\t\t\t\t users.first_name,\n\t\t\t\t\t\t\t\t\t users.last_name,\n\t\t\t\t\t\t\t\t\t report_comments.date,\n\t\t\t\t\t\t\t\t\t reports.is_submitted,\n\t\t\t\t\t\t\t\t\t reports.is_saved\n\t\t\t\t\t\t\t\tFROM report_comments\n\t\t\t\t\t\t\t\t\t INNER JOIN users ON users.id = report_comments.user_id\n\t\t\t\t\t\t\t\t\t INNER JOIN reports ON reports.id = report_comments.report_id\n\t\t\t\t\t\t\t\tWHERE report_comments.property_id=?\n\t\t\t\t\t\t\t\t";
$arrReportComments = array();
if ($reportCommentStmt = $mysqli->prepare($sqlReportComment)) {
$reportCommentStmt->bind_param("i", $propertyId);
if ($reportCommentStmt->execute()) {
$reportCommentStmt->bind_result($reportCommentId, $reportComment, $reportCommentFirstName, $reportCommentLastName, $reportCommentDate, $reportIsSubmitted, $reportIsSaved);
$reportCommentStmt->store_result();
$reportCommentsCtr = 0;
while ($reportCommentStmt->fetch()) {
$arrReportComments[$reportCommentsCtr] = array('id' => $reportCommentId, 'comment' => $reportComment, 'user' => $reportCommentFirstName . ' ' . $reportCommentLastName, 'date' => date('m/d/Y g:ia', strtotime($reportCommentDate)), 'isSubmitted' => $reportIsSubmitted, 'isSaved' => $reportIsSaved);
$reportCommentsCtr++;
}
$reportCommentStmt->free_result();
$reportCommentStmt->close();
}
}
$data['reportComments'] = $arrReportComments;
//REPORT
$reportDateSql = "SELECT date_reported FROM reports WHERE property_id=? ORDER BY date_reported ASC LIMIT 1";
if ($reportDateStmt = $mysqli->prepare($reportDateSql)) {
$reportDateStmt->bind_param("i", $propertyId);
if ($reportDateStmt->execute()) {
$reportDateStmt->bind_result($reportFirstDate);
$reportDateStmt->store_result();
$reportDateStmt->fetch();
$data['firstReportDate'] = $reportFirstDate;
$reportDateStmt->free_result();
$reportDateStmt->close();
}
}
$result['success'] = true;
$result['data'] = $data;
} else {
$result['message'] = "Sorry, there has been a problem processing your request.";
}
$mysqli->close();
if ($isJson) {
header('Content-type: application/json');
echo json_encode($result);
} else {
return $data;
}
}
if (trim($estimatesArray["property_id"]) != '') {
$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) {
define('__BASENAME__', basename(__ROOT__));
require_once __ROOT__ . '/modules/Dynamo.class.php';
$result['success'] = false;
$result['message'] = '';
$propertyId = isset($_POST['propertyId']) ? $_POST['propertyId'] : 0;
$complexPropertyId = isset($_POST['complexPropertyId']) ? $_POST['complexPropertyId'] : 0;
$userId = isset($_POST['userId']) ? $_POST['userId'] : 0;
//add community reports
if ($propertyId > 0 && $complexPropertyId > 0) {
$complex_reports_obj = new Dynamo("complex_reports");
$complex_reports_array = $complex_reports_obj->getAll("WHERE property_id = " . $complexPropertyId);
$community_reports_obj = new Dynamo("community_reports");
$complex_report_rooms_obj = new Dynamo("complex_report_rooms");
$community_report_rooms_obj = new Dynamo("community_report_rooms");
$complex_report_room_items_obj = new Dynamo("complex_report_room_items");
$community_report_room_items_obj = new Dynamo("community_report_room_items");
if (count($complex_reports_array) > 0) {
$query = "INSERT INTO community_reports(`id`,`property_id`,`date_reported`,`status_id`,`reported_by`,`is_submitted`,`is_saved`,`is_closed`) VALUES";
$community_reports_id = $community_reports_obj->getMaxId();
$community_report_rooms_id = $community_report_rooms_obj->getMaxId();
$community_report_room_items_id = $community_report_room_items_obj->getMaxId();
for ($i = 0; $i < count($complex_reports_array); $i++) {
$query .= "({$community_reports_id},{$propertyId},NOW(),0,{$userId},0,0,0),";
$complex_report_rooms_array = $complex_report_rooms_obj->getAll("WHERE report_id = " . $complex_reports_array[$i]["id"]);
$complex_report_room_items_array = $complex_report_room_items_obj->getAll("WHERE report_id = " . $complex_reports_array[$i]["id"]);
if (count($complex_report_rooms_array) > 0) {
//add report rooms
if (trim($query2) == '') {
$query2 = "INSERT INTO community_report_rooms(`id`,`report_id`,`room_template_id`,`name`,`date_created`,`created_by`) VALUES";
}
//add report room items
<?php
require_once dirname(dirname(dirname(__FILE__))) . '/modules/Property.class.php';
require_once dirname(dirname(dirname(__FILE__))) . '/modules/Dynamo.class.php';
$propertyObj = new Property();
$listProperties = array();
if ($propertyObj) {
$listProperties = $propertyObj->getArchivedProperties(false);
}
$report_images = new Dynamo("report_images");
$array_property_images = $report_images->getAll("WHERE property_image = 1");
if (count($array_property_images) > 0) {
$array_property_images2 = array();
for ($i = 0; $i < count($array_property_images); $i++) {
$array_property_images2[$array_property_images[$i]['property_id']] = $array_property_images[$i];
}
$array_property_images = $array_property_images2;
}
?>
<div class="pull-left"><h4>Archived Properties</h4></div>
<div class="pull-right">
<form id="searchPropertyForm" method="POST" onsubmit="return false">
<input type="text" name="searchProperties" id="searchProperties" class="input-large search-query" placeholder="Search Archived Properties" />
<div id="loading_search_archives_image"><img src="images/loading.gif" /></div><div class="clearfix"></div>
<input type="hidden" id="baseName" name="baseName" value="<?php
echo __BASENAME__;
?>
" />
</form>
</div>
<?php
require_once dirname(dirname(__FILE__)) . '/modules/Dynamo.class.php';
$result['success'] = false;
$result['message'] = '';
$report_room_items = new Dynamo("report_room_items");
if (trim($_REQUEST['roomId']) != '') {
$arrayRoomItemsId = $report_room_items->customFetchQuery("SELECT id FROM report_room_items WHERE room_id = " . $_REQUEST['roomId'] . " AND status_id = 2");
$report_room_items->customExecuteQuery("UPDATE report_room_items SET status_id = 1 WHERE room_id = " . $_REQUEST['roomId'] . " AND status_id = 2");
if (count($arrayRoomItemsId) > 0) {
$arrayRoomItemsId2 = array();
for ($i = 0; $i < count($arrayRoomItemsId); $i++) {
$arrayRoomItemsId2[] = $arrayRoomItemsId[$i]['id'];
}
$result['success'] = true;
$result['message'] = $arrayRoomItemsId2;
} else {
$result['success'] = false;
$result['message'] = "All pending items have already been marked as complete";
}
} else {
$result['success'] = false;
$result['message'] = "Oops, there's a problem with these line items";
}
header('Content-type: application/json');
echo json_encode($result);
<?php
if (!isset($_SESSION)) {
session_start();
}
define('__ROOT__', dirname(dirname(__FILE__)));
define('__BASENAME__', basename(__ROOT__));
require_once __ROOT__ . '/modules/Dynamo.class.php';
$community_properties_object = new Dynamo("community_properties");
$community_reports_object = new Dynamo("community_reports");
$community_report_rooms_object = new Dynamo("community_report_rooms");
$community_report_room_items_object = new Dynamo("community_report_room_items");
$community_report_room_item_comments = new Dynamo("community_report_room_item_comments");
$result['success'] = false;
$result['message'] = '';
if (trim($_REQUEST['community']) != '' && trim($_REQUEST['jobType']) != '' && trim($_REQUEST['propertyType']) != '' && trim($_REQUEST['city']) != '' && trim($_REQUEST['zip']) != '' && trim($_REQUEST['emails']) != '' && trim($_REQUEST['id']) != '') {
$_REQUEST['state'] = null;
$_REQUEST['property_type'] = $_REQUEST['propertyType'];
$_REQUEST['job_type'] = $_REQUEST['jobType'];
$_REQUEST['created_by'] = $_REQUEST['userId'];
$_REQUEST['emails'] = $_REQUEST['emails'];
$community_properties_array = $community_properties_object->getOne();
$_REQUEST['date_created'] = $community_properties_array["date_created"];
if ($community_properties_object->edit()) {
$result['success'] = true;
$result['message'] = 'Community successfully edited!';
if (trim($_REQUEST['data']) != '') {
$_REQUEST['property_id'] = $_REQUEST['id'];
$_REQUEST['date_reported'] = date("Y-m-d H:i:s", time());
$_REQUEST['status_id'] = 0;
$_REQUEST['user_id'] = $_REQUEST['created_by'] = $_REQUEST['reported_by'] = $_REQUEST['userId'];
$complex_reports_obj = new Dynamo("complex_reports");
$complex_reports_array = $complex_reports_obj->getOneWhere("property_id = " . $complex_properties_array["id"]);
$_REQUEST['date_reported'] = date("Y-m-d H:i:s");
$_REQUEST['status_id'] = $_REQUEST['is_submitted'] = $_REQUEST['is_closed'] = $_REQUEST['subcontractor'] = 0;
$_REQUEST['is_saved'] = 1;
$_REQUEST['report_id'] = $community_report_id = $reports_obj->getMaxId();
if ($reports_obj->add()) {
$report_rooms_obj = new Dynamo("report_rooms");
$report_rooms_max_id = $report_rooms_obj->getMaxId();
$complex_report_rooms_obj = new Dynamo("complex_report_rooms");
$complex_report_rooms_array = $complex_report_rooms_obj->getAll("WHERE report_id = " . $complex_reports_array["id"] . " ORDER BY id");
if (count($complex_report_rooms_array) > 0) {
$query = "INSERT INTO report_rooms (`id`,`report_id`,`room_template_id`,`name`,`date_created`,`created_by`) VALUES";
$complex_report_room_items_obj = new Dynamo("complex_report_room_items");
$complex_report_room_items_array = $complex_report_room_items_obj->getAll("WHERE report_id = " . $complex_report_rooms_array[0]["report_id"] . " ORDER BY id");
$report_room_items_obj = new Dynamo("report_room_items");
$report_room_items_max_id = $report_room_items_obj->getMaxId();
if (count($complex_report_room_items_array) > 0) {
$query2 = "INSERT INTO report_room_items (`id`,`report_id`,`room_id`,`room_template_item_id`,`name`,`status_id`,`date_created`) VALUES";
}
for ($i = 0; $i < count($complex_report_rooms_array); $i++) {
$query .= "({$report_rooms_max_id}," . $_REQUEST['report_id'] . "," . $complex_report_rooms_array[$i]["room_template_id"] . ",'" . addslashes(stripslashes($complex_report_rooms_array[$i]["name"])) . "',NOW()," . $_SESSION['user_id'] . "),";
for ($j = 0; $j < count($complex_report_room_items_array); $j++) {
if ($complex_report_room_items_array[$j]["room_id"] == $complex_report_rooms_array[$i]["id"]) {
$query2 .= "({$report_room_items_max_id}," . $_REQUEST['report_id'] . ",{$report_rooms_max_id}," . $complex_report_room_items_array[$j]["room_template_item_id"] . ",'" . addslashes(stripslashes($complex_report_room_items_array[$j]["name"])) . "'," . $complex_report_room_items_array[$j]["status_id"] . ",NOW()),";
$report_room_items_max_id += 1;
}
}
$report_rooms_max_id += 1;
}
if (trim($query) != '') {
<?php
if (!isset($_SESSION)) {
session_start();
}
define('__ROOT__', dirname(dirname(__FILE__)));
define('__BASENAME__', basename(__ROOT__));
require_once __ROOT__ . '/modules/Dynamo.class.php';
$result['success'] = false;
$result['message'] = '';
$work_category_estimates_obj = new Dynamo("work_category_estimates");
if (trim($_POST['data']) != '') {
$arrayData = json_decode($_POST['data']);
if (count($arrayData) > 0) {
$query = "DELETE FROM work_category_estimates WHERE work_category_id = " . $_POST['work_category_id'];
$work_category_estimates_obj->customExecuteQuery($query);
$maxId = $work_category_estimates_obj->getMaxId();
$query = "INSERT INTO work_category_estimates VALUES";
for ($i = 0; $i < count($arrayData); $i++) {
$query .= "({$maxId}," . $_POST['work_category_id'] . ",\"" . addslashes(stripslashes($arrayData[$i]->item_name)) . "\",\"" . $arrayData[$i]->price_per_unit . "\"," . $arrayData[$i]->unit_of_measure . ",NOW()),";
$maxId += 1;
}
$query = substr($query, 0, -1);
$work_category_estimates_obj->customExecuteQuery($query);
$result['success'] = true;
$result['message'] = 'Successfully added estimates';
}
}
header('Content-type: application/json');
echo json_encode($result);
<?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) {
?>
<?php
if (!isset($_SESSION)) {
session_start();
}
define('__ROOT__', dirname(dirname(__FILE__)));
define('__BASENAME__', basename(__ROOT__));
require_once __ROOT__ . '/modules/Dynamo.class.php';
$result['success'] = false;
$result['message'] = '';
$id = !isset($_POST['id']) ? "" : $_POST['id'];
if (trim($id) != '') {
$estimate_rooms = new Dynamo("estimate_rooms");
$estimate_room_items_units = new Dynamo("estimate_room_items_units");
if ($estimate_rooms->deleteCustom("WHERE id = " . $id)) {
$query = "DELETE FROM estimate_room_items_units WHERE estimate_room_items_id IN (SELECT id FROM estimate_room_items WHERE room_id = " . $id . ")";
$estimate_room_items_units->customExecuteQuery($query);
$estimate_room_items = new Dynamo("estimate_room_items");
if ($estimate_room_items->deleteCustom("WHERE room_id = " . $id)) {
$result['success'] = true;
$result['message'] = 'Room successfully deleted.';
}
}
}
header('Content-type: application/json');
echo json_encode($result);
}
exit;*/
$roomObj = new Room();
$listRoomTemplates = $roomObj->getRoomTemplates(false);
$reportObj = new Report();
if ($propertyId != 0) {
$propertyObj = new Property();
$propertyInfo = $propertyObj->getPropertyInfo($propertyId, false);
if (!$propertyInfo) {
echo "No property found.";
return;
}
$reportId = $reportObj->getPreviousReportId($propertyId, false);
$reportInfo = $reportObj->getReportDetails($reportId, false);
}
$complex_properties_obj = new Dynamo("complex_properties");
$complex_properties_array = $complex_properties_obj->getAll("ORDER BY id");
?>
<div id="community_left">
<form method="POST" class="form-horizontal" id="addPropertyForm" onsubmit="return false;">
<input type="hidden" id="baseName" name="baseName" value="<?php
echo __BASENAME__;
?>
" />
<input type="hidden" id="userId" name="userId" value="<?php
echo $_SESSION['user_id'];
?>
" />
<div class="pull-left"><h4>Add Community</h4></div>
<div class="clearfix"></div>
if (count($estimateInfo['rooms']) <= 0) {
$reportObj = new Report();
$reportId = $reportObj->getPreviousReportId($propertyId, false);
$reportInfo = $reportObj->getReportDetails($reportId, false);
if (count($reportInfo['rooms']) > 0) {
$estimateInfo = $reportInfo;
$copy_from_report = true;
}
}
if (count($estimateInfo['rooms']) > 0) {
$estimates_obj = new Dynamo("estimates");
$room_templates_obj = new Dynamo("room_templates");
$estimate_rooms_obj = new Dynamo("estimate_rooms");
$estimate_room_items_obj = new Dynamo("estimate_room_items");
$estimate_room_items_units_obj = new Dynamo("estimate_room_items_units");
$room_template_items_obj = new Dynamo("room_template_items");
//get previous room item units
if (!$copy_from_report) {
$estimate_room_items_units_array = $estimate_room_items_units_obj->getAll("WHERE estimate_id = " . $estimatesId);
}
$estimatesId = $_REQUEST['estimatesId'] = $estimates_obj->getMaxId();
$room_template_items_array = $room_template_items_obj->getAll();
$query = "INSERT INTO estimates (`id`,`property_id`,`date_created`,`reported_by`,`is_submitted`,`is_saved`,`is_closed`) \n\t\tVALUES(" . $_REQUEST['estimatesId'] . "," . $estimateInfo['propertyId'] . ",NOW()," . $_SESSION['user_id'] . ",1,0,2)";
$estimates_obj->customExecuteQuery($query);
if (count($estimateInfo['rooms']) > 0) {
$query = "INSERT INTO estimate_rooms VALUES";
$query2 = "INSERT INTO estimate_room_items (`id`,`estimate_id`,`room_id`,`room_template_item_id`,`name`,`date_created`) VALUES";
if (count($estimate_room_items_units_array) > 0) {
$query3 = "INSERT INTO estimate_room_items_units VALUES";
}
$query_first = false;
<?php
if (!isset($_SESSION)) {
session_start();
}
define('__ROOT__', dirname(dirname(__FILE__)));
define('__BASENAME__', basename(__ROOT__));
$result['success'] = false;
$result['message'] = '';
require_once __ROOT__ . '/modules/Dynamo.class.php';
if (trim($_REQUEST['estimate_unit']) != '') {
$unitsObj = new Dynamo("units");
if ($unitsObj->add()) {
$result['success'] = true;
$result['message'] = 'Units successfully added!';
} else {
$result['success'] = false;
$result['message'] = 'Sorry, there has been a problem processing your request.';
}
} else {
$result['success'] = false;
$result['message'] = 'Sorry, there has been a problem processing your request.';
}
header('Content-type: application/json');
echo json_encode($result);
<?php
require_once dirname(dirname(dirname(__FILE__))) . '/modules/Dynamo.class.php';
if (trim($_REQUEST['id']) != '') {
$work_categories = new Dynamo("work_categories");
$work_category = $work_categories->getOne();
$parent_work_categories = $work_categories->getAll("WHERE parent_id = 0");
if (count($work_category) > 0) {
?>
<form method="POST" class="form-horizontal" id="workCategoryForm">
<input type="hidden" id="baseName" name="baseName" value="<?php
echo __BASENAME__;
?>
" />
<input type="hidden" id="id" name="id" value="<?php
print $work_category['id'];
?>
" />
<input type="hidden" id="date_created" name="date_created" value="<?php
print $work_category['date_created'];
?>
" />
<div class="pull-left"><h4>Edit Work Category</h4></div>
<div class="pull-right"><button class="btn btn-warning" type="submit">Submit Changes</button> <a href="work_categories.html" class="btn btn-default">Cancel</a></div>
<div class="clearfix"></div>
<div id="status-message"></div>
<?php
if (count($parent_work_categories) > 0) {
?>
<div class="control-group">
<?php
require_once dirname(dirname(dirname(__FILE__))) . '/modules/Dynamo.class.php';
$dailyLogsObject = new Dynamo("daily_logs");
$propertiesObject = new Dynamo("properties");
$daily_logs_today_progress_object = new Dynamo("daily_logs_today_progress");
$daily_logs_images_object = new Dynamo("daily_logs_images");
if (trim($_REQUEST['estimate']) == "true") {
$estimate = "&estimate=true";
} else {
$estimate = "";
}
if (trim($_REQUEST["id"]) != '') {
$_REQUEST["daily_logs_id"] = $_REQUEST["id"];
$daily_logs_array = $dailyLogsObject->getOne();
} else {
header("Location: add_daily_log.html?propertyId=" . $_REQUEST["propertyId"] . $estimate);
exit;
}
if (trim($_REQUEST["propertyId"]) != '') {
$_REQUEST['id'] = $_REQUEST["propertyId"];
$propertyArray = $propertiesObject->getOne();
} else {
print "You'll need property ID in order to proceed";
exit;
}
?>
<form method="POST" class="form-horizontal" id="addDailyLog">
<input type="hidden" id="baseName" name="baseName" value="<?php
echo __BASENAME__;
?>
if ($j == 0) {
$query = "INSERT INTO estimate_rooms (`id`,`estimate_id`,`room_template_id`,`name`,`date_created`,`created_by`) VALUES";
}
$query .= "({$estimate_room_id},{$estimateId}," . $community_report_rooms[$j]["room_template_id"] . ",\"" . $community_report_rooms[$j]["name"] . "\",NOW()," . $_SESSION['user_id'] . "),";
for ($k = 0; $k < count($community_report_room_items_array); $k++) {
if ($community_report_room_items_array2[$k]['room_id'] == $community_report_rooms[$j]['id']) {
$community_report_room_items_array[$k]['room_id'] = $estimate_room_id;
}
}
$estimate_room_id += 1;
}
if (trim($query) != '') {
$query = substr($query, 0, -1);
$estimatesObj->customExecuteQuery($query);
}
$estimate_room_items = new Dynamo("estimate_room_items");
$count = 0;
$query = '';
for ($j = 0; $j < count($community_report_room_items_array); $j++) {
if ($j == 0 || $count == 0) {
if (trim($query) != '') {
$query = substr($query, 0, -1);
$estimate_room_items->customExecuteQuery($query);
}
$query = "INSERT INTO estimate_room_items (`estimate_id`,`room_id`,`room_template_item_id`,`name`,`date_created`) VALUES";
}
$query .= "({$estimateId}," . $community_report_room_items_array[$j]['room_id'] . "," . $community_report_room_items_array[$j]['room_template_item_id'] . ",\"" . $community_report_room_items_array[$j]['name'] . "\",NOW()),";
if ($j == count($community_report_room_items_array) - 1) {
$query = substr($query, 0, -1);
$estimate_room_items->customExecuteQuery($query);
}
<?php
if (!isset($_SESSION)) {
session_start();
}
define('__ROOT__', dirname(dirname(__FILE__)));
define('__BASENAME__', basename(__ROOT__));
$result['success'] = false;
$result['message'] = '';
require_once __ROOT__ . '/modules/Dynamo.class.php';
if (trim($_REQUEST['estimate_unit']) != '' && trim($_REQUEST['id']) != '') {
$unitsObj = new Dynamo("units");
if ($unitsObj->edit()) {
$result['success'] = true;
$result['message'] = 'Estimate Unit successfully edited!';
} else {
$result['success'] = false;
$result['message'] = 'Sorry, there has been a problem processing your request.';
}
} else {
$result['success'] = false;
$result['message'] = 'Sorry, there has been a problem processing your request.';
}
header('Content-type: application/json');
echo json_encode($result);
?>
- 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
<?php
if (!isset($_SESSION)) {
session_start();
}
if (trim($_SESSION['user_id']) == '') {
exit;
}
define('__ROOT__', dirname(dirname(__FILE__)));
define('__BASENAME__', basename(__ROOT__));
$result['success'] = '';
require_once __ROOT__ . '/modules/Dynamo.class.php';
if (trim($_REQUEST["unit_id"]) != '') {
$estimate_room_items_units_obj = new Dynamo("estimate_room_items_units");
$query = "DELETE FROM estimate_room_items_units WHERE id = " . $_REQUEST["unit_id"];
if ($estimate_room_items_units_obj->customExecuteQuery($query)) {
$result['success'] = true;
}
}
if (trim($result['success']) == '') {
$result['success'] = false;
}
header('Content-type: application/json');
echo json_encode($result);
define('__ROOT__', dirname(dirname(__FILE__)));
define('__BASENAME__', basename(__ROOT__));
require_once __ROOT__ . '/modules/Dynamo.class.php';
require_once __ROOT__ . '/config/main.config.php';
$_REQUEST = $_POST;
if (trim($_REQUEST['email']) != '' && trim($_REQUEST['first_name']) != '' && trim($_REQUEST['last_name']) != '' && trim($_REQUEST['phone_number']) != '' && trim($_REQUEST['id']) != '') {
if (!preg_match(EMAIL_PATTERN, $_REQUEST['email'])) {
$result['success'] = false;
$result['message'] = 'Please enter a valid email address.';
} else {
if ($_REQUEST['password'] != $_REQUEST['passwordConfirm']) {
$result['success'] = false;
$result['message'] = 'Your passwords do not match.';
} else {
$subContractorObj = new Dynamo("sub_contractors");
$sub_contractor_work_category = new Dynamo("sub_contractor_work_category");
$sub_contractor_id = $_REQUEST['id'];
$array_sub_categories = $subContractorObj->getOne();
if (trim($_REQUEST['password']) != '') {
$password = $_REQUEST['password'];
$encryptedPass = base64_encode(mcrypt_encrypt(MCRYPT_RIJNDAEL_256, md5(ENCRYPTION_KEY), $password, MCRYPT_MODE_CBC, md5(md5(ENCRYPTION_KEY))));
$_REQUEST['password'] = $encryptedPass;
} else {
$_REQUEST['password'] = $array_sub_categories['password'];
}
if ($subContractorObj->edit()) {
$sub_contractor_work_category->deleteCustom("WHERE sub_contractor_id = " . $sub_contractor_id);
if (trim($_REQUEST['work_category_id_string']) != '') {
$array_work_category = array();
$work_category_id_string = substr($_REQUEST['work_category_id_string'], 0, -1);
if (stristr($work_category_id_string, ",")) {
$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++) {
if ($daily_logs[$i]['closed'] == 1) {
<?php
require_once 'config/main.config.php';
require_once 'modules/Dynamo.class.php';
require_once 'modules/attach_mailer_class.php';
require_once 'mpdf/mpdf60/mpdf.php';
$subcontractor_emails_obj = new Dynamo("subcontractor_emails");
$array_emails = $subcontractor_emails_obj->getAll("WHERE sent = 0");
$users_obj = new Dynamo("users");
$companyAdminArray = $users_obj->getAll("WHERE user_type = 2 AND is_active = 1");
$email_message = '';
for ($i = 0; $i < count($array_emails); $i++) {
$email_message .= "<h2 style='color:#666;'>Subcontractor Report #" . ($i + 1) . "</h2>";
$email_message .= $array_emails[$i]['emailBody'];
}
$companyAdminEmails = '';
for ($i = 0; $i < count($companyAdminArray); $i++) {
$companyAdminEmails .= $companyAdminArray[$i]['email'] . ",";
}
if (trim($email_message) != '' && trim($companyAdminEmails) != '') {
$companyAdminEmails = substr($companyAdminEmails, 0, -1);
$host_url = "http://" . $_SERVER['HTTP_HOST'] . rtrim(dirname(dirname($_SERVER['PHP_SELF'])), '/\\');
$pdf_file = "mpdf/pdfs/sub_contractor_report.pdf";
@unlink($pdf_file);
@shell_exec("rm -rf " . $pdf_file);
$emailBody_pdf = str_replace("<img src='{$host_url}", "<img src='", str_replace("<img src='{$host_url}/", "<img src='", str_replace("<img src=\"{$host_url}/", "<img src=\"", $email_message)));
preg_match_all("/<img src=[\"\\'](.*?)[\"\\']/i", $emailBody_pdf, $array);
for ($i = 0; $i < count($array[1]); $i++) {
if (!file_exists($array[1][$i])) {
$emailBody_pdf = str_replace($array[1][$i], "", $emailBody_pdf);
}
<?php
require_once dirname(dirname(dirname(__FILE__))) . '/modules/User.class.php';
require_once dirname(dirname(dirname(__FILE__))) . '/modules/Dynamo.class.php';
if ($_SESSION['user_type'] == 1 && trim($_GET['del']) == 'true' && trim($_GET['id']) != '') {
$users_obj = new Dynamo("users");
$query = "DELETE FROM users WHERE id = " . $_GET['id'];
$users_obj->customExecuteQuery($query);
}
$userObj = new User();
$listUsers = array();
$companyId = isset($_SESSION['company_id']) ? $_SESSION['company_id'] : 0;
if ($userObj) {
$userRoleId = isset($_SESSION['user_type']) ? $_SESSION['user_type'] : 0;
if ($userRoleId == 2) {
$listUsers = $userObj->getAllUsersPerCompany($companyId, false);
} else {
$listUsers = $userObj->getAllUsers(false);
}
}
?>
<div class="pull-left"><h4>Users</h4></div>
<div class="pull-right"><a href="add_user.html" class="btn btn-warning"><i class="icon-plus icon-white"></i> Add User</a></div>
<div class="clearfix"></div>
<div id="status-message"></div>
<table id="userTable" class="common-table">
<tr>
<th>Username/Email</th>
<th>Name</th>
<?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__;
?>
}
if (trim($string_community_report) != '') {
$string_community_report = substr($string_community_report, 0, -1);
$query = "DELETE FROM complex_report_rooms WHERE report_id IN ({$string_community_report})";
$complex_reports_obj->customExecuteQuery($query);
$query = "DELETE FROM community_report_room_items WHERE report_id IN({$string_community_report})";
$complex_reports_obj->customExecuteQuery($query);
}
$query = "DELETE FROM complex_properties WHERE id = " . $_GET['id'];
$complex_reports_obj->customExecuteQuery($query);
$query = "DELETE FROM complex_reports WHERE property_id = " . $_GET['id'];
$complex_reports_obj->customExecuteQuery($query);
$query = "DELETE FROM complex_subcontractors_assign WHERE property_id = " . $_GET['id'];
$complex_reports_obj->customExecuteQuery($query);
}
$complex_properties_object = new Dynamo("complex_properties");
$list_complex_properties = array();
if ($complex_properties_object) {
$list_complex_properties = $complex_properties_object->getAll();
}
?>
<div class="pull-left"><h4>Complex List</h4></div>
<div class="pull-right"><a href="add_complexes.html" class="btn btn-warning"><i class="icon-plus icon-white"></i> Add Complex</a></div>
<div class="clearfix"></div>
<div id="status-message"></div>
<table class="common-table">
<?php
if (count($list_complex_properties) > 0) {
?>
<div class="modal-footer-custom">
<button class="btn btn-primary">Create Property</button>
<button class="btn" data-dismiss="modal" aria-hidden="true">Close</button>
</div>
</form>
</div>
<?php
$complex_subcontractors_assign_object = new Dynamo("complex_subcontractors_assign");
$complex_subcontractors_assign_array = $complex_subcontractors_assign_object->getAll("WHERE property_id = " . $_REQUEST['id']);
$community_subcontractors_ids_assign_array = array();
for ($i = 0; $i < count($complex_subcontractors_assign_array); $i++) {
$community_subcontractors_ids_assign_array[$complex_subcontractors_assign_array[$i]['work_category_id']][] = $complex_subcontractors_assign_array[$i]['sub_contractor_id'];
}
$work_categories_object = new Dynamo("work_categories");
$work_categories_array = $work_categories_object->getAll("ORDER BY id");
$sub_contractors_object = new Dynamo("sub_contractors");
$sub_contractors_array = $sub_contractors_object->getAll("INNER JOIN sub_contractor_work_category ON sub_contractors.id = sub_contractor_work_category.sub_contractor_id ORDER BY sub_contractors.first_name");
$work_sub_contractors_array = array();
for ($i = 0; $i < count($sub_contractors_array); $i++) {
if (!is_array($community_subcontractors_ids_assign_array[$sub_contractors_array[$i]['work_category_id']])) {
$community_subcontractors_ids_assign_array[$sub_contractors_array[$i]['work_category_id']] = array();
}
if (in_array($sub_contractors_array[$i]['id'], $community_subcontractors_ids_assign_array[$sub_contractors_array[$i]['work_category_id']])) {
$selected = " checked='checked'";
} else {
$selected = "";
}
$work_sub_contractors_array[$sub_contractors_array[$i]['work_category_id']] .= "<label style='float:left;width:150px;padding-right:20px;white-space:nowrap'><input type=\"checkbox\" class=\"sub_contractor_id_sub\" name='' value='" . $sub_contractors_array[$i]['id'] . "'" . $selected . " /> " . $sub_contractors_array[$i]['first_name'] . " " . $sub_contractors_array[$i]['last_name'] . "</label>";
}
?>
<?php
if (!isset($_SESSION)) {
session_start();
}
require_once dirname(dirname(__FILE__)) . '/modules/Dynamo.class.php';
require_once dirname(dirname(__FILE__)) . '/modules/FileUploader.class.php';
$report_images = new Dynamo("report_images");
$imageId = $report_images->getMaxId();
$uploader = new qqUploadedFileXhr();
$filename = $uploader->getName();
$array_file = explode(".", $filename);
$property_id = $_REQUEST['property_id'] = $_GET['propertyId'];
if (trim($_GET['reportId']) != '') {
$report_id = $_REQUEST['report_id'] = $_GET['reportId'];
$image_filename = $report_id . "_" . $imageId . "." . $array_file[count($array_file) - 1];
} else {
if (trim($_GET['propertyId']) != '') {
$_REQUEST['report_id'] = '';
$image_filename = $property_id . "_" . $imageId . "." . $array_file[count($array_file) - 1];
}
}
$result = $uploader->save(dirname(dirname(__FILE__)) . '/images/report_uploads/' . $image_filename);
if ($result) {
$_REQUEST['image_name'] = $image_filename;
$_REQUEST['date'] = date("Y-m-d H:i:s", time());
$_REQUEST['user_id'] = $_SESSION['user_id'];
$array_images_exist = array();
$array_images_exist = $report_images->getAll("WHERE property_id = " . $property_id);
if (count($array_images_exist) > 0) {
$_REQUEST['property_image'] = 0;
<?php
if (!isset($_SESSION)) {
session_start();
}
define('__ROOT__', dirname(dirname(__FILE__)));
define('__BASENAME__', basename(__ROOT__));
require_once __ROOT__ . '/modules/Dynamo.class.php';
if (trim($_REQUEST['id']) != '') {
$workCategoryObj = new Dynamo("work_categories");
$workCategoryObj->delete($id);
if ($workCategoryObj->delete()) {
$result['success'] = true;
$result['message'] = 'Work Category successfully deleted!';
} else {
$result['success'] = false;
$result['message'] = 'Sorry, there has been a problem processing your request.';
}
} else {
$result['success'] = false;
$result['message'] = 'Sorry, there has been a problem processing your request.';
}
header('Content-type: application/json');
echo json_encode($result);
<?php
require_once dirname(dirname(dirname(__FILE__))) . '/modules/Dynamo.class.php';
$units = new Dynamo("units");
$unitsArray = array();
if ($units) {
$unitsArray = $units->getAll();
}
?>
<div class="pull-left"><h4>Units</h4></div>
<div class="pull-right"><a href="add_unit.html" class="btn btn-warning"><i class="icon-plus icon-white"></i> Add Unit</a></div>
<div class="clearfix"></div>
<div id="status-message"></div>
<div class="container">
<?php
if (count($unitsArray) > 0) {
foreach ($unitsArray as $unit) {
$id = $unit['id'];
$estimate_unit = $unit['estimate_unit'];
?>
<div class="row property-list-row" id="templateRow_<?php
echo $id;
?>
">
<div class="pull-left">
<h2><?php
echo stripslashes($estimate_unit);
?>
</h2>
