getCategory($cat, $_SESSION["LANGUAGE"], DEFAULT_LANGUAGE);
$pageTitle = buildPageTitle($cat_name["title"]);
} else if (isset($_GET['search'])) {
$search = $_GET['search'];
if ($search == $L["INPUT_SEARCH"])
$search = "";
$pageTitle = buildPageTitle($search);
} else {
$pageTitle = buildPageTitle($L["MAIN_TITLE"]);
}
include ('./lib/header.php');
$_SESSION['REFERAL_URL'] = getURL();
?>
";
//WELCOME PAGE
if (($search == '') && ($cat == '')) {
drawImageSlider();
drawHotProducts();
} else {
if ($cat != "") {
$subcat = $product->getSubCategoriesId($cat, true, null);
$count_query = "SELECT COUNT(ref) as total ";
$common_query = "FROM produto WHERE activo = '1' AND (categoria = '" . $cat . "'";
for ($i = 0; $i < count($subcat); $i++)
$common_query .= " OR categoria = '" . $subcat[$i] . "'";
$common_query .= ")";
$count_query .= $common_query;
} else if ($search != "") {
$count_query = "SELECT COUNT(DISTINCT produto.ref) as total ";
$common_query = "FROM produto, produto_lang WHERE produto.activo=1 AND produto.ref = produto_lang.ref AND (";
$session = session_id();
$product->insertLogSearch($search, $session);
$search_word = explode(" ", $search);
$count_words = count($search_word);
for ($i = 0; $i < $count_words; $i++) {
$common_query .= "(";
/*
$common_query .= "produto_lang.titulo LIKE '%".$search_word[$i]."%'"; $common_query .= " OR ";
$common_query .= "produto_lang.descricao LIKE '%".$search_word[$i]."%'"; $common_query .= " OR ";
$common_query .= "produto_lang.keywords LIKE '%".$search_word[$i]."%'"; $common_query .= " OR ";
$common_query .= "produto.ref LIKE '%".$search_word[$i]."%'"; $common_query .= " OR ";
$common_query .= "produto.reffab LIKE '%".$search_word[$i]."%'";$common_query .= " OR ";
$common_query .= "produto.marca LIKE '%".$search_word[$i]."%'";
REGEXP '[[:<:]]2[[:>:]]'
*/
$common_query .= "produto_lang.titulo REGEXP '[[:<:]]" . $search_word[$i] . "[[:>:]]'";
$common_query .= " OR ";
$common_query .= "produto_lang.descricao REGEXP '[[:<:]]" . $search_word[$i] . "[[:>:]]'";
$common_query .= " OR ";
$common_query .= "produto_lang.keywords REGEXP '[[:<:]]" . $search_word[$i] . "[[:>:]]'";
$common_query .= " OR ";
$common_query .= "produto.ref REGEXP '[[:<:]]" . $search_word[$i] . "[[:>:]]'";
$common_query .= " OR ";
$common_query .= "produto.reffab REGEXP '[[:<:]]" . $search_word[$i] . "[[:>:]]'";
$common_query .= " OR ";
$common_query .= "produto.marca REGEXP '[[:<:]]" . $search_word[$i] . "[[:>:]]'";
$common_query .= ")";
if ($i < ($count_words - 1))
$common_query .= " AND ";
}
$common_query .= ")";
$count_query .= $common_query;
}
$db = new sql($count_query);
if ($db->next_record())
$total = $db->f("total");
else
$total = 0;
if (!(isset($_GET['page'])))
$page = 1;
else
$page = $_GET['page'];
$last = ceil($total / MAX_PRODUCTS_PER_PAGE); //ultima pag
if ($page < 1)
$page = 1;
else if ($page > $last)
$page = $last;
if (!(isset($_GET['sort'])))
$sort = 0;
else
$sort = $_GET['sort'];
if ($sort == 0)
$sort_query = " ORDER BY views DESC ";
else if ($sort == 1) {
if ($user->type == '2')
$sort_query = " ORDER BY preco_publico ASC ";
else
$sort_query = " ORDER BY preco_revenda ASC ";
}
else if ($sort == 2) {
if ($user->type == '2')
$sort_query = " ORDER BY preco_publico DESC ";
else
$sort_query = " ORDER BY preco_revenda DESC ";
}
$limit_query = "LIMIT " . (($page - 1) * MAX_PRODUCTS_PER_PAGE) . "," . MAX_PRODUCTS_PER_PAGE;
if ($cat != "") {
$var = "cat=" . $cat;
$query = "SELECT ref " . $common_query . $sort_query . $limit_query;
} else if ($search != "") {
$var = "search=" . $search;
$query = "SELECT DISTINCT (produto.ref) " . $common_query . $sort_query . $limit_query;
} else
$query = "";
$db = new sql($query);
//O QUE MOSTRA ANTES DOS RESULTADOS
if ($cat != "") {
echo "" . $cat_name["title"] . "
";
echo "";
$subcat = $product->getSubCategoriesId($cat, false, null);
$index = 0;
echo "
";
echo "
" . $total . " " . $L["SEARCH_RESULTS"] . " \"" . $search . "\"
";
}
if ($db->nf() > 0) {
echo "";
echo "";
echo "";
echo "
";
echo "
" . $L["ORGANIZE_TEXT"] . ":
";
echo"
";
$product->drawBreadCrumb($cat, "0");
echo "
";
echo "";
while ($db->next_record())
$product->drawProducts($db->f("ref"));
loadAddCartPopUp();
//SEM OCORRENCIAS
} else {
if ($cat != "") {
echo "";
echo "A categoria seleccionada não possui artigos.";
echo "
";
}
if ($search != "") {
echo "
" . $L["MAIN_TITLE_NORESULTS"] . "
" . $L["TITLE1_NORESULTS"] . ":
" . $L["TEXT1_NORESULTS"] . "
" . $L["TITLE2_NORESULTS"] . ":
" . $L["TEXT2_NORESULTS"] . ".
" . $L["TITLE3_NORESULTS"] . ":
" . $L["TEXT3_NORESULTS"] . "
";
echo "
";
}
}
//DIV PARA COLOCAR A PAGINAÇÃO
echo "";
if ($total != 0) {
echo "" . $L['TEXT_RESULTS_PAGE'][0] . "" . $product_ini . "" . $L['TEXT_RESULTS_PAGE'][1] . " " . $product_fin . " " . $L['TEXT_RESULTS_PAGE'][2] . " " . $total . " | " . $last . "" . $L['TEXT_RESULTS_PAGE'][3] . "
";
}
}
echo "";
include('./lib/side_menu.php');
include ('./lib/footer.php');
?>