<?php
/**
* @version	$Id: orders_config.php 16292 2015-10-25 11:14:31Z alex $
* @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!');

	$config =	Array (
					'Prefix'			=>	'ord',
					'ItemClass'			=>	Array ('class' => 'OrdersItem', 'file' => 'orders_item.php', 'build_event' => 'OnItemBuild'),
					'ListClass'			=>	Array ('class' => 'kDBList', 'file' => '', 'build_event' => 'OnListBuild'),
					'EventHandlerClass'	=>	Array ('class' => 'OrdersEventHandler', 'file' => 'orders_event_handler.php', 'build_event' => 'OnBuild'),
					'TagProcessorClass' =>	Array ('class' => 'OrdersTagProcessor', 'file' => 'orders_tag_processor.php', 'build_event' => 'OnBuild'),
					'ValidatorClass' => 'OrderValidator',

					'AutoLoad'			=>	true,

					'RegisterClasses' => Array (
						Array ('pseudo' => 'OrderCalculator', 'class' => 'OrderCalculator', 'file' => 'order_calculator.php', 'build_event' => ''),
						Array ('pseudo' => 'OrderManager', 'class' => 'OrderManager', 'file' => 'order_manager.php', 'build_event' => ''),
						Array ('pseudo' => 'OrderValidator', 'class' => 'OrderValidator', 'file' => 'order_validator.php', 'build_event' => ''),
					),

					'Hooks'				=>	Array (
						Array (
							'Mode' => hAFTER,
							'Conditional' => false,
							'HookToPrefix' => 'ord',
							'HookToSpecial' => '',
							'HookToEvent' => Array ( 'OnPreSave' ),
							'DoPrefix' => '',
							'DoSpecial' => '',
							'DoEvent' => 'OnRecalculateItems',
						),

						Array(
							'Mode' => hBEFORE,
							'Conditional' => false,
							'HookToPrefix' => '',
							'HookToSpecial' => '',
							'HookToEvent' => Array( 'OnUpdateCart', 'OnUpdateCartJSON', 'OnCheckout' ),
							'DoPrefix' => '',
							'DoSpecial' => '',
							'DoEvent' => 'OnApplyCoupon',
						),

 						Array (
							'Mode' => hBEFORE,
 							'Conditional' => false,
							'HookToPrefix' => '',
 							'HookToSpecial' => '',
							'HookToEvent' => Array( 'OnUpdateCart', 'OnUpdateCartJSON', 'OnCheckout' ),
 							'DoPrefix' => '',
 							'DoSpecial' => '',
							'DoEvent' => 'OnApplyGiftCertificate',
						),

						Array (
							'Mode' => hAFTER,
							'Conditional' => false,
							'HookToPrefix' => 'u',
							'HookToSpecial' => '',
							'HookToEvent' => Array ( 'OnCreate' ),
							'DoPrefix' => '',
							'DoSpecial' => '',
							'DoEvent' => 'OnUserCreate',
						),

						Array (
							'Mode' => hBEFORE,
							'Conditional' => false,
							'HookToPrefix' => 'u',
							'HookToSpecial' => '',
							'HookToEvent' => Array ('OnCheckExpiredMembership'),
							'DoPrefix' => '',
							'DoSpecial' => '',
							'DoEvent' => 'OnCheckRecurringOrders',
						),

						Array (
							'Mode' => hAFTER,
							'Conditional' => false,
							'HookToPrefix' => 'u',
							'HookToSpecial' => '',
							'HookToEvent' => Array ( 'OnAfterLogin' ),
							'DoPrefix' => '',
							'DoSpecial' => '',
							'DoEvent' => 'OnUserLogin',
						),

						Array (
							'Mode' => hBEFORE, // before because OnInpLogin is called after real in-portal login and uses data from hooks
							'Conditional' => false,
							'HookToPrefix' => 'u',
							'HookToSpecial' => '',
							'HookToEvent' => Array ( 'OnInpLogin' ),
							'DoPrefix' => '',
							'DoSpecial' => '',
							'DoEvent' => 'OnUserLogin',
						),
						Array(
							'Mode' => hAFTER,
							'Conditional' => false,
							'HookToPrefix' => 'adm',
							'HookToSpecial' => '*',
							'HookToEvent' => Array('OnStartup'),
							'DoPrefix' => '',
							'DoSpecial' => '',
							'DoEvent' => 'OnRestoreOrder',
						),
						array(
							'Mode' => hAFTER,
							'Conditional' => false,
							'HookToPrefix' => 'conf',
							'HookToSpecial' => '',
							'HookToEvent' => array('OnBeforeItemValidate'),
							'DoPrefix' => '',
							'DoSpecial' => '',
							'DoEvent' => 'OnBeforeNextOrderNumberChange',
						),
					),
					'AggregateTags' => Array (
							Array (
								'AggregateTo' => 'orditems',
								'AggregatedTagName' => 'LinkRemoveFromCart',
								'LocalTagName' => 'Orditems_LinkRemoveFromCart',
							),
							Array (
								'AggregateTo' => 'orditems',
								'AggregatedTagName' => 'ProductLink',
								'LocalTagName' => 'Orderitems_ProductLink',
							),
							Array (
								'AggregateTo' => 'orditems',
								'AggregatedTagName' => 'ProductExists',
								'LocalTagName' => 'Orderitems_ProductExists',
							),
					),

					'QueryString' => Array (
						1 => 'id',
						2 => 'Page',
						3 => 'PerPage',
						4 => 'event',
						5 => 'mode',
					),
					'IDField'			=>	'OrderId',
					'StatusField'		=>	Array ('Status'),	// field, that is affected by Approve/Decline events

					'ViewMenuPhrase'	=>	'la_title_Orders',
					'CatalogTabIcon' => 'icon16_item.png',

					'TitleField' => 'OrderNumber',
					'TitlePresets'		=>	Array (
						'default'	=>	Array (
							'new_status_labels'		=> Array ('ord' => '!la_title_Adding_Order!'),
							'edit_status_labels'	=> Array ('ord' => '!la_title_Editing_Order!'),
							'new_titlefield'		=> Array ('ord' => '!la_title_New_Order!'),
						),

						'orders_incomplete'	=>	Array (	'prefixes'				=>	Array ('ord.incomplete_List'),
														'format'				=>	"!la_title_IncompleteOrders!",
										),

						'orders_pending'	=>	Array (	'prefixes'				=>	Array ('ord.pending_List'),
														'format'				=>	"!la_title_PendingOrders!",
										),

						'orders_backorders'	=>	Array (	'prefixes'				=>	Array ('ord.backorders_List'),
														'format'				=>	"!la_title_BackOrders!",
										),

						'orders_toship'		=>	Array (	'prefixes'				=>	Array ('ord.toship_List'),
														'format'				=>	"!la_title_OrdersToShip!",
										),

						'orders_processed'	=>	Array (	'prefixes'				=>	Array ('ord.processed_List'),
														'format'				=>	"!la_title_OrdersProcessed!",
										),

						'orders_returns'	=>	Array (	'prefixes'				=>	Array ('ord.returns_List'),
														'format'				=>	"!la_title_OrdersReturns!",
										),

						'orders_denied'		=>	Array (	'prefixes'				=>	Array ('ord.denied_List'),
														'format'				=>	"!la_title_OrdersDenied!",
										),
						'orders_archived'	=>	Array (	'prefixes'				=>	Array ('ord.archived_List'),
														'format'				=>	"!la_title_OrdersArchived!",
										),

						'orders_search'		=>	Array (	'prefixes'				=>	Array ('ord.search_List'),
														'format'				=>	"!la_title_OrdersSearch!",
										),

						'orders_edit_general'	=>	Array ('prefixes' => Array ('ord'), 'format' => "#ord_status# '#ord_titlefield#' - !la_title_General!"),
						'orders_edit_billing'	=>	Array ('prefixes' => Array ('ord'), 'format' => "#ord_status# '#ord_titlefield#' - !la_title_OrderBilling!"),
						'orders_edit_shipping'	=>	Array ('prefixes' => Array ('ord'), 'format' => "#ord_status# '#ord_titlefield#' - !la_title_OrderShipping!"),
						'orders_edit_items'		=>	Array ('prefixes' => Array ('ord', 'orditems_List'), 'format' => "#ord_status# '#ord_titlefield#' - !la_title_OrderItems!"),
						'orders_edit_preview'	=>	Array ('prefixes' => Array ('ord'), 'format' => "#ord_status# '#ord_titlefield#' - !la_title_OrderPreview!"),

						'orders_gw_result' => Array ('prefixes' => Array ('ord'), 'format' => "!la_title_OrderGWResult!"),

						'orders_export' => Array ('format' => '!la_title_OrdersExport!'),

						'orders_product_edit' => Array ('format' => '!la_title_Editing_Order_Item!'),
					),

					'EditTabPresets' => Array (
						'Default' => Array (
							'general' => Array ('title' => 'la_tab_General', 't' => 'in-commerce/orders/orders_edit', 'priority' => 1),
							'items' => Array ('title' => 'la_tab_Items', 't' => 'in-commerce/orders/orders_edit_items', 'priority' => 2),
							'shipping' => Array ('title' => 'la_tab_Shipping', 't' => 'in-commerce/orders/orders_edit_shipping', 'priority' => 3),
							'billing' => Array ('title' => 'la_tab_Billing', 't' => 'in-commerce/orders/orders_edit_billing', 'priority' => 4),
							'preview' => Array ('title' => 'la_tab_Preview', 't' => 'in-commerce/orders/orders_edit_preview', 'priority' => 5),
						),
					),

					'PermSection'		=>	Array ('main' => 'in-commerce:orders'),


					'Sections'			=>	Array (
						'in-commerce:orders'	=>	Array (
								'parent'		=>	'in-commerce',
								'icon'			=>	'in-commerce:orders',
								'label'			=>	'la_tab_Orders',
								'url'			=>	Array ('t' => 'in-commerce/orders/orders_pending_list', 'pass' => 'm'),
								'permissions'	=>	Array ('view', 'add', 'edit', 'delete', 'advanced:approve', 'advanced:deny', 'advanced:archive', 'advanced:place', 'advanced:process', 'advanced:ship', 'advanced:reset_to_pending'),
								'priority'		=>	1,
								'type'			=>	stTREE,
						),
					),

					'SectionAdjustments' => Array (
						'in-portal:visits' => Array (
							'url' => Array ('t' => 'in-commerce/visits/visits_list_incommerce', 'pass' => 'm'),
						),
					),

					'StatisticsInfo'	=>	Array (
													'pending'	=>	Array (
																			'icon'		=>	'core:icon16_item.png',
																			'label'		=>	'la_title_Orders',
																			'js_url' 	=>	"#url#",
																			'url'		=>	Array ('t' => 'in-commerce/orders/orders_pending_list', 'pass' => 'm'),
																			'status'	=>	ORDER_STATUS_PENDING,

																	),
											),

					'TableName' => TABLE_PREFIX . 'Orders',

					'CalculatedFields' => Array (
						'' => Array (
							'CustomerName'			=>	'IF( ISNULL(u.Username), IF (%1$s.PortalUserId = ' . USER_ROOT . ', "root", IF (%1$s.PortalUserId = ' . USER_GUEST . ', "Guest", "n/a")), CONCAT(u.FirstName," ",u.LastName) )',
							'Username'				=>	'IF( ISNULL(u.Username),"root",IF(u.Username = "", u.Email, u.Username))',
							'OrderNumber'			=>	'CONCAT(LPAD(Number,6,"0"),\'-\',LPAD(SubNumber,3,"0") )',
							'SubtotalWithoutDiscount'	=>	'(SubTotal + DiscountTotal)',
							'SubtotalWithDiscount'	=>	'(SubTotal)',
							'AmountWithoutVAT'		=>	'(SubTotal+IF(ShippingTaxable=1, ShippingCost, 0)+IF(ProcessingTaxable=1, ProcessingFee, 0)-IF(VATIncluded=1,VAT,0))',
							'TotalAmount'			=>	'SubTotal+ShippingCost+IF(VATIncluded=1,0,VAT)+ProcessingFee+InsuranceFee-GiftCertificateDiscount',
							'CouponCode'			=>	'pc.Code',
							'CouponName'			=>	'pc.Name',
							'AffiliateUser'			=>	'IF(au.PortalUserId IS NULL, "!la_None!", IF(au.Username = "", au.Email, au.Username))',
							'AffiliatePortalUserId'	=>	'af.PortalUserId',
							'GiftCertificateCode'	=>	'gc.Code',
							'GiftCertificateRecipient' => 'gc.Recipient',
							'ShippingSubTotal'		=>	'%1$s.ShippingCost + %1$s.InsuranceFee',
						),

						'myorders' => Array (
							'OrderNumber'			=>	'CONCAT(LPAD(Number,6,"0"),\'-\',LPAD(SubNumber,3,"0") )',
							'SubtotalWithoutDiscount'	=>	'(SubTotal + DiscountTotal)',
							'SubtotalWithDiscount'	=>	'(SubTotal)',
							'AmountWithoutVAT'		=>	'(SubTotal+IF(ShippingTaxable=1, ShippingCost, 0)+IF(ProcessingTaxable=1, ProcessingFee, 0)-IF(VATIncluded=1,VAT,0))',
							'TotalAmount'			=>	'SubTotal+ShippingCost+IF(VATIncluded=1,0,VAT)+ProcessingFee+InsuranceFee-GiftCertificateDiscount',
							/*'ItemsCount'			=>	'COUNT(%1$s.OrderId)',*/
							'ShippingSubTotal'		=>	'%1$s.ShippingCost + %1$s.InsuranceFee',
						),
					),
					// %1$s - table name of object
					// %2$s - calculated fields
					'ListSQLs' => Array (
						'' => '	SELECT %1$s.* %2$s
								FROM %1$s
								LEFT JOIN '.TABLE_PREFIX.'Users u ON %1$s.PortalUserId = u.PortalUserId
								LEFT JOIN '.TABLE_PREFIX.'ProductsCoupons pc ON %1$s.CouponId = pc.CouponId
								LEFT JOIN '.TABLE_PREFIX.'GiftCertificates gc ON %1$s.GiftCertificateId = gc.GiftCertificateId
								LEFT JOIN '.TABLE_PREFIX.'Affiliates af ON %1$s.AffiliateId = af.AffiliateId
								LEFT JOIN '.TABLE_PREFIX.'Users au ON af.PortalUserId = au.PortalUserId',

						'myorders' => '	SELECT %1$s.* %2$s
										FROM %1$s
										LEFT JOIN '.TABLE_PREFIX.'Users u ON %1$s.PortalUserId = u.PortalUserId',
//										LEFT JOIN '.TABLE_PREFIX.'OrderItems ON %1$s.OrderId = '.TABLE_PREFIX.'OrderItems.OrderId',
					),

					'ItemSQLs' => Array (
						'' => '	SELECT %1$s.* %2$s FROM %1$s
								LEFT JOIN '.TABLE_PREFIX.'Users u ON %1$s.PortalUserId = u.PortalUserId
								LEFT JOIN '.TABLE_PREFIX.'ProductsCoupons pc ON %1$s.CouponId = pc.CouponId
								LEFT JOIN '.TABLE_PREFIX.'GiftCertificates gc ON %1$s.GiftCertificateId = gc.GiftCertificateId
								LEFT JOIN '.TABLE_PREFIX.'Affiliates af ON %1$s.AffiliateId = af.AffiliateId
								LEFT JOIN '.TABLE_PREFIX.'Users au ON af.PortalUserId = au.PortalUserId',
					),

					'SubItems'	=> Array ('orditems'),
					'ListSortings'	=> 	Array (
																'' => Array (
																	'Sorting' => Array ('OrderDate' => 'desc'),
																)
															),
					'Fields' => Array (
			            'OrderId' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0, 'filter_type' => 'equals'),
			            'Number' => Array ('type' => 'int', 'required' =>1, 'formatter' => 'kFormatter', 'unique' =>Array ('SubNumber'), 'format' => '%06d', 'max_value_inc'>999999, 'not_null' => 1, 'default' => 0),
			            'SubNumber' => Array ('type' => 'int', 'required' =>1, 'formatter' => 'kFormatter', 'unique' =>Array ('Number'), 'format' => '%03d', 'max_value_inc'>999, 'not_null' => 1, 'default' => 0),
			            'Status' => Array ('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' =>Array (0=> 'la_Incomplete',1=> 'la_Pending',2=> 'la_BackOrders',3=> 'la_ToShip',4=> 'la_Processed',5=> 'la_Denied',6=> 'la_Archived'), 'use_phrases' =>1, 'not_null' => 1, 'default' => 0, 'filter_type' => 'equals'),
						'OnHold' => Array (
							'type' => 'int',
							'formatter' => 'kOptionsFormatter',
							'options' => Array (0 => 'la_No', 1 => 'la_Yes'), 'use_phrases' => 1,
							'not_null' => 1, 'default' => 0,
						),
			            'OrderDate' => Array ('type' => 'int', 'formatter' => 'kDateFormatter', 'required' => 1, 'default' => '#NOW#'),
			            'PortalUserId' =>Array ('type' => 'int', 'formatter' => 'kLEFTFormatter', 'error_msgs' => Array ('invalid_option' => '!la_error_UserNotFound!'), 'options' =>Array (USER_ROOT => 'root', USER_GUEST => 'Guest'), 'left_sql' => 'SELECT %s FROM '.TABLE_PREFIX.'Users WHERE %s', 'left_key_field' => 'PortalUserId', 'left_title_field' => USER_TITLE_FIELD, 'required' =>1, 'not_null' =>1, 'default' =>-1),
			            'OrderIP' => Array ('type' => 'string', 'not_null' => 1, 'default' => '', 'filter_type' => 'like'),
			            'UserComment' => Array ('type' => 'string', 'formatter' => 'kFormatter', 'using_fck' => 1, 'default' => NULL),
			            'AdminComment' => Array ('type' => 'string', 'formatter' => 'kFormatter', 'using_fck' => 1, 'default' => NULL),
			            'BillingTo' => Array ('type' => 'string', 'not_null' => 1, 'default' => ''),
			            'BillingCompany' => Array ('type' => 'string', 'not_null' => 1, 'default' => ''),
			            'BillingPhone' => Array ('type' => 'string', 'not_null' => 1, 'default' => ''),
			            'BillingFax' => Array ('type' => 'string', 'not_null' => 1, 'default' => ''),
			            'BillingEmail' => Array (
			            	'type' => 'string',
			            	'formatter' => 'kFormatter',
			            	'regexp' => '/^(' . REGEX_EMAIL_USER . '@' . REGEX_EMAIL_DOMAIN . ')$/i',
							'error_msgs' => Array ('invalid_format' => '!la_invalid_email!', 'unique' => '!lu_email_already_exist!'),
			            	'not_null' => 1, 'default' => '',
						),
			            'BillingAddress1' => Array ('type' => 'string', 'not_null' => 1, 'default' => ''),
			            'BillingAddress2' => Array ('type' => 'string', 'not_null' => 1, 'default' => ''),
			            'BillingCity' => Array ('type' => 'string', 'not_null' => 1, 'default' => ''),
			            'BillingState' => Array (
			            	'type' => 'string',
			            	'formatter' => 'kOptionsFormatter',
			            	'options' => Array (),
							'option_key_field' => 'DestAbbr',
							'option_title_field' => 'Translation',
							'not_null' => 1, 'default' => '',
						),
			            'BillingZip' => Array ('type' => 'string', 'not_null' => 1, 'default' => ''),
						'BillingCountry' => Array(
							'type' => 'string',
							'formatter' => 'kOptionsFormatter',
							'options_sql' => '	SELECT IF(l%2$s_Name = "", l%3$s_Name, l%2$s_Name) AS Name, IsoCode
												FROM '.TABLE_PREFIX.'CountryStates
												WHERE Type = ' . DESTINATION_TYPE_COUNTRY . '
												ORDER BY Name',
							'option_key_field' => 'IsoCode', 'option_title_field' => 'Name',
							'not_null' => 1, 'default' => 'USA'
						),
			            'VAT' => Array ('type' => 'float', 'formatter' => 'kFormatter', 'not_null' =>1, 'default' => '0', 'format' => '%01.2f'),
			            'VATPercent' => Array ('type' => 'float', 'formatter' => 'kFormatter', 'not_null' =>1, 'default' => '0', 'format' => '%01.3f'),
			            'VATIncluded' => Array (
							'type' => 'int',
							'formatter' => 'kOptionsFormatter',
							'options' => Array (0 => 'la_No', 1 => 'la_Yes'), 'use_phrases' => 1,
							'not_null' => 1, 'default' => 0,
						),
			            'PaymentType' => Array (
			            	'type' => 'int',
			            	'formatter' => 'kOptionsFormatter',
			            	'options_sql' => 'SELECT IF(l%2$s_Description <> "", l%2$s_Description, l%3$s_Description) AS Description, PaymentTypeId
			            						FROM ' . TABLE_PREFIX . 'PaymentTypes
	        		    						WHERE Status = 1
	            								ORDER BY Priority DESC, Name ASC',
							'option_key_field' => 'PaymentTypeId', 'option_title_field' => 'Description',
							'not_null' => 1, 'default' => 0
						),

			            'PaymentAccount' => Array ('type' => 'string', 'not_null' => 1, 'cardtype_field' => 'PaymentCardType', 'default' => '', 'filter_type' => 'like'),
			            'PaymentNameOnCard' => Array ('type' => 'string', 'not_null' => 1, 'default' => ''),
			            'PaymentCCExpDate' => Array ('type' => 'string', 'formatter' => 'kCCDateFormatter', 'month_field' => 'PaymentCCExpMonth', 'year_field' => 'PaymentCCExpYear', 'not_null' => 1, 'default' => ''),
			            'PaymentCardType' => Array ('type' => 'string', 'not_null' => 1, 'formatter' => 'kOptionsFormatter', 'options' => Array ('' => '', '1' => 'Visa', '2' => 'Mastercard', '3' => 'Amex', '4' => 'Discover', '5' => 'Diners Club', '6' => 'JBC'), 'default' => ''),
			            'PaymentExpires' => Array ('type' => 'int', 'formatter' => 'kDateFormatter', 'default' => '#NOW#'),
			            'ShippingTo' => Array ('type' => 'string', 'not_null' => 1, 'default' => ''),
			            'ShippingCompany' => Array ('type' => 'string', 'not_null' => 1, 'default' => ''),
			            'ShippingPhone' => Array ('type' => 'string', 'not_null' => 1, 'default' => ''),
			            'ShippingFax' => Array ('type' => 'string', 'not_null' => 1, 'default' => ''),
			            'ShippingEmail' => Array (
			            	'type' => 'string',
			            	'formatter' => 'kFormatter',
			            	'regexp' => '/^(' . REGEX_EMAIL_USER . '@' . REGEX_EMAIL_DOMAIN . ')$/i',
							'error_msgs' => Array ('invalid_format' => '!la_invalid_email!'),
			            	'not_null' => 1, 'default' => '',
						),
			            'ShippingAddress1' => Array ('type' => 'string', 'not_null' => 1, 'default' => ''),
			            'ShippingAddress2' => Array ('type' => 'string', 'not_null' => 1, 'default' => ''),
			            'ShippingCity' => Array ('type' => 'string', 'not_null' => 1, 'default' => ''),
			            'ShippingState' => Array (
			            	'type' => 'string', 'formatter' => 'kOptionsFormatter',
			            							'options' => Array (),
								            		'option_key_field' => 'DestAbbr', 'option_title_field' => 'Translation',
								            		'not_null' => 1, 'default' => ''),
			            'ShippingZip' => Array ('type' => 'string', 'not_null' => 1, 'default' => ''),
						'ShippingCountry' => Array(
							'type' => 'string', 'formatter' => 'kOptionsFormatter',
							'options_sql' => '	SELECT IF(l%2$s_Name = "", l%3$s_Name, l%2$s_Name) AS Name, IsoCode
												FROM '.TABLE_PREFIX.'CountryStates
												WHERE Type = ' . DESTINATION_TYPE_COUNTRY . '
												ORDER BY Name',
							'option_key_field' => 'IsoCode', 'option_title_field' => 'Name',
							'not_null' => 1, 'default' => 'USA'
						),
			            'ShippingType' => Array (
			            	'type' => 'int',
			            	'formatter' => 'kOptionsFormatter',
			            	'options_sql' => 'SELECT %s
			            							FROM ' . TABLE_PREFIX . 'ShippingType
			            						WHERE Status = 1',
							'option_key_field' => 'ShippingID',
							'option_title_field' => 'Name',
							'not_null' => 1, 'default' => 0,
						),
			            'ShippingCost' => Array ('type' => 'double', 'formatter' => 'kFormatter', 'format' => '%01.2f', 'not_null' => 1, 'default' => '0.00'),
			            'ShippingCustomerAccount' => Array ('type' => 'string', 'not_null' => 1, 'default' => ''),
			            'ShippingTracking' => Array ('type' => 'string', 'not_null' => 1, 'default' => ''),
			            'ShippingDate' => Array ('type' => 'int', 'formatter' => 'kDateFormatter', 'default' => null),
			            'SubTotal' => Array ('type' => 'float', 'formatter' => 'kFormatter', 'format' => '%01.2f', 'not_null' => 1, 'default' => '0.00'),
			            'ReturnTotal' => Array ('type' => 'float', 'formatter' => 'kFormatter', 'format' => '%01.2f', 'not_null' => 1, 'default' => '0.00'),
			            'CostTotal' => Array ('type' => 'float', 'formatter' => 'kFormatter', 'format' => '%01.2f', 'not_null' => 1, 'default' => '0.00'),
			            'OriginalAmount'	=>	Array ('type' => 'float', 'formatter' => 'kFormatter', 'format' => '%01.2f', 'not_null' => 1, 'default' => '0.00'),
			            'ShippingOption' => Array (
			            	'type' => 'int',
			            	'formatter' => 'kOptionsFormatter',
			            	'options' => Array (
								0 => 'la_ship_all_together', 1 => 'la_ship_backorder_separately', 2 => 'la_ship_backorders_upon_avail',
							),
							'use_phrases' => 1, 'not_null' => 1, 'default' => 0,
						),
			            'ShippingGroupOption' => Array (
			            	'type' => 'int',
			            	'formatter' => 'kOptionsFormatter', 'use_phrases' => 1,
			            	'options' => Array (0 => 'la_opt_AutoGroupShipments', 1 => 'la_opt_ManualGroupShipments'),
							'not_null' => 1, 'default' => 0,
						),
			            'GiftCertificateId' => Array ('type' => 'int', 'default' => null),
			            'GiftCertificateDiscount' => Array ('type' => 'float', 'formatter' => 'kFormatter', 'format' => '%01.2f', 'not_null' => 1, 'default' => '0.00',),
			            'ShippingInfo' => Array ('type' => 'string', 'default' => NULL),
			            'CouponId' => Array ('type' => 'int', 'default' => null),
			            'CouponDiscount' => Array ('type' => 'float', 'not_null' => 1, 'default' => '0.00', 'formatter' => 'kFormatter', 'format' => '%01.2f'),
			            'DiscountTotal' => Array ('type' => 'float', 'not_null' => 1, 'default' => '0.00', 'formatter' => 'kFormatter', 'format' => '%01.2f'),
			            'TransactionStatus' => Array (
			            	'type' => 'int',
			            	'formatter' => 'kOptionsFormatter',
			            	'options' => Array (0 => 'la_opt_Invalid', 1 => 'la_opt_Verified', 2 => 'la_opt_Pending'),
							'use_phrases' =>1, 'not_null' => 1, 'default' => 2,
						),
						'GWResult1' => Array ('type' => 'string', 'formatter' => 'kSerializedFormatter', 'default' => NULL),
			            'GWResult2' => Array ('type' => 'string', 'formatter' => 'kSerializedFormatter', 'default' => NULL),
			            'AffiliateId' => Array ('type' => 'int', 'formatter' => 'kLEFTFormatter', 'error_msgs' => Array ('invalid_option' => '!la_error_UserNotFound!'),  'options' => Array (0 => 'lu_None'), 'left_sql' => 'SELECT %s FROM '.TABLE_PREFIX.'Affiliates af LEFT JOIN '.TABLE_PREFIX.'Users u ON u.PortalUserId = af.PortalUserId WHERE %s', 'left_key_field' => 'AffiliateId', 'left_title_field' => 'IF(u.Email = "", u.Username, u.Email)', 'not_null' =>1, 'default' =>0),
			            'VisitId' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0),
            			'AffiliateCommission' => Array ('type' => 'double', 'formatter' => 'kFormatter', 'format' => '%.02f', 'not_null' => 1, 'default' => '0.0000'),
            			'ProcessingFee' => Array ('type' => 'double', 'formatter' => 'kFormatter', 'format' => '%.02f', 'not_null' => '0', 'default' => '0.0000'),
            			'InsuranceFee' => Array ('type' => 'float', 'formatter' => 'kFormatter', 'format' => '%01.2f', 'not_null' => 1, 'default' => '0.00'),
            			'ShippingTaxable'		=>	Array ('type' => 'int', 'not_null' => 0, 'default' => 0),
            			'ProcessingTaxable'		=>	Array ('type' => 'int', 'not_null' => 0, 'default' => 0),
            			'IsRecurringBilling'	=> Array (
							'type' => 'int',
							'formatter' => 'kOptionsFormatter',
							'options' => Array (0 => 'la_No', 1 => 'la_Yes',), 'use_phrases' => 1,
							'default' => 0, 'not_null' => 1,
						),
            			'ChargeOnNextApprove'	=> Array (
							'type' => 'int',
							'formatter' => 'kOptionsFormatter',
							'options' => Array (0 => 'la_No', 1 => 'la_Yes',), 'use_phrases' => 1,
							'default' => 0, 'not_null' => 1,
						),
            			'NextCharge'			=>	Array ('type' => 'int', 'formatter' => 'kDateFormatter', 'default' => null),
            			'GroupId'			=>	Array ('type' => 'int', 'not_null' => 1, 'default' => 0),
						'GoogleOrderNumber' => Array ('type' => 'string', 'default' => NULL), // MySQL BIGINT UNSIGNED = 8 Bytes, PHP int = 4 Bytes -> threat as string
			        ),

					'VirtualFields'	=> 	Array (
						'CustomerName'			=>	Array ('type' => 'string', 'default' => '', 'filter_type' => 'like'),
						'TotalAmount'			=>	Array ('type' => 'float', 'formatter' => 'kFormatter', 'format' => '%01.2f', 'default' => '0.00'),
						'AmountWithoutVAT'		=>	Array ('type' => 'float', 'formatter' => 'kFormatter', 'format' => '%01.2f', 'default' => '0.00'),
						'SubtotalWithDiscount'	=>	Array ('type' => 'float', 'formatter' => 'kFormatter', 'format' => '%01.2f', 'default' => '0.00'),
						'SubtotalWithoutDiscount'	=>	Array ('type' => 'float', 'formatter' => 'kFormatter', 'format' => '%01.2f', 'default' => '0.00'),
						'ShippingSubTotal' => Array ('type' => 'float', 'formatter' => 'kFormatter', 'format' => '%01.2f', 'default' => '0.00'),
						'OrderNumber'			=>	Array ('type' => 'string', 'default' => '', 'filter_type' => 'like'),
						'CouponCode'			=>	Array ('type' => 'string', 'default' => ''),
						'CouponName'			=>	Array ('type' => 'string', 'default' => ''),
						'GiftCertificateCode'	=>	Array ('type' => 'string', 'default' => ''),
						'GiftCertificateRecipient'	=>	Array ('type' => 'string', 'default' => ''),

						// for ResetToUser
						'UserTo'		=>	Array ('type' => 'string', 'default' => ''),
						'UserCompany'	=>	Array ('type' => 'string', 'default' => ''),
						'UserPhone'		=>	Array ('type' => 'string', 'default' => ''),
						'UserFax'		=>	Array ('type' => 'string', 'default' => ''),
						'UserEmail'		=>	Array ('type' => 'string', 'default' => ''),
						'UserAddress1'	=>	Array ('type' => 'string', 'default' => ''),
						'UserAddress2'	=>	Array ('type' => 'string', 'default' => ''),
						'UserCity'		=>	Array ('type' => 'string', 'default' => ''),
						'UserState'		=>	Array ('type' => 'string', 'default' => ''),
						'UserZip'		=>	Array ('type' => 'string', 'default' => ''),
						'UserCountry'	=>	Array ('type' => 'string', 'default' => ''),

						// for Search
						'Username'		=>	Array ('type' => 'string', 'filter_type' => 'like', 'default' => ''),
						'HasBackOrders' => Array ('type' => 'int', 'default' => 0),
						'PaymentCVV2'	=>	Array ('type' => 'string', 'default' => ''),
						'AffiliateUser' =>	Array ('type' => 'string', 'filter_type' => 'like', 'default' => ''),
						'AffiliatePortalUserId' => Array ('type' => 'int', 'default' => 0),

						// export related fields: begin
						'ExportFormat'			=>	Array ('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (1 => 'CSV', /*2 => 'XML'*/), 'default' => 1),
						'ExportFilename'		=>	Array ('type' => 'string', 'default' => ''),
						'FieldsSeparatedBy'		=>	Array ('type' => 'string', 'default' => ','),
						'FieldsEnclosedBy'		=>	Array ('type' => 'string', 'default' => '"'),
						'LineEndings'			=>	Array ('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (1 => 'Windows', 2 => 'UNIX'), 'default' => 1),
						'LineEndingsInside'		=>	Array ('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (1 => 'CRLF', 2 => 'LF'), 'default' => 2),
						'IncludeFieldTitles'	=>	Array (
					    	'type' => 'int',
					    	'formatter' => 'kOptionsFormatter',
					    	'options' => Array (0 => 'la_No', 1 => 'la_Yes'),
					    	'use_phrases' => 1, 'default' => 1,
						),
						'ExportColumns'			=>	Array ('type' => 'string', 'formatter' => 'kOptionsFormatter', 'options' => Array (), 'default' => ''),
						'AvailableColumns'		=>	Array ('type' => 'string', 'formatter' => 'kOptionsFormatter', 'options' => Array (), 'default' => ''),
						'ExportPresets' => Array ('type' => 'string', 'formatter' => 'kOptionsFormatter', 'options' => Array (), 'default' => ''),
						'ExportSavePreset' => Array (
					    	'type' => 'int',
					    	'formatter' => 'kOptionsFormatter',
					    	'options' => Array (0 => 'la_No', 1 => 'la_Yes'),
					    	'use_phrases' => 1, 'default' => 0,
						),
						'ExportPresetName' =>	Array ('type' => 'string', 'default' => ''),
						// export related fields: end

						// for "one step checkout"
						'UserPassword' => Array (
							'type' => 'string',
							'formatter' => 'kPasswordFormatter', 'hashing_method' => PasswordHashingMethod::MD5, 'verify_field' => 'VerifyUserPassword',
							'skip_empty' => 1, 'default' => 'd41d8cd98f00b204e9800998ecf8427e'
						),

						// for "Shipping Info" step during Checkout
						'ShippingTypeId' => Array ('type' => 'array', 'default' => ''),
					),
					'Grids'	=> Array (
						'Default' => Array (
							'Icons' => Array (
								'default' => 'icon16_item.png',
								1 => 'icon16_pending.png',
								5 => 'icon16_disabled.png',
								'module' => 'core',
							),

							'Fields' => Array (
								'OrderId'		=>	Array ('title' => 'column:la_fld_Id', 'data_block' => 'grid_checkbox_td', 'filter_block' => 'grid_range_filter', 'width' => 70, ),
								'OrderNumber'	=> Array ( 'data_block' => 'grid_ordernumber_td', 'filter_block' => 'grid_like_filter', 'width' => 100, ),
								'OrderDate' => Array ( 'title' => 'la_col_OrderDate', 'data_block' => 'grid_checkbox_td', 'filter_block' => 'grid_date_range_filter', 'width' => 140, ),
								'CustomerName'	=> Array ( 'title' => 'la_col_CustomerName', 'data_block' => 'grid_userlink_td', 'user_field' => 'PortalUserId', 'filter_block' => 'grid_like_filter', 'width' => 140, ),
								'PaymentType'	=> Array ( 'data_block' => 'grid_billinglink_td', 'filter_block' => 'grid_options_filter', 'width' => 140, ),
								'TotalAmount'	=> Array ( 'data_block' => 'grid_previewlink_td', 'filter_block' => 'grid_range_filter', 'width' => 140, ),
								'AffiliateUser'	=> Array ( 'data_block' => 'grid_userlink_td', 'user_field' => 'AffiliatePortalUserId', 'filter_block' => 'grid_like_filter', 'width' => 140, ),
								'OnHold' => Array ('filter_block' => 'grid_options_filter', 'width' => 100, ),
							),
						),

						'Search' => Array (
							'Icons' => Array (
								'default' => 'icon16_item.png',
								1 => 'icon16_pending.png',
								5 => 'icon16_disabled.png',
								'module' => 'core',
							),
							'Fields' => Array (
								'OrderId'		=>	Array ('title' => 'column:la_fld_Id', 'data_block' => 'grid_checkbox_td', 'filter_block' => 'grid_range_filter', 'width' => 70, ),
								'OrderNumber'	=>	Array ('data_block' => 'grid_ordernumber_td', 'filter_block' => 'grid_like_filter', 'width' => 100, ),
								'Status'		=>	Array ('filter_block' => 'grid_options_filter', 'filter_block' => 'grid_options_filter', 'width' => 100, ),
								'OrderDate'	=>	Array ('title' => 'la_col_OrderDate', 'filter_block' => 'grid_date_range_filter', 'width' => 140, ),
								'CustomerName'		=>	Array ('title' => 'la_col_CustomerName', 'data_block' => 'grid_userlink_td', 'user_field' => 'PortalUserId', 'filter_block' => 'grid_like_filter'),
								'PaymentType'	=> 	Array ('data_block' => 'grid_billinglink_td', 'filter_block' => 'grid_options_filter'),
								'TotalAmount'	=>	Array ('data_block' => 'grid_previewlink_td', 'filter_block' => 'grid_range_filter'),
								'AffiliateUser'	=>	Array ('data_block' => 'grid_userlink_td', 'user_field' => 'AffiliatePortalUserId', 'filter_block' => 'grid_user_like_filter'),
								'OrderIP'		=>	Array ('filter_block' => 'grid_like_filter'),
								'Username'		=>	Array ('filter_block' => 'grid_user_like_filter'),
								'PaymentAccount'	=>	Array ('title' => 'column:la_fld_CreditCardNumber', 'filter_block' => 'grid_like_filter'),
							),
						),
					),
	);