Ejemplo n.º 1
0
 if ($community_properties_obj->add()) {
     $community_reports_obj = new Dynamo("community_reports");
     $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_saved'] = $_REQUEST['is_closed'] = 0;
     $_REQUEST['report_id'] = $community_report_id = $community_reports_obj->getMaxId();
     if ($community_reports_obj->add()) {
         $community_report_rooms_obj = new Dynamo("community_report_rooms");
         $community_report_rooms_max_id = $community_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 community_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");
             $community_report_room_items_obj = new Dynamo("community_report_room_items");
             $community_report_room_items_max_id = $community_report_room_items_obj->getMaxId();
             if (count($complex_report_room_items_array) > 0) {
                 $query2 = "INSERT INTO community_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 .= "({$community_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 .= "({$community_report_room_items_max_id}," . $_REQUEST['report_id'] . ",{$community_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()),";
                         $community_report_room_items_max_id += 1;
                     }
                 }
                 $community_report_rooms_max_id += 1;
             }
Ejemplo n.º 2
0
				<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>";
}
?>
	
	<div id="editSubcontractorsModal" class="modal hide fade" tabindex="-1" role="dialog" aria-hidden="true">
Ejemplo n.º 3
0
        $query = "DELETE FROM community_report_rooms WHERE report_id IN ({$string_community_report})";
        $community_reports_obj->customExecuteQuery($query);
        $query = "DELETE FROM community_report_room_items WHERE report_id IN({$string_community_report})";
        $community_reports_obj->customExecuteQuery($query);
    }
    $query = "DELETE FROM community_properties WHERE id = " . $_GET['id'];
    $community_reports_obj->customExecuteQuery($query);
    $query = "DELETE FROM community_reports WHERE property_id = " . $_GET['id'];
    $community_reports_obj->customExecuteQuery($query);
    $query = "DELETE FROM community_subcontractors_assign WHERE property_id = " . $_GET['id'];
    $community_reports_obj->customExecuteQuery($query);
}
$community_properties_object = new Dynamo("community_properties");
$list_community_properties = array();
if ($community_properties_object) {
    $list_community_properties = $community_properties_object->getAll();
}
?>

<div class="pull-left"><h4>Community List</h4></div>
<div class="pull-right"><a href="add_community.html" class="btn btn-warning"><i class="icon-plus icon-white"></i> Add Community</a></div>
<div class="clearfix"></div>

<div id="status-message"></div>
<table class="common-table">
<tr>
	<th>Community Name</th>
	<th>Date Created</th>
	<th></th>
    <?php 
