in-commerce
No OneTemporary
Actions

Subscribers

None

File Metadata

Created: Sun, Aug 24, 12:44 PM

in-commerce
View Options

	Index: branches/5.0.x/in-commerce/install/upgrades.php
	===================================================================
	--- branches/5.0.x/in-commerce/install/upgrades.php (revision 12430)
	+++ branches/5.0.x/in-commerce/install/upgrades.php (revision 12431)
	@@ -1,138 +1,144 @@
	<?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.net/license/commercial/ for copyright notices and details.
	*/
	defined('FULL_PATH') or die('restricted access!');

	$upgrade_class = 'InCommerceUpgrades';

	/**
	* Class, that holds all upgrade scripts for "Core" module
	*
	*/
	class InCommerceUpgrades extends kHelper {

	/**
	* Install toolkit instance
	*
	* @var kInstallToolkit
	*/
	var $_toolkit = null;

	/**
	* Sets common instance of installator toolkit
	*
	* @param kInstallToolkit $instance
	*/
	function setToolkit(&$instance)
	{
	$this->_toolkit =& $instance;
	}

	/**
	* Changes table structure, where multilingual fields of TEXT type are present
	*
	* @param string $mode when called mode {before, after)
	*/
	function Upgrade_5_0_0($mode)
	{
	if ($mode == 'after') {
	// update icon
	$root_category = $this->Application->findModule('Name', 'In-Commerce', 'RootCat');

	$sql = 'UPDATE ' . $this->Application->getUnitOption('c', 'TableName') . '
	SET UseMenuIconUrl = 1, MenuIconUrl = "in-commerce/img/menu_products.gif"
	WHERE ' . $this->Application->getUnitOption('c', 'IDField') . ' = ' . $root_category;
	$this->Conn->Query($sql);

	$this->_updateDetailTemplate('p', 'in-commerce/product/details', 'in-commerce/designs/detail');

	// copy store name to company name
	$store_name = $this->Application->ConfigValue('Comm_StoreName');

	$sql = 'UPDATE ' . TABLE_PREFIX . 'ConfigurationValues
	SET VariableValue = ' . $this->Conn->qstr($store_name) . '
	WHERE VariableName = "Comm_CompanyName"';
	$this->Conn->Query($sql);
	}
	}

	/**
	* Replaces deprecated detail template design with new one
	*
	* @param string $prefix
	* @param string $from_template
	* @param string $to_template
	*/
	function _updateDetailTemplate($prefix, $from_template, $to_template)
	{
	$sql = 'SELECT CustomFieldId
	FROM ' . TABLE_PREFIX . 'CustomField
	WHERE FieldName = "' . $prefix . '_ItemTemplate"';
	$custom_field_id = $this->Conn->GetOne($sql);

	$ml_formatter =& $this->Application->recallObject('kMultiLanguage');
	/* @var $ml_formatter kMultiLanguage */

	$field = $ml_formatter->LangFieldName('cust_' . $custom_field_id, true);

	$sql = 'UPDATE ' . TABLE_PREFIX . 'CategoryCustomData
	SET ' . $field . ' = "' . $to_template . '"
	WHERE ' . $field . ' = "' . $from_template . '"';
	$this->Conn->Query($sql);
	}

	/**
	* Update to 5.0.1, update details template
	*
	* @param string $mode when called mode {before, after)
	*/
	function Upgrade_5_0_1($mode)
	{
	if ($mode == 'after') {
	$this->_updateDetailTemplate('p', 'in-commerce/designs/detail', 'in-commerce/products/product_detail');

	// clean incomplete orders 5+ hours old
	$delete_timestamp = mktime() - (3600 * 5);
	$sql = 'SELECT OrderId FROM ' . TABLE_PREFIX . 'Orders
	WHERE Status = ' . ORDER_STATUS_INCOMPLETE . '
	AND OrderDate < ' . $delete_timestamp;

	$orders_to_delete = $this->Conn->GetCol($sql);

	if ( $orders_to_delete && is_array($orders_to_delete) ) {

	$this->Conn->Query( 'DELETE FROM ' . TABLE_PREFIX . 'OrderItems
	WHERE OrderId IN ( ' . implode(',', $orders_to_delete) . ' )' );

	$this->Conn->Query( 'DELETE FROM ' . TABLE_PREFIX . 'Orders
	WHERE Status = ' . ORDER_STATUS_INCOMPLETE . '
	AND OrderDate < ' . $delete_timestamp );
	}

	// delete old events
	- $events_to_delete = Array ( '"SITE.SUGGEST"' );
	- $sql = 'SELECT EventId
	- FROM ' . TABLE_PREFIX . 'Events
	- WHERE Event IN (' . implode(',', $events_to_delete) . ')';
	+ $events_to_delete = Array ( 'SITE.SUGGEST' );
	+
	+ $sql = 'SELECT EventId FROM ' . TABLE_PREFIX . 'Events
	+ WHERE Event IN ("' . implode('","', $events_to_delete) . '")';
	$event_ids = $this->Conn->GetCol($sql);

	if ($event_ids) {
	- $sql = 'DELETE FROM EmailMessages WHERE EventId IN (' . implode(',', $event_ids) . ')';
	+ $sql = 'DELETE FROM ' . TABLE_PREFIX . 'EmailMessage
	+ WHERE EventId IN (' . implode(',', $event_ids) . ')';
	+ $this->Conn->Query($sql);
	+
	+ $sql = 'DELETE FROM ' . TABLE_PREFIX . 'Events
	+ WHERE EventId IN (' . implode(',', $event_ids) . ')';
	$this->Conn->Query($sql);

	- $sql = 'DELETE FROM Events WHERE EventId IN (' . implode(',', $event_ids) . ')';
	+ $sql = 'DELETE FROM ' . TABLE_PREFIX . 'Phrase
	+ WHERE Phrase IN ("la_event_user.suggest_site")';
	$this->Conn->Query($sql);
	}
	}
	}

	}
	\ No newline at end of file
	Index: branches/5.0.x/in-commerce/install/upgrades.sql
	===================================================================
	--- branches/5.0.x/in-commerce/install/upgrades.sql (revision 12430)
	+++ branches/5.0.x/in-commerce/install/upgrades.sql (revision 12431)
	@@ -1,62 +1,60 @@
	# ===== v 4.3.9 =====

	INSERT INTO ImportScripts VALUES (DEFAULT, 'Products from CSV file [In-Commerce]', '', 'p', 'In-Commerce', '', 'CSV', '1');

	ALTER TABLE Products ADD OnSale TINYINT(1) NOT NULL default '0' AFTER Featured, ADD INDEX (OnSale);

	UPDATE Phrase SET Module = 'In-Commerce' WHERE Phrase IN ('lu_comm_Images', 'lu_comm_ImagesHeader');

	# ===== v 5.0.0 =====
	UPDATE Category SET Template = '/in-commerce/designs/section' WHERE Template = 'in-commerce/store/category';
	UPDATE Category SET CachedTemplate = '/in-commerce/designs/section' WHERE CachedTemplate = 'in-commerce/store/category';

	UPDATE ConfigurationValues SET VariableValue = '/in-commerce/designs/section' WHERE VariableName = 'p_CategoryTemplate';
	UPDATE ConfigurationValues SET VariableValue = 'in-commerce/designs/detail' WHERE VariableName = 'p_ItemTemplate';

	DELETE FROM PersistantSessionData WHERE VariableName IN ('affil_columns_.', 'ap_columns_.', 'apayments_columns_.', 'apayments.log_columns_.', 'd_columns_.', 'coup_columns_.', 'file_columns_.', 'po_columns_.', 'z_columns_.', 'tax_columns_.');
	DELETE FROM PersistantSessionData WHERE VariableName LIKE '%ord.%';

	INSERT INTO Permissions VALUES (DEFAULT, 'in-commerce:products.view', 11, 1, 1, 0);
	INSERT INTO Permissions VALUES (DEFAULT, 'in-commerce:setting_folder.view', 11, 1, 1, 0);

	INSERT INTO ShippingQuoteEngines VALUES (DEFAULT, 'USPS.com', 0, 0, 0, 'a:21:{s:12:"AccountLogin";s:0:"";s:15:"AccountPassword";N;s:10:"UPSEnabled";N;s:10:"UPSAccount";s:0:"";s:11:"UPSInvoiced";N;s:10:"FDXEnabled";N;s:10:"FDXAccount";s:0:"";s:10:"DHLEnabled";N;s:10:"DHLAccount";s:0:"";s:11:"DHLInvoiced";N;s:10:"USPEnabled";N;s:10:"USPAccount";s:0:"";s:11:"USPInvoiced";N;s:10:"ARBEnabled";N;s:10:"ARBAccount";s:0:"";s:11:"ARBInvoiced";N;s:10:"1DYEnabled";N;s:10:"2DYEnabled";N;s:10:"3DYEnabled";N;s:10:"GNDEnabled";N;s:10:"ShipMethod";N;}', 'USPS');

	INSERT INTO ConfigurationAdmin VALUES ('Comm_CompanyName', 'la_Text_ContactsGeneral', 'la_text_CompanyName', 'text', NULL, NULL, 10.01, 0, 0);
	INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Comm_CompanyName', '', 'In-Commerce', 'in-commerce:contacts');

	UPDATE ConfigurationAdmin SET prompt = 'la_text_StoreName', DisplayOrder = 10.02 WHERE VariableName = 'Comm_StoreName';

	INSERT INTO ConfigurationAdmin VALUES ('Comm_Contacts_Name', 'la_Text_ContactsGeneral', 'la_text_ContactName', 'text', NULL, NULL, 10.03, 0, 0);
	INSERT INTO ConfigurationValues VALUES (DEFAULT, 'Comm_Contacts_Name', '', 'In-Commerce', 'in-commerce:contacts');

	UPDATE ConfigurationAdmin SET DisplayOrder = 10.04 WHERE VariableName = 'Comm_Contacts_Phone';
	UPDATE ConfigurationAdmin SET DisplayOrder = 10.05 WHERE VariableName = 'Comm_Contacts_Fax';
	UPDATE ConfigurationAdmin SET DisplayOrder = 10.06 WHERE VariableName = 'Comm_Contacts_Email';
	UPDATE ConfigurationAdmin SET DisplayOrder = 10.07 WHERE VariableName = 'Comm_Contacts_Additional';

	DELETE FROM Phrase WHERE Phrase IN ('la_fld_ManufacturerId', 'la_fld_DiscountId', 'la_fld_CouponId', 'la_fld_AffiliatePlanId', 'la_fld_AffiliateId', 'la_fld_ZoneId', 'la_fld_EngineId', 'la_fld_ShippingId', 'la_fld_ProductId', 'la_fld_OptionId', 'la_fld_CurrencyId');

	UPDATE Phrase SET Module = 'In-Commerce' WHERE ((Phrase LIKE '%Product%' OR Phrase LIKE '%Shipping%' OR Phrase LIKE '%Coupon%' OR Phrase LIKE '%Discount%' OR Phrase LIKE '%Report%' OR Phrase LIKE '%Currency%' OR Phrase LIKE '%Cart%') AND (Module = 'Core'));

	# ===== v 5.0.1 =====
	UPDATE ConfigurationValues SET VariableValue = 'in-commerce/products/product_detail' WHERE VariableName = 'p_ItemTemplate';

	UPDATE ConfigurationAdmin SET ValueList = '1=la_opt_Session,2=la_opt_PermanentCookie' WHERE VariableName = 'Comm_AffiliateStorageMethod';

	UPDATE ConfigurationAdmin SET ValueList = 'ASC=la_common_Ascending,DESC=la_common_Descending'
	WHERE VariableName = 'product_OrderProductsByDir';

	UPDATE ConfigurationAdmin SET ValueList = 'ASC=la_common_Ascending,DESC=la_common_Descending'
	WHERE VariableName = 'product_OrderProductsThenByDir';

	UPDATE ConfigurationAdmin SET ValueList = '1=la_opt_PriceCalculationByPrimary,2=la_opt_PriceCalculationByOptimal'
	WHERE VariableName = 'Comm_PriceBracketCalculation';

	UPDATE ConfigurationAdmin SET ValueList = '1=la_opt_Sec,60=la_opt_Min,3600=la_opt_Hour,86400=la_opt_Day,604800=la_opt_Week,2419200=la_opt_Month,29030400=la_opt_Year' WHERE VariableName = 'product_ReviewDelay_Interval';
	UPDATE ConfigurationAdmin SET ValueList = '1=la_opt_Sec,60=la_opt_Min,3600=la_opt_Hour,86400=la_opt_Day,604800=la_opt_Week,2419200=la_opt_Month,29030400=la_opt_Year' WHERE VariableName = 'product_RatingDelay_Interval';

	UPDATE CustomField SET FieldLabel = 'la_fld_cust_p_ItemTemplate', Prompt = 'la_fld_cust_p_ItemTemplate' WHERE FieldName = 'p_ItemTemplate';

	-DELETE FROM Phrase WHERE Phrase IN ('la_event_user.suggest_site');
	-
	UPDATE Events SET Type = 1 WHERE Event = 'BACKORDER.FULLFILL';
	\ 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