function getProject($project_id)
{
$project = [];
$ConnectionManager = new ConnectionManager();
$conn = $ConnectionManager->getConnection();
$stmt = $conn->prepare("SELECT * FROM project WHERE project_id=?");
$stmt->bind_param("s", $project_id);
$stmt->execute();
$stmt->bind_result($project_id, $project_name, $type, $year, $country, $location, $size, $completion_date, $description);
while ($stmt->fetch()) {
$project['project_id'] = $project_id;
$project['project_name'] = $project_name;
$project['type'] = $type;
$project['year'] = $year;
$project['country'] = $country;
$project['location'] = $location;
$project['size'] = $size;
$project['completion_date'] = $completion_date;
$project['description'] = $description;
}
$ConnectionManager->closeConnection($stmt, $conn);
$photoMgr = new PhotoManager();
$photo_arr = $photoMgr->getPhotosByProject($project_id);
$project['photo_arr'] = $photo_arr;
return $project;
}
<?php
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
include_once "./Manager/ConnectionManager.php";
include_once "./Manager/ProductManager.php";
include_once "./Manager/PhotoManager.php";
$photoMgr = new PhotoManager();
$productMgr = new ProductManager();
$product_id = addslashes(filter_input(INPUT_POST, 'selected_product_id'));
$color = addslashes(filter_input(INPUT_POST, 'color'));
$qty = intval(addslashes(filter_input(INPUT_POST, 'qty')));
//$url = filter_input(INPUT_POST, 'url');
//print_r($url);
$stock = $productMgr->getStock($product_id);
session_start();
$userid = null;
$addedQty = 0;
$totalQty = 0;
$qty_update = false;
$cart_data = array();
if (!empty($_SESSION["userid"])) {
// $userid is customer email address
$userid = $_SESSION["userid"];
$cart_data['error_not_logged_in'] = false;
//add product to the shopping cart
if ($productMgr->retrieveItemQtyInShoppingCart($userid, $product_id, $color) > 0) {
$addedQty = $productMgr->retrieveItemQtyInShoppingCart($userid, $product_id, $color);
include_once "./Manager/ProjectManager.php";
include_once "./Manager/PhotoManager.php";
//Get page number from Ajax
if (isset($_POST["page"])) {
$pageNumber = filter_var($_POST["page"], FILTER_SANITIZE_NUMBER_INT, FILTER_FLAG_STRIP_HIGH);
//filter number
if (!is_numeric($pageNumber)) {
die('Invalid page number!');
}
//incase of invalid page number
} else {
$pageNumber = 1;
//if there's no page number, set it to 1
}
$projectMgr = new ProjectManager();
$photoMgr = new PhotoManager();
$itemPerPage = 10;
$results = [];
$filteredProjects = [];
if (isset($_SESSION['filterResults']) && !empty($_SESSION['filterResults'])) {
//get total number of records from database
$filteredProjects = $_SESSION['filterResults'];
$totalNumberProjects = count($filteredProjects);
//break records into pages
$totalPages = ceil($totalNumberProjects / $itemPerPage);
//fetch position of record
$pagePosition = ($pageNumber - 1) * $itemPerPage;
//fetch paginated results
for ($i = $pagePosition; $i < min($pagePosition + $itemPerPage, $totalNumberProjects); $i++) {
array_push($results, $filteredProjects[$i]);
}
<?php
error_reporting(E_ALL);
ini_set('display_errors', 'On');
include_once "./Manager/ConnectionManager.php";
include_once "./Manager/ProductManager.php";
include_once "./Manager/PhotoManager.php";
include_once "./Manager/OrderManager.php";
$productMgr = new ProductManager();
$photoMgr = new PhotoManager();
$orderMgr = new OrderManager();
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
$operation = '';
$operation = filter_input(INPUT_POST, 'operation');
if ($operation === '') {
$operation = $_GET['operation'];
}
if ($operation === "add_product") {
$valid = true;
$product_name = filter_input(INPUT_POST, 'product_name');
$random_no = (string) rand(0, 10000);
$product_id = "AL" . $random_no;
$symbol_code = filter_input(INPUT_POST, 'symbol_code');
if (empty($symbol_code)) {
$symbol_code = '';
}
$price = filter_input(INPUT_POST, 'price');
To change this license header, choose License Headers in Project Properties.
To change this template file, choose Tools | Templates
and open the template in the editor.
-->
<html>
<head>
<?php
if (session_status() != PHP_SESSION_ACTIVE) {
session_start();
}
include_once "./Manager/ConnectionManager.php";
include_once "./Manager/ProjectManager.php";
include_once "./Manager/PhotoManager.php";
$project_id = filter_input(INPUT_GET, 'project_id');
$projectMgr = new ProjectManager();
$photoMgr = new PhotoManager();
$hdImages = $photoMgr->getHDPhotosByid($project_id);
$detailImage = $hdImages[0];
$project = $projectMgr->getProject($project_id);
$completionDate = date_create_from_format('Y-m-d H:i:s', $project['completion_date']);
?>
<meta name="viewport" content="width=device-width, initial-scale=1">
<!-- Latest compiled and minified CSS -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.4/css/bootstrap.min.css">
<link rel="stylesheet" href="http://netdna.bootstrapcdn.com/font-awesome/4.0.3/css/font-awesome.min.css">
<link rel="stylesheet" href="./public_html/css/carouselHome.css">
<link rel="stylesheet" href="./public_html/css/main.css">
<link rel="stylesheet" href="./public_html/css/dmx_style.css">
<style>
.wrapper{
margin-bottom: 30px;
<!DOCTYPE html>
<!--[if IE 8]> <html lang="en" class="ie8"> <![endif]-->
<!--[if IE 9]> <html lang="en" class="ie9"> <![endif]-->
<!--[if !IE]><!--> <html lang="en"> <!--<![endif]-->
<?php
session_start();
include_once "./Manager/ConnectionManager.php";
include_once "./Manager/ProjectManager.php";
include_once "./Manager/PhotoManager.php";
if (isset($_GET['message'])) {
print '<script type="text/javascript">alert("' . $_GET['message'] . '");</script>';
}
$projectMgr = new ProjectManager();
$photoMgr = new PhotoManager();
$projectList = $projectMgr->getAllProjects();
$photoListJson = $photoMgr->getAllPhotosInJson();
?>
<head>
<title>Admin | Issac</title>
<!-- Meta -->
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="description" content="Responsive HTML5 Website landing Page for Developers">
<meta name="author" content="3rd Wave Media">
<link rel="shortcut icon" href="favicon.ico">
<link href='http://fonts.googleapis.com/css?family=Lato:300,400,300italic,400italic' rel='stylesheet' type='text/css'>
<link href='http://fonts.googleapis.com/css?family=Montserrat:400,700' rel='stylesheet' type='text/css'>
<script src="//code.jquery.com/jquery-1.11.0.min.js"></script>
<script type="text/javascript" src="public_html/bootstrap/js/bootstrap.min.js"></script>
}
}
$ids = implode(',', $photos_to_delete);
if (count($photos_to_delete) > 0) {
$query = "DELETE FROM photos WHERE photoid IN ({$ids})";
$result = mysql_query($query, $db_connection);
if (!$result) {
die('Invalid query 4: ' . mysql_error());
}
}
// convert roomurl to photos and clear roomurls whose files dont exist
$query = "SELECT * FROM property WHERE roomurl != ''";
$properties_with_roomurl_result = mysql_query($query, $db_connection);
$missing_files = array();
$converted_roomurls = array();
$pm = new PhotoManager($db_connection, $UPLOAD_DIRECTORY);
while ($property = mysql_fetch_array($properties_with_roomurl_result)) {
$roomurl = $property['roomurl'];
$roomurl = str_replace('http://www.j9accommodation.co.uk/j9/upload/', '', $roomurl);
$roomurl = str_replace('http://www.exceldiving.co.uk/j9/upload/', '', $roomurl);
$roomurl_path = $UPLOAD_DIRECTORY . '/' . $roomurl;
if (!file_exists($roomurl_path) || !is_file($roomurl_path)) {
// file specified by roomurl column doesnt exist so clear it
$query = 'UPDATE property SET roomurl = "" WHERE id = "' . $property['id'] . '"';
$result = mysql_query($query, $db_connection);
if (!$result) {
die('Invalid query 1: ' . mysql_error());
}
array_push($missing_files, $roomurl_path);
} else {
// file exists, so rename it then create thumbnails for it
<?php
require_once 'PhotoManager.php';
require_once 'PhotoManagerWidget.php';
require_once 'connect.php';
require_once 'config.php';
// get property id param
if (array_key_exists('property_id', $_GET)) {
$property_id = $_GET['property_id'];
} else {
$property_id = null;
}
// get db connection
$pm = new PhotoManager($db_connection, $UPLOAD_DIRECTORY);
if ($property_id != null) {
// load photos for property
$photos = $pm->get_photos_for_property($property_id);
$photo_manager_widget = new PhotoManagerWidget($property_id, $photos, $SITE_ROOT);
$photo_manager_widget->render();
}
?>
<br />
<br />
<form action="" method="get">
<input type="text" name="property_id" placeholder="Enter a property ID" /><input type="submit" />
</form>
<table class="table table-bordered table-hover table-striped" id="display_product">
<thead>
<tr>
<th> </th>
<th>Product ID</th>
<th>Product Name</th>
<th>Symbol Code</th>
<th>Price</th>
<th>Color</th>
<th>Stock</th>
<th width="10%">Edit</th>
</tr>
</thead>
<tbody>
<?php
$photoMgr = new PhotoManager();
foreach ($product_list as $product) {
$p_id = $product["product_id"];
$p_name = $product["product_name"];
$p_symbol_code = $product["symbol_code"];
$p_price = $product["price"];
$p_color = $product["color"];
$description = htmlentities($product["description"]);
$p_stock = $product["stock"];
$photo_url_arr = $photoMgr->getPhotos($p_id);
$photo_url_string = str_replace('"', """, str_replace(array("{", "}"), "", json_encode($photo_url_arr)));
$p_color_optional_code_arr = $productMgr->getAllColorOptionalCodeByProduct($p_id);
$p_color_optional_code_string = str_replace('"', """, str_replace(array("{", "}"), "", json_encode($p_color_optional_code_arr)));
?>
<tr>
<td><input type="checkbox" class="productList_id" value="<?php
include_once "./Manager/ProductManager.php";
include_once "./Manager/CreditManager.php";
include_once "./Manager/PhotoManager.php";
// Load the header
$userid = null;
$username = null;
if (!empty($_SESSION["userid"])) {
// $userid is customer email address
$userid = $_SESSION["userid"];
$pos = strpos($userid, "@");
// $username is displayed in the header
$username = substr($userid, 0, $pos);
}
$checkoutList = $_POST;
$productMgr = new ProductManager();
$photoMgr = new PhotoManager();
$list = [];
//var_dump($checkoutList);
foreach ($checkoutList as $checkout) {
$product = $productMgr->getProduct($checkout["productId"]);
$item = [];
$photoList = $photoMgr->getPhotos($product["product_id"]);
$item["product_id"] = $product["product_id"];
$item["product_name"] = $product["product_name"];
$item["color"] = $checkout["color"];
$item["thumbnail"] = $photoList[$item["color"]];
$item["quantity"] = $checkout["quantity"];
$item["price"] = $product["price"];
$item["subtotal"] = $checkout["quantity"] * $product["price"];
$item["add_to_cart_time"] = $checkout["create_time"];
array_push($list, $item);
<?php
error_reporting(E_ALL);
ini_set('display_errors', 'On');
include_once "./Manager/ConnectionManager.php";
include_once "./Manager/ProjectManager.php";
include_once "./Manager/PhotoManager.php";
$projectMgr = new ProjectManager();
$photoMgr = new PhotoManager();
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
$operation = "";
$operation = filter_input(INPUT_POST, 'operation');
if ($operation == "") {
$operation = $_GET['operation'];
}
if ($operation === "create") {
$valid = true;
$random_no = (string) rand(0, 10000);
$project_id = "P" . $random_no;
$project_name = filter_input(INPUT_POST, 'name');
$type = $_POST['type'];
$year = filter_input(INPUT_POST, 'year');
$country = filter_input(INPUT_POST, 'country');
$location = filter_input(INPUT_POST, 'location');
$size = filter_input(INPUT_POST, 'size');
$completion_date = filter_input(INPUT_POST, 'completion_date');
$date = new DateTime($completion_date);
<?php
require_once 'ApiResponses.php';
require_once '../config.php';
if (!array_key_exists('photo_id', $_POST)) {
$response = new ApiResponseFailure('Missing photo id');
$response->render();
}
$photo_id = $_POST['photo_id'];
// get file names from db
require_once '../connect.php';
require_once '../PhotoManager.php';
$pm = new PhotoManager($db_connection, $UPLOAD_DIRECTORY);
$photo = $pm->get_photo_by_id($photo_id);
$photo->delete();
$response = new ApiResponseSuccess();
$response->render();
<?php
require_once 'ApiResponses.php';
require_once '../config.php';
if (!array_key_exists('property_id', $_POST) || !array_key_exists('file_contents', $_POST) || !array_key_exists('file_name', $_POST)) {
$response = new ApiResponseFailure('Missing one of the following: file_contents, file_name, property_id');
$response->render();
}
// get file contents and other data
$file_contents = explode(",", $_POST['file_contents']);
$file_contents = $file_contents[1];
$file_contents = str_replace(' ', '+', $file_contents);
$file_contents = base64_decode($file_contents);
$file_name = $_POST['file_name'];
$property_id = $_POST['property_id'];
// add the photo
require_once '../connect.php';
require_once '../PhotoManager.php';
$pm = new PhotoManager($db_connection, $UPLOAD_DIRECTORY);
$file_name = PhotoManager::generate_file_name($file_name);
$written_files = $pm->add_photo($file_name, $file_contents, $property_id);
$response = new ApiResponseFileUploaded($written_files['photo_id'], $written_files['file_name'], $written_files['file_name_medium'], $written_files['file_name_small']);
$response->render();
<!DOCTYPE html>
<!--
To change this license header, choose License Headers in Project Properties.
To change this template file, choose Tools | Templates
and open the template in the editor.
-->
<?php
if (session_status() != PHP_SESSION_ACTIVE) {
session_start();
}
include_once "./Manager/ConnectionManager.php";
include_once "./Manager/ProductManager.php";
include_once "./Manager/PhotoManager.php";
$productMgr = new ProductManager();
$photoMgr = new PhotoManager();
$userid = null;
$username = null;
if (isset($_SESSION["userid"]) && !empty($_SESSION["userid"])) {
// $userid is customer email address
$userid = $_SESSION["userid"];
$pos = strpos($userid, "@");
// $username is displayed in the header
$username = substr($userid, 0, $pos);
$cart_items = $productMgr->retrieveFromShoppingCart($userid);
$cart_total_qty = $productMgr->retrieveTotalNumberOfItemsInShoppingCart($userid);
}
$selected_product_id = addslashes(filter_input(INPUT_GET, 'selected_product_id'));
$selected_product_color = addslashes(filter_input(INPUT_GET, 'color'));
$product_selected = $productMgr->getProduct($selected_product_id);
$selected_product_name = $product_selected['product_name'];
$selected_product_description = $product_selected['description'];
<!DOCTYPE html>
<!--
To change this license header, choose License Headers in Project Properties.
To change this template file, choose Tools | Templates
and open the template in the editor.
-->
<?php
if (session_status() != PHP_SESSION_ACTIVE) {
session_start();
}
include_once "./Manager/ConnectionManager.php";
include_once "./Manager/ProductManager.php";
include_once "./Manager/PhotoManager.php";
$productMgr = new ProductManager();
$photoMgr = new PhotoManager();
$userid = null;
$username = null;
if (isset($_SESSION["userid"]) && !empty($_SESSION["userid"])) {
// $userid is customer email address
$userid = $_SESSION["userid"];
$pos = strpos($userid, "@");
// $username is displayed in the header
$username = substr($userid, 0, $pos);
$cart_items = $productMgr->retrieveFromShoppingCart($userid);
$cart_total_qty = $productMgr->retrieveTotalNumberOfItemsInShoppingCart($userid);
}
?>
<html>
<head>
<meta name="viewport" content="width=device-width, initial-scale=1">
<!-- Latest compiled and minified CSS -->
<!DOCTYPE html>
<!--
To change this license header, choose License Headers in Project Properties.
To change this template file, choose Tools | Templates
and open the template in the editor.
-->
<?php
if (session_status() != PHP_SESSION_ACTIVE) {
session_start();
}
include_once "./Manager/ConnectionManager.php";
include_once "./Manager/ProductManager.php";
include_once "./Manager/PhotoManager.php";
$productMgr = new ProductManager();
$photoMgr = new PhotoManager();
$userid = null;
$username = null;
if (isset($_SESSION["userid"]) && !empty($_SESSION["userid"])) {
// $userid is customer email address
$userid = $_SESSION["userid"];
$pos = strpos($userid, "@");
// $username is displayed in the header
$username = substr($userid, 0, $pos);
$cart_items = $productMgr->retrieveFromShoppingCart($userid);
$cart_total_qty = $productMgr->retrieveTotalNumberOfItemsInShoppingCart($userid);
}
include_once "./protect.php";
?>
<html>
<head>
<meta name="viewport" content="width=device-width, initial-scale=1">
<?php
require_once 'ApiResponses.php';
require_once '../config.php';
if (!array_key_exists('photo_id', $_POST)) {
$response = new ApiResponseFailure('Missing photo_id');
$response->render();
}
require_once '../connect.php';
require_once '../PhotoManager.php';
// get property id from photo
$photo_id = $_POST['photo_id'];
$pm = new PhotoManager($db_connection, $UPLOAD_DIRECTORY);
$photo = $pm->get_photo_by_id($photo_id);
$property_id = $photo->propertyid;
// set default to 0 for all photos for this property
$pm->reset_default_for_property($property_id);
// set photo to default
$pm->set_default($photo_id, 1);
// return successful
$response = new ApiResponseSuccess();
$response->render();
include_once "./Manager/PhotoManager.php";
//Get page number from Ajax
if (isset($_POST["page"])) {
$pageNumber = filter_var($_POST["page"], FILTER_SANITIZE_NUMBER_INT, FILTER_FLAG_STRIP_HIGH);
//filter number
if (!is_numeric($pageNumber)) {
die('Invalid page number!');
}
//incase of invalid page number
} else {
$pageNumber = 1;
//if there's no page number, set it to 1
}
$project_id = filter_input(INPUT_POST, 'project_id');
$projectMgr = new ProjectManager();
$photoMgr = new PhotoManager();
$photoPerPage = 9;
$results = [];
//get total number of records from database
$totalNumberImages = $photoMgr->getTotalNumberOfThumbnailPhotosOfProject($project_id);
//break records into pages
$totalPages = ceil($totalNumberImages / $photoPerPage);
//fetch position of record
$pagePosition = ($pageNumber - 1) * $photoPerPage;
//Fetch part of records using SQL LIMIT clause
$results = $photoMgr->getPaginatedResults($pagePosition, $photoPerPage, $project_id);
//Display fetched records
if (!empty($results)) {
//$_SESSION['results'] = $filteredProjects;
?>
<div id='thumbnails'>
