RESULT OF LOADFULLPRODUCT
array (
'product_group_id' => 758,
'name' => 'Angel View',
'title' => 'Angel View™',
'summary' => 'Angel View™ is the wide view mirror attachment that gives a 160° view behind you to help reduce blind spots. Angel View™ is quick and easy to install and snaps over most rearview mirrors in seconds. And the spring-loaded rubber feet automatically adjust to hold on tight. Plus, Angel Views™ wide convex shape, crystal clear mirror and special anti-glare coating helps provide amazing panoramic vision day or night. From a senior driver to a younger driver and everyone in between, get a wide view with Angel View™.',
'description' => NULL,
'tag_line' => 'Wide View Mirror Attachment That Helps Reduce Blind Spots',
'tag_line_cross_sell' => 'SAVE $20!',
'offer_tag_line' => 'BUY 1, GET 1 MORE!',
'image_category' => 'productGroup/758/1680063372_Angel View_Cat_logo.jpg',
'image_logo' => 'productGroup/758/1680063372_Angel View_Logo.jpg',
'image_landscape' => '',
'image_overlay' => 'productGroup/758/1680063374_Angel View_Gallery_1.jpg',
'call_centre_script' => '
Would you like to add another Angel View buy 1, get 1 more offer to your order and save $20?
So thats only $49.95 with free delivery for another Angel View?
[AFTER REPLY]
For your convenience would you like to pay in one easy amount?
',
'call_centre_script_cross_sell' => '
Angel View™ is the wide view mirror attachment that gives a 160° view behind you to help reduce blind spots. Angel View™ is quick and easy to install and snaps over most rearview mirrors in seconds. And the spring-loaded rubber feet automatically adjust to hold on tight. Plus, Angel Views™ wide convex shape, crystal clear mirror and special anti-glare coating helps provide amazing panoramic vision day or night.
Would you like to add a Angel View buy 1, get 1 more offer to your order and save $20?
So thats only $49.95 with free delivery for Angel View?
[AFTER REPLY]
Would you like to add another Angel View buy 1, get 1 more offer to your order and save $20?
So thats only $49.95 with free delivery for another Angel View?
[AFTER REPLY]
For your convenience would you like to pay in one easy amount?
',
'additional_item_title' => NULL,
'additional_item_summary' => NULL,
'stock_control' => 1,
'ax_product_group' => 'ANVI',
'product_review_content' => 0,
'stock_level' => 1,
'stock_display_message' => 0,
'stock_message' => NULL,
'stock_configurator' => 1,
'stock_collect_email' => 0,
'url' => 'angel-view-mirror',
'old_product_id' => NULL,
'seo_title' => 'Angel View™ | Wide View Mirror Attachment',
'seo_description' => 'Angel View™ is the wide view mirror attachment that gives a 160° view behind you to help reduce blind spots. Angel View™ is quick and easy to install and snaps over most rearview mirrors in seconds. And the spring-loaded rubber feet automatically adjust to hold on tight. Plus, Angel Views™ wide convex shape, crystal clear mirror and special anti-glare coating helps provide amazing panoramic vision day or night. From a senior driver to a younger driver and everyone in between, get a wide view with Angel View™.',
'status' => '7',
'acoustic_content_id' => NULL,
'acoustic_tag' => 'angel-view-mirror',
'feed_google_image' => 'productGroup/758/1680063372_Angel View_Cat_nologo.jpg',
'feed_google_category' => 'Vehicles & Parts > Vehicle Parts & Accessories',
'stock_lower_level' => 0,
'image_category_path' => NULL,
'image_category_acoustic' => 'dxdam/product/758/1680063372_Angel View_Cat_logo.jpg',
'image_category_acoustic_old' => 'dxdam/product//1680063372_Angel View_Cat_logo.jpg',
'image_logo_path' => NULL,
'image_logo_acoustic' => 'dxdam/product/758/1680063372_Angel View_Logo.jpg',
'image_logo_acoustic_old' => 'dxdam/product//1680063372_Angel View_Logo.jpg',
'image_landscape_path' => '',
'image_landscape_acoustic' => '',
'image_landscape_acoustic_old' => '',
'image_overlay_path' => NULL,
'image_overlay_acoustic' => 'dxdam/product/758/1680063374_Angel View_Gallery_1.jpg',
'image_overlay_acoustic_old' => 'dxdam/product//1680063374_Angel View_Gallery_1.jpg',
)
(Returned via var_export)
DISCOUNTS
array (
0 =>
array (
'PriceDiscountValue' => 10.0,
'PriceDiscountPercentage' => 0.0,
'PhDiscountValue' => 0.0,
'PhDiscountPercentage' => 100.0,
'TotalDiscount' => '0.00',
),
)
(Returned via var_export)
Print val is:
BREAD CRUMBS
object(stdClass)#59 (2) {
[\"url\"]=>
string(7) \"outdoor\"
[\"name\"]=>
string(7) \"OUTDOOR\"
}
(Returned via var_dump)
CATEGORIES
array (
0 =>
array (
'category_id' => 8,
'name' => 'OUTDOOR',
'url' => 'outdoor',
),
1 =>
array (
'category_id' => 10,
'name' => 'TECH & GADGETS',
'url' => 'TECH-GADGETS',
),
2 =>
array (
'category_id' => 21,
'name' => 'DIY',
'url' => 'diy',
),
3 =>
array (
'category_id' => 20,
'name' => 'ALL',
'url' => 'all',
),
4 =>
array (
'category_id' => 28,
'name' => 'FATHER\'S DAY GIFT IDEAS',
'url' => 'fathers-day-gift-ideas',
),
)
(Returned via var_export)
ALL OPTIONS
array (
0 =>
array (
'ProductOptionID' => 1877,
),
)
(Returned via var_export)
PRODUCT OPTIONS
array (
0 =>
array (
'product_option_id' => 1877,
'name' => 'Angel View',
),
)
(Returned via var_export)
Product SQL is:
SELECT
p.ItemTitle as name,
p.ProductID as product_id,
p.Price as price,
p.PH as ph,
p.Stock as stock,
p.SubscriptionCode as subscription_code,
p.Message as message,
p.Disabled as disabled,
IFNULL(p.PriceDiscountValue,0) as discount_price_value,
IFNULL(p.PriceDiscountPercentage,0) as discount_price_percentage,
IFNULL(p.PhDiscountValue,0) as discount_ph_value,
IFNULL(p.PhDiscountPercentage,0) as discount_ph_percentage,
(CASE WHEN pgm.Value IS NOT NULL THEN CONCAT(\"productGroup/\",p.ProductGroupID,\"/\",pgm.Value) WHEN pgm.Value IS NULL THEN NULL END) as image,
(CASE WHEN pgm.AcousticPath IS NOT NULL THEN CONCAT(pgm.AcousticPath) WHEN pgm.AcousticPath IS NULL THEN NULL END) as image_path,
(CASE WHEN pgm.Value IS NOT NULL THEN CONCAT(\"dxdam/product/\",p.ProductGroupID,\"/\",pgm.Value) WHEN pgm.Value IS NULL THEN NULL END) as image_acoustic,
(CASE WHEN pgm.Value IS NOT NULL THEN CONCAT(\"dxdam/product/\",pg.OldProductId,\"/\",pgm.Value) WHEN pgm.Value IS NULL THEN NULL END) as image_acoustic_old,
pgm.AcousticID as acoustic_content_id,
pg.AcousticContentID as acoustic_id
FROM gsddb_product as p
LEFT JOIN gsddb_product_image as pi ON p.ProductID=pi.ProductID
LEFT JOIN gsddb_product_group_media as pgm ON pi.ProductGroupMediaID=pgm.ProductGroupMediaID
JOIN gsddb_product_group as pg ON pg.ProductGroupID = p.ProductGroupID JOIN gsddb_product_group_sales_channel as pgsc ON p.ProductGroupID = pgsc.ProductGroupID JOIN gsddb_sales_channel as sc ON pgsc.SalesChannelID = sc.SalesChannelID WHERE p.ProductOptionID = ? AND sc.SalesChannelID = 5 AND sc.Configurator = 1 AND pg.Status IN (3, 5, 7) AND p.AXItemID IS NOT NULL GROUP BY p.ProductID
RAW PRODUCTS DATA
array (
0 =>
array (
'name' => 'Angel View',
'product_id' => 2765,
'price' => 59.95,
'ph' => 9.95,
'stock' => 0,
'subscription_code' => NULL,
'message' => NULL,
'disabled' => 1,
'discount_price_value' => 10.0,
'discount_price_percentage' => 0.0,
'discount_ph_value' => 0.0,
'discount_ph_percentage' => 100.0,
'image' => 'productGroup/758/1680063372_Angel View_Configurator.jpg',
'image_path' => NULL,
'image_acoustic' => 'dxdam/product/758/1680063372_Angel View_Configurator.jpg',
'image_acoustic_old' => NULL,
'acoustic_content_id' => NULL,
'acoustic_id' => NULL,
),
)
(Returned via var_export)
[
{
\"name\": \"Angel View\",
\"product_id\": 2765,
\"price\": 59.95,
\"ph\": 9.95,
\"stock\": 0,
\"subscription_code\": null,
\"message\": null,
\"disabled\": 1,
\"discount_price_value\": 10,
\"discount_price_percentage\": 0,
\"discount_ph_value\": 0,
\"discount_ph_percentage\": 100,
\"image\": \"productGroup\/758\/1680063372_Angel View_Configurator.jpg\",
\"image_path\": null,
\"image_acoustic\": \"dxdam\/product\/758\/1680063372_Angel View_Configurator.jpg\",
\"image_acoustic_old\": null,
\"acoustic_content_id\": null,
\"acoustic_id\": null
}
]Function:GetProducts() CONFIGURATOR OPTIONS? GET RESULT FULL RETURN OF EVERYTHING
{
\"options\": [
{
\"0\": {
\"product_option_id\": 1877,
\"name\": \"Angel View\"
},
\"attributes\": [],
\"products\": [
{
\"name\": \"Angel View\",
\"product_id\": 2765,
\"price\": 59.95,
\"ph\": 9.95,
\"stock\": 0,
\"subscription_code\": null,
\"message\": null,
\"disabled\": 1,
\"discount_price_value\": 10,
\"discount_price_percentage\": 0,
\"discount_ph_value\": 0,
\"discount_ph_percentage\": 100,
\"image\": \"productGroup\/758\/1680063372_Angel View_Configurator.jpg\",
\"image_path\": null,
\"image_acoustic\": \"dxdam\/product\/758\/1680063372_Angel View_Configurator.jpg\",
\"image_acoustic_old\": null,
\"acoustic_content_id\": null,
\"acoustic_id\": null
}
]
}
]
}PRODUCT OPTIONS FOR CONFIGURATOR
SQL FOR FREEBIES
SELECT
gsddb_product_group.Name as GroupName,
gsddb_product_group.ProductGroupID as ProductGroupID,
gsddb_product_group.StockControl as stock_control,
gsddb_product_group.StockLevel as stock_level,
gsddb_product_group.StockDisplayMessage as stock_display_message,
gsddb_product_group.StockMessage as stock_message,
gsddb_product_group.StockConfigurator as stock_configurator,
gsddb_product_group.StockCollectEmail as stock_collect_email,
(SELECT min(Stock) FROM gsddb_product WHERE ProductGroupID=gsddb_product_group.ProductGroupID) AS stock_lower_level,
gsddb_product_freebie.FreebieID,
gsddb_product_freebie.ProductFreebieID as product_freebie_id,
gsddb_freebie.Description as product_freebie_name,
gsddb_freebie.FreebieType as freebie_type,
gsddb_freebie.Quantity as quantity,
gsddb_freebie.Price as product_freebie_price,
gsddb_freebie.Ph as product_freebie_ph,
gsddb_product.ProductOptionID,
gsddb_product_option.Name as OptionName,
gsddb_product.ProductID,
gsddb_product.ItemTitle as ProductName,
gsddb_product.AXItemID as AXItemID,
gsddb_product.Price as price,
gsddb_product.PH as ph,
gsddb_product.Stock as stock,
gsddb_product.SubscriptionCode as subscription_code,
gsddb_product.Message as message,
gsddb_product.Disabled as disabled,
IFNULL(gsddb_product.PriceDiscountValue,0) as discount_price_value,
IFNULL(gsddb_product.PriceDiscountPercentage,0) as discount_price_percentage,
IFNULL(gsddb_product.PhDiscountValue,0) as discount_ph_value,
IFNULL(gsddb_product.PhDiscountPercentage,0) as discount_ph_percentage,
CONCAT(\"productGroup/\",gsddb_product_group.ProductGroupID,\"/\",gsddb_product_group_media.Value) as image,
CONCAT(\"dxdam/product/\",gsddb_product_group.ProductGroupID,\"/\",gsddb_product_group_media.Value) as image_acoustic,
CONCAT(\"dxdam/product/\",gsddb_product_group.OldProductId,\"/\",gsddb_product_group_media.Value) as image_acoustic_old,
gsddb_product_group_media.AcousticID as acoustic_content_id
FROM gsddb_freebie
JOIN gsddb_product_freebie ON gsddb_product_freebie.FreebieID=gsddb_freebie.FreebieID
JOIN gsddb_product ON gsddb_product.ProductID = gsddb_product_freebie.ProductID
JOIN gsddb_product_option ON gsddb_product.ProductOptionID = gsddb_product_option.ProductOptionID
JOIN gsddb_product_group ON gsddb_product_group.ProductGroupID = gsddb_freebie.ProductFreebieGroupID
LEFT JOIN gsddb_product_image ON gsddb_product_image.ProductID = gsddb_product.ProductID
LEFT JOIN gsddb_product_group_media ON gsddb_product_group_media.ProductGroupMediaID = gsddb_product_image.ProductGroupMediaID
WHERE gsddb_freebie.ProductGroupID = ? AND gsddb_product_freebie.Selected=1
AND gsddb_product.AXItemID IS NOT NULL
AND gsddb_product.Price IS NOT NULL
AND gsddb_product.PH IS NOT NULL
FREEBIES
array(1) {
[0]=>
array(18) {
[\"product_option_id\"]=>
int(1877)
[\"name\"]=>
string(10) \"Angel View\"
[\"freebie_id\"]=>
int(339)
[\"product_freebie_id\"]=>
int(675)
[\"product_freebie_name\"]=>
string(5) \"Bonus\"
[\"freebie_type\"]=>
int(1)
[\"product_freebie_quantity\"]=>
int(1)
[\"product_freebie_price\"]=>
float(0)
[\"product_freebie_ph\"]=>
float(0)
[\"stock_control\"]=>
int(1)
[\"stock_level\"]=>
int(1)
[\"stock_display_message\"]=>
int(0)
[\"stock_message\"]=>
NULL
[\"stock_configurator\"]=>
int(0)
[\"stock_collect_email\"]=>
int(0)
[\"stock_lower_level\"]=>
int(0)
[\"products\"]=>
array(1) {
[0]=>
array(22) {
[\"product_id\"]=>
int(2765)
[\"name\"]=>
string(10) \"Angel View\"
[\"ax_item_id\"]=>
string(4) \"ANVI\"
[\"price\"]=>
float(59.95)
[\"ph\"]=>
float(9.95)
[\"stock\"]=>
int(0)
[\"subscription_code\"]=>
NULL
[\"message\"]=>
NULL
[\"disabled\"]=>
int(1)
[\"quantity\"]=>
int(1)
[\"discount_price_value\"]=>
float(10)
[\"discount_price_percentage\"]=>
float(0)
[\"discount_ph_value\"]=>
float(0)
[\"discount_ph_percentage\"]=>
float(100)
[\"image\"]=>
string(55) \"productGroup/758/1680063372_Angel View_Configurator.jpg\"
[\"image_acoustic\"]=>
string(56) \"dxdam/product/758/1680063372_Angel View_Configurator.jpg\"
[\"image_acoustic_old\"]=>
NULL
[\"acoustic_content_id\"]=>
NULL
[\"product_freebie_id\"]=>
int(675)
[\"product_freebie_name\"]=>
string(5) \"Bonus\"
[\"freebie_type\"]=>
int(1)
[\"attributes_and_values\"]=>
array(0) {
}
}
}
[\"attributes\"]=>
array(0) {
}
}
}
(Returned via var_dump)
NO ADDONS
NO ADDON FREEBIES
NO CROSS SELL PRODUCTS
'SELECT
gsddb_product_group_media.ProductGroupMediaID as media_id,
gsddb_product_group_media.Value as value,
gsddb_product_group_media.AcousticPath as acoustic_path,
gsddb_product_group_media.Type as type,
gsddb_product_group.OldProductId as old_id,
IFNULL(gsddb_product_group_gallery.SortOrder,0) as sort_order
FROM gsddb_product_group_gallery
JOIN gsddb_product_group_media ON gsddb_product_group_media.ProductGroupMediaID=gsddb_product_group_gallery.ProductGroupMediaID
JOIN gsddb_product_group ON gsddb_product_group.ProductGroupID = gsddb_product_group_media.ProductGroupID
WHERE gsddb_product_group_gallery.ProductGroupID = 758 ORDER BY sort_order ASC'
(Returned via var_export)
GALLERY IMAGES
array (
0 =>
array (
'media_id' => 9751,
'value' => 'cwR5epPOAl8',
'acoustic_path' => NULL,
'type' => 'VIDEO',
'old_id' => NULL,
'sort_order' => 1,
'image_overlay' => 'productGroup/758/1680063374_Angel View_Gallery_1.jpg',
'image_overlay_path' => NULL,
'image_landscape' => NULL,
'image_landscape_path' => NULL,
'image_overlay_acoustic' => 'dxdam/product/758/1680063374_Angel View_Gallery_1.jpg',
'image_overlay_acoustic_old' => NULL,
'image_landscape_acoustic' => NULL,
'image_landscape_acoustic_old' => NULL,
),
1 =>
array (
'media_id' => 9743,
'value' => 'https://prod-general-assets-bucket-nz20211214193811535900000002.s3-ap-southeast-2.amazonaws.com/productGroup/758/1680063373_Angel View_Gallery_2.jpg',
'acoustic_path' => NULL,
'type' => 'IMAGE',
'old_id' => NULL,
'sort_order' => 2,
),
2 =>
array (
'media_id' => 9752,
'value' => 'https://prod-general-assets-bucket-nz20211214193811535900000002.s3-ap-southeast-2.amazonaws.com/productGroup/758/1680063473_Angel View_Gallery_4.gif',
'acoustic_path' => NULL,
'type' => 'IMAGE',
'old_id' => NULL,
'sort_order' => 3,
),
3 =>
array (
'media_id' => 9744,
'value' => 'https://prod-general-assets-bucket-nz20211214193811535900000002.s3-ap-southeast-2.amazonaws.com/productGroup/758/1680063373_Angel View_Gallery_3.jpg',
'acoustic_path' => NULL,
'type' => 'IMAGE',
'old_id' => NULL,
'sort_order' => 4,
),
4 =>
array (
'media_id' => 9745,
'value' => 'https://prod-general-assets-bucket-nz20211214193811535900000002.s3-ap-southeast-2.amazonaws.com/productGroup/758/1680063374_Angel View_Gallery_5.jpg',
'acoustic_path' => NULL,
'type' => 'IMAGE',
'old_id' => NULL,
'sort_order' => 5,
),
5 =>
array (
'media_id' => 9742,
'value' => 'https://prod-general-assets-bucket-nz20211214193811535900000002.s3-ap-southeast-2.amazonaws.com/productGroup/758/1680063373_Angel View_Gallery_6.jpg',
'acoustic_path' => NULL,
'type' => 'IMAGE',
'old_id' => NULL,
'sort_order' => 6,
),
6 =>
array (
'media_id' => 9748,
'value' => 'https://prod-general-assets-bucket-nz20211214193811535900000002.s3-ap-southeast-2.amazonaws.com/productGroup/758/1680063374_Angel View_Gallery_7.jpg',
'acoustic_path' => NULL,
'type' => 'IMAGE',
'old_id' => NULL,
'sort_order' => 7,
),
7 =>
array (
'media_id' => 9746,
'value' => 'https://prod-general-assets-bucket-nz20211214193811535900000002.s3-ap-southeast-2.amazonaws.com/productGroup/758/1680063374_Angel View_Gallery_8.jpg',
'acoustic_path' => NULL,
'type' => 'IMAGE',
'old_id' => NULL,
'sort_order' => 8,
),
)
(Returned via var_export)
'SELECT
gsddb_product_group_media.ProductGroupMediaID as media_id,
gsddb_product_group_media.Value as value,
gsddb_product_group_media.AcousticPath as acoustic_path,
gsddb_product_group_media.Type as type,
gsddb_product_group_media.AcousticID as acoustic_id,
IFNULL(gsddb_product_group_gallery.SortOrder,0) as sort_order
FROM gsddb_product_group_gallery
JOIN gsddb_product_group_media ON gsddb_product_group_media.ProductGroupMediaID=gsddb_product_group_gallery.ProductGroupMediaID
WHERE gsddb_product_group_gallery.ProductGroupID = ? ORDER BY sort_order ASC'
(Returned via var_export)
FAQs
array (
0 =>
array (
'product_group_faq_id' => 63743,
'question' => 'How does Angel View™ work?',
'answer' => '
Angel View™ is the wide view mirror attachment that gives a 160° view behind you to help reduce blind spots. With a convex curved glass shape, Angel View™ helps see both blind spots with just one glance.
NOTE: Angel View™ does not eliminate the use of side mirrors or blind spot checking.
',
'sort_order' => 1,
),
1 =>
array (
'product_group_faq_id' => 63744,
'question' => 'Is Angel View™ easy to install?',
'answer' => '
Yes! Angel View™ is quick and easy to install. Simply place the spring-loaded rubber feet around your existing rearview mirror and it automatically adjusts to hold on tight.
',
'sort_order' => 2,
),
2 =>
array (
'product_group_faq_id' => 63745,
'question' => 'Does Angle View™ fit on all rearview mirrors?',
'answer' => '
Angel View™ fits virtually any rearview mirror in cars or SUVS.
Note: Angel View™ is not compatible on mirrors more than 80mm or less than 55mm tall.
',
'sort_order' => 3,
),
3 =>
array (
'product_group_faq_id' => 63746,
'question' => 'Does Angel View™ work at night?',
'answer' => '
Yes! Angel View’s™ crystal-clear mirror and special anti-glare coating provides amazing panoramic vision day or night.*
*Results may vary depending on the size, contents, and shape of the vehicle.
',
'sort_order' => 4,
),
)
(Returned via var_export)
PRODUCT CONTENT
array (
0 =>
array (
'product_group_content_id' => 41731,
'type' => 'TEXT',
'name' => 'FEATURES',
'value' => '
- Wide view mirror attachment
- Gives a 160° view behind you to help you see blind spots from your car's rearview mirror*
- Quick and easy to install – snaps over most rearview mirrors in seconds!
- Spring-loaded rubber feet – automatically adjust to hold on tight
- Huge mirror length with curved glass – so you see more (30cm)
- Convex shape – helps see both blind spots with one glance
- Crystal clear mirror – for amazing panoramic vision**
- Special coating is anti-glare at night
- Fits virtually any car or SUV
- Great for new drivers, older drivers and everyone in between
- No fish-eye effect like other mirrors!
- Buy 1, Get 1 More!
*Angel View™ does not eliminate the use of side mirrors or blind spot checking. **Results may vary depending on the size, contents, and shape of the vehicle.
',
'sort_order' => 0,
),
1 =>
array (
'product_group_content_id' => 41732,
'type' => 'TEXT',
'name' => 'OFFER',
'value' => '
![\"\"](\"https://prod-general-assets-bucket-nz20211214193811535900000002.s3-ap-southeast-2.amazonaws.com/productGroup/758/1680063375_Angel)
',
'sort_order' => 0,
),
2 =>
array (
'product_group_content_id' => 41733,
'type' => 'FAQ',
'name' => 'FAQ',
'value' => NULL,
'sort_order' => 0,
),
)
(Returned via var_export)
PRODUCT SALES CHANNEL
array (
0 =>
array (
'sales_channel_id' => 1,
'name' => 'Emarsys',
'emarsys' => 1,
'google' => 1,
'configurator' => 0,
'call_centre' => 1,
'microsite' => 1,
),
1 =>
array (
'sales_channel_id' => 2,
'name' => 'Google',
'emarsys' => 1,
'google' => 1,
'configurator' => 0,
'call_centre' => 0,
'microsite' => 0,
),
2 =>
array (
'sales_channel_id' => 5,
'name' => 'Product Live',
'emarsys' => 0,
'google' => 0,
'configurator' => 1,
'call_centre' => 0,
'microsite' => 0,
),
)
(Returned via var_export)
NO PAYMENT OPTION 5
PAYMENT OPTION
array (
0 =>
array (
'payment_option_id' => 1,
'payment_name' => 'Single Payment',
'number_instalment' => 0,
'ph' => 9.95,
'first_payment' => 59.95,
'next_payment' => 0,
),
1 =>
array (
'payment_option_id' => 2,
'payment_name' => 'Monthly Payments',
'number_instalment' => 5,
'ph' => 9.95,
'first_payment' => 11.99,
'next_payment' => 11.99,
),
)
(Returned via var_export)
GET ADDON SQL
SELECT
gsddb_product.ProductID
FROM gsddb_product_addon
JOIN gsddb_product ON gsddb_product.ProductID = gsddb_product_addon.ProductID
WHERE gsddb_product_addon.ProductGroupID=758;
GET ADDON RESULT
array (
)
(Returned via var_export)
Min Prod SQL
SELECT
IFNULL((IFNULL(Price,0)-(IFNULL(PriceDiscountValue,0)+(IFNULL(PriceDiscountPercentage,0)*IFNULL(Price,0)/100))),0) as price,
IFNULL((IFNULL(OriginalPrice,0)-(IFNULL(PriceDiscountValue,0)+(IFNULL(PriceDiscountPercentage,0)*IFNULL(OriginalPrice,0)/100))),0) as original_price,
IFNULL(PH,0) as ph,
IFNULL(OriginalPH,0) as original_ph,
IFNULL((IFNULL(PH,0)-(IFNULL(PhDiscountValue,0)+(IFNULL(PhDiscountPercentage,0)*IFNULL(PH,0)/100))),0) as ph_discounted,
IFNULL((IFNULL(OriginalPH,0)-(IFNULL(PhDiscountValue,0)+(IFNULL(PhDiscountPercentage,0)*IFNULL(OriginalPH,0)/100))),0) as original_ph_discounted
FROM gsddb_product
WHERE ProductID IN () ORDER BY price ASC LIMIT 1;
Min Prod Results
array (
)
(Returned via var_export)
NO MIN PRODUCT
INSTALMENTS
array (
'have_trial' => 0,
'product' => 'ONLY 5 x $11.99 ($59.95) + $9.95 P&H',
'product_chunks' =>
array (
'title' => 'ONLY',
'installment' => 5,
'price_per_installment' => 11.99,
'total_price' => 59.95,
'ph' => 9.95,
),
'cross_sell' => 'ONLY 5 x $9.99 ($49.95)',
'cross_sell_chunks' =>
array (
'title' => 'ONLY',
'installment' => 5,
'price_per_installment' => 9.99,
'total_price' => 49.95,
'ph' => 0,
),
'addon' => 'ONLY 5 x $0 ($0)',
'price' => 'ONLY 5 x $11.99',
'price_total' => '($59.95) + $9.95 P&H',
'original_product' => 'ONLY 5 x $0 ($0) + $0 P&H',
'original_product_chunks' =>
array (
'title' => 'ONLY',
'installment' => 5,
'price_per_installment' => 0.0,
'total_price' => 0.0,
'ph' => 0.0,
),
'original_cross_sell' => 'ONLY 5 x $-2 ($-10)',
'original_cross_sell_chunks' =>
array (
'title' => 'ONLY',
'installment' => 5,
'price_per_installment' => 0,
'total_price' => 0,
'ph' => 0,
),
'original_addon' => 'ONLY 5 x $0 ($0)',
'original_price' => 'ONLY 5 x $0',
'original_price_total' => '($0) + $0 P&H',
)
(Returned via var_export)
