1
. SELECT SQL_CALC_FOUND_ROWS * FROM corporate_user WHERE directory_name = 'specialtyproducts' 0.0003 secRender > mainpage.tpl
Array ( [twd] => Array ( [titletag] =>Specialty Products | Canvas Prints, Social Media Frames, Custom Notebooks- ABC Print 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=44e42229d554b2180c69ef89f7c0ad9e&scope=email&return_url=http%3A%2F%2Fabcimaging.dev.radixweb.net%2Fuser_registration.php [fb_button] => Facebook ) [layout_style] => Array ( [l1] => Array ( [1] => Array ( [6z] => Array ( [0] => image-gallery [tab-content] => Array ( [tabs] => Array ( [PRODUCT_INFO_DESCRIPTION] => product-description [COMMON_PRICE_DETAILS] => price-list [PRODUCT_TEMPLETES] => help-template ) ) ) [6b] => Array ( [0] => price-calculator [action-buttons] => Array ( [type] => horizontal-button [popupoption] => yes ) ) ) [2] => Array ( [12i] => Array ( [0] => product-extra-message ) ) [3] => Array ( [12o] => Array ( [tab-content] => Array ( [tabs] => Array ( [RELATED_PRODUCTS] => product-related [COMBO_DISCOUNT_PRODUCTS] => product-combo ) ) ) ) [4] => Array ( [12o] => Array ( [0] => product-review ) ) ) [l2] => Array ( [1] => Array ( [7] => Array ( [0] => image-gallery [1] => product-description ) [5] => Array ( [0] => price-calculator ) ) [2] => Array ( [7] => Array ( [0] => price-list ) [5] => Array ( [action-buttons] => Array ( [type] => vertical-button ) ) ) [3] => Array ( [7] => Array ( [0] => help-template ) [5] => Array ( [0] => product-extra-message ) ) [4] => Array ( [12a] => Array ( [0] => product-related ) [12b] => Array ( [0] => product-combo ) [12c] => Array ( [0] => product-review ) ) ) [l3] => Array ( [1] => Array ( [12] => Array ( [0] => product-extra-message ) ) [2] => Array ( [5] => Array ( [0] => price-calculator ) [7] => Array ( [0] => image-gallery [tab-content] => Array ( [tabs] => Array ( [PRODUCT_INFO_DESCRIPTION] => product-description [COMMON_PRICE_DETAILS] => price-list [PRODUCT_TEMPLETES] => help-template ) ) ) ) [3] => Array ( [12a] => Array ( [action-buttons] => Array ( [type] => horizontal-icon ) ) [12b] => Array ( [tab-content] => Array ( [tabs] => Array ( [RELATED_PRODUCTS] => product-related [COMBO_DISCOUNT_PRODUCTS] => product-combo ) ) ) [12c] => Array ( [0] => product-review ) ) ) [l4] => Array ( [1] => Array ( [6k] => Array ( [0] => image-gallery [1] => product-description ) [6v] => Array ( [tab-content] => Array ( [tabs] => Array ( [PRICE_CALCULATOR] => price-calculator [COMMON_PRICE_DETAILS] => price-list [PRODUCT_TEMPLETES] => help-template ) ) [action-buttons] => Array ( [type] => vertical-button ) ) ) [2] => Array ( [12l] => Array ( [0] => product-extra-message ) ) [3] => Array ( [12h] => Array ( [tab-content] => Array ( [tabs] => Array ( [RELATED_PRODUCTS] => product-related [COMBO_DISCOUNT_PRODUCTS] => product-combo ) ) ) ) [4] => Array ( [12x] => Array ( [0] => product-review ) ) ) [l5] => Array ( [1] => Array ( [12] => Array ( [0] => image-gallery ) ) [2] => Array ( [6a] => Array ( [tab-content] => Array ( [tabs] => Array ( [PRODUCT_INFO_DESCRIPTION] => product-description [COMMON_PRICE_DETAILS] => price-list [PRODUCT_TEMPLETES] => help-template ) ) ) [6b] => Array ( [0] => price-calculator ) ) [3] => Array ( [12] => Array ( [action-buttons] => Array ( [type] => horizontal-icon ) ) ) [4] => Array ( [12a] => Array ( [0] => product-extra-message ) [12b] => Array ( [tab-content] => Array ( [tabs] => Array ( [RELATED_PRODUCTS] => product-related [COMBO_DISCOUNT_PRODUCTS] => product-combo ) ) ) [12c] => Array ( [0] => product-review ) ) ) [l6] => Array ( [1] => Array ( [12] => Array ( [tab-content] => Array ( [tabs] => Array ( [Gallery] => image-gallery [PRODUCT_INFO_DESCRIPTION] => product-description [PRICE_CALCULATOR] => price-calculator [COMMON_PRICE_DETAILS] => price-list [PRODUCT_TEMPLETES] => help-template [PRODUCT EXTRA MESSAGE] => product-extra-message ) ) ) ) [2] => Array ( [12a] => Array ( [action-buttons] => Array ( [type] => horizontal-icon ) ) [12b] => Array ( [tab-content] => Array ( [tabs] => Array ( [RELATED_PRODUCTS] => product-related [COMBO_DISCOUNT_PRODUCTS] => product-combo ) ) ) [12c] => Array ( [0] => product-review ) ) ) [l7] => Array ( [1] => Array ( [12] => Array ( [0] => product-description ) ) [2] => Array ( [6a] => Array ( [0] => price-calculator ) [6b] => Array ( [action-buttons] => Array ( [type] => vertical-icon ) ) ) [3] => Array ( [12a] => Array ( [0] => product-extra-message ) [12b] => Array ( [tab-content] => Array ( [tabs] => Array ( [RELATED_PRODUCTS] => product-related [COMBO_DISCOUNT_PRODUCTS] => product-combo ) ) ) [12c] => Array ( [0] => product-review ) ) ) [predefined] => Array ( [1] => Array ( [6m] => Array ( [0] => image-gallery [1] => product-description ) [6u] => Array ( [0] => price-calculator ) ) [2] => Array ( [12f] => Array ( [0] => login-form ) ) [3] => Array ( [12f] => Array ( [0] => product-extra-message ) ) [4] => Array ( [12x] => Array ( [0] => product-related ) ) [5] => Array ( [12a] => Array ( [0] => product-review ) ) [6] => Array ( [12b] => Array ( [0] => product-combo ) ) ) [m1] => Array ( [1] => Array ( [12x] => Array ( [0] => price-calculator ) ) [2] => Array ( [12p] => Array ( [action-buttons] => Array ( [type] => vertical-button [popupoption] => no ) ) ) [3] => Array ( [12v] => Array ( [0] => image-gallery ) ) [4] => Array ( [12o] => Array ( [0] => product-description ) ) ) [book] => Array ( [1] => Array ( [5k] => Array ( [0] => image-gallery ) [7b] => Array ( [0] => product-description ) ) [2] => Array ( [12z] => Array ( [0] => content-upload ) ) [3] => Array ( [12g] => Array ( [action-buttons] => Array ( [type] => horizontal-button ) ) ) [4] => Array ( [12y] => Array ( [0] => price-calculator ) ) [5] => Array ( [12c] => Array ( [0] => product-extra-message ) ) [6] => Array ( [12r] => Array ( [0] => product-review ) ) [7] => Array ( [12a] => Array ( [0] => login-form ) ) [8] => Array ( [12z] => Array ( [tab-content] => Array ( [tabs] => Array ( [RELATED_PRODUCTS] => product-related [COMBO_DISCOUNT_PRODUCTS] => product-combo ) ) ) ) ) [photo-print] => Array ( [1] => Array ( [6x] => Array ( [0] => product-description ) [6v] => Array ( [0] => price-calculator ) ) [2] => Array ( [12v] => Array ( [action-buttons] => Array ( [type] => horizontal-button [popupoption] => no ) ) ) ) [photobook] => Array ( [1] => Array ( [6o] => Array ( [0] => image-gallery ) [6h] => Array ( [0] => product-description ) ) [2] => Array ( [12o] => Array ( [0] => product-photobook-designs ) ) ) [test] => Array ( [1] => Array ( [6q] => Array ( [tab-content] => Array ( [tabs] => Array ( ) ) [0] => image-gallery ) [6e] => Array ( [0] => price-calculator [action-buttons] => Array ( [type] => vertical-button [popupoption] => no ) ) ) [2] => Array ( [12b] => Array ( [0] => product-extra-message ) ) [3] => Array ( [12c] => Array ( [tab-content] => Array ( [tabs] => Array ( [RELATED_PRODUCTS] => product-related [COMBO_DISCOUNT_PRODUCTS] => product-combo ) ) ) ) [4] => Array ( [12s] => Array ( [0] => product-review ) ) ) [test2] => Array ( [1] => Array ( [6y] => Array ( [0] => image-gallery ) [6n] => Array ( [0] => price-calculator ) ) [2] => Array ( [6p] => Array ( [tab-content] => Array ( [tabs] => Array ( [COMMON_PRICE_DETAILS] => price-list [RELATED_PRODUCTS] => product-related [COMBO_DISCOUNT_PRODUCTS] => product-combo ) ) ) [6n] => Array ( [action-buttons] => Array ( [type] => vertical-button [popupoption] => no ) ) ) [3] => Array ( [12p] => Array ( [0] => product-extra-message ) ) [4] => Array ( [12k] => Array ( [0] => product-description ) ) [5] => Array ( [12q] => Array ( [tab-content] => Array ( [tabs] => Array ( [PRODUCT_INFO_TEMPLATES] => product-templates ) ) ) ) [6] => Array ( [12d] => Array ( [0] => product-review ) ) ) [Bryan-11/29/18] => Array ( [1] => Array ( [6u] => Array ( [0] => image-gallery ) [6q] => Array ( [0] => product-description ) ) [2] => Array ( [6w] => Array ( [0] => price-list ) [6n] => Array ( [action-buttons] => Array ( [type] => vertical-button [popupoption] => no ) ) ) [3] => Array ( [12m] => Array ( [0] => product-templates ) ) ) [kitproduct] => Array ( [0] => Array ( [12] => Array ( [0] => image-gallery [1] => product-description [2] => price-calculator ) ) ) ) [arr_side_boxes] => Array ( [page_sidebox_detail] => RDataRecord Object ( [_Data:protected] => Array ( [sidebar_id] => 1 [section_name] => Default [section_pages] => [leftbox] => false [rightbox] => false [hide_left_sidebox] => [hide_right_sidebox] => [master_sidebar_id] => 0 [corporate_id] => 0 ) [_IteratorKeys:protected] => Array ( [0] => sidebar_id [1] => section_name [2] => section_pages [3] => leftbox [4] => rightbox [5] => hide_left_sidebox [6] => hide_right_sidebox [7] => master_sidebar_id [8] => corporate_id ) ) [rightbox] => Array ( [0] => Array ( [function_name] => contact_us_sidemenu_box ) [1] => Array ( [function_name] => get_subscriber ) [2] => Array ( [function_name] => get_testimonials ) ) [leftbox] => Array ( [0] => Array ( [function_name] => get_product_listing ) [1] => Array ( [function_name] => get_user_unsaved_template_block ) [2] => Array ( [function_name] => user_login ) ) ) [arr_header_main_css] => Array ( [0] => http://abcimaging.dev.radixweb.net/thirdparty/bootstrap/css/bootstrap.css [1] => http://abcimaging.dev.radixweb.net/thirdparty/bootstrap/css/bootstrap-plugins.css [2] => http://abcimaging.dev.radixweb.net/thirdparty/css/font-awesome.css [3] => http://abcimaging.dev.radixweb.net/thirdparty/fancybox/css/jquery.fancybox.css [4] => http://abcimaging.dev.radixweb.net/thirdparty/fancybox/helpers/jquery.fancybox-thumbs.css [5] => http://abcimaging.dev.radixweb.net/thirdparty/css/icomoon.css [6] => http://abcimaging.dev.radixweb.net/templates/css/loader.css [7] => http://abcimaging.dev.radixweb.net/templates/css/common.css [8] => http://abcimaging.dev.radixweb.net/templates/css/badge.css [9] => http://abcimaging.dev.radixweb.net/thirdparty/slick/css/slick-theme.css [10] => http://abcimaging.dev.radixweb.net/thirdparty/slick/css/slick.css [11] => http://abcimaging.dev.radixweb.net/thirdparty/flipbook/css/flipbook.style.css [12] => http://abcimaging.dev.radixweb.net/templates/css/breadcrumbs.css [13] => http://abcimaging.dev.radixweb.net/templates/css/promotional_message.css [14] => http://abcimaging.dev.radixweb.net/themes/abcimaging/css/theme.css [15] => http://abcimaging.dev.radixweb.net/images/custom_css/abcimaging.css ) [arr_main_css] => Array ( ) [arr_main_js] => Array ( [0] => common_js.php [1] => http://abcimaging.dev.radixweb.net/thirdparty/js/jquery.js [2] => http://abcimaging.dev.radixweb.net/thirdparty/js/jquery-ui.js [3] => http://abcimaging.dev.radixweb.net/thirdparty/bootstrap/js/bootstrap.js [4] => http://abcimaging.dev.radixweb.net/thirdparty/bootstrap/js/bootstrap-plugins.js [5] => http://abcimaging.dev.radixweb.net/thirdparty/js/jquery.validate.js [6] => http://abcimaging.dev.radixweb.net/thirdparty/js/jquery.validate.methods.js [7] => http://abcimaging.dev.radixweb.net/thirdparty/js/jquery.bootstrap-growl.js [8] => http://abcimaging.dev.radixweb.net/thirdparty/js/handlebars.js [9] => http://abcimaging.dev.radixweb.net/thirdparty/js/typeahead.js [10] => http://abcimaging.dev.radixweb.net/thirdparty/js/holder.js [11] => http://abcimaging.dev.radixweb.net/thirdparty/js/jquery.touchSwipe.min.js [12] => http://abcimaging.dev.radixweb.net/thirdparty/fancybox/js/jquery.fancybox.js [13] => http://abcimaging.dev.radixweb.net/thirdparty/js/jquery.cookie.js [14] => http://abcimaging.dev.radixweb.net/thirdparty/js/fileuploader.js [15] => http://abcimaging.dev.radixweb.net/thirdparty/js/number-functions.js [16] => http://abcimaging.dev.radixweb.net/thirdparty/js/dompurify.min.js [17] => http://abcimaging.dev.radixweb.net/thirdparty/js/bootbox.js [18] => http://abcimaging.dev.radixweb.net/templates/js/jquery.validate.bootstrap.js [19] => http://abcimaging.dev.radixweb.net/templates/js/common.js [20] => http://abcimaging.dev.radixweb.net/templates/js/common_seo.js [21] => http://abcimaging.dev.radixweb.net/templates/js/cookiewarning.js [22] => http://abcimaging.dev.radixweb.net/thirdparty/slick/js/slick.js [23] => http://abcimaging.dev.radixweb.net/thirdparty/flipbook/js/flipbook.min.js [24] => http://abcimaging.dev.radixweb.net/templates/js/promotional_message.js [25] => /themes/abcimaging/js/theme.js ) [show_leftbox] => false [show_rightbox] => false [show_left_panel] => [show_right_panel] => [col] => Array ( [left] => Array ( [0] => 12 [1] => 4 [2] => 3 [3] => 3 ) [middle] => Array ( [0] => 12 [1] => 12 [2] => 12 [3] => 12 ) [right] => Array ( [0] => 12 [1] => 12 [2] => 3 [3] => 3 ) ) [class] => Array ( [left] => col-xs-12 col-sm-4 col-md-3 col-lg-3 [middle] => col-xs-12 col-sm-12 col-md-12 col-lg-12 [right] => col-xs-12 col-sm-12 col-md-3 col-lg-3 [right_box] => col-xs-12 col-sm-6 col-md-12 col-lg-12 ) [cms] => Array ( [contact_us_box] =>
ABC PrintRoom
5290 Shawnee Road, Suite 300
Alexandria, VA 22312 - United States
Phone : 202.559.7454
customerservice@abcprintroom.com[cms_header] =>
Welcome to ABC PrintRoom! Your one stop print source for any occasion.
[cms_footer] =>Popular Products
Start your print project today. Upload your own files or choose from our 3,500 customizable design templates.
Thank you so much for your best Printing Services, all the amazing work you did with our programs and flyers last week. The quality was exceptional, and your flexibility and speediness has always been appreciated.
Customer service is great - they communicate quickly and easily and are open to flexibility. The products received are high quality and conveniently delivered. I must say they are best photo developing company.
You guys are AWESOME!!! They look terrific. Thank you so much and please thank everyone involved.The President of our company was very happy with the sample yesterday!!” Best Photo Printing services !!
First off, AMAZING JOB. I’ve been so impressed by the quality of best photo printer and speed of this work. I’m so grateful to you for everything. Thank you.
You might also like to view our other products...
) [SITE_VAR_PRODUCT_NO_IMAGE] => [SITE_VAR_DISPLAY_PRODUCT_CATEGORY_SUBOPTION] => %s (%s) [SITE_VAR_CART_AGREE_CHECKBOX] => product_add_info [SITE_VAR_PREDEFINED_PRODUCT_CHECKBOX] => [payonMethodIDs] => [22] [productCategoryDetails] => RDataRecord Object ( [_Data:protected] => Array ( [category_id] => 10 [category_name] => Specialty Products [description] => [long_description] =>Brilliant marketing ideas deserve to be presented beautifully. Easily design your advertising and marketing material that are sure to impresses your audience.
[site_language_id] => 1 [status] => 1 ) [_IteratorKeys:protected] => Array ( [0] => category_id [1] => category_name [2] => description [3] => long_description [4] => site_language_id [5] => status ) ) [objProduct] => ProductsMaster Object ( [Connection] => RDataConnection Object ( [Connection:RDataConnection:private] => PDO Object ( ) [queryTime] => 0.001 [debug:RDataConnection:private] => 1 ) [buildQuery:RMasterModel:private] => Array ( [query] => Array ( ) [select] => Array ( ) [where] => Array ( ) [insert] => Array ( ) [update] => Array ( ) [join] => Array ( ) [orderBy] => Array ( ) [limit] => Array ( ) [groupBy] => Array ( ) [having] => Array ( ) [from] => Array ( ) [delete] => Array ( ) ) [params:RMasterModel:private] => Array ( ) [types:RMasterModel:private] => Array ( ) [customQuery:RMasterModel:private] => Array ( ) [customParams:RMasterModel:private] => Array ( ) [customTypes:RMasterModel:private] => Array ( ) [query:RMasterModel:private] => SELECT products.products_id, products.category_id, products.multiple_category, product_category.category_id as cat_id, products_description.imagename, products_description.products_title, products_description.product_description, products_description.product_url, products_description.product_promotional_text, product_settings.product_setting_id, product_settings.setting_constant_name, product_settings.setting_value FROM products LEFT JOIN product_category ON product_category.category_id = products.category_id or (find_in_set(product_category.category_id,products.multiple_category) > :product_multiple_category ) LEFT JOIN product_settings ON product_settings.products_id = products.products_id AND product_settings.setting_constant_name = :product_settings_setting_constant_name LEFT JOIN product_category_description ON product_category_description.category_id = product_category.category_id AND product_category_description.site_language_id = :product_category_description_site_language_id LEFT JOIN products_description ON products_description.products_id = products.products_id WHERE products.visible = :visible AND products.predefined_product_type IN (:input_0, :input_1, :input_2, :input_3, :input_4) AND (products.user_type_id = :products_corporate_id_1 OR products.user_type_id = :products_user_type_id_0) AND products_description.site_language_id = :site_language_id ORDER BY products.sort_order,products_description.products_title [addFoundRows:RMasterModel:private] => [queryType:RMasterModel:private] => 0 [debug:RMasterModel:private] => 1 [backtrace:RMasterModel:private] => Array ( [/home/abcimaging/public_html/productlist_category_wise.php(66): RMasterModel->setSelect(Array)] =>65: */
66: $objProduct->setSelect(array("products.products_id", "products.category_id", "products.multiple_category", "product_category.category_id as cat_id", "products_description.imagename", "products_description.products_title", "products_description.product_description", "products_description.product_url", "products_description.product_promotional_text","product_settings.product_setting_id","product_settings.setting_constant_name","product_settings.setting_value"));
67: $language_id = SITE_LANGUAGE_ID;
[/home/abcimaging/public_html/productlist_category_wise.php(68): RMasterModel->setJoin('LEFT JOIN product_category ON product_category.category_id = products.category_id or (find_in_set(product_category.category_id,products.multiple_category) > :product_multiple_category )', 0, 'int')] =>67: $language_id = SITE_LANGUAGE_ID;
68: $objProduct->setJoin("LEFT JOIN product_category ON product_category.category_id = products.category_id or (find_in_set(product_category.category_id,products.multiple_category) > :product_multiple_category )",0,'int')
69: ->setJoin("LEFT JOIN product_settings ON product_settings.products_id = products.products_id AND product_settings.setting_constant_name = :product_settings_setting_constant_name", 'PRODUCT_PROMOTION_PATTERN', 'string')
[/home/abcimaging/public_html/productlist_category_wise.php(69): RMasterModel->setJoin('LEFT JOIN product_settings ON product_settings.products_id = products.products_id AND product_settings.setting_constant_name = :product_settings_setting_constant_name', 'PRODUCT_PROMOTION_PATTERN', 'string')] =>68: $objProduct->setJoin("LEFT JOIN product_category ON product_category.category_id = products.category_id or (find_in_set(product_category.category_id,products.multiple_category) > :product_multiple_category )",0,'int')
69: ->setJoin("LEFT JOIN product_settings ON product_settings.products_id = products.products_id AND product_settings.setting_constant_name = :product_settings_setting_constant_name", 'PRODUCT_PROMOTION_PATTERN', 'string')
70: ->setJoin("LEFT JOIN product_category_description ON product_category_description.category_id = product_category.category_id AND product_category_description.site_language_id = :product_category_description_site_language_id ",SITE_LANGUAGE_ID, 'int')
[/home/abcimaging/public_html/productlist_category_wise.php(70): RMasterModel->setJoin('LEFT JOIN product_category_description ON product_category_description.category_id = product_category.category_id AND product_category_description.site_language_id = :product_category_description_site_language_id ', 1, 'int')] =>69: ->setJoin("LEFT JOIN product_settings ON product_settings.products_id = products.products_id AND product_settings.setting_constant_name = :product_settings_setting_constant_name", 'PRODUCT_PROMOTION_PATTERN', 'string')
70: ->setJoin("LEFT JOIN product_category_description ON product_category_description.category_id = product_category.category_id AND product_category_description.site_language_id = :product_category_description_site_language_id ",SITE_LANGUAGE_ID, 'int')
71: ->setWhere("AND products.visible = :visible", '1', 'string');
[/home/abcimaging/public_html/productlist_category_wise.php(71): RMasterModel->setWhere('AND products.visible = :visible', '1', 'string')] =>70: ->setJoin("LEFT JOIN product_category_description ON product_category_description.category_id = product_category.category_id AND product_category_description.site_language_id = :product_category_description_site_language_id ",SITE_LANGUAGE_ID, 'int')
71: ->setWhere("AND products.visible = :visible", '1', 'string');
72: //->setWhere("AND products.category_id = :category_id", $categoryId, 'string');
[/home/abcimaging/public_html/productlist_category_wise.php(76): RMasterModel->setWhere('AND products.predefined_product_type IN @p_predefined_product_type', Array, 'string')] =>75: $predefined_product_list = array_keys($predefined_product_types);
76: $objProduct->setWhere("AND products.predefined_product_type IN @p_predefined_product_type",$predefined_product_list,"string");
77: // Condition for retailer and corporate user.
[/home/abcimaging/public_html/productlist_category_wise.php(79): RMasterModel->setWhere('AND (products.user_type_id = :products_corporate_id_1 OR products.user_type_id = :products_user_type_id_0)', Array, Array)] =>78: $user_type_search = get_user_type_query($userTypeId,$corporateId,$department_id);
79: $objProduct->setWhere($user_type_search[0], $user_type_search[1], $user_type_search[2])
80: ->setWhere("AND products_description.site_language_id = :site_language_id", SITE_LANGUAGE_ID, 'int')
[/home/abcimaging/public_html/productlist_category_wise.php(80): RMasterModel->setWhere('AND products_description.site_language_id = :site_language_id', 1, 'int')] =>79: $objProduct->setWhere($user_type_search[0], $user_type_search[1], $user_type_search[2])
80: ->setWhere("AND products_description.site_language_id = :site_language_id", SITE_LANGUAGE_ID, 'int')
81: ->setOrderBy("products.sort_order,products_description.products_title");
[/home/abcimaging/public_html/productlist_category_wise.php(81): RMasterModel->setOrderBy('products.sort_order,products_description.products_title')] =>80: ->setWhere("AND products_description.site_language_id = :site_language_id", SITE_LANGUAGE_ID, 'int')
81: ->setOrderBy("products.sort_order,products_description.products_title");
82: $thisCatProducts = $objProduct->get_product_details();
[/home/abcimaging/public_html/model/ProductsMaster.php(189): RMasterModel->setWhere('AND products.products_id = :products_id', , 'int', true)] =>188: public function get_product_details($product_id=null, $language_id=null, $category_id=null,$predefined=null, $seo_case = false) {
189: $this->setWhere("AND products.products_id = :products_id", $product_id, 'int',true);
190: $this->setWhere("AND products_description.site_language_id = :site_language_id", $language_id, 'int',true);
[/home/abcimaging/public_html/model/ProductsMaster.php(190): RMasterModel->setWhere('AND products_description.site_language_id = :site_language_id', , 'int', true)] =>189: $this->setWhere("AND products.products_id = :products_id", $product_id, 'int',true);
190: $this->setWhere("AND products_description.site_language_id = :site_language_id", $language_id, 'int',true);
191: $this->setWhere("AND products.category_id = :category_id", $category_id, 'int',true);
[/home/abcimaging/public_html/model/ProductsMaster.php(191): RMasterModel->setWhere('AND products.category_id = :category_id', , 'int', true)] =>190: $this->setWhere("AND products_description.site_language_id = :site_language_id", $language_id, 'int',true);
191: $this->setWhere("AND products.category_id = :category_id", $category_id, 'int',true);
192: $this->setWhere("AND products.predefined_product_type = :predefined_product_type", $predefined, 'int',true);
[/home/abcimaging/public_html/model/ProductsMaster.php(192): RMasterModel->setWhere('AND products.predefined_product_type = :predefined_product_type', , 'int', true)] =>191: $this->setWhere("AND products.category_id = :category_id", $category_id, 'int',true);
192: $this->setWhere("AND products.predefined_product_type = :predefined_product_type", $predefined, 'int',true);
193:
[/home/abcimaging/public_html/model/ProductsMaster.php(200): RMasterModel->setJoin('LEFT JOIN products_description ON products_description.products_id = products.products_id')] =>199: } else {
200: $this->setJoin("LEFT JOIN products_description ON products_description.products_id = products.products_id");
201: }
[/home/abcimaging/public_html/model/ProductsMaster.php(202): RMasterModel->setFrom('products')] =>201: }
202: $this->setFrom("products");
203: return $this->exec_query();
[/home/abcimaging/public_html/lib/Classes/Models/RMasterModel.php(83): RMasterModel->resetVariables()] =>82:
83: $this->resetVariables(); // reset all variables
84: } catch (Exception $e) {
)
)
[userTypeId] => 1
[corporateId] => 0
[thisCatProducts] => Array
(
[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 ) [25] => Array ( [imagename] => square-magnets_thumb.jpg [description] =>Creative Square Magnets.
Square Magnets with die cut in varity of shapes,styles and sizes with rounded corner. We provide state of the art, useful high end Business Card Magnets.
[title] => Square Magnets [promotion_title] => [id] => 68 [url] => http://abcimaging.dev.radixweb.net/product_info.php?pid=68 [product_url] => square-magnets ) [31] => Array ( [imagename] => custom-shape-magnet_thumb.jpg [description] =>Attract your customers to your brand and business
Custom magnet designs that attract your customers to your brand and business
[title] => Custom Shape Magnet [promotion_title] => [id] => 67 [url] => http://abcimaging.dev.radixweb.net/product_info.php?pid=67 [product_url] => custom-shape-magnet ) ) ) ) 7
. SELECT * FROM website_logos WHERE corporate_id = 0 0.0001 secRender > header_toplinks.block
Array ( [twd] => Array ( [cnt] => 0 [menus] => Array ( [0] => RDataRecord Object ( [_Data:protected] => Array ( [menu_id] => 64 [menu_link] => cms.php?page=contact_us [menu_target] => _self [menu_position] => topheader [link_display] => 2 [menu_option] => 0 [status] => 1 [sort_order] => 0 [menu_link_category] => 1 [link_type_id] => 10 [master_menu_id] => 0 [corporate_id] => 0 [menu_title] => 202.559.7454 [menu_image] => [site_language_id] => 1 ) [_IteratorKeys:protected] => Array ( [0] => menu_id [1] => menu_link [2] => menu_target [3] => menu_position [4] => link_display [5] => menu_option [6] => status [7] => sort_order [8] => menu_link_category [9] => link_type_id [10] => master_menu_id [11] => corporate_id [12] => menu_title [13] => menu_image [14] => site_language_id ) ) [1] => RDataRecord Object ( [_Data:protected] => Array ( [menu_id] => 7 [menu_link] => user_account.php [menu_target] => _self [menu_position] => topheader [link_display] => 0 [menu_option] => 2 [status] => 1 [sort_order] => 1 [menu_link_category] => 4 [link_type_id] => 36 [master_menu_id] => 0 [corporate_id] => 0 [menu_title] => Login / Register [menu_image] => fa-user [site_language_id] => 1 ) [_IteratorKeys:protected] => Array ( [0] => menu_id [1] => menu_link [2] => menu_target [3] => menu_position [4] => link_display [5] => menu_option [6] => status [7] => sort_order [8] => menu_link_category [9] => link_type_id [10] => master_menu_id [11] => corporate_id [12] => menu_title [13] => menu_image [14] => site_language_id ) ) [2] => RDataRecord Object ( [_Data:protected] => Array ( [menu_id] => 37 [menu_link] => express_checkout_payment.php [menu_target] => _self [menu_position] => topheader [link_display] => 2 [menu_option] => 2 [status] => 1 [sort_order] => 8 [menu_link_category] => 0 [link_type_id] => 0 [master_menu_id] => 0 [corporate_id] => 0 [menu_title] => Shopping Cart [menu_image] => fa-shopping-cart [site_language_id] => 1 ) [_IteratorKeys:protected] => Array ( [0] => menu_id [1] => menu_link [2] => menu_target [3] => menu_position [4] => link_display [5] => menu_option [6] => status [7] => sort_order [8] => menu_link_category [9] => link_type_id [10] => master_menu_id [11] => corporate_id [12] => menu_title [13] => menu_image [14] => site_language_id ) ) ) [arr_myaccount_menu_link] => Array ( [0] => user_account.php [1] => user_order.php [3] => user_portfolio.php [4] => quote.php [5] => user_order_inventory.php [7] => user_reward.php [8] => user_images.php [9] => user_qrcode_list.php [10] => user_address.php [11] => user_profile.php [12] => user_store_profile.php [13] => sales_order_report.php [14] => user_changepassword.php ) [form] => Array ( [fb_button] => Facebook [fb_link] => https://www.facebook.com/dialog/oauth?client_id=207871080027786&redirect_uri=http%3A%2F%2Fabcimaging.dev.radixweb.net%2Fuser_registration.php&state=44e42229d554b2180c69ef89f7c0ad9e&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=44e42229d554b2180c69ef89f7c0ad9e&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] => 10 [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] => 10 [select_category_product] => 10 ) )
Render > banner.block
Array ( [twd] => Array ( [section] => top [index_top_section_details] => 1 [banner_settings] => Array ( [bannerWidth] => auto [bannerHeight] => auto [autoStart] => 1 [timeout] => 6000 [showPrevNextLinks] => 1 [showPagerLinks] => 1 [bannerDescLeftPosition] => auto [bannerDescTopPosition] => auto [bannerEffect] => slide [bannerDisplayType] => 1 [bannerSelection] => 0 ) [res_banner] => Array ( ) [banner_advance_settings] => ) )
Render > footer_links.block
Array ( [twd] => Array ( [cnt] => 0 [menus] => Array ( [0] => RDataRecord Object ( [_Data:protected] => Array ( [menu_id] => 13 [menu_link] => cms.php?page=privacy_policy [menu_target] => _self [menu_position] => footer [link_display] => 2 [menu_option] => 0 [status] => 1 [sort_order] => 5 [menu_link_category] => 0 [link_type_id] => 0 [master_menu_id] => 0 [corporate_id] => 0 [menu_title] => Privacy Policy [menu_image] => [site_language_id] => 1 ) [_IteratorKeys:protected] => Array ( [0] => menu_id [1] => menu_link [2] => menu_target [3] => menu_position [4] => link_display [5] => menu_option [6] => status [7] => sort_order [8] => menu_link_category [9] => link_type_id [10] => master_menu_id [11] => corporate_id [12] => menu_title [13] => menu_image [14] => site_language_id ) ) [1] => RDataRecord Object ( [_Data:protected] => Array ( [menu_id] => 14 [menu_link] => cms.php?page=terms_of_use [menu_target] => _self [menu_position] => footer [link_display] => 2 [menu_option] => 0 [status] => 1 [sort_order] => 14 [menu_link_category] => 0 [link_type_id] => 0 [master_menu_id] => 0 [corporate_id] => 0 [menu_title] => Terms & Conditions [menu_image] => [site_language_id] => 1 ) [_IteratorKeys:protected] => Array ( [0] => menu_id [1] => menu_link [2] => menu_target [3] => menu_position [4] => link_display [5] => menu_option [6] => status [7] => sort_order [8] => menu_link_category [9] => link_type_id [10] => master_menu_id [11] => corporate_id [12] => menu_title [13] => menu_image [14] => site_language_id ) ) ) [arr_myaccount_menu_link] => Array ( [0] => user_account.php [1] => user_order.php [3] => user_portfolio.php [4] => quote.php [5] => user_order_inventory.php [7] => user_reward.php [8] => user_images.php [9] => user_qrcode_list.php [10] => user_address.php [11] => user_profile.php [12] => user_store_profile.php [13] => sales_order_report.php [14] => user_changepassword.php ) [form] => Array ( [fb_button] => Facebook [fb_link] => https://www.facebook.com/dialog/oauth?client_id=207871080027786&redirect_uri=http%3A%2F%2Fabcimaging.dev.radixweb.net%2Fuser_registration.php&state=44e42229d554b2180c69ef89f7c0ad9e&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] => ) )