<?php
include "conf/config.inc.php";
$value = $_POST['value'];
$attribute = $_POST['attr'];
$manufac = $_POST['manufact'];
$classname = $_POST["class"];
if ($classname == "") {
$classname = "customStyleSelectBox";
}
$search = new search();
$com = new common();
if ($attribute == "manufacturer") {
$dataArray = array("{$attribute}" => $value);
$carid = $search->attributeSearch($dataArray, "");
$set = implode(",", $carid);
$returnvalue = '<select class="' . $classname . '" id="model" name="model" onchange="ajaxcall(this.value,\'model\',\'year\',' . $value . ')">';
$returnvalue .= "<option value=''>Modèles</option>";
//echo "Select DISTINCT(value) from car_varchar where attribute_id = '4' and FIND_IN_SET(car_id, '".$set."') order by value";
$year = $com->CustomQuery("Select DISTINCT(value) from car_varchar where attribute_id = '4' and FIND_IN_SET(car_id, '" . $set . "') order by value");
while ($yrow = mysql_fetch_object($year)) {
$returnvalue .= "<option value='" . $yrow->value . "'>" . $yrow->value . "</option>";
}
$returnvalue .= '</select>';
echo $returnvalue;
}
if ($attribute == "model") {
$dataArray = array("{$attribute}" => $value, "manufacturer" => $manufac);
$carid = $search->attributeSearch($dataArray, "");
$set = implode(",", $carid);
$returnvalue = '<select class="' . $classname . '" name="madeYear" id="madeYear">';
$apicall .= $where;
//echo $apicall;die;
// Load the call and capture the document returned by eBay API
$resp = simplexml_load_file($apicall);
$ebay_total = (int) $resp->paginationOutput->totalEntries;
$pages = new Paginator();
$pages->items_per_page = 110;
$pages->current_page = $fillfor;
if (count($dataArray) >= 1) {
if ($groupby != "" && $sort != "") {
$order = explode("~", $sort);
$orderby = $groupby . "," . $order[0];
$total_rows = $search->attributeSearchCount($dataArray, $groupby);
$pages->items_total += $total_rows;
$pages->paginate();
$cars = $search->attributeSearch($dataArray, $orderby, $order[1], $pages->limit);
} else {
if ($groupby == "" && $sort != "") {
$order = explode("~", $sort);
$total_rows = $search->attributeSearchCount($dataArray, $groupby);
$pages->items_total += $total_rows;
$pages->paginate();
$cars = $search->attributeSearch($dataArray, $order[0], $order[1], $pages->limit);
} else {
if ($groupby != "" && $sort == "") {
$total_rows = $search->attributeSearchCount($dataArray, $groupby);
$pages->items_total += $total_rows;
$pages->paginate();
$cars = $search->attributeSearch($dataArray, $groupby, 'ASC', $pages->limit);
} else {
$total_rows = $search->attributeSearchCount($dataArray);
$obj_search = new search();
if (isset($_GET['field']) and $_GET['field'] != '') {
$field = $_GET['field'];
} else {
$field = 'car_id';
}
if (isset($_GET['orderBy']) and $_GET['orderBy'] != '') {
$orderby = $_GET['orderBy'];
} else {
$orderby = 'ASC';
}
$addCarToQuery = '';
$dataArr = array("featured" => 169);
if ($submitcar == 'Search') {
$backtype = explode("~", $searchattr);
if ($backtype[2] == "select" or $backtype[2] == "radio" or $backtype[2] == "multiselect" or $backtype[2] == "checkbox") {
$value_id = $obj_setting->customQuery("select value_id from attribute_option_value where attribute_id = '" . $backtype['0'] . "' and value like '" . "%" . $searchcar . "%" . "' ");
$value_id = mysql_fetch_object($value_id);
$value = $value_id->value_id;
} else {
$value = $searchcar;
}
$attribute_code = $obj_setting->customQuery("select attribute_code from attribute where attribute_id = " . $backtype['0']);
$attribute_code = mysql_fetch_object($attribute_code);
$dataArr[$attribute_code->attribute_code] = $value;
}
$pages->items_total = $obj_search->attributeSearchCount($dataArr);
$total_rows = $pages->items_total;
$pages->paginate();
$all_car = $obj_search->attributeSearch($dataArr, "fullName", "ASC", $pages->limit);
$all_car = $obj_setting->CarAttributesFromID($all_car);
