$amount = isset($item['amount']) ? $item['amount'] : 1; $product_data = fn_get_product_data($item['product_id'], $auth, CART_LANGUAGE, '', false, false, false, false, false, false, false); if ($product_data['options_type'] == 'S' && isset($item['product_options']) && isset($_REQUEST['changed_option'][$cart_id])) { $item['product_options'] = fn_fill_sequential_options($item, $_REQUEST['changed_option'][$cart_id]); unset($_REQUEST['changed_option']); } $product_options = isset($item['product_options']) ? $item['product_options'] : array(); $amount = fn_check_amount_in_stock($item['product_id'], $amount, $product_options, $cart_id, $_cart['products'][$cart_id]['is_edp'], 0, $_cart); if ($amount === false) { unset($_cart['products'][$cart_id]); continue; } $_cart['products'][$cart_id]['amount'] = $amount; $_cart['products'][$cart_id]['selected_options'] = isset($item['product_options']) ? $item['product_options'] : array(); $_cart['products'][$cart_id]['product_options'] = fn_get_selected_product_options($item['product_id'], $_cart['products'][$cart_id]['selected_options']); $_cart['products'][$cart_id] = fn_apply_options_rules($_cart['products'][$cart_id]); $_cart['products'][$cart_id]['product_options'] = $_cart['products'][$cart_id]['selected_options']; if (!empty($_cart['products'][$cart_id]['extra']['saved_options_key'])) { $_cart['saved_product_options'][$_cart['products'][$cart_id]['extra']['saved_options_key']] = $_cart['products'][$cart_id]['product_options']; } if (!empty($item['object_id'])) { $_cart['products'][$cart_id]['object_id'] = $item['object_id']; if (!empty($_cart['products'][$cart_id]['extra']['saved_options_key'])) { // Product from promotion. Save object_id for this product $_cart['saved_object_ids'][$_cart['products'][$cart_id]['extra']['saved_options_key']] = $item['object_id']; } } } } fn_set_hook('calculate_options', $cart_products, $_cart, $auth); $exclude_products = array();
function fn_look_through_variants_prices($product_id, $options, $variants) { $product = fn_get_product_data($product_id, $_SESSION['auth'], CART_LANGUAGE, '', true, true, true, true, $auth['area'] == 'A' && !empty($_REQUEST['action']) && $_REQUEST['action'] == 'preview'); $product['product_options'] = fn_get_product_options(array($product_id), CART_LANGUAGE); $product = fn_apply_options_rules($product); //var_dump($product['product_options']); $position = 0; $hashes = array(); $combinations = fn_get_options_combinations($options, $variants); //var_dump($combinations); foreach ($combinations as $key => $combination) { $flagToUnsetArrayElement = 0; $productArrayOtionsVariants = fn_get_options_variants_by_option_variant_id($product_id, $combination); foreach ($combination as $optionId => $variantId) { if ($productArrayOtionsVariants[$optionId] && !in_array($variantId, $productArrayOtionsVariants[$optionId])) { $flagToUnsetArrayElement = 1; } } if ($flagToUnsetArrayElement == 1) { unset($combinations[$key]); } } //var_dump($combinations); if (!empty($combinations)) { foreach ($combinations as $combination) { $_data = array(); $_data['product_id'] = $product_id; $_data['combination_hash'] = fn_generate_cart_id($product_id, array('product_options' => $combination)); if (array_search($_data['combination_hash'], $hashes) === false) { $hashes[] = $_data['combination_hash']; $_data['combination'] = fn_get_options_combination($combination); $product['product_options'] = fn_get_selected_product_options($product['product_id'], $combination, CART_LANGUAGE); $product = fn_apply_options_rules($product); $_data['price'] = fn_calculate_price_of_a_product($product, $combination); $old_data = db_get_row("SELECT combination_hash, price " . "FROM ?:product_options_inventory_prices " . "WHERE product_id = ?i AND combination_hash = ?i AND temp = 1", $product_id, $_data['combination_hash']); /** * Changes data before update combination * * @param array $combination Array of combination data * @param array $data Combination data to update * @param int $product_id Product identifier * @param int $amount Default combination amount * @param array $options Array of options identifiers * @param array $variants Array of option variants identifiers arrays in order corresponding to $options parameter */ db_query("REPLACE INTO ?:product_options_inventory_prices ?e", $_data); $combinations[] = $combination; } echo str_repeat('. ', count($combination)); } } }
$countedElements = count($combinationArrayItems); for ($i = 0; $i < $countedElements; $i++) { if ($i % 2 == 0) { $combination[$combinationArrayItems[$i]] = $combinationArrayItems[$i + 1]; } } //var_dump($optionCombinationStart['combination']);echo" ----- ";var_dump(array("product_id"=>$optionCombinationStart['product_id'],"combination_hash"=>$optionCombinationStart['combination_hash'],"combination"=>$combination));echo"<br/>"; $optionCombinationsFinal[] = array("product_id" => $optionCombinationStart['product_id'], "combination_hash" => $optionCombinationStart['combination_hash'], "combination" => $combination, "old_price" => $optionCombinationStart['price']); } } foreach ($optionCombinationsFinal as $optionCombinationFinal) { $product = fn_get_product_data($optionCombinationFinal['product_id'], $_SESSION['auth'], CART_LANGUAGE, '', true, true, true, true, $auth['area'] == 'A' && !empty($_REQUEST['action']) && $_REQUEST['action'] == 'preview'); $product['product_options'] = fn_get_product_options(array($optionCombinationFinal['product_id']), CART_LANGUAGE); $product = fn_apply_options_rules($product); $product['product_options'] = fn_get_selected_product_options($product['product_id'], $combination, CART_LANGUAGE); $product = fn_apply_options_rules($product); //var_dump($optionCombinationFinal['product_id']);echo" ==> ";var_dump($optionCombinationFinal['combination_hash']);echo" ==> ";var_dump($optionCombinationFinal['old_price']);echo" => ";var_dump(fn_calculate_price_of_a_product($product, $optionCombinationFinal['combination']));echo"<br/>"; $newPrice = fn_calculate_price_of_a_product($product, $optionCombinationFinal['combination']); db_query("UPDATE ?:product_options_inventory_prices SET ?u WHERE product_id = ?i AND combination_hash=?s", array('price' => $newPrice), $optionCombinationFinal['product_id'], $optionCombinationFinal['combination_hash']); } } exit; } if ($mode == 'option_variant_link_product_save') { // delete the link allready in db_query('DELETE FROM ?:product_option_variants_link WHERE `option_variant_id`=?i AND `product_id` = ?i', $_REQUEST['option_variant_id'], intval($_REQUEST['product_id'])); //insert the new link $_data = array('option_variant_id' => $_REQUEST['option_variant_id'], 'product_id' => $_REQUEST['product_id'], 'product_nr' => $_REQUEST['product_nr']); echo $inserted_id = db_query("INSERT INTO ?:product_option_variants_link ?e", $_data); exit; }
/** * Gets additional products data * * @param array $products Array with products * @param array $params Array of flags which determines which data should be gathered * @return array Array of products with additional information */ function fn_gather_additional_products_data(&$products, $params) { /** * Change parameters for gathering additional products data * * @param array $products List of products * @param array $params Parameters for gathering data */ fn_set_hook('gather_additional_products_data_pre', $products, $params); if (empty($products)) { return; } // Set default values to input params $default_params = array('get_icon' => false, 'get_detailed' => false, 'get_additional' => false, 'get_options' => true, 'get_discounts' => true, 'get_features' => false, 'get_extra' => false, 'get_taxed_prices' => true, 'get_for_one_product' => !is_array(reset($products)) ? true : false, 'detailed_params' => true, 'features_display_on' => 'C'); $params = array_merge($default_params, $params); $auth =& $_SESSION['auth']; $allow_negative_amount = Registry::get('settings.General.allow_negative_amount'); $inventory_tracking = Registry::get('settings.General.inventory_tracking'); if ($params['get_for_one_product']) { $products = array($products); } $product_ids = array(); foreach ($products as $v) { $product_ids[] = $v['product_id']; } if ($params['get_icon'] || $params['get_detailed']) { $products_images = fn_get_image_pairs($product_ids, 'product', 'M', $params['get_icon'], $params['get_detailed'], CART_LANGUAGE); } if ($params['get_additional']) { $additional_images = fn_get_image_pairs($product_ids, 'product', 'A', true, true, CART_LANGUAGE); } if ($params['get_options']) { $product_options = fn_get_product_options($product_ids, CART_LANGUAGE); } else { $has_product_options = db_get_hash_array("SELECT a.option_id, a.product_id FROM ?:product_options AS a WHERE a.product_id IN (?n) AND a.status = 'A'", 'product_id', $product_ids); $has_product_options_links = db_get_hash_array("SELECT c.option_id, c.product_id FROM ?:product_global_option_links AS c LEFT JOIN ?:product_options AS a ON a.option_id = c.option_id WHERE a.status = 'A' AND c.product_id IN (?n)", 'product_id', $product_ids); } /** * Changes before gathering additional products data * * @param array $product_ids Array of product identifiers * @param array $params Parameteres for gathering data * @param array $products Array of products * @param mixed $auth Array of user authentication data * @param array $products_images Array with product main images * @param array $additional_images Array with product additional images * @param array $product_options Array with product options * @param array $has_product_options Array of flags determines if product has options * @param array $has_product_options_links Array of flags determines if product has option links */ fn_set_hook('gather_additional_products_data_params', $product_ids, $params, $products, $auth, $products_images, $additional_images, $product_options, $has_product_options, $has_product_options_links); // foreach $products foreach ($products as &$_product) { $product = $_product; $product_id = $product['product_id']; // Get images if ($params['get_icon'] == true || $params['get_detailed'] == true) { if (empty($product['main_pair']) && !empty($products_images[$product_id])) { $product['main_pair'] = reset($products_images[$product_id]); } } if ($params['get_additional'] == true) { if (empty($product['image_pairs']) && !empty($additional_images[$product_id])) { $product['image_pairs'] = $additional_images[$product_id]; } } if (!isset($product['base_price'])) { $product['base_price'] = $product['price']; // save base price (without discounts, etc...) } /** * Changes before gathering product options * * @param array $product Product data * @param mixed $auth Array of user authentication data * @param array $params Parameteres for gathering data */ fn_set_hook('gather_additional_product_data_before_options', $product, $auth, $params); // Convert product categories if (!empty($product['category_ids']) && !is_array($product['category_ids'])) { list($product['category_ids'], $product['main_category']) = fn_convert_categories($product['category_ids']); } $product['selected_options'] = empty($product['selected_options']) ? array() : $product['selected_options']; // Get product options if ($params['get_options'] && !empty($product_options[$product['product_id']])) { if (!isset($product['options_type']) || !isset($product['exceptions_type'])) { $types = db_get_row('SELECT options_type, exceptions_type FROM ?:products WHERE product_id = ?i', $product['product_id']); $product['options_type'] = $types['options_type']; $product['exceptions_type'] = $types['exceptions_type']; } if (empty($product['product_options'])) { if (!empty($product['combination'])) { $selected_options = fn_get_product_options_by_combination($product['combination']); } $product['product_options'] = !empty($selected_options) ? fn_get_selected_product_options($product['product_id'], $selected_options, CART_LANGUAGE) : $product_options[$product_id]; } $product = fn_apply_options_rules($product); if (!empty($params['get_icon']) || !empty($params['get_detailed'])) { // Get product options images if (!empty($product['combination_hash']) && !empty($product['product_options'])) { $image = fn_get_image_pairs($product['combination_hash'], 'product_option', 'M', $params['get_icon'], $params['get_detailed'], CART_LANGUAGE); if (!empty($image)) { $product['main_pair'] = $image; } } } $product['has_options'] = !empty($product['product_options']); if (!fn_allowed_for('ULTIMATE:FREE')) { $product = fn_apply_exceptions_rules($product); } //var_dump($product['product_options']);die(); //var_dump($selected_options); // Change price $selected_options = isset($product['selected_options']) ? $product['selected_options'] : array(); foreach ($product['product_options'] as $option) { if (!empty($option['disabled'])) { unset($selected_options[$option['option_id']]); } } $product['selected_options'] = $selected_options; if (empty($product['modifiers_price'])) { $product['base_modifier'] = fn_apply_options_modifiers($selected_options, $product['base_price'], 'P', array(), array('product_data' => $product)); $old_price = $product['price']; $product['price'] = fn_apply_options_modifiers($selected_options, $product['price'], 'P', array(), array('product_data' => $product)); if (empty($product['original_price'])) { $product['original_price'] = $old_price; } $product['original_price'] = fn_apply_options_modifiers($selected_options, $product['original_price'], 'P', array(), array('product_data' => $product)); $product['modifiers_price'] = $product['price'] - $old_price; } if (!empty($product['list_price'])) { $product['list_price'] = fn_apply_options_modifiers($selected_options, $product['list_price'], 'P', array(), array('product_data' => $product)); } if (!empty($product['prices']) && is_array($product['prices'])) { foreach ($product['prices'] as $pr_k => $pr_v) { $product['prices'][$pr_k]['price'] = fn_apply_options_modifiers($selected_options, $pr_v['price'], 'P', array(), array('product_data' => $product)); } } } else { $product['has_options'] = !empty($has_product_options[$product_id]) || !empty($has_product_options_links[$product_id]) ? true : false; $product['product_options'] = empty($product['product_options']) ? array() : $product['product_options']; } unset($selected_options); /** * Changes before gathering product discounts * * @param array $product Product data * @param mixed $auth Array of user authentication data * @param array $params Parameteres for gathering data */ fn_set_hook('gather_additional_product_data_before_discounts', $product, $auth, $params); // Get product discounts if ($params['get_discounts'] && !isset($product['exclude_from_calculate'])) { fn_promotion_apply('catalog', $product, $auth); if (!empty($product['prices']) && is_array($product['prices'])) { $product_copy = $product; foreach ($product['prices'] as $pr_k => $pr_v) { $product_copy['base_price'] = $product_copy['price'] = $pr_v['price']; fn_promotion_apply('catalog', $product_copy, $auth); $product['prices'][$pr_k]['price'] = $product_copy['price']; } } if (empty($product['discount']) && !empty($product['list_price']) && !empty($product['price']) && floatval($product['price']) && $product['list_price'] > $product['price']) { $product['list_discount'] = fn_format_price($product['list_price'] - $product['price']); $product['list_discount_prc'] = sprintf('%d', round($product['list_discount'] * 100 / $product['list_price'])); } } // FIXME: old product options scheme $product['discounts'] = array('A' => 0, 'P' => 0); if (!empty($product['promotions'])) { foreach ($product['promotions'] as $v) { foreach ($v['bonuses'] as $a) { if ($a['discount_bonus'] == 'to_fixed') { $product['discounts']['A'] += $a['discount']; } elseif ($a['discount_bonus'] == 'by_fixed') { $product['discounts']['A'] += $a['discount_value']; } elseif ($a['discount_bonus'] == 'to_percentage') { $product['discounts']['P'] += 100 - $a['discount_value']; } elseif ($a['discount_bonus'] == 'by_percentage') { $product['discounts']['P'] += $a['discount_value']; } } } } // Add product prices with taxes and without taxes if ($params['get_taxed_prices'] && AREA != 'A' && Registry::get('settings.Appearance.show_prices_taxed_clean') == 'Y' && $auth['tax_exempt'] != 'Y') { fn_get_taxed_and_clean_prices($product, $auth); } if ($params['get_features'] && !isset($product['product_features'])) { $product['product_features'] = fn_get_product_features_list($product, $params['features_display_on']); } if ($params['get_extra'] && !empty($product['is_edp']) && $product['is_edp'] == 'Y') { $product['agreement'] = array(fn_get_edp_agreements($product['product_id'])); } $product['qty_content'] = fn_get_product_qty_content($product, $allow_negative_amount, $inventory_tracking); if ($params['detailed_params']) { $product['detailed_params'] = empty($product['detailed_params']) ? $params : array_merge($product['detailed_params'], $params); } /** * Add additional data to product * * @param array $product Product data * @param mixed $auth Array of user authentication data * @param array $params Parameteres for gathering data */ fn_set_hook('gather_additional_product_data_post', $product, $auth, $params); $_product = $product; } // \foreach $products /** * Add additional data to products after gathering additional products data * * @param array $product_ids Array of product identifiers * @param array $params Parameteres for gathering data * @param array $products Array of products * @param mixed $auth Array of user authentication data */ fn_set_hook('gather_additional_products_data_post', $product_ids, $params, $products, $auth); if ($params['get_for_one_product'] == true) { $products = array_shift($products); } }
function fn_gather_additional_product_data(&$product, $get_icon = false, $get_detailed = false, $get_options = true, $get_discounts = true, $get_features = false) { $auth =& $_SESSION['auth']; if ($get_icon == true || $get_detailed == true) { if (empty($product['main_pair'])) { $product['main_pair'] = fn_get_image_pairs($product['product_id'], 'product', 'M', $get_icon, $get_detailed, CART_LANGUAGE); if (Registry::get('settings.General.enable_thumbnail_new_stamp') == "Y") { $threshold = strtotime("-" . Registry::get('settings.General.new_stamp_time_threshold') . " days"); } else { $threshold = time(); } if (strtotime($product['timestamp']) > $threshold && $product['main_pair']['new'] == 0) { //new product - update thumbnails and check "new" flag $product['main_pair']['force'] = 'new'; db_query('UPDATE ?:images_links SET new=1 WHERE pair_id=?i', $product['main_pair']['pair_id']); } elseif (strtotime($product['timestamp']) < $threshold && $product['main_pair']['new'] == 1) { //old product - update thumbnails and uncheck "new" flag $product['main_pair']['force'] = 'old'; db_query('UPDATE ?:images_links SET new=0 WHERE pair_id=?i', $product['main_pair']['pair_id']); } } } if (!isset($product['base_price'])) { $product['base_price'] = $product['price']; // save base price (without discounts, etc...) } // Convert product categories if (!empty($product['category_ids']) && !is_array($product['category_ids'])) { $product['category_ids'] = fn_convert_categories($product['category_ids']); } $product['selected_options'] = empty($product['selected_options']) ? array() : $product['selected_options']; // Get product options if ($get_options == true) { if (!isset($product['options_type']) || !isset($product['exceptions_type'])) { $types = db_get_row('SELECT options_type, exceptions_type FROM ?:products WHERE product_id = ?i', $product['product_id']); $product['options_type'] = $types['options_type']; $product['exceptions_type'] = $types['exceptions_type']; } if (empty($product['product_options'])) { if (!empty($product['combination'])) { $selected_options = fn_get_product_options_by_combination($product['combination']); } $product['product_options'] = !empty($selected_options) ? fn_get_selected_product_options($product['product_id'], $selected_options, CART_LANGUAGE) : fn_get_product_options($product['product_id'], CART_LANGUAGE); } $product = fn_apply_options_rules($product); if ($get_icon == true || $get_detailed == true) { // Get product options images if (!empty($product['combination_hash'])) { $image = fn_get_image_pairs($product['combination_hash'], 'product_option', 'M', $get_icon, $get_detailed, CART_LANGUAGE); if (!empty($image)) { $product['main_pair'] = $image; } } } $product['has_options'] = !empty($product['product_options']); $product = fn_apply_exceptions_rules($product); } else { $product['has_options'] = db_get_field("SELECT COUNT(*) FROM ?:product_options as a LEFT JOIN ?:product_global_option_links as c ON c.option_id = a.option_id WHERE (a.product_id = ?i OR c.product_id = ?i) AND a.status = 'A'", $product['product_id'], $product['product_id']); } fn_set_hook('get_additional_product_data_before_discounts', $product, $auth, $get_options); // Get product discounts if ($get_discounts == true && !isset($product['exclude_from_calculate'])) { fn_promotion_apply('catalog', $product, $auth); if (!empty($product['prices']) && is_array($product['prices'])) { $product_copy = $product; foreach ($product['prices'] as $pr_k => $pr_v) { $product_copy['base_price'] = $product_copy['price'] = $pr_v['price']; fn_promotion_apply('catalog', $product_copy, $auth); $product['prices'][$pr_k]['price'] = $product_copy['price']; } } if (empty($product['discount']) && !empty($product['list_price']) && !empty($product['price']) && floatval($product['price']) && $product['list_price'] > $product['price']) { $product['list_discount'] = fn_format_price($product['list_price'] - $product['price']); $product['list_discount_prc'] = sprintf('%d', round($product['list_discount'] * 100 / $product['list_price'])); } } // FIXME: old product options scheme $product['discounts'] = array('A' => 0, 'P' => 0); if (!empty($product['promotions'])) { foreach ($product['promotions'] as $v) { foreach ($v['bonuses'] as $a) { if ($a['discount_bonus'] == 'to_fixed') { $product['discounts']['A'] += $a['discount']; } elseif ($a['discount_bonus'] == 'by_fixed') { $product['discounts']['A'] += $a['discount_value']; } elseif ($a['discount_bonus'] == 'to_percentage') { $product['discounts']['P'] += 100 - $a['discount_value']; } elseif ($a['discount_bonus'] == 'by_percentage') { $product['discounts']['P'] += $a['discount_value']; } } } } // Add product prices with taxes and without taxes if (!empty($product) && AREA != 'A' && Registry::get('settings.Appearance.show_prices_taxed_clean') == 'Y' && $auth['tax_exempt'] != 'Y') { fn_get_taxed_and_clean_prices($product, $auth); } if (!isset($product['product_features']) && $get_features == true) { $product['product_features'] = fn_get_product_features_list($product['product_id']); } if (!empty($product['is_edp']) && $product['is_edp'] == 'Y') { $product['agreement'] = array(fn_get_edp_agreements($product['product_id'])); } $qty_content = array(); if (!empty($product['qty_step'])) { $per_item = 0; if (Registry::get('settings.General.allow_negative_amount') == 'Y' && !empty($product['max_qty'])) { $amount = $product['max_qty']; } else { $amount = isset($product['in_stock']) ? $product['in_stock'] : (isset($product['inventory_amount']) ? $product['inventory_amount'] : $product['amount']); } for ($i = 1; $per_item <= $amount - $product['qty_step']; $i++) { $per_item = $product['qty_step'] * $i; if (!empty($product['list_qty_count']) && $i > $product['list_qty_count']) { break; } if (!empty($product['max_qty']) && $per_item > $product['max_qty'] || !empty($product['min_qty']) && $per_item < $product['min_qty']) { continue; } $qty_content[$i] = $per_item; } } $product['qty_content'] = $qty_content; $product['detailed_params'] = empty($product['detailed_params']) ? array() : $product['detailed_params']; $product['detailed_params'] = array_merge($product['detailed_params'], array('get_icon' => $get_icon, 'get_detailed' => $get_detailed, 'get_options' => $get_options, 'get_discounts' => $get_discounts, 'get_features' => $get_features)); fn_set_hook('get_additional_product_data', $product, $auth, $get_options); }