1 . SELECT SQL_CALC_FOUND_ROWS * FROM corporate_user WHERE directory_name = 'calendar.html' 0.0006 sec
↳cms.php : 15 -> require_once
2 . SELECT section_id, status FROM admin_section WHERE section_id IN (SELECT section_id FROM admin_section_description where site_language_id = '1' AND LOWER(section_heading) = LOWER('Templates')) 0.0004 sec
↳cms.php : 15 -> require_once
3 . SELECT configuration_master.constant_name,configuration_master.set_value,configuration_master.default_value,configuration_master.setting_type FROM configuration_master ORDER BY configuration_master.sort_order ASC, configuration_master.configuration_id ASC 0.0006 sec
↳cms.php : 15 -> require_once
4 . SELECT SQL_CALC_FOUND_ROWS theme_general_cofiguration FROM site_theme WHERE theme_dir_name = 'abcimaging' 0.0002 sec
↳cms.php : 15 -> require_once
5 . SELECT payment_method_id FROM payment_method WHERE directory= 'payon_account' ORDER BY sort_order ASC 0.0002 sec
↳cms.php : 15 -> require_once
6 . SELECT * FROM external_services WHERE status = '1' 0.0002 sec
↳cms.php : 15 -> require_once
7 . SELECT * FROM website_logos WHERE corporate_id = 0 0.0002 sec
↳cms.php : 15 -> require_once
8 . SELECT * FROM site_language WHERE default_language = '1' 0.0002 sec
↳cms.php : 15 -> require_once
9 . SELECT * FROM site_currency WHERE default_currency = '1' 0.0002 sec
↳cms.php : 15 -> require_once
10 . SET time_zone = '+05:30' 0.0001 sec
↳cms.php : 15 -> require_once
11 . SELECT count(*) as active_langs FROM site_language where status = '1' 0.0001 sec
↳cms.php : 15 -> require_once
12 . SELECT shortname, site_language_id FROM site_language 0.0001 sec
↳cms.php : 15 -> require_once
13 . select TC.category_id, TCD.category_name from site_template_category as TC Left Join site_template_category_description AS TCD ON TCD.category_id = TC.category_id and TCD.site_language_id = '1' 0.0005 sec
↳cms.php : 15 -> require_once
14 . SELECT product_category.category_id, product_category_description.category_url as caturl, product_category_description.description, product_category_description.site_language_id FROM product_category LEFT JOIN product_category_description ON product_category_description.category_id = product_category.category_id WHERE product_category.status = '1' 0.0003 sec
↳cms.php : 15 -> require_once
15 . select p.products_id, pd.product_url as producturl,pd.products_title as productname, pd.site_language_id from products as p Left Join products_description as pd on pd.products_id = p.products_id 0.0013 sec
↳cms.php : 15 -> require_once
16 . SELECT * FROM product_info_layout ORDER BY layout_id ASC 0.0003 sec
↳cms.php : 15 -> require_once
17 . SELECT site_seo_description.seo_page_title, site_seo_description.seo_page_keywords,site_seo_description.seo_page_description FROM site_seo LEFT JOIN site_seo_description on site_seo_description.page_id = site_seo.page_id WHERE site_seo_description.site_language_id = 1 AND (site_seo.page_name = 'cms.php' OR site_seo.page_name = 'cms' OR site_seo.page_name = 'Default') ORDER BY site_seo.page_id desc 0.0007 sec
↳cms.php : 15 -> require_once
18 . SELECT SQL_CALC_FOUND_ROWS cms_pages_description.site_language_id, cms_pages_description.seo_page_title, cms_pages_description.seo_page_keywords,cms_pages_description.seo_page_description,cms_pages_description.page_heading,cms_pages_description.canonical_id,(IF(cms_pages_description.canonical_id > 0 ,(select page_name from cms_pages where page_id = cms_pages_description.canonical_id),'')) as canonical_page FROM cms_pages LEFT JOIN cms_pages_description ON cms_pages_description.page_id = cms_pages.page_id WHERE cms_pages_description.site_language_id = 1 AND (cms_pages.page_name = 'calendar' OR cms_pages.page_name = 'calendar') AND cms_pages.status = '1' AND cms_pages.corporate_id = 0 ORDER BY corporate_id DESC 0.0019 sec
↳cms.php : 15 -> require_once
19 . SELECT site_general_metatag.name, site_general_metatag.content FROM site_general_metatag LEFT JOIN site_front_pages on site_front_pages.front_pages_id = site_general_metatag.page_id AND site_front_pages.seo_status = '1' WHERE (site_front_pages.front_pages_name = 'cms.php' OR site_front_pages.front_pages_name = 'cms') OR site_general_metatag.page_id = 0 ORDER BY site_front_pages.front_pages_id desc 0.0002 sec
↳cms.php : 15 -> require_once
20 . SELECT front_group_id FROM site_front_pages WHERE front_pages_name = 'cms' 0.0001 sec
↳cms.php : 15 -> require_once
21 . SELECT SQL_CALC_FOUND_ROWS * FROM (SELECT site_constants.constant_name, site_constants_description.constant_value, site_constants_description.constant_id, Concat(site_constants_description.constant_id, IF(site_constants_description.corporate_id = -1, 1, 0)) AS corporateid FROM site_constants LEFT JOIN site_constants_description ON site_constants_description.constant_id = site_constants.constant_id AND site_constants_description.site_language_id=1 LEFT JOIN site_front_page_group ON site_constants.front_group_id = site_front_page_group.front_group_id WHERE 1 AND site_constants.front_group_id IN ('1', '5') AND site_constants.available_to IN ('0', '11', '3', '12', '-2') AND site_constants_description.corporate_id = 0 GROUP BY corporateid ORDER BY corporateid DESC) AS site_constants_description GROUP BY site_constants_description.constant_id 0.0175 sec
↳cms.php : 15 -> require_once
22 . SELECT * FROM (SELECT menu_link.*, menu_link_description.menu_title,menu_link_description.menu_image,menu_link_description.site_language_id FROM menu_link LEFT JOIN menu_link_description ON menu_link_description.menu_id = menu_link.menu_id WHERE menu_link_description.site_language_id = 1 AND menu_link.status = '1' AND corporate_id = 0 AND (link_display = '2' OR link_display = '0') LIMIT 18446744073709551615) AS temp_table ORDER BY sort_order ASC 0.0005 sec
↳cms.php : 15 -> require_once
23 . SELECT * FROM sidebar_management WHERE section_pages LIKE '%|cms.php|%' AND corporate_id = 0 OR sidebar_id = '1' ORDER BY sidebar_id DESC LIMIT 1 OFFSET 0 0.0004 sec
↳cms.php : 15 -> require_once
24 . SELECT * FROM (SELECT side_menu_link. * FROM side_menu_link WHERE 1 AND corporate_id = 0 GROUP BY menu_title HAVING status = '1' AND menu_display IN ('0', '1') ORDER BY sortorder ASC, status ASC, menu_title ASC LIMIT 18446744073709551615 ) AS temp_table ORDER BY sortorder ASC, status ASC, menu_title ASC 0.0002 sec
↳cms.php : 15 -> require_once
25 . SELECT SQL_CALC_FOUND_ROWS * FROM corporate_user WHERE directory_name = 'calendar.html' 0.0002 sec
↳cms.php : 15 -> require_once
26 . SELECT SQL_CALC_FOUND_ROWS cms_pages.page_name, cms_pages_description.page_heading, cms_pages_description.page_content, cms_pages.corporate_id FROM cms_pages LEFT JOIN cms_pages_description ON cms_pages_description.page_id = cms_pages.page_id WHERE cms_pages_description.site_language_id = 1 AND cms_pages.page_name IN ('cms_header', 'cms_middle_footer', 'cms_footer', 'contact_us_box', 'sidebar_content_left', 'sidebar_content_right', 'related_product_section_help', 'cms_social_media_links') AND cms_pages.status = '1' AND cms_pages.corporate_id = 0 ORDER BY corporate_id DESC 0.0003 sec
↳cms.php : 15 -> require_once
*******************************COMMON END*********************************
27 . SELECT * FROM url_redirection_manage WHERE (old_url = 'http://abcimaging.dev.radixweb.net/calendar.html' OR old_url = 'http://abcimaging.dev.radixweb.net/calendar.html' OR old_url = 'http://abcimaging.dev.radixweb.net/calendar.html') ORDER BY url_redirection_id ASC 0.0001 sec
↳cms.php : 23 -> manage_url_redirection
28 . SELECT SQL_CALC_FOUND_ROWS cms_pages.*, cms_pages_description.page_heading , cms_pages_description.page_content FROM cms_pages LEFT JOIN cms_pages_description ON cms_pages_description.page_id = cms_pages.page_id WHERE cms_pages_description.site_language_id = 1 AND (cms_pages.page_name = 'calendar' OR cms_pages.page_name = 'calendar') AND cms_pages.status = '1' GROUP BY cms_pages.page_id ORDER BY corporate_id ASC, corporate_id DESC 0.0005 sec
↳cms.php : 75 -> CmsPagesMaster::getCmsPagesDetails
Array
(
[twd] => Array
(
[titletag] =>Printing Services| Design. Create. Print | ABCPrint Room
[metatag] =>
ABC PrintRoom 5290 Shawnee Road, Suite 300customerservice@abcprintroom.com
[cms_header] =>
Welcome to ABC PrintRoom! Your one stop print source for any occasion. Popular Products Start your print project today. Upload your own files or choose from our 3,500 customizable design templates.
[cms_middle_footer] =>
Weddings Family Albums Look Books Portfolios
Sign up for savings, join our eNewsletter
Watch Online Design Tool Video VIDEO
[related_product_section_help] =>
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]
[cmsData] => RDataRecord Object
(
[_Data:protected] => Array
(
[page_id] => 97
[page_name] => calendar
[type] => M
[status] => 1
[allow_delete] => 1
[full_html] => 1
[sidebar_display] => 0
[corporate_id] => 0
[created_on] => 2018-11-19 15:18:51
[modified_on] => 2018-11-19 15:18:51
[page_heading] =>
[page_content] =>
Desktop Calendar From as low as $10.00 Folded Calendar From as low as $14.95 Wall Calendar From as low as $14.95 Yearly Calendar From as low as $5.00 1
Pick a Template Chose from our selection of designs or create your own
2
Add Photos Upload photos & artwork and place them into our layouts.
3
Customize Create a personalized calendar with our powerful and easy-to-use online designer
Create a personalized calendar with our Customize your calendar with birthdays, Display all or select specific holidays.
)
[_IteratorKeys:protected] => Array
(
[0] => page_id
[1] => page_name
[2] => type
[3] => status
[4] => allow_delete
[5] => full_html
[6] => sidebar_display
[7] => corporate_id
[8] => created_on
[9] => modified_on
[10] => page_heading
[11] => page_content
)
)
[CmsPageName] => calendar
[DataCmsMaster] => RDataRecordSet Object
(
[ResultData:RDataRecordSet:private] => PDOStatement Object
(
[queryString] => SELECT SQL_CALC_FOUND_ROWS cms_pages.*, cms_pages_description.page_heading , cms_pages_description.page_content FROM cms_pages LEFT JOIN cms_pages_description ON cms_pages_description.page_id = cms_pages.page_id WHERE cms_pages_description.site_language_id = :site_language_id AND (cms_pages.page_name = :cms_pages_page_name OR cms_pages.page_name = :cms_pages_decode_str_page_name) AND cms_pages.status = :cms_pages_status GROUP BY cms_pages.page_id ORDER BY corporate_id ASC, corporate_id DESC
)
[AffectedRows:RDataRecordSet:private] => 1
[RecordCount] => 1
[foundRows] => 1
[RecordList:RDataRecordSet:private] => Array
(
[0] => RDataRecord Object
(
[_Data:protected] => Array
(
[page_id] => 97
[page_name] => calendar
[type] => M
[status] => 1
[allow_delete] => 1
[full_html] => 1
[sidebar_display] => 0
[corporate_id] => 0
[created_on] => 2018-11-19 15:18:51
[modified_on] => 2018-11-19 15:18:51
[page_heading] =>
[page_content] =>
Desktop Calendar From as low as $10.00 Folded Calendar From as low as $14.95 Wall Calendar From as low as $14.95 Yearly Calendar From as low as $5.00 1
Pick a Template Chose from our selection of designs or create your own
2
Add Photos Upload photos & artwork and place them into our layouts.
3
Customize Create a personalized calendar with our powerful and easy-to-use online designer
Create a personalized calendar with our Customize your calendar with birthdays, Display all or select specific holidays.
)
[_IteratorKeys:protected] => Array
(
[0] => page_id
[1] => page_name
[2] => type
[3] => status
[4] => allow_delete
[5] => full_html
[6] => sidebar_display
[7] => corporate_id
[8] => created_on
[9] => modified_on
[10] => page_heading
[11] => page_content
)
)
)
[IteratorCount:RDataRecordSet:private] => 0
[last_query] => SELECT SQL_CALC_FOUND_ROWS cms_pages.*, cms_pages_description.page_heading , cms_pages_description.page_content FROM cms_pages LEFT JOIN cms_pages_description ON cms_pages_description.page_id = cms_pages.page_id WHERE cms_pages_description.site_language_id = 1 AND (cms_pages.page_name = 'calendar' OR cms_pages.page_name = 'calendar') AND cms_pages.status = '1' GROUP BY cms_pages.page_id ORDER BY corporate_id ASC, corporate_id DESC
)
[own_mail] =>
[err] =>
[referrer_page] =>
[admin] =>
[isPopup_loaded] =>
)
)
*******************************Render TPL Start*********************************
29 . SELECT * FROM website_logos WHERE corporate_id = 0 0.0001 sec
↳cms.php : 143 -> Twig_Environment::render (mainpage.tpl )
Render > 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] => 30 . SELECT * FROM site_language WHERE status = '1' 0.0001 sec
↳cms.php : 143 -> Twig_Environment::render (mainpage.tpl )
31 . 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 0.0011 sec
↳cms.php : 143 -> Twig_Environment::render (mainpage.tpl )
32 . SELECT product_category.category_id,product_category.category_pro_enable,product_category.category_pro_pattern,product_category_description.category_promotional_text FROM product_category_description LEFT JOIN product_category ON product_category.category_id = product_category_description.category_id WHERE product_category.status = '1' AND product_category.parent_id = '0' AND product_category_description.site_language_id = 1 0.0002 sec
↳cms.php : 143 -> Twig_Environment::render (mainpage.tpl )
33 . SELECT SQL_CALC_FOUND_ROWS * FROM product_kit LEFT JOIN product_kit_description ON product_kit_description.kit_id = product_kit.kit_id AND product_kit_description.site_language_id = 1 WHERE (product_kit.user_type_id = '1' OR product_kit.user_type_id = '0') AND product_kit.status = 1 ORDER BY product_kit.sort_order ASC, product_kit.kit_id ASC 0.0003 sec
↳cms.php : 143 -> Twig_Environment::render (mainpage.tpl )
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] => Render > product_category_group.block Array
(
[twd] => Array
(
[product_count] => 20
[FArray] => Array
(
[0] => product_info.php
[1] => product_design_upload.php
[2] => product_designs.php
[3] => corporate_products.php
)
[productCategoryDetails] => RDataRecordSet Object
(
[ResultData:RDataRecordSet:private] => PDOStatement Object
(
[queryString] => SELECT pp.sort_order AS group_srt,products.category_id as cat_id, products_description.product_url,product_category.category_id,product_category.category_pro_enable,products.multiple_category,product_category_description.category_name,product_category_description.category_promotional_text,product_category.parent_id, products.products_id, products.predefined_product_type, products_description.products_title,products_description.product_promotional_text,product_settings.setting_constant_name,product_settings.setting_value,pcd.category_name AS group_name FROM products LEFT JOIN product_category ON products.category_id = product_category.category_id OR (find_in_set(product_category.category_id,products.multiple_category) > 0) LEFT JOIN product_category_description ON (product_category_description.category_id = product_category.category_id AND product_category_description.site_language_id = :pcd_site_language_id) LEFT JOIN product_category pp ON pp.category_id = product_category.parent_id AND pp.status = :pp_status LEFT JOIN product_category_description pcd ON pcd.category_id = product_category.parent_id AND pp.status = '1' AND pcd.site_language_id = :pcd_site_language_id1 LEFT JOIN products_description ON (products_description.products_id = products.products_id AND products_description.site_language_id = :products_description_site_language_id) LEFT JOIN product_settings ON (product_settings.products_id = products.products_id AND product_settings.setting_constant_name = 'PRODUCT_PROMOTION_IN_TITLE') WHERE product_category.status = :product_category_status AND products.visible = :products_visible_2 AND products.products_id != :products_id_quote AND products.predefined_product_type IN (:input_0, :input_1, :input_2, :input_3, :input_4) AND products.product_service_type NOT IN (:input_5, :input_6, :input_7, :input_8) AND (products.user_type_id = :products_corporate_id_1 OR products.user_type_id = :products_user_type_id_0) ORDER BY -group_srt DESC, product_category.sort_order ASC, product_category.parent_id ASC, product_category.category_id ASC, products.sort_order ASC,products_description.products_title ASC, products.products_id ASC
)
[AffectedRows:RDataRecordSet:private] => 20
[RecordCount] => 20
[foundRows] => -1
[RecordList:RDataRecordSet:private] => Array
(
[0] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 10
[product_url] => canvasprints
[category_id] => 10
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Specialty Products
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 97
[predefined_product_type] => 0
[products_title] => Canvas Prints
[product_promotional_text] =>
[setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE
[setting_value] => no
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[1] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 10
[product_url] => square-magnets
[category_id] => 10
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Specialty Products
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 68
[predefined_product_type] => 0
[products_title] => Square Magnets
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[2] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 10
[product_url] => custom-shape-magnet
[category_id] => 10
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Specialty Products
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 67
[predefined_product_type] => 0
[products_title] => Custom Shape Magnet
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[3] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 8
[product_url] => test-photoprint-product
[category_id] => 8
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Photo Books
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 2001
[predefined_product_type] => 12
[products_title] => Test Photoprint Product
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[4] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 8
[product_url] => square-photo-book-8x8-inch
[category_id] => 8
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Photo Books
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 96
[predefined_product_type] => 3
[products_title] => Photo Book (8x8)
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[5] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 8
[product_url] => square-photo-book-12x12-inch
[category_id] => 8
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Photo Books
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 95
[predefined_product_type] => 3
[products_title] => Photo Book (12x12)
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[6] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 8
[product_url] => photobook-portrait
[category_id] => 8
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Photo Books
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 94
[predefined_product_type] => 3
[products_title] => Photo Book (Portrait)
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[7] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 8
[product_url] => photobook-landscape
[category_id] => 8
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Photo Books
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 2000
[predefined_product_type] => 3
[products_title] => Photo Book (Landscape)
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[8] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 3
[product_url] => banners
[category_id] => 3
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 23
[predefined_product_type] => 0
[products_title] => Banners
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[9] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 3
[product_url] => postcards
[category_id] => 3
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 4
[predefined_product_type] => 0
[products_title] => Postcards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[10] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 3
[product_url] => yard-sign-banners
[category_id] => 3
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 66
[predefined_product_type] => 0
[products_title] => Yard Sign Banners
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[11] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 3
[product_url] => car-door-magnets
[category_id] => 3
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 82
[predefined_product_type] => 0
[products_title] => Car Door Magnets
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[12] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 3
[product_url] => catalogs-both-side
[category_id] => 3
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 22
[predefined_product_type] => 0
[products_title] => Catalogs Both Side
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[13] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 3
[product_url] => door-hangers-two-side
[category_id] => 3
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 26
[predefined_product_type] => 0
[products_title] => Door Hangers Two Side
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[14] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 3
[product_url] => brochures
[category_id] => 3
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 7
[predefined_product_type] => 0
[products_title] => Brochures
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[15] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 3
[product_url] => flyers-one-side
[category_id] => 3
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 2
[predefined_product_type] => 0
[products_title] => Flyers One Side
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[16] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 11
[product_url] => posters
[category_id] => 11
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Posters, Banners & Signs
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 24
[predefined_product_type] => 0
[products_title] => Posters
[product_promotional_text] =>
[setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE
[setting_value] => no
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[17] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 2
[product_url] => envelopes
[category_id] => 2
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Business Stationary
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 5
[predefined_product_type] => 0
[products_title] => Envelopes
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[18] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 2
[product_url] => greeting-cards
[category_id] => 2
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Business Stationary
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 20
[predefined_product_type] => 0
[products_title] => Greeting Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[19] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 2
[product_url] => letterhead
[category_id] => 2
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Business Stationary
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 3
[predefined_product_type] => 0
[products_title] => Letterhead
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
)
[IteratorCount:RDataRecordSet:private] => 20
[last_query] => SELECT pp.sort_order AS group_srt,products.category_id as cat_id, products_description.product_url,product_category.category_id,product_category.category_pro_enable,products.multiple_category,product_category_description.category_name,product_category_description.category_promotional_text,product_category.parent_id, products.products_id, products.predefined_product_type, products_description.products_title,products_description.product_promotional_text,product_settings.setting_constant_name,product_settings.setting_value,pcd.category_name AS group_name FROM products LEFT JOIN product_category ON products.category_id = product_category.category_id OR (find_in_set(product_category.category_id,products.multiple_category) > 0) LEFT JOIN product_category_description ON (product_category_description.category_id = product_category.category_id AND product_category_description.site_language_id = 1) LEFT JOIN product_category pp ON pp.category_id = product_category.parent_id AND pp.status = '1' LEFT JOIN product_category_description pcd ON pcd.category_id = product_category.parent_id AND pp.status = '1' AND pcd.site_language_id = 1 LEFT JOIN products_description ON (products_description.products_id = products.products_id AND products_description.site_language_id = 1) LEFT JOIN product_settings ON (product_settings.products_id = products.products_id AND product_settings.setting_constant_name = 'PRODUCT_PROMOTION_IN_TITLE') WHERE product_category.status = '1' AND products.visible = '1' AND products.products_id != '-11' AND products.predefined_product_type IN ('0', '11', '1', '3', '12') AND products.product_service_type NOT IN ('2', '3', '4', '5') AND (products.user_type_id = '1' OR products.user_type_id = '0') ORDER BY -group_srt DESC, product_category.sort_order ASC, product_category.parent_id ASC, product_category.category_id ASC, products.sort_order ASC,products_description.products_title ASC, products.products_id ASC
)
[CATEGORY_LAYOUT_ENABLED] => toggle
[category_product] => Array
(
[10] => Array
(
[category_name] => Specialty Products
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[97] => Array
(
[pname] => Canvas Prints
[pro_enable] => no
[pro_title] =>
[cat_id] => 10
[product_url] => canvasprints
)
[68] => Array
(
[pname] => Square Magnets
[pro_enable] =>
[pro_title] =>
[cat_id] => 10
[product_url] => square-magnets
)
[67] => Array
(
[pname] => Custom Shape Magnet
[pro_enable] =>
[pro_title] =>
[cat_id] => 10
[product_url] => custom-shape-magnet
)
)
)
[8] => Array
(
[category_name] => Photo Books
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[2001] => Array
(
[pname] => Test Photoprint Product
[pro_enable] =>
[pro_title] =>
[cat_id] => 8
[product_url] => test-photoprint-product
)
[96] => Array
(
[pname] => Photo Book (8x8)
[pro_enable] =>
[pro_title] =>
[cat_id] => 8
[product_url] => square-photo-book-8x8-inch
)
[95] => Array
(
[pname] => Photo Book (12x12)
[pro_enable] =>
[pro_title] =>
[cat_id] => 8
[product_url] => square-photo-book-12x12-inch
)
[94] => Array
(
[pname] => Photo Book (Portrait)
[pro_enable] =>
[pro_title] =>
[cat_id] => 8
[product_url] => photobook-portrait
)
[2000] => Array
(
[pname] => Photo Book (Landscape)
[pro_enable] =>
[pro_title] =>
[cat_id] => 8
[product_url] => photobook-landscape
)
)
)
[3] => Array
(
[category_name] => Marketing Materials
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[23] => Array
(
[pname] => Banners
[pro_enable] =>
[pro_title] =>
[cat_id] => 3
[product_url] => banners
)
[4] => Array
(
[pname] => Postcards
[pro_enable] =>
[pro_title] =>
[cat_id] => 3
[product_url] => postcards
)
[66] => Array
(
[pname] => Yard Sign Banners
[pro_enable] =>
[pro_title] =>
[cat_id] => 3
[product_url] => yard-sign-banners
)
[82] => Array
(
[pname] => Car Door Magnets
[pro_enable] =>
[pro_title] =>
[cat_id] => 3
[product_url] => car-door-magnets
)
[22] => Array
(
[pname] => Catalogs Both Side
[pro_enable] =>
[pro_title] =>
[cat_id] => 3
[product_url] => catalogs-both-side
)
[26] => Array
(
[pname] => Door Hangers Two Side
[pro_enable] =>
[pro_title] =>
[cat_id] => 3
[product_url] => door-hangers-two-side
)
[7] => Array
(
[pname] => Brochures
[pro_enable] =>
[pro_title] =>
[cat_id] => 3
[product_url] => brochures
)
[2] => Array
(
[pname] => Flyers One Side
[pro_enable] =>
[pro_title] =>
[cat_id] => 3
[product_url] => flyers-one-side
)
)
)
[11] => Array
(
[category_name] => Posters, Banners & Signs
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[24] => Array
(
[pname] => Posters
[pro_enable] => no
[pro_title] =>
[cat_id] => 11
[product_url] => posters
)
)
)
[2] => Array
(
[category_name] => Business Stationary
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[5] => Array
(
[pname] => Envelopes
[pro_enable] =>
[pro_title] =>
[cat_id] => 2
[product_url] => envelopes
)
[20] => Array
(
[pname] => Greeting Cards
[pro_enable] =>
[pro_title] =>
[cat_id] => 2
[product_url] => greeting-cards
)
[3] => Array
(
[pname] => Letterhead
[pro_enable] =>
[pro_title] =>
[cat_id] => 2
[product_url] => letterhead
)
)
)
)
[selected_category] =>
[allgroupcategorys] => RDataRecordSet Object
(
[ResultData:RDataRecordSet:private] => PDOStatement Object
(
[queryString] => SELECT pp.sort_order AS group_srt,products.category_id as cat_id, products_description.product_url,product_category.category_id,product_category.category_pro_enable,products.multiple_category,product_category_description.category_name,product_category_description.category_promotional_text,product_category.parent_id, products.products_id, products.predefined_product_type, products_description.products_title,products_description.product_promotional_text,product_settings.setting_constant_name,product_settings.setting_value,pcd.category_name AS group_name FROM products LEFT JOIN product_category ON products.category_id = product_category.category_id OR (find_in_set(product_category.category_id,products.multiple_category) > 0) LEFT JOIN product_category_description ON (product_category_description.category_id = product_category.category_id AND product_category_description.site_language_id = :pcd_site_language_id) LEFT JOIN product_category pp ON pp.category_id = product_category.parent_id AND pp.status = :pp_status LEFT JOIN product_category_description pcd ON pcd.category_id = product_category.parent_id AND pp.status = '1' AND pcd.site_language_id = :pcd_site_language_id1 LEFT JOIN products_description ON (products_description.products_id = products.products_id AND products_description.site_language_id = :products_description_site_language_id) LEFT JOIN product_settings ON (product_settings.products_id = products.products_id AND product_settings.setting_constant_name = 'PRODUCT_PROMOTION_IN_TITLE') WHERE product_category.status = :product_category_status AND products.visible = :products_visible_2 AND products.products_id != :products_id_quote AND products.predefined_product_type IN (:input_0, :input_1, :input_2, :input_3, :input_4) AND products.product_service_type NOT IN (:input_5, :input_6, :input_7, :input_8) AND (products.user_type_id = :products_corporate_id_1 OR products.user_type_id = :products_user_type_id_0) ORDER BY -group_srt DESC, product_category.sort_order ASC, product_category.parent_id ASC, product_category.category_id ASC, products.sort_order ASC,products_description.products_title ASC, products.products_id ASC
)
[AffectedRows:RDataRecordSet:private] => 20
[RecordCount] => 20
[foundRows] => -1
[RecordList:RDataRecordSet:private] => Array
(
[0] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 10
[product_url] => canvasprints
[category_id] => 10
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Specialty Products
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 97
[predefined_product_type] => 0
[products_title] => Canvas Prints
[product_promotional_text] =>
[setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE
[setting_value] => no
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[1] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 10
[product_url] => square-magnets
[category_id] => 10
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Specialty Products
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 68
[predefined_product_type] => 0
[products_title] => Square Magnets
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[2] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 10
[product_url] => custom-shape-magnet
[category_id] => 10
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Specialty Products
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 67
[predefined_product_type] => 0
[products_title] => Custom Shape Magnet
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[3] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 8
[product_url] => test-photoprint-product
[category_id] => 8
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Photo Books
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 2001
[predefined_product_type] => 12
[products_title] => Test Photoprint Product
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[4] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 8
[product_url] => square-photo-book-8x8-inch
[category_id] => 8
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Photo Books
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 96
[predefined_product_type] => 3
[products_title] => Photo Book (8x8)
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[5] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 8
[product_url] => square-photo-book-12x12-inch
[category_id] => 8
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Photo Books
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 95
[predefined_product_type] => 3
[products_title] => Photo Book (12x12)
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[6] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 8
[product_url] => photobook-portrait
[category_id] => 8
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Photo Books
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 94
[predefined_product_type] => 3
[products_title] => Photo Book (Portrait)
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[7] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 8
[product_url] => photobook-landscape
[category_id] => 8
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Photo Books
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 2000
[predefined_product_type] => 3
[products_title] => Photo Book (Landscape)
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[8] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 3
[product_url] => banners
[category_id] => 3
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 23
[predefined_product_type] => 0
[products_title] => Banners
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[9] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 3
[product_url] => postcards
[category_id] => 3
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 4
[predefined_product_type] => 0
[products_title] => Postcards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[10] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 3
[product_url] => yard-sign-banners
[category_id] => 3
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 66
[predefined_product_type] => 0
[products_title] => Yard Sign Banners
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[11] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 3
[product_url] => car-door-magnets
[category_id] => 3
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 82
[predefined_product_type] => 0
[products_title] => Car Door Magnets
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[12] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 3
[product_url] => catalogs-both-side
[category_id] => 3
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 22
[predefined_product_type] => 0
[products_title] => Catalogs Both Side
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[13] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 3
[product_url] => door-hangers-two-side
[category_id] => 3
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 26
[predefined_product_type] => 0
[products_title] => Door Hangers Two Side
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[14] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 3
[product_url] => brochures
[category_id] => 3
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 7
[predefined_product_type] => 0
[products_title] => Brochures
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[15] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 3
[product_url] => flyers-one-side
[category_id] => 3
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 2
[predefined_product_type] => 0
[products_title] => Flyers One Side
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[16] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 11
[product_url] => posters
[category_id] => 11
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Posters, Banners & Signs
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 24
[predefined_product_type] => 0
[products_title] => Posters
[product_promotional_text] =>
[setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE
[setting_value] => no
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[17] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 2
[product_url] => envelopes
[category_id] => 2
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Business Stationary
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 5
[predefined_product_type] => 0
[products_title] => Envelopes
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[18] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 2
[product_url] => greeting-cards
[category_id] => 2
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Business Stationary
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 20
[predefined_product_type] => 0
[products_title] => Greeting Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[19] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 2
[product_url] => letterhead
[category_id] => 2
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Business Stationary
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 3
[predefined_product_type] => 0
[products_title] => Letterhead
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
)
[IteratorCount:RDataRecordSet:private] => 20
[last_query] => SELECT pp.sort_order AS group_srt,products.category_id as cat_id, products_description.product_url,product_category.category_id,product_category.category_pro_enable,products.multiple_category,product_category_description.category_name,product_category_description.category_promotional_text,product_category.parent_id, products.products_id, products.predefined_product_type, products_description.products_title,products_description.product_promotional_text,product_settings.setting_constant_name,product_settings.setting_value,pcd.category_name AS group_name FROM products LEFT JOIN product_category ON products.category_id = product_category.category_id OR (find_in_set(product_category.category_id,products.multiple_category) > 0) LEFT JOIN product_category_description ON (product_category_description.category_id = product_category.category_id AND product_category_description.site_language_id = 1) LEFT JOIN product_category pp ON pp.category_id = product_category.parent_id AND pp.status = '1' LEFT JOIN product_category_description pcd ON pcd.category_id = product_category.parent_id AND pp.status = '1' AND pcd.site_language_id = 1 LEFT JOIN products_description ON (products_description.products_id = products.products_id AND products_description.site_language_id = 1) LEFT JOIN product_settings ON (product_settings.products_id = products.products_id AND product_settings.setting_constant_name = 'PRODUCT_PROMOTION_IN_TITLE') WHERE product_category.status = '1' AND products.visible = '1' AND products.products_id != '-11' AND products.predefined_product_type IN ('0', '11', '1', '3', '12') AND products.product_service_type NOT IN ('2', '3', '4', '5') AND (products.user_type_id = '1' OR products.user_type_id = '0') ORDER BY -group_srt DESC, product_category.sort_order ASC, product_category.parent_id ASC, product_category.category_id ASC, products.sort_order ASC,products_description.products_title ASC, products.products_id ASC
)
[group_categorys] => Array
(
[-1] => Array
(
[group_name] =>
[group_enable] =>
[group_pro_text] =>
[groups] => Array
(
[10] => Array
(
[category_name] => Specialty Products
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[97] => Array
(
[pname] => Canvas Prints
[pro_enable] => no
[pro_title] =>
[product_url] => canvasprints
)
[68] => Array
(
[pname] => Square Magnets
[pro_enable] =>
[pro_title] =>
[product_url] => square-magnets
)
[67] => Array
(
[pname] => Custom Shape Magnet
[pro_enable] =>
[pro_title] =>
[product_url] => custom-shape-magnet
)
)
)
[8] => Array
(
[category_name] => Photo Books
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[2001] => Array
(
[pname] => Test Photoprint Product
[pro_enable] =>
[pro_title] =>
[product_url] => test-photoprint-product
)
[96] => Array
(
[pname] => Photo Book (8x8)
[pro_enable] =>
[pro_title] =>
[product_url] => square-photo-book-8x8-inch
)
[95] => Array
(
[pname] => Photo Book (12x12)
[pro_enable] =>
[pro_title] =>
[product_url] => square-photo-book-12x12-inch
)
[94] => Array
(
[pname] => Photo Book (Portrait)
[pro_enable] =>
[pro_title] =>
[product_url] => photobook-portrait
)
[2000] => Array
(
[pname] => Photo Book (Landscape)
[pro_enable] =>
[pro_title] =>
[product_url] => photobook-landscape
)
)
)
[3] => Array
(
[category_name] => Marketing Materials
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[23] => Array
(
[pname] => Banners
[pro_enable] =>
[pro_title] =>
[product_url] => banners
)
[4] => Array
(
[pname] => Postcards
[pro_enable] =>
[pro_title] =>
[product_url] => postcards
)
[66] => Array
(
[pname] => Yard Sign Banners
[pro_enable] =>
[pro_title] =>
[product_url] => yard-sign-banners
)
[82] => Array
(
[pname] => Car Door Magnets
[pro_enable] =>
[pro_title] =>
[product_url] => car-door-magnets
)
[22] => Array
(
[pname] => Catalogs Both Side
[pro_enable] =>
[pro_title] =>
[product_url] => catalogs-both-side
)
[26] => Array
(
[pname] => Door Hangers Two Side
[pro_enable] =>
[pro_title] =>
[product_url] => door-hangers-two-side
)
[7] => Array
(
[pname] => Brochures
[pro_enable] =>
[pro_title] =>
[product_url] => brochures
)
[2] => Array
(
[pname] => Flyers One Side
[pro_enable] =>
[pro_title] =>
[product_url] => flyers-one-side
)
)
)
[11] => Array
(
[category_name] => Posters, Banners & Signs
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[24] => Array
(
[pname] => Posters
[pro_enable] => no
[pro_title] =>
[product_url] => posters
)
)
)
[2] => Array
(
[category_name] => Business Stationary
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[5] => Array
(
[pname] => Envelopes
[pro_enable] =>
[pro_title] =>
[product_url] => envelopes
)
[20] => Array
(
[pname] => Greeting Cards
[pro_enable] =>
[pro_title] =>
[product_url] => greeting-cards
)
[3] => Array
(
[pname] => Letterhead
[pro_enable] =>
[pro_title] =>
[product_url] => letterhead
)
)
)
)
)
)
[category_with_group] => Array
(
)
[category_without_group_name] => Array
(
[10] => Array
(
[category_name] => Specialty Products
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[97] => Array
(
[pname] => Canvas Prints
[pro_enable] => no
[pro_title] =>
[product_url] => canvasprints
)
[68] => Array
(
[pname] => Square Magnets
[pro_enable] =>
[pro_title] =>
[product_url] => square-magnets
)
[67] => Array
(
[pname] => Custom Shape Magnet
[pro_enable] =>
[pro_title] =>
[product_url] => custom-shape-magnet
)
)
)
[8] => Array
(
[category_name] => Photo Books
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[2001] => Array
(
[pname] => Test Photoprint Product
[pro_enable] =>
[pro_title] =>
[product_url] => test-photoprint-product
)
[96] => Array
(
[pname] => Photo Book (8x8)
[pro_enable] =>
[pro_title] =>
[product_url] => square-photo-book-8x8-inch
)
[95] => Array
(
[pname] => Photo Book (12x12)
[pro_enable] =>
[pro_title] =>
[product_url] => square-photo-book-12x12-inch
)
[94] => Array
(
[pname] => Photo Book (Portrait)
[pro_enable] =>
[pro_title] =>
[product_url] => photobook-portrait
)
[2000] => Array
(
[pname] => Photo Book (Landscape)
[pro_enable] =>
[pro_title] =>
[product_url] => photobook-landscape
)
)
)
[3] => Array
(
[category_name] => Marketing Materials
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[23] => Array
(
[pname] => Banners
[pro_enable] =>
[pro_title] =>
[product_url] => banners
)
[4] => Array
(
[pname] => Postcards
[pro_enable] =>
[pro_title] =>
[product_url] => postcards
)
[66] => Array
(
[pname] => Yard Sign Banners
[pro_enable] =>
[pro_title] =>
[product_url] => yard-sign-banners
)
[82] => Array
(
[pname] => Car Door Magnets
[pro_enable] =>
[pro_title] =>
[product_url] => car-door-magnets
)
[22] => Array
(
[pname] => Catalogs Both Side
[pro_enable] =>
[pro_title] =>
[product_url] => catalogs-both-side
)
[26] => Array
(
[pname] => Door Hangers Two Side
[pro_enable] =>
[pro_title] =>
[product_url] => door-hangers-two-side
)
[7] => Array
(
[pname] => Brochures
[pro_enable] =>
[pro_title] =>
[product_url] => brochures
)
[2] => Array
(
[pname] => Flyers One Side
[pro_enable] =>
[pro_title] =>
[product_url] => flyers-one-side
)
)
)
[11] => Array
(
[category_name] => Posters, Banners & Signs
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[24] => Array
(
[pname] => Posters
[pro_enable] => no
[pro_title] =>
[product_url] => posters
)
)
)
[2] => Array
(
[category_name] => Business Stationary
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[5] => Array
(
[pname] => Envelopes
[pro_enable] =>
[pro_title] =>
[product_url] => envelopes
)
[20] => Array
(
[pname] => Greeting Cards
[pro_enable] =>
[pro_title] =>
[product_url] => greeting-cards
)
[3] => Array
(
[pname] => Letterhead
[pro_enable] =>
[pro_title] =>
[product_url] => letterhead
)
)
)
)
[select_group] =>
[select_category_product] =>
)
)
34 . SELECT SQL_CALC_FOUND_ROWS * FROM banner_image_setting 0.0002 sec
↳cms.php : 143 -> Twig_Environment::render (mainpage.tpl )
35 . SELECT SQL_CALC_FOUND_ROWS banner_image.* FROM banner_image LEFT JOIN site_language ON site_language.site_language_id = banner_image.banner_language WHERE (banner_image.banner_start_date = '0' OR (banner_image.banner_start_date <= '2024-04-20 00:54:27' AND banner_image.banner_end_date >= '2024-04-20 00:54:27')) AND (FIND_IN_SET('calendar',banner_image.banner_pages)) AND banner_image.corporate_id = 0 AND banner_image.banner_language IN (1, 0) AND banner_image.status = '1' ORDER BY sort_order ASC 0.0003 sec
↳cms.php : 143 -> Twig_Environment::render (mainpage.tpl )
Array
(
[twd] => Array
(
[section] => top
[index_top_section_details] => 1
[banner_settings] => Array
(
[bannerWidth] => auto
[bannerHeight] => auto
[autoStart] => 1
[timeout] => 6000
[showPrevNextLinks] => 1
[showPagerLinks] => 1
[bannerDescLeftPosition] => auto
[bannerDescTopPosition] => auto
[bannerEffect] => slide
[bannerDisplayType] => 1
[bannerSelection] => 0
)
[res_banner] => Array
(
[0] => RDataRecord Object
(
[_Data:protected] => Array
(
[banner_image_id] => 27
[banner_image_name] => Calendar_promo.jpg
[banner_link] =>
[open_target] => _blank
[banner_display] => 2
[banner_available_to] => 3
[banner_pages] => calendar
[category_ids] =>
[sort_order] => 0
[status] => 1
[title] => calendar
[banner_language] => 0
[corporate_id] => 0
[banner_text] =>
[banner_upperimage_name] =>
[banner_advance_settings] =>
[banner_start_date] => 0000-00-00 00:00:00
[banner_end_date] => 0000-00-00 00:00:00
)
[_IteratorKeys:protected] => Array
(
[0] => banner_image_id
[1] => banner_image_name
[2] => banner_link
[3] => open_target
[4] => banner_display
[5] => banner_available_to
[6] => banner_pages
[7] => category_ids
[8] => sort_order
[9] => status
[10] => title
[11] => banner_language
[12] => corporate_id
[13] => banner_text
[14] => banner_upperimage_name
[15] => banner_advance_settings
[16] => banner_start_date
[17] => banner_end_date
)
)
)
[banner_advance_settings] => Array
(
[27] => Array
(
)
)
)
)
36 . SELECT * FROM breadcrumbs WHERE status = '1' 0.0004 sec
↳cms.php : 143 -> Twig_Environment::render (mainpage.tpl )
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] => 37 . SELECT * FROM (SELECT promotional_message.promotional_id,promotional_category,promotional_message_description.title,promotional_message_description.description,style_type,status,section_name,promo_cookie,promo_settings FROM promotional_messageLEFT JOIN promotional_message_description ON promotional_message_description.promotional_id = promotional_message.promotional_id WHERE 1 AND promotional_message_description.site_language_id = 1 AND promotional_message.status = '1' AND (user_type = '1' OR user_type = '0') AND (promotional_message.promotion_start_date = '0' OR (promotional_message.promotion_start_date <= '2024-04-20 00:54:27' AND promotional_message.promotion_end_date >= '2024-04-20 00:54:27')) AND (promotional_message.promotional_display = '2' OR promotional_message.promotional_display = '0' ) AND promotional_message.section_name LIKE 'cms.php?page=calendar' OR ((promotional_message.promotional_category = '13' OR promotional_message.promotional_category = '14' ) AND (user_type = '1' OR user_type = '0') AND (promotional_message.promotion_start_date = '0' OR (promotional_message.promotion_start_date <= '2024-04-20 00:54:27' AND promotional_message.promotion_end_date >= '2024-04-20 00:54:27'))AND (promotional_message.promotional_display = '2' OR promotional_message.promotional_display = '0' ) AND promotional_message_description.site_language_id = 1 AND promotional_message.status = '1') ORDER BY FIELD(promotional_category,'14','13','12',promotional_category),promotional_message.promotional_id DESC LIMIT 18446744073709551615) AS a group by promotional_category LIMIT 0,1 0.0008 sec
↳cms.php : 143 -> Twig_Environment::render (mainpage.tpl )
Desktop Calendar
Folded
Wall
Yearly
Create a personalized calendar with our
Customize your calendar with birthdays,
Display all or select specific holidays. 
