1
. SELECT SQL_CALC_FOUND_ROWS * FROM corporate_user WHERE directory_name = 'posters-signs' 0.0002 secRender > mainpage.tpl
Array ( [twd] => Array ( [titletag] =>Posters, Banners & Signs [metatag] => [form] => Array ( [fb_link] => https://www.facebook.com/dialog/oauth?client_id=207871080027786&redirect_uri=http%3A%2F%2Fabcimaging.dev.radixweb.net%2Fuser_registration.php&state=0054c32e638a87ccbc6c9e00ec614927&scope=email&return_url=http%3A%2F%2Fabcimaging.dev.radixweb.net%2Fuser_registration.php [fb_button] => Facebook ) [layout_style] => Array ( [l1] => Array ( [1] => Array ( [6z] => Array ( [0] => image-gallery [tab-content] => Array ( [tabs] => Array ( [PRODUCT_INFO_DESCRIPTION] => product-description [COMMON_PRICE_DETAILS] => price-list [PRODUCT_TEMPLETES] => help-template ) ) ) [6b] => Array ( [0] => price-calculator [action-buttons] => Array ( [type] => horizontal-button [popupoption] => yes ) ) ) [2] => Array ( [12i] => Array ( [0] => product-extra-message ) ) [3] => Array ( [12o] => Array ( [tab-content] => Array ( [tabs] => Array ( [RELATED_PRODUCTS] => product-related [COMBO_DISCOUNT_PRODUCTS] => product-combo ) ) ) ) [4] => Array ( [12o] => Array ( [0] => product-review ) ) ) [l2] => Array ( [1] => Array ( [7] => Array ( [0] => image-gallery [1] => product-description ) [5] => Array ( [0] => price-calculator ) ) [2] => Array ( [7] => Array ( [0] => price-list ) [5] => Array ( [action-buttons] => Array ( [type] => vertical-button ) ) ) [3] => Array ( [7] => Array ( [0] => help-template ) [5] => Array ( [0] => product-extra-message ) ) [4] => Array ( [12a] => Array ( [0] => product-related ) [12b] => Array ( [0] => product-combo ) [12c] => Array ( [0] => product-review ) ) ) [l3] => Array ( [1] => Array ( [12] => Array ( [0] => product-extra-message ) ) [2] => Array ( [5] => Array ( [0] => price-calculator ) [7] => Array ( [0] => image-gallery [tab-content] => Array ( [tabs] => Array ( [PRODUCT_INFO_DESCRIPTION] => product-description [COMMON_PRICE_DETAILS] => price-list [PRODUCT_TEMPLETES] => help-template ) ) ) ) [3] => Array ( [12a] => Array ( [action-buttons] => Array ( [type] => horizontal-icon ) ) [12b] => Array ( [tab-content] => Array ( [tabs] => Array ( [RELATED_PRODUCTS] => product-related [COMBO_DISCOUNT_PRODUCTS] => product-combo ) ) ) [12c] => Array ( [0] => product-review ) ) ) [l4] => Array ( [1] => Array ( [6k] => Array ( [0] => image-gallery [1] => product-description ) [6v] => Array ( [tab-content] => Array ( [tabs] => Array ( [PRICE_CALCULATOR] => price-calculator [COMMON_PRICE_DETAILS] => price-list [PRODUCT_TEMPLETES] => help-template ) ) [action-buttons] => Array ( [type] => vertical-button ) ) ) [2] => Array ( [12l] => Array ( [0] => product-extra-message ) ) [3] => Array ( [12h] => Array ( [tab-content] => Array ( [tabs] => Array ( [RELATED_PRODUCTS] => product-related [COMBO_DISCOUNT_PRODUCTS] => product-combo ) ) ) ) [4] => Array ( [12x] => Array ( [0] => product-review ) ) ) [l5] => Array ( [1] => Array ( [12] => Array ( [0] => image-gallery ) ) [2] => Array ( [6a] => Array ( [tab-content] => Array ( [tabs] => Array ( [PRODUCT_INFO_DESCRIPTION] => product-description [COMMON_PRICE_DETAILS] => price-list [PRODUCT_TEMPLETES] => help-template ) ) ) [6b] => Array ( [0] => price-calculator ) ) [3] => Array ( [12] => Array ( [action-buttons] => Array ( [type] => horizontal-icon ) ) ) [4] => Array ( [12a] => Array ( [0] => product-extra-message ) [12b] => Array ( [tab-content] => Array ( [tabs] => Array ( [RELATED_PRODUCTS] => product-related [COMBO_DISCOUNT_PRODUCTS] => product-combo ) ) ) [12c] => Array ( [0] => product-review ) ) ) [l6] => Array ( [1] => Array ( [12] => Array ( [tab-content] => Array ( [tabs] => Array ( [Gallery] => image-gallery [PRODUCT_INFO_DESCRIPTION] => product-description [PRICE_CALCULATOR] => price-calculator [COMMON_PRICE_DETAILS] => price-list [PRODUCT_TEMPLETES] => help-template [PRODUCT EXTRA MESSAGE] => product-extra-message ) ) ) ) [2] => Array ( [12a] => Array ( [action-buttons] => Array ( [type] => horizontal-icon ) ) [12b] => Array ( [tab-content] => Array ( [tabs] => Array ( [RELATED_PRODUCTS] => product-related [COMBO_DISCOUNT_PRODUCTS] => product-combo ) ) ) [12c] => Array ( [0] => product-review ) ) ) [l7] => Array ( [1] => Array ( [12] => Array ( [0] => product-description ) ) [2] => Array ( [6a] => Array ( [0] => price-calculator ) [6b] => Array ( [action-buttons] => Array ( [type] => vertical-icon ) ) ) [3] => Array ( [12a] => Array ( [0] => product-extra-message ) [12b] => Array ( [tab-content] => Array ( [tabs] => Array ( [RELATED_PRODUCTS] => product-related [COMBO_DISCOUNT_PRODUCTS] => product-combo ) ) ) [12c] => Array ( [0] => product-review ) ) ) [predefined] => Array ( [1] => Array ( [6m] => Array ( [0] => image-gallery [1] => product-description ) [6u] => Array ( [0] => price-calculator ) ) [2] => Array ( [12f] => Array ( [0] => login-form ) ) [3] => Array ( [12f] => Array ( [0] => product-extra-message ) ) [4] => Array ( [12x] => Array ( [0] => product-related ) ) [5] => Array ( [12a] => Array ( [0] => product-review ) ) [6] => Array ( [12b] => Array ( [0] => product-combo ) ) ) [m1] => Array ( [1] => Array ( [12x] => Array ( [0] => price-calculator ) ) [2] => Array ( [12p] => Array ( [action-buttons] => Array ( [type] => vertical-button [popupoption] => no ) ) ) [3] => Array ( [12v] => Array ( [0] => image-gallery ) ) [4] => Array ( [12o] => Array ( [0] => product-description ) ) ) [book] => Array ( [1] => Array ( [5k] => Array ( [0] => image-gallery ) [7b] => Array ( [0] => product-description ) ) [2] => Array ( [12z] => Array ( [0] => content-upload ) ) [3] => Array ( [12g] => Array ( [action-buttons] => Array ( [type] => horizontal-button ) ) ) [4] => Array ( [12y] => Array ( [0] => price-calculator ) ) [5] => Array ( [12c] => Array ( [0] => product-extra-message ) ) [6] => Array ( [12r] => Array ( [0] => product-review ) ) [7] => Array ( [12a] => Array ( [0] => login-form ) ) [8] => Array ( [12z] => Array ( [tab-content] => Array ( [tabs] => Array ( [RELATED_PRODUCTS] => product-related [COMBO_DISCOUNT_PRODUCTS] => product-combo ) ) ) ) ) [photo-print] => Array ( [1] => Array ( [6x] => Array ( [0] => product-description ) [6v] => Array ( [0] => price-calculator ) ) [2] => Array ( [12v] => Array ( [action-buttons] => Array ( [type] => horizontal-button [popupoption] => no ) ) ) ) [photobook] => Array ( [1] => Array ( [6o] => Array ( [0] => image-gallery ) [6h] => Array ( [0] => product-description ) ) [2] => Array ( [12o] => Array ( [0] => product-photobook-designs ) ) ) [test] => Array ( [1] => Array ( [6q] => Array ( [tab-content] => Array ( [tabs] => Array ( ) ) [0] => image-gallery ) [6e] => Array ( [0] => price-calculator [action-buttons] => Array ( [type] => vertical-button [popupoption] => no ) ) ) [2] => Array ( [12b] => Array ( [0] => product-extra-message ) ) [3] => Array ( [12c] => Array ( [tab-content] => Array ( [tabs] => Array ( [RELATED_PRODUCTS] => product-related [COMBO_DISCOUNT_PRODUCTS] => product-combo ) ) ) ) [4] => Array ( [12s] => Array ( [0] => product-review ) ) ) [test2] => Array ( [1] => Array ( [6y] => Array ( [0] => image-gallery ) [6n] => Array ( [0] => price-calculator ) ) [2] => Array ( [6p] => Array ( [tab-content] => Array ( [tabs] => Array ( [COMMON_PRICE_DETAILS] => price-list [RELATED_PRODUCTS] => product-related [COMBO_DISCOUNT_PRODUCTS] => product-combo ) ) ) [6n] => Array ( [action-buttons] => Array ( [type] => vertical-button [popupoption] => no ) ) ) [3] => Array ( [12p] => Array ( [0] => product-extra-message ) ) [4] => Array ( [12k] => Array ( [0] => product-description ) ) [5] => Array ( [12q] => Array ( [tab-content] => Array ( [tabs] => Array ( [PRODUCT_INFO_TEMPLATES] => product-templates ) ) ) ) [6] => Array ( [12d] => Array ( [0] => product-review ) ) ) [Bryan-11/29/18] => Array ( [1] => Array ( [6u] => Array ( [0] => image-gallery ) [6q] => Array ( [0] => product-description ) ) [2] => Array ( [6w] => Array ( [0] => price-list ) [6n] => Array ( [action-buttons] => Array ( [type] => vertical-button [popupoption] => no ) ) ) [3] => Array ( [12m] => Array ( [0] => product-templates ) ) ) [kitproduct] => Array ( [0] => Array ( [12] => Array ( [0] => image-gallery [1] => product-description [2] => price-calculator ) ) ) ) [arr_side_boxes] => Array ( [page_sidebox_detail] => RDataRecord Object ( [_Data:protected] => Array ( [sidebar_id] => 1 [section_name] => Default [section_pages] => [leftbox] => false [rightbox] => false [hide_left_sidebox] => [hide_right_sidebox] => [master_sidebar_id] => 0 [corporate_id] => 0 ) [_IteratorKeys:protected] => Array ( [0] => sidebar_id [1] => section_name [2] => section_pages [3] => leftbox [4] => rightbox [5] => hide_left_sidebox [6] => hide_right_sidebox [7] => master_sidebar_id [8] => corporate_id ) ) [rightbox] => Array ( [0] => Array ( [function_name] => contact_us_sidemenu_box ) [1] => Array ( [function_name] => get_subscriber ) [2] => Array ( [function_name] => get_testimonials ) ) [leftbox] => Array ( [0] => Array ( [function_name] => get_product_listing ) [1] => Array ( [function_name] => get_user_unsaved_template_block ) [2] => Array ( [function_name] => user_login ) ) ) [arr_header_main_css] => Array ( [0] => http://abcimaging.dev.radixweb.net/thirdparty/bootstrap/css/bootstrap.css [1] => http://abcimaging.dev.radixweb.net/thirdparty/bootstrap/css/bootstrap-plugins.css [2] => http://abcimaging.dev.radixweb.net/thirdparty/css/font-awesome.css [3] => http://abcimaging.dev.radixweb.net/thirdparty/fancybox/css/jquery.fancybox.css [4] => http://abcimaging.dev.radixweb.net/thirdparty/fancybox/helpers/jquery.fancybox-thumbs.css [5] => http://abcimaging.dev.radixweb.net/thirdparty/css/icomoon.css [6] => http://abcimaging.dev.radixweb.net/templates/css/loader.css [7] => http://abcimaging.dev.radixweb.net/templates/css/common.css [8] => http://abcimaging.dev.radixweb.net/templates/css/badge.css [9] => http://abcimaging.dev.radixweb.net/thirdparty/slick/css/slick-theme.css [10] => http://abcimaging.dev.radixweb.net/thirdparty/slick/css/slick.css [11] => http://abcimaging.dev.radixweb.net/thirdparty/flipbook/css/flipbook.style.css [12] => http://abcimaging.dev.radixweb.net/templates/css/breadcrumbs.css [13] => http://abcimaging.dev.radixweb.net/templates/css/promotional_message.css [14] => http://abcimaging.dev.radixweb.net/themes/abcimaging/css/theme.css [15] => http://abcimaging.dev.radixweb.net/images/custom_css/abcimaging.css ) [arr_main_css] => Array ( ) [arr_main_js] => Array ( [0] => common_js.php [1] => http://abcimaging.dev.radixweb.net/thirdparty/js/jquery.js [2] => http://abcimaging.dev.radixweb.net/thirdparty/js/jquery-ui.js [3] => http://abcimaging.dev.radixweb.net/thirdparty/bootstrap/js/bootstrap.js [4] => http://abcimaging.dev.radixweb.net/thirdparty/bootstrap/js/bootstrap-plugins.js [5] => http://abcimaging.dev.radixweb.net/thirdparty/js/jquery.validate.js [6] => http://abcimaging.dev.radixweb.net/thirdparty/js/jquery.validate.methods.js [7] => http://abcimaging.dev.radixweb.net/thirdparty/js/jquery.bootstrap-growl.js [8] => http://abcimaging.dev.radixweb.net/thirdparty/js/handlebars.js [9] => http://abcimaging.dev.radixweb.net/thirdparty/js/typeahead.js [10] => http://abcimaging.dev.radixweb.net/thirdparty/js/holder.js [11] => http://abcimaging.dev.radixweb.net/thirdparty/js/jquery.touchSwipe.min.js [12] => http://abcimaging.dev.radixweb.net/thirdparty/fancybox/js/jquery.fancybox.js [13] => http://abcimaging.dev.radixweb.net/thirdparty/js/jquery.cookie.js [14] => http://abcimaging.dev.radixweb.net/thirdparty/js/fileuploader.js [15] => http://abcimaging.dev.radixweb.net/thirdparty/js/number-functions.js [16] => http://abcimaging.dev.radixweb.net/thirdparty/js/dompurify.min.js [17] => http://abcimaging.dev.radixweb.net/thirdparty/js/bootbox.js [18] => http://abcimaging.dev.radixweb.net/templates/js/jquery.validate.bootstrap.js [19] => http://abcimaging.dev.radixweb.net/templates/js/common.js [20] => http://abcimaging.dev.radixweb.net/templates/js/common_seo.js [21] => http://abcimaging.dev.radixweb.net/templates/js/cookiewarning.js [22] => http://abcimaging.dev.radixweb.net/thirdparty/slick/js/slick.js [23] => http://abcimaging.dev.radixweb.net/thirdparty/flipbook/js/flipbook.min.js [24] => http://abcimaging.dev.radixweb.net/templates/js/promotional_message.js [25] => /themes/abcimaging/js/theme.js ) [show_leftbox] => false [show_rightbox] => false [show_left_panel] => [show_right_panel] => [col] => Array ( [left] => Array ( [0] => 12 [1] => 4 [2] => 3 [3] => 3 ) [middle] => Array ( [0] => 12 [1] => 12 [2] => 12 [3] => 12 ) [right] => Array ( [0] => 12 [1] => 12 [2] => 3 [3] => 3 ) ) [class] => Array ( [left] => col-xs-12 col-sm-4 col-md-3 col-lg-3 [middle] => col-xs-12 col-sm-12 col-md-12 col-lg-12 [right] => col-xs-12 col-sm-12 col-md-3 col-lg-3 [right_box] => col-xs-12 col-sm-6 col-md-12 col-lg-12 ) [cms] => Array ( [contact_us_box] =>
ABC PrintRoom
5290 Shawnee Road, Suite 300
Alexandria, VA 22312 - United States
Phone : 202.559.7454
customerservice@abcprintroom.com[cms_header] =>
Welcome to ABC PrintRoom! Your one stop print source for any occasion.
[cms_footer] =>Popular Products
Start your print project today. Upload your own files or choose from our 3,500 customizable design templates.
Thank you so much for your best Printing Services, all the amazing work you did with our programs and flyers last week. The quality was exceptional, and your flexibility and speediness has always been appreciated.
Customer service is great - they communicate quickly and easily and are open to flexibility. The products received are high quality and conveniently delivered. I must say they are best photo developing company.
You guys are AWESOME!!! They look terrific. Thank you so much and please thank everyone involved.The President of our company was very happy with the sample yesterday!!” Best Photo Printing services !!
First off, AMAZING JOB. I’ve been so impressed by the quality of best photo printer and speed of this work. I’m so grateful to you for everything. Thank you.
You might also like to view our other products...
) [SITE_VAR_PRODUCT_NO_IMAGE] => [SITE_VAR_DISPLAY_PRODUCT_CATEGORY_SUBOPTION] => %s (%s) [SITE_VAR_CART_AGREE_CHECKBOX] => product_add_info [SITE_VAR_PREDEFINED_PRODUCT_CHECKBOX] => [payonMethodIDs] => [22] [productCategoryDetails] => RDataRecord Object ( [_Data:protected] => Array ( [category_id] => 11 [category_name] => Posters, Banners & Signs [description] =>Create beautiful large format content in just minutes! No matter what message you're looking to get out there, your vibrant, full-color custom design will surely get you noticed.
[long_description] =>Create beautiful large format content in just minutes! No matter what message you're looking to get out there, your vibrant, full-color custom design will surely get you noticed.
[site_language_id] => 1 [status] => 1 ) [_IteratorKeys:protected] => Array ( [0] => category_id [1] => category_name [2] => description [3] => long_description [4] => site_language_id [5] => status ) ) [objProduct] => ProductsMaster Object ( [Connection] => RDataConnection Object ( [Connection:RDataConnection:private] => PDO Object ( ) [queryTime] => 0.0007 [debug:RDataConnection:private] => 1 ) [buildQuery:RMasterModel:private] => Array ( [query] => Array ( ) [select] => Array ( ) [where] => Array ( ) [insert] => Array ( ) [update] => Array ( ) [join] => Array ( ) [orderBy] => Array ( ) [limit] => Array ( ) [groupBy] => Array ( ) [having] => Array ( ) [from] => Array ( ) [delete] => Array ( ) ) [params:RMasterModel:private] => Array ( ) [types:RMasterModel:private] => Array ( ) [customQuery:RMasterModel:private] => Array ( ) [customParams:RMasterModel:private] => Array ( ) [customTypes:RMasterModel:private] => Array ( ) [query:RMasterModel:private] => SELECT products.products_id, products.category_id, products.multiple_category, product_category.category_id as cat_id, products_description.imagename, products_description.products_title, products_description.product_description, products_description.product_url, products_description.product_promotional_text, product_settings.product_setting_id, product_settings.setting_constant_name, product_settings.setting_value FROM products LEFT JOIN product_category ON product_category.category_id = products.category_id or (find_in_set(product_category.category_id,products.multiple_category) > :product_multiple_category ) LEFT JOIN product_settings ON product_settings.products_id = products.products_id AND product_settings.setting_constant_name = :product_settings_setting_constant_name LEFT JOIN product_category_description ON product_category_description.category_id = product_category.category_id AND product_category_description.site_language_id = :product_category_description_site_language_id LEFT JOIN products_description ON products_description.products_id = products.products_id WHERE products.visible = :visible AND products.predefined_product_type IN (:input_0, :input_1, :input_2, :input_3, :input_4) AND (products.user_type_id = :products_corporate_id_1 OR products.user_type_id = :products_user_type_id_0) AND products_description.site_language_id = :site_language_id ORDER BY products.sort_order,products_description.products_title [addFoundRows:RMasterModel:private] => [queryType:RMasterModel:private] => 0 [debug:RMasterModel:private] => 1 [backtrace:RMasterModel:private] => Array ( [/home/abcimaging/public_html/productlist_category_wise.php(66): RMasterModel->setSelect(Array)] =>65: */
66: $objProduct->setSelect(array("products.products_id", "products.category_id", "products.multiple_category", "product_category.category_id as cat_id", "products_description.imagename", "products_description.products_title", "products_description.product_description", "products_description.product_url", "products_description.product_promotional_text","product_settings.product_setting_id","product_settings.setting_constant_name","product_settings.setting_value"));
67: $language_id = SITE_LANGUAGE_ID;
[/home/abcimaging/public_html/productlist_category_wise.php(68): RMasterModel->setJoin('LEFT JOIN product_category ON product_category.category_id = products.category_id or (find_in_set(product_category.category_id,products.multiple_category) > :product_multiple_category )', 0, 'int')] =>67: $language_id = SITE_LANGUAGE_ID;
68: $objProduct->setJoin("LEFT JOIN product_category ON product_category.category_id = products.category_id or (find_in_set(product_category.category_id,products.multiple_category) > :product_multiple_category )",0,'int')
69: ->setJoin("LEFT JOIN product_settings ON product_settings.products_id = products.products_id AND product_settings.setting_constant_name = :product_settings_setting_constant_name", 'PRODUCT_PROMOTION_PATTERN', 'string')
[/home/abcimaging/public_html/productlist_category_wise.php(69): RMasterModel->setJoin('LEFT JOIN product_settings ON product_settings.products_id = products.products_id AND product_settings.setting_constant_name = :product_settings_setting_constant_name', 'PRODUCT_PROMOTION_PATTERN', 'string')] =>68: $objProduct->setJoin("LEFT JOIN product_category ON product_category.category_id = products.category_id or (find_in_set(product_category.category_id,products.multiple_category) > :product_multiple_category )",0,'int')
69: ->setJoin("LEFT JOIN product_settings ON product_settings.products_id = products.products_id AND product_settings.setting_constant_name = :product_settings_setting_constant_name", 'PRODUCT_PROMOTION_PATTERN', 'string')
70: ->setJoin("LEFT JOIN product_category_description ON product_category_description.category_id = product_category.category_id AND product_category_description.site_language_id = :product_category_description_site_language_id ",SITE_LANGUAGE_ID, 'int')
[/home/abcimaging/public_html/productlist_category_wise.php(70): RMasterModel->setJoin('LEFT JOIN product_category_description ON product_category_description.category_id = product_category.category_id AND product_category_description.site_language_id = :product_category_description_site_language_id ', 1, 'int')] =>69: ->setJoin("LEFT JOIN product_settings ON product_settings.products_id = products.products_id AND product_settings.setting_constant_name = :product_settings_setting_constant_name", 'PRODUCT_PROMOTION_PATTERN', 'string')
70: ->setJoin("LEFT JOIN product_category_description ON product_category_description.category_id = product_category.category_id AND product_category_description.site_language_id = :product_category_description_site_language_id ",SITE_LANGUAGE_ID, 'int')
71: ->setWhere("AND products.visible = :visible", '1', 'string');
[/home/abcimaging/public_html/productlist_category_wise.php(71): RMasterModel->setWhere('AND products.visible = :visible', '1', 'string')] =>70: ->setJoin("LEFT JOIN product_category_description ON product_category_description.category_id = product_category.category_id AND product_category_description.site_language_id = :product_category_description_site_language_id ",SITE_LANGUAGE_ID, 'int')
71: ->setWhere("AND products.visible = :visible", '1', 'string');
72: //->setWhere("AND products.category_id = :category_id", $categoryId, 'string');
[/home/abcimaging/public_html/productlist_category_wise.php(76): RMasterModel->setWhere('AND products.predefined_product_type IN @p_predefined_product_type', Array, 'string')] =>75: $predefined_product_list = array_keys($predefined_product_types);
76: $objProduct->setWhere("AND products.predefined_product_type IN @p_predefined_product_type",$predefined_product_list,"string");
77: // Condition for retailer and corporate user.
[/home/abcimaging/public_html/productlist_category_wise.php(79): RMasterModel->setWhere('AND (products.user_type_id = :products_corporate_id_1 OR products.user_type_id = :products_user_type_id_0)', Array, Array)] =>78: $user_type_search = get_user_type_query($userTypeId,$corporateId,$department_id);
79: $objProduct->setWhere($user_type_search[0], $user_type_search[1], $user_type_search[2])
80: ->setWhere("AND products_description.site_language_id = :site_language_id", SITE_LANGUAGE_ID, 'int')
[/home/abcimaging/public_html/productlist_category_wise.php(80): RMasterModel->setWhere('AND products_description.site_language_id = :site_language_id', 1, 'int')] =>79: $objProduct->setWhere($user_type_search[0], $user_type_search[1], $user_type_search[2])
80: ->setWhere("AND products_description.site_language_id = :site_language_id", SITE_LANGUAGE_ID, 'int')
81: ->setOrderBy("products.sort_order,products_description.products_title");
[/home/abcimaging/public_html/productlist_category_wise.php(81): RMasterModel->setOrderBy('products.sort_order,products_description.products_title')] =>80: ->setWhere("AND products_description.site_language_id = :site_language_id", SITE_LANGUAGE_ID, 'int')
81: ->setOrderBy("products.sort_order,products_description.products_title");
82: $thisCatProducts = $objProduct->get_product_details();
[/home/abcimaging/public_html/model/ProductsMaster.php(189): RMasterModel->setWhere('AND products.products_id = :products_id', , 'int', true)] =>188: public function get_product_details($product_id=null, $language_id=null, $category_id=null,$predefined=null, $seo_case = false) {
189: $this->setWhere("AND products.products_id = :products_id", $product_id, 'int',true);
190: $this->setWhere("AND products_description.site_language_id = :site_language_id", $language_id, 'int',true);
[/home/abcimaging/public_html/model/ProductsMaster.php(190): RMasterModel->setWhere('AND products_description.site_language_id = :site_language_id', , 'int', true)] =>189: $this->setWhere("AND products.products_id = :products_id", $product_id, 'int',true);
190: $this->setWhere("AND products_description.site_language_id = :site_language_id", $language_id, 'int',true);
191: $this->setWhere("AND products.category_id = :category_id", $category_id, 'int',true);
[/home/abcimaging/public_html/model/ProductsMaster.php(191): RMasterModel->setWhere('AND products.category_id = :category_id', , 'int', true)] =>190: $this->setWhere("AND products_description.site_language_id = :site_language_id", $language_id, 'int',true);
191: $this->setWhere("AND products.category_id = :category_id", $category_id, 'int',true);
192: $this->setWhere("AND products.predefined_product_type = :predefined_product_type", $predefined, 'int',true);
[/home/abcimaging/public_html/model/ProductsMaster.php(192): RMasterModel->setWhere('AND products.predefined_product_type = :predefined_product_type', , 'int', true)] =>191: $this->setWhere("AND products.category_id = :category_id", $category_id, 'int',true);
192: $this->setWhere("AND products.predefined_product_type = :predefined_product_type", $predefined, 'int',true);
193:
[/home/abcimaging/public_html/model/ProductsMaster.php(200): RMasterModel->setJoin('LEFT JOIN products_description ON products_description.products_id = products.products_id')] =>199: } else {
200: $this->setJoin("LEFT JOIN products_description ON products_description.products_id = products.products_id");
201: }
[/home/abcimaging/public_html/model/ProductsMaster.php(202): RMasterModel->setFrom('products')] =>201: }
202: $this->setFrom("products");
203: return $this->exec_query();
[/home/abcimaging/public_html/lib/Classes/Models/RMasterModel.php(83): RMasterModel->resetVariables()] =>82:
83: $this->resetVariables(); // reset all variables
84: } catch (Exception $e) {
)
)
[userTypeId] => 1
[corporateId] => 0
[thisCatProducts] => Array
(
[18] => Array
(
[imagename] => poster_thumb.jpg
[description] =>The Perfect Attention Grabbing Medium No Matter Where You Choose to Display
Produce posters to promote your clients' business.
[title] => Posters [promotion_title] => [id] => 24 [url] => http://abcimaging.dev.radixweb.net/product_info.php?pid=24 [product_url] => posters [badgepattern] => none ) ) ) ) 7
. SELECT * FROM website_logos WHERE corporate_id = 0 0.0001 secRender > header_toplinks.block
Array ( [twd] => Array ( [cnt] => 0 [menus] => Array ( [0] => RDataRecord Object ( [_Data:protected] => Array ( [menu_id] => 64 [menu_link] => cms.php?page=contact_us [menu_target] => _self [menu_position] => topheader [link_display] => 2 [menu_option] => 0 [status] => 1 [sort_order] => 0 [menu_link_category] => 1 [link_type_id] => 10 [master_menu_id] => 0 [corporate_id] => 0 [menu_title] => 202.559.7454 [menu_image] => [site_language_id] => 1 ) [_IteratorKeys:protected] => Array ( [0] => menu_id [1] => menu_link [2] => menu_target [3] => menu_position [4] => link_display [5] => menu_option [6] => status [7] => sort_order [8] => menu_link_category [9] => link_type_id [10] => master_menu_id [11] => corporate_id [12] => menu_title [13] => menu_image [14] => site_language_id ) ) [1] => RDataRecord Object ( [_Data:protected] => Array ( [menu_id] => 7 [menu_link] => user_account.php [menu_target] => _self [menu_position] => topheader [link_display] => 0 [menu_option] => 2 [status] => 1 [sort_order] => 1 [menu_link_category] => 4 [link_type_id] => 36 [master_menu_id] => 0 [corporate_id] => 0 [menu_title] => Login / Register [menu_image] => fa-user [site_language_id] => 1 ) [_IteratorKeys:protected] => Array ( [0] => menu_id [1] => menu_link [2] => menu_target [3] => menu_position [4] => link_display [5] => menu_option [6] => status [7] => sort_order [8] => menu_link_category [9] => link_type_id [10] => master_menu_id [11] => corporate_id [12] => menu_title [13] => menu_image [14] => site_language_id ) ) [2] => RDataRecord Object ( [_Data:protected] => Array ( [menu_id] => 37 [menu_link] => express_checkout_payment.php [menu_target] => _self [menu_position] => topheader [link_display] => 2 [menu_option] => 2 [status] => 1 [sort_order] => 8 [menu_link_category] => 0 [link_type_id] => 0 [master_menu_id] => 0 [corporate_id] => 0 [menu_title] => Shopping Cart [menu_image] => fa-shopping-cart [site_language_id] => 1 ) [_IteratorKeys:protected] => Array ( [0] => menu_id [1] => menu_link [2] => menu_target [3] => menu_position [4] => link_display [5] => menu_option [6] => status [7] => sort_order [8] => menu_link_category [9] => link_type_id [10] => master_menu_id [11] => corporate_id [12] => menu_title [13] => menu_image [14] => site_language_id ) ) ) [arr_myaccount_menu_link] => Array ( [0] => user_account.php [1] => user_order.php [3] => user_portfolio.php [4] => quote.php [5] => user_order_inventory.php [7] => user_reward.php [8] => user_images.php [9] => user_qrcode_list.php [10] => user_address.php [11] => user_profile.php [12] => user_store_profile.php [13] => sales_order_report.php [14] => user_changepassword.php ) [form] => Array ( [fb_button] => Facebook [fb_link] => https://www.facebook.com/dialog/oauth?client_id=207871080027786&redirect_uri=http%3A%2F%2Fabcimaging.dev.radixweb.net%2Fuser_registration.php&state=0054c32e638a87ccbc6c9e00ec614927&scope=email&return_url=http%3A%2F%2Fabcimaging.dev.radixweb.net%2Fuser_registration.php ) [SITE_VAR_DESIGNER_MODULE_ENABLE] => 0 [SITE_VAR_USERNAME_LOGIN] => N [SITE_VAR_CORPORATE_URL_TYPE] => ) )
Render > header_menu.block
Array ( [twd] => Array ( [cnt] => 0 [menus] => Array ( [0] => RDataRecord Object ( [_Data:protected] => Array ( [menu_id] => 2 [menu_link] => product_list.php [menu_target] => _self [menu_position] => header [link_display] => 2 [menu_option] => 2 [status] => 1 [sort_order] => 0 [menu_link_category] => 6 [link_type_id] => 0 [master_menu_id] => 0 [corporate_id] => 0 [menu_title] => Products [menu_image] => fa-list [site_language_id] => 1 ) [_IteratorKeys:protected] => Array ( [0] => menu_id [1] => menu_link [2] => menu_target [3] => menu_position [4] => link_display [5] => menu_option [6] => status [7] => sort_order [8] => menu_link_category [9] => link_type_id [10] => master_menu_id [11] => corporate_id [12] => menu_title [13] => menu_image [14] => site_language_id ) ) [1] => RDataRecord Object ( [_Data:protected] => Array ( [menu_id] => 70 [menu_link] => cms.php?page=photobooks [menu_target] => _self [menu_position] => header [link_display] => 2 [menu_option] => 0 [status] => 1 [sort_order] => 1 [menu_link_category] => 1 [link_type_id] => 99 [master_menu_id] => 0 [corporate_id] => 0 [menu_title] => photo books [menu_image] => [site_language_id] => 1 ) [_IteratorKeys:protected] => Array ( [0] => menu_id [1] => menu_link [2] => menu_target [3] => menu_position [4] => link_display [5] => menu_option [6] => status [7] => sort_order [8] => menu_link_category [9] => link_type_id [10] => master_menu_id [11] => corporate_id [12] => menu_title [13] => menu_image [14] => site_language_id ) ) [2] => RDataRecord Object ( [_Data:protected] => Array ( [menu_id] => 69 [menu_link] => cms.php?page=calendar [menu_target] => _self [menu_position] => header [link_display] => 2 [menu_option] => 0 [status] => 1 [sort_order] => 2 [menu_link_category] => 1 [link_type_id] => 97 [master_menu_id] => 0 [corporate_id] => 0 [menu_title] => calendars [menu_image] => [site_language_id] => 1 ) [_IteratorKeys:protected] => Array ( [0] => menu_id [1] => menu_link [2] => menu_target [3] => menu_position [4] => link_display [5] => menu_option [6] => status [7] => sort_order [8] => menu_link_category [9] => link_type_id [10] => master_menu_id [11] => corporate_id [12] => menu_title [13] => menu_image [14] => site_language_id ) ) [3] => RDataRecord Object ( [_Data:protected] => Array ( [menu_id] => 3 [menu_link] => product_prices.php [menu_target] => _self [menu_position] => header [link_display] => 2 [menu_option] => 0 [status] => 1 [sort_order] => 3 [menu_link_category] => 2 [link_type_id] => 0 [master_menu_id] => 0 [corporate_id] => 0 [menu_title] => Pricing [menu_image] => [site_language_id] => 1 ) [_IteratorKeys:protected] => Array ( [0] => menu_id [1] => menu_link [2] => menu_target [3] => menu_position [4] => link_display [5] => menu_option [6] => status [7] => sort_order [8] => menu_link_category [9] => link_type_id [10] => master_menu_id [11] => corporate_id [12] => menu_title [13] => menu_image [14] => site_language_id ) ) [4] => RDataRecord Object ( [_Data:protected] => Array ( [menu_id] => 44 [menu_link] => cms.php?page=contact_us [menu_target] => _self [menu_position] => header [link_display] => 2 [menu_option] => 0 [status] => 1 [sort_order] => 5 [menu_link_category] => 1 [link_type_id] => 10 [master_menu_id] => 0 [corporate_id] => 0 [menu_title] => Contact us [menu_image] => fa-envelope-o [site_language_id] => 1 ) [_IteratorKeys:protected] => Array ( [0] => menu_id [1] => menu_link [2] => menu_target [3] => menu_position [4] => link_display [5] => menu_option [6] => status [7] => sort_order [8] => menu_link_category [9] => link_type_id [10] => master_menu_id [11] => corporate_id [12] => menu_title [13] => menu_image [14] => site_language_id ) ) ) [arr_myaccount_menu_link] => Array ( [0] => user_account.php [1] => user_order.php [3] => user_portfolio.php [4] => quote.php [5] => user_order_inventory.php [7] => user_reward.php [8] => user_images.php [9] => user_qrcode_list.php [10] => user_address.php [11] => user_profile.php [12] => user_store_profile.php [13] => sales_order_report.php [14] => user_changepassword.php ) [form] => Array ( [fb_button] => Facebook [fb_link] => https://www.facebook.com/dialog/oauth?client_id=207871080027786&redirect_uri=http%3A%2F%2Fabcimaging.dev.radixweb.net%2Fuser_registration.php&state=0054c32e638a87ccbc6c9e00ec614927&scope=email&return_url=http%3A%2F%2Fabcimaging.dev.radixweb.net%2Fuser_registration.php ) [SITE_VAR_DESIGNER_MODULE_ENABLE] => 0 [group_category] => Array ( [-1] => Array ( [group_name] => [group_enable] => [group_pro_text] => [groups] => Array ( [10] => Array ( [category_name] => Specialty Products [cat_enable] => 0 [cat_pro_text] => [products] => Array ( [97] => Array ( [pname] => Canvas Prints [pro_enable] => no [pro_title] => [product_url] => canvasprints ) [68] => Array ( [pname] => Square Magnets [pro_enable] => [pro_title] => [product_url] => square-magnets ) [67] => Array ( [pname] => Custom Shape Magnet [pro_enable] => [pro_title] => [product_url] => custom-shape-magnet ) ) ) [8] => Array ( [category_name] => Photo Books [cat_enable] => 0 [cat_pro_text] => [products] => Array ( [2001] => Array ( [pname] => Test Photoprint Product [pro_enable] => [pro_title] => [product_url] => test-photoprint-product ) [96] => Array ( [pname] => Photo Book (8x8) [pro_enable] => [pro_title] => [product_url] => square-photo-book-8x8-inch ) [95] => Array ( [pname] => Photo Book (12x12) [pro_enable] => [pro_title] => [product_url] => square-photo-book-12x12-inch ) [94] => Array ( [pname] => Photo Book (Portrait) [pro_enable] => [pro_title] => [product_url] => photobook-portrait ) [2000] => Array ( [pname] => Photo Book (Landscape) [pro_enable] => [pro_title] => [product_url] => photobook-landscape ) ) ) [3] => Array ( [category_name] => Marketing Materials [cat_enable] => 0 [cat_pro_text] => [products] => Array ( [23] => Array ( [pname] => Banners [pro_enable] => [pro_title] => [product_url] => banners ) [4] => Array ( [pname] => Postcards [pro_enable] => [pro_title] => [product_url] => postcards ) [66] => Array ( [pname] => Yard Sign Banners [pro_enable] => [pro_title] => [product_url] => yard-sign-banners ) [82] => Array ( [pname] => Car Door Magnets [pro_enable] => [pro_title] => [product_url] => car-door-magnets ) [22] => Array ( [pname] => Catalogs Both Side [pro_enable] => [pro_title] => [product_url] => catalogs-both-side ) [26] => Array ( [pname] => Door Hangers Two Side [pro_enable] => [pro_title] => [product_url] => door-hangers-two-side ) [7] => Array ( [pname] => Brochures [pro_enable] => [pro_title] => [product_url] => brochures ) [2] => Array ( [pname] => Flyers One Side [pro_enable] => [pro_title] => [product_url] => flyers-one-side ) ) ) [11] => Array ( [category_name] => Posters, Banners & Signs [cat_enable] => 0 [cat_pro_text] => [products] => Array ( [24] => Array ( [pname] => Posters [pro_enable] => no [pro_title] => [product_url] => posters ) ) ) [2] => Array ( [category_name] => Business Stationary [cat_enable] => 0 [cat_pro_text] => [products] => Array ( [5] => Array ( [pname] => Envelopes [pro_enable] => [pro_title] => [product_url] => envelopes ) [20] => Array ( [pname] => Greeting Cards [pro_enable] => [pro_title] => [product_url] => greeting-cards ) [3] => Array ( [pname] => Letterhead [pro_enable] => [pro_title] => [product_url] => letterhead ) ) ) ) ) ) [kit_data] => Array ( [0] => Array ( [imagename] => [description] => [title] => Test kit product [id] => 1 [url] => http://abcimaging.dev.radixweb.net/product_kit_info.php?kid=1 ) ) [SITE_VAR_USERNAME_LOGIN] => N [SITE_VAR_CORPORATE_URL_TYPE] => ) )
Render > product_category_group.block
Array ( [twd] => Array ( [product_count] => 20 [FArray] => Array ( [0] => product_info.php [1] => product_design_upload.php [2] => product_designs.php [3] => corporate_products.php ) [productCategoryDetails] => RDataRecordSet Object ( [ResultData:RDataRecordSet:private] => PDOStatement Object ( [queryString] => SELECT pp.sort_order AS group_srt,products.category_id as cat_id, products_description.product_url,product_category.category_id,product_category.category_pro_enable,products.multiple_category,product_category_description.category_name,product_category_description.category_promotional_text,product_category.parent_id, products.products_id, products.predefined_product_type, products_description.products_title,products_description.product_promotional_text,product_settings.setting_constant_name,product_settings.setting_value,pcd.category_name AS group_name FROM products LEFT JOIN product_category ON products.category_id = product_category.category_id OR (find_in_set(product_category.category_id,products.multiple_category) > 0) LEFT JOIN product_category_description ON (product_category_description.category_id = product_category.category_id AND product_category_description.site_language_id = :pcd_site_language_id) LEFT JOIN product_category pp ON pp.category_id = product_category.parent_id AND pp.status = :pp_status LEFT JOIN product_category_description pcd ON pcd.category_id = product_category.parent_id AND pp.status = '1' AND pcd.site_language_id = :pcd_site_language_id1 LEFT JOIN products_description ON (products_description.products_id = products.products_id AND products_description.site_language_id = :products_description_site_language_id) LEFT JOIN product_settings ON (product_settings.products_id = products.products_id AND product_settings.setting_constant_name = 'PRODUCT_PROMOTION_IN_TITLE') WHERE product_category.status = :product_category_status AND products.visible = :products_visible_2 AND products.products_id != :products_id_quote AND products.predefined_product_type IN (:input_0, :input_1, :input_2, :input_3, :input_4) AND products.product_service_type NOT IN (:input_5, :input_6, :input_7, :input_8) AND (products.user_type_id = :products_corporate_id_1 OR products.user_type_id = :products_user_type_id_0) ORDER BY -group_srt DESC, product_category.sort_order ASC, product_category.parent_id ASC, product_category.category_id ASC, products.sort_order ASC,products_description.products_title ASC, products.products_id ASC ) [AffectedRows:RDataRecordSet:private] => 20 [RecordCount] => 20 [foundRows] => -1 [RecordList:RDataRecordSet:private] => Array ( [0] => RDataRecord Object ( [_Data:protected] => Array ( [group_srt] => [cat_id] => 10 [product_url] => canvasprints [category_id] => 10 [category_pro_enable] => 0 [multiple_category] => [category_name] => Specialty Products [category_promotional_text] => [parent_id] => -1 [products_id] => 97 [predefined_product_type] => 0 [products_title] => Canvas Prints [product_promotional_text] => [setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE [setting_value] => no [group_name] => ) [_IteratorKeys:protected] => Array ( [0] => group_srt [1] => cat_id [2] => product_url [3] => category_id [4] => category_pro_enable [5] => multiple_category [6] => category_name [7] => category_promotional_text [8] => parent_id [9] => products_id [10] => predefined_product_type [11] => products_title [12] => product_promotional_text [13] => setting_constant_name [14] => setting_value [15] => group_name ) ) [1] => RDataRecord Object ( [_Data:protected] => Array ( [group_srt] => [cat_id] => 10 [product_url] => square-magnets [category_id] => 10 [category_pro_enable] => 0 [multiple_category] => [category_name] => Specialty Products [category_promotional_text] => [parent_id] => -1 [products_id] => 68 [predefined_product_type] => 0 [products_title] => Square Magnets [product_promotional_text] => [setting_constant_name] => [setting_value] => [group_name] => ) [_IteratorKeys:protected] => Array ( [0] => group_srt [1] => cat_id [2] => product_url [3] => category_id [4] => category_pro_enable [5] => multiple_category [6] => category_name [7] => category_promotional_text [8] => parent_id [9] => products_id [10] => predefined_product_type [11] => products_title [12] => product_promotional_text [13] => setting_constant_name [14] => setting_value [15] => group_name ) ) [2] => RDataRecord Object ( [_Data:protected] => Array ( [group_srt] => [cat_id] => 10 [product_url] => custom-shape-magnet [category_id] => 10 [category_pro_enable] => 0 [multiple_category] => [category_name] => Specialty Products [category_promotional_text] => [parent_id] => -1 [products_id] => 67 [predefined_product_type] => 0 [products_title] => Custom Shape Magnet [product_promotional_text] => [setting_constant_name] => [setting_value] => [group_name] => ) [_IteratorKeys:protected] => Array ( [0] => group_srt [1] => cat_id [2] => product_url [3] => category_id [4] => category_pro_enable [5] => multiple_category [6] => category_name [7] => category_promotional_text [8] => parent_id [9] => products_id [10] => predefined_product_type [11] => products_title [12] => product_promotional_text [13] => setting_constant_name [14] => setting_value [15] => group_name ) ) [3] => RDataRecord Object ( [_Data:protected] => Array ( [group_srt] => [cat_id] => 8 [product_url] => test-photoprint-product [category_id] => 8 [category_pro_enable] => 0 [multiple_category] => [category_name] => Photo Books [category_promotional_text] => [parent_id] => -1 [products_id] => 2001 [predefined_product_type] => 12 [products_title] => Test Photoprint Product [product_promotional_text] => [setting_constant_name] => [setting_value] => [group_name] => ) [_IteratorKeys:protected] => Array ( [0] => group_srt [1] => cat_id [2] => product_url [3] => category_id [4] => category_pro_enable [5] => multiple_category [6] => category_name [7] => category_promotional_text [8] => parent_id [9] => products_id [10] => predefined_product_type [11] => products_title [12] => product_promotional_text [13] => setting_constant_name [14] => setting_value [15] => group_name ) ) [4] => RDataRecord Object ( [_Data:protected] => Array ( [group_srt] => [cat_id] => 8 [product_url] => square-photo-book-8x8-inch [category_id] => 8 [category_pro_enable] => 0 [multiple_category] => [category_name] => Photo Books [category_promotional_text] => [parent_id] => -1 [products_id] => 96 [predefined_product_type] => 3 [products_title] => Photo Book (8x8) [product_promotional_text] => [setting_constant_name] => [setting_value] => [group_name] => ) [_IteratorKeys:protected] => Array ( [0] => group_srt [1] => cat_id [2] => product_url [3] => category_id [4] => category_pro_enable [5] => multiple_category [6] => category_name [7] => category_promotional_text [8] => parent_id [9] => products_id [10] => predefined_product_type [11] => products_title [12] => product_promotional_text [13] => setting_constant_name [14] => setting_value [15] => group_name ) ) [5] => RDataRecord Object ( [_Data:protected] => Array ( [group_srt] => [cat_id] => 8 [product_url] => square-photo-book-12x12-inch [category_id] => 8 [category_pro_enable] => 0 [multiple_category] => [category_name] => Photo Books [category_promotional_text] => [parent_id] => -1 [products_id] => 95 [predefined_product_type] => 3 [products_title] => Photo Book (12x12) [product_promotional_text] => [setting_constant_name] => [setting_value] => [group_name] => ) [_IteratorKeys:protected] => Array ( [0] => group_srt [1] => cat_id [2] => product_url [3] => category_id [4] => category_pro_enable [5] => multiple_category [6] => category_name [7] => category_promotional_text [8] => parent_id [9] => products_id [10] => predefined_product_type [11] => products_title [12] => product_promotional_text [13] => setting_constant_name [14] => setting_value [15] => group_name ) ) [6] => RDataRecord Object ( [_Data:protected] => Array ( [group_srt] => [cat_id] => 8 [product_url] => photobook-portrait [category_id] => 8 [category_pro_enable] => 0 [multiple_category] => [category_name] => Photo Books [category_promotional_text] => [parent_id] => -1 [products_id] => 94 [predefined_product_type] => 3 [products_title] => Photo Book (Portrait) [product_promotional_text] => [setting_constant_name] => [setting_value] => [group_name] => ) [_IteratorKeys:protected] => Array ( [0] => group_srt [1] => cat_id [2] => product_url [3] => category_id [4] => category_pro_enable [5] => multiple_category [6] => category_name [7] => category_promotional_text [8] => parent_id [9] => products_id [10] => predefined_product_type [11] => products_title [12] => product_promotional_text [13] => setting_constant_name [14] => setting_value [15] => group_name ) ) [7] => RDataRecord Object ( [_Data:protected] => Array ( [group_srt] => [cat_id] => 8 [product_url] => photobook-landscape [category_id] => 8 [category_pro_enable] => 0 [multiple_category] => [category_name] => Photo Books [category_promotional_text] => [parent_id] => -1 [products_id] => 2000 [predefined_product_type] => 3 [products_title] => Photo Book (Landscape) [product_promotional_text] => [setting_constant_name] => [setting_value] => [group_name] => ) [_IteratorKeys:protected] => Array ( [0] => group_srt [1] => cat_id [2] => product_url [3] => category_id [4] => category_pro_enable [5] => multiple_category [6] => category_name [7] => category_promotional_text [8] => parent_id [9] => products_id [10] => predefined_product_type [11] => products_title [12] => product_promotional_text [13] => setting_constant_name [14] => setting_value [15] => group_name ) ) [8] => RDataRecord Object ( [_Data:protected] => Array ( [group_srt] => [cat_id] => 3 [product_url] => banners [category_id] => 3 [category_pro_enable] => 0 [multiple_category] => [category_name] => Marketing Materials [category_promotional_text] => [parent_id] => -1 [products_id] => 23 [predefined_product_type] => 0 [products_title] => Banners [product_promotional_text] => [setting_constant_name] => [setting_value] => [group_name] => ) [_IteratorKeys:protected] => Array ( [0] => group_srt [1] => cat_id [2] => product_url [3] => category_id [4] => category_pro_enable [5] => multiple_category [6] => category_name [7] => category_promotional_text [8] => parent_id [9] => products_id [10] => predefined_product_type [11] => products_title [12] => product_promotional_text [13] => setting_constant_name [14] => setting_value [15] => group_name ) ) [9] => RDataRecord Object ( [_Data:protected] => Array ( [group_srt] => [cat_id] => 3 [product_url] => postcards [category_id] => 3 [category_pro_enable] => 0 [multiple_category] => [category_name] => Marketing Materials [category_promotional_text] => [parent_id] => -1 [products_id] => 4 [predefined_product_type] => 0 [products_title] => Postcards [product_promotional_text] => [setting_constant_name] => [setting_value] => [group_name] => ) [_IteratorKeys:protected] => Array ( [0] => group_srt [1] => cat_id [2] => product_url [3] => category_id [4] => category_pro_enable [5] => multiple_category [6] => category_name [7] => category_promotional_text [8] => parent_id [9] => products_id [10] => predefined_product_type [11] => products_title [12] => product_promotional_text [13] => setting_constant_name [14] => setting_value [15] => group_name ) ) [10] => RDataRecord Object ( [_Data:protected] => Array ( [group_srt] => [cat_id] => 3 [product_url] => yard-sign-banners [category_id] => 3 [category_pro_enable] => 0 [multiple_category] => [category_name] => Marketing Materials [category_promotional_text] => [parent_id] => -1 [products_id] => 66 [predefined_product_type] => 0 [products_title] => Yard Sign Banners [product_promotional_text] => [setting_constant_name] => [setting_value] => [group_name] => ) [_IteratorKeys:protected] => Array ( [0] => group_srt [1] => cat_id [2] => product_url [3] => category_id [4] => category_pro_enable [5] => multiple_category [6] => category_name [7] => category_promotional_text [8] => parent_id [9] => products_id [10] => predefined_product_type [11] => products_title [12] => product_promotional_text [13] => setting_constant_name [14] => setting_value [15] => group_name ) ) [11] => RDataRecord Object ( [_Data:protected] => Array ( [group_srt] => [cat_id] => 3 [product_url] => car-door-magnets [category_id] => 3 [category_pro_enable] => 0 [multiple_category] => [category_name] => Marketing Materials [category_promotional_text] => [parent_id] => -1 [products_id] => 82 [predefined_product_type] => 0 [products_title] => Car Door Magnets [product_promotional_text] => [setting_constant_name] => [setting_value] => [group_name] => ) [_IteratorKeys:protected] => Array ( [0] => group_srt [1] => cat_id [2] => product_url [3] => category_id [4] => category_pro_enable [5] => multiple_category [6] => category_name [7] => category_promotional_text [8] => parent_id [9] => products_id [10] => predefined_product_type [11] => products_title [12] => product_promotional_text [13] => setting_constant_name [14] => setting_value [15] => group_name ) ) [12] => RDataRecord Object ( [_Data:protected] => Array ( [group_srt] => [cat_id] => 3 [product_url] => catalogs-both-side [category_id] => 3 [category_pro_enable] => 0 [multiple_category] => [category_name] => Marketing Materials [category_promotional_text] => [parent_id] => -1 [products_id] => 22 [predefined_product_type] => 0 [products_title] => Catalogs Both Side [product_promotional_text] => [setting_constant_name] => [setting_value] => [group_name] => ) [_IteratorKeys:protected] => Array ( [0] => group_srt [1] => cat_id [2] => product_url [3] => category_id [4] => category_pro_enable [5] => multiple_category [6] => category_name [7] => category_promotional_text [8] => parent_id [9] => products_id [10] => predefined_product_type [11] => products_title [12] => product_promotional_text [13] => setting_constant_name [14] => setting_value [15] => group_name ) ) [13] => RDataRecord Object ( [_Data:protected] => Array ( [group_srt] => [cat_id] => 3 [product_url] => door-hangers-two-side [category_id] => 3 [category_pro_enable] => 0 [multiple_category] => [category_name] => Marketing Materials [category_promotional_text] => [parent_id] => -1 [products_id] => 26 [predefined_product_type] => 0 [products_title] => Door Hangers Two Side [product_promotional_text] => [setting_constant_name] => [setting_value] => [group_name] => ) [_IteratorKeys:protected] => Array ( [0] => group_srt [1] => cat_id [2] => product_url [3] => category_id [4] => category_pro_enable [5] => multiple_category [6] => category_name [7] => category_promotional_text [8] => parent_id [9] => products_id [10] => predefined_product_type [11] => products_title [12] => product_promotional_text [13] => setting_constant_name [14] => setting_value [15] => group_name ) ) [14] => RDataRecord Object ( [_Data:protected] => Array ( [group_srt] => [cat_id] => 3 [product_url] => brochures [category_id] => 3 [category_pro_enable] => 0 [multiple_category] => [category_name] => Marketing Materials [category_promotional_text] => [parent_id] => -1 [products_id] => 7 [predefined_product_type] => 0 [products_title] => Brochures [product_promotional_text] => [setting_constant_name] => [setting_value] => [group_name] => ) [_IteratorKeys:protected] => Array ( [0] => group_srt [1] => cat_id [2] => product_url [3] => category_id [4] => category_pro_enable [5] => multiple_category [6] => category_name [7] => category_promotional_text [8] => parent_id [9] => products_id [10] => predefined_product_type [11] => products_title [12] => product_promotional_text [13] => setting_constant_name [14] => setting_value [15] => group_name ) ) [15] => RDataRecord Object ( [_Data:protected] => Array ( [group_srt] => [cat_id] => 3 [product_url] => flyers-one-side [category_id] => 3 [category_pro_enable] => 0 [multiple_category] => [category_name] => Marketing Materials [category_promotional_text] => [parent_id] => -1 [products_id] => 2 [predefined_product_type] => 0 [products_title] => Flyers One Side [product_promotional_text] => [setting_constant_name] => [setting_value] => [group_name] => ) [_IteratorKeys:protected] => Array ( [0] => group_srt [1] => cat_id [2] => product_url [3] => category_id [4] => category_pro_enable [5] => multiple_category [6] => category_name [7] => category_promotional_text [8] => parent_id [9] => products_id [10] => predefined_product_type [11] => products_title [12] => product_promotional_text [13] => setting_constant_name [14] => setting_value [15] => group_name ) ) [16] => RDataRecord Object ( [_Data:protected] => Array ( [group_srt] => [cat_id] => 11 [product_url] => posters [category_id] => 11 [category_pro_enable] => 0 [multiple_category] => [category_name] => Posters, Banners & Signs [category_promotional_text] => [parent_id] => -1 [products_id] => 24 [predefined_product_type] => 0 [products_title] => Posters [product_promotional_text] => [setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE [setting_value] => no [group_name] => ) [_IteratorKeys:protected] => Array ( [0] => group_srt [1] => cat_id [2] => product_url [3] => category_id [4] => category_pro_enable [5] => multiple_category [6] => category_name [7] => category_promotional_text [8] => parent_id [9] => products_id [10] => predefined_product_type [11] => products_title [12] => product_promotional_text [13] => setting_constant_name [14] => setting_value [15] => group_name ) ) [17] => RDataRecord Object ( [_Data:protected] => Array ( [group_srt] => [cat_id] => 2 [product_url] => envelopes [category_id] => 2 [category_pro_enable] => 0 [multiple_category] => [category_name] => Business Stationary [category_promotional_text] => [parent_id] => -1 [products_id] => 5 [predefined_product_type] => 0 [products_title] => Envelopes [product_promotional_text] => [setting_constant_name] => [setting_value] => [group_name] => ) [_IteratorKeys:protected] => Array ( [0] => group_srt [1] => cat_id [2] => product_url [3] => category_id [4] => category_pro_enable [5] => multiple_category [6] => category_name [7] => category_promotional_text [8] => parent_id [9] => products_id [10] => predefined_product_type [11] => products_title [12] => product_promotional_text [13] => setting_constant_name [14] => setting_value [15] => group_name ) ) [18] => RDataRecord Object ( [_Data:protected] => Array ( [group_srt] => [cat_id] => 2 [product_url] => greeting-cards [category_id] => 2 [category_pro_enable] => 0 [multiple_category] => [category_name] => Business Stationary [category_promotional_text] => [parent_id] => -1 [products_id] => 20 [predefined_product_type] => 0 [products_title] => Greeting Cards [product_promotional_text] => [setting_constant_name] => [setting_value] => [group_name] => ) [_IteratorKeys:protected] => Array ( [0] => group_srt [1] => cat_id [2] => product_url [3] => category_id [4] => category_pro_enable [5] => multiple_category [6] => category_name [7] => category_promotional_text [8] => parent_id [9] => products_id [10] => predefined_product_type [11] => products_title [12] => product_promotional_text [13] => setting_constant_name [14] => setting_value [15] => group_name ) ) [19] => RDataRecord Object ( [_Data:protected] => Array ( [group_srt] => [cat_id] => 2 [product_url] => letterhead [category_id] => 2 [category_pro_enable] => 0 [multiple_category] => [category_name] => Business Stationary [category_promotional_text] => [parent_id] => -1 [products_id] => 3 [predefined_product_type] => 0 [products_title] => Letterhead [product_promotional_text] => [setting_constant_name] => [setting_value] => [group_name] => ) [_IteratorKeys:protected] => Array ( [0] => group_srt [1] => cat_id [2] => product_url [3] => category_id [4] => category_pro_enable [5] => multiple_category [6] => category_name [7] => category_promotional_text [8] => parent_id [9] => products_id [10] => predefined_product_type [11] => products_title [12] => product_promotional_text [13] => setting_constant_name [14] => setting_value [15] => group_name ) ) ) [IteratorCount:RDataRecordSet:private] => 20 [last_query] => SELECT pp.sort_order AS group_srt,products.category_id as cat_id, products_description.product_url,product_category.category_id,product_category.category_pro_enable,products.multiple_category,product_category_description.category_name,product_category_description.category_promotional_text,product_category.parent_id, products.products_id, products.predefined_product_type, products_description.products_title,products_description.product_promotional_text,product_settings.setting_constant_name,product_settings.setting_value,pcd.category_name AS group_name FROM products LEFT JOIN product_category ON products.category_id = product_category.category_id OR (find_in_set(product_category.category_id,products.multiple_category) > 0) LEFT JOIN product_category_description ON (product_category_description.category_id = product_category.category_id AND product_category_description.site_language_id = 1) LEFT JOIN product_category pp ON pp.category_id = product_category.parent_id AND pp.status = '1' LEFT JOIN product_category_description pcd ON pcd.category_id = product_category.parent_id AND pp.status = '1' AND pcd.site_language_id = 1 LEFT JOIN products_description ON (products_description.products_id = products.products_id AND products_description.site_language_id = 1) LEFT JOIN product_settings ON (product_settings.products_id = products.products_id AND product_settings.setting_constant_name = 'PRODUCT_PROMOTION_IN_TITLE') WHERE product_category.status = '1' AND products.visible = '1' AND products.products_id != '-11' AND products.predefined_product_type IN ('0', '11', '1', '3', '12') AND products.product_service_type NOT IN ('2', '3', '4', '5') AND (products.user_type_id = '1' OR products.user_type_id = '0') ORDER BY -group_srt DESC, product_category.sort_order ASC, product_category.parent_id ASC, product_category.category_id ASC, products.sort_order ASC,products_description.products_title ASC, products.products_id ASC ) [CATEGORY_LAYOUT_ENABLED] => toggle [category_product] => Array ( [10] => Array ( [category_name] => Specialty Products [cat_enable] => 0 [cat_pro_text] => [products] => Array ( [97] => Array ( [pname] => Canvas Prints [pro_enable] => no [pro_title] => [cat_id] => 10 [product_url] => canvasprints ) [68] => Array ( [pname] => Square Magnets [pro_enable] => [pro_title] => [cat_id] => 10 [product_url] => square-magnets ) [67] => Array ( [pname] => Custom Shape Magnet [pro_enable] => [pro_title] => [cat_id] => 10 [product_url] => custom-shape-magnet ) ) ) [8] => Array ( [category_name] => Photo Books [cat_enable] => 0 [cat_pro_text] => [products] => Array ( [2001] => Array ( [pname] => Test Photoprint Product [pro_enable] => [pro_title] => [cat_id] => 8 [product_url] => test-photoprint-product ) [96] => Array ( [pname] => Photo Book (8x8) [pro_enable] => [pro_title] => [cat_id] => 8 [product_url] => square-photo-book-8x8-inch ) [95] => Array ( [pname] => Photo Book (12x12) [pro_enable] => [pro_title] => [cat_id] => 8 [product_url] => square-photo-book-12x12-inch ) [94] => Array ( [pname] => Photo Book (Portrait) [pro_enable] => [pro_title] => [cat_id] => 8 [product_url] => photobook-portrait ) [2000] => Array ( [pname] => Photo Book (Landscape) [pro_enable] => [pro_title] => [cat_id] => 8 [product_url] => photobook-landscape ) ) ) [3] => Array ( [category_name] => Marketing Materials [cat_enable] => 0 [cat_pro_text] => [products] => Array ( [23] => Array ( [pname] => Banners [pro_enable] => [pro_title] => [cat_id] => 3 [product_url] => banners ) [4] => Array ( [pname] => Postcards [pro_enable] => [pro_title] => [cat_id] => 3 [product_url] => postcards ) [66] => Array ( [pname] => Yard Sign Banners [pro_enable] => [pro_title] => [cat_id] => 3 [product_url] => yard-sign-banners ) [82] => Array ( [pname] => Car Door Magnets [pro_enable] => [pro_title] => [cat_id] => 3 [product_url] => car-door-magnets ) [22] => Array ( [pname] => Catalogs Both Side [pro_enable] => [pro_title] => [cat_id] => 3 [product_url] => catalogs-both-side ) [26] => Array ( [pname] => Door Hangers Two Side [pro_enable] => [pro_title] => [cat_id] => 3 [product_url] => door-hangers-two-side ) [7] => Array ( [pname] => Brochures [pro_enable] => [pro_title] => [cat_id] => 3 [product_url] => brochures ) [2] => Array ( [pname] => Flyers One Side [pro_enable] => [pro_title] => [cat_id] => 3 [product_url] => flyers-one-side ) ) ) [11] => Array ( [category_name] => Posters, Banners & Signs [cat_enable] => 0 [cat_pro_text] => [products] => Array ( [24] => Array ( [pname] => Posters [pro_enable] => no [pro_title] => [cat_id] => 11 [product_url] => posters ) ) ) [2] => Array ( [category_name] => Business Stationary [cat_enable] => 0 [cat_pro_text] => [products] => Array ( [5] => Array ( [pname] => Envelopes [pro_enable] => [pro_title] => [cat_id] => 2 [product_url] => envelopes ) [20] => Array ( [pname] => Greeting Cards [pro_enable] => [pro_title] => [cat_id] => 2 [product_url] => greeting-cards ) [3] => Array ( [pname] => Letterhead [pro_enable] => [pro_title] => [cat_id] => 2 [product_url] => letterhead ) ) ) ) [selected_category] => 11 [allgroupcategorys] => RDataRecordSet Object ( [ResultData:RDataRecordSet:private] => PDOStatement Object ( [queryString] => SELECT pp.sort_order AS group_srt,products.category_id as cat_id, products_description.product_url,product_category.category_id,product_category.category_pro_enable,products.multiple_category,product_category_description.category_name,product_category_description.category_promotional_text,product_category.parent_id, products.products_id, products.predefined_product_type, products_description.products_title,products_description.product_promotional_text,product_settings.setting_constant_name,product_settings.setting_value,pcd.category_name AS group_name FROM products LEFT JOIN product_category ON products.category_id = product_category.category_id OR (find_in_set(product_category.category_id,products.multiple_category) > 0) LEFT JOIN product_category_description ON (product_category_description.category_id = product_category.category_id AND product_category_description.site_language_id = :pcd_site_language_id) LEFT JOIN product_category pp ON pp.category_id = product_category.parent_id AND pp.status = :pp_status LEFT JOIN product_category_description pcd ON pcd.category_id = product_category.parent_id AND pp.status = '1' AND pcd.site_language_id = :pcd_site_language_id1 LEFT JOIN products_description ON (products_description.products_id = products.products_id AND products_description.site_language_id = :products_description_site_language_id) LEFT JOIN product_settings ON (product_settings.products_id = products.products_id AND product_settings.setting_constant_name = 'PRODUCT_PROMOTION_IN_TITLE') WHERE product_category.status = :product_category_status AND products.visible = :products_visible_2 AND products.products_id != :products_id_quote AND products.predefined_product_type IN (:input_0, :input_1, :input_2, :input_3, :input_4) AND products.product_service_type NOT IN (:input_5, :input_6, :input_7, :input_8) AND (products.user_type_id = :products_corporate_id_1 OR products.user_type_id = :products_user_type_id_0) ORDER BY -group_srt DESC, product_category.sort_order ASC, product_category.parent_id ASC, product_category.category_id ASC, products.sort_order ASC,products_description.products_title ASC, products.products_id ASC ) [AffectedRows:RDataRecordSet:private] => 20 [RecordCount] => 20 [foundRows] => -1 [RecordList:RDataRecordSet:private] => Array ( [0] => RDataRecord Object ( [_Data:protected] => Array ( [group_srt] => [cat_id] => 10 [product_url] => canvasprints [category_id] => 10 [category_pro_enable] => 0 [multiple_category] => [category_name] => Specialty Products [category_promotional_text] => [parent_id] => -1 [products_id] => 97 [predefined_product_type] => 0 [products_title] => Canvas Prints [product_promotional_text] => [setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE [setting_value] => no [group_name] => ) [_IteratorKeys:protected] => Array ( [0] => group_srt [1] => cat_id [2] => product_url [3] => category_id [4] => category_pro_enable [5] => multiple_category [6] => category_name [7] => category_promotional_text [8] => parent_id [9] => products_id [10] => predefined_product_type [11] => products_title [12] => product_promotional_text [13] => setting_constant_name [14] => setting_value [15] => group_name ) ) [1] => RDataRecord Object ( [_Data:protected] => Array ( [group_srt] => [cat_id] => 10 [product_url] => square-magnets [category_id] => 10 [category_pro_enable] => 0 [multiple_category] => [category_name] => Specialty Products [category_promotional_text] => [parent_id] => -1 [products_id] => 68 [predefined_product_type] => 0 [products_title] => Square Magnets [product_promotional_text] => [setting_constant_name] => [setting_value] => [group_name] => ) [_IteratorKeys:protected] => Array ( [0] => group_srt [1] => cat_id [2] => product_url [3] => category_id [4] => category_pro_enable [5] => multiple_category [6] => category_name [7] => category_promotional_text [8] => parent_id [9] => products_id [10] => predefined_product_type [11] => products_title [12] => product_promotional_text [13] => setting_constant_name [14] => setting_value [15] => group_name ) ) [2] => RDataRecord Object ( [_Data:protected] => Array ( [group_srt] => [cat_id] => 10 [product_url] => custom-shape-magnet [category_id] => 10 [category_pro_enable] => 0 [multiple_category] => [category_name] => Specialty Products [category_promotional_text] => [parent_id] => -1 [products_id] => 67 [predefined_product_type] => 0 [products_title] => Custom Shape Magnet [product_promotional_text] => [setting_constant_name] => [setting_value] => [group_name] => ) [_IteratorKeys:protected] => Array ( [0] => group_srt [1] => cat_id [2] => product_url [3] => category_id [4] => category_pro_enable [5] => multiple_category [6] => category_name [7] => category_promotional_text [8] => parent_id [9] => products_id [10] => predefined_product_type [11] => products_title [12] => product_promotional_text [13] => setting_constant_name [14] => setting_value [15] => group_name ) ) [3] => RDataRecord Object ( [_Data:protected] => Array ( [group_srt] => [cat_id] => 8 [product_url] => test-photoprint-product [category_id] => 8 [category_pro_enable] => 0 [multiple_category] => [category_name] => Photo Books [category_promotional_text] => [parent_id] => -1 [products_id] => 2001 [predefined_product_type] => 12 [products_title] => Test Photoprint Product [product_promotional_text] => [setting_constant_name] => [setting_value] => [group_name] => ) [_IteratorKeys:protected] => Array ( [0] => group_srt [1] => cat_id [2] => product_url [3] => category_id [4] => category_pro_enable [5] => multiple_category [6] => category_name [7] => category_promotional_text [8] => parent_id [9] => products_id [10] => predefined_product_type [11] => products_title [12] => product_promotional_text [13] => setting_constant_name [14] => setting_value [15] => group_name ) ) [4] => RDataRecord Object ( [_Data:protected] => Array ( [group_srt] => [cat_id] => 8 [product_url] => square-photo-book-8x8-inch [category_id] => 8 [category_pro_enable] => 0 [multiple_category] => [category_name] => Photo Books [category_promotional_text] => [parent_id] => -1 [products_id] => 96 [predefined_product_type] => 3 [products_title] => Photo Book (8x8) [product_promotional_text] => [setting_constant_name] => [setting_value] => [group_name] => ) [_IteratorKeys:protected] => Array ( [0] => group_srt [1] => cat_id [2] => product_url [3] => category_id [4] => category_pro_enable [5] => multiple_category [6] => category_name [7] => category_promotional_text [8] => parent_id [9] => products_id [10] => predefined_product_type [11] => products_title [12] => product_promotional_text [13] => setting_constant_name [14] => setting_value [15] => group_name ) ) [5] => RDataRecord Object ( [_Data:protected] => Array ( [group_srt] => [cat_id] => 8 [product_url] => square-photo-book-12x12-inch [category_id] => 8 [category_pro_enable] => 0 [multiple_category] => [category_name] => Photo Books [category_promotional_text] => [parent_id] => -1 [products_id] => 95 [predefined_product_type] => 3 [products_title] => Photo Book (12x12) [product_promotional_text] => [setting_constant_name] => [setting_value] => [group_name] => ) [_IteratorKeys:protected] => Array ( [0] => group_srt [1] => cat_id [2] => product_url [3] => category_id [4] => category_pro_enable [5] => multiple_category [6] => category_name [7] => category_promotional_text [8] => parent_id [9] => products_id [10] => predefined_product_type [11] => products_title [12] => product_promotional_text [13] => setting_constant_name [14] => setting_value [15] => group_name ) ) [6] => RDataRecord Object ( [_Data:protected] => Array ( [group_srt] => [cat_id] => 8 [product_url] => photobook-portrait [category_id] => 8 [category_pro_enable] => 0 [multiple_category] => [category_name] => Photo Books [category_promotional_text] => [parent_id] => -1 [products_id] => 94 [predefined_product_type] => 3 [products_title] => Photo Book (Portrait) [product_promotional_text] => [setting_constant_name] => [setting_value] => [group_name] => ) [_IteratorKeys:protected] => Array ( [0] => group_srt [1] => cat_id [2] => product_url [3] => category_id [4] => category_pro_enable [5] => multiple_category [6] => category_name [7] => category_promotional_text [8] => parent_id [9] => products_id [10] => predefined_product_type [11] => products_title [12] => product_promotional_text [13] => setting_constant_name [14] => setting_value [15] => group_name ) ) [7] => RDataRecord Object ( [_Data:protected] => Array ( [group_srt] => [cat_id] => 8 [product_url] => photobook-landscape [category_id] => 8 [category_pro_enable] => 0 [multiple_category] => [category_name] => Photo Books [category_promotional_text] => [parent_id] => -1 [products_id] => 2000 [predefined_product_type] => 3 [products_title] => Photo Book (Landscape) [product_promotional_text] => [setting_constant_name] => [setting_value] => [group_name] => ) [_IteratorKeys:protected] => Array ( [0] => group_srt [1] => cat_id [2] => product_url [3] => category_id [4] => category_pro_enable [5] => multiple_category [6] => category_name [7] => category_promotional_text [8] => parent_id [9] => products_id [10] => predefined_product_type [11] => products_title [12] => product_promotional_text [13] => setting_constant_name [14] => setting_value [15] => group_name ) ) [8] => RDataRecord Object ( [_Data:protected] => Array ( [group_srt] => [cat_id] => 3 [product_url] => banners [category_id] => 3 [category_pro_enable] => 0 [multiple_category] => [category_name] => Marketing Materials [category_promotional_text] => [parent_id] => -1 [products_id] => 23 [predefined_product_type] => 0 [products_title] => Banners [product_promotional_text] => [setting_constant_name] => [setting_value] => [group_name] => ) [_IteratorKeys:protected] => Array ( [0] => group_srt [1] => cat_id [2] => product_url [3] => category_id [4] => category_pro_enable [5] => multiple_category [6] => category_name [7] => category_promotional_text [8] => parent_id [9] => products_id [10] => predefined_product_type [11] => products_title [12] => product_promotional_text [13] => setting_constant_name [14] => setting_value [15] => group_name ) ) [9] => RDataRecord Object ( [_Data:protected] => Array ( [group_srt] => [cat_id] => 3 [product_url] => postcards [category_id] => 3 [category_pro_enable] => 0 [multiple_category] => [category_name] => Marketing Materials [category_promotional_text] => [parent_id] => -1 [products_id] => 4 [predefined_product_type] => 0 [products_title] => Postcards [product_promotional_text] => [setting_constant_name] => [setting_value] => [group_name] => ) [_IteratorKeys:protected] => Array ( [0] => group_srt [1] => cat_id [2] => product_url [3] => category_id [4] => category_pro_enable [5] => multiple_category [6] => category_name [7] => category_promotional_text [8] => parent_id [9] => products_id [10] => predefined_product_type [11] => products_title [12] => product_promotional_text [13] => setting_constant_name [14] => setting_value [15] => group_name ) ) [10] => RDataRecord Object ( [_Data:protected] => Array ( [group_srt] => [cat_id] => 3 [product_url] => yard-sign-banners [category_id] => 3 [category_pro_enable] => 0 [multiple_category] => [category_name] => Marketing Materials [category_promotional_text] => [parent_id] => -1 [products_id] => 66 [predefined_product_type] => 0 [products_title] => Yard Sign Banners [product_promotional_text] => [setting_constant_name] => [setting_value] => [group_name] => ) [_IteratorKeys:protected] => Array ( [0] => group_srt [1] => cat_id [2] => product_url [3] => category_id [4] => category_pro_enable [5] => multiple_category [6] => category_name [7] => category_promotional_text [8] => parent_id [9] => products_id [10] => predefined_product_type [11] => products_title [12] => product_promotional_text [13] => setting_constant_name [14] => setting_value [15] => group_name ) ) [11] => RDataRecord Object ( [_Data:protected] => Array ( [group_srt] => [cat_id] => 3 [product_url] => car-door-magnets [category_id] => 3 [category_pro_enable] => 0 [multiple_category] => [category_name] => Marketing Materials [category_promotional_text] => [parent_id] => -1 [products_id] => 82 [predefined_product_type] => 0 [products_title] => Car Door Magnets [product_promotional_text] => [setting_constant_name] => [setting_value] => [group_name] => ) [_IteratorKeys:protected] => Array ( [0] => group_srt [1] => cat_id [2] => product_url [3] => category_id [4] => category_pro_enable [5] => multiple_category [6] => category_name [7] => category_promotional_text [8] => parent_id [9] => products_id [10] => predefined_product_type [11] => products_title [12] => product_promotional_text [13] => setting_constant_name [14] => setting_value [15] => group_name ) ) [12] => RDataRecord Object ( [_Data:protected] => Array ( [group_srt] => [cat_id] => 3 [product_url] => catalogs-both-side [category_id] => 3 [category_pro_enable] => 0 [multiple_category] => [category_name] => Marketing Materials [category_promotional_text] => [parent_id] => -1 [products_id] => 22 [predefined_product_type] => 0 [products_title] => Catalogs Both Side [product_promotional_text] => [setting_constant_name] => [setting_value] => [group_name] => ) [_IteratorKeys:protected] => Array ( [0] => group_srt [1] => cat_id [2] => product_url [3] => category_id [4] => category_pro_enable [5] => multiple_category [6] => category_name [7] => category_promotional_text [8] => parent_id [9] => products_id [10] => predefined_product_type [11] => products_title [12] => product_promotional_text [13] => setting_constant_name [14] => setting_value [15] => group_name ) ) [13] => RDataRecord Object ( [_Data:protected] => Array ( [group_srt] => [cat_id] => 3 [product_url] => door-hangers-two-side [category_id] => 3 [category_pro_enable] => 0 [multiple_category] => [category_name] => Marketing Materials [category_promotional_text] => [parent_id] => -1 [products_id] => 26 [predefined_product_type] => 0 [products_title] => Door Hangers Two Side [product_promotional_text] => [setting_constant_name] => [setting_value] => [group_name] => ) [_IteratorKeys:protected] => Array ( [0] => group_srt [1] => cat_id [2] => product_url [3] => category_id [4] => category_pro_enable [5] => multiple_category [6] => category_name [7] => category_promotional_text [8] => parent_id [9] => products_id [10] => predefined_product_type [11] => products_title [12] => product_promotional_text [13] => setting_constant_name [14] => setting_value [15] => group_name ) ) [14] => RDataRecord Object ( [_Data:protected] => Array ( [group_srt] => [cat_id] => 3 [product_url] => brochures [category_id] => 3 [category_pro_enable] => 0 [multiple_category] => [category_name] => Marketing Materials [category_promotional_text] => [parent_id] => -1 [products_id] => 7 [predefined_product_type] => 0 [products_title] => Brochures [product_promotional_text] => [setting_constant_name] => [setting_value] => [group_name] => ) [_IteratorKeys:protected] => Array ( [0] => group_srt [1] => cat_id [2] => product_url [3] => category_id [4] => category_pro_enable [5] => multiple_category [6] => category_name [7] => category_promotional_text [8] => parent_id [9] => products_id [10] => predefined_product_type [11] => products_title [12] => product_promotional_text [13] => setting_constant_name [14] => setting_value [15] => group_name ) ) [15] => RDataRecord Object ( [_Data:protected] => Array ( [group_srt] => [cat_id] => 3 [product_url] => flyers-one-side [category_id] => 3 [category_pro_enable] => 0 [multiple_category] => [category_name] => Marketing Materials [category_promotional_text] => [parent_id] => -1 [products_id] => 2 [predefined_product_type] => 0 [products_title] => Flyers One Side [product_promotional_text] => [setting_constant_name] => [setting_value] => [group_name] => ) [_IteratorKeys:protected] => Array ( [0] => group_srt [1] => cat_id [2] => product_url [3] => category_id [4] => category_pro_enable [5] => multiple_category [6] => category_name [7] => category_promotional_text [8] => parent_id [9] => products_id [10] => predefined_product_type [11] => products_title [12] => product_promotional_text [13] => setting_constant_name [14] => setting_value [15] => group_name ) ) [16] => RDataRecord Object ( [_Data:protected] => Array ( [group_srt] => [cat_id] => 11 [product_url] => posters [category_id] => 11 [category_pro_enable] => 0 [multiple_category] => [category_name] => Posters, Banners & Signs [category_promotional_text] => [parent_id] => -1 [products_id] => 24 [predefined_product_type] => 0 [products_title] => Posters [product_promotional_text] => [setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE [setting_value] => no [group_name] => ) [_IteratorKeys:protected] => Array ( [0] => group_srt [1] => cat_id [2] => product_url [3] => category_id [4] => category_pro_enable [5] => multiple_category [6] => category_name [7] => category_promotional_text [8] => parent_id [9] => products_id [10] => predefined_product_type [11] => products_title [12] => product_promotional_text [13] => setting_constant_name [14] => setting_value [15] => group_name ) ) [17] => RDataRecord Object ( [_Data:protected] => Array ( [group_srt] => [cat_id] => 2 [product_url] => envelopes [category_id] => 2 [category_pro_enable] => 0 [multiple_category] => [category_name] => Business Stationary [category_promotional_text] => [parent_id] => -1 [products_id] => 5 [predefined_product_type] => 0 [products_title] => Envelopes [product_promotional_text] => [setting_constant_name] => [setting_value] => [group_name] => ) [_IteratorKeys:protected] => Array ( [0] => group_srt [1] => cat_id [2] => product_url [3] => category_id [4] => category_pro_enable [5] => multiple_category [6] => category_name [7] => category_promotional_text [8] => parent_id [9] => products_id [10] => predefined_product_type [11] => products_title [12] => product_promotional_text [13] => setting_constant_name [14] => setting_value [15] => group_name ) ) [18] => RDataRecord Object ( [_Data:protected] => Array ( [group_srt] => [cat_id] => 2 [product_url] => greeting-cards [category_id] => 2 [category_pro_enable] => 0 [multiple_category] => [category_name] => Business Stationary [category_promotional_text] => [parent_id] => -1 [products_id] => 20 [predefined_product_type] => 0 [products_title] => Greeting Cards [product_promotional_text] => [setting_constant_name] => [setting_value] => [group_name] => ) [_IteratorKeys:protected] => Array ( [0] => group_srt [1] => cat_id [2] => product_url [3] => category_id [4] => category_pro_enable [5] => multiple_category [6] => category_name [7] => category_promotional_text [8] => parent_id [9] => products_id [10] => predefined_product_type [11] => products_title [12] => product_promotional_text [13] => setting_constant_name [14] => setting_value [15] => group_name ) ) [19] => RDataRecord Object ( [_Data:protected] => Array ( [group_srt] => [cat_id] => 2 [product_url] => letterhead [category_id] => 2 [category_pro_enable] => 0 [multiple_category] => [category_name] => Business Stationary [category_promotional_text] => [parent_id] => -1 [products_id] => 3 [predefined_product_type] => 0 [products_title] => Letterhead [product_promotional_text] => [setting_constant_name] => [setting_value] => [group_name] => ) [_IteratorKeys:protected] => Array ( [0] => group_srt [1] => cat_id [2] => product_url [3] => category_id [4] => category_pro_enable [5] => multiple_category [6] => category_name [7] => category_promotional_text [8] => parent_id [9] => products_id [10] => predefined_product_type [11] => products_title [12] => product_promotional_text [13] => setting_constant_name [14] => setting_value [15] => group_name ) ) ) [IteratorCount:RDataRecordSet:private] => 20 [last_query] => SELECT pp.sort_order AS group_srt,products.category_id as cat_id, products_description.product_url,product_category.category_id,product_category.category_pro_enable,products.multiple_category,product_category_description.category_name,product_category_description.category_promotional_text,product_category.parent_id, products.products_id, products.predefined_product_type, products_description.products_title,products_description.product_promotional_text,product_settings.setting_constant_name,product_settings.setting_value,pcd.category_name AS group_name FROM products LEFT JOIN product_category ON products.category_id = product_category.category_id OR (find_in_set(product_category.category_id,products.multiple_category) > 0) LEFT JOIN product_category_description ON (product_category_description.category_id = product_category.category_id AND product_category_description.site_language_id = 1) LEFT JOIN product_category pp ON pp.category_id = product_category.parent_id AND pp.status = '1' LEFT JOIN product_category_description pcd ON pcd.category_id = product_category.parent_id AND pp.status = '1' AND pcd.site_language_id = 1 LEFT JOIN products_description ON (products_description.products_id = products.products_id AND products_description.site_language_id = 1) LEFT JOIN product_settings ON (product_settings.products_id = products.products_id AND product_settings.setting_constant_name = 'PRODUCT_PROMOTION_IN_TITLE') WHERE product_category.status = '1' AND products.visible = '1' AND products.products_id != '-11' AND products.predefined_product_type IN ('0', '11', '1', '3', '12') AND products.product_service_type NOT IN ('2', '3', '4', '5') AND (products.user_type_id = '1' OR products.user_type_id = '0') ORDER BY -group_srt DESC, product_category.sort_order ASC, product_category.parent_id ASC, product_category.category_id ASC, products.sort_order ASC,products_description.products_title ASC, products.products_id ASC ) [group_categorys] => Array ( [-1] => Array ( [group_name] => [group_enable] => [group_pro_text] => [groups] => Array ( [10] => Array ( [category_name] => Specialty Products [cat_enable] => 0 [cat_pro_text] => [products] => Array ( [97] => Array ( [pname] => Canvas Prints [pro_enable] => no [pro_title] => [product_url] => canvasprints ) [68] => Array ( [pname] => Square Magnets [pro_enable] => [pro_title] => [product_url] => square-magnets ) [67] => Array ( [pname] => Custom Shape Magnet [pro_enable] => [pro_title] => [product_url] => custom-shape-magnet ) ) ) [8] => Array ( [category_name] => Photo Books [cat_enable] => 0 [cat_pro_text] => [products] => Array ( [2001] => Array ( [pname] => Test Photoprint Product [pro_enable] => [pro_title] => [product_url] => test-photoprint-product ) [96] => Array ( [pname] => Photo Book (8x8) [pro_enable] => [pro_title] => [product_url] => square-photo-book-8x8-inch ) [95] => Array ( [pname] => Photo Book (12x12) [pro_enable] => [pro_title] => [product_url] => square-photo-book-12x12-inch ) [94] => Array ( [pname] => Photo Book (Portrait) [pro_enable] => [pro_title] => [product_url] => photobook-portrait ) [2000] => Array ( [pname] => Photo Book (Landscape) [pro_enable] => [pro_title] => [product_url] => photobook-landscape ) ) ) [3] => Array ( [category_name] => Marketing Materials [cat_enable] => 0 [cat_pro_text] => [products] => Array ( [23] => Array ( [pname] => Banners [pro_enable] => [pro_title] => [product_url] => banners ) [4] => Array ( [pname] => Postcards [pro_enable] => [pro_title] => [product_url] => postcards ) [66] => Array ( [pname] => Yard Sign Banners [pro_enable] => [pro_title] => [product_url] => yard-sign-banners ) [82] => Array ( [pname] => Car Door Magnets [pro_enable] => [pro_title] => [product_url] => car-door-magnets ) [22] => Array ( [pname] => Catalogs Both Side [pro_enable] => [pro_title] => [product_url] => catalogs-both-side ) [26] => Array ( [pname] => Door Hangers Two Side [pro_enable] => [pro_title] => [product_url] => door-hangers-two-side ) [7] => Array ( [pname] => Brochures [pro_enable] => [pro_title] => [product_url] => brochures ) [2] => Array ( [pname] => Flyers One Side [pro_enable] => [pro_title] => [product_url] => flyers-one-side ) ) ) [11] => Array ( [category_name] => Posters, Banners & Signs [cat_enable] => 0 [cat_pro_text] => [products] => Array ( [24] => Array ( [pname] => Posters [pro_enable] => no [pro_title] => [product_url] => posters ) ) ) [2] => Array ( [category_name] => Business Stationary [cat_enable] => 0 [cat_pro_text] => [products] => Array ( [5] => Array ( [pname] => Envelopes [pro_enable] => [pro_title] => [product_url] => envelopes ) [20] => Array ( [pname] => Greeting Cards [pro_enable] => [pro_title] => [product_url] => greeting-cards ) [3] => Array ( [pname] => Letterhead [pro_enable] => [pro_title] => [product_url] => letterhead ) ) ) ) ) ) [category_with_group] => Array ( ) [category_without_group_name] => Array ( [10] => Array ( [category_name] => Specialty Products [cat_enable] => 0 [cat_pro_text] => [products] => Array ( [97] => Array ( [pname] => Canvas Prints [pro_enable] => no [pro_title] => [product_url] => canvasprints ) [68] => Array ( [pname] => Square Magnets [pro_enable] => [pro_title] => [product_url] => square-magnets ) [67] => Array ( [pname] => Custom Shape Magnet [pro_enable] => [pro_title] => [product_url] => custom-shape-magnet ) ) ) [8] => Array ( [category_name] => Photo Books [cat_enable] => 0 [cat_pro_text] => [products] => Array ( [2001] => Array ( [pname] => Test Photoprint Product [pro_enable] => [pro_title] => [product_url] => test-photoprint-product ) [96] => Array ( [pname] => Photo Book (8x8) [pro_enable] => [pro_title] => [product_url] => square-photo-book-8x8-inch ) [95] => Array ( [pname] => Photo Book (12x12) [pro_enable] => [pro_title] => [product_url] => square-photo-book-12x12-inch ) [94] => Array ( [pname] => Photo Book (Portrait) [pro_enable] => [pro_title] => [product_url] => photobook-portrait ) [2000] => Array ( [pname] => Photo Book (Landscape) [pro_enable] => [pro_title] => [product_url] => photobook-landscape ) ) ) [3] => Array ( [category_name] => Marketing Materials [cat_enable] => 0 [cat_pro_text] => [products] => Array ( [23] => Array ( [pname] => Banners [pro_enable] => [pro_title] => [product_url] => banners ) [4] => Array ( [pname] => Postcards [pro_enable] => [pro_title] => [product_url] => postcards ) [66] => Array ( [pname] => Yard Sign Banners [pro_enable] => [pro_title] => [product_url] => yard-sign-banners ) [82] => Array ( [pname] => Car Door Magnets [pro_enable] => [pro_title] => [product_url] => car-door-magnets ) [22] => Array ( [pname] => Catalogs Both Side [pro_enable] => [pro_title] => [product_url] => catalogs-both-side ) [26] => Array ( [pname] => Door Hangers Two Side [pro_enable] => [pro_title] => [product_url] => door-hangers-two-side ) [7] => Array ( [pname] => Brochures [pro_enable] => [pro_title] => [product_url] => brochures ) [2] => Array ( [pname] => Flyers One Side [pro_enable] => [pro_title] => [product_url] => flyers-one-side ) ) ) [11] => Array ( [category_name] => Posters, Banners & Signs [cat_enable] => 0 [cat_pro_text] => [products] => Array ( [24] => Array ( [pname] => Posters [pro_enable] => no [pro_title] => [product_url] => posters ) ) ) [2] => Array ( [category_name] => Business Stationary [cat_enable] => 0 [cat_pro_text] => [products] => Array ( [5] => Array ( [pname] => Envelopes [pro_enable] => [pro_title] => [product_url] => envelopes ) [20] => Array ( [pname] => Greeting Cards [pro_enable] => [pro_title] => [product_url] => greeting-cards ) [3] => Array ( [pname] => Letterhead [pro_enable] => [pro_title] => [product_url] => letterhead ) ) ) ) [select_group] => 11 [select_category_product] => 11 ) )
Render > banner.block
Array ( [twd] => Array ( [section] => top [index_top_section_details] => 1 [banner_settings] => Array ( [bannerWidth] => auto [bannerHeight] => auto [autoStart] => 1 [timeout] => 6000 [showPrevNextLinks] => 1 [showPagerLinks] => 1 [bannerDescLeftPosition] => auto [bannerDescTopPosition] => auto [bannerEffect] => slide [bannerDisplayType] => 1 [bannerSelection] => 0 ) [res_banner] => Array ( ) [banner_advance_settings] => ) )
Render > footer_links.block
Array ( [twd] => Array ( [cnt] => 0 [menus] => Array ( [0] => RDataRecord Object ( [_Data:protected] => Array ( [menu_id] => 13 [menu_link] => cms.php?page=privacy_policy [menu_target] => _self [menu_position] => footer [link_display] => 2 [menu_option] => 0 [status] => 1 [sort_order] => 5 [menu_link_category] => 0 [link_type_id] => 0 [master_menu_id] => 0 [corporate_id] => 0 [menu_title] => Privacy Policy [menu_image] => [site_language_id] => 1 ) [_IteratorKeys:protected] => Array ( [0] => menu_id [1] => menu_link [2] => menu_target [3] => menu_position [4] => link_display [5] => menu_option [6] => status [7] => sort_order [8] => menu_link_category [9] => link_type_id [10] => master_menu_id [11] => corporate_id [12] => menu_title [13] => menu_image [14] => site_language_id ) ) [1] => RDataRecord Object ( [_Data:protected] => Array ( [menu_id] => 14 [menu_link] => cms.php?page=terms_of_use [menu_target] => _self [menu_position] => footer [link_display] => 2 [menu_option] => 0 [status] => 1 [sort_order] => 14 [menu_link_category] => 0 [link_type_id] => 0 [master_menu_id] => 0 [corporate_id] => 0 [menu_title] => Terms & Conditions [menu_image] => [site_language_id] => 1 ) [_IteratorKeys:protected] => Array ( [0] => menu_id [1] => menu_link [2] => menu_target [3] => menu_position [4] => link_display [5] => menu_option [6] => status [7] => sort_order [8] => menu_link_category [9] => link_type_id [10] => master_menu_id [11] => corporate_id [12] => menu_title [13] => menu_image [14] => site_language_id ) ) ) [arr_myaccount_menu_link] => Array ( [0] => user_account.php [1] => user_order.php [3] => user_portfolio.php [4] => quote.php [5] => user_order_inventory.php [7] => user_reward.php [8] => user_images.php [9] => user_qrcode_list.php [10] => user_address.php [11] => user_profile.php [12] => user_store_profile.php [13] => sales_order_report.php [14] => user_changepassword.php ) [form] => Array ( [fb_button] => Facebook [fb_link] => https://www.facebook.com/dialog/oauth?client_id=207871080027786&redirect_uri=http%3A%2F%2Fabcimaging.dev.radixweb.net%2Fuser_registration.php&state=0054c32e638a87ccbc6c9e00ec614927&scope=email&return_url=http%3A%2F%2Fabcimaging.dev.radixweb.net%2Fuser_registration.php ) [SITE_VAR_DESIGNER_MODULE_ENABLE] => 0 [SITE_VAR_USERNAME_LOGIN] => N [SITE_VAR_CORPORATE_URL_TYPE] => ) )