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.
Render > mainpage.tpl
Array ( [twd] => Array ( [titletag] =>Printing Services| Design. Create. Print | ABCPrint Room [metatag] => [form] => Array ( [fb_link] => https://www.facebook.com/dialog/oauth?client_id=207871080027786&redirect_uri=http%3A%2F%2Fabcimaging.dev.radixweb.net%2Fuser_registration.php&state=79f732f4b5d2d222bc364c12c443db53&scope=email&return_url=http%3A%2F%2Fabcimaging.dev.radixweb.net%2Fuser_registration.php [fb_button] => Facebook ) [layout_style] => Array ( [l1] => Array ( [1] => Array ( [6z] => Array ( [0] => image-gallery [tab-content] => Array ( [tabs] => Array ( [PRODUCT_INFO_DESCRIPTION] => product-description [COMMON_PRICE_DETAILS] => price-list [PRODUCT_TEMPLETES] => help-template ) ) ) [6b] => Array ( [0] => price-calculator [action-buttons] => Array ( [type] => horizontal-button [popupoption] => yes ) ) ) [2] => Array ( [12i] => Array ( [0] => product-extra-message ) ) [3] => Array ( [12o] => Array ( [tab-content] => Array ( [tabs] => Array ( [RELATED_PRODUCTS] => product-related [COMBO_DISCOUNT_PRODUCTS] => product-combo ) ) ) ) [4] => Array ( [12o] => Array ( [0] => product-review ) ) ) [l2] => Array ( [1] => Array ( [7] => Array ( [0] => image-gallery [1] => product-description ) [5] => Array ( [0] => price-calculator ) ) [2] => Array ( [7] => Array ( [0] => price-list ) [5] => Array ( [action-buttons] => Array ( [type] => vertical-button ) ) ) [3] => Array ( [7] => Array ( [0] => help-template ) [5] => Array ( [0] => product-extra-message ) ) [4] => Array ( [12a] => Array ( [0] => product-related ) [12b] => Array ( [0] => product-combo ) [12c] => Array ( [0] => product-review ) ) ) [l3] => Array ( [1] => Array ( [12] => Array ( [0] => product-extra-message ) ) [2] => Array ( [5] => Array ( [0] => price-calculator ) [7] => Array ( [0] => image-gallery [tab-content] => Array ( [tabs] => Array ( [PRODUCT_INFO_DESCRIPTION] => product-description [COMMON_PRICE_DETAILS] => price-list [PRODUCT_TEMPLETES] => help-template ) ) ) ) [3] => Array ( [12a] => Array ( [action-buttons] => Array ( [type] => horizontal-icon ) ) [12b] => Array ( [tab-content] => Array ( [tabs] => Array ( [RELATED_PRODUCTS] => product-related [COMBO_DISCOUNT_PRODUCTS] => product-combo ) ) ) [12c] => Array ( [0] => product-review ) ) ) [l4] => Array ( [1] => Array ( [6k] => Array ( [0] => image-gallery [1] => product-description ) [6v] => Array ( [tab-content] => Array ( [tabs] => Array ( [PRICE_CALCULATOR] => price-calculator [COMMON_PRICE_DETAILS] => price-list [PRODUCT_TEMPLETES] => help-template ) ) [action-buttons] => Array ( [type] => vertical-button ) ) ) [2] => Array ( [12l] => Array ( [0] => product-extra-message ) ) [3] => Array ( [12h] => Array ( [tab-content] => Array ( [tabs] => Array ( [RELATED_PRODUCTS] => product-related [COMBO_DISCOUNT_PRODUCTS] => product-combo ) ) ) ) [4] => Array ( [12x] => Array ( [0] => product-review ) ) ) [l5] => Array ( [1] => Array ( [12] => Array ( [0] => image-gallery ) ) [2] => Array ( [6a] => Array ( [tab-content] => Array ( [tabs] => Array ( [PRODUCT_INFO_DESCRIPTION] => product-description [COMMON_PRICE_DETAILS] => price-list [PRODUCT_TEMPLETES] => help-template ) ) ) [6b] => Array ( [0] => price-calculator ) ) [3] => Array ( [12] => Array ( [action-buttons] => Array ( [type] => horizontal-icon ) ) ) [4] => Array ( [12a] => Array ( [0] => product-extra-message ) [12b] => Array ( [tab-content] => Array ( [tabs] => Array ( [RELATED_PRODUCTS] => product-related [COMBO_DISCOUNT_PRODUCTS] => product-combo ) ) ) [12c] => Array ( [0] => product-review ) ) ) [l6] => Array ( [1] => Array ( [12] => Array ( [tab-content] => Array ( [tabs] => Array ( [Gallery] => image-gallery [PRODUCT_INFO_DESCRIPTION] => product-description [PRICE_CALCULATOR] => price-calculator [COMMON_PRICE_DETAILS] => price-list [PRODUCT_TEMPLETES] => help-template [PRODUCT EXTRA MESSAGE] => product-extra-message ) ) ) ) [2] => Array ( [12a] => Array ( [action-buttons] => Array ( [type] => horizontal-icon ) ) [12b] => Array ( [tab-content] => Array ( [tabs] => Array ( [RELATED_PRODUCTS] => product-related [COMBO_DISCOUNT_PRODUCTS] => product-combo ) ) ) [12c] => Array ( [0] => product-review ) ) ) [l7] => Array ( [1] => Array ( [12] => Array ( [0] => product-description ) ) [2] => Array ( [6a] => Array ( [0] => price-calculator ) [6b] => Array ( [action-buttons] => Array ( [type] => vertical-icon ) ) ) [3] => Array ( [12a] => Array ( [0] => product-extra-message ) [12b] => Array ( [tab-content] => Array ( [tabs] => Array ( [RELATED_PRODUCTS] => product-related [COMBO_DISCOUNT_PRODUCTS] => product-combo ) ) ) [12c] => Array ( [0] => product-review ) ) ) [predefined] => Array ( [1] => Array ( [6m] => Array ( [0] => image-gallery [1] => product-description ) [6u] => Array ( [0] => price-calculator ) ) [2] => Array ( [12f] => Array ( [0] => login-form ) ) [3] => Array ( [12f] => Array ( [0] => product-extra-message ) ) [4] => Array ( [12x] => Array ( [0] => product-related ) ) [5] => Array ( [12a] => Array ( [0] => product-review ) ) [6] => Array ( [12b] => Array ( [0] => product-combo ) ) ) [m1] => Array ( [1] => Array ( [12x] => Array ( [0] => price-calculator ) ) [2] => Array ( [12p] => Array ( [action-buttons] => Array ( [type] => vertical-button [popupoption] => no ) ) ) [3] => Array ( [12v] => Array ( [0] => image-gallery ) ) [4] => Array ( [12o] => Array ( [0] => product-description ) ) ) [book] => Array ( [1] => Array ( [5k] => Array ( [0] => image-gallery ) [7b] => Array ( [0] => product-description ) ) [2] => Array ( [12z] => Array ( [0] => content-upload ) ) [3] => Array ( [12g] => Array ( [action-buttons] => Array ( [type] => horizontal-button ) ) ) [4] => Array ( [12y] => Array ( [0] => price-calculator ) ) [5] => Array ( [12c] => Array ( [0] => product-extra-message ) ) [6] => Array ( [12r] => Array ( [0] => product-review ) ) [7] => Array ( [12a] => Array ( [0] => login-form ) ) [8] => Array ( [12z] => Array ( [tab-content] => Array ( [tabs] => Array ( [RELATED_PRODUCTS] => product-related [COMBO_DISCOUNT_PRODUCTS] => product-combo ) ) ) ) ) [photo-print] => Array ( [1] => Array ( [6x] => Array ( [0] => product-description ) [6v] => Array ( [0] => price-calculator ) ) [2] => Array ( [12v] => Array ( [action-buttons] => Array ( [type] => horizontal-button [popupoption] => no ) ) ) ) [photobook] => Array ( [1] => Array ( [6o] => Array ( [0] => image-gallery ) [6h] => Array ( [0] => product-description ) ) [2] => Array ( [12o] => Array ( [0] => product-photobook-designs ) ) ) [test] => Array ( [1] => Array ( [6q] => Array ( [tab-content] => Array ( [tabs] => Array ( ) ) [0] => image-gallery ) [6e] => Array ( [0] => price-calculator [action-buttons] => Array ( [type] => vertical-button [popupoption] => no ) ) ) [2] => Array ( [12b] => Array ( [0] => product-extra-message ) ) [3] => Array ( [12c] => Array ( [tab-content] => Array ( [tabs] => Array ( [RELATED_PRODUCTS] => product-related [COMBO_DISCOUNT_PRODUCTS] => product-combo ) ) ) ) [4] => Array ( [12s] => Array ( [0] => product-review ) ) ) [test2] => Array ( [1] => Array ( [6y] => Array ( [0] => image-gallery ) [6n] => Array ( [0] => price-calculator ) ) [2] => Array ( [6p] => Array ( [tab-content] => Array ( [tabs] => Array ( [COMMON_PRICE_DETAILS] => price-list [RELATED_PRODUCTS] => product-related [COMBO_DISCOUNT_PRODUCTS] => product-combo ) ) ) [6n] => Array ( [action-buttons] => Array ( [type] => vertical-button [popupoption] => no ) ) ) [3] => Array ( [12p] => Array ( [0] => product-extra-message ) ) [4] => Array ( [12k] => Array ( [0] => product-description ) ) [5] => Array ( [12q] => Array ( [tab-content] => Array ( [tabs] => Array ( [PRODUCT_INFO_TEMPLATES] => product-templates ) ) ) ) [6] => Array ( [12d] => Array ( [0] => product-review ) ) ) [Bryan-11/29/18] => Array ( [1] => Array ( [6u] => Array ( [0] => image-gallery ) [6q] => Array ( [0] => product-description ) ) [2] => Array ( [6w] => Array ( [0] => price-list ) [6n] => Array ( [action-buttons] => Array ( [type] => vertical-button [popupoption] => no ) ) ) [3] => Array ( [12m] => Array ( [0] => product-templates ) ) ) [kitproduct] => Array ( [0] => Array ( [12] => Array ( [0] => image-gallery [1] => product-description [2] => price-calculator ) ) ) ) [arr_side_boxes] => Array ( [page_sidebox_detail] => RDataRecord Object ( [_Data:protected] => Array ( [sidebar_id] => 2 [section_name] => Home [section_pages] => |index.php| [leftbox] => false [rightbox] => false [hide_left_sidebox] => ,15,2,7, [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 ) ) ) [arr_header_main_css] => Array ( [0] => http://abcimaging.dev.radixweb.net/thirdparty/bootstrap/css/bootstrap.css [1] => http://abcimaging.dev.radixweb.net/thirdparty/bootstrap/css/bootstrap-plugins.css [2] => http://abcimaging.dev.radixweb.net/thirdparty/css/font-awesome.css [3] => http://abcimaging.dev.radixweb.net/thirdparty/fancybox/css/jquery.fancybox.css [4] => http://abcimaging.dev.radixweb.net/thirdparty/fancybox/helpers/jquery.fancybox-thumbs.css [5] => http://abcimaging.dev.radixweb.net/thirdparty/css/icomoon.css [6] => http://abcimaging.dev.radixweb.net/templates/css/loader.css [7] => http://abcimaging.dev.radixweb.net/templates/css/common.css [8] => http://abcimaging.dev.radixweb.net/templates/css/badge.css [9] => http://abcimaging.dev.radixweb.net/thirdparty/slick/css/slick-theme.css [10] => http://abcimaging.dev.radixweb.net/thirdparty/slick/css/slick.css [11] => http://abcimaging.dev.radixweb.net/thirdparty/flipbook/css/flipbook.style.css [12] => http://abcimaging.dev.radixweb.net/templates/css/breadcrumbs.css [13] => http://abcimaging.dev.radixweb.net/templates/css/promotional_message.css [14] => http://abcimaging.dev.radixweb.net/themes/abcimaging/css/theme.css [15] => http://abcimaging.dev.radixweb.net/images/custom_css/abcimaging.css ) [arr_main_css] => Array ( ) [arr_main_js] => Array ( [0] => common_js.php [1] => http://abcimaging.dev.radixweb.net/thirdparty/js/jquery.js [2] => http://abcimaging.dev.radixweb.net/thirdparty/js/jquery-ui.js [3] => http://abcimaging.dev.radixweb.net/thirdparty/bootstrap/js/bootstrap.js [4] => http://abcimaging.dev.radixweb.net/thirdparty/bootstrap/js/bootstrap-plugins.js [5] => http://abcimaging.dev.radixweb.net/thirdparty/js/jquery.validate.js [6] => http://abcimaging.dev.radixweb.net/thirdparty/js/jquery.validate.methods.js [7] => http://abcimaging.dev.radixweb.net/thirdparty/js/jquery.bootstrap-growl.js [8] => http://abcimaging.dev.radixweb.net/thirdparty/js/handlebars.js [9] => http://abcimaging.dev.radixweb.net/thirdparty/js/typeahead.js [10] => http://abcimaging.dev.radixweb.net/thirdparty/js/holder.js [11] => http://abcimaging.dev.radixweb.net/thirdparty/js/jquery.touchSwipe.min.js [12] => http://abcimaging.dev.radixweb.net/thirdparty/fancybox/js/jquery.fancybox.js [13] => http://abcimaging.dev.radixweb.net/thirdparty/js/jquery.cookie.js [14] => http://abcimaging.dev.radixweb.net/thirdparty/js/fileuploader.js [15] => http://abcimaging.dev.radixweb.net/thirdparty/js/number-functions.js [16] => http://abcimaging.dev.radixweb.net/thirdparty/js/dompurify.min.js [17] => http://abcimaging.dev.radixweb.net/thirdparty/js/bootbox.js [18] => http://abcimaging.dev.radixweb.net/templates/js/jquery.validate.bootstrap.js [19] => http://abcimaging.dev.radixweb.net/templates/js/common.js [20] => http://abcimaging.dev.radixweb.net/templates/js/common_seo.js [21] => http://abcimaging.dev.radixweb.net/templates/js/cookiewarning.js [22] => http://abcimaging.dev.radixweb.net/thirdparty/slick/js/slick.js [23] => http://abcimaging.dev.radixweb.net/thirdparty/flipbook/js/flipbook.min.js [24] => http://abcimaging.dev.radixweb.net/templates/js/promotional_message.js [25] => /themes/abcimaging/js/theme.js ) [show_leftbox] => false [show_rightbox] => false [show_left_panel] => [show_right_panel] => [col] => Array ( [left] => Array ( [0] => 12 [1] => 4 [2] => 3 [3] => 3 ) [middle] => Array ( [0] => 12 [1] => 12 [2] => 12 [3] => 12 ) [right] => Array ( [0] => 12 [1] => 12 [2] => 3 [3] => 3 ) ) [class] => Array ( [left] => col-xs-12 col-sm-4 col-md-3 col-lg-3 [middle] => col-xs-12 col-sm-12 col-md-12 col-lg-12 [right] => col-xs-12 col-sm-12 col-md-3 col-lg-3 [right_box] => col-xs-12 col-sm-6 col-md-12 col-lg-12 ) [cms] => Array ( [index_middle] => [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] [allProducts] => Array ( [0] => Array ( [imagename] => [description] => [title] => Test Photoprint Product [promotion_title] => [id] => 2001 [url] => http://abcimaging.dev.radixweb.net/product_info.php?pid=2001 [product_url] => test-photoprint-product ) [1] => Array ( [imagename] => canvas_386_04450023201811.jpg [description] =>Transform Your Walls Instantly
Bring your rooms to life with custom Canvas Photo Prints.
[title] => Canvas Prints [promotion_title] => [id] => 97 [url] => http://abcimaging.dev.radixweb.net/product_info.php?pid=97 [product_url] => canvasprints [badgepattern] => none ) [2] => Array ( [imagename] => 01_pic_photo_land.jpg [description] =>Give the gift of joy this holiday season with a custom made photobook. Capture life's magical moments and share the good memories with your family and friends. Great for your day trip photos, wedding photos, or as a photo gift book.
[title] => Photo Book (Landscape) [promotion_title] => [id] => 2000 [url] => http://abcimaging.dev.radixweb.net/product_info.php?pid=2000 [product_url] => photobook-landscape ) [3] => Array ( [imagename] => pic_postcards.jpg [description] =>Picturesque Postcards for Mass Marketing
Provide personal flavor to mass marketing efforts.
[title] => Postcards [promotion_title] => [id] => 4 [url] => http://abcimaging.dev.radixweb.net/product_info.php?pid=4 [product_url] => postcards ) [4] => Array ( [imagename] => pic_bc_sm.jpg [description] =>Creative Business Cards to Impress Clients!
Create cards that make the first impression
[title] => Standard Business Cards [promotion_title] => [id] => 1 [url] => http://abcimaging.dev.radixweb.net/product_info.php?pid=1 [product_url] => standard-business-cards [badgepattern] => none ) ) [Pagging] => ) ) 6
. 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=79f732f4b5d2d222bc364c12c443db53&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=79f732f4b5d2d222bc364c12c443db53&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 ( [0] => RDataRecord Object ( [_Data:protected] => Array ( [banner_image_id] => 26 [banner_image_name] => banner_calendar64.jpg [banner_link] => http://abcimaging.dev.radixweb.net/calendar.html [open_target] => _blank [banner_display] => 2 [banner_available_to] => 0 [banner_pages] => index.php [category_ids] => [sort_order] => 1 [status] => 1 [title] => Custom Calendars [banner_language] => 0 [corporate_id] => 0 [banner_text] => [banner_upperimage_name] => [banner_advance_settings] => [banner_start_date] => 0000-00-00 00:00:00 [banner_end_date] => 0000-00-00 00:00:00 ) [_IteratorKeys:protected] => Array ( [0] => banner_image_id [1] => banner_image_name [2] => banner_link [3] => open_target [4] => banner_display [5] => banner_available_to [6] => banner_pages [7] => category_ids [8] => sort_order [9] => status [10] => title [11] => banner_language [12] => corporate_id [13] => banner_text [14] => banner_upperimage_name [15] => banner_advance_settings [16] => banner_start_date [17] => banner_end_date ) ) [1] => RDataRecord Object ( [_Data:protected] => Array ( [banner_image_id] => 19 [banner_image_name] => 2018_Xmas_Promo199.png [banner_link] => http://www.abcprintroom.com/holiday-card/products/ [open_target] => _self [banner_display] => 2 [banner_available_to] => 0 [banner_pages] => index.php [category_ids] => [sort_order] => 2 [status] => 1 [title] => Holiday Cards [banner_language] => 0 [corporate_id] => 0 [banner_text] => [banner_upperimage_name] => [banner_advance_settings] => [banner_start_date] => 0000-00-00 00:00:00 [banner_end_date] => 0000-00-00 00:00:00 ) [_IteratorKeys:protected] => Array ( [0] => banner_image_id [1] => banner_image_name [2] => banner_link [3] => open_target [4] => banner_display [5] => banner_available_to [6] => banner_pages [7] => category_ids [8] => sort_order [9] => status [10] => title [11] => banner_language [12] => corporate_id [13] => banner_text [14] => banner_upperimage_name [15] => banner_advance_settings [16] => banner_start_date [17] => banner_end_date ) ) [2] => RDataRecord Object ( [_Data:protected] => Array ( [banner_image_id] => 24 [banner_image_name] => ABC_PR_dryerase.jpg [banner_link] => https://www.abcprintroom.com/dryerase/ [open_target] => _self [banner_display] => 2 [banner_available_to] => 0 [banner_pages] => index.php [category_ids] => [sort_order] => 3 [status] => 1 [title] => Dry Ease Wall [banner_language] => 0 [corporate_id] => 0 [banner_text] => [banner_upperimage_name] => [banner_advance_settings] => [banner_start_date] => 0000-00-00 00:00:00 [banner_end_date] => 0000-00-00 00:00:00 ) [_IteratorKeys:protected] => Array ( [0] => banner_image_id [1] => banner_image_name [2] => banner_link [3] => open_target [4] => banner_display [5] => banner_available_to [6] => banner_pages [7] => category_ids [8] => sort_order [9] => status [10] => title [11] => banner_language [12] => corporate_id [13] => banner_text [14] => banner_upperimage_name [15] => banner_advance_settings [16] => banner_start_date [17] => banner_end_date ) ) ) [banner_advance_settings] => Array ( [26] => Array ( ) [19] => Array ( ) [24] => Array ( ) ) ) )
30
. SELECT SQL_CALC_FOUND_ROWS * FROM banner_image_setting 0.0001 secRender > 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=79f732f4b5d2d222bc364c12c443db53&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] => ) )