function fn_get_tags($params = array(), $items_per_page = 0) { // Init filter $params = LastView::instance()->update('tags', $params); $default_params = array('page' => 1, 'items_per_page' => $items_per_page); $params = array_merge($default_params, $params); // Define sort fields $sortings = array('tag' => '?:tags.tag', 'status' => '?:tags.status', 'popularity' => 'popularity', 'users' => 'users'); $conditions = fn_tags_build_conditions($params); $sorting = db_sort($params, $sortings, 'tag', 'asc'); $limit = ''; if (!empty($params['limit'])) { $limit = db_quote(' LIMIT 0, ?i', $params['limit']); } elseif (!empty($params['items_per_page'])) { $params['total_items'] = db_get_field("SELECT COUNT(DISTINCT(?:tags.tag_id)) FROM ?:tags LEFT JOIN ?:tag_links ON ?:tags.tag_id = ?:tag_links.tag_id WHERE 1 ?p", $conditions); $limit = db_paginate($params['page'], $params['items_per_page'], $params['total_items']); } $tags = db_get_hash_array("SELECT ?:tags.tag_id, ?:tag_links.object_id, ?:tag_links.object_type, ?:tags.tag, ?:tags.status, COUNT(?:tag_links.tag_id) as popularity " . "FROM ?:tags LEFT JOIN ?:tag_links ON ?:tag_links.tag_id = ?:tags.tag_id WHERE 1 ?p GROUP BY ?:tags.tag_id {$sorting} {$limit}", 'tag_id', $conditions); if (!empty($params['count_objects'])) { $objs = db_get_array("SELECT tag_id, COUNT(DISTINCT(object_id)) as count, object_type " . "FROM ?:tag_links WHERE tag_id IN (?n) GROUP BY tag_id, object_type", array_keys($tags)); foreach ($objs as $v) { $tags[$v['tag_id']]['objects_count'][$v['object_type']] = $v['count']; } } // Generate popularity level foreach ($tags as $k => $v) { $level = ceil(log($v['popularity'])); $tags[$k]['level'] = $level > TAGS_MAX_LEVEL ? TAGS_MAX_LEVEL : $level; } if (!empty($params['sort_popular'])) { $tags = fn_sort_array_by_key($tags, 'tag', SORT_ASC); } return array($tags, $params); }
function fn_get_seo_rules($params = array(), $items_per_page = 0, $lang_code = DESCR_SL) { $condition = fn_get_seo_company_condition('?:seo_names.company_id'); $lang_code = fn_get_corrected_seo_lang_code($lang_code); $global_total = db_get_fields("SELECT dispatch FROM ?:seo_names WHERE object_id = '0' AND type = 's' ?p GROUP BY dispatch", $condition); $local_total = db_get_fields("SELECT dispatch FROM ?:seo_names WHERE object_id = '0' AND type = 's' AND lang_code = ?s ?p", $lang_code, $condition); if ($diff = array_diff($global_total, $local_total)) { foreach ($diff as $disp) { fn_create_seo_name(0, 's', str_replace('.', '-', $disp), 0, $disp, '', DESCR_SL); } } // Init filter $params = LastView::instance()->update('seo_rules', $params); // Set default values to input params $default_params = array('page' => 1, 'items_per_page' => $items_per_page); $params = array_merge($default_params, $params); if (isset($params['name']) && fn_string_not_empty($params['name'])) { $condition .= db_quote(" AND name LIKE ?l", "%" . trim($params['name']) . "%"); } if (isset($params['rule_params']) && fn_string_not_empty($params['rule_params'])) { $condition .= db_quote(" AND dispatch LIKE ?l", "%" . trim($params['rule_params']) . "%"); } $limit = ''; if (!empty($params['items_per_page'])) { $params['total_items'] = db_get_field("SELECT COUNT(*) FROM ?:seo_names WHERE object_id = '0' AND type = 's' AND lang_code = ?s ?p", $lang_code, $condition); $limit = db_paginate($params['page'], $params['items_per_page'], $params['total_items']); } $seo_data = db_get_array("SELECT name, dispatch FROM ?:seo_names WHERE object_id = '0' AND type = 's' AND lang_code = ?s ?p ORDER BY dispatch {$limit}", $lang_code, $condition); return array($seo_data, $params); }
function fn_get_seo_redirects($params = array(), $items_per_page = 0, $lang_code = DESCR_SL) { // Init filter $params = LastView::instance()->update('seo_redirects', $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 = ''; if (isset($params['src']) && fn_string_not_empty($params['src'])) { $condition .= db_quote(" AND src LIKE ?l", "%" . trim($params['src']) . "%"); } if (!empty($params['type'])) { $condition .= db_quote(" AND type = ?s", $params['type']); } if (!empty($params['lang_code'])) { $condition .= db_quote(" AND lang_code = ?s", $params['lang_code']); } $condition .= fn_get_seo_company_condition('?:seo_redirects.company_id'); $limit = ''; if (!empty($params['items_per_page'])) { $params['total_items'] = db_get_field("SELECT COUNT(*) FROM ?:seo_redirects WHERE 1 ?p", $condition); $limit = db_paginate($params['page'], $params['items_per_page']); } $seo_redirects = db_get_hash_array("SELECT * FROM ?:seo_redirects WHERE 1 ?p ORDER BY src {$limit}", 'redirect_id', $condition); if (!empty($seo_redirects)) { foreach ($seo_redirects as $key => $seo_redirect) { $seo_redirects[$key]['parsed_url'] = fn_generate_seo_url_from_schema($seo_redirect); } } return array($seo_redirects, $params); }
public static function getVariables($params, $items_per_page = 0, $lang_code = DESCR_SL) { // Set default values to input params $default_params = array('page' => 1, 'items_per_page' => $items_per_page); $params = array_merge($default_params, $params); $fields = array('lang.value' => true, 'lang.name' => true); if (!empty($params['fields'])) { $fields = array_merge($fields, $params['fields']); } $tables = array('?:language_values as lang'); $left_join = array(); $condition = array(); $condition['param1'] = db_quote('lang.lang_code = ?s', $lang_code); if (isset($params['q']) && fn_string_not_empty($params['q'])) { $condition['param2'] = db_quote('(lang.name LIKE ?l OR lang.value LIKE ?l)', '%' . trim($params['q']) . '%', '%' . trim($params['q']) . '%'); } fn_set_hook('get_language_variable', $fields, $tables, $left_join, $condition, $params); $joins = !empty($left_join) ? ' LEFT JOIN ' . implode(', ', $left_join) : ''; $limit = ''; if (!empty($params['items_per_page'])) { $params['total_items'] = db_get_field('SELECT COUNT(*) FROM ' . implode(', ', $tables) . $joins . ' WHERE ' . implode(' AND ', $condition)); $limit = db_paginate($params['page'], $params['items_per_page'], $params['total_items']); } $lang_data = db_get_array('SELECT ' . implode(', ', array_keys($fields)) . ' FROM ' . implode(', ', $tables) . $joins . ' WHERE ' . implode(' AND ', $condition) . ' ORDER BY lang.name ' . $limit); return array($lang_data, $params); }
/** * Get promotions * * @param array $params array with search params * @param int $items_per_page * @param string $lang_code * @return array list of promotions in first element, filtered parameters in second */ function fn_get_promotions($params, $items_per_page = 0, $lang_code = CART_LANGUAGE) { // Init filter $params = LastView::instance()->update('promotions', $params); // Set default values to input params $default_params = array('page' => 1, 'items_per_page' => $items_per_page, 'get_hidden' => true); $params = array_merge($default_params, $params); // Define fields that should be retrieved $fields = array("?:promotions.*", "?:promotion_descriptions.name", "?:promotion_descriptions.detailed_description", "?:promotion_descriptions.short_description"); // Define sort fields $sortings = array('name' => "?:promotion_descriptions.name", 'priority' => "?:promotions.priority", 'zone' => "?:promotions.zone", 'status' => "?:promotions.status"); $condition = $join = $group = ''; $condition .= fn_get_company_condition('?:promotions.company_id'); $statuses = array('A'); if (!empty($params['get_hidden'])) { $statuses[] = 'H'; } if (!empty($params['promotion_id'])) { $condition .= db_quote(' AND ?:promotions.promotion_id IN (?n)', $params['promotion_id']); } if (!empty($params['active'])) { $condition .= db_quote(" AND IF(from_date, from_date <= ?i, 1) AND IF(to_date, to_date >= ?i, 1) AND status IN (?a)", TIME, TIME, $statuses); } if (fn_allowed_for('ULTIMATE:FREE')) { $params['zone'] = 'catalog'; } if (!empty($params['zone'])) { $condition .= db_quote(" AND ?:promotions.zone = ?s", $params['zone']); } if (!empty($params['coupon_code'])) { $condition .= db_quote(" AND (CONCAT(LOWER(?:promotions.conditions_hash), ';') LIKE ?l OR CONCAT(LOWER(?:promotions.conditions_hash), ';') LIKE ?l)", "%coupon_code={$params['coupon_code']};%", "%auto_coupons={$params['coupon_code']};%"); } if (!empty($params['coupons'])) { $condition .= db_quote(" AND ?:promotions.conditions_hash LIKE ?l", "%coupon_code=%"); } if (!empty($params['auto_coupons'])) { $condition .= db_quote(" AND ?:promotions.conditions_hash LIKE ?l", "%auto_coupons=%"); } $join .= db_quote(" LEFT JOIN ?:promotion_descriptions ON ?:promotion_descriptions.promotion_id = ?:promotions.promotion_id AND ?:promotion_descriptions.lang_code = ?s", $lang_code); fn_set_hook('get_promotions', $params, $fields, $sortings, $condition, $join); $sorting = db_sort($params, $sortings, 'name', 'desc'); $limit = ''; if (!empty($params['items_per_page'])) { $params['total_items'] = db_get_field("SELECT COUNT(*) FROM ?:promotions {$join} WHERE 1 {$condition} {$group}"); $limit = db_paginate($params['page'], $params['items_per_page'], $params['total_items']); } if (!empty($params['simple'])) { return db_get_hash_single_array("SELECT ?:promotions.promotion_id, ?:promotion_descriptions.name FROM ?:promotions {$join} WHERE 1 {$condition} {$group} {$sorting} {$limit}", array('promotion_id', 'name')); } else { $promotions = db_get_hash_array('SELECT ' . implode(', ', $fields) . " FROM ?:promotions {$join} WHERE 1 {$condition} {$group} {$sorting} {$limit}", 'promotion_id'); } if (!empty($params['expand'])) { foreach ($promotions as $k => $v) { $promotions[$k]['conditions'] = !empty($v['conditions']) ? unserialize($v['conditions']) : array(); $promotions[$k]['bonuses'] = !empty($v['bonuses']) ? unserialize($v['bonuses']) : array(); } } return array($promotions, $params); }
function fn_get_restricted_locations($params, $items_per_page, $lang_code = CART_LANGUAGE) { $default_params = array('page' => 1, 'q' => '', 'match' => 'any', 'items_per_page' => $items_per_page); $params = array_merge($default_params, $params); $fields = array('?:restricted_locations.*', '?:restricted_location_descriptions.*', '?:country_descriptions.country as country_title'); $join = db_quote(" LEFT JOIN ?:restricted_location_descriptions ON ?:restricted_locations.restricted_location_id = ?:restricted_location_descriptions.restricted_location_id AND ?:restricted_location_descriptions.lang_code = ?s", $lang_code); $join .= db_quote(" LEFT JOIN ?:country_descriptions ON ?:restricted_locations.country = ?:country_descriptions.code AND ?:country_descriptions.lang_code = ?s", $lang_code); $condition = 1; if (AREA == 'C') { $condition .= " AND status = 'A'"; } // Search string condition for SQL query if (!empty($params['q'])) { if ($params['match'] == 'any') { $pieces = explode(' ', $params['q']); $search_type = ' OR '; } elseif ($params['match'] == 'all') { $pieces = explode(' ', $params['q']); $search_type = ' AND '; } else { $pieces = array($params['q']); $search_type = ''; } $_condition = array(); foreach ($pieces as $piece) { $tmp = db_quote("?:restricted_location_descriptions.name LIKE ?l", "%{$piece}%"); // check search words $tmp .= db_quote(" OR ?:restricted_location_descriptions.description LIKE ?l", "%{$piece}%"); $tmp .= db_quote(" OR ?:restricted_location_descriptions.city LIKE ?l", "%{$piece}%"); $tmp .= db_quote(" OR ?:country_descriptions.country LIKE ?l", "%{$piece}%"); $_condition[] = '(' . $tmp . ')'; } $_cond = implode($search_type, $_condition); if (!empty($_condition)) { $condition .= ' AND (' . $_cond . ') '; } unset($_condition); } $condition .= AREA == 'C' && defined('CART_LOCALIZATION') ? fn_get_localizations_condition('?:restricted_locations.localization') : ''; $sorting = "?:restricted_location_descriptions.name"; $limit = ''; if (!empty($params['items_per_page'])) { $params['total_items'] = db_get_field("SELECT COUNT(?:restricted_locations.restricted_location_id) FROM ?:restricted_locations ?p WHERE ?p", $join, $condition); //Get total item count $limit = db_paginate($params['page'], $params['items_per_page'], $params['total_items']); //Generate SQL condition to get only the necessary items } $data = db_get_array('SELECT ?p FROM ?:restricted_locations ?p WHERE ?p GROUP BY ?:restricted_locations.restricted_location_id ORDER BY ?p ?p', implode(', ', $fields), $join, $condition, $sorting, $limit); return array($data, $params); }
function fn_gift_registry_get_userlog($params, $items_per_page = 0) { // Set default values to input params $default_params = array('page' => 1, 'items_per_page' => $items_per_page); $params = array_merge($default_params, $params); $sortings = array('timestamp' => 'timestamp', 'amount' => 'amount'); $sorting = db_sort($params, $sortings, 'timestamp', 'desc'); $limit = ''; if (!empty($params['items_per_page'])) { $params['total_items'] = db_get_field("SELECT COUNT(*) FROM ?:reward_point_changes WHERE user_id = ?i", $params['user_id']); $limit = db_paginate($params['page'], $params['items_per_page'], $params['total_items']); } $userlog = db_get_array("SELECT change_id, action, timestamp, amount, reason FROM ?:reward_point_changes WHERE user_id = ?i {$sorting} {$limit}", $params['user_id']); return array($userlog, $params); }
public function prepare() { $this->result = ''; $table_name = $this->model->getTableName(); $field = $this->model->getPrimaryField(); if (!empty($this->params['items_per_page']) || !empty($this->params['get_count'])) { if (empty($this->params['page'])) { $this->params['page'] = 1; } $this->params['total_items'] = db_get_field("SELECT COUNT(DISTINCT({$table_name}.{$field}))" . " FROM {$table_name}" . $this->joins->get() . $this->condition->get()); if (!empty($this->params['items_per_page'])) { $this->result = db_paginate($this->params['page'], $this->params['items_per_page']); } } if (!empty($this->params['limit'])) { $this->result = db_quote(' LIMIT 0, ?i', $this->params['limit']); } }
function fn_get_feedbacks($params, $items_per_page, $lang_code = CART_LANGUAGE) { $params = LastView::instance()->update('feedbacks', $params); $default_params = array('page' => 1, 'items_per_page' => $items_per_page); $params = array_merge($default_params, $params); $fields = array("?:orders_feedback.feedback_id", "?:orders_feedback.statuses", "?:orders_feedback.subject", "?:orders_feedback.remind_in", "?:orders_feedback.status", "?:orders_feedback.lang_code"); $sortings = array('feedback_id' => "?:orders_feedback.feedback_id", 'subject' => "?:orders_feedback.subject", 'statuses' => "?:orders_feedback.statuses", 'remind_in' => "?:orders_feedback.remind_in"); $condition = $_condition = $join = $group = ''; /*conditions*/ $condition .= db_quote(' AND lang_code = ?s', $lang_code); /*conditions*/ $sorting = db_sort($params, $sortings, 'feedback_id', 'desc'); $limit = ''; if (!empty($params['items_per_page'])) { $params['total_items'] = db_get_field("SELECT COUNT(?:orders_feedback.feedback_id) FROM ?:orders_feedback {$join} WHERE 1 {$condition}"); $limit = db_paginate($params['page'], $params['items_per_page']); } $feedbacks = db_get_array('SELECT ' . implode(', ', $fields) . " FROM ?:orders_feedback {$join} WHERE 1 {$condition} {$group} {$sorting} {$limit}"); LastView::instance()->processResults('feedbacks', $feedbacks, $params); return array($feedbacks, $params); }
/** * Gets products default navigation * * @param array $params Request params * @return array navigation data */ function fn_lv_get_product_default_navigation($params) { if (empty($params['product_id'])) { return false; } $update_data = array(); $product_id = $params['product_id']; if (fn_allowed_for('ULTIMATE') && Registry::get('runtime.company_id')) { $company_condition = fn_get_company_condition('c.company_id'); $category_id = db_get_field("SELECT c.category_id, IF(pc.link_type = ?s, 1, 0) as is_main FROM ?:categories AS c LEFT JOIN ?:products_categories AS pc ON c.category_id = pc.category_id WHERE pc.product_id = ?i {$company_condition} ORDER BY is_main DESC", 'M', $product_id); } else { $category_id = db_get_field("SELECT category_id FROM ?:products_categories WHERE product_id = ?i AND link_type = ?s", $product_id, 'M'); } if (empty($category_id)) { return false; } $search_params = array('cid' => $category_id, 'get_conditions' => true); list($fields, $join, $condition) = fn_get_products($search_params); $sorting = "ORDER BY descr1.product asc"; // get product position in full list db_query("SET @r = 0;"); $product_position = db_get_field("SELECT a.row FROM (SELECT products.product_id, @r := @r + 1 as row FROM ?:products as products {$join} WHERE 1 {$condition} GROUP BY products.product_id {$sorting}) AS a WHERE a.product_id = ?i", $product_id); $items_per_page = Registry::get('settings.Appearance.products_per_page'); if (empty($product_position) || empty($items_per_page)) { return false; } $page = ceil($product_position / $items_per_page); $limit = db_paginate($page, $items_per_page); $stored_items_ids[$page] = db_get_fields("SELECT SQL_CALC_FOUND_ROWS products.product_id FROM ?:products as products {$join} WHERE 1 {$condition} GROUP BY products.product_id {$sorting} {$limit}"); $total_items = db_get_found_rows(); $total_pages = ceil($total_items / $items_per_page); unset($search_params['get_conditions']); $update_data['params'] = serialize($search_params); $update_data['view_results'] = array('items_ids' => $stored_items_ids, 'total_pages' => $total_pages, 'items_per_page' => $items_per_page, 'total_items' => $total_items); $update_data['view_results'] = serialize($update_data['view_results']); return $update_data; }
if ($page_number == 1) { if (!empty($offers_features[$offer_key]['product_fields'])) { $product_objects = array(); foreach ($offers_features[$offer_key]['product_fields'] as $product_field) { $product_objects[] = array('id' => 'product.' . $product_field, 'text' => __('yml2_product_field_' . $product_field)); } $objects[] = array('id' => 'product_fields', 'text' => __('yml_export.product_fields'), 'children' => $product_objects); } } $statuses = array('A'); $fields = db_quote("?:product_features.feature_id, ?:product_features_descriptions.description"); $join = db_quote("LEFT JOIN ?:product_features_descriptions ON ?:product_features_descriptions.feature_id = ?:product_features.feature_id AND ?:product_features_descriptions.lang_code = ?s", $lang_code); $condition = db_quote("AND ?:product_features.status IN (?a) AND ?:product_features.feature_type != ?s", $statuses, ProductFeatures::GROUP); if (!empty($search_query)) { $condition .= db_quote(' AND ?:product_features_descriptions.description LIKE ?l', '%' . trim($search_query) . '%'); } $total_items = 1; if (!empty($page_size)) { $total_items = db_get_field("SELECT COUNT(*) FROM ?:product_features {$join} WHERE 1 {$condition}"); $limit = db_paginate($page_number, $page_size, $total_items); } $features = db_get_hash_array("SELECT {$fields} FROM ?:product_features {$join} WHERE 1 {$condition} ORDER BY ?:product_features.position {$limit}", 'feature_id'); $feature_objects = array(); foreach ($features as $feature) { $feature_objects[] = array('id' => 'feature.' . $feature['feature_id'], 'text' => $feature['description']); } $objects[] = array('id' => 'product_features', 'text' => __('yml_export.product_features'), 'children' => $feature_objects); Tygh::$app['ajax']->assign('objects', $objects); Tygh::$app['ajax']->assign('total_objects', $total_items); exit; }
function fn_get_rma_returns($params, $items_per_page = 0) { // Init filter $params = LastView::instance()->update('rma', $params); // Set default values to input params $default_params = array('page' => 1, 'items_per_page' => $items_per_page); $params = array_merge($default_params, $params); // Define fields that should be retrieved $fields = array('DISTINCT ?:rma_returns.return_id', '?:rma_returns.order_id', '?:rma_returns.timestamp', '?:rma_returns.status', '?:rma_returns.total_amount', '?:rma_property_descriptions.property AS action', '?:users.firstname', '?:users.lastname'); // Define sort fields $sortings = array('return_id' => "?:rma_returns.return_id", 'timestamp' => "?:rma_returns.timestamp", 'order_id' => "?:rma_returns.order_id", 'status' => "?:rma_returns.status", 'amount' => "?:rma_returns.total_amount", 'action' => "?:rma_returns.action", 'customer' => "?:users.lastname"); $sorting = db_sort($params, $sortings, 'timestamp', 'desc'); $join = $condition = $group = ''; if (isset($params['cname']) && fn_string_not_empty($params['cname'])) { $arr = fn_explode(' ', $params['cname']); foreach ($arr as $k => $v) { if (!fn_string_not_empty($v)) { unset($arr[$k]); } } if (sizeof($arr) == 2) { $condition .= db_quote(" AND ?:users.firstname LIKE ?l AND ?:users.lastname LIKE ?l", "%" . array_shift($arr) . "%", "%" . array_shift($arr) . "%"); } else { $condition .= db_quote(" AND (?:users.firstname LIKE ?l OR ?:users.lastname LIKE ?l)", "%" . trim($params['cname']) . "%", "%" . trim($params['cname']) . "%"); } } if (isset($params['email']) && fn_string_not_empty($params['email'])) { $condition .= db_quote(" AND ?:users.email LIKE ?l", "%" . trim($params['email']) . "%"); } if (isset($params['rma_amount_from']) && fn_is_numeric($params['rma_amount_from'])) { $condition .= db_quote("AND ?:rma_returns.total_amount >= ?d", $params['rma_amount_from']); } if (isset($params['rma_amount_to']) && fn_is_numeric($params['rma_amount_to'])) { $condition .= db_quote("AND ?:rma_returns.total_amount <= ?d", $params['rma_amount_to']); } if (!empty($params['action'])) { $condition .= db_quote(" AND ?:rma_returns.action = ?s", $params['action']); } if (!empty($params['return_id'])) { $condition .= db_quote(" AND ?:rma_returns.return_id = ?i", $params['return_id']); } if (!empty($params['request_status'])) { $condition .= db_quote(" AND ?:rma_returns.status IN (?a)", $params['request_status']); } if (!empty($params['period']) && $params['period'] != 'A') { list($params['time_from'], $params['time_to']) = fn_create_periods($params); $condition .= db_quote(" AND (?:rma_returns.timestamp >= ?i AND ?:rma_returns.timestamp <= ?i)", $params['time_from'], $params['time_to']); } if (!empty($params['order_id'])) { $condition .= db_quote(" AND ?:rma_returns.order_id = ?i", $params['order_id']); } if (isset($params['user_id'])) { $condition .= db_quote(" AND ?:rma_returns.user_id = ?i", $params['user_id']); } if (!empty($params['order_status'])) { $condition .= db_quote(" AND ?:orders.status IN (?a)", $params['order_status']); } if (!empty($params['p_ids']) || !empty($params['product_view_id'])) { $arr = strpos($params['p_ids'], ',') !== false || !is_array($params['p_ids']) ? explode(',', $params['p_ids']) : $params['p_ids']; if (empty($params['product_view_id'])) { $condition .= db_quote(" AND ?:order_details.product_id IN (?n)", $arr); } else { $condition .= db_quote(" AND ?:order_details.product_id IN (?n)", db_get_fields(fn_get_products(array('view_id' => $params['product_view_id'], 'get_query' => true)))); } $join .= " LEFT JOIN ?:order_details ON ?:order_details.order_id = ?:orders.order_id"; $group .= db_quote(" GROUP BY ?:rma_returns.return_id HAVING COUNT(?:orders.order_id) >= ?i", count($arr)); } $limit = ''; if (!empty($params['items_per_page'])) { $params['total_items'] = db_get_field("SELECT COUNT(DISTINCT ?:rma_returns.return_id) FROM ?:rma_returns LEFT JOIN ?:rma_return_products ON ?:rma_return_products.return_id = ?:rma_returns.return_id LEFT JOIN ?:rma_property_descriptions ON ?:rma_property_descriptions.property_id = ?:rma_returns.action LEFT JOIN ?:users ON ?:rma_returns.user_id = ?:users.user_id LEFT JOIN ?:orders ON ?:rma_returns.order_id = ?:orders.order_id {$join} WHERE 1 {$condition} {$group}"); $limit = db_paginate($params['page'], $params['items_per_page'], $params['total_items']); } $return_requests = db_get_array("SELECT " . implode(', ', $fields) . " FROM ?:rma_returns LEFT JOIN ?:rma_return_products ON ?:rma_return_products.return_id = ?:rma_returns.return_id LEFT JOIN ?:rma_property_descriptions ON (?:rma_property_descriptions.property_id = ?:rma_returns.action AND ?:rma_property_descriptions.lang_code = ?s) LEFT JOIN ?:users ON ?:rma_returns.user_id = ?:users.user_id LEFT JOIN ?:orders ON ?:rma_returns.order_id = ?:orders.order_id {$join} WHERE 1 {$condition} {$group} {$sorting} {$limit}", AREA == 'C' ? CART_LANGUAGE : DESCR_SL); LastView::instance()->processResults('rma_returns', $return_requests, $params); return array($return_requests, $params); }
/** * Gets company data array * * @param array $params Array of search params: * <ul> * <li>string company - Name of company</li> * <li>string status - Status of company</li> * <li>string email - Email of company</li> * <li>string address - Address of company</li> * <li>string zipcode - Zipcode of company</li> * <li>string country - 2-letters country code of company country</li> * <li>string state - State code of company</li> * <li>string city - City of company</li> * <li>string phone - Phone of company</li> * <li>string url - URL address of company</li> * <li>string fax - Fax number of company</li> * <li>mixed company_id - Company ID, array with company IDs or comma-separated list of company IDs. * If defined, data will be returned only for companies with such company IDs.</li> * <li>int exclude_company_id - Company ID, if defined, * result array will not include the data for company with such company ID.</li> * <li>int page - First page to displaying list of companies (if <i>$items_per_page</i> it not empty.</li> * <li>string sort_order - <i>ASC</i> or <i>DESC</i>: database query sorting order</li> * <li>string sort_by - One or list of database fields for sorting.</li> * </ul> * @param array $auth Array of user authentication data (e.g. uid, usergroup_ids, etc.) * @param int $items_per_page * @param string $lang_code 2-letter language code (e.g. 'en', 'ru', etc.) * @return array Array: * <ul> * <li>0 - First element is array with companies data.</li> * <li>1 - is possibly modified array with searh params (<i>$params</i>).</li> * </ul> */ function fn_get_companies($params, &$auth, $items_per_page = 0, $lang_code = CART_LANGUAGE) { // Init filter $_view = 'companies'; $params = LastView::instance()->update($_view, $params); // Set default values to input params $default_params = array('page' => 1, 'items_per_page' => $items_per_page); $params = array_merge($default_params, $params); // Define fields that should be retrieved $fields = array('?:companies.company_id', '?:companies.lang_code', '?:companies.email', '?:companies.company', '?:companies.timestamp', '?:companies.status'); if (fn_allowed_for('ULTIMATE')) { $fields[] = '?:companies.storefront'; $fields[] = '?:companies.secure_storefront'; } // Define sort fields $sortings = array('id' => '?:companies.company_id', 'company' => '?:companies.company', 'email' => '?:companies.email', 'date' => '?:companies.timestamp', 'status' => '?:companies.status'); if (fn_allowed_for('ULTIMATE')) { $sortings['storefront'] = '?:companies.storefront'; } $condition = $join = $group = ''; $condition .= fn_get_company_condition('?:companies.company_id'); $group .= " GROUP BY ?:companies.company_id"; if (isset($params['company']) && fn_string_not_empty($params['company'])) { $condition .= db_quote(" AND ?:companies.company LIKE ?l", "%" . trim($params['company']) . "%"); } if (!empty($params['status'])) { if (is_array($params['status'])) { $condition .= db_quote(" AND ?:companies.status IN (?a)", $params['status']); } else { $condition .= db_quote(" AND ?:companies.status = ?s", $params['status']); } } if (isset($params['email']) && fn_string_not_empty($params['email'])) { $condition .= db_quote(" AND ?:companies.email LIKE ?l", "%" . trim($params['email']) . "%"); } if (isset($params['address']) && fn_string_not_empty($params['address'])) { $condition .= db_quote(" AND ?:companies.address LIKE ?l", "%" . trim($params['address']) . "%"); } if (isset($params['zipcode']) && fn_string_not_empty($params['zipcode'])) { $condition .= db_quote(" AND ?:companies.zipcode LIKE ?l", "%" . trim($params['zipcode']) . "%"); } if (!empty($params['country'])) { $condition .= db_quote(" AND ?:companies.country = ?s", $params['country']); } if (isset($params['state']) && fn_string_not_empty($params['state'])) { $condition .= db_quote(" AND ?:companies.state LIKE ?l", "%" . trim($params['state']) . "%"); } if (isset($params['city']) && fn_string_not_empty($params['city'])) { $condition .= db_quote(" AND ?:companies.city LIKE ?l", "%" . trim($params['city']) . "%"); } if (isset($params['phone']) && fn_string_not_empty($params['phone'])) { $condition .= db_quote(" AND ?:companies.phone LIKE ?l", "%" . trim($params['phone']) . "%"); } if (isset($params['url']) && fn_string_not_empty($params['url'])) { $condition .= db_quote(" AND ?:companies.url LIKE ?l", "%" . trim($params['url']) . "%"); } if (isset($params['fax']) && fn_string_not_empty($params['fax'])) { $condition .= db_quote(" AND ?:companies.fax LIKE ?l", "%" . trim($params['fax']) . "%"); } if (!empty($params['company_id'])) { $condition .= db_quote(' AND ?:companies.company_id IN (?n)', $params['company_id']); } if (!empty($params['exclude_company_id'])) { $condition .= db_quote(' AND ?:companies.company_id != ?i', $params['exclude_company_id']); } fn_set_hook('get_companies', $params, $fields, $sortings, $condition, $join, $auth, $lang_code, $group); $sorting = db_sort($params, $sortings, 'company', 'asc'); // Paginate search results $limit = ''; if (!empty($params['items_per_page'])) { $params['total_items'] = db_get_field("SELECT COUNT(DISTINCT(?:companies.company_id)) FROM ?:companies {$join} WHERE 1 {$condition}"); $limit = db_paginate($params['page'], $params['items_per_page']); } $companies = db_get_array("SELECT " . implode(', ', $fields) . " FROM ?:companies {$join} WHERE 1 {$condition} {$group} {$sorting} {$limit}"); return array($companies, $params); }
/** * Gets states list * * @param array $params search params * @param int $items_per_page number of states per page. Gets all if zero * @param string $lang_code language code * @return array 2 elements array, first - found states, second - filtered input params */ function fn_get_states($params = array(), $items_per_page = 0, $lang_code = CART_LANGUAGE) { // Set default values to input params $default_params = array('page' => 1, 'items_per_page' => $items_per_page); $params = array_merge($default_params, $params); $fields = array('a.state_id', 'a.country_code', 'a.code', 'a.status', 'b.state', 'c.country'); $condition = '1'; if (!empty($params['only_avail'])) { $condition .= db_quote(" AND a.status = ?s", 'A'); } if (!empty($params['q'])) { $condition .= db_quote(" AND b.state LIKE ?l", '%' . $params['q'] . '%'); } if (!empty($params['country_code'])) { $condition .= db_quote(" AND a.country_code = ?s", $params['country_code']); } $limit = ''; if (!empty($params['items_per_page'])) { $params['total_items'] = db_get_field("SELECT count(*) FROM ?:states as a WHERE ?p", $condition); $limit = db_paginate($params['page'], $params['items_per_page']); } $states = db_get_array("SELECT " . implode(', ', $fields) . " FROM ?:states as a " . "LEFT JOIN ?:state_descriptions as b ON b.state_id = a.state_id AND b.lang_code = ?s " . "LEFT JOIN ?:country_descriptions as c ON c.code = a.country_code AND c.lang_code = ?s " . "WHERE ?p ORDER BY c.country, b.state {$limit}", $lang_code, $lang_code, $condition); return array($states, $params); }
function fn_get_product_options_inventory($params, $items_per_page = 0, $lang_code = DESCR_SL) { $default_params = array('page' => 1, 'product_id' => 0, 'items_per_page' => $items_per_page); $params = array_merge($default_params, $params); $limit = ''; if (!empty($params['items_per_page'])) { $params['total_items'] = db_get_field("SELECT COUNT(*) FROM ?:product_options_inventory WHERE product_id = ?i", $params['product_id']); $limit = db_paginate($params['page'], $params['items_per_page']); } $inventory = db_get_array("SELECT * FROM ?:product_options_inventory WHERE product_id = ?i ORDER BY position {$limit}", $params['product_id']); foreach ($inventory as $k => $v) { $inventory[$k]['combination'] = fn_get_product_options_by_combination($v['combination']); $inventory[$k]['image_pairs'] = fn_get_image_pairs($v['combination_hash'], 'product_option', 'M', true, true, $lang_code); $inventory[$k]['additional_image_pairs'] = fn_get_image_pairs($v['combination_hash'], 'product_option', 'A', true, true, $lang_code); } $product_options = fn_get_product_options($params['product_id'], $lang_code, true, true); $product_inventory = db_get_field("SELECT tracking FROM ?:products WHERE product_id = ?i", $params['product_id']); return array($inventory, $params, $product_options, $product_inventory); }
function fn_get_review_posts_1($thread_id = 0, $page = 0, $first_limit = '', $random = 'N') { $sets = Registry::get('addons.discussion'); $discussion_object_types = fn_get_discussion_objects(); if (empty($thread_id)) { return false; } $thread_data = db_get_row("SELECT type, object_type FROM ?:discussion WHERE thread_id = ?i", $thread_id); if ($thread_data['type'] == 'D') { return false; } $join = $fields = ''; if ($thread_data['type'] == 'C' || $thread_data['type'] == 'B') { $join .= " LEFT JOIN ?:discussion_messages ON ?:discussion_messages.post_id = ?:discussion_posts.post_id "; $fields .= ", ?:discussion_messages.message"; } if ($thread_data['type'] == 'R' || $thread_data['type'] == 'B') { $join .= " LEFT JOIN ?:discussion_rating ON ?:discussion_rating.post_id = ?:discussion_posts.post_id "; $fields .= ", ?:discussion_rating.rating_value"; $fields .= ', ?:discussion_messages.message_title'; } $status_cond = AREA == 'A' ? '' : " AND ?:discussion_posts.status = 'A'"; $total_pages = db_get_field("SELECT COUNT(*) FROM ?:discussion_posts WHERE thread_id = ?i {$status_cond}", $thread_id); if ($first_limit != '') { $limit = "LIMIT {$first_limit}"; } else { $params['total_items'] = $total_pages; $limit = db_paginate($params['page'], $params['items_per_page']); // $limit = fn_paginate($page, $total_pages, $sets[$discussion_object_types[$thread_data['object_type']] . '_posts_per_page']); } $sort = isset($_REQUEST['sort_review']) && $_REQUEST['sort_review'] != 'DF' ? $_REQUEST['sort_review'] : ''; // if discussion type is C do not sort by rating if ($thread_data['type'] == 'C' && ($sort == 'HR' || $sort == 'LR')) { $sort = ''; } switch ($sort) { case 'MH': $fields .= ', SUM(?:review_likes.is_like) as is_l'; $order_by = 'is_l DESC'; $join .= ' JOIN ?:review_likes ON ?:discussion_posts.post_id = ?:review_likes.post_id '; $status_cond .= ' GROUP BY ?:review_likes.post_id '; break; case 'HR': $fields .= ', AVG(?:review_rating.rating) as rating'; $order_by = 'rating DESC'; $join .= ' JOIN ?:review_rating ON ?:discussion_posts.post_id = ?:review_rating.post_id '; $status_cond .= ' GROUP BY ?:review_rating.post_id '; break; case 'LR': $fields .= ', AVG(?:review_rating.rating) as rating'; $order_by = 'rating ASC'; $join .= ' JOIN ?:review_rating ON ?:discussion_posts.post_id = ?:review_rating.post_id '; $status_cond .= ' GROUP BY ?:review_rating.post_id '; break; case 'OD': $order_by = '?:discussion_posts.timestamp ASC'; break; default: $order_by = $random == 'N' ? '?:discussion_posts.timestamp DESC' : 'RAND()'; } $posts = db_get_array("SELECT ?:discussion_posts.* {$fields} FROM ?:discussion_posts {$join} WHERE ?:discussion_posts.thread_id = ?i {$status_cond} ORDER BY ?p {$limit}", $thread_id, $order_by); if (!empty($posts) && is_array($posts)) { foreach ($posts as $k => $post) { $is_like = db_get_field("SELECT COUNT(is_like) FROM ?:review_likes WHERE post_id = ?i AND is_like = '1'", $post['post_id']); $votes = db_get_field('SELECT COUNT(is_like) FROM ?:review_likes WHERE post_id = ?i', $post['post_id']); $posts[$k]['likes']['yes'] = $is_like ? $is_like : 0; $posts[$k]['likes']['votes'] = $votes ? $votes : 0; } } return $posts; }
/** * Returns list of pages * <i>$params</i> - Array of various parameters used for element selection: * <ul> * <li>page_id - If defined and not zero, get data for the page with this id; otherwise get data for all pages</li> * <li>item_ids - A comma-delimited page identifiers list; if defined, get data for the pages with these ids; otherwise get data for all pages</li> * <li>except_id - Identifier of the page to be excluded from the result</li> * <li>parent_id - If defined and not zero, get data for the pages with this parent page id</li> * <li>active_page_id - Identifier of the page being currently shown</li> * <li>current_page_id - The same as <i>active_page_id</i></li> * * <li>add_root - If defined, additionally returns root element data</li> * <li>subpages - If defined, additionally returns subpages</li> * <li>get_tree - If defined, pages will be returned as tree; otherwise as list. Possible value: <i>plain</i></li> * <li>visible - For pages tree: show visible branch only</li> * * <li>page - Number of the current page for pagination</li> * * <li>pdescr - If defined, additionally returns descriptions. Possible value: <i>Y</i></li> * * <li>vendor_pages - If defined, try to return pages for the company defined by <i>company_id</i></li> * <li>company_id - If <i>vendor_pages</i> is defined: if defined, get data for the company with this id</li> * * <li>neighbours - If defined, try to return neighbor pages for the page with the id <i>neighbours_page_id</i></li> * <li>neighbours_page_id - If <i>neighbours</i> is defined: if defined, get neighbor pages for the page with this id</li> * * <li>limit - If defined, used to limit your MySQL query results by this value</li> * <li>sort_by - Table field to sort by, default is position</li> * <li>sort_order - Sorting direction, ascending or descending; Possible values: <i>asc</i> or <i>desc</i>, default is <i>asc</i></li> * * <li>status - If defined, returns pages only with this status. Can be comma delimited statuses list</li> * * <li>period - If defined, get pages by time period. Time period is generated by ::fn_create_periods</li> * <li>time_from - Returns pages created earlier than this time</li> * <li>time_to - Returns pages created later than this time</li> * * <li>parent_page_id - Deprecated, <i>parent_id</i> used instead</li> * <li>from_page_id - Deprecated, <i>parent_id</i> used instead</li> * </ul> * @param array $params Array of params * @param int $items_per_page Limit items per page * @param string $lang_code 2-letter language code * @return array List of pages, params */ function fn_get_pages($params = array(), $items_per_page = 0, $lang_code = CART_LANGUAGE) { /** * Changes params for selecting pages * * @param array $params Pages search params * @param int $items_per_page Items per page * @param string $lang_code Two-letter language code (e.g. 'en', 'ru', etc.) */ fn_set_hook('get_pages_pre', $params, $items_per_page, $lang_code); $view_type = 'pages'; if (!empty($params['page_type']) && fn_is_exclusive_page_type($params['page_type'])) { $view_type .= '_' . $params['page_type']; } // Init filter $params = LastView::instance()->update($view_type, $params); $default_params = array('page_id' => 0, 'page' => 1, 'visible' => false, 'get_tree' => '', 'pdescr' => '', 'subpages' => '', 'match' => '', 'page_type' => '', 'items_per_page' => $items_per_page); if (is_array($params)) { $params = array_merge($default_params, $params); } else { $params = $default_params; } if (empty($params['pname']) && empty($params['pdescr']) && empty($params['subpages'])) { $params['pname'] = 'Y'; } $fields = array('?:pages.*'); if (!empty($params['simple'])) { $fields[] = '?:page_descriptions.page'; } else { $fields[] = '?:page_descriptions.*'; } // Define sort fields $sortings = array('position' => array('?:pages.position', '?:page_descriptions.page'), 'name' => '?:page_descriptions.page', 'timestamp' => '?:pages.timestamp', 'type' => '?:pages.page_type', 'multi_level' => array('?:pages.parent_id', '?:pages.position', '?:page_descriptions.page')); $auth =& $_SESSION['auth']; $condition = '1'; $join = $limit = $group_by = ''; if (isset($params['q']) && fn_string_not_empty($params['q'])) { $params['q'] = trim($params['q']); if ($params['match'] == 'any') { $pieces = fn_explode(' ', $params['q']); $search_type = ' OR '; } elseif ($params['match'] == 'all') { $pieces = fn_explode(' ', $params['q']); $search_type = ' AND '; } else { $pieces = array($params['q']); $search_type = ''; } $_condition = array(); foreach ($pieces as $piece) { if (strlen($piece) == 0) { continue; } $tmp = array(); if (!empty($params['pname']) && $params['pname'] == 'Y') { $tmp[] = db_quote("?:page_descriptions.page LIKE ?l", "%{$piece}%"); // check search words } if ($params['pdescr'] == 'Y') { $tmp[] = db_quote("?:page_descriptions.description LIKE ?l", "%{$piece}%"); } if (!empty($tmp)) { $_condition[] = '(' . implode(' OR ', $tmp) . ')'; } } if (!empty($_condition)) { $condition .= ' AND (' . implode($search_type, $_condition) . ')'; } } $condition .= fn_get_company_condition('?:pages.company_id'); if (isset($params['parent_id']) && $params['parent_id'] !== '') { $p_ids = array(); if ($params['subpages'] == 'Y') { $p_ids = db_get_fields("SELECT a.page_id FROM ?:pages as a LEFT JOIN ?:pages as b ON b.page_id = ?i WHERE a.id_path LIKE CONCAT(b.id_path, '/%')", $params['parent_id']); } $p_ids[] = $params['parent_id']; $condition .= db_quote(" AND ?:pages.parent_id IN (?n)", $p_ids); } if (isset($params['parent_page_id'])) { // set parent id, that was set in block properties $params['from_page_id'] = $params['parent_page_id']; } if (!empty($params['from_page_id'])) { $from_id_path = db_get_field("SELECT id_path FROM ?:pages WHERE page_id = ?i", $params['from_page_id']); $condition .= db_quote(" AND ?:pages.id_path LIKE ?l", "{$from_id_path}/%"); } if (!empty($params['status'])) { $condition .= db_quote(" AND ?:pages.status IN (?a)", $params['status']); } if (!empty($params['vendor_pages']) && empty($params['company_id'])) { return array(array(), $params); } elseif (!empty($params['company_id'])) { $condition .= db_quote(" AND ?:pages.company_id = ?i", $params['company_id']); } if (empty($params['full_search'])) { $condition .= db_quote(" AND ?:pages.page_type IN (?a)", array_keys(fn_get_page_type_filter($params['page_type']))); } if (!empty($params['visible'])) { // for pages tree: show visible branch only $page_ids = array(); if (!empty($params['current_page_id'])) { $cur_id_path = db_get_field("SELECT id_path FROM ?:pages WHERE page_id = ?i", $params['current_page_id']); if (!empty($cur_id_path)) { $page_ids = explode('/', $cur_id_path); } } if (!empty($from_id_path)) { $_page_ids = explode('/', $from_id_path); $page_ids = array_merge($page_ids, $_page_ids); $page_ids = array_unique($page_ids); } $page_ids[] = $params['page_id']; $condition .= db_quote(" AND ?:pages.parent_id IN (?n)", $page_ids); } if (!empty($params['period']) && $params['period'] != 'A') { list($params['time_from'], $params['time_to']) = fn_create_periods($params); $condition .= db_quote(" AND (?:pages.timestamp >= ?i AND ?:pages.timestamp <= ?i)", $params['time_from'], $params['time_to']); } if (!empty($params['item_ids'])) { // get only defined pages $condition .= db_quote(" AND ?:pages.page_id IN (?n)", explode(',', $params['item_ids'])); } if (!empty($params['except_id']) && (empty($params['item_ids']) || !empty($params['item_ids']) && !in_array($params['except_id'], explode(',', $params['item_ids'])))) { $condition .= db_quote(' AND ?:pages.page_id != ?i AND ?:pages.parent_id != ?i', $params['except_id'], $params['except_id']); } if (AREA != 'A') { $condition .= " AND (" . fn_find_array_in_set($auth['usergroup_ids'], '?:pages.usergroup_ids', true) . ")"; $condition .= fn_get_localizations_condition('?:pages.localization', true); $condition .= db_quote(" AND (use_avail_period = ?s OR (use_avail_period = ?s AND avail_from_timestamp <= ?i AND avail_till_timestamp >= ?i))", 'N', 'Y', TIME, TIME); } $join = db_quote('LEFT JOIN ?:page_descriptions ON ?:pages.page_id = ?:page_descriptions.page_id AND ?:page_descriptions.lang_code = ?s', $lang_code); if (!empty($params['limit'])) { $limit = db_quote(" LIMIT 0, ?i", $params['limit']); } if (!empty($params['neighbours'])) { $parent_ids = array(); if (!empty($params['neighbours_page_id'])) { $id_path = db_get_field("SELECT id_path FROM ?:pages WHERE page_id = ?i", $params['neighbours_page_id']); $parent_ids = explode('/', $id_path); if (count($parent_ids) == 1) { array_unshift($parent_ids, 0); } $params['root_id'] = $parent_ids[0]; } else { $parent_ids[] = 0; } $condition .= db_quote(" AND ?:pages.parent_id IN (?n)", array_unique($parent_ids)); } fn_set_hook('get_pages', $params, $join, $condition, $fields, $group_by, $sortings, $lang_code); if (!empty($params['get_tree'])) { $params['sort_by'] = 'multi_level'; } $sorting = db_sort($params, $sortings, 'position', 'asc'); if (!empty($group_by)) { $group_by = ' GROUP BY ' . $group_by; } // Get search conditions if (!empty($params['get_conditions'])) { return array($fields, $join, $condition); } if (!empty($params['items_per_page'])) { $params['total_items'] = db_get_field("SELECT COUNT(DISTINCT(?:pages.page_id)) FROM ?:pages ?p WHERE ?p ?p ?p", $join, $condition, $group_by, $sorting); $limit = db_paginate($params['page'], $params['items_per_page'], $params['total_items']); } $pages = db_get_hash_array("SELECT " . implode(', ', $fields) . " FROM ?:pages ?p WHERE ?p ?p ?p ?p", 'page_id', $join, $condition, $group_by, $sorting, $limit); if (!empty($params['active_page_id']) && !empty($pages[$params['active_page_id']])) { $pages[$params['active_page_id']]['active'] = true; Registry::set('runtime.active_page_ids', explode('/', $pages[$params['active_page_id']]['id_path'])); } if (!empty($pages)) { foreach ($pages as $k => $v) { $pages[$k]['level'] = substr_count($v['id_path'], '/'); } if (!empty($params['get_tree'])) { $delete_keys = array(); foreach ($pages as $k => $v) { if (!empty($v['parent_id']) && !empty($pages[$v['parent_id']])) { $pages[$v['parent_id']]['subpages'][$v['page_id']] =& $pages[$k]; $delete_keys[] = $k; } if (!empty($v['parent_id']) && (!isset($params['root_id']) && empty($pages[$v['parent_id']]) || isset($params['root_id']) && $v['parent_id'] != $params['root_id']) && (empty($params['from_page_id']) || $params['from_page_id'] != $v['parent_id'])) { // delete pages that don't have parent. FIXME: should be done on database layer $delete_keys[] = $k; } } foreach ($delete_keys as $k) { unset($pages[$k]); } } elseif (!empty($params['item_ids'])) { $pages = fn_sort_by_ids($pages, explode(',', $params['item_ids']), 'page_id'); } if ($params['get_tree'] == 'plain') { $pages = fn_multi_level_to_plain($pages, 'subpages'); } if (!empty($params['get_children_count'])) { $where_condition = !empty($params['except_id']) ? db_quote(' AND page_id != ?i', $params['except_id']) : ''; if ($params['get_tree'] == 'plain') { $_page_ids = array(); foreach ($pages as $_p) { $_page_ids[] = $_p['page_id']; } } else { $_page_ids = array_keys($pages); } $children = db_get_hash_single_array("SELECT parent_id, COUNT(page_id) as children FROM ?:pages WHERE parent_id IN (?n) ?p GROUP BY parent_id", array('parent_id', 'children'), $_page_ids, $where_condition); if (!empty($children)) { if ($params['get_tree'] == 'plain') { foreach ($pages as $_id => $_p) { if (!empty($children[$_p['page_id']])) { $pages[$_id]['has_children'] = true; } } } else { foreach ($children as $k => $v) { $pages[$k]['has_children'] = !empty($v); } } } } } if (!empty($params['add_root'])) { array_unshift($pages, array('page_id' => '', 'page' => $params['add_root'])); } fn_dropdown_appearance_cut_second_third_levels($pages, 'subpages', $params); fn_set_hook('post_get_pages', $pages, $params, $lang_code); LastView::instance()->processResults($view_type, $pages, $params); return array($pages, $params); }
function fn_twg_get_logs($params = array()) { $items_per_page = TWG_RESPONSE_ITEMS_LIMIT; $page = empty($params['page']) ? 1 : $params['page']; $condition = db_quote(" WHERE type IN('users', 'products', 'orders') AND action != 'session'"); if (Registry::get('runtime.company_id')) { $condition .= db_quote(" AND ?:logs.company_id = ?i", Registry::get('runtime.company_id')); } $limit = ''; if (!empty($items_per_page)) { $total = db_get_field("SELECT COUNT(DISTINCT(?:logs.log_id)) FROM ?:logs ?p", $condition); $limit = db_paginate($page, $items_per_page); } $data = db_get_array("SELECT * FROM ?:logs ?p ORDER BY log_id desc {$limit}", $condition); foreach ($data as $k => $v) { $data[$k]['backtrace'] = !empty($v['backtrace']) ? unserialize($v['backtrace']) : array(); $data[$k]['content'] = !empty($v['content']) ? unserialize($v['content']) : array(); } $params = array('page' => $page, 'items_per_page' => $items_per_page, 'total_items' => $total, 'total_pages' => ceil((int) $total / $items_per_page)); return array($data, $params); }
function fn_get_call_requests($params = array(), $lang_code = CART_LANGUAGE) { // Init filter $params = LastView::instance()->update('call_requests', $params); $params = array_merge(array('items_per_page' => 0, 'page' => 1), $params); $fields = array('r.*', 'o.status as order_status', 'd.product'); $joins = array(db_quote("LEFT JOIN ?:users u USING(user_id)"), db_quote("LEFT JOIN ?:orders o USING(order_id)"), db_quote("LEFT JOIN ?:product_descriptions d ON d.product_id = r.product_id AND d.lang_code = ?s", $lang_code)); $sortings = array('id' => 'r.request_id', 'date' => 'r.timestamp', 'status' => 'r.status', 'name' => 'r.name', 'phone' => 'r.phone', 'user_id' => 'r.user_id', 'user' => array('u.lastname', 'u.firstname'), 'order' => 'r.order_id', 'order_status' => 'o.status'); $condition = array(); if (isset($params['id']) && fn_string_not_empty($params['id'])) { $params['id'] = trim($params['id']); $condition[] = db_quote("r.request_id = ?i", $params['id']); } if (isset($params['name']) && fn_string_not_empty($params['name'])) { $params['name'] = trim($params['name']); $condition[] = db_quote("r.name LIKE ?l", '%' . $params['name'] . '%'); } if (isset($params['phone']) && fn_string_not_empty($params['phone'])) { $params['phone'] = trim($params['phone']); $condition[] = db_quote("r.phone LIKE ?l", '%' . $params['phone'] . '%'); } if (!empty($params['status'])) { $condition[] = db_quote("r.status = ?s", $params['status']); } if (!empty($params['order_status'])) { $condition[] = db_quote("o.status = ?s", $params['order_status']); } if (!empty($params['user_id'])) { $condition[] = db_quote("r.user_id = ?s", $params['user_id']); } if (!empty($params['order_exists'])) { $sign = $params['order_exists'] == 'Y' ? '<>' : '='; $condition[] = db_quote("r.order_id ?p 0", $sign); } $fields_str = implode(', ', $fields); $joins_str = ' ' . implode(' ', $joins); $condition_str = $condition ? ' WHERE ' . implode(' AND ', $condition) : ''; $sorting_str = db_sort($params, $sortings, 'date', 'desc'); $limit = ''; if (!empty($params['items_per_page'])) { $params['total_items'] = db_get_field("SELECT COUNT(r.request_id) FROM ?:call_requests r" . $joins_str . $condition_str); $limit = db_paginate($params['page'], $params['items_per_page'], $params['total_items']); } $items = db_get_array("SELECT " . $fields_str . " FROM ?:call_requests r" . $joins_str . $condition_str . $sorting_str . $limit); if (!empty($items)) { $cart_product_ids = array(); foreach ($items as &$item) { if (!empty($item['cart_products'])) { $item['cart_products'] = unserialize($item['cart_products']); foreach ($item['cart_products'] as $cart_product) { $cart_product_ids[] = $cart_product['product_id']; } } } $cart_product_names = db_get_hash_single_array("SELECT product_id, product FROM ?:product_descriptions WHERE product_id IN(?n) AND lang_code = ?s", array('product_id', 'product'), array_unique($cart_product_ids), $lang_code); foreach ($items as &$item) { if (!empty($item['cart_products'])) { foreach ($item['cart_products'] as &$cart_product) { if (!empty($cart_product_names[$cart_product['product_id']])) { $cart_product['product'] = $cart_product_names[$cart_product['product_id']]; } } } } } return array($items, $params); }
function fn_get_shipments_info($params, $items_per_page = 0) { // Init view params $params = LastView::instance()->update('shipments', $params); // Set default values to input params $default_params = array('page' => 1, 'items_per_page' => $items_per_page); $params = array_merge($default_params, $params); $fields_list = array('?:shipments.shipment_id', '?:shipments.timestamp AS shipment_timestamp', '?:shipments.comments', '?:shipment_items.order_id', '?:orders.timestamp AS order_timestamp', '?:orders.s_firstname', '?:orders.s_lastname', '?:orders.user_id'); $joins = array('LEFT JOIN ?:shipment_items ON (?:shipments.shipment_id = ?:shipment_items.shipment_id)', 'LEFT JOIN ?:orders ON (?:shipment_items.order_id = ?:orders.order_id)'); $condition = ''; if (Registry::get('runtime.company_id')) { $joins[] = 'LEFT JOIN ?:companies ON (?:companies.company_id = ?:orders.company_id)'; $condition = db_quote(' AND ?:companies.company_id = ?i', Registry::get('runtime.company_id')); } $group = array('?:shipments.shipment_id'); // Define sort fields $sortings = array('id' => "?:shipments.shipment_id", 'order_id' => "?:orders.order_id", 'shipment_date' => "?:shipments.timestamp", 'order_date' => "?:orders.timestamp", 'customer' => array("?:orders.s_lastname", "?:orders.s_firstname")); $sorting = db_sort($params, $sortings, 'id', 'desc'); if (isset($params['advanced_info']) && $params['advanced_info']) { $fields_list[] = '?:shipments.shipping_id'; $fields_list[] = '?:shipping_descriptions.shipping AS shipping'; $fields_list[] = '?:shipments.tracking_number'; $fields_list[] = '?:shipments.carrier'; $joins[] = ' LEFT JOIN ?:shippings ON (?:shipments.shipping_id = ?:shippings.shipping_id)'; $joins[] = db_quote(' LEFT JOIN ?:shipping_descriptions ON (?:shippings.shipping_id = ?:shipping_descriptions.shipping_id AND ?:shipping_descriptions.lang_code = ?s)', DESCR_SL); } if (!empty($params['order_id'])) { $condition .= db_quote(' AND ?:shipment_items.order_id = ?i', $params['order_id']); } if (!empty($params['shipment_id'])) { $condition .= db_quote(' AND ?:shipments.shipment_id = ?i', $params['shipment_id']); } if (isset($params['cname']) && fn_string_not_empty($params['cname'])) { $arr = fn_explode(' ', $params['cname']); foreach ($arr as $k => $v) { if (!fn_string_not_empty($v)) { unset($arr[$k]); } } if (sizeof($arr) == 2) { $condition .= db_quote(" AND ?:orders.firstname LIKE ?l AND ?:orders.lastname LIKE ?l", "%" . array_shift($arr) . "%", "%" . array_shift($arr) . "%"); } else { $condition .= db_quote(" AND (?:orders.firstname LIKE ?l OR ?:orders.lastname LIKE ?l)", "%" . trim($params['cname']) . "%", "%" . trim($params['cname']) . "%"); } } if (!empty($params['p_ids']) || !empty($params['product_view_id'])) { $arr = strpos($params['p_ids'], ',') !== false || !is_array($params['p_ids']) ? explode(',', $params['p_ids']) : $params['p_ids']; if (empty($params['product_view_id'])) { $condition .= db_quote(" AND ?:shipment_items.product_id IN (?n)", $arr); } else { $condition .= db_quote(" AND ?:shipment_items.product_id IN (?n)", db_get_fields(fn_get_products(array('view_id' => $params['product_view_id'], 'get_query' => true)), ',')); } $joins[] = "LEFT JOIN ?:order_details ON ?:order_details.order_id = ?:orders.order_id"; } if (!empty($params['shipment_period']) && $params['shipment_period'] != 'A') { $params['time_from'] = $params['shipment_time_from']; $params['time_to'] = $params['shipment_time_to']; $params['period'] = $params['shipment_period']; list($params['shipment_time_from'], $params['shipment_time_to']) = fn_create_periods($params); $condition .= db_quote(" AND (?:shipments.timestamp >= ?i AND ?:shipments.timestamp <= ?i)", $params['shipment_time_from'], $params['shipment_time_to']); } if (!empty($params['order_period']) && $params['order_period'] != 'A') { $params['time_from'] = $params['order_time_from']; $params['time_to'] = $params['order_time_to']; $params['period'] = $params['order_period']; list($params['order_time_from'], $params['order_time_to']) = fn_create_periods($params); $condition .= db_quote(" AND (?:orders.timestamp >= ?i AND ?:orders.timestamp <= ?i)", $params['order_time_from'], $params['order_time_to']); } fn_set_hook('get_shipments', $params, $fields_list, $joins, $condition, $group); $fields_list = implode(', ', $fields_list); $joins = implode(' ', $joins); $group = implode(', ', $group); if (!empty($group)) { $group = ' GROUP BY ' . $group; } $limit = ''; if (!empty($params['items_per_page'])) { $params['total_items'] = db_get_field("SELECT COUNT(DISTINCT(?:shipments.shipment_id)) FROM ?:shipments {$joins} WHERE 1 {$condition}"); $limit = db_paginate($params['page'], $params['items_per_page'], $params['total_items']); } $shipments = db_get_array("SELECT {$fields_list} FROM ?:shipments {$joins} WHERE 1 {$condition} {$group} {$sorting} {$limit}"); if (isset($params['advanced_info']) && $params['advanced_info'] && !empty($shipments)) { $shipment = reset($shipments); $order_info = fn_get_order_info($shipment['order_id']); foreach ($shipments as $id => $shipment) { $items = db_get_array('SELECT item_id, amount FROM ?:shipment_items WHERE shipment_id = ?i', $shipment['shipment_id']); if (!empty($items)) { foreach ($items as $item) { $shipments[$id]['products'][$item['item_id']] = $item['amount']; if (!empty($order_info['products'][$item['item_id']]['extra']['group_key'])) { $shipments[$id]['group_key'] = $order_info['products'][$item['item_id']]['extra']['group_key']; } else { $shipments[$id]['group_key'] = 0; } } } } if (Settings::instance()->getValue('use_shipments', '', $order_info['company_id']) != 'Y') { foreach ($shipments as $id => $shipment) { $shipments[$id]['one_full'] = true; foreach ($order_info['products'] as $product_key => $product) { $group_key = !empty($product['extra']['group_key']) ? $product['extra']['group_key'] : 0; if ($shipment['group_key'] == $group_key) { if (empty($shipment['products'][$product_key]) || $shipment['products'][$product_key] < $product['amount']) { $shipments[$id]['one_full'] = false; break; } } } } } } /** * Changes selected shipments * * @param array $shipments Array of shipments * @param array $params Shipments search params */ fn_set_hook('get_shipments_info_post', $shipments, $params); LastView::instance()->processResults('shipments_info', $shipments, $params); return array($shipments, $params); }
function fn_rus_sdek_get_status($params = array(), $items_per_page = 0) { $condition = ''; $_view = 'sdek_status'; $params = LastView::instance()->update($_view, $params); $default_params = array('page' => 1, 'items_per_page' => $items_per_page); $params = array_merge($default_params, $params); if (!empty($params['time_from'])) { $condition = db_quote(" WHERE timestamp >= ?i ", strtotime($params['time_from'])); if (!empty($params['time_to'])) { $condition .= db_quote(" AND timestamp < ?i ", strtotime($params['time_to'])); } } $join = db_quote(" LEFT JOIN ?:rus_cities_sdek as b ON a.city_code = b.city_code "); $join .= db_quote(" LEFT JOIN ?:rus_city_sdek_descriptions as c ON b.city_id = c.city_id "); $sort_by = !empty($params['sort_by']) ? $params['sort_by'] : 'order_id'; $sort = 'asc'; if (!empty($params['sort_order'])) { $sort = $params['sort_order']; $params['sort_order'] = $params['sort_order'] == 'asc' ? 'desc' : 'asc'; $params['sort_order_rev'] = $params['sort_order']; } else { $params['sort_order'] = 'asc'; $params['sort_order_rev'] = 'asc'; } $limit = ''; if (!empty($params['items_per_page'])) { $params['total_items'] = db_get_field("SELECT COUNT(*) FROM ?:rus_sdek_status ?p", $condition); $limit = db_paginate($params['page'], $params['items_per_page']); } $data_status = db_get_array("SELECT a.*, c.city FROM ?:rus_sdek_status as a ?p ?p ORDER BY ?p {$sort} {$limit}", $join, $condition, $sort_by); return array($data_status, $params); }
function fn_em_get_subscribers($params, $items_per_page = 0, $lang_code = CART_LANGUAGE) { // Init filter $params = LastView::instance()->update('em_subscribers', $params); // Set default values to input params $default_params = array('page' => 1, 'items_per_page' => $items_per_page); $params = array_merge($default_params, $params); // Define fields that should be retrieved $fields = array('?:em_subscribers.subscriber_id', '?:em_subscribers.email', '?:em_subscribers.timestamp', '?:em_subscribers.name', '?:em_subscribers.unsubscribe_key', '?:em_subscribers.status'); // Define sort fields $sortings = array('email' => '?:em_subscribers.email', 'name' => '?:em_subscribers.name', 'status' => '?:em_subscribers.status', 'timestamp' => '?:em_subscribers.timestamp'); $condition = ''; $group_by = ''; $join = ''; if (!empty($params['subscriber_id'])) { $condition .= db_quote(" AND ?:em_subscribers.subscriber_id = ?i", $params['subscriber_id']); } if (isset($params['email']) && fn_string_not_empty($params['email'])) { $condition .= db_quote(" AND ?:em_subscribers.email LIKE ?l", "%" . trim($params['email']) . "%"); } if (!empty($params['status'])) { $condition .= db_quote(" AND ?:em_subscribers.status = ?s", $params['status']); } if (!empty($params['name'])) { $condition .= db_quote(" AND ?:em_subscribers.name LIKE ?l", "%" . $params['name'] . "%"); } if (!empty($params['lang_code'])) { $condition .= db_quote(" AND ?:em_subscribers.lang_code = ?s", $params['lang_code']); } if (!empty($params['period']) && $params['period'] != 'A') { list($params['time_from'], $params['time_to']) = fn_create_periods($params); $condition .= db_quote(" AND (?:em_subscribers.timestamp >= ?i AND ?:em_subscribers.timestamp <= ?i)", $params['time_from'], $params['time_to']); } $condition .= fn_em_get_company_condition(); $sorting = db_sort($params, $sortings, 'timestamp', 'desc'); $limit = ''; if (!empty($params['items_per_page'])) { $params['total_items'] = db_get_field("SELECT COUNT(?:em_subscribers.subscriber_id) FROM ?:em_subscribers {$join} WHERE 1 {$condition}"); $limit = db_paginate($params['page'], $params['items_per_page'], $params['total_items']); } $subscribers = db_get_array('SELECT ' . implode(', ', $fields) . " FROM ?:em_subscribers {$join} WHERE 1 {$condition} {$group_by} {$sorting} {$limit}"); return array($subscribers, $params); }
/** * get list of mailing lists * * @param array $params - search parameters * @param array $items_per_page * @param string $lang_code - language code * @return array */ function fn_get_mailing_lists($params = array(), $items_per_page = 0, $lang_code = CART_LANGUAGE) { $default_params = array('checkout' => false, 'registration' => false, 'sidebar' => false, 'only_available' => true, 'items_per_page' => $items_per_page); $params = array_merge($default_params, $params); $condition = '1'; if ($params['checkout']) { $condition .= db_quote(" AND ?:mailing_lists.show_on_checkout = ?i", 1); } if ($params['registration']) { $condition .= db_quote(" AND ?:mailing_lists.show_on_registration = ?i", 1); } if ($params['only_available']) { $condition .= db_quote(" AND ?:mailing_lists.status = ?s", 'A'); } $limit = ''; if (!empty($params['items_per_page'])) { $params['total_items'] = db_get_hash_array("SELECT COUNT(*) FROM ?:mailing_lists WHERE ?p", 'list_id', $condition); $limit = db_paginate($params['page'], $params['items_per_page']); } $mailing_lists = db_get_hash_array("SELECT * FROM ?:mailing_lists LEFT JOIN ?:common_descriptions ON ?:common_descriptions.object_id = ?:mailing_lists.list_id AND ?:common_descriptions.object_holder = 'mailing_lists' AND ?:common_descriptions.lang_code = ?s WHERE ?p {$limit}", 'list_id', $lang_code, $condition); return array($mailing_lists, $params); }
function fn_get_product_subscribers($params, $items_per_page = 0) { // Set default values to input params $default_params = array('page' => 1, 'email' => '', 'product_id' => 0, 'items_per_page' => $items_per_page); $params = array_merge($default_params, $params); /** * Changes params for getting product subscribers * * @param array $params Search subscribers params */ fn_set_hook('get_product_subscribers_pre', $params); // Init filter $params = LastView::instance()->update('subscribers', $params); $condition = ''; $limit = ''; if (isset($params['email']) && fn_string_not_empty($params['email'])) { $condition .= db_quote(" AND email LIKE ?l", "%" . trim($params['email']) . "%"); } $sorting = db_sort($params, array('email' => 'email'), 'email', 'asc'); if (!empty($params['items_per_page'])) { $params['total_items'] = db_get_field("SELECT COUNT(*) FROM ?:product_subscriptions WHERE product_id = ?i {$condition}", $params['product_id']); $limit = db_paginate($params['page'], $params['items_per_page']); } $subscribers = db_get_hash_array("SELECT subscription_id as subscriber_id, email FROM ?:product_subscriptions WHERE product_id = ?i {$condition} {$sorting} {$limit}", 'subscriber_id', $params['product_id']); /** * Changes product subscribers * * @param int $product_id Product identifier * @param array $params Search subscribers params * @param array $subscribers Array of subscribers */ fn_set_hook('get_product_subscribers_post', $params, $subscribers); return array($subscribers, $params); }
function fn_get_gift_certificates($params, $items_per_page = 0) { // Init filter $params = LastView::instance()->update('gift_certs', $params); // Set default values to input params $default_params = array('page' => 1, 'items_per_page' => $items_per_page); $params = array_merge($default_params, $params); // Define fields that should be retrieved $fields = array('?:gift_certificates.gift_cert_id', '?:gift_certificates.gift_cert_code', '?:gift_certificates.timestamp', '?:gift_certificates.amount', '?:gift_certificates.status', '?:gift_certificates.recipient', '?:gift_certificates.sender', '?:gift_certificates.send_via', '?:gift_certificates.email'); if (fn_allowed_for('ULTIMATE')) { $fields[] = '?:gift_certificates.company_id'; } // Define sort fields $sortings = array('timestamp' => "?:gift_certificates.timestamp", 'amount' => "?:gift_certificates.amount", 'recipient' => "?:gift_certificates.recipient", 'sender' => "?:gift_certificates.sender", 'status' => "?:gift_certificates.status", 'gift_cert_code' => "?:gift_certificates.gift_cert_code", 'send_via' => "?:gift_certificates.send_via"); $sorting = db_sort($params, $sortings, 'timestamp', 'desc'); $condition = $join = ''; if (isset($params['sender']) && fn_string_not_empty($params['sender'])) { $condition .= db_quote(" AND ?:gift_certificates.sender LIKE ?l", "%" . trim($params['sender']) . "%"); } if (isset($params['recipient']) && fn_string_not_empty($params['recipient'])) { $condition .= db_quote(" AND ?:gift_certificates.recipient LIKE ?l", "%" . trim($params['recipient']) . "%"); } if (isset($params['email']) && fn_string_not_empty($params['email'])) { $condition .= db_quote(" AND ?:gift_certificates.email LIKE ?l", "%" . trim($params['email']) . "%"); } if (!empty($params['amount_from'])) { $condition .= db_quote(" AND ?:gift_certificates.amount >= ?d", $params['amount_from']); } if (!empty($params['amount_to'])) { $condition .= db_quote(" AND ?:gift_certificates.amount <= ?d", $params['amount_to']); } if (!empty($params['gift_cert_ids'])) { $condition .= db_quote(" AND ?:gift_certificates.gift_cert_id IN (?n)", $params['gift_cert_ids']); } if (!empty($params['status'])) { $condition .= db_quote(" AND ?:gift_certificates.status IN (?a)", $params['status']); } if (isset($params['gift_cert_code']) && fn_string_not_empty($params['gift_cert_code'])) { $condition .= db_quote(" AND ?:gift_certificates.gift_cert_code LIKE ?l", "%" . trim($params['gift_cert_code']) . "%"); } if (!empty($params['period']) && $params['period'] != 'A') { list($params['time_from'], $params['time_to']) = fn_create_periods($params); $condition .= db_quote(" AND (?:gift_certificates.timestamp >= ?i AND ?:gift_certificates.timestamp <= ?i)", $params['time_from'], $params['time_to']); } $limit = ''; if (!empty($params['items_per_page'])) { $params['total_items'] = db_get_field("SELECT COUNT(*) FROM ?:gift_certificates WHERE 1 ?p", $condition . fn_get_gift_certificate_company_condition('?:gift_certificates.company_id')); $limit = db_paginate($params['page'], $params['items_per_page'], $params['total_items']); } $gift_certificates = db_get_array("SELECT ?p FROM ?:gift_certificates WHERE 1 ?p ?p ?p", implode(',', $fields), $condition . fn_get_gift_certificate_company_condition('?:gift_certificates.company_id'), $sorting, $limit); foreach ($gift_certificates as $k => $v) { $debit_balance = db_get_row("SELECT debit, debit_products FROM ?:gift_certificates_log WHERE gift_cert_id = ?i ORDER BY log_id DESC", $v['gift_cert_id']); $gift_certificates[$k]['debit'] = empty($debit_balance) ? $v['amount'] : $debit_balance['debit']; } LastView::instance()->processResults('gift_certificates', $gift_certificates, $params); return array($gift_certificates, $params); }
/** * Returns store logs * * @param array $params Search parameters * @param int $items_per_page Logs limit * @return array Logs with search parameters */ function fn_get_logs($params, $items_per_page = 0) { // Init filter $params = LastView::instance()->update('logs', $params); $default_params = array('page' => 1, 'items_per_page' => $items_per_page); $params = array_merge($default_params, $params); $sortings = array('timestamp' => array('?:logs.timestamp', '?:logs.log_id'), 'user' => array('?:users.lastname', '?:users.firstname')); $fields = array('?:logs.*', '?:users.firstname', '?:users.lastname'); $sorting = db_sort($params, $sortings, 'timestamp', 'desc'); $join = "LEFT JOIN ?:users USING(user_id)"; $condition = ''; if (!empty($params['period']) && $params['period'] != 'A') { list($time_from, $time_to) = fn_create_periods($params); $condition .= db_quote(" AND (?:logs.timestamp >= ?i AND ?:logs.timestamp <= ?i)", $time_from, $time_to); } if (isset($params['q_user']) && fn_string_not_empty($params['q_user'])) { $condition .= db_quote(" AND (?:users.lastname LIKE ?l OR ?:users.firstname LIKE ?l)", "%" . trim($params['q_user']) . "%", "%" . trim($params['q_user']) . "%"); } if (!empty($params['q_type'])) { $condition .= db_quote(" AND ?:logs.type = ?s", $params['q_type']); } if (!empty($params['q_action'])) { $condition .= db_quote(" AND ?:logs.action = ?s", $params['q_action']); } if (Registry::get('runtime.company_id')) { $condition .= db_quote(" AND ?:logs.company_id = ?i", Registry::get('runtime.company_id')); } fn_set_hook('admin_get_logs', $params, $condition, $join, $sorting); $limit = ''; if (!empty($params['items_per_page'])) { $params['total_items'] = db_get_field("SELECT COUNT(DISTINCT(?:logs.log_id)) FROM ?:logs ?p WHERE 1 ?p", $join, $condition); $limit = db_paginate($params['page'], $params['items_per_page']); } $data = db_get_array("SELECT " . join(', ', $fields) . " FROM ?:logs ?p WHERE 1 ?p {$sorting} {$limit}", $join, $condition); foreach ($data as $k => $v) { $data[$k]['backtrace'] = !empty($v['backtrace']) ? unserialize($v['backtrace']) : array(); $data[$k]['content'] = !empty($v['content']) ? unserialize($v['content']) : array(); } return array($data, $params); }
function fn_get_discussions($params, $items_per_page) { // Init filter $params = LastView::instance()->update('discussion', $params); // Set default values to input params $default_params = array('page' => 1, 'items_per_page' => $items_per_page); $params = array_merge($default_params, $params); // Define fields that should be retrieved $fields = array('?:discussion_posts.*', '?:discussion_messages.message', '?:discussion_rating.rating_value', '?:discussion.*'); // Define sort fields $sortings = array('object' => "?:discussion.object_type", 'name' => "?:discussion_posts.name", 'ip_address' => "?:discussion_posts.ip_address", 'timestamp' => "?:discussion_posts.timestamp", 'status' => "?:discussion_posts.status", 'date' => "?:orders.timestamp", 'total' => "?:orders.total"); $sorting = db_sort($params, $sortings, 'timestamp', 'desc'); $condition = $join = ''; if (isset($params['name']) && fn_string_not_empty($params['name'])) { $condition .= db_quote(" AND ?:discussion_posts.name LIKE ?l", "%" . trim($params['name']) . "%"); } if (isset($params['message']) && fn_string_not_empty($params['message'])) { $condition .= db_quote(" AND ?:discussion_messages.message LIKE ?l", "%" . trim($params['message']) . "%"); } if (!empty($params['type'])) { $condition .= db_quote(" AND ?:discussion.type = ?s", $params['type']); } if (!empty($params['status'])) { $condition .= db_quote(" AND ?:discussion_posts.status = ?s", $params['status']); } if (!empty($params['post_id'])) { $condition .= db_quote(" AND ?:discussion_posts.post_id = ?i", $params['post_id']); } if (isset($params['ip_address']) && fn_string_not_empty($params['ip_address'])) { $condition .= db_quote(" AND ?:discussion_posts.ip_address = ?s", fn_ip_to_db(trim($params['ip_address']))); } if (!empty($params['rating_value'])) { $condition .= db_quote(" AND ?:discussion_rating.rating_value = ?i", $params['rating_value']); } if (!empty($params['object_type'])) { $condition .= db_quote(" AND ?:discussion.object_type = ?s", $params['object_type']); } $condition .= fn_get_discussion_company_condition('?:discussion.company_id'); if (!empty($params['period']) && $params['period'] != 'A') { list($params['time_from'], $params['time_to']) = fn_create_periods($params); $condition .= db_quote(" AND (?:discussion_posts.timestamp >= ?i AND ?:discussion_posts.timestamp <= ?i)", $params['time_from'], $params['time_to']); } $join .= " INNER JOIN ?:discussion ON ?:discussion.thread_id = ?:discussion_posts.thread_id"; $join .= " INNER JOIN ?:discussion_messages ON ?:discussion_messages.post_id = ?:discussion_posts.post_id"; $join .= " INNER JOIN ?:discussion_rating ON ?:discussion_rating.post_id = ?:discussion_posts.post_id"; $limit = ''; if (!empty($params['items_per_page'])) { $params['total_items'] = db_get_field("SELECT COUNT(*) FROM ?:discussion_posts {$join} WHERE 1 {$condition}"); $limit = db_paginate($params['page'], $params['items_per_page'], $params['total_items']); } $posts = db_get_array("SELECT " . implode(',', $fields) . " FROM ?:discussion_posts {$join} WHERE 1 {$condition} {$sorting} {$limit}"); foreach ($posts as $k => $post) { if (isset($post['ip_address'])) { $posts[$k]['ip_address'] = fn_ip_from_db($post['ip_address']); } } return array($posts, $params); }
function fn_get_discussion_posts($params, $items_per_page = 0) { // Set default values to input params $default_params = array('page' => 1, 'thread_id' => 0, 'avail_only' => false, 'random' => false, 'items_per_page' => $items_per_page); $params = array_merge($default_params, $params); $thread_data = db_get_row("SELECT thread_id, type, object_type, object_id FROM ?:discussion WHERE thread_id = ?i ?p", $params['thread_id'], fn_get_discussion_company_condition('?:discussion.company_id')); if ($thread_data['type'] == 'D') { return array(array(), $params); } $join = $fields = ''; if ($thread_data['type'] == 'C' || $thread_data['type'] == 'B' || $thread_data['type'] == 'R') { $join .= " LEFT JOIN ?:discussion_messages ON ?:discussion_messages.post_id = ?:discussion_posts.post_id "; $fields .= ", ?:discussion_messages.message_title, ?:discussion_messages.message"; $fields .= ", ?:discussion_messages.user_age, ?:discussion_messages.image1, ?:discussion_messages.image2"; } if ($thread_data['type'] == 'R' || $thread_data['type'] == 'B') { $join .= " LEFT JOIN ?:discussion_rating ON ?:discussion_rating.post_id = ?:discussion_posts.post_id "; $fields .= ", ?:discussion_rating.rating_value"; } $thread_condition = fn_generate_thread_condition($thread_data); if ($params['avail_only'] == true) { $thread_condition .= " AND ?:discussion_posts.status = 'A'"; } $limit = ''; if (!empty($params['limit'])) { $limit = db_quote("LIMIT ?i", $params['limit']); } elseif (!empty($params['items_per_page'])) { $params['total_items'] = db_get_field("SELECT COUNT(*) FROM ?:discussion_posts WHERE {$thread_condition}", $params['thread_id']); $limit = db_paginate($params['page'], $params['items_per_page']); } $order_by = empty($params['random']) ? '?:discussion_posts.timestamp DESC' : 'RAND()'; $posts = db_get_array("SELECT ?:discussion_posts.* {$fields} FROM ?:discussion_posts {$join} " . "WHERE {$thread_condition} ORDER BY ?p {$limit}", $order_by); return array($posts, $params); }
function fn_get_subscribers($params, $items_per_page = 0, $lang_code = CART_LANGUAGE) { // Init filter $params = LastView::instance()->update('subscribers', $params); // Set default values to input params $default_params = array('page' => 1, 'items_per_page' => $items_per_page); $params = array_merge($default_params, $params); // Define fields that should be retrieved $fields = array('?:subscribers.subscriber_id', '?:subscribers.email', '?:subscribers.timestamp', '?:subscribers.subscriber_id', "GROUP_CONCAT(?:user_mailing_lists.list_id) as list_ids"); // Define sort fields $sortings = array('email' => '?:subscribers.email', 'timestamp' => '?:subscribers.timestamp'); $condition = ''; $group_by = "?:subscribers.subscriber_id"; $join = db_quote(" LEFT JOIN ?:user_mailing_lists ON ?:user_mailing_lists.subscriber_id = ?:subscribers.subscriber_id"); if (isset($params['email']) && fn_string_not_empty($params['email'])) { $condition .= db_quote(" AND ?:subscribers.email LIKE ?l", "%" . trim($params['email']) . "%"); } if (!empty($params['list_id'])) { $condition .= db_quote(" AND ?:user_mailing_lists.list_id = ?i", $params['list_id']); } if (!empty($params['confirmed'])) { $condition .= db_quote(" AND ?:user_mailing_lists.confirmed = ?i", $params['confirmed'] == 'Y'); } if (!empty($params['language'])) { $condition .= db_quote(" AND ?:user_mailing_lists.lang_code = ?s", $params['language']); } if (!empty($params['period']) && $params['period'] != 'A') { list($params['time_from'], $params['time_to']) = fn_create_periods($params); $condition .= db_quote(" AND (?:subscribers.timestamp >= ?i AND ?:subscribers.timestamp <= ?i)", $params['time_from'], $params['time_to']); } $sorting = db_sort($params, $sortings, 'timestamp', 'desc'); $limit = ''; if (!empty($params['items_per_page'])) { $params['total_items'] = db_get_field("SELECT COUNT(DISTINCT(?:subscribers.subscriber_id)) FROM ?:subscribers {$join} WHERE 1 {$condition}"); $limit = db_paginate($params['page'], $params['items_per_page'], $params['total_items']); } $subscribers = db_get_array('SELECT ' . implode(', ', $fields) . " FROM ?:subscribers {$join} WHERE 1 {$condition} GROUP BY {$group_by} {$sorting} {$limit}"); return array($subscribers, $params); }
function fn_get_cities($params = array(), $items_per_page = 0, $lang_code = CART_LANGUAGE) { // Set default values to input params $default_params = array('page' => 1, 'items_per_page' => $items_per_page); $params = array_merge($default_params, $params); $fields = array('c.city_id', 'c.country_code', 'c.state_code', 'c.city_code', 'c.status', 'cd.city'); $condition = ''; if (!empty($params['only_avail'])) { $condition .= db_quote(" AND c.status = ?s", 'A'); } if (!empty($params['q'])) { $condition .= db_quote(" AND cd.city LIKE ?l", '%' . $params['q'] . '%'); } if (!empty($params['state_code'])) { $condition .= db_quote(" AND c.state_code = ?s", $params['state_code']); } if (!empty($params['country_code'])) { $condition .= db_quote(" AND c.country_code = ?s", $params['country_code']); } $join = "LEFT JOIN ?:rus_city_descriptions as cd ON cd.city_id = c.city_id AND cd.lang_code = ?s "; $limit = ''; if (!empty($params['items_per_page'])) { $params['total_items'] = db_get_field("SELECT count(*) FROM ?:rus_cities as c {$join} WHERE 1 ?p", $lang_code, $condition); $limit = db_paginate($params['page'], $params['items_per_page']); } $cities = db_get_array("SELECT " . implode(', ', $fields) . " FROM ?:rus_cities as c {$join} WHERE 1 ?p ORDER BY cd.city {$limit}", $lang_code, $condition); foreach ($cities as &$city) { if (empty($city['city'])) { $city['city'] = db_get_field("SELECT city FROM ?:rus_city_descriptions WHERE city_id = ?i AND lang_code = 'ru'", $city['city_id']); } } return array($cities, $params); }