if ($_SESSION['user_type'] == 1) {
Ejemplo n.º 4
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
             if (count($complex_report_room_items_array) > 0 && trim($query3) == '') {
                 $query3 = "INSERT INTO community_report_room_items(`id`,`report_id`,`room_id`,`room_template_item_id`,`name`,`status_id`,`date_created`) VALUES";
             }
             for ($j = 0; $j < count($complex_report_rooms_array); $j++) {
                 $query2 .= "({$community_report_rooms_id},{$community_reports_id}," . $complex_report_rooms_array[$j]['room_template_id'] . ",'" . addslashes(stripslashes($complex_report_rooms_array[$j]['name'])) . "',NOW(),{$userId}),";
                 if (count($complex_report_room_items_array) > 0) {
                     for ($k = 0; $k < count($complex_report_room_items_array); $k++) {
                         if ($complex_report_rooms_array[$j]['id'] == $complex_report_room_items_array[$k]['room_id']) {
                             $query3 .= "({$community_report_room_items_id},{$community_reports_id},{$community_report_rooms_id}," . $complex_report_room_items_array[$k]['room_template_item_id'] . ",'" . addslashes(stripslashes($complex_report_room_items_array[$k]['name'])) . "',2,NOW()),";
Ejemplo n.º 5
0
<?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>
Ejemplo n.º 6
0
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;
    } else {
        $_REQUEST['property_image'] = 1;
    }
    $report_images->add();
    ?>
{error:"true",filename:"<?php 
    print $_REQUEST['image_name'];
    ?>
"}
<?php 
} else {
    ?>
{error:"false"}
Ejemplo n.º 7
0
     $community_subcontractors_assign_array = $community_subcontractors_assign_object->getAll("WHERE property_id = " . $community_properties_array['id']);
     //if there are reports there must be rooms
     if (count($community_reports_array) > 0) {
         $report_id = $community_reports_array['id'];
         $community_report_rooms_object = new Dynamo("community_report_rooms");
         $report_rooms_object = new Dynamo("report_rooms");
         //fetch all the report rooms
         $community_report_rooms = $community_report_rooms_object->getAll("WHERE report_id = " . $report_id . " ORDER BY id");
         $community_report_room_items_object = new Dynamo("community_report_room_items");
         $report_room_items_object = new Dynamo("report_room_items");
         //fetch the room items
         $community_report_room_items_array = $community_report_room_items_object->getAll("WHERE report_id = " . $report_id . " ORDER BY room_id");
         //fetch comments
         $community_report_room_item_comments_object = new Dynamo("community_report_room_item_comments");
         $report_room_item_comments_object = new Dynamo("report_room_item_comments");
         $community_report_room_item_comments_array = $community_report_room_item_comments_object->getAll("WHERE report_id = " . $report_id);
     }
 }
 $tools = new Tools();
 for ($i = 0; $i < count($property_array); $i++) {
     //$next_property_id = $properties_object->getMaxId();
     $query = "SHOW TABLE STATUS LIKE 'properties'";
     $property_table_array = $properties_object->customFetchQuery($query);
     $next_property_id = $property_table_array[0]['Auto_increment'];
     $_REQUEST['name'] = addslashes(stripslashes($property_array[$i]->name));
     $_REQUEST['address'] = addslashes(stripslashes($property_array[$i]->lot_address));
     $_REQUEST['map_link'] = addslashes(stripslashes($property_array[$i]->map_link));
     //$tools->convertArrayToRequest($community_properties_array);
     $query = "INSERT INTO properties (`id`,`name`,`address`,`city`,`map_link`,`estimates_multiplier`,`zip`,\n\t\t\t`property_type`,`job_type`,`community`,`date_created`,`status`,`created_by`,`emails`,`estimates_emails`)\n\t\t\tVALUES('" . $next_property_id . "','" . $_REQUEST['name'] . "','" . $_REQUEST['address'] . "','" . addslashes(stripslashes($community_properties_array["city"])) . "'\n\t\t\t,\"" . $_REQUEST['map_link'] . "\",\"" . $community_properties_array["estimates_multiplier"] . "\",\"" . $community_properties_array["zip"] . "\"," . $community_properties_array["property_type"] . "\n\t\t\t," . $community_properties_array["job_type"] . ",'" . addslashes(stripslashes($community_properties_array["community"])) . "',NOW()\n\t\t\t," . $community_properties_array["status"] . "," . $_SESSION['user_id'] . ",\"" . $community_properties_array["emails"] . "\",\"" . $community_properties_array["estimates_emails"] . "\")";
     //end test area
     //add properties
Ejemplo n.º 8
0
<?php

if (!isset($_SESSION)) {
    session_start();
}
require_once dirname(dirname(__FILE__)) . '/modules/Dynamo.class.php';
if (trim($_REQUEST['image_name']) != '') {
    if (stristr($_REQUEST['image_name'], "/")) {
        $array_url = explode("/", $_REQUEST['image_name']);
        $image_name = $array_url[count($array_url) - 1];
    } else {
        $image_name = $_REQUEST['image_name'];
    }
    $report_images = new Dynamo("report_images");
    $array_image = $report_images->getAll("WHERE image_name = \"{$image_name}\"");
    $array_image = $array_image[0];
    if (count($array_image) > 0) {
        $report_images->customExecuteQuery("UPDATE report_images SET property_image = 0 WHERE property_id = " . $array_image["property_id"]);
        $report_images->customExecuteQuery("UPDATE report_images SET property_image = 1 WHERE id = " . $array_image["id"]);
    }
}
Ejemplo n.º 9
0
<?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'] = '';
$room_template_estimates_obj = new Dynamo("room_template_estimates");
$unitsObj = new Dynamo("units");
$units_array = $unitsObj->getAll();
if (trim($_POST['roomTemplateItemsId']) != '') {
    $array_room_template_estimates = $room_template_estimates_obj->getAll("WHERE room_template_items_id = " . $_POST['roomTemplateItemsId'] . " ORDER BY item_name");
    if (count($array_room_template_estimates) > 0) {
        $result['success'] = true;
        //$result['message'] = $array_room_template_estimates;
        $result['message'] = '<div id="accordion" class="panel-group">';
        for ($i = 0; $i < count($array_room_template_estimates); $i++) {
            $result['message'] .= '<div class="panel panel-default">
				<div class="panel-heading">
					 <h4 class="panel-title">
						<a href="#panel' . ($i + 1) . '" data-parent="#accordion" data-toggle="collapse" class="accordion-toggle collapsed"><i class="glyphicon glyphicon-plus"></i>' . $array_room_template_estimates[$i]['item_name'] . '</a> 
					</h4>
		
				</div>
				<div class="panel-collapse collapse" id="panel' . ($i + 1) . '" style="height: 0px;">
					<div class="panel-body">
						 <div class="estimatestemplate_row">			
							<div class="estimatestemplate_left">
Ejemplo n.º 10
0
         } else {
             break;
         }
     }
     $daily_logs_images_object = new Dynamo("daily_logs_images");
     //image upload
     if (trim($_FILES['image_name']['name'][0]) != '') {
         for ($i = 0; $i < count($_FILES['image_name']['name']); $i++) {
             $filename = $_FILES['image_name']['name'][$i] = strtolower($_FILES['image_name']['name'][$i]);
             $file_ext = strrchr($filename, '.');
             $whitelist = array(".jpg", ".jpeg", ".gif", ".png");
             if (!in_array($file_ext, $whitelist)) {
                 die("Please upload either a jpeg, gif or png");
             }
             $_FILES['image_name']['name'][$i] = $tools->replaceBadCharactersImage($_FILES['image_name']['name'][$i]);
             $arrayCheckImageExists = $daily_logs_images_object->getAll("WHERE image_name = \"" . addslashes($_FILES['image_name']['name'][$i]) . "\"");
             if (count($arrayCheckImageExists) > 0) {
                 $_FILES['image_name']['name'][$i] = str_replace(".", time() . ".", $_FILES['image_name']['name'][$i]);
             }
             if (trim($_FILES['image_name']['name'][$i]) != '') {
                 $_FILES['image_name']['name'][$i] = strtolower($_FILES['image_name']['name'][$i]);
             }
             if (move_uploaded_file($_FILES['image_name']['tmp_name'][$i], "images/daily_log_uploads/" . $_FILES['image_name']['name'][$i])) {
                 $query = "INSERT INTO daily_logs_images (`daily_logs_id`,`image_name`,`timestamp`) VALUES(" . $_REQUEST['daily_logs_id'] . ",\"" . addslashes($_FILES['image_name']['name'][$i]) . "\",NOW())";
                 $daily_logs_images_object->customExecuteQuery($query);
             }
         }
     }
 }
 ?>
 <script type="text/javascript">
Ejemplo n.º 11
0
												}
											</script>
										</td>
									</tr>';
                }
                $result['message'] .= '</table>';
            }
            $result['message'] .= '</div>
						</div>
					</div>
				</div>';
        }
        $result['message'] .= '</div>';
        //subcontractors
        if (count($subcontractor_array) > 0) {
            $subcontractors_assign_array_copy = $subcontractors_assign_obj->getAll("WHERE property_id = " . $_REQUEST['propertyId'] . " AND work_category_id = " . $room_template_items_array[0]['work_category_id']);
            $subcontractors_assign_array = array();
            if (count($subcontractors_assign_array_copy) > 0) {
                for ($i = 0; $i < count($subcontractors_assign_array_copy); $i++) {
                    $subcontractors_assign_array[$subcontractors_assign_array_copy[$i]['sub_contractor_id']] = $subcontractors_assign_array_copy[$i];
                }
            }
            $result['message'] .= '<table><tr><td colspan="2"><br />';
            $result['message'] .= '<strong style="font-size:15px;color:#353535;">Please select the subcontractors you\'d like to use:</strong><br />';
            $result['message'] .= '<input type="hidden" name="work_category_id" id="work_category_id" value="' . $room_template_items_array[0]['work_category_id'] . '" />';
            for ($i = 0; $i < count($subcontractor_array); $i++) {
                $result['message'] .= '<label><input type="checkbox" name="subcontractor_id" class="subcontractor_id" value="' . $subcontractor_array[$i]['sub_contractor_id'] . '"' . ($subcontractors_assign_array[$subcontractor_array[$i]['sub_contractor_id']] ? " checked=\"checked\"" : "") . ' /> ' . $subcontractor_array[$i]['first_name'] . " " . $subcontractor_array[$i]['last_name'] . "</label>";
            }
            $result['message'] .= '<br /></td></tr></table>';
        }
        $result['message'] .= '<script type="text/javascript">
Ejemplo n.º 12
0
<?php

if (!isset($_SESSION)) {
    session_start();
}
define('__ROOT__', dirname(dirname(__FILE__)));
define('__BASENAME__', basename(__ROOT__));
require_once __ROOT__ . '/modules/Room.class.php';
require_once __ROOT__ . '/modules/Dynamo.class.php';
$id = !isset($_POST['id']) ? "" : $_POST['id'];
$roomObj = new Room();
$roomObj->deleteCommunityRoom($id);
if (trim($_POST['reportId']) != '') {
    $array_report_rooms = array();
    $community_report_rooms_obj = new Dynamo("community_report_rooms");
    $array_report_rooms = $community_report_rooms_obj->getAll("WHERE report_id = " . $_POST['reportId']);
    if (count($array_report_rooms) <= 0) {
        $query = "DELETE FROM community_reports WHERE id = " . $_POST['reportId'];
        $community_report_rooms_obj->customExecuteQuery($query);
    }
}
Ejemplo n.º 13
0
                        $daily_logs_images_object->customExecuteQuery($query);
                    }
                }
            }
        }
        //image upload
        if (trim($_FILES['image_name']['name'][0]) != '') {
            for ($i = 0; $i < count($_FILES['image_name']['name']); $i++) {
                $filename = $_FILES['image_name']['name'][$i] = strtolower($_FILES['image_name']['name'][$i]);
                $file_ext = strrchr($filename, '.');
                $whitelist = array(".jpg", ".jpeg", ".gif", ".png");
                if (!in_array($file_ext, $whitelist)) {
                    die("Please upload either a jpeg, gif or png");
                }
                $_FILES['image_name']['name'][$i] = $tools->replaceBadCharactersImage($_FILES['image_name']['name'][$i]);
                $arrayCheckImageExists = $daily_logs_images_object->getAll("WHERE image_name = \"" . addslashes($_FILES['image_name']['name'][$i]) . "\"");
                if (count($arrayCheckImageExists) > 0) {
                    $_FILES['image_name']['name'][$i] = str_replace(".", time() . ".", $_FILES['image_name']['name'][$i]);
                }
                if (trim($_FILES['image_name']['name'][$i]) != '') {
                    $_FILES['image_name']['name'][$i] = strtolower($_FILES['image_name']['name'][$i]);
                }
                if (move_uploaded_file($_FILES['image_name']['tmp_name'][$i], "images/daily_log_uploads/" . $_FILES['image_name']['name'][$i])) {
                    $query = "INSERT INTO daily_logs_images (`daily_logs_id`,`image_name`,`timestamp`) VALUES(" . $_REQUEST['daily_logs_id'] . ",\"" . addslashes($_FILES['image_name']['name'][$i]) . "\",NOW())";
                    $daily_logs_images_object->customExecuteQuery($query);
                }
            }
        }
        ?>
        <script type="text/javascript">
			window.onload = function() {
    if (!$propertyInfo) {
        echo "No property found.";
        return;
    }
    $reportObj = new Report();
    $reportInfo = $reportObj->getReportDetails($reportId, false);
    if ($_SESSION['user_type'] == 5) {
        $subcontractors_assign_obj = new Dynamo("subcontractors_assign");
        $subcontractor_array = $subcontractors_assign_obj->getAll("WHERE property_id = " . $propertyId . " AND sub_contractor_id = " . $_SESSION['user_id']);
        $subcontractor_work_category_ids_array = array();
        for ($i = 0; $i < count($subcontractor_array); $i++) {
            $subcontractor_work_category_ids_array[] = $subcontractor_array[$i]['work_category_id'];
        }
    }
    $report_images = new Dynamo("report_images");
    $array_report_images_count = $report_images->getAll("WHERE property_id = " . $propertyId);
    $array_report_images = $report_images->getAllWithId_default("WHERE property_id = " . $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'] . ",";
        }
    }
    ?>
	<!-- ADD REPORT -->
	<form method="POST" class="form-horizontal" id="addReportForm" onSubmit="return false">
	<input type="hidden" id="_BASENAME" name="baseName" value="<?php 
    echo __BASENAME__;
    ?>
