public static function getListSubCatsId($ids = array()) { $db = JFactory::getDBO(); if (!count($ids)) { return array(); } $ids = filterAllowValue($ids, 'int+'); $query = "select category_id from `#__jshopping_categories` where category_parent_id in (" . implode(',', $ids) . ")"; $db->setQuery($query); $list = $db->loadObjectList(); $rows = array(); foreach ($list as $v) { $rows[] = $v->category_id; } return $rows; }
$categorys = $mainframe->getUserStateFromRequest($contextfilter . 'categorys', 'categorys', array()); $categorys = filterAllowValue($categorys, "int+"); $filter_categorys = $manufacturer->getCategorys(); } if ($show_prices) { $fprice_from = $mainframe->getUserStateFromRequest($contextfilter . 'fprice_from', 'fprice_from'); $fprice_from = saveAsPrice($fprice_from); $fprice_to = $mainframe->getUserStateFromRequest($contextfilter . 'fprice_to', 'fprice_to'); $fprice_to = saveAsPrice($fprice_to); } if ($show_characteristics && $jshopConfig->admin_show_product_extra_field) { $characteristic_fields = JSFactory::getAllProductExtraField(); $characteristic_fieldvalues = JSFactory::getAllProductExtraFieldValueDetail(); $characteristic_displayfields = JSFactory::getDisplayFilterExtraFieldForCategory($category_id); $extra_fields_active = $mainframe->getUserStateFromRequest($contextfilter . 'extra_fields', 'extra_fields', array()); $extra_fields_active = filterAllowValue($extra_fields_active, "array_int_k_v+"); } $date_from = $mainframe->getUserStateFromRequest($contextfilter . 'dfrom', 'dfrom', date('d/m/Y')); $date_to = $mainframe->getUserStateFromRequest($contextfilter . 'dto', 'dto', date('d/m/Y', time() + 60 * 60 * 24)); if ($date_from == '') { $date_from = date('d/m/Y'); } if ($date_to == '') { $date_to = date('d/m/Y', time() + 60 * 60 * 24); } $Item_id = $params->get('item_id', ''); if ($Item_id == '') { $action = $_SERVER['REQUEST_URI']; } else { $action = JRoute::_('index.php?Itemid=' . $Item_id); }
function getBuildFilterListProduct($contextfilter, $no_filter = array()) { $mainframe = JFactory::getApplication(); $jshopConfig = JSFactory::getConfig(); $category_id = JRequest::getInt('category_id'); $manufacturer_id = JRequest::getInt('manufacturer_id'); $label_id = JRequest::getInt('label_id'); $vendor_id = JRequest::getInt('vendor_id'); $price_from = saveAsPrice(JRequest::getVar('price_from')); $price_to = saveAsPrice(JRequest::getVar('price_to')); $categorys = $mainframe->getUserStateFromRequest($contextfilter . 'categorys', 'categorys', array()); $categorys = filterAllowValue($categorys, "int+"); $tmpcd = getListFromStr(JRequest::getVar('category_id')); if (is_array($tmpcd) && !$categorys) { $categorys = $tmpcd; } $manufacturers = $mainframe->getUserStateFromRequest($contextfilter . 'manufacturers', 'manufacturers', array()); $manufacturers = filterAllowValue($manufacturers, "int+"); $tmp = getListFromStr(JRequest::getVar('manufacturer_id')); if (is_array($tmp) && !$manufacturers) { $manufacturers = $tmp; } $labels = $mainframe->getUserStateFromRequest($contextfilter . 'labels', 'labels', array()); $labels = filterAllowValue($labels, "int+"); $tmplb = getListFromStr(JRequest::getVar('label_id')); if (is_array($tmplb) && !$labels) { $labels = $tmplb; } $vendors = $mainframe->getUserStateFromRequest($contextfilter . 'vendors', 'vendors', array()); $vendors = filterAllowValue($vendors, "int+"); $tmp = getListFromStr(JRequest::getVar('vendor_id')); if (is_array($tmp) && !$vendors) { $vendors = $tmp; } if ($jshopConfig->admin_show_product_extra_field) { $extra_fields = $mainframe->getUserStateFromRequest($contextfilter . 'extra_fields', 'extra_fields', array()); $extra_fields = filterAllowValue($extra_fields, "array_int_k_v+"); } $fprice_from = $mainframe->getUserStateFromRequest($contextfilter . 'fprice_from', 'fprice_from'); $fprice_from = saveAsPrice($fprice_from); if (!$fprice_from) { $fprice_from = $price_from; } $fprice_to = $mainframe->getUserStateFromRequest($contextfilter . 'fprice_to', 'fprice_to'); $fprice_to = saveAsPrice($fprice_to); if (!$fprice_to) { $fprice_to = $price_to; } $filters = array(); $filters['categorys'] = $categorys; $filters['manufacturers'] = $manufacturers; $filters['price_from'] = $fprice_from; $filters['price_to'] = $fprice_to; $filters['labels'] = $labels; $filters['vendors'] = $vendors; if ($jshopConfig->admin_show_product_extra_field) { $filters['extra_fields'] = $extra_fields; } if ($category_id && !$filters['categorys']) { $filters['categorys'][] = $category_id; } if ($manufacturer_id && !$filters['manufacturers']) { $filters['manufacturers'][] = $manufacturer_id; } if ($label_id && !$filters['labels']) { $filters['labels'][] = $label_id; } if ($vendor_id && !$filters['vendors']) { $filters['vendors'][] = $vendor_id; } if (is_array($filters['vendors'])) { $main_vendor = JSFactory::getMainVendor(); foreach ($filters['vendors'] as $vid) { if ($vid == $main_vendor->id) { $filters['vendors'][] = 0; } } } foreach ($no_filter as $filterkey) { unset($filters[$filterkey]); } JPluginHelper::importPlugin('jshoppingproducts'); $dispatcher = JDispatcher::getInstance(); $dispatcher->trigger('afterGetBuildFilterListProduct', array(&$filters)); return $filters; }
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(); }
public function getExtraFields() { $jshopConfig = JSFactory::getConfig(); 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+"); } else { $extra_fields = array(); } return $extra_fields; }