<?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(); } ?>