function getProducts($filters, $order = null, $orderby = null, $limitstart = 0, $limit = 0)
{
$db = JFactory::getDBO();
$this->buildAdvQuery($filters, $order, $orderby);
$query = "SELECT " . $this->adv_result . " FROM `#__jshopping_products` AS prod\n LEFT JOIN `#__jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id\n LEFT JOIN `#__jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id \n " . $this->adv_from . "\n WHERE prod.product_publish = '1' AND cat.category_publish='1'\n " . $this->adv_query . "\n GROUP BY prod.product_id " . $this->order_query;
$db->setQuery($query, $limitstart, $limit);
$rows = $db->loadObjectList();
$rows = listProductUpdateData($rows);
addLinkToProducts($rows, 0, 1);
return $rows;
}
function result()
{
$mainframe = JFactory::getApplication();
$jshopConfig = JSFactory::getConfig();
$db = JFactory::getDBO();
$lang = JSFactory::getLang();
$user = JFactory::getUser();
$session = JFactory::getSession();
$session->set("jshop_end_page_buy_product", $_SERVER['REQUEST_URI']);
$session->set("jshop_end_page_list_product", $_SERVER['REQUEST_URI']);
$params = $mainframe->getParams();
$dispatcher = JDispatcher::getInstance();
$dispatcher->trigger('onBeforeLoadProductList', array());
$product = JSFactory::getTable('product', 'jshop');
$seo = JSFactory::getTable("seo", "jshop");
$seodata = $seo->loadData("search-result");
if (getThisURLMainPageShop()) {
appendPathWay(_JSHOP_SEARCH);
if ($seodata->title == "") {
$seodata->title = _JSHOP_SEARCH;
}
setMetaData($seodata->title, $seodata->keyword, $seodata->description);
} else {
setMetaData($seodata->title, $seodata->keyword, $seodata->description, $params);
}
$post = JRequest::get('request');
if (isset($post['setsearchdata']) && $post['setsearchdata'] == 1) {
$session->set("jshop_end_form_data", $post);
} else {
$data = $session->get("jshop_end_form_data");
if (count($data)) {
$post = $data;
}
}
$category_id = intval($post['category_id']);
$manufacturer_id = intval($post['manufacturer_id']);
if (isset($post['date_to'])) {
$date_to = $post['date_to'];
} else {
$date_to = null;
}
if (isset($post['date_from'])) {
$date_from = $post['date_from'];
} else {
$date_from = null;
}
if (isset($post['price_to'])) {
$price_to = saveAsPrice($post['price_to']);
} else {
$price_to = null;
}
if (isset($post['price_from'])) {
$price_from = saveAsPrice($post['price_from']);
} else {
$price_from = null;
}
if (isset($post['include_subcat'])) {
$include_subcat = intval($post['include_subcat']);
} else {
$include_subcat = 0;
}
$search = trim($post['search']);
$search_type = $post['search_type'];
if (!$search_type) {
$search_type = "any";
}
$context = "jshoping.searclist.front.product";
$orderby = $mainframe->getUserStateFromRequest($context . 'orderby', 'orderby', $jshopConfig->product_sorting_direction, 'int');
$order = $mainframe->getUserStateFromRequest($context . 'order', 'order', $jshopConfig->product_sorting, 'int');
$limit = $mainframe->getUserStateFromRequest($context . 'limit', 'limit', $jshopConfig->count_products_to_page, 'int');
if (!$limit) {
$limit = $jshopConfig->count_products_to_page;
}
$limitstart = JRequest::getInt('limitstart', 0);
if ($order == 4) {
$order = 1;
}
if ($jshopConfig->admin_show_product_extra_field) {
if (isset($post['extra_fields'])) {
$extra_fields = $post['extra_fields'];
} else {
$extra_fields = array();
}
$extra_fields = filterAllowValue($extra_fields, "array_int_k_v+");
}
$categorys = array();
if ($category_id) {
if ($include_subcat) {
$_category = JSFactory::getTable('category', 'jshop');
$all_categories = $_category->getAllCategories();
$cat_search[] = $category_id;
searchChildCategories($category_id, $all_categories, $cat_search);
foreach ($cat_search as $key => $value) {
$categorys[] = $value;
}
} else {
$categorys[] = $category_id;
}
}
$orderbyq = getQuerySortDirection($order, $orderby);
$image_sort_dir = getImgSortDirection($order, $orderby);
$filters = array();
$filters['categorys'] = $categorys;
if ($manufacturer_id) {
$filters['manufacturers'][] = $manufacturer_id;
}
$filters['price_from'] = $price_from;
$filters['price_to'] = $price_to;
if ($jshopConfig->admin_show_product_extra_field) {
$filters['extra_fields'] = $extra_fields;
}
$adv_query = "";
$adv_from = "";
$adv_result = $product->getBuildQueryListProductDefaultResult();
$product->getBuildQueryListProduct("search", "list", $filters, $adv_query, $adv_from, $adv_result);
if ($date_to && checkMyDate($date_to)) {
$adv_query .= " AND prod.product_date_added <= '" . $db->escape($date_to) . "'";
}
if ($date_from && checkMyDate($date_from)) {
$adv_query .= " AND prod.product_date_added >= '" . $db->escape($date_from) . "'";
}
$where_search = "";
if ($search_type == "exact") {
$word = addcslashes($db->escape($search), "_%");
$tmp = array();
foreach ($jshopConfig->product_search_fields as $field) {
$tmp[] = "LOWER(" . getDBFieldNameFromConfig($field) . ") LIKE '%" . $word . "%'";
}
$where_search = implode(' OR ', $tmp);
} else {
$words = explode(" ", $search);
$search_word = array();
foreach ($words as $word) {
$word = addcslashes($db->escape($word), "_%");
$tmp = array();
foreach ($jshopConfig->product_search_fields as $field) {
$tmp[] = "LOWER(" . getDBFieldNameFromConfig($field) . ") LIKE '%" . $word . "%'";
}
$where_search_block = implode(' OR ', $tmp);
$search_word[] = "(" . $where_search_block . ")";
}
if ($search_type == "any") {
$where_search = implode(" OR ", $search_word);
} else {
$where_search = implode(" AND ", $search_word);
}
}
if ($where_search) {
$adv_query .= " AND ({$where_search})";
}
$orderbyf = $jshopConfig->sorting_products_field_s_select[$order];
$order_query = $product->getBuildQueryOrderListProduct($orderbyf, $orderbyq, $adv_from);
$dispatcher->trigger('onBeforeQueryGetProductList', array("search", &$adv_result, &$adv_from, &$adv_query, &$order_query, &$filters));
$query = "SELECT count(distinct prod.product_id) FROM `#__jshopping_products` AS prod\n LEFT JOIN `#__jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id\n LEFT JOIN `#__jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id \n {$adv_from}\n WHERE prod.product_publish = '1' AND cat.category_publish='1'\n {$adv_query}";
$db->setQuery($query);
$total = $db->loadResult();
if (!$total) {
$view_name = "search";
$view_config = array("template_path" => JPATH_COMPONENT . "/templates/" . $jshopConfig->template . "/" . $view_name);
$view = $this->getView($view_name, getDocumentType(), '', $view_config);
$view->setLayout("noresult");
$view->assign('search', $search);
$view->display();
return 0;
}
$dispatcher->trigger('onBeforeFixLimitstartDisplayProductList', array(&$limitstart, &$total, 'search'));
if ($limitstart >= $total) {
$limitstart = 0;
}
$query = "SELECT {$adv_result} FROM `#__jshopping_products` AS prod\n LEFT JOIN `#__jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id\n LEFT JOIN `#__jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id \n {$adv_from}\n WHERE prod.product_publish = '1' AND cat.category_publish='1'\n {$adv_query}\n GROUP BY prod.product_id " . $order_query;
$db->setQuery($query, $limitstart, $limit);
$rows = $db->loadObjectList();
$rows = listProductUpdateData($rows);
addLinkToProducts($rows, 0, 1);
jimport('joomla.html.pagination');
$pagination = new JPagination($total, $limitstart, $limit);
$pagenav = $pagination->getPagesLinks();
foreach ($jshopConfig->sorting_products_name_s_select as $key => $value) {
$sorts[] = JHTML::_('select.option', $key, $value, 'sort_id', 'sort_value');
}
insertValueInArray($jshopConfig->count_products_to_page, $jshopConfig->count_product_select);
foreach ($jshopConfig->count_product_select as $key => $value) {
$product_count[] = JHTML::_('select.option', $key, $value, 'count_id', 'count_value');
}
$sorting_sel = JHTML::_('select.genericlist', $sorts, 'order', 'class = "inputbox" size = "1" onchange = "submitListProductFilters()"', 'sort_id', 'sort_value', $order);
$product_count_sel = JHTML::_('select.genericlist', $product_count, 'limit', 'class = "inputbox" size = "1" onchange = "submitListProductFilters()"', 'count_id', 'count_value', $limit);
$_review = JSFactory::getTable('review', 'jshop');
$allow_review = $_review->getAllowReview();
$action = xhtmlUrl($_SERVER['REQUEST_URI']);
$dispatcher->trigger('onBeforeDisplayProductList', array(&$rows));
$view_name = "search";
$view_config = array("template_path" => $jshopConfig->template_path . $jshopConfig->template . "/" . $view_name);
$view = $this->getView($view_name, getDocumentType(), '', $view_config);
$view->setLayout("products");
$view->assign('search', $search);
$view->assign('total', $total);
$view->assign('config', $jshopConfig);
$view->assign('template_block_list_product', "list_products/list_products.php");
$view->assign('template_block_form_filter', "list_products/form_filters.php");
$view->assign('template_block_pagination', "list_products/block_pagination.php");
$view->assign('path_image_sorting_dir', $jshopConfig->live_path . 'images/' . $image_sort_dir);
$view->assign('filter_show', 0);
$view->assign('filter_show_category', 0);
$view->assign('filter_show_manufacturer', 0);
$view->assign('pagination', $pagenav);
$view->assign('pagination_obj', $pagination);
$view->assign('display_pagination', $pagenav != "");
$view->assign('product_count', $product_count_sel);
$view->assign('sorting', $sorting_sel);
$view->assign('action', $action);
$view->assign('orderby', $orderby);
$view->assign('count_product_to_row', $jshopConfig->count_products_to_row);
$view->assign('rows', $rows);
$view->assign('allow_review', $allow_review);
$view->assign('shippinginfo', SEFLink($jshopConfig->shippinginfourl, 1));
$dispatcher->trigger('onBeforeDisplayProductListView', array(&$view));
$view->display();
}
function getProducts($filters, $order = null, $orderby = null, $limitstart = 0, $limit = 0)
{
$jshopConfig = JSFactory::getConfig();
$lang = JSFactory::getLang();
$adv_query = "";
$adv_from = "";
$adv_result = $this->getBuildQueryListProductDefaultResult();
$this->getBuildQueryListProduct("vendor", "list", $filters, $adv_query, $adv_from, $adv_result);
if ($this->main) {
$query_vendor_id = "(prod.vendor_id = '" . $this->id . "' OR prod.vendor_id ='0')";
} else {
$query_vendor_id = "prod.vendor_id = '" . $this->id . "'";
}
$order_query = $this->getBuildQueryOrderListProduct($order, $orderby, $adv_from);
JPluginHelper::importPlugin('jshoppingproducts');
$dispatcher = JDispatcher::getInstance();
$dispatcher->trigger('onBeforeQueryGetProductList', array("vendor", &$adv_result, &$adv_from, &$adv_query, &$order_query, &$filters));
$query = "SELECT {$adv_result} FROM `#__jshopping_products` AS prod\n LEFT JOIN `#__jshopping_products_to_categories` AS pr_cat USING (product_id)\n LEFT JOIN `#__jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id \n {$adv_from}\n WHERE " . $query_vendor_id . " AND prod.product_publish = '1' AND cat.category_publish='1' " . $adv_query . "\n GROUP BY prod.product_id " . $order_query;
if ($limit) {
$this->_db->setQuery($query, $limitstart, $limit);
} else {
$this->_db->setQuery($query);
}
$products = $this->_db->loadObjectList();
$products = listProductUpdateData($products);
return $products;
}
function getProducts($filters, $order = null, $orderby = null, $limitstart = 0, $limit = 0)
{
$adv_query = "";
$adv_from = "";
$adv_result = $this->getBuildQueryListProductDefaultResult();
$this->getBuildQueryListProduct("category", "list", $filters, $adv_query, $adv_from, $adv_result);
$order_query = $this->getBuildQueryOrderListProduct($order, $orderby, $adv_from);
$dispatcher = JDispatcher::getInstance();
$dispatcher->trigger('onBeforeQueryGetProductList', array("category", &$adv_result, &$adv_from, &$adv_query, &$order_query, &$filters));
$query = "SELECT {$adv_result} FROM `#__jshopping_products` AS prod\n LEFT JOIN `#__jshopping_products_to_categories` AS pr_cat USING (product_id)\n {$adv_from}\n WHERE pr_cat.category_id = '" . $this->_db->escape($this->category_id) . "' AND prod.product_publish = '1' " . $adv_query . " " . $order_query;
if ($limit) {
$this->_db->setQuery($query, $limitstart, $limit);
} else {
$this->_db->setQuery($query);
}
$products = $this->_db->loadObjectList();
$products = listProductUpdateData($products);
addLinkToProducts($products, $this->category_id);
return $products;
}