$_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; $community_report_room_items_id = $community_report_room_items_object->getMaxId(); if ($community_report_room_items_object->add()) { if (trim($_REQUEST['comment']) != '') { $_REQUEST['room_item_id'] = $community_report_room_items_id; if ($community_report_room_item_comments->add()) { } 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.'; } } } else { $result['success'] = false; $result['message'] = 'Sorry, there has been a problem processing your request.'; } }
$_REQUEST['date_created'] = date("Y-m-d H:i:s"); $complex_properties_obj = new Dynamo("complex_properties"); $complex_properties_array = $complex_properties_obj->getOne(); $_REQUEST['status'] = $complex_properties_array['status']; $_REQUEST['created_by'] = $complex_properties_array['created_by']; $_REQUEST["reported_by"] = $_SESSION['user_id']; $community_properties_obj = new Dynamo("community_properties"); $_REQUEST['property_id'] = $community_property_id = $community_properties_obj->getMaxId(); 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'] . "),";
$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"} <?php }
$_REQUEST['date_created'] = date("Y-m-d H:i:s", time()); $_REQUEST['room_id'] = $complex_report_rooms_object->getMaxId(); if ($complex_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; $complex_report_room_items_id = $complex_report_room_items_object->getMaxId(); if ($complex_report_room_items_object->add()) { if (trim($_REQUEST['comment']) != '') { $_REQUEST['room_item_id'] = $complex_report_room_items_id; if ($complex_report_room_item_comments->add()) { } 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.'; } } } else { $result['success'] = false; $result['message'] = 'Sorry, there has been a problem processing your request.'; } }
$complex_properties_array = $complex_properties_obj->getOne(); $_REQUEST['date_created'] = $complex_properties_array["date_created"]; $_REQUEST['status'] = $complex_properties_array['status']; $_REQUEST['created_by'] = $complex_properties_array['created_by']; $_REQUEST['reported_by'] = $_REQUEST["updated_by"] = $_SESSION['user_id']; $properties_obj = new Dynamo("properties"); $_REQUEST['property_id'] = $community_property_id = $properties_obj->getMaxId(); if ($properties_obj->add()) { $reports_obj = new Dynamo("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_closed'] = $_REQUEST['subcontractor'] = 0; $_REQUEST['is_saved'] = 1; $_REQUEST['report_id'] = $community_report_id = $reports_obj->getMaxId(); if ($reports_obj->add()) { $report_rooms_obj = new Dynamo("report_rooms"); $report_rooms_max_id = $report_rooms_obj->getMaxId(); $complex_report_rooms_obj = new Dynamo("complex_report_rooms"); $complex_report_rooms_array = $complex_report_rooms_obj->getAll("WHERE report_id = " . $complex_reports_array["id"] . " ORDER BY id"); if (count($complex_report_rooms_array) > 0) { $query = "INSERT INTO report_rooms (`id`,`report_id`,`room_template_id`,`name`,`date_created`,`created_by`) VALUES"; $complex_report_room_items_obj = new Dynamo("complex_report_room_items"); $complex_report_room_items_array = $complex_report_room_items_obj->getAll("WHERE report_id = " . $complex_report_rooms_array[0]["report_id"] . " ORDER BY id"); $report_room_items_obj = new Dynamo("report_room_items"); $report_room_items_max_id = $report_room_items_obj->getMaxId(); if (count($complex_report_room_items_array) > 0) { $query2 = "INSERT INTO report_room_items (`id`,`report_id`,`room_id`,`room_template_item_id`,`name`,`status_id`,`date_created`) VALUES"; } for ($i = 0; $i < count($complex_report_rooms_array); $i++) { $query .= "({$report_rooms_max_id}," . $_REQUEST['report_id'] . "," . $complex_report_rooms_array[$i]["room_template_id"] . ",'" . addslashes(stripslashes($complex_report_rooms_array[$i]["name"])) . "',NOW()," . $_SESSION['user_id'] . "),";
<?php if (!isset($_SESSION)) { session_start(); } define('__ROOT__', dirname(dirname(__FILE__))); define('__BASENAME__', basename(__ROOT__)); $result['success'] = false; $result['message'] = ''; require_once __ROOT__ . '/modules/Dynamo.class.php'; if (trim($_REQUEST['name']) != '') { $workCategoryObj = new Dynamo("work_categories"); if ($workCategoryObj->add()) { $result['success'] = true; $result['message'] = 'Work Category successfully added!'; } else { $result['success'] = false; $result['message'] = 'Sorry, there has been a problem processing your request.'; } } else { $result['success'] = false; $result['message'] = 'Sorry, there has been a problem processing your request.'; } header('Content-type: application/json'); echo json_encode($result);
<?php if (!isset($_SESSION)) { session_start(); } define('__ROOT__', dirname(dirname(__FILE__))); define('__BASENAME__', basename(__ROOT__)); $result['success'] = false; $result['message'] = ''; require_once __ROOT__ . '/modules/Dynamo.class.php'; if (trim($_REQUEST['estimate_unit']) != '') { $unitsObj = new Dynamo("units"); if ($unitsObj->add()) { $result['success'] = true; $result['message'] = 'Units successfully added!'; } else { $result['success'] = false; $result['message'] = 'Sorry, there has been a problem processing your request.'; } } else { $result['success'] = false; $result['message'] = 'Sorry, there has been a problem processing your request.'; } header('Content-type: application/json'); echo json_encode($result);
<?php 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);
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']) != '') { $community_subcontractors_assign = new Dynamo("community_subcontractors_assign"); $community_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; $community_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); /*if(!isset($_SESSION)){ session_start(); } define('__ROOT__', dirname(dirname(__FILE__))); define('__BASENAME__', basename(__ROOT__));
<?php exit; } $_REQUEST['id'] = $_REQUEST["propertyId"]; $propertiesObject = new Dynamo("properties"); $propertyArray = $propertiesObject->getOne(); } else { print "You'll need property ID in order to proceed"; exit; } if (trim($_POST["company"]) != '' && trim($_POST["report_no"]) != '' && trim($_POST["log_date"]) != '' && trim($_POST["project_community"]) != '' && trim($_POST["total_field_workers"]) != '' && trim($_POST["superintendent"]) != '' && trim($_POST["weather"]) != '') { $log_date = strtotime($_REQUEST['log_date']); $_REQUEST['log_date'] = date("Y-m-d", $log_date); $_REQUEST['daily_logs_id'] = $maxId = $dailyLogsObject->getMaxId(); $_REQUEST['user_id'] = $_SESSION['user_id']; if ($dailyLogsObject->add()) { for ($i = 1; $i < 30000; $i++) { if (trim($_REQUEST['notes_' . $i]) != '' || trim($_REQUEST['lot_' . $i]) != '') { $_REQUEST["lot"] = $_REQUEST["lot_" . $i]; $_REQUEST["job_status"] = $_REQUEST["job_status_" . $i]; $_REQUEST["notes"] = $_REQUEST["notes_" . $i]; if ($_REQUEST["weather_delay_" . $i]) { $_REQUEST["weather_delay"] = 1; } else { $_REQUEST["weather_delay"] = 0; } if ($_REQUEST["missed_inspection_" . $i]) { $_REQUEST["missed_inspection"] = 1; } else { $_REQUEST["missed_inspection"] = 0; }
<?php define('__ROOT__', dirname(dirname(__FILE__))); define('__BASENAME__', basename(__ROOT__)); require_once __ROOT__ . '/modules/Dynamo.class.php'; $_REQUEST['date_created'] = date("Y-m-d H:i:s"); if (trim($_REQUEST['email']) != '' && trim($_REQUEST['first_name']) != '' && trim($_REQUEST['last_name']) != '' && trim($_REQUEST['phone_number']) != '') { $subContractorObj = new Dynamo("sub_contractors"); $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!'; }
if ($_REQUEST["site_issues_" . $i]) { $_REQUEST["site_issues"] = 1; } else { $_REQUEST["site_issues"] = 0; } if ($_REQUEST["vendor_mistake_" . $i]) { $_REQUEST["vendor_mistake"] = 1; } else { $_REQUEST["vendor_mistake"] = 0; } if ($_REQUEST["other_" . $i]) { $_REQUEST["other"] = 1; } else { $_REQUEST["other"] = 0; } $daily_logs_today_progress_object->add(); } else { break; } } if (count($_REQUEST) > 0) { foreach ($_REQUEST as $key => $value) { if (stristr($key, "image_")) { if (trim($value) != '') { $query = "UPDATE daily_logs_images SET image_notes = '" . addslashes($value) . "' WHERE id = " . str_replace("image_", "", $key); $daily_logs_images_object->customExecuteQuery($query); } } } } //image upload