Index: branches/5.2.x/units/order_items/order_items_config.php =================================================================== diff -u -N -r15719 -r16385 --- branches/5.2.x/units/order_items/order_items_config.php (.../order_items_config.php) (revision 15719) +++ branches/5.2.x/units/order_items/order_items_config.php (.../order_items_config.php) (revision 16385) @@ -1,6 +1,6 @@ 'orditems', - 'ItemClass' => Array('class' => 'kDBItem', 'file' => '', 'build_event' => 'OnItemBuild'), - 'ListClass' => Array('class' => 'kDBList', 'file' => '', 'build_event' => 'OnListBuild'), - 'EventHandlerClass' => Array('class' => 'OrderItemsEventHandler', 'file' => 'order_items_event_handler.php', 'build_event' => 'OnBuild'), - 'TagProcessorClass' => Array('class' => 'OrderItemsTagProcessor', 'file' => 'order_items_tag_processor.php', 'build_event' => 'OnBuild'), +$config = Array ( + 'Prefix' => 'orditems', + 'ItemClass' => Array ('class' => 'kDBItem', 'file' => '', 'build_event' => 'OnItemBuild'), + 'ListClass' => Array ('class' => 'kDBList', 'file' => '', 'build_event' => 'OnListBuild'), + 'EventHandlerClass' => Array ('class' => 'OrderItemsEventHandler', 'file' => 'order_items_event_handler.php', 'build_event' => 'OnBuild'), + 'TagProcessorClass' => Array ('class' => 'OrderItemsTagProcessor', 'file' => 'order_items_tag_processor.php', 'build_event' => 'OnBuild'), - 'AutoLoad' => true, + 'AutoLoad' => true, - 'AggregateTags' => Array ( - Array ( - 'AggregateTo' => '#PARENT#', - 'AggregatedTagName' => 'ItemFieldEquals', - 'LocalTagName' => 'FieldEquals', - ), + 'AggregateTags' => Array ( + Array ( + 'AggregateTo' => '#PARENT#', + 'AggregatedTagName' => 'ItemFieldEquals', + 'LocalTagName' => 'FieldEquals', ), + ), - 'Hooks' => Array ( - Array ( - 'Mode' => hBEFORE, - 'Conditional' => false, - 'HookToPrefix' => '#PARENT#', - 'HookToSpecial' => '', - 'HookToEvent' => Array('OnPreSave', 'OnRecalculateItems'), - 'DoPrefix' => '', - 'DoSpecial' => '', - 'DoEvent' => 'OnUpdate', - ), + 'Hooks' => Array ( + Array ( + 'Mode' => hBEFORE, + 'Conditional' => false, + 'HookToPrefix' => '#PARENT#', + 'HookToSpecial' => '', + 'HookToEvent' => Array ('OnPreSave', 'OnRecalculateItems'), + 'DoPrefix' => '', + 'DoSpecial' => '', + 'DoEvent' => 'OnUpdate', ), + ), - 'QueryString' => Array ( - 1 => 'id', - 2 => 'Page', - 3 => 'PerPage', - 4 => 'event', - ), + 'QueryString' => Array ( + 1 => 'id', + 2 => 'Page', + 3 => 'PerPage', + 4 => 'event', + ), - 'IDField' => 'OrderItemId', - 'TitleField' => 'OrderItemId', - 'StatusField' => Array ('Status'), + 'IDField' => 'OrderItemId', + 'TitleField' => 'OrderItemId', + 'StatusField' => Array ('Status'), - 'TableName' => TABLE_PREFIX.'OrderItems', + 'TableName' => TABLE_PREFIX.'OrderItems', - 'ParentTableKey' => 'OrderId', - 'ForeignKey' => 'OrderId', - 'ParentPrefix' => 'ord', - 'AutoDelete' => true, - 'AutoClone' => true, + 'ParentTableKey' => 'OrderId', + 'ForeignKey' => 'OrderId', + 'ParentPrefix' => 'ord', + 'AutoDelete' => true, + 'AutoClone' => true, - 'ItemType' => 11, + 'ItemType' => 11, - 'CalculatedFields' => Array ( - '' => Array ( - 'ExtendedPrice' => '%1$s.Price * %1$s.Quantity', - 'ExtendedPriceFlat' => '%1$s.FlatPrice * %1$s.Quantity', - 'QuantityAvailable' => 'IF( ISNULL(p.QtyInStock) AND ISNULL(p.ProductId),"!la_ProductDeleted!", IF(p.Type = 1, IF(p.InventoryStatus = 2, poc.QtyInStock, p.QtyInStock), "") )', - 'ItemDiscount' => '(%1$s.FlatPrice - %1$s.Price)', - 'SKU' => 'IF(p.InventoryStatus = 2 OR NOT ISNULL(poc.CombinationCRC), poc.SKU, p.SKU)', // inventory by options OR combination found - ), + 'CalculatedFields' => Array ( + '' => Array ( + 'ExtendedPrice' => '%1$s.Price * %1$s.Quantity', + 'ExtendedPriceFlat' => '%1$s.FlatPrice * %1$s.Quantity', + 'QuantityAvailable' => 'IF( ISNULL(p.QtyInStock) AND ISNULL(p.ProductId),"!la_ProductDeleted!", IF(p.Type = 1, IF(p.InventoryStatus = 2, poc.QtyInStock, p.QtyInStock), "") )', + 'ItemDiscount' => '(%1$s.FlatPrice - %1$s.Price)', + 'SKU' => 'IF(p.InventoryStatus = 2 OR NOT ISNULL(poc.CombinationCRC), poc.SKU, p.SKU)', // inventory by options OR combination found ), + ), - 'ListSQLs' => Array ( - '' => ' SELECT %1$s.*, p.* %2$s - FROM %1$s - LEFT JOIN '.TABLE_PREFIX.'Products p ON %1$s.ProductId = p.ProductId - LEFT JOIN '.TABLE_PREFIX.'ProductOptionCombinations poc ON (%1$s.ProductId = poc.ProductId) AND (%1$s.OptionsSalt = poc.CombinationCRC)', - ), + 'ListSQLs' => Array ( + '' => ' SELECT %1$s.*, p.* %2$s + FROM %1$s + LEFT JOIN '.TABLE_PREFIX.'Products p ON %1$s.ProductId = p.ProductId + LEFT JOIN '.TABLE_PREFIX.'ProductOptionCombinations poc ON (%1$s.ProductId = poc.ProductId) AND (%1$s.OptionsSalt = poc.CombinationCRC)', + ), - 'ItemSQLs' => Array ( - '' => 'SELECT *, (Quantity*Price) AS ExtendedPrice, 0 AS QuantityAvailable FROM %s', - ), + 'ItemSQLs' => Array ( + '' => ' SELECT *, (Quantity*Price) AS ExtendedPrice, 0 AS QuantityAvailable + FROM %s', + ), - 'ListSortings' => Array ( - '' => Array ( - 'Sorting' => Array ('ProductName' => 'asc', 'BackOrderFlag' => 'asc'), - ) + 'ListSortings' => Array ( + '' => Array ( + 'Sorting' => Array ('ProductName' => 'asc', 'BackOrderFlag' => 'asc'), + ) + ), + + 'Fields' => Array ( + 'OrderItemId' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0), + 'OrderId' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0), + 'ProductId' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0), + 'ProductName' => Array ('type' => 'string', 'not_null' => 1, 'default' => ''), + 'Quantity' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0), + 'QuantityReserved' => Array ('type' => 'int', 'default' => null), + 'FlatPrice' => Array ('type' => 'double', 'formatter' => 'kFormatter', 'format' => '%01.2f', 'not_null' => '1', 'default' => '0.0000'), + 'Price' => Array ('type' => 'double', 'formatter' => 'kFormatter', 'format' => '%01.2f', 'not_null' => '1', 'default' => '0.0000'), + 'Cost' => Array ('type' => 'double', 'formatter' => 'kFormatter', 'format' => '%01.2f', 'not_null' => '1', 'default' => '0.0000'), + 'BackOrderFlag' => Array ('type' => 'int', 'default' => 0), + 'Weight' => Array ('type' => 'double', 'default' => NULL), + 'ShippingTypeId' => Array ('type' => 'string', 'default' => NULL), + 'ItemData' => Array ('type' => 'string', 'default' => null), + 'OptionsSalt' => Array ('type' => 'string', 'default' => 0), + 'SplitShippingGroup' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0,), + 'PackageNum' => Array ('type' => 'int', 'not_null' => 1, 'default' => 0,), + 'ReturnType' => Array ( + 'type' => 'int', + 'formatter' => 'kOptionsFormatter', 'options' => Array (1 => 'la_opt_Refund', 2 => 'la_opt_Exchange', 3 => 'la_opt_Warranty'), 'use_phrases' => 1, + 'not_null' => 1, 'default' => 0 ), + 'ReturnAmount' => Array ('type' => 'float', 'formatter' => 'kFormatter', 'format' => '%01.2f', 'not_null' => 1, 'default' => 0), + 'ReturnedOn' => Array ('type' => 'int', 'formatter' => 'kDateFormatter', 'default' => NULL), + ), - 'Fields' => Array ( - 'OrderItemId' => Array('type' => 'int', 'not_null' => 1, 'default' => 0), - 'OrderId' => Array('type' => 'int','not_null' => 1, 'default' => 0), - 'ProductId' => Array('type' => 'int','not_null' => 1, 'default' => 0), - 'ProductName' => Array('type' => 'string','not_null' => 1, 'default' => ''), - 'Quantity' => Array('type' => 'int','not_null' => 1, 'default' => 0), - 'QuantityReserved' => Array('type' => 'int', 'default' => null), - 'FlatPrice' => Array('type' => 'double','formatter'=>'kFormatter','format'=>'%01.2f','not_null' => '1','default' => '0.0000'), - 'Price' => Array('type' => 'double','formatter'=>'kFormatter','format'=>'%01.2f','not_null' => '1','default' => '0.0000'), - 'Cost' => Array('type' => 'double','formatter'=>'kFormatter','format'=>'%01.2f','not_null' => '1','default' => '0.0000'), - 'BackOrderFlag' => Array('type' => 'int', 'default' => 0), - 'Weight' => Array ('type' => 'double', 'default' => NULL), - 'ShippingTypeId' => Array ('type' => 'string', 'default' => NULL), - 'ItemData' => Array('type' => 'string','default' => null), - 'OptionsSalt' => Array('type' => 'string', 'default' => 0), - 'SplitShippingGroup' => Array('type' => 'int', 'not_null' => 1, 'default' => 0,), - 'PackageNum' => Array('type' => 'int', 'not_null' => 1, 'default' => 0,), - 'ReturnType' => Array ( - 'type' => 'int', - 'formatter' => 'kOptionsFormatter', 'options' => Array (1 => 'la_opt_Refund', 2 => 'la_opt_Exchange', 3 => 'la_opt_Warranty'), 'use_phrases' => 1, - 'not_null' => 1, 'default' => 0 + 'VirtualFields' => Array ( + 'ExtendedPrice' => Array ('type' => 'double', 'formatter' => 'kFormatter', 'format' => '%01.2f', 'default' => '0.00'), + 'ExtendedPriceFlat' => Array ('type' => 'double', 'formatter' => 'kFormatter', 'format' => '%01.2f', 'default' => '0.00'), + 'QuantityAvailable' => Array ('type' => 'int', 'default'=>0), + 'DiscountType' => Array ('type' => 'string', 'default' => ''), + 'DiscountId' => Array ('type' => 'int', 'default'=>0), + 'Name' => Array ('type' => 'string', 'formatter' => 'kMultiLanguage', 'default' => ''), + 'ItemDiscount' => Array ('type' => 'double', 'formatter' => 'kFormatter', 'format' => '%01.2f', 'default' => '0.00'), + 'SKU' => Array ('type' => 'string', 'default' => ''), + 'MinQtyFreeShipping'=> Array ('type' => 'int', 'default' => 0,), + 'Virtual' => Array ('type' => 'int', 'default' => 0), + ), + + 'Grids' => Array ( + 'Default' => Array ( + 'Icons' => Array ( + 'default' => 'icon16_product.png', + 0 => 'icon16_product_disabled.png', + 1 => 'icon16_product.png', + 2 => 'icon16_product_pending.png', ), - 'ReturnAmount' => Array ('type' => 'float', 'formatter' => 'kFormatter', 'format' => '%01.2f', 'not_null' => 1, 'default' => 0), - 'ReturnedOn' => Array ('type' => 'int', 'formatter' => 'kDateFormatter', 'default' => NULL), - ), + 'Fields' => Array ( + 'ProductName' => Array ('title' => 'la_col_ProductNameId', 'data_block' => 'grid_productname_td', 'filter_block' => 'grid_like_filter'), + 'Quantity' => Array ('title' => 'la_col_Quantity', 'data_block' => 'grid_quantity_td', 'filter_block' => 'grid_range_filter'), + 'QuantityReserved' => Array ('title' => 'la_col_QuantityReserved', 'filter_block' => 'grid_range_filter'), + 'QuantityAvailable' => Array ('title' => 'la_col_QuantityAvailable', 'filter_block' => 'grid_range_filter'), + 'Price' => Array ('data_block' => 'grid_price_td', 'filter_block' => 'grid_range_filter'), + 'ExtendedPrice' => Array ('title' => 'la_col_ExtendedPrice', 'data_block' => 'grid_extendedprice_td', 'filter_block' => 'grid_range_filter'), - 'VirtualFields' => Array ( - 'ExtendedPrice' => Array('type'=>'double','formatter'=>'kFormatter','format'=>'%01.2f','default'=>'0.00'), - 'ExtendedPriceFlat' => Array('type'=>'double','formatter'=>'kFormatter','format'=>'%01.2f','default'=>'0.00'), - 'QuantityAvailable' => Array('type'=>'int','default'=>0), - 'DiscountType' => Array('type'=>'string','default'=>''), - 'DiscountId' => Array('type'=>'int','default'=>0), - 'Name' => Array('type' => 'string', 'formatter' => 'kMultiLanguage', 'default' => ''), - 'ItemDiscount' => Array('type'=>'double','formatter'=>'kFormatter','format'=>'%01.2f','default'=>'0.00'), - 'SKU' => Array('type' => 'string', 'default' => ''), - 'MinQtyFreeShipping'=> Array('type' => 'int', 'default' => 0,), - 'Virtual' => Array ('type' => 'int', 'default' => 0), + 'ReturnType' => Array ('title' => 'la_col_ReturnType', 'data_block' => 'grid_options_td', 'filter_block' => 'grid_options_filter'), + 'ReturnAmount' => Array ('title' => 'la_col_ReturnAmount', 'data_block' => 'grid_edit_td', 'filter_block' => 'grid_range_filter'), + 'ReturnedOn' => Array ('title' => 'la_col_ReturnedOn', 'data_block' => 'grid_date_td', 'filter_block' => 'grid_date_range_filter'), + ), ), - 'Grids' => Array ( - 'Default' => Array ( - 'Icons' => Array ( - 'default' => 'icon16_product.png', - 0 => 'icon16_product_disabled.png', - 1 => 'icon16_product.png', - 2 => 'icon16_product_pending.png', - ), - 'Fields' => Array ( - 'ProductName' => Array ('title' => 'la_col_ProductNameId', 'data_block' => 'grid_productname_td', 'filter_block' => 'grid_like_filter'), - 'Quantity' => Array ('title' => 'la_col_Quantity', 'data_block' => 'grid_quantity_td', 'filter_block' => 'grid_range_filter'), - 'QuantityReserved' => Array ('title' => 'la_col_QuantityReserved', 'filter_block' => 'grid_range_filter'), - 'QuantityAvailable' => Array ('title' => 'la_col_QuantityAvailable', 'filter_block' => 'grid_range_filter'), - 'Price' => Array ('data_block' => 'grid_price_td', 'filter_block' => 'grid_range_filter'), - 'ExtendedPrice' => Array ('title' => 'la_col_ExtendedPrice', 'data_block' => 'grid_extendedprice_td', 'filter_block' => 'grid_range_filter'), - - 'ReturnType' => Array ('title' => 'la_col_ReturnType', 'data_block' => 'grid_options_td', 'filter_block' => 'grid_options_filter'), - 'ReturnAmount' => Array ('title' => 'la_col_ReturnAmount', 'data_block' => 'grid_edit_td', 'filter_block' => 'grid_range_filter'), - 'ReturnedOn' => Array ('title' => 'la_col_ReturnedOn', 'data_block' => 'grid_date_td', 'filter_block' => 'grid_date_range_filter'), - ), + 'NotEditable' => Array ( + 'Icons' => Array ( + 'default' => 'icon16_product.png', + 0 => 'icon16_product_disabled.png', + 1 => 'icon16_product.png', + 2 => 'icon16_product_pending.png', ), + 'Fields' => Array ( + 'ProductName' => Array ('title' => 'la_col_ProductNameId', 'data_block' => 'grid_productname_td'), + 'Quantity' => Array ('title' => 'la_col_Quantity', 'filter_block' => 'grid_range_filter'), + 'QuantityReserved' => Array ('title' => 'la_col_QuantityReserved', 'filter_block' => 'grid_range_filter'), + 'QuantityAvailable' => Array ('title' => 'la_col_QuantityAvailable', 'filter_block' => 'grid_range_filter'), + 'Price' => Array ('filter_block' => 'grid_range_filter'), + 'ExtendedPrice' => Array ('title' => 'la_col_ExtendedPrice', 'filter_block' => 'grid_range_filter'), - 'NotEditable' => Array ( - 'Icons' => Array ( - 'default' => 'icon16_product.png', - 0 => 'icon16_product_disabled.png', - 1 => 'icon16_product.png', - 2 => 'icon16_product_pending.png', - ), - 'Fields' => Array ( - 'ProductName' => Array ('title' => 'la_col_ProductNameId', 'data_block' => 'grid_productname_td'), - 'Quantity' => Array ('title' => 'la_col_Quantity', 'filter_block' => 'grid_range_filter'), - 'QuantityReserved' => Array ('title' => 'la_col_QuantityReserved', 'filter_block' => 'grid_range_filter'), - 'QuantityAvailable' => Array ('title' => 'la_col_QuantityAvailable', 'filter_block' => 'grid_range_filter'), - 'Price' => Array ('filter_block' => 'grid_range_filter'), - 'ExtendedPrice' => Array ('title' => 'la_col_ExtendedPrice', 'filter_block' => 'grid_range_filter'), - - 'ReturnType' => Array ('title' => 'la_col_ReturnType', 'data_block' => 'grid_options_td', 'filter_block' => 'grid_options_filter'), - 'ReturnAmount' => Array ('title' => 'la_col_ReturnAmount', 'data_block' => 'grid_edit_td', 'filter_block' => 'grid_range_filter'), - 'ReturnedOn' => Array ('title' => 'la_col_ReturnedOn', 'data_block' => 'grid_date_td', 'filter_block' => 'grid_date_range_filter'), - ), + 'ReturnType' => Array ('title' => 'la_col_ReturnType', 'data_block' => 'grid_options_td', 'filter_block' => 'grid_options_filter'), + 'ReturnAmount' => Array ('title' => 'la_col_ReturnAmount', 'data_block' => 'grid_edit_td', 'filter_block' => 'grid_range_filter'), + 'ReturnedOn' => Array ('title' => 'la_col_ReturnedOn', 'data_block' => 'grid_date_td', 'filter_block' => 'grid_date_range_filter'), ), ), - ); \ No newline at end of file + ), +);