Exemple #1
0
function fn_buy_together_get_chains($params = array(), $auth = array(), $lang_code = CART_LANGUAGE)
{
    $fields = array('items.chain_id', 'items.product_id', 'items.products', 'items.modifier', 'items.modifier_type', 'items.date_from', 'items.date_to', 'items.display_in_promotions', 'items.status', 'descr.name', 'descr.description');
    $conditions = array();
    if (!empty($params['product_id'])) {
        $conditions[] = db_quote('items.product_id = ?i', $params['product_id']);
    }
    if (!empty($params['chain_id'])) {
        $conditions[] = db_quote('items.chain_id = ?i', $params['chain_id']);
    }
    if (!empty($params['status'])) {
        $conditions[] = db_quote('items.status = ?s', $params['status']);
    }
    if (!empty($params['date']) && $params['date']) {
        $date = mktime(0, 0, 0);
        $conditions[] = db_quote('(items.date_from <= ?i AND items.date_to >= ?i)', $date, $date);
    }
    if (!empty($params['promotions']) && $params['promotions']) {
        $conditions[] = db_quote('items.display_in_promotions = ?s', 'Y');
    }
    if (!empty($conditions)) {
        $condition = 'WHERE ' . implode(' AND ', $conditions);
    } else {
        $condition = '';
    }
    $fields = implode(', ', $fields);
    $chains = db_get_array("SELECT {$fields} FROM ?:buy_together AS items LEFT JOIN ?:buy_together_descriptions AS descr ON items.chain_id = descr.chain_id AND descr.lang_code = ?s {$condition}", $lang_code);
    if (!empty($chains)) {
        foreach ($chains as $key => $chain) {
            $chains[$key]['products'] = unserialize($chain['products']);
            if (!empty($params['full_info'])) {
                if ($params['full_info']) {
                    if (isset($auth['area']) && $auth['area'] == 'C' && empty($chains[$key]['products'])) {
                        unset($chains[$key]);
                        continue;
                    }
                    $chains[$key]['products_info'] = $chains[$key]['products'];
                    $is_valid = true;
                    $_product = fn_get_product_data($chain['product_id'], $auth, CART_LANGUAGE, '', true, true, true, true);
                    if (empty($_product)) {
                        $is_valid = false;
                        break;
                    }
                    fn_gather_additional_product_data($_product, true, true);
                    $chains[$key]['product_name'] = $_product['product'];
                    $chains[$key]['chain_amount'] = $_product['min_qty'] > 0 ? $_product['min_qty'] : 1;
                    $chains[$key]['min_qty'] = $_product['min_qty'] = 1;
                    $chains[$key]['price'] = $_product['price'];
                    $chains[$key]['list_price'] = $_product['list_price'];
                    $chains[$key]['main_pair'] = $_product['main_pair'];
                    $chains[$key]['default_options'] = fn_get_default_product_options($_product['product_id']);
                    $chains[$key]['product_options'] = $_product['product_options'];
                    list($chains[$key]['discount'], $chains[$key]['discounted_price']) = fn_buy_together_calculate_discount($_product['price'], $chain['modifier'], $chain['modifier_type']);
                    $chains[$key]['options_type'] = $_product['options_type'];
                    $chains[$key]['exceptions_type'] = $_product['exceptions_type'];
                    isset($_product['options_update']) ? $chains[$key]['options_update'] = $_product['options_update'] : ($chains[$key]['options_update'] = false);
                    $total_price = $_product['price'];
                    $chain_price = $chains[$key]['discounted_price'];
                    foreach ($chains[$key]['products'] as $hash => $product) {
                        if (empty($product['product_id'])) {
                            unset($chains[$key]['products'][$hash]);
                            unset($chains[$key]['products_info'][$hash]);
                            continue;
                        }
                        $_product = fn_get_product_data($product['product_id'], $auth, CART_LANGUAGE, '', true, true, true, true);
                        if (empty($_product)) {
                            $is_valid = false;
                            break;
                        }
                        fn_gather_additional_product_data($_product, true, true);
                        $_product['min_qty'] = $_product['min_qty'] > 0 ? $_product['min_qty'] : 1;
                        $chains[$key]['products'][$hash]['product_name'] = $_product['product'];
                        $chains[$key]['products'][$hash]['min_qty'] = $_product['min_qty'];
                        $chains[$key]['products'][$hash]['price'] = empty($chains[$key]['products'][$hash]['price']) ? $_product['price'] : $chains[$key]['products'][$hash]['price'];
                        $chains[$key]['products'][$hash]['list_price'] = $_product['list_price'];
                        $chains[$key]['products'][$hash]['main_pair'] = $_product['main_pair'];
                        $chains[$key]['products'][$hash]['options_type'] = $_product['options_type'];
                        $chains[$key]['products'][$hash]['exceptions_type'] = $_product['exceptions_type'];
                        isset($_product['options_update']) ? $chains[$key]['products'][$hash]['options_update'] = $_product['options_update'] : ($chains[$key]['products'][$hash]['options_update'] = false);
                        list($chains[$key]['products'][$hash]['discount'], $chains[$key]['products'][$hash]['discounted_price']) = fn_buy_together_calculate_discount($_product['price'], empty($product['modifier']) ? 0 : $product['modifier'], empty($product['modifier_type']) ? 'to_fixed' : $product['modifier_type']);
                        $total_price += $_product['price'] * $product['amount'];
                        $chain_price += $chains[$key]['products'][$hash]['discounted_price'] * $product['amount'];
                        if (!empty($product['product_options'])) {
                            $chains[$key]['products'][$hash]['product_options_short'] = $chains[$key]['products'][$hash]['product_options'];
                            $options = fn_get_selected_product_options_info($product['product_options'], DESCR_SL);
                            $chains[$key]['products'][$hash]['product_options'] = $options;
                        } elseif (!empty($_product['product_options'])) {
                            $chains[$key]['products'][$hash]['aoc'] = true;
                            // Allow any option combinations
                            $chains[$key]['products'][$hash]['options'] = $_product['product_options'];
                        }
                        $chains[$key]['products_info'][$hash]['price'] = $chains[$key]['products'][$hash]['price'];
                        $chains[$key]['products_info'][$hash]['discount'] = $chains[$key]['products'][$hash]['discount'];
                        $chains[$key]['products_info'][$hash]['discounted_price'] = $chains[$key]['products'][$hash]['discounted_price'];
                    }
                }
                if (!$is_valid) {
                    unset($chains[$key]);
                    continue;
                }
                $chains[$key]['total_price'] = $total_price;
                $chains[$key]['chain_price'] = $chain_price;
            }
            if (!empty($params['simple'])) {
                if ($params['simple']) {
                    return $chains[$key];
                }
            }
        }
    }
    return $chains;
}
Exemple #2
0
/**
 * Get products chains
 *
 * @param array $params Parameters for the function
 * @param array $auth Array of user authentication data
 * @param string $lang_code 2-letter language code (e.g. 'en', 'ru', etc.)
 *
 * @return array Chains of products
 */
