/**
* Fetches all the informations concerning a segment
* and returns them as an associative array
*
* @param string $db the pdo database object
* @param int $id the id of the segment
*
* @return array associative array containing the informations
*/
function getData($db, $id)
{
$query = "SELECT GPSLatitude, GPSLongitude, s.Name, TotalSlotQty, OptionType, p.City, OpenFrom, CloseAt, \n\t\t\t\t\t ena.StreetName, ena.StreetNumber, pt.OptionType, exa.StreetName, wa.StreetName\n\t\t\t\t\t FROM segment AS s \n\t\t\t\t\t LEFT JOIN payment_type as pt\n\t\t\t\t\t ON s.Segment = pt.Segment \n\t\t\t\t\t LEFT JOIN time_open as t\n\t\t\t\t\t ON s.Segment = t.Segment\n\t\t\t\t\t LEFT JOIN entrance_address AS ena\n\t\t\t\t\t ON s.Segment = ena.Segment\n\t\t\t\t\t LEFT JOIN exit_address AS exa\n\t\t\t\t\t ON s.Segment = exa.Segment\n\t\t\t\t\t LEFT JOIN walking_address AS wa\n\t\t\t\t\t ON s.Segment = wa.Segment\n\t\t\t\t\t LEFT JOIN park_lot AS p\n\t\t\t\t\t ON s.Name = p.Name \n\t\t\t\t WHERE s.Segment = :id;";
$sql = $db->prepare($query);
$sql->bindParam(":id", $id, PDO::PARAM_INT);
$sql->execute();
$data = $sql->fetch();
$lat = $data[0];
$long = $data[1];
$name = $data[2];
$slots = $data[3];
$payment = $data[4];
$city = $data[5];
$openingHour = $data[6];
$closingHour = $data[7];
$entrance = $data[8] . " " . $data[9];
$exit = $data[11];
$walking = $data[12];
$payment = $data[10];
$features = getFeatures($db, $id);
if ($slots == -1) {
$slots = "Unknown";
}
$json = array('latitude' => $lat, 'longitude' => $long, 'name' => $name, 'slots' => $slots, 'city' => $city, 'openingHour' => $openingHour, 'closingHour' => $closingHour, 'entrance' => $entrance, 'features' => $features, 'payment' => $payment, 'exit' => $exit, 'walking' => $walking);
return $json;
}
function request()
{
global $app;
$httprequest = new Phalcon\Http\Request();
$datain = $httprequest->get();
$data = array();
foreach ($datain as $key => $value) {
$data[strtolower($key)] = $value;
}
$filter = new \Phalcon\Filter();
$request = $filter->sanitize($data["request"], array("string", "lower"));
$response = null;
switch ($request) {
case "getcapabilities":
$response = getCapabilities();
break;
case "describefeaturetype":
$response = describeFeatureType($data);
break;
case "getfeatures":
$response = getFeatures($data);
break;
case "delete":
$response = delete($data);
break;
case "create":
$response = create($data);
break;
case "update":
$response = update($data);
break;
case "transaction":
$response = transaction($data);
break;
}
$app->response->setContentType('application/json; charset=UTF-8')->sendHeaders();
echo json_encode($response);
}
function request()
{
global $app;
$httprequest = new Phalcon\Http\Request();
$datain = $httprequest->get();
$data = array();
foreach ($datain as $key => $value) {
$data[strtolower($key)] = $value;
}
$filter = new \Phalcon\Filter();
$request = $filter->sanitize($data["request"], array("string", "lower"));
$response = null;
switch ($request) {
case "getcapabilities":
$response = getCapabilities();
break;
case "describefeaturetype":
$response = describeFeatureType($data);
break;
case "getfeatures":
$response = getFeatures($data);
break;
case "delete":
$response = delete($data);
break;
case "create":
$response = create($data);
break;
case "update":
$response = update($data);
break;
case "transaction":
$response = transaction($data);
break;
/* For grouping*/
/* For grouping*/
case "getassoclayers":
$response = getAssocLayers($data);
break;
case "getgrouping":
$response = getGrouping($data);
break;
case "describegrouping":
$response = describeGrouping($data);
break;
case "creategrouping":
$response = createGrouping($data);
break;
case "updategrouping":
$response = updateGrouping($data);
break;
case "deletegrouping":
$response = deleteGrouping($data);
break;
case "getFeaturesFk":
$response = getFeaturesFk($data);
break;
case "duplicategrouping":
$response = duplicateGrouping($data);
break;
case "associatedocument":
$response = associateDocument($data);
break;
case "deletedocument":
$response = deleteDocument($data);
break;
case "downloaddocument":
$response = downloadDocument($data);
echo $response;
break;
case "getdocumentlist":
$response = getDocumentList($data);
break;
case "getdocumentdescription":
$response = getDocumentDescription($data);
break;
default:
$response = false;
break;
}
$app->response->setContentType('application/json; charset=UTF-8')->sendHeaders();
echo json_encode($response);
}
function mapPropertyDetail($propertyDetail, $contentType)
{
global $detailHeaderText;
global $detailImage1;
global $detailReference;
global $detailPrice;
global $detailPrice2;
global $detailLocation;
global $detailType;
global $detailROLType;
global $detailROLSubType;
global $detailBeds;
global $detailBaths;
global $detailPlot;
global $detailArea;
global $detailTerrace;
global $detailEnergy;
global $detailDescription;
global $photoArray;
global $featuresArray;
global $builds;
global $dimension;
global $agencyRef;
global $languageArr;
global $resultOutput;
global $fSearchType;
$resultText = '';
$metaData = '';
switch ($contentType) {
case 1:
if ($propertyDetail !== NULL) {
$metaData = '';
$metaData .= (string) $propertyDetail->Type . ',';
$metaData .= (string) $propertyDetail->Area . ',';
$metaData .= (string) $propertyDetail->Location . ',';
$metaData .= (string) $propertyDetail->Reference . ',';
$metaData .= (string) $propertyDetail->Bedrooms . $languageArr['field_Headings']['bedrooms']['short_Header'] . ',';
$metaData .= (string) $propertyDetail->Bathrooms . $languageArr['field_Headings']['bathrooms']['short_Header'] . ',';
$resultOutput = $metaData;
}
break;
case 2:
if ($propertyDetail !== NULL) {
$detailType = (string) $propertyDetail->Type;
$detailROLType = (string) $propertyDetail->ROLType;
$detailROLSubType = (string) $propertyDetail->ROLSubType;
$detailImage1 = (string) $propertyDetail->Pictures->Picture->PictureURL;
$searchType = 'Resale';
if (isAccessFromFeatureSearch()) {
$searchType = $fSearchType;
} else {
if (isset($_SESSION["SearchType"])) {
$searchType = $_SESSION["SearchType"];
}
}
if ($searchType == 'Resale') {
$detailPrice = (string) $propertyDetail->Price;
$detailPrice2 = '';
} else {
$detailPrice = (string) $propertyDetail->RentalPrice1;
$detailPrice2 = (string) $propertyDetail->RentalPrice2;
}
$detailArea = (string) $propertyDetail->Area;
$detailLocation = (string) $propertyDetail->Location;
$detailReference = (string) $propertyDetail->Reference;
$detailDescription = (string) $propertyDetail->Description;
$detailBeds = (string) $propertyDetail->Bedrooms;
$detailBaths = (string) $propertyDetail->Bathrooms;
$detailTerrace = (string) $propertyDetail->Terrace;
$detailPlot = (string) $propertyDetail->GardenPlot;
if (isset($propertyDetail->EnergyRating->Value) && (string) $propertyDetail->EnergyRating->Value != '') {
$detailEnergy = (string) $propertyDetail->EnergyRating->Value . ' ' . (string) $propertyDetail->EnergyRating->Rated;
} else {
$detailEnergy = '';
}
$detailHeaderText = str_replace('{i}', $detailBeds, $languageArr['detail_Headings']['detail_Title']);
$detailHeaderText = str_replace('{t}', $detailType, $detailHeaderText);
$detailHeaderText = str_replace('{l}', $detailLocation, $detailHeaderText);
$builds = (string) $propertyDetail->Built;
$dimension = (string) $propertyDetail->Dimensions;
$agencyRef = (string) $propertyDetail->AgencyRef;
$photoArray = getPhotos($propertyDetail->Pictures);
$featuresArray = getFeatures($propertyDetail->PropertyFeatures);
$resultText .= drawPropertyDetail();
} else {
$resultText .= "<br /><br />" . $languageArr['results_Headings']['no_Result'];
}
$resultOutput = $resultText;
break;
}
return $resultOutput;
}
$ret = $value->nodeValue;
}
return $ret;
}
function getDetails($result)
{
$html = new DOMDocument();
$html->loadHTML($result);
$xpath = new DOMXPath($html);
$details = $xpath->query("//div[@class='detailssubbox']");
$i = 0;
$ret = "";
foreach ($details as $value) {
$i++;
if ($i == 3) {
$ret = $value->nodeValue;
}
}
return $ret;
}
$title = getTitle($result);
$img = getImg($result, $title[0]);
$MRP = getMRP($result);
$offer = getOfferPrice($result);
$features = getFeatures($result);
$details = getDetails($result);
$myfile = fopen("results.txt", "w") or die("Unable to open file!");
$write = $img . "~" . $title . "~" . $MRP . "~" . $offer . "~" . $features . "~" . $details;
echo $write;
fwrite($myfile, $write);
fclose($myfile);
} else {
$review_id = $_SESSION["review_id"];
}
require '../model/reviews.php';
echo "<!-- Get the review -->";
$review = getReviewById($review_id);
$_SESSION["game_id"] = $review["game_id"];
require '../model/comments.php';
echo "<!-- Get associated comments -->";
$comments = getCommentsByReview($review_id);
require '../model/genres.php';
echo "<!-- Get associated genres -->";
$genres = getGenres();
require '../model/features.php';
echo "<!-- Get features -->";
$features = getFeatures();
$title = "Comparative Review - " . $review["game"] . " Review";
include '../../view/head.php';
include '../../view/header.php';
include 'content/view_review.php';
break;
case "parse_review":
echo "<!-- Get results -->";
$game_id = $_SESSION["game_id"];
$review_id = $_SESSION["review_id"];
$new_likes = filter_input(INPUT_POST, "likes", FILTER_SANITIZE_STRING, FILTER_REQUIRE_ARRAY);
$new_genres = filter_input(INPUT_POST, "genres", FILTER_SANITIZE_STRING, FILTER_REQUIRE_ARRAY);
$new_features = filter_input(INPUT_POST, "features", FILTER_SANITIZE_STRING, FILTER_REQUIRE_ARRAY);
$new_comments = filter_input(INPUT_POST, "comments", FILTER_SANITIZE_STRING, FILTER_REQUIRE_ARRAY);
echo "<!-- Get the number of entries -->";
$num = sizeof($new_features);
function feature()
{
$row = getFeatures();
return $row;
}
function getAllFeatures()
{
$feature = getFeatures();
return $feature;
}
