<?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/Dynamo.class.php';
if ($_SESSION['user_type'] == 1 && trim($_GET['del']) == 'true' && trim($_GET['id']) != '') {
$complex_reports_obj = new Dynamo("complex_reports");
$complex_reports_array = $complex_reports_obj->getAll("WHERE property_id = " . $_GET['id']);
$string_community_report = '';
for ($i = 0; $i < count($complex_reports_array); $i++) {
$string_community_report .= $complex_reports_array[$i]['id'] . ",";
}
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();
}
?>
<?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
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);
$result['success'] = false;
$result['message'] = 'Sorry, there has been a problem processing your request.2';
}
$community_reports_id += 1;
}
if (trim($query) != '') {
$query = substr($query, 0, -1);
$community_reports_obj->customExecuteQuery($query);
}
if (trim($query2) != '') {
$query2 = substr($query2, 0, -1);
$community_report_rooms_obj->customExecuteQuery($query2);
}
if (trim($query3) != '') {
$query3 = substr($query3, 0, -1);
$community_report_room_items_obj->customExecuteQuery($query3);
}
} else {
$result['success'] = false;
$result['message'] = 'Sorry, there has been a problem processing your request.3';
}
} else {
$result['success'] = false;
$result['message'] = 'Sorry, there has been a problem processing your request.4';
}
if (trim($result['message']) == '') {
$result['success'] = true;
$result['message'] = 'The template has been successfully implemented';
}
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';
$result['success'] = false;
$result['message'] = '';
$estimate_room_items_units_obj = new Dynamo("estimate_room_items_units");
$subcontractors_assign_obj = new Dynamo("subcontractors_assign");
if (trim($_REQUEST['propertyId']) != '' && trim($_REQUEST['work_category_id']) != '') {
$query = "DELETE FROM subcontractors_assign WHERE property_id = " . $_REQUEST['propertyId'] . " AND work_category_id = " . $_REQUEST['work_category_id'];
$subcontractors_assign_obj->customExecuteQuery($query);
}
if (trim($_REQUEST['subcontractor_details']) != '') {
$subcontractor_details_array = json_decode($_REQUEST['subcontractor_details']);
if (count($subcontractor_details_array) > 0) {
$query = "INSERT INTO subcontractors_assign (`sub_contractor_id`,`property_id`,`work_category_id`) VALUES";
for ($i = 0; $i < count($subcontractor_details_array); $i++) {
$query .= "(" . $subcontractor_details_array[$i]->subcontractorId . "," . $_REQUEST['propertyId'] . "," . $_REQUEST['work_category_id'] . "),";
}
$query = substr($query, 0, -1);
$subcontractors_assign_obj->customExecuteQuery($query);
}
}
if (trim($_POST['data']) != '') {
$arrayData = json_decode($_POST['data']);
if (count($arrayData) > 0) {
$maxId = $estimate_room_items_units_obj->getMaxId();
<?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"]);
}
}
$mpdf->WriteHTML($emailBody_pdf);
$mpdf->Output($pdf_file);
$estimate_emails = str_replace("\n", "", trim($propertyArray['estimates_emails']));
if (trim($estimate_emails) != '') {
$estimates = new Estimates();
$arrayEmails = explode(",", $estimate_emails);
if (count($arrayEmails) > 0) {
$error = false;
/*for($i=0;$i<count($arrayEmails);$i++)
{
if(!$estimates->validateEmail($arrayEmails[$i]))
$error = true;
}*/
if ($error == false) {
$query = "UPDATE estimates SET is_submitted = 1,is_saved = 0 WHERE id = " . $estimatesId;
$estimates_obj->customExecuteQuery($query);
/*$mailHeaders = "From: Paxis Group <*****@*****.**> \r\n";
$mailHeaders .= "Reply-To: Paxis Group <*****@*****.**>\r\n";
$mailHeaders .= "Return-Path: Paxis Group <*****@*****.**>\r\n";
$mailHeaders .= "Bcc: Wendell Malpas <*****@*****.**>\r\n";
$mailHeaders .= "X-Mailer: PHP v" .phpversion(). "\r\n";
$mailHeaders .= "MIME-Version: 1.0\r\n";
$mailHeaders .= "Content-Type: text/html; charset=utf-8";
mail($estimate_emails,$mailSubject,$emailBody,$mailHeaders);*/
$attachMailer = new attach_mailer("Paxis Group", "*****@*****.**", $estimate_emails, $cc = "", $bcc = "*****@*****.**", $mailSubject, $emailBody);
if (file_exists($pdf_file)) {
$attachMailer->create_attachment_part($pdf_file, "attachment", "application/pdf");
}
$attachMailer->process_mail();
$result['success'] = true;
$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.location.href = "edit_daily_log.html?propertyId=<?php
print $_REQUEST['propertyId'];
?>
&id=<?php
print $_REQUEST['daily_logs_id'];
?>
&success=true<?php
print $estimate;
?>
$result['success'] = false;
$result['message'] = 'Sorry, there has been a problem processing your request.2';
}
$estimate_id += 1;
}
if (trim($query) != '') {
$query = substr($query, 0, -1);
$estimates_obj->customExecuteQuery($query);
}
if (trim($query2) != '') {
$query2 = substr($query2, 0, -1);
$estimate_rooms_obj->customExecuteQuery($query2);
}
if (trim($query3) != '') {
$query3 = substr($query3, 0, -1);
$estimate_room_items_obj->customExecuteQuery($query3);
}
} else {
$result['success'] = false;
$result['message'] = 'Sorry, there has been a problem processing your request.3';
}
} else {
$result['success'] = false;
$result['message'] = 'Sorry, there has been a problem processing your request.4';
}
if (trim($result['message']) == '') {
$result['success'] = true;
$result['message'] = 'The template has been successfully implemented';
}
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/Property.class.php';
require_once __ROOT__ . '/modules/Report.class.php';
require_once __ROOT__ . '/modules/Room.class.php';
require_once __ROOT__ . '/modules/Estimates.class.php';
require_once __ROOT__ . '/modules/Dynamo.class.php';
$result['success'] = false;
$result['message'] = '';
if (trim($_POST['propertyId']) != '') {
require_once "add_estimate.php";
$propertyId = $_POST['propertyId'];
$properties_obj = new Dynamo("properties");
$query = "UPDATE properties SET in_estimates = 3 WHERE id = " . $propertyId;
$properties_obj->customExecuteQuery($query);
/*$query = "UPDATE estimates SET is_closed = 2 WHERE id = ".$estimates_id;
$properties_obj->customExecuteQuery($query);
*/
$query = "UPDATE estimates SET is_closed = 1 WHERE property_id = " . $_POST['propertyId'] . " AND is_closed = 0";
$properties_obj->customExecuteQuery($query);
$result['success'] = true;
$result['message'] = '';
}
header('Content-type: application/json');
echo json_encode($result);
public function updateRoomTemplateInfo($roomTemplateId, $roomTemplateName, $roomTemplateItems, $itemsIdArray, $workCategoryItems)
{
$result['success'] = false;
$result['message'] = '';
//$room_template_estimates = new Dynamo("room_template_estimates");
if (!isset($roomTemplateId) || empty($roomTemplateId)) {
$result['message'] = 'One of the required fields is missing.';
} else {
$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;
}
$updateSql = "UPDATE room_templates\n\t\t\t\t\t\t\t\t SET name = ?\n\t\t\t\t\t\t\t WHERE id = ?";
if ($updateStmt = $mysqli->prepare($updateSql)) {
$updateStmt->bind_param("si", $roomTemplateName, $roomTemplateId);
if ($updateStmt->execute()) {
//get existing items
$query = "SELECT id FROM room_template_items where room_template_id = ?";
if ($stmt = $mysqli->prepare($query)) {
$stmt->bind_param("i", $roomTemplateId);
$stmt->execute();
$stmt->bind_result($id);
$dataCtr = 0;
while ($stmt->fetch()) {
$existing_room_templates_items[$dataCtr] = $id;
$dataCtr++;
}
}
//get changeable estimates
$query = "SELECT id FROM estimates WHERE is_submitted = 0";
if ($stmt = $mysqli->prepare($query)) {
$stmt->execute();
$stmt->bind_result($id);
$dataCtr = 0;
while ($stmt->fetch()) {
$estimateIdArray[$dataCtr] = $id;
$dataCtr++;
}
if (count($estimateIdArray) > 0) {
$estimateIdString = implode(",", $estimateIdArray);
$query = "SELECT id,estimate_id FROM estimate_rooms WHERE estimate_id IN(" . $estimateIdString . ") AND room_template_id = ?";
if ($stmt = $mysqli->prepare($query)) {
$stmt->bind_param("i", $roomTemplateId);
$stmt->execute();
$stmt->bind_result($id, $estimate_id);
$dataCtr = 0;
while ($stmt->fetch()) {
$estimateRoomIdArray[$dataCtr] = array('id' => $id, 'estimate_id' => $estimate_id);
$dataCtr++;
}
}
}
}
//get ids to delete if any
$arrayDel = array_diff($existing_room_templates_items, $itemsIdArray);
if (count($arrayDel) > 0) {
$stringDel = implode(",", $arrayDel);
$deleteSql = "DELETE FROM room_template_items WHERE id IN(" . $stringDel . ")";
if ($deleteStmt = $mysqli->prepare($deleteSql)) {
$deleteStmt->execute();
$deleteStmt->close();
}
$estimate_room_items_obj = new Dynamo("estimate_room_items");
$query = "SELECT id, estimate_id FROM estimate_room_items WHERE room_template_item_id IN(" . $stringDel . ") AND estimate_id IN(" . $estimateIdString . ")";
$estimate_room_items_array = $estimate_room_items_obj->customFetchQuery($query);
for ($i = 0; $i < count($estimate_room_items_array); $i++) {
$query = "DELETE FROM estimate_room_items_units WHERE estimate_id = " . $estimate_room_items_array[$i]['estimate_id'] . " AND estimate_room_items_id = " . $estimate_room_items_array[$i]['id'];
$estimate_room_items_obj->customExecuteQuery($query);
}
$query = "DELETE FROM estimate_room_items WHERE room_template_item_id IN(" . $stringDel . ") AND estimate_id IN(" . $estimateIdString . ")";
if ($deleteStmt = $mysqli->prepare($deleteSql)) {
$deleteStmt->execute();
$deleteStmt->close();
}
}
/*$deleteSql = "DELETE FROM room_template_items WHERE room_template_id=?";
if ($deleteStmt = $mysqli->prepare($deleteSql)) {
$deleteStmt->bind_param("i", $roomTemplateId);
$deleteStmt->execute();
$deleteStmt->close();
}
*/
//insert work categories
if (!empty($workCategoryItems)) {
$listCategoryItems = explode('|', $workCategoryItems);
}
//Insert new items.
if (!empty($roomTemplateItems)) {
$listItems = explode('|', $roomTemplateItems);
if (count($listItems) > 0) {
$isItemsInserted = false;
$countWorkCategory = -1;
foreach ($listItems as $item) {
$countWorkCategory += 1;
if ($itemsIdArray[$countWorkCategory]) {
$insertSql = "UPDATE room_template_items SET room_template_id = ?, name = ?, work_category_id = ? WHERE id = " . $itemsIdArray[$countWorkCategory];
$room_template_items_id = $itemsIdArray[$countWorkCategory];
} else {
$insertSql = "INSERT INTO room_template_items(room_template_id, name, work_category_id, date_created) VALUES(?, ?,?, NOW())";
$room_template_items_obj = new Dynamo('room_template_items');
$query = "SHOW TABLE STATUS LIKE 'room_template_items'";
$roomTemplatesArray = $room_template_items_obj->customFetchQuery($query);
$room_template_items_id = $roomTemplatesArray[0]['Auto_increment'];
if (count($estimateRoomIdArray) > 0) {
$query = "INSERT INTO estimate_room_items(`estimate_id`,`room_id`,`room_template_item_id`,`name`,`date_created`)";
for ($i = 0; $i < count($estimateRoomIdArray); $i++) {
$query .= "VALUES(" . $estimateRoomIdArray[$i]['estimate_id'] . "," . $estimateRoomIdArray[$i]['id'] . "," . $roomTemplatesArray[0]['Auto_increment'] . ",\"" . $item . "\",NOW()),";
}
$query = substr($query, 0, -1);
$room_template_items_obj->customExecuteQuery($query);
}
}
if ($insertStmt = $mysqli->prepare($insertSql)) {
$insertStmt->bind_param("isi", $roomTemplateId, $item, $listCategoryItems[$countWorkCategory]);
if ($insertStmt->execute()) {
/*$query = "SELECT * FROM room_template_estimates WHERE room_template_id = $roomTemplateId AND room_template_items_id = $room_template_items_id";
$array_room_template_estimates = array();
$array_room_template_estimates = $room_template_estimates->customFetchQuery($query);
if(count($array_room_template_estimates) <= 0)
{
$id = $room_template_estimates->getMaxId();
$query = "INSERT INTO room_template_estimates (`id`,`room_template_id`,`room_template_items_id`,`item_name`,`unit_of_measure`,`timestamp`) VALUES($id,$roomTemplateId,$room_template_items_id,\"".addslashes(stripslashes($item))."\",1,NOW())";
$room_template_estimates->customExecuteQuery($query);
}*/
$isItemsInserted = true;
} else {
$isItemsInserted = false;
break;
}
$insertStmt->close();
} else {
$isItemsInserted = false;
break;
}
}
if ($isItemsInserted) {
$result['success'] = true;
$result['message'] = "Room template successfully updated.";
} else {
$result['message'] = "Sorry, there has been a problem processing your request.";
}
}
} else {
$result['success'] = true;
$result['message'] = "Room template successfully updated.";
}
} else {
if (strrpos($mysqli->error, 'Duplicate entry') == false) {
$result['message'] = "The room name you provided already exist.";
} else {
$result['message'] = "Sorry, there has been a problem processing your request.";
}
}
$updateStmt->close();
} else {
//$mysqli->error
$result['message'] = 'Sorry, there has been a problem processing your request.';
}
$mysqli->close();
}
header('Content-type: application/json');
echo json_encode($result);
}
$sub_contractor_id = $subContractorObj->getMaxId();
if ($subContractorObj->add()) {
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, ",")) {
$array_work_category = explode(",", $work_category_id_string);
} else {
$array_work_category[] = $work_category_id_string;
}
$query = "INSERT INTO sub_contractor_work_category VALUES";
for ($i = 0; $i < count($array_work_category); $i++) {
$query .= "({$sub_contractor_id}," . $array_work_category[$i] . ",NOW()),";
}
$query = substr($query, 0, -1);
if ($subContractorObj->customExecuteQuery($query)) {
$result['success'] = true;
$result['message'] = 'Sub contractor successfully added!';
}
} else {
$result['success'] = true;
$result['message'] = 'Sub contractor 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.';
}
}
}
$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);
}
$count += 1;
if ($count >= 100) {
$count = 0;
}
}
} else {
if (count($community_reports_array) > 0) {
$query = "SELECT * FROM report_room_item_comments WHERE report_id = " . $_REQUEST['reportId'] . " AND room_item_id = " . $_REQUEST['itemId'] . " AND \t`order` = " . $_REQUEST['order'];
if (count($report_room_item_comments_object->customFetchQuery($query)) > 0) {
$query = "UPDATE report_room_item_comments SET comment = '" . addslashes(stripslashes($_REQUEST['comment'])) . "' WHERE report_id = " . $_REQUEST['reportId'] . " AND room_item_id = " . $_REQUEST['itemId'] . " AND `order` = " . $_REQUEST['order'];
} else {
$query = "INSERT INTO report_room_item_comments(`comment`,`user_id`,`room_item_id`,`report_id`,`order`,`date`) VALUE('" . addslashes(stripslashes($_REQUEST['comment'])) . "'," . $_SESSION['user_id'] . "," . $_REQUEST['itemId'] . "," . $_REQUEST['reportId'] . "," . $_REQUEST['order'] . ",NOW())";
}
/*if(trim($_REQUEST['addAnotherComment']) == 1)
{
$query = "INSERT INTO report_room_item_comments(`comment`,`user_id`,`room_item_id`,`report_id`,`date`) VALUE('".addslashes(stripslashes($_REQUEST['comment']))."',".$_SESSION['user_id'].",".$_REQUEST['itemId'].",".$_REQUEST['reportId'].",NOW())";
}
else
{
$query = "SELECT * FROM report_room_item_comments WHERE report_id = ".$_REQUEST['reportId']." AND room_item_id = ".$_REQUEST['itemId'];
if(count($report_room_item_comments_object->customFetchQuery($query)) > 0)
{
$query = "UPDATE report_room_item_comments SET comment = '".addslashes(stripslashes($_REQUEST['comment']))."' WHERE report_id = ".$_REQUEST['reportId']." AND room_item_id = ".$_REQUEST['itemId'];
}
else
{
$query = "INSERT INTO report_room_item_comments(`comment`,`user_id`,`room_item_id`,`report_id`,`date`) VALUE('".addslashes(stripslashes($_REQUEST['comment']))."',".$_SESSION['user_id'].",".$_REQUEST['itemId'].",".$_REQUEST['reportId'].",NOW())";
}
}*/
if ($report_room_item_comments_object->customExecuteQuery($query)) {
$result['success'] = true;
} else {
$result['success'] = false;
}
}
header('Content-type: application/json');
echo json_encode($result);
<?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';
$result['success'] = false;
$result['message'] = '';
$room_template_estimates_obj = new Dynamo("room_template_estimates");
if (trim($_POST['data']) != '') {
$arrayData = json_decode($_POST['data']);
if (count($arrayData) > 0) {
$query = "DELETE FROM room_template_estimates WHERE room_template_items_id = " . $_POST['room_template_items_id'];
$room_template_estimates_obj->customExecuteQuery($query);
$maxId = $room_template_estimates_obj->getMaxId();
$query = "INSERT INTO room_template_estimates VALUES";
for ($i = 0; $i < count($arrayData); $i++) {
$query .= "({$maxId}," . $_POST['room_template_id'] . "," . $_POST['room_template_items_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);
$room_template_estimates_obj->customExecuteQuery($query);
$result['success'] = true;
$result['message'] = 'Successfully added estimates';
}
}
header('Content-type: application/json');
echo json_encode($result);
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, ",")) {
$array_work_category = explode(",", $work_category_id_string);
} else {
$array_work_category[] = $work_category_id_string;
}
$query = "INSERT INTO sub_contractor_work_category VALUES";
for ($i = 0; $i < count($array_work_category); $i++) {
$query .= "({$sub_contractor_id}," . $array_work_category[$i] . ",NOW()),";
}
$query = substr($query, 0, -1);
if ($sub_contractor_work_category->customExecuteQuery($query)) {
$result['success'] = true;
$result['message'] = 'Sub contractor successfully edited!';
}
} else {
$result['success'] = true;
$result['message'] = 'Sub contractor successfully edited!';
}
} else {
$result['success'] = false;
$result['message'] = 'Sorry, there has been a problem processing your request.';
}
}
}
} else {
$result['success'] = false;
$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) != '') {
$query = substr($query, 0, -1);
$report_rooms_obj->customExecuteQuery($query);
}
if (trim($query2) != '') {
$query2 = substr($query2, 0, -1);
$report_room_items_obj->customExecuteQuery($query2);
}
}
$result['success'] = true;
$result['message'] = 'The property has been successfully added!';
}
}
} else {
$result['success'] = false;
$result['message'] = 'Sorry, please fill in all the required values';
}
header('Content-type: application/json');
echo json_encode($result);
$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);
}
}
$mpdf = new mPDF('c');
$mpdf->WriteHTML($emailBody_pdf);
$mpdf->Output($pdf_file);
$subject = "Subcontractor Reports for " . date("m/d/Y", time() - 3600);
$attachMailer = new attach_mailer("Paxis Group", "*****@*****.**", $companyAdminEmails, $cc = "", $bcc = "*****@*****.**", $subject, $email_message);
if (file_exists($pdf_file)) {
$attachMailer->create_attachment_part($pdf_file, "attachment", "application/pdf");
}
$attachMailer->process_mail();
//mail($companyAdminEmails,"Subcontractor Reports for ".date("m/d/Y",time()-3600),$email_message,$array_emails[$i]['headers']) or die("Error: There was an error sending mails");
//@mail("*****@*****.**","Subcontractor Reports for " . date("m/d/Y",time()-3600),$email_message,$array_emails[0]['headers']) or die("Error: There was an error sending mails");
}
$query = "UPDATE subcontractor_emails SET sent = 1";
$subcontractor_emails_obj->customExecuteQuery($query);
$query = "SELECT COUNT(*) AS count_emails FROM subcontractor_emails WHERE sent = 1";
$array_sub_contractor_emails = $subcontractor_emails_obj->customFetchQuery($query);
if ($array_sub_contractor_emails[0]['count_emails'] > 3000) {
$query = "DELETE FROM subcontractor_emails WHERE sent = 1";
$subcontractor_emails_obj->customExecuteQuery($query);
}
print "Emails successfully sent";
<?php
require_once dirname(dirname(dirname(__FILE__))) . '/modules/Dynamo.class.php';
if ($_SESSION['user_type'] == 1 && trim($_GET['del']) == 'true' && trim($_GET['id']) != '') {
$community_reports_obj = new Dynamo("community_reports");
$community_reports_array = $community_reports_obj->getAll("WHERE property_id = " . $_GET['id']);
$string_community_report = '';
for ($i = 0; $i < count($community_reports_array); $i++) {
$string_community_report .= $community_reports_array[$i]['id'] . ",";
}
if (trim($string_community_report) != '') {
$string_community_report = substr($string_community_report, 0, -1);
$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();
}
?>
