/**
* Gets product filters by search params
*
* @param array $params Products filter search params
* @param int $items_per_page Items per page
* @param string $lang_code 2-letter language code (e.g. 'en', 'ru', etc.)
* @return array Product filters
*/
function fn_get_product_filters($params = array(), $items_per_page = 0, $lang_code = DESCR_SL)
{
/**
* Changes product filters search params
*
* @param array $params Products filter search params
* @param int $items_per_page Items per page
* @param string $lang_code 2-letter language code (e.g. 'en', 'ru', etc.)
*/
fn_set_hook('get_product_filters_pre', $params, $items_per_page, $lang_code);
// Init filter
$params = LastView::instance()->update('product_filters', $params);
// Set default values to input params
$default_params = array('page' => 1, 'items_per_page' => $items_per_page);
$params = array_merge($default_params, $params);
$condition = $group = '';
if (!empty($params['filter_id'])) {
$condition .= db_quote(" AND ?:product_filters.filter_id IN (?n)", (array) $params['filter_id']);
}
if (isset($params['filter_name']) && fn_string_not_empty($params['filter_name'])) {
$condition .= db_quote(" AND ?:product_filter_descriptions.filter LIKE ?l", "%" . trim($params['filter_name']) . "%");
}
if (!empty($params['show_on_home_page'])) {
$condition .= db_quote(" AND ?:product_filters.show_on_home_page = ?s", $params['show_on_home_page']);
}
if (!empty($params['status'])) {
$condition .= db_quote(" AND ?:product_filters.status = ?s", $params['status']);
}
if (isset($params['feature_name']) && fn_string_not_empty($params['feature_name'])) {
$condition .= db_quote(" AND ?:product_features_descriptions.description LIKE ?l", "%" . trim($params['feature_name']) . "%");
}
if (!empty($params['category_ids'])) {
$c_ids = is_array($params['category_ids']) ? $params['category_ids'] : fn_explode(',', $params['category_ids']);
$find_set = array(" ?:product_filters.categories_path = '' ");
foreach ($c_ids as $k => $v) {
$find_set[] = db_quote(" FIND_IN_SET(?i, ?:product_filters.categories_path) ", $v);
}
$find_in_set = db_quote(" AND (?p)", implode('OR', $find_set));
$condition .= $find_in_set;
}
if (fn_allowed_for('ULTIMATE')) {
$condition .= fn_get_company_condition('?:product_filters.company_id');
}
$limit = '';
if (!empty($params['items_per_page'])) {
$params['total_items'] = db_get_field("SELECT COUNT(*) FROM ?:product_filters LEFT JOIN ?:product_filter_descriptions ON ?:product_filter_descriptions.lang_code = ?s AND ?:product_filter_descriptions.filter_id = ?:product_filters.filter_id LEFT JOIN ?:product_features_descriptions ON ?:product_features_descriptions.feature_id = ?:product_filters.feature_id AND ?:product_features_descriptions.lang_code = ?s LEFT JOIN ?:product_features ON ?:product_features.feature_id = ?:product_filters.feature_id WHERE 1 ?p", $lang_code, $lang_code, $condition);
$limit = db_paginate($params['page'], $params['items_per_page']);
}
$fields = "";
if (!empty($params['short'])) {
$fields .= db_quote("?:product_filters.filter_id, ?:product_filters.feature_id, ?:product_filters.field_type, ?:product_filters.status, ");
if (fn_allowed_for('ULTIMATE')) {
$fields .= db_quote("?:product_filters.company_id, ");
}
} else {
$fields .= db_quote("?:product_filters.*, ?:product_features_descriptions.description as feature, ");
}
$fields .= db_quote("?:product_filter_descriptions.filter, ?:product_features.feature_type, ?:product_features.parent_id, ?:product_features_descriptions.prefix, ?:product_features_descriptions.suffix");
$join = db_quote("LEFT JOIN ?:product_filter_descriptions ON ?:product_filter_descriptions.lang_code = ?s AND ?:product_filter_descriptions.filter_id = ?:product_filters.filter_id LEFT JOIN ?:product_features_descriptions ON ?:product_features_descriptions.feature_id = ?:product_filters.feature_id AND ?:product_features_descriptions.lang_code = ?s LEFT JOIN ?:product_features ON ?:product_features.feature_id = ?:product_filters.feature_id", $lang_code, $lang_code);
$sorting = db_quote("?:product_filters.position, ?:product_filter_descriptions.filter");
$group_by = db_quote("GROUP BY ?:product_filters.filter_id");
/**
* Changes SQL parameters for product filters select
*
* @param string $fields String of comma-separated SQL fields to be selected in an SQL-query
* @param string $join String with the complete JOIN information (JOIN type, tables and fields) for an SQL-query
* @param string $condition String containing SQL-query condition possibly prepended with a logical operator (AND or OR)
* @param string $group_by String containing the SQL-query GROUP BY field
* @param string $sorting String containing the SQL-query ORDER BY clause
* @param string $limit String containing the SQL-query LIMIT clause
* @param array $params Products filter search params
* @param string $lang_code 2-letter language code (e.g. 'en', 'ru', etc.)
*/
fn_set_hook('get_product_filters_before_select', $fields, $join, $condition, $group_by, $sorting, $limit, $params, $lang_code);
$filters = db_get_hash_array("SELECT {$fields} FROM ?:product_filters {$join} WHERE 1 ?p {$group_by} ORDER BY {$sorting} {$limit}", 'filter_id', $condition);
if (!empty($filters)) {
$fields = fn_get_product_filter_fields();
// Get feature group if exist
$parent_ids = array();
foreach ($filters as $k => $v) {
if (!empty($v['parent_id'])) {
$parent_ids[] = $v['parent_id'];
}
}
$groups = db_get_hash_array("SELECT feature_id, description FROM ?:product_features_descriptions WHERE feature_id IN (?n) AND lang_code = ?s", 'feature_id', $parent_ids, $lang_code);
foreach ($filters as $k => $filter) {
if (!empty($filter['parent_id']) && !empty($groups[$filter['parent_id']])) {
$filters[$k]['feature_group'] = $groups[$filter['parent_id']]['description'];
}
if (!empty($filter['field_type'])) {
$filters[$k]['feature'] = __($fields[$filter['field_type']]['description']);
}
if (empty($filter['feature_id'])) {
$filters[$k]['condition_type'] = $fields[$filter['field_type']]['condition_type'];
}
if (!empty($fields[$filter['field_type']]['slider'])) {
$filters[$k]['slider'] = $fields[$filter['field_type']]['slider'];
}
if (!empty($params['get_descriptions'])) {
$d = array();
$filters[$k]['filter_description'] = __('filter_by') . ': <span>' . $filters[$k]['feature'] . (!empty($filters[$k]['feature_group']) ? ' (' . $filters[$k]['feature_group'] . ' )' : '') . '</span>';
if ($filter['show_on_home_page'] == 'Y') {
$d[] = __('home_page');
}
$d = fn_array_merge($d, fn_get_categories_list($filter['categories_path'], $lang_code), false);
$filters[$k]['filter_description'] .= ' | ' . __('display_on') . ': <span>' . implode(', ', $d) . '</span>';
}
$_ids[$filter['filter_id']] = $filter['feature_type'] != 'N' ? $filter['feature_id'] : null;
}
if (!empty($params['get_variants'])) {
$ranges = db_get_hash_array("SELECT ?:product_filter_ranges.*, ?:product_filter_ranges_descriptions.range_name FROM ?:product_filter_ranges LEFT JOIN ?:product_filter_ranges_descriptions ON ?:product_filter_ranges_descriptions.range_id = ?:product_filter_ranges.range_id AND ?:product_filter_ranges_descriptions.lang_code = ?s WHERE filter_id IN (?a) ORDER BY position", 'range_id', $lang_code, array_keys($_ids));
if (!empty($ranges)) {
foreach ($ranges as $range_id => $range) {
unset($_ids[$range['filter_id']]);
$filters[$range['filter_id']]['ranges'][$range_id] = $range;
}
}
unset($ranges);
if (!empty($_ids)) {
list($variants) = fn_get_product_feature_variants(array('feature_id' => array_values($_ids)));
$_ids_revert = array();
foreach ($_ids as $filter_id => $feature_id) {
if (!empty($feature_id)) {
$_ids_revert[$feature_id][] = $filter_id;
}
}
foreach ($variants as $variant_id => $variant) {
if (!empty($_ids_revert[$variant['feature_id']])) {
foreach ($_ids_revert[$variant['feature_id']] as $filter_id) {
if (!empty($params['short'])) {
$filters[$filter_id]['ranges'][$variant_id] = array('variant_id' => $variant['variant_id'], 'variant' => $variant['variant']);
} else {
$filters[$filter_id]['ranges'][$variant_id] = $variant;
}
}
}
unset($variants[$variant_id]);
}
unset($variants);
}
unset($_ids);
}
}
/**
* Changes product filters data
*
* @param array $filters Product filters
* @param array $params Products filter search params
* @param string $lang_code 2-letter language code (e.g. 'en', 'ru', etc.)
*/
fn_set_hook('get_product_filters_post', $filters, $params, $lang_code);
return array($filters, $params);
}
function fn_ls_get_product_filters($category_id = null, $lang_code = DESCR_SL)
{
$condition = '';
if ($category_id) {
$condition .= db_quote(" AND ?:product_filters.categories_path LIKE '%,?i,%'", $category_id);
}
$fields = "";
if (!empty($params['short'])) {
$fields .= db_quote("?:product_filters.filter_id, ?:product_filters.feature_id, ?:product_filters.field_type, ?:product_filters.status, ");
if (fn_allowed_for('ULTIMATE')) {
$fields .= db_quote("?:product_filters.company_id, ");
}
} else {
$fields .= db_quote("?:product_filters.*, ?:product_features_descriptions.description as feature, ");
}
$fields .= db_quote("?:product_filter_descriptions.filter, ?:product_features.feature_type, ?:product_features.parent_id, ?:product_features_descriptions.prefix, ?:product_features_descriptions.suffix");
$join = db_quote("LEFT JOIN ?:product_filter_descriptions ON ?:product_filter_descriptions.lang_code = ?s AND ?:product_filter_descriptions.filter_id = ?:product_filters.filter_id LEFT JOIN ?:product_features_descriptions ON ?:product_features_descriptions.feature_id = ?:product_filters.feature_id AND ?:product_features_descriptions.lang_code = ?s LEFT JOIN ?:product_features ON ?:product_features.feature_id = ?:product_filters.feature_id", $lang_code, $lang_code);
$sorting = db_quote("?:product_filters.position, ?:product_filter_descriptions.filter");
$group_by = db_quote("GROUP BY ?:product_filters.filter_id");
/**
* Changes SQL parameters for product filters select
*
* @param string $fields String of comma-separated SQL fields to be selected in an SQL-query
* @param string $join String with the complete JOIN information (JOIN type, tables and fields) for an SQL-query
* @param string $condition String containing SQL-query condition possibly prepended with a logical operator (AND or OR)
* @param string $group_by String containing the SQL-query GROUP BY field
* @param string $sorting String containing the SQL-query ORDER BY clause
* @param string $limit String containing the SQL-query LIMIT clause
* @param array $params Products filter search params
* @param string $lang_code 2-letter language code (e.g. 'en', 'ru', etc.)
*/
fn_set_hook('get_product_filters_before_select', $fields, $join, $condition, $group_by, $sorting, $limit, $params, $lang_code);
$filters = db_get_hash_array("SELECT {$fields} FROM ?:product_filters {$join} WHERE 1 ?p {$group_by} ORDER BY {$sorting} {$limit}", 'filter_id', $condition);
if (!empty($filters)) {
$fields = fn_get_product_filter_fields();
// Get feature group if exist
$parent_ids = array();
foreach ($filters as $k => $v) {
if (!empty($v['parent_id'])) {
$parent_ids[] = $v['parent_id'];
}
}
$groups = db_get_hash_array("SELECT feature_id, description FROM ?:product_features_descriptions WHERE feature_id IN (?n) AND lang_code = ?s", 'feature_id', $parent_ids, $lang_code);
foreach ($filters as $k => $filter) {
if (!empty($filter['parent_id']) && !empty($groups[$filter['parent_id']])) {
$filters[$k]['feature_group'] = $groups[$filter['parent_id']]['description'];
}
if (!empty($filter['field_type'])) {
$filters[$k]['feature'] = __($fields[$filter['field_type']]['description']);
}
if (empty($filter['feature_id'])) {
$filters[$k]['condition_type'] = $fields[$filter['field_type']]['condition_type'];
}
if (!empty($fields[$filter['field_type']]['slider'])) {
$filters[$k]['slider'] = $fields[$filter['field_type']]['slider'];
}
if (!empty($params['get_descriptions'])) {
$d = array();
$filters[$k]['filter_description'] = __('filter_by') . ': <span>' . $filters[$k]['feature'] . (!empty($filters[$k]['feature_group']) ? ' (' . $filters[$k]['feature_group'] . ' )' : '') . '</span>';
if ($filter['show_on_home_page'] == 'Y') {
$d[] = __('home_page');
}
$d = fn_array_merge($d, fn_get_categories_list($filter['categories_path'], $lang_code), false);
$filters[$k]['filter_description'] .= ' | ' . __('display_on') . ': <span>' . implode(', ', $d) . '</span>';
}
$_ids[$filter['filter_id']] = $filter['feature_type'] != 'N' ? $filter['feature_id'] : null;
}
}
return $filters;
}
function fn_get_product_filters($params = array(), $items_per_page = 0, $lang_code = DESCR_SL)
{
// Init filter
$params = fn_init_view('product_filters', $params);
// Set default values to input params
$params['page'] = empty($params['page']) ? 1 : $params['page'];
// default page is 1
$condition = $group = '';
if (!empty($params['filter_id'])) {
$condition .= db_quote(" AND ?:product_filters.filter_id = ?i", $params['filter_id']);
}
if (isset($params['filter_name']) && fn_string_no_empty($params['filter_name'])) {
$condition .= db_quote(" AND ?:product_filter_descriptions.filter LIKE ?l", "%" . trim($params['filter_name']) . "%");
}
if (isset($params['feature_name']) && fn_string_no_empty($params['feature_name'])) {
$condition .= db_quote(" AND ?:product_features_descriptions.description LIKE ?l", "%" . trim($params['feature_name']) . "%");
}
if (!empty($params['category_ids'])) {
$c_ids = is_array($params['category_ids']) ? $params['category_ids'] : fn_explode(',', $params['category_ids']);
$find_set = array(" ?:product_filters.categories_path = '' ");
foreach ($c_ids as $k => $v) {
$find_set[] = db_quote(" FIND_IN_SET(?i, ?:product_filters.categories_path) ", $v);
}
$find_in_set = db_quote(" AND (?p)", implode('OR', $find_set));
$condition .= $find_in_set;
}
$limit = '';
if (!empty($items_per_page)) {
$total = db_get_field("SELECT COUNT(*) FROM ?:product_filters LEFT JOIN ?:product_filter_descriptions ON ?:product_filter_descriptions.lang_code = ?s AND ?:product_filter_descriptions.filter_id = ?:product_filters.filter_id LEFT JOIN ?:product_features_descriptions ON ?:product_features_descriptions.feature_id = ?:product_filters.feature_id AND ?:product_features_descriptions.lang_code = ?s LEFT JOIN ?:product_features ON ?:product_features.feature_id = ?:product_filters.feature_id WHERE 1 ?p", $lang_code, $lang_code, $condition);
$limit = fn_paginate($params['page'], $total, $items_per_page);
}
$filters = db_get_hash_array("SELECT ?:product_filters.*, ?:product_filter_descriptions.filter, ?:product_features.feature_type, ?:product_features.parent_id, ?:product_features_descriptions.description as feature, ?:product_features_descriptions.prefix, ?:product_features_descriptions.suffix FROM ?:product_filters LEFT JOIN ?:product_filter_descriptions ON ?:product_filter_descriptions.lang_code = ?s AND ?:product_filter_descriptions.filter_id = ?:product_filters.filter_id LEFT JOIN ?:product_features_descriptions ON ?:product_features_descriptions.feature_id = ?:product_filters.feature_id AND ?:product_features_descriptions.lang_code = ?s LEFT JOIN ?:product_features ON ?:product_features.feature_id = ?:product_filters.feature_id WHERE 1 ?p GROUP BY ?:product_filters.filter_id ORDER BY ?:product_filters.position, ?:product_filter_descriptions.filter {$limit}", 'filter_id', $lang_code, $lang_code, $condition);
if (!empty($filters)) {
$fields = fn_get_product_filter_fields();
// Get feature group if exist
$parent_ids = array();
foreach ($filters as $k => $v) {
if (!empty($v['parent_id'])) {
$parent_ids[$v['parent_id']] = true;
}
}
$groups = db_get_hash_array("SELECT feature_id, description FROM ?:product_features_descriptions WHERE feature_id IN (?n) AND lang_code = ?s", 'feature_id', array_keys($parent_ids), $lang_code);
foreach ($filters as $k => $filter) {
if (!empty($filter['parent_id']) && !empty($groups[$filter['parent_id']])) {
$filters[$k]['feature_group'] = $groups[$filter['parent_id']]['description'];
}
if (!empty($filter['field_type'])) {
$filters[$k]['feature'] = fn_get_lang_var($fields[$filter['field_type']]['description']);
}
if (empty($filter['feature_id'])) {
$filters[$k]['condition_type'] = $fields[$filter['field_type']]['condition_type'];
}
if (!empty($params['get_descriptions'])) {
$d = array();
$filters[$k]['filter_description'] = fn_get_lang_var('filter_by') . ': <strong>' . $filters[$k]['feature'] . (!empty($filters[$k]['feature_group']) ? ' (' . $filters[$k]['feature_group'] . ' )' : '') . '</strong>';
if ($filter['show_on_home_page'] == 'Y') {
$d[] = fn_get_lang_var('home_page');
}
$d = fn_array_merge($d, fn_get_categories_list($filter['categories_path'], $lang_code), false);
$filters[$k]['filter_description'] .= ' | ' . fn_get_lang_var('display_on') . ': <strong>' . implode(', ', $d) . '</strong>';
}
if (!empty($params['get_variants'])) {
$filters[$k]['ranges'] = db_get_array("SELECT ?:product_filter_ranges.*, ?:product_filter_ranges_descriptions.range_name FROM ?:product_filter_ranges LEFT JOIN ?:product_filter_ranges_descriptions ON ?:product_filter_ranges_descriptions.range_id = ?:product_filter_ranges.range_id AND ?:product_filter_ranges_descriptions.lang_code = ?s WHERE filter_id = ?i ORDER BY position", $lang_code, $filter['filter_id']);
if (empty($filters[$k]['ranges']) && !empty($filter['feature_id']) && $filter['feature_type'] != 'N') {
$filters[$k]['ranges'] = fn_get_product_feature_variants($filter['feature_id'], 0, $filter['feature_type']);
}
}
}
}
return array($filters, $params);
}