" />
	<input type="hidden" id="_USERID" name="userId" value="<?php 
Ejemplo n.º 15
0
 $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) {
         $isClosed = 1;
         $isSaved = 0;
         $isSubmitted = 1;
     } else {
         $isClosed = 0;
Ejemplo n.º 16
0
<?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>
Ejemplo n.º 17
0
        $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) {
    ?>
<tr>
	<th>Complex Name</th>
	<th>Date Created</th>
Ejemplo n.º 18
0
    if (!$propertyInfo) {
        echo "No property found.";
        return;
    }
    $reportObj = new Report();
    $reportInfo = $reportObj->getReportDetails($reportId, false);
    if ($_SESSION['user_type'] == 5) {
        $subcontractors_assign_obj = new Dynamo("subcontractors_assign");
        $subcontractor_array = $subcontractors_assign_obj->getAll("WHERE property_id = " . $propertyId . " AND sub_contractor_id = " . $_SESSION['user_id']);
        $subcontractor_work_category_ids_array = array();
        for ($i = 0; $i < count($subcontractor_array); $i++) {
            $subcontractor_work_category_ids_array[] = $subcontractor_array[$i]['work_category_id'];
        }
    }
    $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'] . ",";
        }
    }
    ?>
	<!-- ADD REPORT -->
	<form method="POST" class="form-horizontal" id="addReportForm" onSubmit="return false">
	<input type="hidden" id="_BASENAME" name="baseName" value="<?php 
    echo __BASENAME__;
    ?>