function fn_buy_together_get_chains($params = array(), $auth = array(), $lang_code = CART_LANGUAGE)
{
    /**
     * Modify product chains get parameters
     *
     * @param array $params Parameters for the function
     * @param array $auth Array of user authentication data
     * @param string $lang_code 2-letter language code (e.g. 'en', 'ru', etc.)
     */
    fn_set_hook('buy_together_get_chains_pre', $parms, $auth, $lang_code);
    $fields = array('items.chain_id', 'items.product_id', 'items.products', 'items.modifier', 'items.modifier_type', 'items.date_from', 'items.date_to', 'items.display_in_promotions', 'items.status', 'descr.name', 'descr.description');
    if (fn_allowed_for('ULTIMATE')) {
        $fields[] = 'p.company_id';
    }
    $conditions = array();
    $joins = array();
    $joins[] = db_quote("LEFT JOIN ?:products AS p ON p.product_id = items.product_id");
    $joins[] = db_quote("LEFT JOIN ?:buy_together_descriptions AS descr ON items.chain_id = descr.chain_id AND descr.lang_code = ?s", $lang_code);
    if (!empty($params['product_id'])) {
        $conditions['product_id'] = db_quote('items.product_id = ?i', $params['product_id']);
    }
    if (!empty($params['chain_id'])) {
        $conditions['chain_id'] = db_quote('items.chain_id = ?i', $params['chain_id']);
    }
    if (!empty($params['status'])) {
        $conditions['status'] = db_quote('items.status = ?s', $params['status']);
    }
    if (!empty($params['date']) && $params['date']) {
        $date = mktime(0, 0, 0);
        $conditions['date'] = db_quote('(items.date_from <= ?i AND items.date_to >= ?i)', $date, $date);
    }
    if (!empty($params['promotions']) && $params['promotions']) {
        $conditions['promotions'] = db_quote('items.display_in_promotions = ?s', 'Y');
    }
    /**
     * Change select condition (fields, conditions, joins) before selecting payment method data
     *
     * @param array $params Parameters for the function
     * @param array $auth Array of user authentication data
     * @param string $lang_code 2-letter language code (e.g. 'en', 'ru', etc.)
     * @param array $fields Array of fields to be selected
     * @param array $conditions Array of complete condition expressions to be applied to the end of an SQL-query
     * @param array $joins List of strings with the complete JOIN information (JOIN type, tables and fields) for an SQL-query
     *
     */
    fn_set_hook('buy_together_get_chains', $params, $auth, $lang_code, $fields, $conditions, $joins);
    if (!empty($conditions)) {
        $condition = 'WHERE ' . implode(' AND ', $conditions);
    } else {
        $condition = '';
    }
    $fields = implode(', ', $fields);
    $joins = implode(' ', $joins);
    $chains = db_get_array("SELECT {$fields} FROM ?:buy_together AS items {$joins} {$condition}");
    if (!empty($chains)) {
        $selected_options = isset($params['selected_options']) ? $params['selected_options'] : array();
        $product_ids = array();
        $products = array();
        if (!empty($params['full_info'])) {
            foreach ($chains as $chain) {
                $product_ids[$chain['product_id']] = $chain['product_id'];
                $chain_products = unserialize($chain['products']);
                foreach ($chain_products as $product) {
                    $product_ids[$product['product_id']] = $product['product_id'];
                }
            }
            list($products) = fn_get_products(array('pid' => $product_ids));
        }
        foreach ($chains as $key => &$chain) {
            $chain['products'] = unserialize($chain['products']);
            if (!empty($params['full_info'])) {
                $is_valid = true;
                if (isset($auth['area']) && $auth['area'] == 'C' && empty($chain['products'])) {
                    unset($chains[$key]);
                    continue;
                }
                if (!isset($products[$chain['product_id']])) {
                    unset($chains[$key]);
                    continue;
                }
                $chain['products_info'] = $chain['products'];
                $main_product = $products[$chain['product_id']];
                $option_key = $main_product['product_id'] . '_' . $chain['chain_id'];
                $main_product['selected_options'] = isset($selected_options[$option_key]['selected_options']) ? $selected_options[$option_key]['selected_options'] : '';
                $main_product['changed_option'] = isset($selected_options[$option_key]['changed_option']) ? $params['selected_options'][$option_key]['changed_option'] : '';
                fn_gather_additional_products_data($main_product, array('get_icon' => true, 'get_detailed' => true, 'get_additional' => false, 'get_options' => true, 'get_discounts' => true));
                $chain['product_name'] = $main_product['product'];
                $chain['chain_amount'] = $main_product['min_qty'] > 0 ? $main_product['min_qty'] : 1;
                $chain['min_qty'] = $main_product['min_qty'] = 1;
                $chain['price'] = $main_product['price'];
                $chain['list_price'] = $main_product['list_price'];
                $chain['default_options'] = fn_get_default_product_options($main_product['product_id']);
                $chain['product_options'] = $main_product['product_options'];
                $chain['options_type'] = $main_product['options_type'];
                $chain['exceptions_type'] = $main_product['exceptions_type'];
                $chain['options_update'] = isset($main_product['options_update']) ? $main_product['options_update'] : false;
                list($chain['discount'], $chain['discounted_price']) = fn_buy_together_calculate_discount($main_product['price'], $chain['modifier'], $chain['modifier_type']);
                if (isset($main_product['main_pair'])) {
                    $chain['main_pair'] = $main_product['main_pair'];
                }
                $total_price = $main_product['price'];
                $chain_price = $chain['discounted_price'];
                foreach ($chain['products'] as $hash => &$chain_product) {
                    if (empty($product['product_id'])) {
                        unset($chains[$key]['products'][$hash]);
                        unset($chains[$key]['products_info'][$hash]);
                        continue;
                    }
                    if (!isset($products[$chain_product['product_id']])) {
                        if (isset($auth['area']) && $auth['area'] == 'C') {
                            $is_valid = false;
                            break;
                        }
                        unset($chains[$key]['products'][$hash]);
                        unset($chains[$key]['products_info'][$hash]);
                        continue;
                    }
                    $product = $products[$chain_product['product_id']];
                    if (AREA == 'C' && ($product['status'] == 'H' || isset($product['tracking']) && $product['tracking'] != ProductTracking::DO_NOT_TRACK && Registry::get('settings.General.show_out_of_stock_products') == 'N' && empty($product['amount']))) {
                        $is_valid = false;
                        break;
                    }
                    if (!empty($chain_product['product_options'])) {
                        $product['selected_options'] = $chain_product['product_options'];
                    } else {
                        $product['selected_options'] = isset($selected_options[$product['product_id']]['selected_options']) ? $selected_options[$product['product_id']]['selected_options'] : '';
                        $product['changed_option'] = isset($selected_options[$product['product_id']]['changed_option']) ? $selected_options[$product['product_id']]['changed_option'] : '';
                    }
                    fn_gather_additional_products_data($product, array('get_icon' => true, 'get_detailed' => true, 'get_additional' => false, 'get_options' => true, 'get_discounts' => true));
                    $product['min_qty'] = $product['min_qty'] > 0 ? $product['min_qty'] : 1;
                    $chain_product['product_name'] = $product['product'];
                    $chain_product['min_qty'] = $product['min_qty'];
                    $chain_product['price'] = empty($chain_product['price']) ? $product['price'] : $chain_product['price'];
                    $chain_product['list_price'] = $product['list_price'];
                    if (isset($product['main_pair'])) {
                        $chain_product['main_pair'] = $product['main_pair'];
                    }
                    list($chain_product['discount'], $chain_product['discounted_price']) = fn_buy_together_calculate_discount($product['price'], empty($chain_product['modifier']) ? 0 : $chain_product['modifier'], empty($chain_product['modifier_type']) ? 'to_fixed' : $chain_product['modifier_type']);
                    $chain_product['options_type'] = $product['options_type'];
                    $chain_product['exceptions_type'] = $product['exceptions_type'];
                    $chain_product['options_update'] = isset($product['options_update']) ? $product['options_update'] : false;
                    $total_price += $product['price'] * $chain_product['amount'];
                    $chain_price += $chain_product['discounted_price'] * $chain_product['amount'];
                    if (!empty($chain_product['product_options'])) {
                        $chain_product['product_options_short'] = $chain_product['product_options'];
                        $options = fn_get_selected_product_options_info($chain_product['product_options'], DESCR_SL);
                        $chain_product['product_options'] = $options;
                    } elseif (!empty($product['product_options'])) {
                        $chain_product['aoc'] = true;
                        // Allow any option combinations
                        $chain_product['options'] = $product['product_options'];
                    }
                    $chains[$key]['products_info'][$hash]['price'] = $chain_product['price'];
                    $chains[$key]['products_info'][$hash]['discount'] = $chain_product['discount'];
                    $chains[$key]['products_info'][$hash]['discounted_price'] = $chain_product['discounted_price'];
                }
                if (!$is_valid) {
                    unset($chains[$key]);
                    continue;
                }
                $chain['total_price'] = $total_price;
                $chain['chain_price'] = $chain_price;
                unset($chain_product);
            }
            if (!empty($params['simple'])) {
                $simple_chain = $chain;
                break;
            }
        }
        unset($chain);
    }
    if (isset($simple_chain)) {
        $chains = $simple_chain;
    }
    /**
     * Gets function result along with parameters and query information.
     *
     * @param array $params Parameters for the function
     * @param array $auth Array of user authentication data
     * @param string $lang_code 2-letter language code (e.g. 'en', 'ru', etc.)
     * @param mixed $chains One chain or array of chains, depending on 'simple' parameter.
     * @param array $fields Array of fields to be selected
     * @param array $conditions Array of complete condition expressions to be applied to the end of an SQL-query
     * @param array $joins List of strings with the complete JOIN information (JOIN type, tables and fields) for an SQL-query
     */
    fn_set_hook('buy_together_get_chains_post', $params, $auth, $lang_code, $chains, $fields, $conditions, $joins);
    return $chains;
}