in-commerce
No OneTemporary
Actions

Subscribers

None

File Metadata

Created: Wed, Feb 12, 11:00 PM

in-commerce
View Options

	Index: branches/5.2.x/units/product_options/product_options_tag_processor.php
	===================================================================
	--- branches/5.2.x/units/product_options/product_options_tag_processor.php (revision 16024)
	+++ branches/5.2.x/units/product_options/product_options_tag_processor.php (revision 16025)
	@@ -1,175 +1,176 @@
	<?php
	/**
	* @version $Id$
	* @package In-Commerce
	* @copyright Copyright (C) 1997 - 2009 Intechnic. All rights reserved.
	* @license Commercial License
	* This software is protected by copyright law and international treaties.
	* Unauthorized reproduction or unlicensed usage of the code of this program,
	* or any portion of it may result in severe civil and criminal penalties,
	* and will be prosecuted to the maximum extent possible under the law
	* See http://www.in-portal.org/commercial-license for copyright notices and details.
	*/

	defined('FULL_PATH') or die('restricted access!');

	class ProductOptionsTagProcessor extends kDBTagProcessor {

	function ShowOptions($params)
	{
	$object = $this->getObject($params);
	/* @var $object kDBItem */

	$opt_helper = $this->Application->recallObject('kProductOptionsHelper');
	/* @var $opt_helper kProductOptionsHelper */

	$parsed = $opt_helper->ExplodeOptionValues($object->GetFieldValues());
	if ( !$parsed ) {
	return '';
	}

	$values = $parsed['Values'];
	$conv_prices = $parsed['Prices'];
	$conv_price_types = $parsed['PriceTypes'];

	$options =& $this->GetOptions();

	$mode = $this->SelectParam($params, 'mode');
	$combination_prefix = $this->SelectParam($params, 'combination_prefix');
	$combination_field = $this->SelectParam($params, 'combination_field');

	if ( $mode == 'selected' ) {
	$comb = $this->Application->recallObject($combination_prefix);
	/* @var $comb kDBItem */

	$options = unserialize($comb->GetDBField($combination_field));
	}

	$block_params['name'] = $params['render_as'];
	$block_params['selected'] = '';
	$block_params['pass_params'] = 1;

	$lang = $this->Application->recallObject('lang.current');
	/* @var $lang LanguagesItem */

	$o = '';
	$first_selected = false;

	foreach ($values as $option) {
	// list($val, $label) = explode('\|', $option);
	$val = $option;

	if ( getArrayValue($params, 'js') ) {
	$block_params['id'] = kUtil::escape($val, kUtil::ESCAPE_JS);
	$block_params['value'] = kUtil::escape($val);
	}
	else {
	$block_params['id'] = kUtil::escape($val);
	$block_params['value'] = kUtil::escape($val);
	}

	if ( $conv_prices[$val] ) {
	if ( $conv_price_types[$val] == '$' && !getArrayValue($params, 'js') && !getArrayValue($params, 'no_currency') ) {
	$iso = $this->GetISO($params['currency']);
	$value = sprintf("%.2f", $this->ConvertCurrency($conv_prices[$val], $iso));

	$value = $this->AddCurrencySymbol($lang->formatNumber($value, 2), $iso, true); // true to force sign
	$block_params['price'] = $value;
	$block_params['price_type'] = '';
	$block_params['sign'] = ''; //sign is included in the formatted value
	}
	else {
	$block_params['price'] = isset($params['js']) ? $conv_prices[$val] : $lang->formatNumber($conv_prices[$val], 2);
	$block_params['price_type'] = $conv_price_types[$val];
	$block_params['sign'] = $conv_prices[$val] >= 0 ? '+' : '-';
	}
	}
	else {
	$block_params['price'] = '';
	$block_params['price_type'] = '';
	$block_params['sign'] = '';
	}

	/*if ($mode == 'selected') {
	$selected = $combination[$object->GetID()] == $val;
	}
	else*/
	$selected = false;

	if ( !$options && isset($params['preselect_first']) && $params['preselect_first'] && !$first_selected ) {
	$selected = true;
	$first_selected = true;
	}

	if ( is_array($options) ) {
	$option_value = array_key_exists($object->GetID(), $options) ? $options[$object->GetID()] : '';

	if ( $object->GetDBField('OptionType') == OptionType::CHECKBOX ) {
	$selected = is_array($option_value) && in_array(kUtil::escape($val), $option_value);
	}
	else { // radio buttons ?
	- $selected = htmlspecialchars_decode($option_value) == $val;
	+ // TODO: Not sure why we're unescaping.
	+ $selected = kUtil::unescape($option_value, kUtil::ESCAPE_HTML) == $val;
	}
	}

	if ( $selected ) {
	if ( $mode == 'selected' ) {
	if ( $object->GetDBField('OptionType') != OptionType::CHECKBOX ) {
	$block_params['selected'] = ' selected="selected" ';
	}
	else {
	$block_params['selected'] = ' checked="checked" ';
	}
	}
	else {
	switch ($object->GetDBField('OptionType')) {
	case OptionType::DROPDOWN:
	$block_params['selected'] = ' selected="selected" ';
	break;
	case OptionType::RADIO:
	case OptionType::CHECKBOX:
	$block_params['selected'] = ' checked="checked" ';
	break;
	}
	}
	}
	else {
	$block_params['selected'] = '';
	}

	$o .= $this->Application->ParseBlock($block_params);
	}

	return $o;
	}

	function &GetOptions()
	{
	$opt_data = $this->Application->GetVar('options');
	$options = getArrayValue($opt_data, $this->Application->GetVar('p_id'));
	if (!$options && $this->Application->GetVar('orditems_id')) {
	$ord_item = $this->Application->recallObject('orditems.-opt', null, Array ('skip_autoload' => true));
	/* @var $ord_item kDBItem */

	$ord_item->Load($this->Application->GetVar('orditems_id'));
	$item_data = unserialize($ord_item->GetDBField('ItemData'));
	$options = getArrayValue($item_data, 'Options');
	}
	return $options;
	}

	function OptionData($params)
	{
	$object = $this->getObject($params);
	/* @var $object kDBItem */

	$options =& $this->GetOptions();

	return getArrayValue($options, $object->GetID());
	}

	function ListOptions($params)
	{
	return $this->PrintList2($params);
	}
	-}
	\ No newline at end of file
	+}
	Index: branches/5.2.x/units/orders/order_calculator.php
	===================================================================
	--- branches/5.2.x/units/orders/order_calculator.php (revision 16024)
	+++ branches/5.2.x/units/orders/order_calculator.php (revision 16025)
	@@ -1,859 +1,859 @@
	<?php
	/**
	* @version $Id$
	* @package In-Commerce
	* @copyright Copyright (C) 1997 - 2009 Intechnic. All rights reserved.
	* @license Commercial License
	* This software is protected by copyright law and international treaties.
	* Unauthorized reproduction or unlicensed usage of the code of this program,
	* or any portion of it may result in severe civil and criminal penalties,
	* and will be prosecuted to the maximum extent possible under the law
	* See http://www.in-portal.org/commercial-license for copyright notices and details.
	*/

	defined('FULL_PATH') or die('restricted access!');

	/**
	* Performs order price calculations
	*
	*/
	class OrderCalculator extends kBase {

	/**
	* Order manager instance
	*
	* @var OrderManager
	*/
	protected $manager = null;

	/**
	* Items, associated with current order
	*
	* @var Array
	*/
	protected $items = Array ();

	/**
	* Creates new clean instance of calculator
	*
	*/
	public function __construct()
	{
	parent::__construct();

	$this->reset();
	}

	/**
	* Sets order manager instance to calculator
	*
	* @param OrderManager $manager
	*/
	public function setManager(&$manager)
	{
	$this->manager =& $manager;
	}

	public function reset()
	{
	$this->items = Array ();
	}

	/**
	* Returns order object used in order manager
	*
	* @return OrdersItem
	*/
	protected function &getOrder()
	{
	$order =& $this->manager->getOrder();

	return $order;
	}

	/**
	* Sets checkout error
	*
	* @param int $error_type = {product,coupon,gc}
	* @param int $error_code
	* @param int $product_id - {ProductId}:{OptionsSalt}:{BackOrderFlag}:{FieldName}
	* @return void
	* @access protected
	*/
	protected function setError($error_type, $error_code, $product_id = null)
	{
	$this->manager->setError($error_type, $error_code, $product_id);
	}

	/**
	* Perform order calculations and prepares operations for order manager
	*
	*/
	public function calculate()
	{
	$this->queryItems();
	$this->groupItems();

	$this->generateOperations();
	$this->applyWholeOrderFlatDiscount();
	}

	/**
	* Groups order items, when requested
	*
	* @return Array
	*/
	protected function groupItems()
	{
	$skipped_items = Array ();

	foreach ($this->items as $item_id => $item_data) {
	if ( in_array($item_id, $skipped_items) ) {
	continue;
	}

	$group_items = $this->getItemsToGroupWith($item_id);

	if (!$group_items) {
	continue;
	}

	foreach ($group_items as $group_item_id) {
	$this->items[$item_id]['Quantity'] += $this->items[$group_item_id]['Quantity'];
	$this->items[$group_item_id]['Quantity'] = 0;
	}

	$skipped_items = array_merge($skipped_items, $group_items);
	}
	}

	/**
	* Returns order item ids, that can be grouped with given order item id
	*
	* @param int $target_item_id
	* @return Array
	* @see OrderCalculator::canBeGrouped
	*/
	protected function getItemsToGroupWith($target_item_id)
	{
	$ret = Array ();

	foreach ($this->items as $item_id => $item_data) {
	if ( $this->canBeGrouped($this->items[$item_id], $this->items[$target_item_id]) ) {
	$ret[] = $item_id;
	}
	}

	return array_diff($ret, Array ($target_item_id));
	}

	/**
	* Checks if 2 given order items can be grouped together
	*
	* @param Array $src_item
	* @param Array $dst_item
	* @return bool
	*/
	public function canBeGrouped($src_item, $dst_item)
	{
	if ($dst_item['Type'] != PRODUCT_TYPE_TANGIBLE) {
	return false;
	}

	return ($src_item['ProductId'] == $dst_item['ProductId']) && ($src_item['OptionsSalt'] == $dst_item['OptionsSalt']);
	}

	/**
	* Retrieves order contents from database
	*
	*/
	protected function queryItems()
	{
	$poc_table = $this->Application->getUnitOption('poc', 'TableName');

	$query = ' SELECT oi.ProductId, oi.OptionsSalt, oi.ItemData, oi.Quantity,
	IF(p.InventoryStatus = ' . ProductInventory::BY_OPTIONS . ', poc.QtyInStock, p.QtyInStock) AS QtyInStock,
	p.QtyInStockMin, p.BackOrder, p.InventoryStatus,
	p.Type, oi.OrderItemId
	FROM ' . $this->getTable('orditems') . ' AS oi
	LEFT JOIN ' . TABLE_PREFIX . 'Products AS p ON oi.ProductId = p.ProductId
	LEFT JOIN ' . $poc_table . ' poc ON (poc.CombinationCRC = oi.OptionsSalt) AND (oi.ProductId = poc.ProductId)
	WHERE oi.OrderId = ' . $this->getOrder()->GetID();

	$this->items = $this->Conn->Query($query, 'OrderItemId');
	}

	/**
	* Generates operations and returns true, when something was changed
	*
	* @return bool
	*/
	protected function generateOperations()
	{
	$this->manager->resetOperationTotals();

	foreach ($this->items as $item) {
	$this->ensureMinQty($item);

	$to_order = $back_order = 0;
	$available = $this->getAvailableQty($item);

	if ( $this->allowBackordering($item) ) {
	// split order into order & backorder
	if ($item['BackOrder'] == ProductBackorder::ALWAYS) {
	$to_order = $available = 0;
	$back_order = $item['Quantity'];
	}
	elseif ($item['BackOrder'] == ProductBackorder::AUTO) {
	$to_order = $available;
	$back_order = $item['Quantity'] - $available;
	}

	$qty = $to_order + $back_order;

	$price = $this->getPlainProductPrice($item, $qty);
	$cost = $this->getProductCost($item, $qty);
	$discount_info = $this->getDiscountInfo( $item['ProductId'], $price, $qty );

	$this->manager->addOperation($item, 0, $to_order, $price, $cost, $discount_info);
	$this->manager->addOperation($item, 1, $back_order, $price, $cost, $discount_info);
	}
	else {
	// store as normal order (and remove backorder)
	// we could get here with backorder=never then we should order only what's available
	$to_order = min($item['Quantity'], $available);

	$price = $this->getPlainProductPrice($item, $to_order);
	$cost = $this->getProductCost($item, $to_order);
	$discount_info = $this->getDiscountInfo( $item['ProductId'], $price, $to_order );

	$this->manager->addOperation($item, 0, $to_order, $price, $cost, $discount_info, $item['OrderItemId']);
	$this->manager->addOperation($item, 1, 0, $price, $cost, $discount_info); // remove backorder record

	if ($to_order < $item['Quantity']) {
	// ordered less, then requested -> inform user
	if ( $to_order > 0 ) {
	$this->setError(OrderCheckoutErrorType::PRODUCT, OrderCheckoutError::QTY_UNAVAILABLE, $item['ProductId'] . ':' . $item['OptionsSalt'] . ':0:Quantity');
	}
	else {
	$this->setError(OrderCheckoutErrorType::PRODUCT, OrderCheckoutError::QTY_OUT_OF_STOCK, $item['ProductId'] . ':' . $item['OptionsSalt'] . ':0:Quantity');
	}
	}
	}
	}
	}

	/**
	* Adds product to order (not to db)
	*
	* @param Array $item
	* @param kCatDBItem $product
	* @param int $qty
	*/
	public function addProduct($item, &$product, $qty)
	{
	$this->updateItemDataFromProduct($item, $product);

	$price = $this->getPlainProductPrice($item, $qty);
	$cost = $this->getProductCost($item, $qty);
	$discount_info = $this->getDiscountInfo( $item['ProductId'], $price, $qty );

	$this->manager->addOperation( $item, 0, $qty, $price, $cost, $discount_info, $item['OrderItemId'] );
	}

	/**
	* Apply whole order flat discount after sub-total been calculated
	*
	*/
	protected function applyWholeOrderFlatDiscount()
	{
	$sub_total_flat = $this->manager->getOperationTotal('SubTotalFlat');
	$flat_discount = min( $sub_total_flat, $this->getWholeOrderPlainDiscount($global_discount_id) );
	$coupon_flat_discount = min( $sub_total_flat, $this->getWholeOrderCouponDiscount() );

	if ($coupon_flat_discount && $coupon_flat_discount > $flat_discount) {
	$global_discount_type = 'coupon';
	$flat_discount = $coupon_flat_discount;
	$global_discount_id = $coupon_id;
	}
	else {
	$global_discount_type = 'discount';
	}

	$sub_total = $this->manager->getOperationTotal('SubTotal');

	if ($sub_total_flat - $sub_total < $flat_discount) {
	// individual item discounts together are smaller when order flat discount
	$this->manager->setOperationTotal('CouponDiscount', $flat_discount == $coupon_flat_discount ? $flat_discount : 0);
	$this->manager->setOperationTotal('SubTotal', $sub_total_flat - $flat_discount);

	// replace discount for each operation
	foreach ($this->operations as $index => $operation) {
	$discounted_price = ($operation['Price'] / $sub_total_flat) * $sub_total;
	$this->operations[$index]['DiscountInfo'] = Array ($global_discount_id, $global_discount_type, $discounted_price, 0);
	}
	}
	}

	/**
	* Returns discount information for given product price and qty
	*
	* @param int $product_id
	* @param float $price
	* @param int $qty
	* @return Array
	*/
	protected function getDiscountInfo($product_id, $price, $qty)
	{
	$discounted_price = $this->getDiscountedProductPrice($product_id, $price, $discount_id);
	$couponed_price = $this->getCouponDiscountedPrice($product_id, $price);

	if ($couponed_price < $discounted_price) {
	$discount_type = 'coupon';
	$discount_id = $coupon_id;

	$discounted_price = $couponed_price;
	$coupon_discount = ($price - $couponed_price) * $qty;
	}
	else {
	$coupon_discount = 0;
	$discount_type = 'discount';
	}

	return Array ($discount_id, $discount_type, $discounted_price, $coupon_discount);
	}

	/**
	* Returns product qty, available for ordering
	*
	* @param Array $item
	* @return int
	*/
	protected function getAvailableQty($item)
	{
	if ( $item['InventoryStatus'] == ProductInventory::DISABLED ) {
	// always available
	return $item['Quantity'] * 2;
	}

	return max(0, $item['QtyInStock'] - $item['QtyInStockMin']);
	}

	/**
	* Checks, that product in given order item can be backordered
	*
	* @param Array $item
	* @return bool
	*/
	protected function allowBackordering($item)
	{
	if ($item['BackOrder'] == ProductBackorder::ALWAYS) {
	return true;
	}

	$available = $this->getAvailableQty($item);
	$backordering = $this->Application->ConfigValue('Comm_Enable_Backordering');

	return $backordering && ($item['Quantity'] > $available) && ($item['BackOrder'] == ProductBackorder::AUTO);
	}

	/**
	* Make sure, that user can't order less, then minimal required qty of product
	*
	* @param Array $item
	*/
	protected function ensureMinQty(&$item)
	{
	$sql = 'SELECT MIN(MinQty)
	FROM ' . TABLE_PREFIX . 'ProductsPricing
	WHERE ProductId = ' . $item['ProductId'];
	$min_qty = max(1, $this->Conn->GetOne($sql));

	$qty = $item['Quantity'];

	if ($qty > 0 && $qty < $min_qty) {
	// qty in cart increased to meat minimal qry requirements of given product
	$this->setError(OrderCheckoutErrorType::PRODUCT, OrderCheckoutError::QTY_CHANGED_TO_MINIMAL, $item['ProductId'] . ':' . $item['OptionsSalt'] . ':0:Quantity');

	$item['Quantity'] = $min_qty;
	}
	}

	/**
	* Return product price for given qty, taking no discounts into account
	*
	* @param Array $item
	* @param int $qty
	* @return float
	*/
	public function getPlainProductPrice($item, $qty)
	{
	$item_data = $this->getItemData($item);

	if ( isset($item_data['ForcePrice']) ) {
	return $item_data['ForcePrice'];
	}

	$pricing_id = $this->getPriceBracketByQty($item, $qty);

	$sql = 'SELECT Price
	FROM ' . TABLE_PREFIX . 'ProductsPricing
	WHERE PriceId = ' . $pricing_id;
	$price = (float)$this->Conn->GetOne($sql);

	if ( isset($item_data['Options']) ) {
	$price += $this->getOptionPriceAddition($price, $item_data);
	$price = $this->getCombinationPriceOverride($price, $item_data);
	}

	return max($price, 0);
	}

	/**
	* Return product cost for given qty, taking no discounts into account
	*
	* @param Array $item
	* @param int $qty
	* @return float
	*/
	public function getProductCost($item, $qty)
	{
	$pricing_id = $this->getPriceBracketByQty($item, $qty);

	$sql = 'SELECT Cost
	FROM ' . TABLE_PREFIX . 'ProductsPricing
	WHERE PriceId = ' . $pricing_id;

	return (float)$this->Conn->GetOne($sql);
	}

	/**
	* Return product price for given qty, taking no discounts into account
	*
	* @param Array $item
	* @param int $qty
	* @return float
	*/
	protected function getPriceBracketByQty($item, $qty)
	{
	$orderby_clause = '';
	$where_clause = Array ();
	$product_id = $item['ProductId'];

	if ( $this->usePriceBrackets($item) ) {
	$user_id = $this->getOrder()->GetDBField('PortalUserId');

	$where_clause = Array (
	'GroupId IN (' . $this->Application->getUserGroups($user_id) . ')',
	'pp.ProductId = ' . $product_id,
	'pp.MinQty <= ' . $qty,
	$qty . ' < pp.MaxQty OR pp.MaxQty = -1',
	);

	$orderby_clause = $this->getPriceBracketOrderClause($user_id);
	}
	else {
	$item_data = $this->getItemData($item);

	$where_clause = Array(
	'pp.ProductId = ' . $product_id,
	'pp.PriceId = ' . $this->getPriceBracketFromRequest($product_id, $item_data),
	);
	}

	$sql = 'SELECT pp.PriceId
	FROM ' . TABLE_PREFIX . 'ProductsPricing AS pp
	LEFT JOIN ' . TABLE_PREFIX . 'Products AS p ON p.ProductId = pp.ProductId
	WHERE (' . implode(') AND (', $where_clause) . ')';

	if ($orderby_clause) {
	$sql .= ' ORDER BY ' . $orderby_clause;
	}

	return (float)$this->Conn->GetOne($sql);
	}

	/**
	* Checks if price brackets should be used in price calculations
	*
	* @param Array $item
	* @return bool
	*/
	protected function usePriceBrackets($item)
	{
	return $item['Type'] == PRODUCT_TYPE_TANGIBLE;
	}

	/**
	* Return product pricing id for given product.
	* If not passed - return primary pricing ID
	*
	* @param int $product_id
	* @return int
	*/
	public function getPriceBracketFromRequest($product_id, $item_data)
	{
	if ( !is_array($item_data) ) {
	$item_data = unserialize($item_data);
	}

	// remembered pricing during checkout
	if ( isset($item_data['PricingId']) && $item_data['PricingId'] ) {
	return $item_data['PricingId'];
	}

	// selected pricing from product detail page
	$price_id = $this->Application->GetVar('pr_id');

	if ($price_id) {
	return $price_id;
	}

	$sql = 'SELECT PriceId
	FROM ' . TABLE_PREFIX . 'ProductsPricing
	WHERE ProductId = ' . $product_id . ' AND IsPrimary = 1';

	return $this->Conn->GetOne($sql);
	}

	/**
	* Returns order clause for price bracket selection based on configration
	*
	* @param int $user_id
	* @return string
	*/
	protected function getPriceBracketOrderClause($user_id)
	{
	if ($this->Application->ConfigValue('Comm_PriceBracketCalculation') == 1) {
	// if we have to stick to primary group, then its pricing will go first,
	// but if there is no pricing for primary group, then next optimal will be taken
	$primary_group = $this->getUserPrimaryGroup($user_id);

	return '( IF(GroupId = ' . $primary_group . ', 1, 2) ) ASC, pp.Price ASC';
	}

	return 'pp.Price ASC';
	}

	/**
	* Returns addition to product price based on used product option
	*
	* @param float $price
	* @param Array $item_data
	* @return float
	*/
	protected function getOptionPriceAddition($price, $item_data)
	{
	$addition = 0;

	$opt_helper = $this->Application->recallObject('kProductOptionsHelper');
	/* @var $opt_helper kProductOptionsHelper */

	foreach ($item_data['Options'] as $opt => $val) {
	$sql = 'SELECT *
	FROM ' . TABLE_PREFIX . 'ProductOptions
	WHERE ProductOptionId = ' . $opt;
	$data = $this->Conn->GetRow($sql);

	$parsed = $opt_helper->ExplodeOptionValues($data);

	if ( !$parsed ) {
	continue;
	}

	if ( is_array($val) ) {
	foreach ($val as $a_val) {
	$addition += $this->formatPrice($a_val, $price, $parsed);
	}
	}
	else {
	$addition += $this->formatPrice($val, $price, $parsed);
	}
	}

	return $addition;
	}

	protected function formatPrice($a_val, $price, $parsed)
	{
	- $a_val = htmlspecialchars_decode($a_val);
	+ $a_val = kUtil::unescape($a_val, kUtil::ESCAPE_HTML); // TODO: Not sure why we're unescaping.

	$addition = 0;
	$conv_prices = $parsed['Prices'];
	$conv_price_types = $parsed['PriceTypes'];

	if ( isset($conv_prices[$a_val]) && $conv_prices[$a_val] ) {
	if ($conv_price_types[$a_val] == '$') {
	$addition += $conv_prices[$a_val];
	}
	elseif ($conv_price_types[$a_val] == '%') {
	$addition += $price * $conv_prices[$a_val] / 100;
	}
	}

	return $addition;
	}

	/**
	* Returns product price after applying combination price override
	*
	* @param float $price
	* @param Array $item_data
	* @return float
	*/
	protected function getCombinationPriceOverride($price, $item_data)
	{
	$combination_salt = $this->generateOptionsSalt( $item_data['Options'] );

	if (!$combination_salt) {
	return $price;
	}

	$sql = 'SELECT *
	FROM ' . TABLE_PREFIX . 'ProductOptionCombinations
	WHERE CombinationCRC = ' . $combination_salt;
	$combination = $this->Conn->GetRow($sql);

	if (!$combination) {
	return $price;
	}

	switch ( $combination['PriceType'] ) {
	case OptionCombinationPriceType::EQUALS:
	return $combination['Price'];
	break;

	case OptionCombinationPriceType::FLAT:
	return $price + $combination['Price'];
	break;

	case OptionCombinationPriceType::PECENT:
	return $price * (1 + $combination['Price'] / 100);
	break;
	}

	return $price;
	}

	/**
	* Generates salt for given option set
	*
	* @param Array $options
	* @return int
	*/
	public function generateOptionsSalt($options)
	{
	$opt_helper = $this->Application->recallObject('kProductOptionsHelper');
	/* @var $opt_helper kProductOptionsHelper */

	return $opt_helper->OptionsSalt($options, true);
	}

	/**
	* Return product price for given qty, taking possible discounts into account
	*
	* @param int $product_id
	* @param int $price
	* @param int $discount_id
	* @return float
	*/
	public function getDiscountedProductPrice($product_id, $price, &$discount_id)
	{
	$discount_id = 0;
	$user_id = $this->getOrder()->GetDBField('PortalUserId');

	$join_clause = Array (
	'd.DiscountId = di.DiscountId',
	'di.ItemType = ' . DiscountItemType::PRODUCT . ' OR (di.ItemType = ' . DiscountItemType::WHOLE_ORDER . ' AND d.Type = ' . DiscountType::PERCENT . ')',
	'd.Status = ' . STATUS_ACTIVE,
	'd.GroupId IN (' . $this->Application->getUserGroups($user_id) . ')',
	'd.Start IS NULL OR d.Start < ' . $this->getOrder()->GetDBField('OrderDate'),
	'd.End IS NULL OR d.End > ' . $this->getOrder()->GetDBField('OrderDate'),
	);

	$sql = 'SELECT
	CASE d.Type
	WHEN ' . DiscountType::FLAT . ' THEN ' . $price . ' - d.Amount
	WHEN ' . DiscountType::PERCENT . ' THEN ' . $price . ' * (1 - d.Amount / 100)
	ELSE ' . $price . '
	END, d.DiscountId
	FROM ' . TABLE_PREFIX . 'Products AS p
	LEFT JOIN ' . TABLE_PREFIX . 'ProductsDiscountItems AS di ON (di.ItemResourceId = p.ResourceId) OR (di.ItemType = ' . DiscountItemType::WHOLE_ORDER . ')
	LEFT JOIN ' . TABLE_PREFIX . 'ProductsDiscounts AS d ON (' . implode(') AND (', $join_clause) . ')
	WHERE (p.ProductId = ' . $product_id . ') AND (d.DiscountId IS NOT NULL)';
	$pricing = $this->Conn->GetCol($sql, 'DiscountId');

	if (!$pricing) {
	return $price;
	}

	// get minimal price + discount
	$discounted_price = min($pricing);
	$pricing = array_flip($pricing);
	$discount_id = $pricing[$discounted_price];

	// optimal discount, but prevent negative price
	return max( min($discounted_price, $price), 0 );
	}

	public function getWholeOrderPlainDiscount(&$discount_id)
	{
	$discount_id = 0;
	$user_id = $this->getOrder()->GetDBField('PortalUserId');

	$join_clause = Array (
	'd.DiscountId = di.DiscountId',
	'di.ItemType = ' . DiscountItemType::WHOLE_ORDER . ' AND d.Type = ' . DiscountType::FLAT,
	'd.Status = ' . STATUS_ACTIVE,
	'd.GroupId IN (' . $this->Application->getUserGroups($user_id) . ')',
	'd.Start IS NULL OR d.Start < ' . $this->getOrder()->GetDBField('OrderDate'),
	'd.End IS NULL OR d.End > ' . $this->getOrder()->GetDBField('OrderDate'),
	);

	$sql = 'SELECT d.Amount AS Discount, d.DiscountId
	FROM ' . TABLE_PREFIX . 'ProductsDiscountItems AS di
	LEFT JOIN ' . TABLE_PREFIX . 'ProductsDiscounts AS d ON (' . implode(') AND (', $join_clause) . ')
	WHERE d.DiscountId IS NOT NULL';
	$pricing = $this->Conn->GetCol($sql, 'DiscountId');

	if (!$pricing) {
	return 0;
	}

	$discounted_price = max($pricing);
	$pricing = array_flip($pricing);
	$discount_id = $pricing[$discounted_price];

	return max($discounted_price, 0);
	}

	public function getCouponDiscountedPrice($product_id, $price)
	{
	if ( !$this->getCoupon() ) {
	return $price;
	}

	$join_clause = Array (
	'c.CouponId = ci.CouponId',
	'ci.ItemType = ' . CouponItemType::PRODUCT . ' OR (ci.ItemType = ' . CouponItemType::WHOLE_ORDER . ' AND c.Type = ' . CouponType::PERCENT . ')',
	);

	$sql = 'SELECT
	MIN(
	CASE c.Type
	WHEN ' . CouponType::FLAT . ' THEN ' . $price . ' - c.Amount
	WHEN ' . CouponType::PERCENT . ' THEN ' . $price . ' * (1 - c.Amount / 100)
	ELSE ' . $price . '
	END
	)
	FROM ' . TABLE_PREFIX . 'Products AS p
	LEFT JOIN ' . TABLE_PREFIX . 'ProductsCouponItems AS ci ON (ci.ItemResourceId = p.ResourceId) OR (ci.ItemType = ' . CouponItemType::WHOLE_ORDER . ')
	LEFT JOIN ' . TABLE_PREFIX . 'ProductsCoupons AS c ON (' . implode(') AND (', $join_clause) . ')
	WHERE p.ProductId = ' . $product_id . ' AND ci.CouponId = ' . $this->getCoupon() . '
	GROUP BY p.ProductId';

	$coupon_price = $this->Conn->GetOne($sql);

	if ($coupon_price === false) {
	return $price;
	}

	return max( min($price, $coupon_price), 0 );
	}

	public function getWholeOrderCouponDiscount()
	{
	if ( !$this->getCoupon() ) {
	return 0;
	}

	$where_clause = Array (
	'ci.CouponId = ' . $this->getCoupon(),
	'ci.ItemType = ' . CouponItemType::WHOLE_ORDER,
	'c.Type = ' . CouponType::FLAT,
	);

	$sql = 'SELECT Amount
	FROM ' . TABLE_PREFIX . 'ProductsCouponItems AS ci
	LEFT JOIN ' . TABLE_PREFIX . 'ProductsCoupons AS c ON c.CouponId = ci.CouponId
	WHERE (' . implode(') AND (', $where_clause) . ')';

	return $this->Conn->GetOne($sql);
	}

	protected function getCoupon()
	{
	return $this->getOrder()->GetDBField('CouponId');
	}

	/**
	* Returns primary group of given user
	*
	* @param int $user_id
	* @return int
	*/
	protected function getUserPrimaryGroup($user_id)
	{
	if ($user_id > 0) {
	$sql = 'SELECT PrimaryGroupId
	FROM ' . TABLE_PREFIX . 'Users
	WHERE PortalUserId = ' . $user_id;
	return $this->Conn->GetOne($sql);
	}

	return $this->Application->ConfigValue('User_LoggedInGroup');
	}

	/**
	* Returns ItemData associated with given order item
	*
	* @param Array $item
	* @return Array
	*/
	protected function getItemData($item)
	{
	$item_data = $item['ItemData'];

	if ( is_array($item_data) ) {
	return $item_data;
	}

	return $item_data ? unserialize($item_data) : Array ();
	}

	/**
	* Sets ItemData according to product
	*
	* @param Array $item
	* @param kCatDBItem $product
	*/
	protected function updateItemDataFromProduct(&$item, &$product)
	{
	$item_data = $this->getItemData($item);
	$item_data['IsRecurringBilling'] = $product->GetDBField('IsRecurringBilling');

	// it item is processed in order using new style, then put such mark in orderitem record
	$processing_data = $product->GetDBField('ProcessingData');

	if ($processing_data) {
	$processing_data = unserialize($processing_data);

	if ( isset($processing_data['HasNewProcessing']) ) {
	$item_data['HasNewProcessing'] = 1;
	}
	}

	$item['ItemData'] = serialize($item_data);
	}

	/**
	* Returns table name according to order temp mode
	*
	* @param string $prefix
	* @return string
	*/
	protected function getTable($prefix)
	{
	return $this->manager->getTable($prefix);
	}
	- }
	\ No newline at end of file
	+ }
	Index: branches/5.2.x/units/order_items/order_items_tag_processor.php
	===================================================================
	--- branches/5.2.x/units/order_items/order_items_tag_processor.php (revision 16024)
	+++ branches/5.2.x/units/order_items/order_items_tag_processor.php (revision 16025)
	@@ -1,305 +1,305 @@
	<?php
	/**
	* @version $Id$
	* @package In-Commerce
	* @copyright Copyright (C) 1997 - 2009 Intechnic. All rights reserved.
	* @license Commercial License
	* This software is protected by copyright law and international treaties.
	* Unauthorized reproduction or unlicensed usage of the code of this program,
	* or any portion of it may result in severe civil and criminal penalties,
	* and will be prosecuted to the maximum extent possible under the law
	* See http://www.in-portal.org/commercial-license for copyright notices and details.
	*/

	defined('FULL_PATH') or die('restricted access!');

	class OrderItemsTagProcessor extends kDBTagProcessor
	{
	function PrintGrid($params)
	{
	$order = $this->Application->recallObject('ord');
	/* @var $order kDBList */

	if ( $order->GetDBField('Status') != ORDER_STATUS_INCOMPLETE ) {
	$params['grid'] = $params['NotEditable'];
	}
	else {
	$params['grid'] = $params['Editable'];
	}

	return $this->Application->ProcessParsedTag('m', 'ParseBlock', $params);
	}

	function IsTangible($params)
	{
	$object = $this->getObject($params);
	/* @var $object kDBItem */

	return $object->GetDBField('Type') == PRODUCT_TYPE_TANGIBLE;
	}

	function HasQty($params)
	{
	$object = $this->getObject($params);
	/* @var $object kDBItem */

	return in_array($object->GetDBField('Type'), Array (PRODUCT_TYPE_TANGIBLE, 6));
	}

	function HasDiscount($params)
	{
	$object = $this->getObject($params);
	/* @var $object kDBItem */

	return (float)$object->GetDBField('ItemDiscount') ? 1 : 0;
	}

	function HasOptions($params)
	{
	$object = $this->getObject($params);
	$item_data = @unserialize($object->GetDBField('ItemData'));
	return isset($item_data['Options']);
	}

	function PrintOptions($params)
	{
	$object = $this->getObject($params);
	/* @var $object kDBItem */

	$item_data = @unserialize($object->GetDBField('ItemData'));

	$render_as = $this->SelectParam($params, 'render_as');
	$block_params['name'] = $render_as;

	$opt_helper = $this->Application->recallObject('kProductOptionsHelper');
	/* @var $opt_helper kProductOptionsHelper */

	$o = '';
	$options = $item_data['Options'];
	foreach ($options as $opt => $val) {
	if ( !is_array($val) ) {
	- $val = htmlspecialchars_decode($val);
	+ $val = kUtil::unescape($val, kUtil::ESCAPE_HTML); // TODO: Not sure why we're unescaping.
	}
	$key_data = $opt_helper->ConvertKey($opt, $object->GetDBField('ProductId'));

	$parsed = $opt_helper->ExplodeOptionValues($key_data);
	if ( $parsed ) {
	$values = $parsed['Values'];
	$prices = $parsed['Prices'];
	$price_types = $parsed['PriceTypes'];
	}
	else {
	$values = array ();
	$prices = array ();
	$price_types = array ();
	}

	$key = $key_data['Name'];
	/*if (is_array($val)) {
	$val = join(',', $val);
	}*/

	$lang = $this->Application->recallObject('lang.current');
	/* @var $lang LanguagesItem */

	if ( $render_as ) {
	$block_params['option'] = $key;
	if ( is_array($val) ) {
	$block_params['value'] = $val;
	$block_params['type'] = $key_data['OptionType'];
	$block_params['price'] = $prices;
	$block_params['price_type'] = $price_types;
	}
	else {
	$price_type = array_key_exists($val, $price_types) ? $price_types[$val] : '';
	$price = array_key_exists($val, $prices) ? $prices[$val] : '';

	if ( $price_type == '$' ) {
	$iso = $this->GetISO($params['currency']);
	$value = $this->AddCurrencySymbol($lang->formatNumber($this->ConvertCurrency($price, $iso), 2), $iso, true); // true to force sign
	$block_params['price'] = $value;
	$block_params['price_type'] = '';
	$block_params['sign'] = ''; // sign is included in the formatted value
	}
	else {
	$block_params['price'] = $price;
	$block_params['price_type'] = $price_type;
	$block_params['sign'] = $price >= 0 ? '+' : '-';
	}

	// TODO: consider escaping in template instead
	$block_params['value'] = kUtil::escape($val);
	$block_params['type'] = $key_data['OptionType'];
	}
	$o .= $this->Application->ParseBlock($block_params, 1);
	}
	else {
	$o .= $key . ': ' . $val . '<br>';
	}
	}
	return $o;
	}

	function ProductsInStock($params)
	{
	$object = $this->getObject($params);

	if (!$object->GetDBField('InventoryStatus')) {
	// unlimited count available
	return false;
	}

	if ($object->GetDBField('InventoryStatus') == 2) {
	$poc_table = $this->Application->getUnitOption('poc', 'TableName');
	$sql = 'SELECT QtyInStock
	FROM '.$poc_table.'
	WHERE (ProductId = '.$object->GetDBField('ProductId').') AND (Availability = 1) AND (CombinationCRC = '.$object->GetDBField('OptionsSalt').')';
	$ret = $this->Conn->GetOne($sql);
	}
	else {
	$ret = $object->GetDBField('QtyInStock');
	}

	return $ret;
	}

	function PrintOptionValues($params)
	{
	$block_params['name'] = $params['render_as'];

	$values = $this->Application->Parser->GetParam('value');
	/* @var $values Array */

	$prices = $this->Application->Parser->GetParam('price');
	$price_types = $this->Application->Parser->GetParam('price_type');

	$o = '';
	$i = 0;
	foreach ($values as $val) {
	$i++;
	- $val = htmlspecialchars_decode($val);
	+ $val = kUtil::unescape($val, kUtil::ESCAPE_HTML); // TODO: Not sure why we're unescaping.

	// TODO: consider escaping in template instead
	$block_params['value'] = kUtil::escape($val);

	if ($price_types[$val] == '$') {
	$iso = $this->GetISO($params['currency']);
	$value = $this->AddCurrencySymbol(sprintf("%.2f", $this->ConvertCurrency($prices[$val], $iso)), $iso, true); // true to force sign
	$block_params['price'] = $value;
	$block_params['price_type'] = '';
	$block_params['sign'] = ''; // sign is included in the formatted value
	}
	else {
	$block_params['price'] = $prices[$val];
	$block_params['price_type'] = $price_types[$val];
	$block_params['sign'] = $prices[$val] >= 0 ? '+' : '-';
	}
	$block_params['is_last'] = $i == count($values);
	$o.= $this->Application->ParseBlock($block_params, 1);
	}
	return $o;
	}

	/*function ConvertKey($key, &$object)
	{
	static $mapping = null;
	if (is_null($mapping) \|\| !isset($mapping[$object->GetDBField('ProductId')])) {
	$table = TABLE_PREFIX.'ProductOptions';
	$sql = 'SELECT * FROM '.$table.' WHERE ProductId = '.$object->GetDBField('ProductId');
	$mapping[$object->GetDBField('ProductId')] = $this->Conn->Query($sql, 'ProductOptionId');
	}
	return $mapping[$object->GetDBField('ProductId')][$key];
	}*/

	function PrintList($params)
	{
	$list =& $this->GetList($params);
	$id_field = $this->Application->getUnitOption($this->Prefix, 'IDField');

	$list->Query();
	$o = '';
	$list->GoFirst();

	$block_params = $this->prepareTagParams($params);
	$block_params['name'] = $this->SelectParam($params, 'render_as,block');
	$block_params['pass_params'] = 'true';

	$product_object = $this->Application->recallObject('p', 'p', Array ('skip_autoload' => true));
	/* @var $product_object kCatDBItem */

	$i = 0;
	$product_id = $product_object->GetID();
	$product_id_get = $this->Application->GetVar('p_id');

	while (!$list->EOL()) {
	// load product used in orderitem
	$this->Application->SetVar($this->getPrefixSpecial() . '_id', $list->GetDBField($id_field)); // for edit/delete links using GET
	$this->Application->SetVar('p_id', $list->GetDBField('ProductId'));
	$product_object->Load($list->GetDBField('ProductId')); // correct product load

	$this->Application->SetVar('m_cat_id', $product_object->GetDBField('CategoryId'));

	$block_params['is_last'] = ($i == $list->GetSelectedCount() - 1);

	$o .= $this->Application->ParseBlock($block_params, 1);
	$list->GoNext();
	$i++;
	}

	// restore IDs used in cycle
	$this->Application->SetVar('p_id', $product_id_get);
	$this->Application->DeleteVar($this->getPrefixSpecial() . '_id');

	if ( $product_id ) {
	$product_object->Load($product_id);
	}

	return $o;
	}

	function DisplayOptionsPricing($params)
	{
	$object = $this->getObject($params);
	/* @var $object kDBItem */

	if ( $object->GetDBField('OptionsSelectionMode') == 1 ) {
	return false;
	}

	$item_data = unserialize($object->GetDBField('ItemData'));
	if ( !is_array($item_data) ) {
	return false;
	}

	$options = getArrayValue($item_data, 'Options');
	$helper = $this->Application->recallObject('kProductOptionsHelper');
	/* @var $helper kProductOptionsHelper */

	$crc = $helper->OptionsSalt($options, true);

	$sql = 'SELECT COUNT(*)
	FROM ' . TABLE_PREFIX . 'ProductOptionCombinations
	WHERE CombinationCRC = ' . $crc . ' AND ProductId = ' . $object->GetDBField('ProductId') . ' AND (Price != 0 OR (PriceType = 1 AND Price = 0))';

	return $this->Conn->GetOne($sql) == 0; // no overriding combinations found
	}

	function RowIndex($params)
	{
	$object = $this->getObject($params);
	/* @var $object kDBItem */

	return $object->GetDBField('ProductId') . ':' . $object->GetDBField('OptionsSalt') . ':' . $object->GetDBField('BackOrderFlag');
	}

	function FreePromoShippingAvailable($params)
	{
	$object = $this->getObject($params);
	/* @var $object kDBItem */

	$order_helper = $this->Application->recallObject('OrderHelper');
	/* @var $order_helper OrderHelper */

	return $order_helper->eligibleForFreePromoShipping($object);
	}
	-}
	\ No newline at end of file
	+}

in-commerceNo OneTemporaryActions

File Metadata

in-commerceView Options

Event Timeline

in-commerce
No OneTemporary
Actions

in-commerce
View Options