function ls_get_fav_data() { //wishlist products footer carousel $_SESSION['wishlist'] = isset($_SESSION['wishlist']) ? $_SESSION['wishlist'] : array(); $wishlist =& $_SESSION['wishlist']; $_SESSION['continue_url'] = fn_ls_get_base_url(); $auth =& $_SESSION['auth']; //view products $products_footer = !empty($wishlist['products']) ? $wishlist['products'] : array(); $extra_products = array(); $wishlist_is_empty = fn_cart_is_empty($wishlist); if (!empty($products_footer)) { foreach ($products_footer as $k => $v) { $_options = array(); $extra = $v['extra']; if (!empty($v['product_options'])) { $_options = $v['product_options']; } $products_footer[$k] = fn_get_product_data($v['product_id'], $auth, CART_LANGUAGE, '', true, true, true, false, false, true, false, true); if (empty($products_footer[$k])) { unset($products_footer[$k], $wishlist['products'][$k]); continue; } $products_footer[$k]['extra'] = empty($products_footer[$k]['extra']) ? array() : $products_footer[$k]['extra']; $products_footer[$k]['extra'] = array_merge($products_footer[$k]['extra'], $extra); if (isset($products_footer[$k]['extra']['product_options']) || $_options) { $products_footer[$k]['selected_options'] = empty($products_footer[$k]['extra']['product_options']) ? $_options : $products_footer[$k]['extra']['product_options']; } if (!empty($products_footer[$k]['selected_options'])) { $options = fn_get_selected_product_options($v['product_id'], $v['product_options'], CART_LANGUAGE); foreach ($products_footer[$k]['selected_options'] as $option_id => $variant_id) { foreach ($options as $option) { if ($option['option_id'] == $option_id && !in_array($option['option_type'], array('I', 'T', 'F')) && empty($variant_id)) { $products_footer[$k]['changed_option'] = $option_id; break 2; } } } } $products_footer[$k]['display_subtotal'] = $products_footer[$k]['price'] * $v['amount']; $products_footer[$k]['display_amount'] = $v['amount']; $products_footer[$k]['cart_id'] = $k; if (!empty($products_footer[$k]['extra']['parent'])) { $extra_products[$k] = $products_footer[$k]; unset($products_footer[$k]); continue; } } } fn_gather_additional_products_data($products_footer, array('get_icon' => true, 'get_detailed' => true, 'get_options' => true, 'get_discounts' => true)); return $products_footer; }
function fn_exim_get_product_combination($product_id, $combination, $set_delimiter, $lang_code = CART_LANGUAGE) { $selected_options = fn_get_product_options_by_combination($combination); $options = fn_get_selected_product_options($product_id, $selected_options, $lang_code); $return = array(); if (!empty($options)) { foreach ($options as $option) { if (isset($selected_options[$option['option_id']])) { $return[] = $option['option_name'] . ': ' . $option['variants'][$selected_options[$option['option_id']]]['variant_name']; } } } return implode($set_delimiter, $return); }
$extra = $v['extra']; if (!empty($v['product_options'])) { $_options = $v['product_options']; } $products_footer[$k] = fn_get_product_data($v['product_id'], $auth, CART_LANGUAGE, '', true, true, true, false, false, true, false, true); if (empty($products_footer[$k])) { unset($products_footer[$k], $wishlist['products'][$k]); continue; } $products_footer[$k]['extra'] = empty($products_footer[$k]['extra']) ? array() : $products_footer[$k]['extra']; $products_footer[$k]['extra'] = array_merge($products_footer[$k]['extra'], $extra); if (isset($products_footer[$k]['extra']['product_options']) || $_options) { $products_footer[$k]['selected_options'] = empty($products_footer[$k]['extra']['product_options']) ? $_options : $products_footer[$k]['extra']['product_options']; } if (!empty($products_footer[$k]['selected_options'])) { $options = fn_get_selected_product_options($v['product_id'], $v['product_options'], CART_LANGUAGE); foreach ($products_footer[$k]['selected_options'] as $option_id => $variant_id) { foreach ($options as $option) { if ($option['option_id'] == $option_id && !in_array($option['option_type'], array('I', 'T', 'F')) && empty($variant_id)) { $products_footer[$k]['changed_option'] = $option_id; break 2; } } } } $products_footer[$k]['display_subtotal'] = $products_footer[$k]['price'] * $v['amount']; $products_footer[$k]['display_amount'] = $v['amount']; $products_footer[$k]['cart_id'] = $k; /* $products_footer[$k]['product_options'] = fn_get_selected_product_options($v['product_id'], $v['product_options'], CART_LANGUAGE); $products_footer[$k]['price'] = fn_apply_options_modifiers($v['product_options'], $products_footer[$k]['price'], 'P'); */ if (!empty($products_footer[$k]['extra']['parent'])) {
function fn_twg_get_api_product_data($product_id, $lang_code = CART_LANGUAGE) { $auth =& $_SESSION['auth']; $get_features = $get_discounts = $get_options = AREA == 'C'; $product = fn_get_product_data($product_id, $auth, $lang_code, '', true, true, true, $get_discounts, false, $get_features, null, true); if (empty($product)) { return array(); } $product['main_product_code'] = $product['product_code']; fn_gather_additional_product_data($product, true, true, $get_options, $get_discounts); // Delete empty product feature groups if ($get_features && !empty($product['product_features'])) { foreach ($product['product_features'] as $feature_id => $feature) { if ($feature['feature_type'] == 'G' and empty($feature['subfeatures'])) { unset($product['product_features'][$feature_id]); } } } $product['product_options'] = array(); $product_options = fn_twg_api_get_product_options($product); 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, $lang_code) : $product_options[$product_id]; } $product['product_options'] = $product_options; foreach ($product['product_options'] as $key1 => $val1) { $option_descriptions = db_get_row("SELECT option_name, option_text, description, comment\n FROM ?:product_options_descriptions\n WHERE option_id = ?i AND lang_code = ?s", $val1['option_id'], $lang_code); foreach ($option_descriptions as $key2 => $val2) { $product['product_options'][$key1][$key2] = $val2; } $val1['variants'] = isset($val1['variants']) ? $val1['variants'] : array(); foreach (array_keys($val1['variants']) as $vid) { if ($val1['option_type'] == 'C') { $product['product_options'][$key1]['variants'][$vid]['variant_name'] = empty($val1['position']) ? __('no', $lang_code) : __('yes', $lang_code); } elseif ($val1['option_type'] == 'S' || $val1['option_type'] == 'R') { $variant_description = db_get_field("SELECT variant_name\n FROM ?:product_option_variants_descriptions\n WHERE variant_id = ?i AND lang_code = ?s", $vid, $lang_code); $product['product_options'][$key1]['variants'][$vid]['variant_name'] = $variant_description; } } } $product['category_id'] = $product['main_category']; $product['images'] = array(); $images_config = TwigmoSettings::get('images'); $image_params = $images_config['big']; if (!empty($product['main_pair'])) { $product['icon'] = TwigmoImage::getApiImageData($product['main_pair'], 'product', 'icon', $images_config['prewiew']); $product['images'][] = TwigmoImage::getApiImageData($product['main_pair'], 'product', 'detailed', $image_params); } foreach ($product['image_pairs'] as $v) { $product['images'][] = TwigmoImage::getApiImageData($v, 'product', 'detailed', $image_params); } $product['category'] = db_get_field("SELECT category FROM ?:category_descriptions WHERE category_id = ?i AND lang_code = ?s", $product['main_category'], $lang_code); $product['product_options_exceptions'] = fn_twg_get_api_product_options_exceptions($product_id); $product['product_options_inventory'] = fn_twg_get_api_product_options_inventory($product_id, $lang_code); $_product = Api::getAsApiObject('products', $product); $_product['avail_since_formated'] = strftime(Registry::get('settings.Appearance.date_format'), $_product['avail_since']); $_product['TIME'] = TIME; if (AREA == 'C') { $_product['tabs'] = fn_twg_get_product_tabs(array('product_id' => $product_id, 'descr_sl' => DESCR_SL)); } $_product['default_image'] = fn_get_image_pairs($product_id, 'product', 'M', true, true); if (!empty($product['points_info'])) { $_product['points_info'] = $product['points_info']; } return $_product; }
protected function buildOfferCombination($product, $combination) { $this->offer['items']['param'] = $this->params; $skip = false; foreach ($combination['combination'] as $option_id => $variant_id) { if (!isset($product['product_options'][$option_id]['variants'][$variant_id])) { $skip = true; break; } } if ($this->options['export_stock'] == 'Y') { if ($product['tracking'] == 'O' && $combination['amount'] <= 0) { $this->log->write(Logs::SKIP_PRODUCT, $product, __('yml2_log_product_amount_combination_is_empty')); $skip = true; } } if ($skip) { return false; } if ($product['tracking'] == 'O' && $combination['amount'] <= 0) { $this->offer['attr']['available'] = 'false'; } $product['images'][] = $combination['image_pairs']; while ($image = array_shift($product['images'])) { $offer['items']['picture'][] = $this->getImageUrl($image); } $this->offer['items']['price'] = fn_apply_options_modifiers($combination['combination'], $this->offer['items']['price'], 'P'); $combination_hash = array(); foreach ($combination['combination'] as $option_id => $variant_id) { $combination_hash[] = $option_id; $combination_hash[] = $variant_id; } $this->offer['items']['url'] = $this->escapeUrl('products.view?product_id=' . $product['product_id'] . '&combination=' . implode('_', $combination_hash)); $options = fn_get_selected_product_options($product['product_id'], $combination['combination']); if (!empty($combination['product_code']) && isset($this->offer['items']['vendorCode']) && $this->offer['items']['vendorCode'] == $product['product_code']) { $this->offer['items']['vendorCode'] = $combination['product_code']; } foreach ($options as $option) { if (!empty($option['yml2_type_options'])) { $this->setOfferOptions($option); } } $this->offer['attr']['id'] = $this->generateNewId($options); sort($this->offer['items']['param']); return true; }
} elseif ($mode == 'view') { $product = $view->get_var('product'); $product['configuration_mode'] = true; if (!empty($product) && $product['product_type'] == 'C') { if (!empty($_REQUEST['cart_id'])) { $cart =& $_SESSION['cart']; if (isset($cart['products'][$_REQUEST['cart_id']]['extra'])) { $product['extra'] = $cart['products'][$_REQUEST['cart_id']]['extra']; } $view->assign('edit_configuration', $_REQUEST['cart_id']); $view->assign('cart_item', $cart['products'][$_REQUEST['cart_id']]); $selected_configuration = $cart['products'][$_REQUEST['cart_id']]['extra']['configuration']; // If product has options, select the appropriate // FIXME: duplicate selection, first was in gather_additional_product_data if (!empty($cart['products'][$_REQUEST['cart_id']]['product_options'])) { $product['product_options'] = fn_get_selected_product_options($product['product_id'], $cart['products'][$_REQUEST['cart_id']]['product_options'], CART_LANGUAGE); } } $product_configurator_steps = db_get_hash_array("SELECT ?:conf_steps.step_id, ?:conf_step_descriptions.step_name FROM ?:conf_steps LEFT JOIN ?:conf_step_descriptions ON ?:conf_steps.step_id = ?:conf_step_descriptions.step_id WHERE ?:conf_steps.status = 'A' AND ?:conf_step_descriptions.lang_code = ?s ORDER BY ?:conf_steps.position", 'step_id', CART_LANGUAGE); $current_step_id = 0; foreach ($product_configurator_steps as $step_id => $step_value) { $product_configurator_groups = db_get_array("SELECT ?:conf_groups.group_id, ?:conf_group_descriptions.configurator_group_name, ?:conf_group_descriptions.full_description, ?:conf_groups.configurator_group_type, ?:conf_product_groups.position, ?:conf_product_groups.default_product_ids, ?:conf_product_groups.required FROM ?:conf_groups LEFT JOIN ?:conf_group_descriptions ON ?:conf_group_descriptions.group_id = ?:conf_groups.group_id LEFT JOIN ?:conf_product_groups ON ?:conf_product_groups.group_id = ?:conf_groups.group_id WHERE ?:conf_groups.status = 'A' AND ?:conf_group_descriptions.lang_code = ?s AND ?:conf_product_groups.product_id = ?i AND ?:conf_groups.step_id = ?i ORDER BY ?:conf_product_groups.position", CART_LANGUAGE, $product['product_id'], $step_id); $price_usergroup = db_quote(" AND ?:product_prices.usergroup_id IN (?n)", array_merge(array(USERGROUP_ALL), $auth['usergroup_ids'])); if (!empty($product_configurator_groups)) { $c_price = 0; $where = $join = ''; if (Registry::get('settings.General.show_out_of_stock_products') == 'N') { $join = " LEFT JOIN ?:product_options_inventory as inventory ON inventory.product_id = ?:products.product_id"; $where = " AND IF(?:products.tracking = 'O', inventory.amount > 0, ?:products.amount > 0)"; } foreach ($product_configurator_groups as $k => $v) {
* and use this program. * * * **************************************************************************** * PLEASE READ THE FULL TEXT OF THE SOFTWARE LICENSE AGREEMENT IN THE * * "copyright.txt" FILE PROVIDED WITH THIS DISTRIBUTION PACKAGE. * ****************************************************************************/ // // $Id: products.pre.php 10229 2010-07-27 14:21:39Z 2tl $ // if (!defined('AREA')) { die('Access denied'); } if ($_SERVER['REQUEST_METHOD'] == 'POST') { if ($mode == 'options') { if (!empty($_REQUEST['event_products']) && !empty($_REQUEST['appearance']['events'])) { $event_data['products'] = db_get_hash_array("SELECT * FROM ?:giftreg_event_products LEFT JOIN ?:product_descriptions ON ?:product_descriptions.product_id = ?:giftreg_event_products.product_id AND ?:product_descriptions.lang_code = ?s WHERE event_id = ?i", 'item_id', CART_LANGUAGE, $_REQUEST['appearance']['event_id']); foreach ($event_data['products'] as $k => $v) { $event_data['products'][$k]['extra'] = $event_data['products'][$k]['selected_options'] = @$_REQUEST['event_products'][$k]['product_options']; $product_options = $event_data['products'][$k]['extra']; $event_data['products'][$k]['product_options'] = fn_get_selected_product_options($v['product_id'], $product_options, CART_LANGUAGE); $event_data['products'][$k]['original_price'] = $event_data['products'][$k]['price'] = fn_get_product_price($v['product_id'], 1, $auth); $event_data['products'][$k]['avail_amount'] = $v['amount'] - $v['ordered_amount']; fn_gather_additional_product_data($event_data['products'][$k], true, false, true, true); } $view->assign('event_id', $_REQUEST['appearance']['event_id']); $view->assign('event_data', $event_data); $view->display('addons/gift_registry/views/events/components/event_products.tpl'); exit; } } }
if (isset($_cart['products'][$cart_id])) { $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);
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)); } } }
/** * Gets displayable product data to show it in the cart * * @param string $hash Unique product HASH * @param array &$product Product data * @param bool $skip_promotion Skip promotion calculation * @param array &$cart Array of cart content and user information necessary for purchase * @param array &$auth Array with authorization data * @param array $promotion_amount Amount of product in promotion (like Free products, etc) * @return array Product data */ function fn_get_cart_product_data($hash, &$product, $skip_promotion, &$cart, &$auth, $promotion_amount = 0) { /** * Prepare params before getting product data from cart * * @param string $hash Unique product HASH * @param array &$product Product data * @param bool $skip_promotion Skip promotion calculation * @param array &$cart Array of cart content and user information necessary for purchase * @param array &$auth Array with authorization data * @param array $promotion_amount Amount of product in promotion (like Free products, etc) */ fn_set_hook('get_cart_product_data_pre', $hash, $product, $skip_promotion, $cart, $auth, $promotion_amount); if (!empty($product['product_id'])) { $fields = array('?:products.product_id', '?:products.company_id', "GROUP_CONCAT(IF(?:products_categories.link_type = 'M', CONCAT(?:products_categories.category_id, 'M'), ?:products_categories.category_id)) as category_ids", '?:products.product_code', '?:products.weight', '?:products.tracking', '?:product_descriptions.product', '?:product_descriptions.short_description', '?:products.is_edp', '?:products.edp_shipping', '?:products.shipping_freight', '?:products.free_shipping', '?:products.zero_price_action', '?:products.tax_ids', '?:products.qty_step', '?:products.list_qty_count', '?:products.max_qty', '?:products.min_qty', '?:products.amount as in_stock', '?:products.shipping_params', '?:companies.status as company_status', '?:companies.company as company_name'); $join = db_quote("LEFT JOIN ?:product_descriptions ON ?:product_descriptions.product_id = ?:products.product_id AND ?:product_descriptions.lang_code = ?s", CART_LANGUAGE); $_p_statuses = array('A', 'H'); $_c_statuses = array('A', 'H'); $avail_cond = ''; if (fn_allowed_for('ULTIMATE') && Registry::get('runtime.company_id')) { if (AREA == 'C') { $avail_cond .= fn_get_company_condition('?:categories.company_id'); } else { $avail_cond .= ' AND (' . fn_get_company_condition('?:categories.company_id', false) . ' OR ' . fn_get_company_condition('?:products.company_id', false) . ')'; } } $avail_cond .= AREA == 'C' ? " AND (" . fn_find_array_in_set($auth['usergroup_ids'], '?:categories.usergroup_ids', true) . ")" : ''; $avail_cond .= AREA == 'C' ? " AND (" . fn_find_array_in_set($auth['usergroup_ids'], '?:products.usergroup_ids', true) . ")" : ''; $avail_cond .= AREA == 'C' && !(isset($auth['area']) && $auth['area'] == 'A') ? db_quote(' AND ?:categories.status IN (?a) AND ?:products.status IN (?a)', $_c_statuses, $_p_statuses) : ''; $avail_cond .= AREA == 'C' ? fn_get_localizations_condition('?:products.localization') : ''; $join .= " INNER JOIN ?:products_categories ON ?:products_categories.product_id = ?:products.product_id INNER JOIN ?:categories ON ?:categories.category_id = ?:products_categories.category_id {$avail_cond}"; $join .= " LEFT JOIN ?:companies ON ?:companies.company_id = ?:products.company_id"; fn_set_hook('pre_get_cart_product_data', $hash, $product, $skip_promotion, $cart, $auth, $promotion_amount, $fields, $join); $_pdata = db_get_row("SELECT " . implode(', ', $fields) . " FROM ?:products ?p WHERE ?:products.product_id = ?i GROUP BY ?:products.product_id", $join, $product['product_id']); // delete product from cart if vendor was disabled. if (empty($_pdata) || !empty($_pdata['company_id']) && !defined('ORDER_MANAGEMENT') && $_pdata['company_status'] != 'A') { fn_delete_cart_product($cart, $hash); return false; } if (!empty($_pdata['category_ids'])) { list($_pdata['category_ids'], $_pdata['main_category']) = fn_convert_categories($_pdata['category_ids']); } else { $_pdata['category_ids'] = array(); } $_pdata['options_count'] = db_get_field("SELECT COUNT(*) FROM ?:product_options WHERE product_id = ?i AND status = 'A'", $product['product_id']); $amount = !empty($product['amount_total']) ? $product['amount_total'] : $product['amount']; $_pdata['price'] = fn_get_product_price($product['product_id'], $amount, $auth); $_pdata['base_price'] = isset($product['stored_price']) && $product['stored_price'] == 'Y' ? $product['price'] : $_pdata['price']; fn_set_hook('get_cart_product_data', $product['product_id'], $_pdata, $product, $auth, $cart, $hash); $product['stored_price'] = empty($product['stored_price']) ? 'N' : $product['stored_price']; $product['stored_discount'] = empty($product['stored_discount']) ? 'N' : $product['stored_discount']; $product['product_options'] = empty($product['product_options']) ? array() : $product['product_options']; if (empty($_pdata['product_id'])) { // FIXME - for deleted products for OM fn_delete_cart_product($cart, $hash); return array(); } if (!empty($_pdata['options_count']) && empty($product['product_options'])) { $cart['products'][$hash]['product_options'] = fn_get_default_product_options($product['product_id']); } if (Registry::get('settings.General.inventory_tracking') == 'Y' && !empty($_pdata['tracking']) && $_pdata['tracking'] == ProductTracking::TRACK_WITH_OPTIONS && !empty($product['selectable_cart_id'])) { $_pdata['in_stock'] = db_get_field("SELECT amount FROM ?:product_options_inventory WHERE combination_hash = ?i", $product['selectable_cart_id']); } $product['amount'] = fn_check_amount_in_stock($product['product_id'], $product['amount'], $product['product_options'], $hash, $_pdata['is_edp'], !empty($product['original_amount']) ? $product['original_amount'] : 0, $cart); if ($product['amount'] == 0) { fn_delete_cart_product($cart, $hash); $out_of_stock = true; return false; } if (!fn_allowed_for('ULTIMATE:FREE')) { $exceptions = fn_get_product_exceptions($product['product_id'], true); if (!isset($product['options_type']) || !isset($product['exceptions_type'])) { $product = array_merge($product, db_get_row('SELECT options_type, exceptions_type FROM ?:products WHERE product_id = ?i', $product['product_id'])); } if (!fn_is_allowed_options_exceptions($exceptions, $product['product_options'], $product['options_type'], $product['exceptions_type']) && !defined('GET_OPTIONS')) { fn_set_notification('E', __('notice'), __('product_options_forbidden_combination', array('[product]' => $_pdata['product']))); fn_delete_cart_product($cart, $hash); return false; } if (!fn_is_allowed_options($product)) { fn_set_notification('E', __('notice'), __('product_disabled_options', array('[product]' => $_pdata['product']))); fn_delete_cart_product($cart, $hash); return false; } } if (isset($product['extra']['custom_files'])) { $_pdata['extra']['custom_files'] = $product['extra']['custom_files']; } $_pdata['calculation'] = array(); if (isset($product['extra']['exclude_from_calculate'])) { $_pdata['exclude_from_calculate'] = $product['extra']['exclude_from_calculate']; $_pdata['aoc'] = !empty($product['extra']['aoc']); $_pdata['price'] = 0; } else { if ($product['stored_price'] == 'Y') { $_pdata['price'] = $product['price']; } } $product['price'] = $_pdata['zero_price_action'] == 'A' && isset($product['custom_user_price']) ? $product['custom_user_price'] : floatval($_pdata['price']); $cart['products'][$hash]['price'] = $product['price']; $_pdata['original_price'] = $product['price']; if ($product['stored_price'] != 'Y' && !isset($product['extra']['exclude_from_calculate'])) { $_tmp = $product['price']; $product['price'] = fn_apply_options_modifiers($product['product_options'], $product['price'], 'P', array(), array('product_data' => $product)); $product['modifiers_price'] = $_pdata['modifiers_price'] = $product['price'] - $_tmp; // modifiers } else { $product['modifiers_price'] = $_pdata['modifiers_price'] = 0; } if (isset($product['modifiers_price']) && $_pdata['zero_price_action'] == 'A') { $_pdata['base_price'] = $product['price'] - $product['modifiers_price']; } $_pdata['weight'] = fn_apply_options_modifiers($product['product_options'], $_pdata['weight'], 'W', array(), array('product_data' => $product)); $_pdata['amount'] = $product['amount']; $_pdata['price'] = $_pdata['original_price'] = fn_format_price($product['price']); $_pdata['stored_price'] = $product['stored_price']; if ($cart['options_style'] == 'F') { $_pdata['product_options'] = fn_get_selected_product_options($product['product_id'], $product['product_options'], CART_LANGUAGE); } elseif ($cart['options_style'] == 'I') { $_pdata['product_options'] = fn_get_selected_product_options_info($product['product_options'], CART_LANGUAGE); } else { $_pdata['product_options'] = $product['product_options']; } fn_set_hook('get_cart_product_data_post_options', $product['product_id'], $_pdata, $product); if (($_pdata['free_shipping'] != 'Y' || AREA == 'A') && ($_pdata['is_edp'] != 'Y' || $_pdata['is_edp'] == 'Y' && $_pdata['edp_shipping'] == 'Y')) { $cart['shipping_required'] = true; } $cart['products'][$hash]['is_edp'] = !empty($_pdata['is_edp']) && $_pdata['is_edp'] == 'Y' ? 'Y' : 'N'; $cart['products'][$hash]['edp_shipping'] = !empty($_pdata['edp_shipping']) && $_pdata['edp_shipping'] == 'Y' ? 'Y' : 'N'; if (empty($cart['products'][$hash]['extra']['parent'])) { // count only products without parent if ($skip_promotion == true && !empty($promotion_amount)) { $cart['amount'] += $promotion_amount; } else { $cart['amount'] += $product['amount']; } } if ($skip_promotion == false) { if (empty($cart['order_id']) || !empty($cart['recalculate_catalog_promotions'])) { fn_promotion_apply('catalog', $_pdata, $auth); } else { if (isset($product['discount'])) { $_pdata['discount'] = $product['discount']; $_pdata['price'] -= $product['discount']; if ($_pdata['price'] < 0) { $_pdata['discount'] += $_pdata['price']; $_pdata['price'] = 0; } } } // apply discount to the product if (!empty($_pdata['discount'])) { $cart['use_discount'] = true; } } if (!empty($product['object_id'])) { $_pdata['object_id'] = $product['object_id']; } $_pdata['shipping_params'] = empty($_pdata['shipping_params']) ? array() : unserialize($_pdata['shipping_params']); $_pdata['stored_discount'] = $product['stored_discount']; $cart['products'][$hash]['modifiers_price'] = $product['modifiers_price']; $_pdata['subtotal'] = $_pdata['price'] * $product['amount']; $cart['original_subtotal'] += $_pdata['original_price'] * $product['amount']; $cart['subtotal'] += $_pdata['subtotal']; /** * Prepare params before getting product data from cart * * @param string $hash Unique product HASH * @param array &$product Product data * @param bool $skip_promotion Skip promotion calculation * @param array &$cart Array of cart content and user information necessary for purchase * @param array &$auth Array with authorization data * @param array $promotion_amount Amount of product in promotion (like Free products, etc) * @param array $promotion_amount Product data */ fn_set_hook('get_cart_product_data_post', $hash, $product, $skip_promotion, $cart, $auth, $promotion_amount, $_pdata); return $_pdata; } return array(); }
function fn_get_cart_product_data($hash, &$product, $skip_promotion, &$cart, &$auth, $promotion_amount = 0) { if (!empty($product['product_id'])) { $_p_statuses = array('A', 'H'); $_c_statuses = array('A', 'H'); $avail_cond = AREA == 'C' ? " AND (" . fn_find_array_in_set($auth['usergroup_ids'], '?:categories.usergroup_ids', true) . ")" : ''; $avail_cond .= AREA == 'C' ? " AND (" . fn_find_array_in_set($auth['usergroup_ids'], '?:products.usergroup_ids', true) . ")" : ''; $avail_cond .= AREA == 'C' ? db_quote(' AND ?:categories.status IN (?a) AND ?:products.status IN (?a)', $_c_statuses, $_p_statuses) : ''; $avail_cond .= AREA == 'C' ? fn_get_localizations_condition('?:products.localization') : ''; $join = " INNER JOIN ?:products_categories ON ?:products_categories.product_id = ?:products.product_id INNER JOIN ?:categories ON ?:categories.category_id = ?:products_categories.category_id {$avail_cond}"; $_pdata = db_get_row("SELECT ?:products.product_id, ?:products.company_id, GROUP_CONCAT(IF(?:products_categories.link_type = 'M', CONCAT(?:products_categories.category_id, 'M'), ?:products_categories.category_id)) as category_ids, ?:products.product_code, ?:products.weight, ?:products.tracking, ?:product_descriptions.product, ?:product_descriptions.short_description, ?:products.is_edp, ?:products.edp_shipping, ?:products.shipping_freight, ?:products.free_shipping, ?:products.zero_price_action, ?:products.tax_ids, ?:products.qty_step, ?:products.list_qty_count, ?:products.max_qty, ?:products.min_qty, ?:products.amount as in_stock FROM ?:products LEFT JOIN ?:product_descriptions ON ?:product_descriptions.product_id = ?:products.product_id AND ?:product_descriptions.lang_code = ?s ?p WHERE ?:products.product_id = ?i GROUP BY ?:products.product_id", CART_LANGUAGE, $join, $product['product_id']); $companies =& Registry::get('s_companies'); // delete product from cart if supplier or vendor was disabled. if (empty($_pdata) || !empty($_pdata['company_id']) && ($companies[$_pdata['company_id']]['status'] != 'A' || (PRODUCT_TYPE == 'PROFESSIONAL' || PRODUCT_TYPE == 'COMMUNITY') && Registry::get('settings.Suppliers.enable_suppliers') != 'Y')) { return false; } $_pdata['category_ids'] = fn_convert_categories($_pdata['category_ids']); $_pdata['options_count'] = db_get_field("SELECT COUNT(*) FROM ?:product_options WHERE product_id = ?i AND status = 'A'", $product['product_id']); $_pdata['price'] = fn_get_product_price($product['product_id'], $product['amount'], $auth); $_pdata['base_price'] = isset($product['stored_price']) && $product['stored_price'] == 'Y' ? $product['price'] : $_pdata['price']; fn_set_hook('get_cart_product_data', $product['product_id'], $_pdata, $product); $product['stored_price'] = empty($product['stored_price']) ? 'N' : $product['stored_price']; $product['stored_discount'] = empty($product['stored_discount']) ? 'N' : $product['stored_discount']; $product['product_options'] = empty($product['product_options']) ? array() : $product['product_options']; if (empty($_pdata['product_id'])) { // FIXME - for deleted products for OM unset($cart['products'][$hash]); return array(); } if (!empty($_pdata['options_count']) && empty($product['product_options'])) { $cart['products'][$hash]['product_options'] = fn_get_default_product_options($product['product_id']); } if (Registry::get('settings.General.inventory_tracking') == 'Y' && !empty($_pdata['tracking']) && $_pdata['tracking'] == 'O' && !empty($product['selectable_cart_id'])) { $_pdata['in_stock'] = db_get_field("SELECT amount FROM ?:product_options_inventory WHERE combination_hash = ?i", $product['selectable_cart_id']); } if (fn_check_amount_in_stock($product['product_id'], $product['amount'], $product['product_options'], $hash, $_pdata['is_edp'], !empty($product['original_amount']) ? $product['original_amount'] : 0, $cart) == false) { unset($cart['products'][$hash]); $out_of_stock = true; return false; } $exceptions = fn_get_product_exceptions($product['product_id'], true); if (!isset($product['options_type']) || !isset($product['exceptions_type'])) { $product = array_merge($product, db_get_row('SELECT options_type, exceptions_type FROM ?:products WHERE product_id = ?i', $product['product_id'])); } if (!fn_is_allowed_options_exceptions($exceptions, $product['product_options'], $product['options_type'], $product['exceptions_type']) && !defined('GET_OPTIONS')) { fn_set_notification('E', fn_get_lang_var('notice'), str_replace('[product]', $_pdata['product'], fn_get_lang_var('product_options_forbidden_combination'))); unset($cart['products'][$hash]); return false; } if (isset($product['extra']['custom_files'])) { $_pdata['extra']['custom_files'] = $product['extra']['custom_files']; } $_pdata['calculation'] = array(); if (isset($product['extra']['exclude_from_calculate'])) { $_pdata['exclude_from_calculate'] = $product['extra']['exclude_from_calculate']; $_pdata['aoc'] = !empty($product['extra']['aoc']); $_pdata['price'] = 0; } else { if ($product['stored_price'] == 'Y') { $_pdata['price'] = $product['price']; } } // If price defined and zero price action allows add zero priced product to cart, get price from the database if (isset($_pdata['price']) && $_pdata['zero_price_action'] != 'A') { $product['price'] = floatval($_pdata['price']); $cart['products'][$hash]['price'] = $product['price']; } $_pdata['original_price'] = $product['price']; if ($product['stored_price'] != 'Y' && !isset($product['extra']['exclude_from_calculate'])) { if ($_pdata['zero_price_action'] != 'A' || $_pdata['zero_price_action'] == 'A' && empty($product['modifiers_price'])) { $_tmp = $product['price']; $product['price'] = fn_apply_options_modifiers($product['product_options'], $product['price'], 'P'); $product['modifiers_price'] = $_pdata['modifiers_price'] = $product['price'] - $_tmp; // modifiers } } else { $product['modifiers_price'] = $_pdata['modifiers_price'] = 0; } if (isset($product['modifiers_price']) && $_pdata['zero_price_action'] == 'A') { $_pdata['base_price'] = $product['price'] - $product['modifiers_price']; } $_pdata['weight'] = fn_apply_options_modifiers($product['product_options'], $_pdata['weight'], 'W'); $_pdata['amount'] = $product['amount']; $_pdata['price'] = $_pdata['original_price'] = fn_format_price($product['price']); $_pdata['stored_price'] = $product['stored_price']; if ($cart['options_style'] == 'F') { $_pdata['product_options'] = fn_get_selected_product_options($product['product_id'], $product['product_options'], CART_LANGUAGE); } elseif ($cart['options_style'] == 'I') { $_pdata['product_options'] = fn_get_selected_product_options_info($product['product_options'], CART_LANGUAGE); } else { $_pdata['product_options'] = $product['product_options']; } if (($_pdata['free_shipping'] != 'Y' || AREA == 'A') && ($_pdata['is_edp'] != 'Y' || $_pdata['is_edp'] == 'Y' && $_pdata['edp_shipping'] == 'Y')) { $cart['shipping_required'] = true; } $cart['products'][$hash]['is_edp'] = !empty($_pdata['is_edp']) && $_pdata['is_edp'] == 'Y' ? 'Y' : 'N'; $cart['products'][$hash]['edp_shipping'] = !empty($_pdata['edp_shipping']) && $_pdata['edp_shipping'] == 'Y' ? 'Y' : 'N'; if (empty($cart['products'][$hash]['extra']['parent'])) { // count only products without parent if ($skip_promotion == true && !empty($promotion_amount)) { $cart['amount'] += $promotion_amount; } else { $cart['amount'] += $product['amount']; } } if ($skip_promotion == false) { if (empty($cart['order_id'])) { fn_promotion_apply('catalog', $_pdata, $auth); } else { if (empty($product['original_discount'])) { $product['original_discount'] = !empty($product['discount']) ? $product['discount'] : 0; $cart['products'][$hash]['original_discount'] = $product['original_discount']; } if (isset($product['discount'])) { $_pdata['discount'] = $product['discount']; $_pdata['price'] -= $product['discount']; if ($_pdata['price'] < 0) { $_pdata['discount'] += $_pdata['price']; $_pdata['price'] = 0; } } } // apply discount to the product if (!empty($_pdata['discount'])) { $cart['use_discount'] = true; } } if (!empty($product['object_id'])) { $_pdata['object_id'] = $product['object_id']; } $_pdata['stored_discount'] = $product['stored_discount']; $cart['products'][$hash]['modifiers_price'] = $product['modifiers_price']; $_pdata['subtotal'] = $_pdata['price'] * $product['amount']; $cart['original_subtotal'] += $_pdata['original_price'] * $product['amount']; $cart['subtotal'] += $_pdata['subtotal']; return $_pdata; } return array(); }
/** * 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); } }
$combinationArrayItems = explode("_", $optionCombinationStart['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;
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); }