" />
	<input type="hidden" id="_USERID" name="userId" value="<?php 
Ejemplo n.º 19
0
<?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> &nbsp; <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">
Ejemplo n.º 20
0
         $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;
         $query_second = false;
         $query_third = false;
         $maxIdEstimateRooms = $estimate_rooms_obj->getMaxId();
         $estimateRoomMaxId = $estimate_room_items_obj->getMaxId();
         $estimateRoomItemsUnitsMaxId = $estimate_room_items_units_obj->getMaxId();
         for ($i = 0; $i < count($estimateInfo['rooms']); $i++) {
Ejemplo n.º 21
0
 $_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'];
         $_REQUEST['is_submitted'] = 0;
         $_REQUEST['is_saved'] = 0;
         $_REQUEST['is_closed'] = 0;
         $community_reports_array = $community_reports_object->getAll("WHERE property_id = " . $_REQUEST['property_id']);
         if (count($community_reports_array) <= 0 || !is_array($community_reports_array)) {
             $report_id = $_REQUEST['report_id'] = $community_reports_object->getMaxId();
             if (!$community_reports_object->add()) {
                 $result['success'] = false;
                 $result['message'] = 'Sorry, there has been a problem processing your request.';
             }
         } else {
             $community_reports_array = $community_reports_array[0];
             $report_id = $_REQUEST['report_id'] = $community_reports_array['id'];
         }
         $array_data = json_decode($_REQUEST['data']);
         if (count($array_data) > 0) {
             $community_report_rooms_object->deleteCustom("WHERE report_id = " . $report_id);
             $community_report_room_items_object->deleteCustom("WHERE report_id = " . $report_id);
             $community_report_room_item_comments->deleteCustom("WHERE report_id = " . $report_id);
Ejemplo n.º 22
0
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>

		<div id="status-message"></div>
Ejemplo n.º 23
0
<?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);
        }
