$result['success'] = false;
$result['message'] = 'Your passwords do not match.';
} else {
$subContractorObj = new Dynamo("sub_contractors");
$sub_contractor_work_category = new Dynamo("sub_contractor_work_category");
$sub_contractor_id = $_REQUEST['id'];
$array_sub_categories = $subContractorObj->getOne();
if (trim($_REQUEST['password']) != '') {
$password = $_REQUEST['password'];
$encryptedPass = base64_encode(mcrypt_encrypt(MCRYPT_RIJNDAEL_256, md5(ENCRYPTION_KEY), $password, MCRYPT_MODE_CBC, md5(md5(ENCRYPTION_KEY))));
$_REQUEST['password'] = $encryptedPass;
} else {
$_REQUEST['password'] = $array_sub_categories['password'];
}
if ($subContractorObj->edit()) {
$sub_contractor_work_category->deleteCustom("WHERE sub_contractor_id = " . $sub_contractor_id);
if (trim($_REQUEST['work_category_id_string']) != '') {
$array_work_category = array();
$work_category_id_string = substr($_REQUEST['work_category_id_string'], 0, -1);
if (stristr($work_category_id_string, ",")) {
$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;
<?php
if (!isset($_SESSION)) {
session_start();
}
define('__ROOT__', dirname(dirname(__FILE__)));
define('__BASENAME__', basename(__ROOT__));
require_once __ROOT__ . '/modules/Dynamo.class.php';
$result['success'] = false;
$result['message'] = '';
$id = !isset($_POST['id']) ? "" : $_POST['id'];
if (trim($id) != '') {
$estimate_rooms = new Dynamo("estimate_rooms");
$estimate_room_items_units = new Dynamo("estimate_room_items_units");
if ($estimate_rooms->deleteCustom("WHERE id = " . $id)) {
$query = "DELETE FROM estimate_room_items_units WHERE estimate_room_items_id IN (SELECT id FROM estimate_room_items WHERE room_id = " . $id . ")";
$estimate_room_items_units->customExecuteQuery($query);
$estimate_room_items = new Dynamo("estimate_room_items");
if ($estimate_room_items->deleteCustom("WHERE room_id = " . $id)) {
$result['success'] = true;
$result['message'] = 'Room successfully deleted.';
}
}
}
header('Content-type: application/json');
echo json_encode($result);
$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);
if (count($array_data) > 0) {
for ($i = 0; $i < count($array_data); $i++) {
$_REQUEST['room_template_id'] = $array_data[$i]->roomTemplateId;
$_REQUEST['name'] = $array_data[$i]->roomName;
$_REQUEST['date_created'] = date("Y-m-d H:i:s", time());
$_REQUEST['room_id'] = $community_report_rooms_object->getMaxId();
if ($community_report_rooms_object->add()) {
for ($j = 0; $j < count($array_data[$i]->roomItems); $j++) {
$roomItems = $array_data[$i]->roomItems;
$_REQUEST['room_template_item_id'] = $roomItems[$j]->roomTemplateItemId;
$_REQUEST['name'] = $roomItems[$j]->name;
$_REQUEST['status_id'] = $roomItems[$j]->statusId;
$_REQUEST['work_category_id'] = $roomItems[$j]->work_category_id;
$_REQUEST['date'] = $_REQUEST['date_created'] = date("Y-m-d H:i:s", time());
$_REQUEST['comment'] = $roomItems[$j]->comment;
<?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'] = '';
if (trim($_REQUEST['property_id']) != '' && trim($_REQUEST['data']) != '') {
$subcontractors_assign = new Dynamo("subcontractors_assign");
$subcontractors_assign->deleteCustom("WHERE property_id = " . $_REQUEST['property_id']);
$array_sub = json_decode($_REQUEST['data']);
for ($i = 0; $i < count($array_sub); $i++) {
$_REQUEST['sub_contractor_id'] = $array_sub[$i]->sub_contractor_id;
$_REQUEST['work_category_id'] = $array_sub[$i]->work_category_id;
$subcontractors_assign->add();
}
$result['success'] = true;
$result['message'] = 'Subcontractors successfully edited!';
} else {
$result['success'] = false;
$result['message'] = '';
}
header('Content-type: application/json');
echo json_encode($result);
