function fn_em_confirm_subscription($email) { $subscriber_data = fn_em_get_subscriber_data($email); $subscribed = EmailSync::instance()->subscribe(array('email' => $email, 'timestamp' => $subscriber_data['timestamp'], 'lang_code' => $subscriber_data['lang_code'], 'ip_address' => fn_ip_from_db($subscriber_data['ip_address']), 'name' => $subscriber_data['name'])); if ($subscribed) { $unsubscribe_key = md5(uniqid()); db_query("UPDATE ?:em_subscribers SET ?u WHERE email = ?s", array('status' => 'A', 'unsubscribe_key' => $unsubscribe_key), $email); if (Registry::get('addons.email_marketing.em_welcome_letter') == 'Y') { Mailer::sendMail(array('to' => $email, 'from' => 'default_company_newsletter_email', 'data' => array('url' => fn_url('em_subscribers.unsubscribe?unsubscribe_key=' . $unsubscribe_key)), 'tpl' => Registry::get('addons.email_marketing.em_double_opt_in') == 'Y' ? 'addons/email_marketing/welcome_2optin.tpl' : 'addons/email_marketing/welcome.tpl')); } } return $subscribed; }
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); }
exit; } return array(CONTROLLER_STATUS_OK, fn_url()); } if ($mode == 'delete_post' && defined('AJAX_REQUEST')) { db_query("DELETE FROM ?:discussion_messages WHERE post_id = ?i", $_REQUEST['post_id']); db_query("DELETE FROM ?:discussion_rating WHERE post_id = ?i", $_REQUEST['post_id']); db_query("DELETE FROM ?:discussion_posts WHERE post_id = ?i", $_REQUEST['post_id']); return array(CONTROLLER_STATUS_OK, fn_url()); } return; } // No action for vendor at the index if (Registry::get('runtime.company_id') && fn_allowed_for('MULTIVENDOR')) { return; } $latest_posts = db_get_array("SELECT a.post_id, a.ip_address, a.status, a.timestamp, b.object_id, b.object_type as object_type, b.type as type, a.name, c.message, d.rating_value " . "FROM ?:discussion_posts as a INNER JOIN ?:discussion as b ON a.thread_id = b.thread_id ?p " . "LEFT JOIN ?:discussion_messages as c ON a.post_id = c.post_id LEFT JOIN ?:discussion_rating as d ON a.post_id = d.post_id " . "ORDER BY a.timestamp DESC LIMIT 5", fn_get_discussion_company_condition('b.company_id')); if (!empty($latest_posts)) { foreach ($latest_posts as $k => $v) { $latest_posts[$k]['ip_address'] = fn_ip_from_db($v['ip_address']); $latest_posts[$k]['object_data'] = fn_get_discussion_object_data($v['object_id'], $v['object_type'], DESCR_SL); $latest_posts[$k]['rating'] = fn_get_discussion_rating($v['rating_value']); } } Registry::get('view')->assign('discussion_objects', fn_get_discussion_objects()); Registry::get('view')->assign('latest_posts', $latest_posts); if ($mode == 'delete_post' && defined('AJAX_REQUEST')) { // FIXME - bad style Registry::get('view')->display('addons/discussion/views/index/components/dashboard.tpl'); exit; }
function fn_get_discussion_posts($params, $items_per_page = 0) { // Set default values to input params $default_params = array('page' => 1, 'thread_id' => 0, 'avail_only' => false, 'random' => false, 'items_per_page' => $items_per_page); $params = array_merge($default_params, $params); $thread_data = db_get_row("SELECT thread_id, type, object_type, object_id FROM ?:discussion WHERE thread_id = ?i ?p", $params['thread_id'], fn_get_discussion_company_condition('?:discussion.company_id')); if ($thread_data['type'] == 'D') { return array(array(), $params); } $thread_condition = fn_generate_thread_condition($thread_data); $join = $fields = ''; if ($thread_data['type'] == 'C' || $thread_data['type'] == 'B') { $join .= " LEFT JOIN ?:discussion_messages ON ?:discussion_messages.post_id = ?:discussion_posts.post_id "; $fields .= ", ?:discussion_messages.message"; if ($thread_data['type'] == 'C') { $thread_condition .= " AND ?:discussion_messages.message <> ''"; } } if ($thread_data['type'] == 'R' || $thread_data['type'] == 'B') { $join .= " LEFT JOIN ?:discussion_rating ON ?:discussion_rating.post_id = ?:discussion_posts.post_id "; $fields .= ", ?:discussion_rating.rating_value"; if ($thread_data['type'] == 'R') { $thread_condition .= " AND ?:discussion_rating.rating_value > 0"; } } if ($params['avail_only'] == true) { $thread_condition .= " AND ?:discussion_posts.status = 'A'"; } $limit = ''; if (!empty($params['limit'])) { $limit = db_quote("LIMIT ?i", $params['limit']); } elseif (!empty($params['items_per_page'])) { $params['total_items'] = db_get_field("SELECT COUNT(*) FROM ?:discussion_posts {$join} WHERE {$thread_condition}"); $limit = db_paginate($params['page'], $params['items_per_page'], $params['total_items']); } $order_by = isset($params['random']) && $params['random'] == 'Y' ? 'RAND()' : '?:discussion_posts.timestamp DESC'; $posts = db_get_array("SELECT ?:discussion_posts.* {$fields} FROM ?:discussion_posts {$join} " . "WHERE {$thread_condition} ORDER BY ?p {$limit}", $order_by); 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); }
/** * Returns orders * * @param array $params array with search params * @param int $items_per_page * @param bool $get_totals * @param string $lang_code * @return array */ function fn_get_orders($params, $items_per_page = 0, $get_totals = false, $lang_code = CART_LANGUAGE) { // Init filter $params = LastView::instance()->update('orders', $params); // Set default values to input params $default_params = array('page' => 1, 'items_per_page' => $items_per_page); $params = array_merge($default_params, $params); if (AREA != 'C') { $params['include_incompleted'] = empty($params['include_incompleted']) ? false : $params['include_incompleted']; // default incomplited orders should not be displayed if (!empty($params['status']) && (is_array($params['status']) && in_array(STATUS_INCOMPLETED_ORDER, $params['status']) || !is_array($params['status']) && $params['status'] == STATUS_INCOMPLETED_ORDER)) { $params['include_incompleted'] = true; } } else { $params['include_incompleted'] = false; } // Define fields that should be retrieved $fields = array("distinct ?:orders.order_id", "?:orders.issuer_id", "?:orders.user_id", "?:orders.is_parent_order", "?:orders.parent_order_id", "?:orders.company_id", "?:orders.timestamp", "?:orders.firstname", "?:orders.lastname", "?:orders.email", "?:orders.phone", "?:orders.status", "?:orders.total", "invoice_docs.doc_id as invoice_id", "memo_docs.doc_id as credit_memo_id"); // Define sort fields $sortings = array('order_id' => "?:orders.order_id", 'status' => "?:orders.status", 'customer' => array("?:orders.lastname", "?:orders.firstname"), 'email' => "?:orders.email", 'date' => array("?:orders.timestamp", "?:orders.order_id"), 'total' => "?:orders.total"); fn_set_hook('pre_get_orders', $params, $fields, $sortings, $get_totals, $lang_code); if (isset($params['compact']) && $params['compact'] == 'Y') { $union_condition = ' OR '; } else { $union_condition = ' AND '; } $condition = $_condition = $join = $group = ''; $condition .= " AND ?:orders.is_parent_order != 'Y' "; $condition .= fn_get_company_condition('?:orders.company_id'); if (isset($params['cname']) && fn_string_not_empty($params['cname'])) { $customer_name = fn_explode(' ', $params['cname']); $customer_name = array_filter($customer_name, "fn_string_not_empty"); if (sizeof($customer_name) == 2) { $_condition .= db_quote(" {$union_condition} ?:orders.firstname LIKE ?l AND ?:orders.lastname LIKE ?l", "%" . array_shift($customer_name) . "%", "%" . array_shift($customer_name) . "%"); } else { $_condition .= db_quote(" {$union_condition} (?:orders.firstname LIKE ?l OR ?:orders.lastname LIKE ?l)", "%" . trim($params['cname']) . "%", "%" . trim($params['cname']) . "%"); } } if (isset($params['issuer']) && fn_string_not_empty($params['issuer'])) { $issuer_name = fn_explode(' ', $params['issuer']); $issuer_name = array_filter($issuer_name, "fn_string_not_empty"); if (sizeof($issuer_name) == 2) { $issuer_ids = db_get_field("SELECT user_id FROM ?:users WHERE user_type IN ('A', 'V') AND firstname LIKE ?l AND lastname LIKE ?l", "%" . array_shift($issuer_name) . "%", "%" . array_shift($issuer_name) . "%"); } else { $issuer_ids = db_get_field("SELECT user_id FROM ?:users WHERE user_type IN ('A', 'V') AND (firstname LIKE ?l OR lastname LIKE ?l)", "%" . trim($params['issuer']) . "%", "%" . trim($params['issuer']) . "%"); } $_condition .= db_quote(" {$union_condition} ?:orders.issuer_id IN (?a)", $issuer_ids); } if (isset($params['company_id']) && $params['company_id'] != '') { $condition .= db_quote(' AND ?:orders.company_id = ?i ', $params['company_id']); } if (!empty($params['tax_exempt'])) { $condition .= db_quote(" AND ?:orders.tax_exempt = ?s", $params['tax_exempt']); } if (isset($params['email']) && fn_string_not_empty($params['email'])) { $_condition .= db_quote(" {$union_condition} ?:orders.email LIKE ?l", "%" . trim($params['email']) . "%"); } if (!empty($params['user_id'])) { $condition .= db_quote(' AND ?:orders.user_id IN (?n)', $params['user_id']); } if (isset($params['total_from']) && fn_is_numeric($params['total_from'])) { $condition .= db_quote(" AND ?:orders.total >= ?d", fn_convert_price($params['total_from'])); } if (!empty($params['total_to']) && fn_is_numeric($params['total_to'])) { $condition .= db_quote(" AND ?:orders.total <= ?d", fn_convert_price($params['total_to'])); } if (!empty($params['status'])) { $condition .= db_quote(' AND ?:orders.status IN (?a)', $params['status']); } if (empty($params['include_incompleted'])) { $condition .= db_quote(' AND ?:orders.status != ?s', STATUS_INCOMPLETED_ORDER); } if (!empty($params['order_id'])) { $_condition .= db_quote($union_condition . ' ?:orders.order_id IN (?n)', !is_array($params['order_id']) && strpos($params['order_id'], ',') !== false ? explode(',', $params['order_id']) : $params['order_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 .= 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 .= " GROUP BY ?:orders.order_id "; } if (!empty($params['admin_user_id'])) { $condition .= db_quote(" AND ?:new_orders.user_id = ?i", $params['admin_user_id']); $join .= " LEFT JOIN ?:new_orders ON ?:new_orders.order_id = ?:orders.order_id"; } $docs_conditions = array(); if (!empty($params['invoice_id']) || !empty($params['has_invoice'])) { if (!empty($params['has_invoice'])) { $docs_conditions[] = "invoice_docs.doc_id IS NOT NULL"; } elseif (!empty($params['invoice_id'])) { $docs_conditions[] = db_quote("invoice_docs.doc_id = ?i", $params['invoice_id']); } } $join .= " LEFT JOIN ?:order_docs as invoice_docs ON invoice_docs.order_id = ?:orders.order_id AND invoice_docs.type = 'I'"; if (!empty($params['credit_memo_id']) || !empty($params['has_credit_memo'])) { if (!empty($params['has_credit_memo'])) { $docs_conditions[] = "memo_docs.doc_id IS NOT NULL"; } elseif (!empty($params['credit_memo_id'])) { $docs_conditions[] = db_quote("memo_docs.doc_id = ?i", $params['credit_memo_id']); } } $join .= " LEFT JOIN ?:order_docs as memo_docs ON memo_docs.order_id = ?:orders.order_id AND memo_docs.type = 'C'"; if (!empty($docs_conditions)) { $condition .= ' AND (' . implode(' OR ', $docs_conditions) . ')'; } if (!empty($params['shippings'])) { $set_conditions = array(); foreach ($params['shippings'] as $v) { $set_conditions[] = db_quote("FIND_IN_SET(?s, ?:orders.shipping_ids)", $v); } $condition .= ' AND (' . implode(' OR ', $set_conditions) . ')'; } if (!empty($params['payments'])) { $condition .= db_quote(" AND ?:orders.payment_id IN (?a)", $params['payments']); } if (!empty($params['period']) && $params['period'] != 'A') { list($params['time_from'], $params['time_to']) = fn_create_periods($params); $condition .= db_quote(" AND (?:orders.timestamp >= ?i AND ?:orders.timestamp <= ?i)", $params['time_from'], $params['time_to']); } if (!empty($params['custom_files']) && $params['custom_files'] == 'Y') { $condition .= db_quote(" AND ?:order_details.extra LIKE ?l", '%custom_files%'); if (empty($params['p_ids']) && empty($params['product_view_id'])) { $join .= " LEFT JOIN ?:order_details ON ?:order_details.order_id = ?:orders.order_id"; } } if (!empty($params['company_name'])) { $fields[] = '?:companies.company as company_name'; $join .= " LEFT JOIN ?:companies ON ?:companies.company_id = ?:orders.company_id"; } if (!empty($_condition)) { $condition .= ' AND (' . ($union_condition == ' OR ' ? '0 ' : '1 ') . $_condition . ')'; } fn_set_hook('get_orders', $params, $fields, $sortings, $condition, $join, $group); $sorting = db_sort($params, $sortings, 'date', 'desc'); // Used for Extended search if (!empty($params['get_conditions'])) { return array($fields, $join, $condition); } $limit = ''; if (!empty($params['items_per_page'])) { $params['total_items'] = db_get_field("SELECT COUNT(DISTINCT (?:orders.order_id)) FROM ?:orders {$join} WHERE 1 {$condition}"); $limit = db_paginate($params['page'], $params['items_per_page'], $params['total_items']); } $orders = db_get_array('SELECT ' . implode(', ', $fields) . " FROM ?:orders {$join} WHERE 1 {$condition} {$group} {$sorting} {$limit}"); fn_set_hook('get_orders_post', $params, $orders); foreach ($orders as $k => $order) { if (isset($order['ip_address'])) { $order['ip_address'] = fn_ip_from_db($order['ip_address']); } } if ($get_totals == true) { $paid_statuses = array('P', 'C'); fn_set_hook('get_orders_totals', $paid_statuses, $join, $condition, $group); $totals = array('gross_total' => db_get_field("SELECT sum(t.total) FROM ( SELECT total FROM ?:orders {$join} WHERE 1 {$condition} {$group}) as t"), 'totally_paid' => db_get_field("SELECT sum(t.total) FROM ( SELECT total FROM ?:orders {$join} WHERE ?:orders.status IN (?a) {$condition} {$group}) as t", $paid_statuses)); $params['paid_statuses'] = $paid_statuses; } LastView::instance()->processResults('orders', $orders, $params); return array($orders, $params, $get_totals == true ? $totals : array()); }
$carts_list[$key]['cart_all_products'] = $all_cart_products[$key]['sum']; $carts_list[$key]['total'] = $all_cart_products[$key]['total']; $carts_list[$key]['user_data'] = fn_get_user_info($cart_data['user_id'], true); $carts_list[$key]['ip_address'] = fn_ip_from_db($all_cart_products[$key]['ip_address']); } $_SESSION['abandoned_carts'][$cart_data['company_id']][] = $cart_data['user_id']; } } else { foreach ($carts_list as $key => $cart_data) { $all_cart_products[$key] = db_get_row("SELECT SUM(amount) as count, SUM(amount) as sum, SUM(amount * price) as total, ip_address" . " FROM ?:user_session_products" . " WHERE user_id = ?i AND item_type IN (?a) AND type = 'C'" . " GROUP BY ?:user_session_products.user_id", $cart_data['user_id'], $item_types); if (!empty($all_cart_products[$key])) { $carts_list[$key]['cart_products'] = $all_cart_products[$key]['count']; $carts_list[$key]['cart_all_products'] = $all_cart_products[$key]['sum']; $carts_list[$key]['total'] = $all_cart_products[$key]['total']; $carts_list[$key]['user_data'] = fn_get_user_info($cart_data['user_id'], true); $carts_list[$key]['ip_address'] = fn_ip_from_db($all_cart_products[$key]['ip_address']); } $_SESSION['abandoned_carts'][] = $cart_data['user_id']; } } } Tygh::$app['view']->assign('carts_list', $carts_list); Tygh::$app['view']->assign('search', $search); } function fn_delete_user_cart($user_ids, $data = '') { $condition = db_quote(' AND user_id IN (?a)', $user_ids); fn_set_hook('delete_user_cart', $user_ids, $condition, $data); db_query("DELETE FROM ?:user_session_products WHERE 1 {$condition}"); return true; }
/** * Get poll votes * * @param array $params array of search parameters * @param int $items_per_page votes per page * @return boolean true if results exists, false otherwise */ function fn_polls_get_votes($params, $items_per_page = 0) { $votes = array(); $default_values = array('item_id' => 0, 'page' => 1, 'completed' => 'N', 'items_per_page' => $items_per_page); $fields = array('?:polls_votes.vote_id', '?:polls_votes.type', '?:polls_votes.time', '?:polls_votes.ip_address', '?:polls_votes.user_id', '?:users.firstname', '?:users.lastname'); $params = array_merge($default_values, $params); if (empty($params['poll_page_id'])) { return array($votes, $params); } $condition = '1'; $join = ''; if ($params['completed'] == 'Y') { $condition .= db_quote(" AND ?:polls_votes.type = ?s", 'C'); } if (!empty($params['anwer_id']) || !empty($params['item_id'])) { $join = db_quote(" LEFT JOIN ?:polls_answers ON ?:polls_answers.vote_id = ?:polls_votes.vote_id"); } if (!empty($params['answer_id'])) { $condition .= db_quote(" AND ?:polls_answers.answer_id = ?i", $params['answer_id']); } if (!empty($params['item_id'])) { $condition .= db_quote(" AND ?:polls_answers.item_id = ?i", $params['item_id']); } if (!empty($params['poll_page_id'])) { $condition .= db_quote(" AND ?:polls_votes.page_id = ?i", $params['poll_page_id']); } $limit = ''; if (!empty($params['items_per_page'])) { $params['total_items'] = db_get_field("SELECT COUNT(DISTINCT(?:polls_votes.vote_id)) FROM ?:polls_votes ?p WHERE ?p", $join, $condition); $limit = db_paginate($params['page'], $params['items_per_page'], $params['total_items']); } $join .= " LEFT JOIN ?:users ON ?:users.user_id = ?:polls_votes.user_id"; $votes = db_get_hash_array("SELECT " . implode(', ', $fields) . " FROM ?:polls_votes ?p WHERE ?p ORDER BY time DESC {$limit}", 'vote_id', $join, $condition); foreach ($votes as $k => $vote) { if (isset($vote['ip_address'])) { $votes[$k]['ip_address'] = fn_ip_from_db($vote['ip_address']); } } return array($votes, $params); }
/** * Gets discussion posts * * @param array $params Request parameters * @param int $items_per_page Amount of posts per page * @return array Array with posts and query parameters */ function fn_get_discussion_posts($params, $items_per_page = 0) { /** * Modifies request parameters for fetching discussion posts * @param array $params Query parameters * @param int $items_per_page Amount of posts per page */ fn_set_hook('get_discussion_posts_pre', $params, $items_per_page); // Set default values to input params $default_params = array('page' => 1, 'thread_id' => 0, 'avail_only' => false, 'random' => false, 'items_per_page' => $items_per_page); $params = array_merge($default_params, $params); $thread_data = db_get_row("SELECT thread_id, type, object_type, object_id FROM ?:discussion WHERE thread_id = ?i ?p", $params['thread_id'], fn_get_discussion_company_condition('?:discussion.company_id')); if ($thread_data['type'] == 'D') { return array(array(), $params); } $condition = fn_generate_thread_condition($thread_data); $join = $fields = ''; if ($thread_data['type'] == 'C' || $thread_data['type'] == 'B') { $join .= " LEFT JOIN ?:discussion_messages ON ?:discussion_messages.post_id = ?:discussion_posts.post_id "; $fields .= ", ?:discussion_messages.message"; if ($thread_data['type'] == 'C') { $condition .= " AND ?:discussion_messages.message <> ''"; } } if ($thread_data['type'] == 'R' || $thread_data['type'] == 'B') { $join .= " LEFT JOIN ?:discussion_rating ON ?:discussion_rating.post_id = ?:discussion_posts.post_id "; $fields .= ", ?:discussion_rating.rating_value"; if ($thread_data['type'] == 'R') { $condition .= " AND ?:discussion_rating.rating_value > 0"; } } if ($params['avail_only'] == true) { $condition .= " AND ?:discussion_posts.status = 'A'"; } $limit = ''; if (!empty($params['limit'])) { $limit = db_quote("LIMIT ?i", $params['limit']); } elseif (!empty($params['items_per_page'])) { $params['total_items'] = db_get_field("SELECT COUNT(*) FROM ?:discussion_posts {$join} WHERE {$condition}"); $limit = db_paginate($params['page'], $params['items_per_page'], $params['total_items']); } $order_by = isset($params['random']) && $params['random'] == 'Y' ? 'RAND()' : '?:discussion_posts.timestamp DESC'; /** * Modifies discuission posts query * * @param array $params Query parameters * @param int $items_per_page Amount of posts per page * @param string $fields String of comma-separated SQL fields to be selected in an SQL-query * @param string $join String with the complete JOIN information (JOIN type, tables and fields) for an SQL-query * @param string $condition String containing SQL-query condition possibly prepended with a logical operator (AND or OR) * @param string $order_by String containing SQL-query ordering conditions * @param string $limit String containing SQL-query limit conditions */ fn_set_hook('get_discussion_posts', $params, $items_per_page, $fields, $join, $condition, $order_by, $limit); $posts = db_get_array("SELECT ?:discussion_posts.* {$fields} FROM ?:discussion_posts {$join} " . "WHERE {$condition} ORDER BY ?p {$limit}", $order_by); foreach ($posts as $k => $post) { if (isset($post['ip_address'])) { $posts[$k]['ip_address'] = fn_ip_from_db($post['ip_address']); } } /** * Modifies discussion posts and request parameters * * @param array $params Query parameters * @param int $items_per_page Amount of posts per page * @param array $posts Discussion posts */ fn_set_hook('get_discussion_posts_post', $params, $items_per_page, $posts); return array($posts, $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); }