function displayViewTable($uid, $gid, $tid, $selection)
{
global $keep_shard, $keep_server, $keep_service, $display_view;
// 1. create views tree
buildVariableEnv($uid, $gid, $tid, $vardisp, $bounds, $privilege, $tree, $condensed, $autoDisplay);
if ($autoDisplay || $display_view) {
// 2. select branches
if (count($selection) > 0) {
foreach ($selection as $sel) {
if ($sel != "") {
$selarray = expandQuery($sel);
foreach ($selarray as $sel) {
$address = explode(".", $sel);
//echo "select address ".$sel."<br>\n";
addToSelectNode($tree, $address, 0);
}
}
}
}
// 3. remove unselected branches
clearupNode($tree);
// 4. build and factorize query
$query = factorizeQuery(buildQuery($tree));
if ($numsteps == 5) {
echo "Unsupported entity request now<br>\n";
return;
}
$bef = microtime();
$qstate = nel_query($query, $result);
$aft = microtime();
list($usec, $sec) = explode(" ", $bef);
$bef = (double) $sec + (double) $usec;
list($usec, $sec) = explode(" ", $aft);
$aft = (double) $sec + (double) $usec;
$tm = (int) (($aft - $bef) * 1000.0);
if (!$qstate) {
echo "<b>{$result}</b>\n";
}
}
displayResult($result, $vardisp, $bounds, $privilege, $condensed, $autoDisplay);
return "Executed query '{$query}'<br>{$tm} milliseconds computation time<br>\n";
}
#!/usr/bin/env php
<?php
// Looks for and reports any missing translation in the EasyAdmin bundle
// translation files (it uses the English translation as the reference because
// it's always complete).
// Configuration options
// ----------------------------------------------------------------------------
$translationsDir = __DIR__ . '/../vendor/javiereguiluz/easyadmin-bundle/Resources/translations';
// Don't change anything below this line
// ----------------------------------------------------------------------------
$englishTranslations = array('EasyAdminBundle' => getTranslationKeys($translationsDir . '/EasyAdminBundle.en.xlf'), 'messages' => getTranslationKeys($translationsDir . '/messages.en.xlf'));
$missingTranslations = findMissingTranslations($englishTranslations, $translationsDir);
displayResult($missingTranslations);
function findMissingTranslations($referenceTranslation, $translationsDir)
{
$missingTranslations = array();
foreach (array('EasyAdminBundle', 'messages') as $domain) {
$availableTranslations = glob(sprintf('%s/%s.*.xlf', $translationsDir, $domain));
foreach ($availableTranslations as $translationFile) {
$extension = ltrim(strstr(basename($translationFile), '.'), '.');
if ('en.xlf' === $extension) {
continue;
}
$translatedKeys = getTranslationKeys($translationFile);
$missingTranslationKeys = array_diff($referenceTranslation[$domain], $translatedKeys);
if (!empty($missingTranslationKeys)) {
$locale = substr($extension, 0, 2);
$missingTranslations[$locale][$domain] = $missingTranslationKeys;
}
}
}
} else {
if (isset($executeQuery)) {
$bef = microtime();
$qstate = nel_query($executeQuery, $updateResult);
$aft = microtime();
list($usec, $sec) = explode(" ", $bef);
$bef = (double) $sec + (double) $usec;
list($usec, $sec) = explode(" ", $aft);
$aft = (double) $sec + (double) $usec;
$tm = (int) (($aft - $bef) * 1000.0);
$queryResult = "Executed {$executeQuery}<br>{$tm} milliseconds computation time<br>\n";
}
}
if ($updateResult) {
buildVariableEnv($uid, $gid, $tid, $vardisp, $bounds, $privilege, $tree, $condensed, $autoDisplay);
displayResult($updateResult, $vardisp, $bounds, $privilege);
} else {
// send select request
if (count($sel) > 0) {
$sel = array_unique($sel);
}
if (count($sel) == 1 && $sel[0] == "") {
unset($sel);
}
$queryResult = displayViewTable($uid, $gid, $tid, $sel);
}
echo "<input type=hidden name='current_tid' value='{$tid}'>\n";
$i = 0;
if (count($sel) > 0) {
foreach ($sel as $selec) {
echo "<input type=hidden name='current_select_" . $i++ . "' value='{$selec}'>\n";
$getsearchword = $_POST["keyword"];
if ($getsearchword == "") {
foreach (range('a', 'z') as $letter) {
$sort = TRUE;
$results = $dal->get_models($letter, $sort);
$totalResul = count($results);
displayResult($results);
if ($results >= 0) {
break;
}
}
// end foreach
} else {
$sort = FALSE;
$results = $dal->get_models($getsearchword, $sort);
displayResult($results);
}
}
?>
<?php
function displayResult($results)
{
?>
<div id="intrates_div">
<table cellspacing="0" cellpadding="0" border="0" id="intrates">
<?php
if ($results) {
foreach ($results as $model) {
function outputResults($propertyResults)
{
global $resultType;
global $resultImage;
global $resultPrice;
global $resultPrice2;
global $resultLocation;
global $resultReference;
global $resultDescription;
global $resultBeds;
global $resultBaths;
global $resultTerrace;
global $resultPlot;
global $urlRewrite;
global $searchResultType;
global $rewritePatternUrl;
global $queryInfo;
global $built;
global $languageArr;
global $featureSearchArr;
global $resultTypeVal;
$_SESSION['isFSearch'] = 0;
$resultText = '';
if ($propertyResults !== NULL) {
foreach ($propertyResults as $property) {
if ($_SESSION["SearchType"] == 'Resale') {
$resultPrice = (string) $property->Price;
$resultPrice2 = '';
} else {
$resultPrice = (string) $property->RentalPrice1;
$resultPrice2 = (string) $property->RentalPrice2;
}
$resultType = (string) $property->Type;
$resultTypeVal = (string) $property->TypeVal;
$resultImage = (string) $property->MainImage;
$resultLocation = (string) $property->Location;
$resultReference = (string) $property->Reference;
$resultDescription = (string) $property->Description;
$resultBeds = (string) $property->Bedrooms;
$resultBaths = (string) $property->Bathrooms;
$resultTerrace = (string) $property->Terrace;
$resultPlot = (string) $property->GardenPlot;
$built = (string) $property->Built;
$area = (string) $property->Area;
$arr = array();
foreach ($property->PropertyFeatures as $feature) {
foreach ($feature->Category as $item) {
$categoryName = (string) $item->attributes()->Name;
$categoryType = (string) $item->attributes()->Type;
$tmpArr = array();
foreach ($item->Feature as $data) {
$feValue = (string) $data->Value;
$feName = (string) $data->Name;
$tmpArr[$feValue] = array('CategoryType' => $categoryType, 'FeatureValue' => $feValue, 'FeatureName' => $feName);
}
$arr[$categoryName] = $tmpArr;
}
}
$featureSearchArr = $arr;
//Rewrite url with pattern config from roWebKit
//option: beds, baths, type, location, refid, area, search_type, subtype
$arrayTmp = array('beds' => $resultBeds, 'baths' => $resultBaths, 'location' => $resultLocation, 'refid' => $resultReference, 'search_type' => $_SESSION["SearchType"], 'type' => $resultType, 'area' => $area);
$data = array();
$patterns = explode("-", $rewritePatternUrl);
foreach ($patterns as $item) {
if ($item == 'type') {
if ($arrayTmp[$item] != '') {
$data[] = str_replace('-', ' ', $arrayTmp[$item]);
}
} else {
if ($arrayTmp[$item] != '' && !in_array($item, array('refid', 'location', 'type', 'search_type', 'area', 'subtype'))) {
$data[] = $arrayTmp[$item] . $item;
} else {
$data[] = $arrayTmp[$item];
}
}
}
$urlRewrite = implode('-', $data);
$resultText .= displayResult();
}
} else {
$resultText .= "<br /><br />" . $languageArr['results_Headings']['no_Result'];
}
echo $resultText;
if ($propertyResults != NULL) {
outputResultPagination($queryInfo);
}
createHiddenParam();
}
function search()
{
$requestURL = "http://sandbox.api.ebaycommercenetwork.com/publisher/3.0/rest/GeneralSearch?apiKey=78b0db8a-0ee1-4939-a2f9-d3cd95ec0fcc&trackingId=7000610&";
if (isset($_GET["search"]) && isset($_GET["category"])) {
$requestURL = $requestURL . 'categoryId=' . $_GET["category"] . '&keyword=' . urlencode($_GET["search"]) . '&numItems=20';
if (strlen($_GET['search']) > 0) {
$xmlstr = file_get_contents($requestURL);
if (isset($xmlstr)) {
$xmlData = new SimpleXMLElement($xmlstr);
displayResult($xmlData);
}
}
}
}
$result = mysql_query($sql);
if (!checkConn($db)) {
echo 'Lost connection...please reconnect.';
exit;
} else {
//echo 'Connection established!';
mysql_free_result($result);
if (isset($_POST['query'])) {
switch ($_POST['query']) {
case "0":
echo 'Please select a query from the dropdown box in the previous page.';
exit;
break;
case "1":
displayReport1("SELECT educal, count(id) FROM hpq_mem \n\t\t\t\t\t\tWHERE memno=1 AND jobind = 2 AND entrepind = 2 GROUP BY educal ORDER BY educal");
break;
case "2":
displayReport2("SELECT count(id) FROM hpq_hh WHERE calam1 = 1 AND calam1_aid = 2 AND disas_prep = 2 UNION\n\t\t\t\t\t\tSELECT count(id) FROM hpq_hh WHERE calam2 = 1 AND calam2_aid = 2 AND disas_prep = 2 UNION\n\t\t\t\t\t\tSELECT count(id) FROM hpq_hh WHERE calam3 = 1 AND calam3_aid = 2 AND disas_prep = 2 UNION\n\t\t\t\t\t\tSELECT count(id) FROM hpq_hh WHERE calam4= 1 AND calam4_aid = 2 AND disas_prep = 2 UNION\n\t\t\t\t\t\tSELECT count(id) FROM hpq_hh WHERE calam5 = 1 AND calam5_aid = 2 AND disas_prep = 2 UNION\n\t\t\t\t\t\tSELECT count(id) FROM hpq_hh WHERE calam6 = 1 AND calam6_aid = 2 AND disas_prep = 2 UNION\n\t\t\t\t\t\tSELECT count(id) FROM hpq_hh WHERE calam7 = 1 AND calam7_aid = 2 AND disas_prep = 2 UNION\n\t\t\t\t\t\tSELECT count(id) FROM hpq_hh WHERE calam8 = 1 AND calam8_aid = 2 AND disas_prep = 2 UNION\n\t\t\t\t\t\tSELECT count(id) FROM hpq_hh WHERE calam9 = 1 AND calam9_aid = 2 AND disas_prep = 2 UNION\n\t\t\t\t\t\tSELECT count(id) FROM hpq_hh WHERE calam10 = 1 AND calam10_aid = 2 AND disas_prep = 2", "SELECT count(id) FROM hpq_hh \n\t\t\t\t\t\t\tWHERE calam11 = 1 AND calam11_aid = '2' AND disas_prep = 2");
break;
}
} else {
if (isset($_POST['queryenter'])) {
if ($_POST['queryenter'] != '') {
displayResult($_POST['queryenter']);
} else {
echo ' Please enter a valid query.';
exit;
}
}
}
}