function fn_get_banners($params = array(), $lang_code = CART_LANGUAGE)
{
$default_params = array('items_per_page' => 0);
$params = array_merge($default_params, $params);
$sortings = array('position' => '?:banners.position', 'timestamp' => '?:banners.timestamp', 'name' => '?:banner_descriptions.banner');
$condition = $limit = '';
if (!empty($params['limit'])) {
$limit = db_quote(' LIMIT 0, ?i', $params['limit']);
}
$sorting = db_sort($params, $sortings, 'name', 'asc');
$condition = AREA == 'A' ? '' : " AND ?:banners.status = 'A' ";
$condition .= fn_get_localizations_condition('?:banners.localization');
$condition .= AREA == 'A' ? '' : " AND (?:banners.type != 'G' OR ?:banner_images.banner_image_id IS NOT NULL) ";
if (!empty($params['item_ids'])) {
$condition .= db_quote(' AND ?:banners.banner_id IN (?n)', explode(',', $params['item_ids']));
}
if (!empty($params['period']) && $params['period'] != 'A') {
list($params['time_from'], $params['time_to']) = fn_create_periods($params);
$condition .= db_quote(" AND (?:banners.timestamp >= ?i AND ?:banners.timestamp <= ?i)", $params['time_from'], $params['time_to']);
}
fn_set_hook('get_banners', $params, $condition, $sorting, $limit, $lang_code);
$fields = array('?:banners.banner_id', '?:banners.type', '?:banners.target', '?:banners.status', '?:banners.position', '?:banner_descriptions.banner', '?:banner_descriptions.description', '?:banner_descriptions.url', '?:banner_images.banner_image_id');
if (fn_allowed_for('ULTIMATE')) {
$fields[] = '?:banners.company_id';
}
$banners = db_get_array("SELECT ?p FROM ?:banners " . "LEFT JOIN ?:banner_descriptions ON ?:banner_descriptions.banner_id = ?:banners.banner_id AND ?:banner_descriptions.lang_code = ?s" . "LEFT JOIN ?:banner_images ON ?:banner_images.banner_id = ?:banners.banner_id AND ?:banner_images.lang_code = ?s" . "WHERE 1 ?p ?p ?p", implode(", ", $fields), $lang_code, $lang_code, $condition, $sorting, $limit);
foreach ($banners as $k => $v) {
$banners[$k]['main_pair'] = fn_get_image_pairs($v['banner_image_id'], 'promo', 'M', true, false, $lang_code);
}
fn_set_hook('get_banners_post', $banners, $params);
return array($banners, $params);
}
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);
}
/**
* 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_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_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);
}
/**
* Gets list of locations
*
* @param array $params input params
* @param string $lang_code 2 letter language code
* @return array Array of locations data
*/
public function getList($params = array(), $lang_code = CART_LANGUAGE)
{
/**
* Prepares params for SQL query before getting locations
* @param array $params input params
* @param string $lang_code 2 letter language code
*/
fn_set_hook('get_locations_pre', $params, $lang_code);
$sortings = array('location_id' => 'l.location_id', 'dispatch' => 'l.dispatch', 'is_default' => 'l.is_default', 'layout_id' => 'l.layout_id', 'location' => array('l.is_default', 'd.name'), 'object_ids' => 'l.object_ids', 'position' => 'l.position');
$sorting = db_sort($params, $sortings, 'is_default', 'desc');
$join = $condition = '';
if (!empty($params['dispatch'])) {
$condition .= db_quote(" AND l.dispatch = ?s", $params['dispatch']);
}
if (!empty($params['location_id'])) {
$condition .= db_quote(" AND l.location_id = ?i", $params['location_id']);
}
if (!empty($params['is_default'])) {
$condition .= db_quote(" AND l.is_default = 1");
}
if (!empty($params['dynamic_object']) && !empty($params['dispatch'])) {
if (!empty($params['dynamic_object']['object_id'])) {
$dynamic_object_scheme = SchemesManager::getDynamicObject($params['dispatch'], 'C');
if (!empty($dynamic_object_scheme)) {
$condition .= db_quote(" AND (FIND_IN_SET(?i, l.object_ids) OR l.object_ids = '')", $params['dynamic_object']['object_id']);
}
}
}
$limit = '';
if (!empty($params['limit'])) {
$limit = db_quote(" LIMIT ?i", $params['limit']);
}
// Try to get location for this dispatch
$locations = db_get_hash_array("SELECT * FROM ?:bm_locations as l " . "LEFT JOIN ?:bm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = ?s ?p" . "WHERE l.layout_id = ?i ?p {$sorting} {$limit}", 'location_id', $lang_code, $join, $this->_layout_id, $condition);
/**
* Processes locations list after getting it
* @param array $locations Array of locations data
* @param string $lang_code 2 letter language code
*/
fn_set_hook('get_locations_post', $locations, $lang_code);
return $locations;
}
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);
}
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_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);
}
/**
* 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);
}
/**
* Return list log items by filter
*
* @param array $params
* @param int $items_per_page
* @return array
*/
public static function getList($params, $items_per_page = 0)
{
// Set default values to input params
$default_params = array('page' => 1, 'items_per_page' => $items_per_page);
$types = static::getTypes();
$actions = static::getActions();
$params = array_merge($default_params, $params);
$condition = '';
$limit = '';
$sortings = array('id' => 'id', 'datetime' => 'datetime');
if (isset($params['template_id']) && fn_is_not_empty($params['template_id'])) {
$condition .= db_quote(' AND template_id = ?i', $params['template_id']);
}
if (isset($params['product_id']) && fn_is_not_empty($params['product_id'])) {
$condition .= db_quote(' AND product_id = ?i', $params['product_id']);
}
if (isset($params['product_ids']) && fn_is_not_empty($params['product_ids'])) {
$condition .= db_quote(' AND product_id IN (?n)', $params['product_ids']);
}
if (isset($params['code']) && fn_is_not_empty($params['code'])) {
$condition .= db_quote(' AND product_id = ?s', $params['code']);
}
if (isset($params['type']) && fn_is_not_empty($params['type'])) {
$condition .= db_quote(' AND type = ?i', $params['type']);
}
if (isset($params['action']) && fn_is_not_empty($params['action'])) {
$condition .= db_quote(' AND action = ?i', $params['action']);
}
if (!empty($params['period']) && $params['period'] != 'A') {
list($time_from, $time_to) = fn_create_periods($params);
$condition .= db_quote(' AND (datetime >= ?i AND datetime <= ?i)', $time_from, $time_to);
}
$sorting = db_sort($params, $sortings, 'id', 'desc');
if (!empty($params['items_per_page'])) {
$params['total_items'] = db_get_field("SELECT COUNT(*) FROM ?:ebay_product_log WHERE 1 {$condition}");
$limit = db_paginate($params['page'], $params['items_per_page'], $params['total_items']);
}
$result = db_get_array("SELECT * FROM ?:ebay_product_log WHERE 1 {$condition} {$sorting} {$limit}");
foreach ($result as &$item) {
switch ($item['type']) {
case static::TYPE_ERROR:
$item['type_code'] = 'error';
break;
case static::TYPE_INFO:
$item['type_code'] = 'info';
break;
case static::TYPE_WARNING:
$item['type_code'] = 'warning';
break;
default:
$item['type_code'] = 'undefined';
break;
}
$item['type_name'] = isset($types[$item['type']]) ? $types[$item['type']] : 'undefined';
$item['action_name'] = isset($actions[$item['action']]) ? $actions[$item['action']] : 'undefined';
}
unset($item);
return array($result, $params);
}
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);
/**
* Change parameters for getting tags
*
* @param array $params Params list
* @param int $items_per_page Tags per page
* @param array $default_params Default params
*/
fn_set_hook('get_tags_pre', $params, $items_per_page, $default_params);
$params = array_merge($default_params, $params);
$fields = array('?:tags.tag_id', '?:tag_links.object_id', '?:tag_links.object_type', '?:tags.tag', '?:tags.status', 'COUNT(?:tag_links.tag_id) as popularity');
$joins = array('LEFT JOIN ?:tag_links ON ?:tag_links.tag_id = ?:tags.tag_id');
$conditions = fn_tags_build_conditions($params);
// Define sort fields
$sortings = array('tag' => '?:tags.tag', 'status' => '?:tags.status', 'popularity' => 'popularity', 'users' => 'users');
$sorting = db_sort($params, $sortings, 'tag', 'asc');
$group = 'GROUP BY ?:tags.tag_id';
/**
* Gets tags
*
* @param array $params Params list
* @param int $items_per_page Tags per page
* @param array $fields List of SQL fields to be selected in an SQL-query
* @param array $joins List of strings with the complete JOIN information (JOIN type, tables and fields) for an SQL-query
* @param string $conditions String containing the SQL-query conditions prepended with a logical operator (AND or OR)
* @param string $group String containing the SQL-query GROUP BY field
* @param string $sorting String containing the SQL-query ORDER BY field
*/
fn_set_hook('get_tags', $params, $items_per_page, $fields, $joins, $conditions, $group, $sorting);
$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 " . implode(', ', $fields) . " " . "FROM ?:tags " . implode(' ', $joins) . " WHERE 1 ?p {$group} {$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);
}
/**
* Change tags
*
* @param array $params Params list
* @param int $items_per_page Tags per page
* @param array $tags Tags
*/
fn_set_hook('get_tags_post', $params, $items_per_page, $tags);
return array($tags, $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);
}
/**
* 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);
}
$sortings = array('id' => '?:hw_404.id', 'url' => '?:hw_404.url', 'timestamp' => '?:hw_404.created', 'redirect' => '?:hw_404.redirect', 'hits' => '?:hw_404.hits', 'redirect_type' => '?:hw_404.redirect_type');
$auth =& $_SESSION['auth'];
$condition = '1';
$join = $limit = $group_by = '';
if (isset($params['q']) && fn_string_not_empty($params['q'])) {
$condition .= db_quote(' AND ( url LIKE ?l OR redirect LIKE ?l OR referer LIKE ?l)', '%' . $params['q'] . '%', '%' . $params['q'] . '%', '%' . $params['q'] . '%');
}
$company_id = Registry::get('runtime.company_id');
if ($company_id > 0) {
$condition .= db_quote(' AND company_id=?i', $company_id);
}
#NEW
if (!isset($_REQUEST['show']) || $_REQUEST['show'] != 'all') {
$condition .= db_quote(' AND ( redirect=?s OR redirect IS NULL) AND object_id=?i', '', 0);
}
$sorting = db_sort($params, $sortings, 'timestamp', 'desc');
if (!empty($group_by)) {
$group_by = ' GROUP BY ' . $group_by;
}
if (!empty($params['items_per_page'])) {
$params['total_items'] = db_get_field("SELECT COUNT(*) FROM ?:hw_404 ?p WHERE ?p ?p ?p", $join, $condition, $group_by, $sorting);
$limit = db_paginate($params['page'], $params['items_per_page']);
}
$errors = db_get_hash_array("SELECT " . implode(', ', $fields) . " FROM ?:hw_404 ?p WHERE ?p ?p ?p ?p", 'id', $join, $condition, $group_by, $sorting, $limit);
//generate urls
if (!empty($_REQUEST['show']) && $_REQUEST['show'] == 'all' && !empty($errors)) {
foreach ($errors as $key => $error) {
if ($error['object_id'] > 0) {
$errors[$key]['redirect'] = fn_hw_404_fixer_generate_url($error['type'], $error['object_id']);
}
}
function fn_companies_get_payouts($params = array(), $items_per_page = 0)
{
$params = LastView::instance()->update('balance', $params);
$default_params = array('page' => 1, 'items_per_page' => $items_per_page);
$params = array_merge($default_params, $params);
$fields = array();
$join = ' ';
// Define sort fields
$sortings = array('sort_vendor' => 'companies.company', 'sort_period' => 'payouts.start_date', 'sort_amount' => 'payout_amount', 'sort_date' => 'payouts.payout_date');
$condition = $date_condition = ' 1 ';
$join .= ' LEFT JOIN ?:orders AS orders ON (payouts.order_id = orders.order_id)';
$join .= ' LEFT JOIN ?:companies AS companies ON (payouts.company_id = companies.company_id)';
// If the sales period not defined, specify it as 'All'
if (empty($params['time_from']) && empty($params['time_to'])) {
$params['period'] = 'A';
}
if (empty($params['time_from']) && empty($params['period'])) {
$params['time_from'] = mktime(0, 0, 0, date('n', TIME), 1, date('Y', time()));
} elseif (!empty($params['time_from'])) {
$params['time_from'] = fn_parse_date($params['time_from']);
} else {
$time_from = true;
}
if (empty($params['time_to']) && empty($params['period'])) {
$params['time_to'] = time();
} elseif (!empty($params['time_to'])) {
$params['time_to'] = fn_parse_date($params['time_to']) + 24 * 60 * 60 - 1;
//Get the day ending time
} else {
$time_to = true;
}
if (isset($time_from) || isset($time_to)) {
$dates = db_get_row('SELECT MIN(start_date) AS time_from, MAX(end_date) AS time_to FROM ?:vendor_payouts');
if (isset($time_from)) {
$params['time_from'] = $dates['time_from'];
}
if (isset($time_to)) {
$params['time_to'] = $dates['time_to'];
}
}
// Order statuses condition
$statuses = db_get_fields('SELECT status FROM ?:status_data WHERE `type` = ?s AND param = ?s AND `value` = ?s', 'O', 'calculate_for_payouts', 'Y');
if (!empty($statuses)) {
$condition .= db_quote(' AND (orders.status IN (?a) OR payouts.order_id = 0)', $statuses);
} else {
$condition .= db_quote(' AND payouts.order_id = 0');
}
$date_condition .= db_quote(' AND ((payouts.start_date >= ?i AND payouts.end_date <= ?i AND payouts.order_id != ?i) OR (payouts.order_id = ?i AND (payouts.start_date BETWEEN ?i AND ?i OR payouts.end_date BETWEEN ?i AND ?i)))', $params['time_from'], $params['time_to'], 0, 0, $params['time_from'], $params['time_to'], $params['time_from'], $params['time_to']);
// Filter by the transaction type
if (!empty($params['transaction_type']) && ($params['transaction_type'] == 'income' || $params['transaction_type'] == 'expenditure')) {
if ($params['transaction_type'] == 'income') {
$condition .= ' AND (payouts.order_id != 0 OR payouts.payout_amount > 0)';
} else {
$condition .= ' AND payouts.payout_amount < 0';
}
}
// Filter by vendor
if (Registry::get('runtime.company_id')) {
$params['vendor'] = Registry::get('runtime.company_id');
}
if (!empty($params['vendor']) && $params['vendor'] != 'all') {
$condition .= db_quote(' AND payouts.company_id = ?i', $params['vendor']);
}
if (!empty($params['payment'])) {
$condition .= db_quote(' AND payouts.payment_method like ?l', '%' . $params['payment'] . '%');
}
$sorting = db_sort($params, $sortings, 'sort_vendor', 'asc');
$limit = '';
$items = db_get_array("SELECT SQL_CALC_FOUND_ROWS * FROM ?:vendor_payouts AS payouts {$join} WHERE {$condition} AND {$date_condition} GROUP BY payouts.payout_id {$sorting} {$limit}");
if (!empty($params['items_per_page'])) {
$params['total_items'] = db_get_found_rows();
$limit = db_paginate($params['page'], $params['items_per_page'], $params['total_items']);
}
// Calculate balance for the selected period
$total = array('BCF' => 0, 'NO' => 0, 'TPP' => 0, 'LPM' => 0, 'TOB' => 0);
$bcf_query = db_quote("SELECT SUM(payouts.order_amount) - SUM(payouts.payout_amount) * (-1) - SUM(payouts.commission_amount) AS BCF FROM ?:vendor_payouts AS payouts {$join} WHERE {$condition} AND payouts.start_date < ?i", $params['time_from']);
$current_payouts_query = db_quote("SELECT SUM(payouts.order_amount) AS NO, SUM(payouts.payout_amount) * (-1) AS TTP, SUM(payouts.order_amount) - SUM(payouts.commission_amount) + SUM(payouts.payout_amount) AS LPM FROM ?:vendor_payouts AS payouts LEFT JOIN ?:orders AS orders ON (payouts.order_id = orders.order_id) WHERE {$condition} AND {$date_condition}");
$payouts_query = db_quote("SELECT payouts.*, companies.company, IF(payouts.order_id <> 0,orders.total,payouts.payout_amount) AS payout_amount, IF(payouts.order_id <> 0, payouts.end_date, '') AS date FROM ?:vendor_payouts AS payouts {$join} WHERE {$condition} AND {$date_condition} GROUP BY payouts.payout_id {$sorting} {$limit}");
fn_set_hook('mve_companies_get_payouts', $bcf_query, $current_payouts_query, $payouts_query, $join, $total, $condition, $date_condition);
$payouts = db_get_array($payouts_query);
$total['BCF'] += db_get_field($bcf_query);
$current_payouts = db_get_row($current_payouts_query);
$total['NO'] = $current_payouts['NO'];
$total['TPP'] = $current_payouts['TTP'];
$total['LPM'] = $current_payouts['LPM'];
$total['TOB'] += fn_format_price($total['BCF'] + $total['LPM']);
$total['LPM'] = $total['LPM'] < 0 ? 0 : $total['LPM'];
$total['new_period_date'] = db_get_field('SELECT MAX(end_date) FROM ?:vendor_payouts');
return array($payouts, $params, $total);
}
/**
* Getting users list
*
* @param array $params Params list
* @param array $auth Auth
* @param int $items_per_page Items per page
* @param str $custom_view Custom view
* @return array
*/
function fn_get_users($params, &$auth, $items_per_page = 0, $custom_view = '')
{
/**
* Actions before getting users list
*
* @param array $params Params list
* @param array $auth Auth data
* @param int $items_per_page Items per page
* @param str $custom_view Custom view
*/
fn_set_hook('get_users_pre', $params, $auth, $items_per_page, $custom_view);
// Init filter
$_view = !empty($custom_view) ? $custom_view : 'users';
$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("?:users.user_id", "?:users.user_login", "?:users.is_root", "?:users.timestamp", "?:users.user_type", "?:users.status", "?:users.firstname", "?:users.lastname", "?:users.email", "?:users.company", "?:users.company_id", "?:companies.company as company_name");
// Define sort fields
$sortings = array('id' => "?:users.user_id", 'username' => "?:users.user_login", 'email' => "?:users.email", 'name' => array("?:users.lastname", "?:users.firstname"), 'date' => "?:users.timestamp", 'type' => "?:users.user_type", 'status' => "?:users.status", 'company' => "company_name");
if (isset($params['compact']) && $params['compact'] == 'Y') {
$union_condition = ' OR ';
} else {
$union_condition = ' AND ';
}
$condition = array();
$join = $group = '';
$group .= " GROUP BY ?:users.user_id";
if (isset($params['company']) && fn_string_not_empty($params['company'])) {
$condition['company'] = db_quote(" AND ?:users.company LIKE ?l", "%" . trim($params['company']) . "%");
}
if (isset($params['name']) && fn_string_not_empty($params['name'])) {
$arr = fn_explode(' ', $params['name']);
foreach ($arr as $k => $v) {
if (!fn_string_not_empty($v)) {
unset($arr[$k]);
}
}
if (sizeof($arr) == 2) {
$condition['name'] = db_quote(" AND (?:users.firstname LIKE ?l AND ?:users.lastname LIKE ?l)", "%" . array_shift($arr) . "%", "%" . array_shift($arr) . "%");
} else {
$condition['name'] = db_quote(" AND (?:users.firstname LIKE ?l OR ?:users.lastname LIKE ?l)", "%" . trim($params['name']) . "%", "%" . trim($params['name']) . "%");
}
}
if (isset($params['user_login']) && fn_string_not_empty($params['user_login'])) {
$condition['user_login'] = db_quote(" {$union_condition} ?:users.user_login LIKE ?l", "%" . trim($params['user_login']) . "%");
}
if (!empty($params['tax_exempt'])) {
$condition['tax_exempt'] = db_quote(" AND ?:users.tax_exempt = ?s", $params['tax_exempt']);
}
if (!fn_allowed_for('ULTIMATE:FREE')) {
if (isset($params['usergroup_id']) && $params['usergroup_id'] != ALL_USERGROUPS) {
if (!empty($params['usergroup_id'])) {
$join .= db_quote(" LEFT JOIN ?:usergroup_links ON ?:usergroup_links.user_id = ?:users.user_id AND ?:usergroup_links.usergroup_id = ?i", $params['usergroup_id']);
$condition['usergroup_links'] = " AND ?:usergroup_links.status = 'A'";
} else {
$join .= " LEFT JOIN ?:usergroup_links ON ?:usergroup_links.user_id = ?:users.user_id AND ?:usergroup_links.status = 'A'";
$condition['usergroup_links'] = " AND ?:usergroup_links.user_id IS NULL";
}
}
}
if (!empty($params['status'])) {
$condition['status'] = db_quote(" AND ?:users.status = ?s", $params['status']);
}
if (isset($params['email']) && fn_string_not_empty($params['email'])) {
$condition['email'] = db_quote(" {$union_condition} ?:users.email LIKE ?l", "%" . trim($params['email']) . "%");
}
if (isset($params['address']) && fn_string_not_empty($params['address'])) {
$condition['address'] = db_quote(" AND (?:user_profiles.b_address LIKE ?l OR ?:user_profiles.s_address LIKE ?l)", "%" . trim($params['address']) . "%", "%" . trim($params['address']) . "%");
}
if (isset($params['zipcode']) && fn_string_not_empty($params['zipcode'])) {
$condition['zipcode'] = db_quote(" AND (?:user_profiles.b_zipcode LIKE ?l OR ?:user_profiles.s_zipcode LIKE ?l)", "%" . trim($params['zipcode']) . "%", "%" . trim($params['zipcode']) . "%");
}
if (!empty($params['country'])) {
$condition['country'] = db_quote(" AND (?:user_profiles.b_country LIKE ?l OR ?:user_profiles.s_country LIKE ?l)", "%{$params['country']}%", "%{$params['country']}%");
}
if (isset($params['state']) && fn_string_not_empty($params['state'])) {
$condition['state'] = db_quote(" AND (?:user_profiles.b_state LIKE ?l OR ?:user_profiles.s_state LIKE ?l)", "%" . trim($params['state']) . "%", "%" . trim($params['state']) . "%");
}
if (isset($params['city']) && fn_string_not_empty($params['city'])) {
$condition['city'] = db_quote(" AND (?:user_profiles.b_city LIKE ?l OR ?:user_profiles.s_city LIKE ?l)", "%" . trim($params['city']) . "%", "%" . trim($params['city']) . "%");
}
if (!empty($params['user_id'])) {
$condition['user_id'] = db_quote(' AND ?:users.user_id IN (?n)', $params['user_id']);
}
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['order_product_id'] = db_quote(" AND ?:order_details.product_id IN (?n)", $arr);
} else {
$condition['order_product_id'] = 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 .= db_quote(" LEFT JOIN ?:orders ON ?:orders.user_id = ?:users.user_id AND ?:orders.is_parent_order != 'Y' LEFT JOIN ?:order_details ON ?:order_details.order_id = ?:orders.order_id");
}
if (defined('RESTRICTED_ADMIN')) {
// FIXME: NOT GOOD
$condition['restricted_admin'] = db_quote(" AND ((?:users.user_type != 'A' AND ?:users.user_type != 'V') OR (?:users.user_type = 'A' AND ?:users.user_id = ?i))", $auth['user_id']);
}
// sometimes other vendor's admins could buy products from other vendors.
if (!empty($params['user_type']) && (!($params['user_type'] == 'C' && Registry::get('runtime.company_id')) || fn_allowed_for('ULTIMATE'))) {
$condition['user_type'] = db_quote(' AND ?:users.user_type = ?s', $params['user_type']);
} else {
// Get active user types
$user_types = array_keys(fn_get_user_types());
// Select only necessary groups frm all available
if (!empty($params['user_types'])) {
$user_types = array_intersect($user_types, $params['user_types']);
}
if (!empty($params['exclude_user_types'])) {
$user_types = array_diff($user_types, $params['exclude_user_types']);
}
$condition['user_type'] = db_quote(" AND ?:users.user_type IN(?a)", $user_types);
}
$join .= db_quote(" LEFT JOIN ?:user_profiles ON ?:user_profiles.user_id = ?:users.user_id");
$join .= db_quote(" LEFT JOIN ?:companies ON ?:companies.company_id = ?:users.company_id");
/**
* Prepare params for getting users query
*
* @param array $params Params list
* @param array $fields Fields list
* @param array $sortings Sorting variants
* @param array $condition Conditions set
* @param str $join Joins list
* @param array $auth Auth data
*/
fn_set_hook('get_users', $params, $fields, $sortings, $condition, $join, $auth);
$sorting = db_sort($params, $sortings, 'name', 'asc');
// Used for Extended search
if (!empty($params['get_conditions'])) {
return array($fields, $join, $condition);
}
// Paginate search results
$limit = '';
if (!empty($params['items_per_page'])) {
$params['total_items'] = db_get_field("SELECT COUNT(DISTINCT(?:users.user_id)) FROM ?:users {$join} WHERE 1 " . implode(' ', $condition));
$limit = db_paginate($params['page'], $params['items_per_page'], $params['total_items']);
}
$users = db_get_array("SELECT " . implode(', ', $fields) . " FROM ?:users {$join} WHERE 1" . implode('', $condition) . " {$group} {$sorting} {$limit}");
LastView::instance()->processResults('users', $users, $params);
/**
* Actions after getting users list
*
* @param array $users Users list
* @param array $params Params list
* @param array $auth Auth data
*/
fn_set_hook('get_users_post', $users, $params, $auth);
return array($users, $params);
}
function fn_get_carts($params, $items_per_page = 0)
{
// Init filter
$params = LastView::instance()->update('carts', $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('?:user_session_products.user_id', '?:users.firstname', '?:users.lastname', '?:user_session_products.timestamp AS date');
// Define sort fields
$sortings = array('customer' => "CONCAT(?:users.lastname, ?:users.firstname)", 'date' => "?:user_session_products.timestamp");
if (fn_allowed_for('ULTIMATE')) {
$sortings['company_id'] = "?:user_session_products.company_id";
}
$sorting = db_sort($params, $sortings, 'customer', 'asc');
$condition = $join = '';
$group = " GROUP BY ?:user_session_products.user_id";
$group_post = '';
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 (!empty($params['user_id'])) {
$condition .= db_quote(" AND ?:user_session_products.user_id = ?i", $params['user_id']);
}
if (!empty($params['online_only'])) {
$sessions = Session::getOnline('C');
if (!empty($sessions)) {
$condition .= db_quote(" AND ?:user_session_products.session_id IN (?a)", $sessions);
} else {
$condition .= db_quote(" AND 0");
}
}
if (!empty($params['with_info_only'])) {
$condition .= db_quote(" AND ?:users.email != ''");
}
if (!empty($params['users_type'])) {
if ($params['users_type'] == 'R') {
$condition .= db_quote(" AND !ISNULL(?:users.user_id)");
} elseif ($params['users_type'] == 'G') {
$condition .= db_quote(" AND ISNULL(?:users.user_id)");
}
}
if (!empty($params['total_from']) || !empty($params['total_to'])) {
$having = '';
if (fn_is_numeric($params['total_from'])) {
$having .= db_quote(" AND SUM(price * amount) >= ?d", $params['total_from']);
}
if (fn_is_numeric($params['total_to'])) {
$having .= db_quote(" AND SUM(price * amount) <= ?d", $params['total_to']);
}
if (!empty($having)) {
$users4total = db_get_fields("SELECT user_id FROM ?:user_session_products GROUP BY user_id HAVING 1 {$having}");
if (!empty($users4total)) {
$condition .= db_quote(" AND (?:user_session_products.user_id IN (?n))", $users4total);
} else {
$condition .= " AND (?:user_session_products.user_id = 'no')";
}
}
}
if (!empty($params['period']) && $params['period'] != 'A') {
list($params['time_from'], $params['time_to']) = fn_create_periods($params);
$condition .= db_quote(" AND (?:user_session_products.timestamp >= ?i AND ?:user_session_products.timestamp <= ?i)", $params['time_from'], $params['time_to']);
}
$_condition = array();
if (!empty($params['product_type_c'])) {
$_condition[] = "?:user_session_products.type = 'C'";
}
if (!empty($params['product_type_w']) && $params['product_type_w'] == 'Y') {
$_condition[] = "?:user_session_products.type = 'W'";
}
if (!empty($_condition)) {
$condition .= " AND (" . implode(" OR ", $_condition) . ")";
}
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 ?:user_session_products.product_id IN (?n)", $arr);
} else {
$condition .= db_quote(" AND ?:user_session_products.product_id IN (?n)", db_get_fields(fn_get_products(array('view_id' => $params['product_view_id'], 'get_query' => true))));
}
$group_post .= " HAVING COUNT(?:user_session_products.user_id) >= " . count($arr);
}
$join .= " LEFT JOIN ?:users ON ?:user_session_products.user_id = ?:users.user_id";
// checking types for retrieving from the database
$type_restrictions = array('C');
fn_set_hook('get_carts', $type_restrictions, $params, $condition, $join, $fields, $group, $array_index_field);
if (!empty($type_restrictions) && is_array($type_restrictions)) {
$condition .= " AND ?:user_session_products.type IN ('" . implode("', '", $type_restrictions) . "')";
}
$carts_list = array();
$group .= $group_post;
$limit = '';
if (!empty($params['items_per_page'])) {
$limit = db_paginate($params['page'], $params['items_per_page']);
}
if (fn_allowed_for('ULTIMATE')) {
$group = " GROUP BY ?:user_session_products.user_id, ?:user_session_products.company_id";
}
$carts_list = db_get_array("SELECT SQL_CALC_FOUND_ROWS " . implode(', ', $fields) . " FROM ?:user_session_products {$join} WHERE 1 {$condition} {$group} {$sorting} {$limit}");
if (!empty($params['items_per_page'])) {
$params['total_items'] = db_get_found_rows();
}
unset($_SESSION['abandoned_carts']);
return array($carts_list, $params);
}
/**
* Get supplier data
*
* @param array $params
* @return array Found suppliers data
*/
function fn_get_suppliers($params = array(), $items_per_page = 0)
{
// Init filter
$params = LastView::instance()->update('suppliers', $params);
$condition = fn_get_company_condition('?:suppliers.company_id');
$join = db_quote(" JOIN ?:companies ON ?:suppliers.company_id = ?:companies.company_id");
// 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("?:suppliers.supplier_id", "?:suppliers.timestamp", "?:suppliers.status", "?:suppliers.name", "?:suppliers.email", "?:suppliers.company_id", "?:companies.company as company_name");
// Define sort fields
$sortings = array('id' => "?:suppliers.supplier_id", 'email' => "?:suppliers.email", 'name' => "?:suppliers.name", 'date' => "?:suppliers.timestamp", 'type' => "?:suppliers.supplier_type", 'status' => "?:suppliers.status", 'company' => "company_name");
$filters = array('name' => "?:suppliers.name", 'email' => "?:suppliers.email", 'address' => "?:suppliers.address", 'zipcode' => "?:suppliers.zipcode", 'country' => "?:suppliers.country", 'state' => "?:suppliers.state", 'city' => "?:suppliers.city", 'status' => "?:suppliers.status", 'company' => "?:companies.company");
foreach ($filters as $filter => $field) {
if (!empty($params[$filter])) {
$condition .= db_quote(" AND " . $field . " LIKE ?l", "%" . trim($params[$filter]) . "%");
}
}
if (!empty($params['supplier_id'])) {
$condition .= db_quote(' AND ?:suppliers.supplier_id IN (?n)', $params['supplier_id']);
}
$sorting = db_sort($params, $sortings, 'name', 'asc');
// Paginate search results
$limit = '';
if (!empty($params['items_per_page'])) {
$params['total_items'] = db_get_field("SELECT COUNT(DISTINCT(?:suppliers.supplier_id)) FROM ?:suppliers ?p WHERE 1 ?p", $join, $condition);
$limit = db_paginate($params['page'], $params['items_per_page']);
}
$suppliers = db_get_array("SELECT ?p FROM ?:suppliers ?p WHERE 1 ?p GROUP BY ?:suppliers.supplier_id ?p ?p", implode(', ', $fields), $join, $condition, $sorting, $limit);
LastView::instance()->processResults('suppliers', $suppliers, $params);
return array($suppliers, $params);
}
function fn_get_ebay_templates($params, $items_per_page = 0, $lang_code = CART_LANGUAGE, $get_simple = false)
{
// Init filter
$params = LastView::instance()->update('ebay_templates', $params);
$fields = array('templates.template_id', 'templates.status', 'descr.name', 'templates.company_id');
// Define sort fields
$sortings = array('status' => 'templates.status', 'name' => 'descr.name');
$condition = '';
//fn_get_company_condition('templates.company_id')
$join = db_quote('LEFT JOIN ?:ebay_template_descriptions as descr ON templates.template_id = descr.template_id AND descr.lang_code = ?s', $lang_code);
if (!empty($params['product_id'])) {
if (fn_allowed_for('ULTIMATE')) {
if (Registry::get('runtime.simple_ultimate')) {
$condition = '';
} else {
$company_ids = fn_ult_get_shared_product_companies($params['product_id']);
$tempalte_ids = db_get_fields("SELECT share_object_id FROM ?:ult_objects_sharing WHERE share_object_type = 'ebay_templates' AND share_company_id IN (?n)", $company_ids);
$condition = db_quote(' AND templates.template_id IN (?n)', $tempalte_ids);
}
} elseif (fn_allowed_for('MULTIVENDOR')) {
if (Registry::get('runtime.company_id')) {
$condition = fn_get_company_condition('templates.company_id');
} else {
$company_id = db_get_field("SELECT company_id FROM ?:products WHERE product_id = ?i", $params['product_id']);
$condition = db_quote(" AND templates.company_id = ?i", $company_id);
}
}
} else {
if (fn_allowed_for('ULTIMATE') && !Registry::get('runtime.simple_ultimate') && Registry::get('runtime.company_id')) {
$join .= db_quote(" INNER JOIN ?:ult_objects_sharing ON (?:ult_objects_sharing.share_object_id = templates.template_id AND ?:ult_objects_sharing.share_company_id = ?i AND ?:ult_objects_sharing.share_object_type = 'ebay_templates')", Registry::get('runtime.company_id'));
}
}
$limit = '';
$group_by = 'templates.template_id';
// -- SORTINGS --
if (empty($params['sort_by']) || empty($sortings[$params['sort_by']])) {
$params['sort_by'] = 'name';
}
if (empty($params['sort_order'])) {
$params['sort_order'] = 'asc';
}
$sorting = db_sort($params, $sortings);
if (!empty($params['limit'])) {
$limit = db_quote(" LIMIT 0, ?i", $params['limit']);
} elseif (!empty($params['items_per_page'])) {
$limit = db_paginate($params['page'], $params['items_per_page']);
}
Registry::set('runtime.skip_sharing_selection', true);
$templates = db_get_array("SELECT SQL_CALC_FOUND_ROWS " . implode(', ', $fields) . " FROM ?:ebay_templates as templates {$join} WHERE 1 {$condition} GROUP BY {$group_by} {$sorting} {$limit}");
Registry::set('runtime.skip_sharing_selection', false);
if (!empty($params['items_per_page'])) {
$params['total_items'] = !empty($total) ? $total : db_get_found_rows();
} else {
$params['total_items'] = count($templates);
}
if ($get_simple == true) {
$_templates = array();
foreach ($templates as $template) {
$_templates[$template['template_id']] = $template['name'];
}
return $_templates;
}
return array($templates, $params);
}
function fn_get_usergroup_requests($params, $items_per_page = 0, $status = 'P', $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("?:usergroup_links.user_id", "?:usergroup_links.link_id", "?:usergroup_links.usergroup_id", "?:usergroup_links.status", "?:users.firstname", "?:users.lastname", "?:usergroup_descriptions.usergroup");
$sortings = array('customer' => array("?:users.lastname", "?:users.firstname"), 'usergroup' => "?:usergroup_descriptions.usergroup", 'status' => "?:usergroup_links.status");
$sorting = db_sort($params, $sortings, 'customer', 'desc');
$condition = '';
if (!empty($params['cname'])) {
$arr = explode(' ', $params['cname']);
if (sizeof($arr) == 2) {
$condition .= db_quote(" AND ?:users.firstname LIKE ?l AND ?:users.lastname LIKE ?l", "%{$arr['0']}%", "%{$arr['1']}%");
} else {
$condition .= db_quote(" AND (?:users.firstname LIKE ?l OR ?:users.lastname LIKE ?l)", "%{$params['cname']}%", "%{$params['cname']}%");
}
}
if (!empty($params['ugname'])) {
$condition .= db_quote(" AND ?:usergroup_descriptions.usergroup LIKE ?l", "%{$params['ugname']}%");
}
$join = db_quote("LEFT JOIN ?:users ON ?:usergroup_links.user_id = ?:users.user_id LEFT JOIN ?:usergroup_descriptions ON ?:usergroup_links.usergroup_id = ?:usergroup_descriptions.usergroup_id AND ?:usergroup_descriptions.lang_code = ?s", $lang_code);
$limit = '';
if (!empty($params['items_per_page'])) {
$params['total_items'] = db_get_field("SELECT COUNT(?:usergroup_links.link_id) FROM ?:usergroup_links {$join} WHERE ?:usergroup_links.status = ?s {$condition}", $status);
$limit = db_paginate($params['page'], $params['items_per_page'], $params['total_items']);
}
$requests = db_get_array("SELECT " . implode(', ', $fields) . " FROM ?:usergroup_links {$join} WHERE ?:usergroup_links.status = ?s {$condition} {$sorting} {$limit}", $status);
return array($requests, $params);
}
/**
* 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_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 categories tree beginning from category identifier defined in params or root category
* @param array $params Categories search params
* category_id - Root category identifier
* visible - Flag that defines if only visible categories should be included
* current_category_id - Identifier of current node for visible categories
* simple - Flag that defines if category path should be getted as set of category IDs
* plain - Flag that defines if continues list of categories should be returned
* --------------------------------------
* Examples:
* Gets whole categories tree:
* fn_ebay_get_categories()
* --------------------------------------
* Gets subcategories tree of the category:
* fn_ebay_get_categories(array(
* 'category_id' => 123
* ))
* --------------------------------------
* Gets all first-level nodes of the category
* fn_ebay_get_categories(array(
* 'category_id' => 123,
* 'visible' => true
* ))
* --------------------------------------
* Gets all visible nodes of the category, start from the root
* fn_ebay_get_categories(array(
* 'category_id' => 0,
* 'current_category_id' => 234,
* 'visible' => true
* ))
* @param int $site_id
* @param string $lang_code 2-letters language code
* @return array Categories tree
*/
function fn_ebay_get_categories($params = array(), $site_id = 0, $lang_code = CART_LANGUAGE)
{
$default_params = array('category_id' => 0, 'visible' => false, 'current_category_id' => 0, 'simple' => true, 'plain' => false, 'limit' => 0, 'item_ids' => '', 'group_by_level' => true, 'category_delimiter' => ',', 'max_nesting_level' => null);
$params = array_merge($default_params, $params);
$sortings = array('name' => '?:ebay_categories.name');
$fields = array('category_id', 'parent_id', 'id_path', 'name', 'level', 'leaf', 'site_id');
if (empty($params['current_category_id']) && !empty($params['product_category_id'])) {
$params['current_category_id'] = $params['product_category_id'];
}
$condition = db_quote('AND site_id = ?i', $site_id);
if (isset($params['parent_category_id'])) {
// set parent id, that was set in block properties
$params['category_id'] = $params['parent_category_id'];
}
if (empty($params['b_id'])) {
$parent_categories_ids = array();
if (!empty($params['current_category_id'])) {
$cur_id_path = db_get_field("SELECT id_path FROM ?:ebay_categories WHERE category_id = ?i AND site_id = ?i", $params['current_category_id'], $site_id);
if (!empty($cur_id_path)) {
$parent_categories_ids = explode(',', $cur_id_path);
}
}
if (!empty($params['category_id']) || empty($parent_categories_ids)) {
$parent_categories_ids[] = $params['category_id'];
}
$parents_condition = db_quote(" AND ?:ebay_categories.parent_id IN (?n)", $parent_categories_ids);
}
// if we have company_condtion, skip $parents_condition, it will be processed later by PHP
if (!empty($parents_condition) && empty($company_condition)) {
$condition .= $parents_condition;
}
if (!empty($params['category_id'])) {
$from_id_path = db_get_field("SELECT id_path FROM ?:ebay_categories WHERE category_id = ?i AND site_id = ?i", $params['category_id'], $site_id);
$condition .= db_quote(" AND ?:ebay_categories.id_path LIKE ?l", "{$from_id_path},%");
}
if (!empty($params['item_ids'])) {
$condition .= db_quote(' AND ?:ebay_categories.category_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 ?:ebay_categories.category_id != ?i AND ?:ebay_categories.parent_id != ?i', $params['except_id'], $params['except_id']);
}
if (!empty($params['max_nesting_level'])) {
$condition .= db_quote(" AND ?:ebay_categories.level <= ?i", $params['max_nesting_level']);
}
$limit = $join = $group_by = '';
if (!empty($params['limit'])) {
$limit = db_quote(' LIMIT 0, ?i', $params['limit']);
}
$sorting = db_sort($params, $sortings, 'name', 'asc');
$categories = db_get_hash_array('SELECT ' . implode(',', $fields) . " FROM ?:ebay_categories WHERE 1 ?p {$group_by} {$sorting} ?p", 'category_id', $condition, $limit);
if (empty($categories)) {
return array(array());
}
// @TODO remove from here, because active category may not exist in the resulting set. This is the job for controller.
if (!empty($params['active_category_id']) && !empty($categories[$params['active_category_id']])) {
$categories[$params['active_category_id']]['active'] = true;
}
$categories_list = array();
if ($params['simple'] == true || $params['group_by_level'] == true) {
$child_for = array_keys($categories);
$where_condition = !empty($params['except_id']) ? db_quote(' AND category_id != ?i', $params['except_id']) : '';
$has_children = db_get_hash_array("SELECT category_id, parent_id FROM ?:ebay_categories WHERE parent_id IN(?n) AND site_id = ?i ?p", 'parent_id', $child_for, $site_id, $where_condition);
}
$category_ids = array();
// Group categories by the level (simple)
if ($params['simple'] == true) {
foreach ($categories as $k => $v) {
$v['level'] = substr_count($v['id_path'], ',');
if ((!empty($params['current_category_id']) || $v['level'] == 0) && isset($has_children[$k])) {
$v['has_children'] = $has_children[$k]['category_id'];
}
$categories_list[$v['level']][$v['category_id']] = $v;
$category_ids[] = $v['category_id'];
}
} elseif ($params['group_by_level'] == true) {
// Group categories by the level (simple) and literalize path
foreach ($categories as $k => $v) {
$path = explode('/', $v['id_path']);
$category_path = array();
foreach ($path as $__k => $__v) {
$category_path[$__v] = @$categories[$__v]['category'];
}
$v['category_path'] = implode($params['category_delimiter'], $category_path);
$v['level'] = substr_count($v['id_path'], ",");
if ((!empty($params['current_category_id']) || $v['level'] == 0) && isset($has_children[$k])) {
$v['has_children'] = $has_children[$k]['category_id'];
}
$categories_list[$v['level']][$v['category_id']] = $v;
$category_ids[] = $v['category_id'];
}
} else {
// @FIXME: Seems that this code isn't being executed anywhere
$categories_list = $categories;
$category_ids = fn_fields_from_multi_level($categories_list, 'category_id', 'category_id');
}
ksort($categories_list, SORT_NUMERIC);
$categories_list = array_reverse($categories_list, !$params['simple'] && !$params['group_by_level']);
// Rearrangement of subcategories and filling with images
foreach ($categories_list as $level => $categories_of_level) {
foreach ($categories_of_level as $category_id => $category_data) {
// Move subcategories to their parents' elements
if (isset($category_data['parent_id']) && isset($categories_list[$level + 1][$category_data['parent_id']])) {
$categories_list[$level + 1][$category_data['parent_id']]['subcategories'][] = $categories_list[$level][$category_id];
unset($categories_list[$level][$category_id]);
}
}
}
if ($params['group_by_level'] == true) {
$categories_list = array_pop($categories_list);
}
if ($params['plain'] == true) {
$categories_list = fn_multi_level_to_plain($categories_list, 'subcategories');
}
if (!empty($params['item_ids'])) {
$categories_list = fn_sort_by_ids($categories_list, explode(',', $params['item_ids']), 'category_id');
}
if (!empty($params['add_root'])) {
array_unshift($categories_list, array('category_id' => 0, 'category' => $params['add_root']));
}
fn_dropdown_appearance_cut_second_third_levels($categories_list, 'subcategories', $params);
return array($categories_list, $params);
}
function fn_get_product_counts_by_category($params, $lang_code = CART_LANGUAGE)
{
$default_params = array('company_id' => 0, 'sort_by' => 'position', 'sort_order' => 'asc');
$params = array_merge($default_params, $params);
$sort_fields = array('position' => '?:categories.position', 'category' => '?:category_descriptions.category', 'count' => 'count');
$sort = db_sort($params, $sort_fields, $default_params['sort_by'], $default_params['sort_order']);
$condition = $join = '';
if (!empty($params['company_id'])) {
if (is_array($params['company_id'])) {
$condition .= db_quote(" AND ?:products.company_id IN (?a) ", $params['company_id']);
} else {
$condition .= db_quote(" AND ?:products.company_id = ?i ", $params['company_id']);
}
}
$condition .= db_quote(" AND ?:category_descriptions.lang_code = ?s ", $lang_code);
$join .= 'JOIN ?:products ON ?:products_categories.product_id = ?:products.product_id ';
$join .= 'JOIN ?:categories ON ?:products_categories.category_id = ?:categories.category_id ';
$join .= 'JOIN ?:category_descriptions ON ?:products_categories.category_id = ?:category_descriptions.category_id ';
$result = db_get_array("SELECT COUNT(*) as count, ?:category_descriptions.category, ?:category_descriptions.category_id FROM ?:products_categories ?p WHERE 1 ?p GROUP BY ?:products_categories.category_id ?p", $join, $condition, $sort);
return $result;
}
function fn_get_news($params, $items_per_page = 0, $lang_code = CART_LANGUAGE)
{
$default_params = array('page' => 1, 'items_per_page' => $items_per_page);
$params = array_merge($default_params, $params);
$fields = array('?:news.*', 'descr.news', 'descr.description');
// Define sort fields
$sortings = array('position' => '?:news.position', 'name' => 'descr.news', 'date' => '?:news.date');
$limit = $condition = '';
$join = db_quote(" LEFT JOIN ?:news_descriptions AS descr ON descr.news_id = ?:news.news_id AND descr.lang_code = ?s", $lang_code);
$condition .= AREA == 'A' ? '1 ' : " ?:news.status = 'A'";
$condition .= fn_get_localizations_condition('?:news.localization');
// Get additional information about companies
if (fn_allowed_for('ULTIMATE')) {
$fields[] = ' ?:companies.company as company';
$sortings['company'] = 'company';
$join .= db_quote(" LEFT JOIN ?:companies ON ?:companies.company_id = ?:news.company_id");
}
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();
$tmp[] = db_quote("descr.news LIKE ?l", "%{$piece}%");
$tmp[] = db_quote("descr.description LIKE ?l", "%{$piece}%");
$_condition[] = '(' . join(' OR ', $tmp) . ')';
}
$_cond = implode($search_type, $_condition);
if (!empty($_condition)) {
$condition .= ' AND (' . $_cond . ') ';
}
}
if (!empty($params['period']) && $params['period'] != 'A') {
list($params['time_from'], $params['time_to']) = fn_create_periods($params);
$condition .= db_quote(" AND (?:news.date >= ?i AND ?:news.date <= ?i)", $params['time_from'], $params['time_to']);
}
if (!empty($params['item_ids'])) {
$condition .= db_quote(' AND ?:news.news_id IN (?n)', explode(',', $params['item_ids']));
}
$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(?:news.news_id) FROM ?:news ?p WHERE ?p", $join, $condition);
$limit = db_paginate($params['page'], $params['items_per_page']);
}
fn_set_hook('get_news', $params, $fields, $join, $condition, $sorting, $limit, $lang_code);
$sorting = db_sort($params, $sortings, 'date', 'desc');
// Used for Extended search
if (!empty($params['get_conditions'])) {
return array($fields, $join, $condition);
}
$fields = join(', ', $fields);
$news = db_get_array("SELECT ?p FROM ?:news ?p WHERE ?p ?p ?p", $fields, $join, $condition, $sorting, $limit);
/**
* Get additional data for selected news
*
* @param array $news news list
* @param string $lang_code language code
*/
fn_set_hook('get_news_post', $news, $lang_code);
return array($news, $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);
}
function fn_access_restrictions_get_rules($params, $items_per_page, $lang_code = DESCR_SL)
{
// Set default values to input params
$default_params = array('selected_section' => 'ip', 'page' => 1, 'items_per_page' => $items_per_page);
$params = array_merge($default_params, $params);
$types = array('ip' => array("ips", "ipr", "ipb"), 'domain' => array("d"), 'email' => array("es", "ed"), 'credit_card' => array("cc"), 'admin_panel' => array("aas", "aar", "aab"));
// Select sorting
if ($params['selected_section'] == 'ip' || $params['selected_section'] == 'admin_panel') {
$sortings = array('ip' => 'a.ip_from', 'reason' => 'b.reason', 'created' => 'a.timestamp', 'expires' => 'a.expires', 'status' => 'a.status');
} else {
$sortings = array('value' => 'a.value', 'reason' => 'b.reason', 'created' => 'a.timestamp', 'status' => 'a.status');
}
$sorting = db_sort($params, $sortings, 'created', 'desc');
$limit = '';
if (!empty($params['items_per_page'])) {
$params['total_items'] = db_get_field("SELECT COUNT(a.item_id) FROM ?:access_restriction as a WHERE a.type IN (?a)", $types[$params['selected_section']]);
$limit = db_paginate($params['page'], $params['items_per_page'], $params['total_items']);
}
$rules = db_get_array("SELECT a.*, b.reason FROM ?:access_restriction as a LEFT JOIN ?:access_restriction_reason_descriptions as b ON a.item_id = b.item_id AND b.type = a.type AND lang_code = ?s WHERE a.type IN (?a) {$sorting} {$limit}", $lang_code, $types[$params['selected_section']]);
return array($rules, $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);
}
/**
* Gets abandoned/live carts
*
* @param array $params Query parameters
* @param int $items_per_page Number of carts per page
* @return array Abandoned/live carts
* array(
* 0: array List of carts
* 1: array Query parameters
* 2: array User IDs (grouped by companies for ultimate)
* )
*/
function fn_get_carts($params, $items_per_page = 0)
{
// Init filter
$params = LastView::instance()->update('carts', $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('?:user_session_products.user_id', '?:users.firstname', '?:users.lastname', '?:user_session_products.timestamp AS date', '?:user_session_products.ip_address');
// Define sort fields
$sortings = array('customer' => "CONCAT(?:users.lastname, ?:users.firstname)", 'date' => "?:user_session_products.timestamp");
if (fn_allowed_for('ULTIMATE')) {
$sortings['company_id'] = "?:user_session_products.company_id";
}
$sorting = db_sort($params, $sortings, 'customer', 'asc');
$condition = $join = '';
$group = " GROUP BY ?:user_session_products.user_id";
$group_post = '';
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 (!empty($params['user_id'])) {
$condition .= db_quote(" AND ?:user_session_products.user_id = ?i", $params['user_id']);
}
if (!empty($params['online_only'])) {
$sessions = Tygh::$app['session']->getStorageDriver()->getOnline('C');
if (!empty($sessions)) {
$condition .= db_quote(" AND ?:user_session_products.session_id IN (?a)", $sessions);
} else {
$condition .= db_quote(" AND 0");
}
}
if (!empty($params['with_info_only'])) {
$condition .= db_quote(" AND ?:users.email != ''");
}
if (!empty($params['users_type'])) {
if ($params['users_type'] == 'R') {
$condition .= db_quote(" AND !ISNULL(?:users.user_id)");
} elseif ($params['users_type'] == 'G') {
$condition .= db_quote(" AND ISNULL(?:users.user_id)");
}
}
if (!empty($params['total_from']) || !empty($params['total_to'])) {
$having = '';
if (!empty($params['total_from']) && fn_is_numeric($params['total_from'])) {
$having .= db_quote(" AND SUM(price * amount) >= ?d", $params['total_from']);
}
if (!empty($params['total_to']) && fn_is_numeric($params['total_to'])) {
$having .= db_quote(" AND SUM(price * amount) <= ?d", $params['total_to']);
}
if (!empty($having)) {
$users4total = db_get_fields("SELECT user_id FROM ?:user_session_products GROUP BY user_id HAVING 1 {$having}");
if (!empty($users4total)) {
$condition .= db_quote(" AND (?:user_session_products.user_id IN (?n))", $users4total);
} else {
$condition .= " AND (?:user_session_products.user_id = 'no')";
}
}
}
if (!empty($params['period']) && $params['period'] != 'A') {
list($params['time_from'], $params['time_to']) = fn_create_periods($params);
$condition .= db_quote(" AND (?:user_session_products.timestamp >= ?i AND ?:user_session_products.timestamp <= ?i)", $params['time_from'], $params['time_to']);
}
$_condition = array();
if (!empty($params['product_type_c'])) {
$_condition[] = "?:user_session_products.type = 'C'";
}
if (!empty($params['product_type_w'])) {
$_condition[] = "?:user_session_products.type = 'W'";
}
if (!empty($_condition)) {
$condition .= " AND (" . implode(" OR ", $_condition) . ")";
}
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 ?:user_session_products.product_id IN (?n)", $arr);
} else {
$condition .= db_quote(" AND ?:user_session_products.product_id IN (?n)", db_get_fields(fn_get_products(array('view_id' => $params['product_view_id'], 'get_query' => true))));
}
$group_post .= " HAVING COUNT(?:user_session_products.user_id) >= " . count($arr);
}
$join .= " LEFT JOIN ?:users ON ?:user_session_products.user_id = ?:users.user_id";
// checking types for retrieving from the database
$type_restrictions = array('C');
/**
* Sets getting abandoned/live carts parameters
*
* @param array $type_restrictions Product types
* @param array $params Query params
* @param string $condition String containing SQL-query condition possibly prepended with a logical operator (AND or OR)
* @param string $join String with the complete JOIN information (JOIN type, tables and fields) for an SQL-query
* @param array $fields SQL fields to be selected in an SQL-query
* @param string $group String containing the SQL-query GROUP BY field
* @param $array_index_field Deprecated unused parameter
*/
fn_set_hook('get_carts', $type_restrictions, $params, $condition, $join, $fields, $group, $array_index_field);
if (!empty($type_restrictions) && is_array($type_restrictions)) {
$condition .= " AND ?:user_session_products.type IN ('" . implode("', '", $type_restrictions) . "')";
}
$carts_list = array();
$group .= $group_post;
$limit = '';
if (!empty($params['items_per_page'])) {
$limit = db_paginate($params['page'], $params['items_per_page']);
}
if (fn_allowed_for('ULTIMATE')) {
$group = " GROUP BY ?:user_session_products.user_id, ?:user_session_products.company_id";
}
/**
* Gets abandoned/live carts
*
* @param array $params Query params
* @param int $items_per_page Amount of carts per page
* @param array $fields 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 String containing the SQL-query GROUP BY field
* @param string $sorting String containing the SQL-query ORDER BY field
* @param string $limit String containing the SQL-query LIMIT field
*/
fn_set_hook('get_carts_before_select', $params, $items_per_page, $fields, $join, $condition, $group, $sorting, $limit);
$carts_list = db_get_hash_array("SELECT SQL_CALC_FOUND_ROWS " . implode(', ', $fields) . " FROM ?:user_session_products {$join}" . " WHERE 1 {$condition} {$group} {$sorting} {$limit}", 'user_id');
if (!empty($params['items_per_page'])) {
$params['total_items'] = db_get_found_rows();
}
$extra_data = db_get_hash_array("SELECT user_id, SUM(amount) as cart_products, SUM(amount * price) as total, order_id" . " FROM ?:user_session_products" . " WHERE user_id IN(?n) AND type = 'C'" . " GROUP BY user_id", 'user_id', array_keys($carts_list));
if ($extra_data) {
$carts_list = fn_array_merge($carts_list, $extra_data);
}
$user_ids = array();
foreach ($carts_list as &$item) {
$item['ip_address'] = fn_ip_from_db($item['ip_address']);
$item['user_data'] = fn_get_user_info($item['user_id'], true);
unset($item['user_data']['password'], $item['user_data']['salt'], $item['user_data']['last_passwords'], $item['user_data']['password_change_timestamp'], $item['user_data']['api_key']);
if (fn_allowed_for('ULTIMATE')) {
$user_ids[$item['company_id']][] = $item['user_id'];
} else {
$user_ids[] = $item['user_id'];
}
}
/**
* Actions after getting abandoned/live carts
*
* @param array $carts_list List of abandoned/live carts
* @param array $params Query params
* @param array $user_ids Cart User IDs. Grouped by companies for ultimate
* @param int $items_per_page Amount of carts per page
* @param array $fields 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 String containing the SQL-query GROUP BY field
* @param string $sorting String containing the SQL-query ORDER BY field
* @param string $limit String containing the SQL-query LIMIT field
*/
fn_set_hook('get_carts_post', $carts_list, $params, $user_ids, $items_per_page, $fields, $join, $condition, $group, $sorting, $limit);
LastView::instance()->processResults('carts', $carts_list, $params);
return array($carts_list, $params, $user_ids);
}
