/** * 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; }