1
. SELECT SQL_CALC_FOUND_ROWS * FROM corporate_user WHERE directory_name = 'user_login.php?backurl=http://abcimaging.dev.radixweb.net/express_checkout_payment.php' 0.0002 secRender > mainpage.tpl
Array ( [twd] => Array ( [titletag] =>ABC PrintRoom: Customer Login [metatag] => [form] => Array ( [quickfirstname] => [quicklastname] => [quickemail] => [left_email_signup] => [fb_link] => https://www.facebook.com/dialog/oauth?client_id=207871080027786&redirect_uri=http%3A%2F%2Fabcimaging.dev.radixweb.net%2Fuser_registration.php&state=6c59229c289fbbf74140ec3b836b2871&scope=email&return_url=http%3A%2F%2Fabcimaging.dev.radixweb.net%2Fuser_registration.php [fb_button] => Facebook [google_button] => ) [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] => 6 [section_name] => Sign In / Sign Up [section_pages] => |user_login.php|user_registration.php| [leftbox] => true [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] => http://abcimaging.dev.radixweb.net/templates/js/user_action.js [26] => /themes/abcimaging/js/theme.js ) [show_leftbox] => true [show_rightbox] => false [show_left_panel] => 1 [show_right_panel] => [col] => Array ( [left] => Array ( [0] => 12 [1] => 4 [2] => 3 [3] => 3 ) [middle] => Array ( [0] => 12 [1] => 8 [2] => 9 [3] => 9 ) [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-8 col-md-9 col-lg-9 [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] [lastname_setting] => 1 [display_quick_register] => [open_id_button] => [error] => [quickerror] => [Users] => [referrer_page] => [corporate_id] => 0 [SITE_VAR_USERNAME_LOGIN] => N [isPopup_loaded] => [backurl] => backurl=http%3A%2F%2Fabcimaging.dev.radixweb.net%2Fexpress_checkout_payment.php ) ) 7
. SELECT * FROM website_logos WHERE corporate_id = 0 0.0002 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=6c59229c289fbbf74140ec3b836b2871&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=6c59229c289fbbf74140ec3b836b2871&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] => [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] => [select_category_product] => ) )
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 > products_menu_group_toggle.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] => [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] => [select_category_product] => ) )
Render > user_login.block
Array ( [twd] => Array ( [form] => Array ( [left_email_signup] => [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=6c59229c289fbbf74140ec3b836b2871&scope=email&return_url=http%3A%2F%2Fabcimaging.dev.radixweb.net%2Fuser_registration.php ) [error] => [left_panel_login_module] => yes [SITE_VAR_USERNAME_LOGIN] => N ) )
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=6c59229c289fbbf74140ec3b836b2871&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] => ) )