Ejemplo n.º 24
0
<?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> &nbsp;<?php 
        if ($_SESSION['user_type'] != 5) {
            ?>
Ejemplo n.º 25
0
<?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__;
    ?>
Ejemplo n.º 26
0
?>
</textarea></p>
       <p>RENTAL EQUIPMENT & MATERIAL DELIVERIES/RETURNS<br />
       <p><textarea name="rental_equipment_material_deliveries" id="rental_equipment_material_deliveries" class="textarea_daily_log" disabled><?php 
if (count($daily_logs_array) > 0) {
    print $daily_logs_array["rental_equipment_material_deliveries"];
}
?>
</textarea></p>
       <p>GENERAL COMMENTS<br />
       <p><textarea name="general_comments" id="general_comments" class="textarea_daily_log" disabled><?php 
if (count($daily_logs_array) > 0) {
    print $daily_logs_array["general_comments"];
}
?>
</textarea></p>	
       <p>
       <div style="width:75%;margin:0 auto;text-align:left;">
           <?php 
$daily_logs_images_array = $daily_logs_images_object->getAll("WHERE daily_logs_id = " . $_REQUEST["daily_logs_id"] . " ORDER BY timestamp");
for ($i = 0; $i < count($daily_logs_images_array); $i++) {
    print "<div style='float:left;padding:10px;'><a href='images/daily_log_uploads/" . $daily_logs_images_array[$i]["image_name"] . "'><img src='images/daily_log_uploads/" . $daily_logs_images_array[$i]["image_name"] . "' style='height:100px;margin-right:5px;margin-bottom:5px;' /></a>\n\t\t\t\t\t<textarea name='image_" . $daily_logs_images_array[$i]['id'] . "' placeholder='ADD IMAGE NOTE' style='width:150px;' disabled='disabled'>" . $daily_logs_images_array[$i]["image_notes"] . "</textarea> \n\t\t\t\t\t</div>";
}
if (count($daily_logs_images_array) > 0) {
    print "<div class='clear'></div>";
}
?>
           </div>
       </p>
       </div>
	<form>
Ejemplo n.º 27
0
require_once dirname(dirname(dirname(__FILE__))) . '/modules/Dynamo.class.php';
require_once dirname(dirname(dirname(__FILE__))) . '/modules/Tools.class.php';
$estimatesId = isset($_GET['estimatesId']) ? $_GET['estimatesId'] : 0;
if ($estimatesId != 0) {
    $estimates_obj = new Dynamo("estimates");
    $estimatesArray = $estimates_obj->getAll("WHERE id = " . $estimatesId);
    $estimatesArray = $estimatesArray[0];
    $propertyId = $estimatesArray['property_id'];
    $arrayOtherEstimates = array();
    $arrayOtherEstimates = $estimates_obj->getAll("WHERE id > " . $estimatesId . " AND property_id = " . $propertyId);
    $users_obj = new Dynamo("users");
    $userArray = $users_obj->getAll("WHERE id = " . $estimatesArray['reported_by']);
    $userArray = $userArray[0];
    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++) {
Ejemplo n.º 28
0
        $user_properties_obj->customExecuteQuery($query);
        $user_properties_id = $user_properties_obj->getMaxId();
        if (count($_POST['propertyId']) > 0) {
            $query = "INSERT INTO user_properties (`id`,`user_id`,`property_id`,`timestamp`) VALUES";
            for ($i = 0; $i < count($_POST['propertyId']); $i++) {
                $query .= "({$user_properties_id}," . $_GET['userId'] . "," . $_POST['propertyId'][$i] . ",NOW()),";
            }
            $query = substr($query, 0, -1);
            $user_properties_obj->customExecuteQuery($query);
        }
    }
    $users_obj = new Dynamo("users");
    $userArray = $users_obj->getAll("WHERE id = " . $_GET['userId']);
    $userArray = $userArray[0];
    $properties_obj = new Dynamo("properties");
    $propertyArray = $properties_obj->getAll("WHERE status = 1");
    $userPropertiesArray = $user_properties_obj->getAll("WHERE user_id = " . $_GET['userId']);
    $userPropertyArray = array();
    for ($i = 0; $i < count($userPropertiesArray); $i++) {
        $userPropertyArray[] = $userPropertiesArray[$i]['property_id'];
    }
    ?>
	<form method="POST" class="form-horizontal" id="addUserForm">
	<div class="pull-left"><h4>Assign Properties to <?php 
    print $userArray["first_name"] . " " . $userArray["last_name"];
    ?>
</h4></div>
	<div class="pull-right"><button class="btn btn-warning" type="submit">Submit Changes</button> &nbsp; <a href="users.html" class="btn btn-default">Cancel</a></div>
	<div class="clearfix"></div>
	
	<div id="status-message"></div>