Debug Line 181 $queryfindorders->where Orders found that need reminders i.e. Array
(
[0] => stdClass Object
(
[virtuemart_order_id] => 405
[email] => test2@gjcwebdesign.com
[user_realname] => Test Name
)
)
JDatabaseQueryElement Object
(
[name:protected] => WHERE
[elements:protected] => Array
(
[0] => `a`.`virtuemart_order_id`=405
)
[glue:protected] => AND
)
Array
(
[0] => stdClass Object
(
[id] => 2
[state] => 0
[virtuemart_order_id] => 405
[order_number] => 4XDR0404
[user_id] => 330
[user_name] => test2
[email] => test2@gjcwebdesign.com
[user_realname] => web
[user_city] => web
[user_country] => United Kingdom
[product_id] => 263
[product_name] => Polychrome Jasper
[product_image] => /images/stories/virtuemart/product/polychrome-jasper-polished-oval.jpg
[product_desc] =>
[catid] => 13
[catname] => Crystals Rocks Minerals
[manuid] => 0
[manuname] =>
[cost] => 19.99
[review] => Wonderful... bought as a gift for my wife... very pleased
[rating] => 5
[reminder] => 0
[helpful] => 0
[datestamp] => 2021-01-02 16:32:52
[lastdatesent] => 0000-00-00 00:00:00
[admin_comment] =>
[send_email] => 1
[order_status] => C
[order_language] => en-GB
[modified] => 2018-07-20 18:53:52
)
[1] => stdClass Object
(
[id] => 3
[state] => 0
[virtuemart_order_id] => 405
[order_number] => 4XDR0404
[user_id] => 330
[user_name] => test2
[email] => test2@gjcwebdesign.com
[user_realname] => web
[user_city] => web
[user_country] => United Kingdom
[product_id] => 515
[product_name] => test
[product_image] => /images/stories/virtuemart/product/polychrome-jasper-polished-oval.jpg
[product_desc] =>
[catid] => 0
[catname] =>
[manuid] => 0
[manuname] =>
[cost] => 0.01
[review] =>
[rating] => 0
[reminder] => 0
[helpful] => 0
[datestamp] => 2021-01-02 16:32:52
[lastdatesent] => 0000-00-00 00:00:00
[admin_comment] =>
[send_email] => 1
[order_status] => C
[order_language] => en-GB
[modified] => 2018-07-20 18:53:52
)
)
https://www.stonemania.co.uk en-GB Dear {name}, https://www.stonemania.co.uk/index.php?option=com_vmreview&view=orderrev1ewsform&enter_email=test2@gjcwebdesign.com&enter_ordernumber=4XDR0404 Stone Mania - Leave A Review Review reminder from : Stone Mania Stone Mania - Leave A Review Dear Test Name,Stone Mania - Leave A Review Stone Mania - Opt out from these reminders 1 Array
(
[0] => test2@gjcwebdesign.com | Test Name | 4XDR0404 | 1: Polychrome Jasper 2: test | Reminder: 1 | Status C Date: 2018-07-20 18:53:52
)
Crystals Rocks Minerals from Around the World
Sort by
Sorted Product Name
Product Name
Product SKU
Category
Ordering
Product Code: LBVL
COM_VIRTUEMART_PRODUCT_SALESPRICE2 £24.50
Product Code: SAAX
COM_VIRTUEMART_PRODUCT_SALESPRICE2 £88.00
Product Code: AMHB
COM_VIRTUEMART_PRODUCT_SALESPRICE2 £68.99
Product Code: AMAY
COM_VIRTUEMART_PRODUCT_SALESPRICE2 £71.10
Product Code: GLQZ
COM_VIRTUEMART_PRODUCT_SALESPRICE2 £161.00
Product Code: BCRC
COM_VIRTUEMART_PRODUCT_SALESPRICE2 £0.48
Product Code: FTHB
COM_VIRTUEMART_PRODUCT_SALESPRICE2 £14.99
Product Code: BRCR
COM_VIRTUEMART_PRODUCT_SALESPRICE2 £1.20
Product Code: CCCZ
COM_VIRTUEMART_PRODUCT_SALESPRICE2 £23.99
Product Code: GKKG
COM_VIRTUEMART_PRODUCT_SALESPRICE2 £18.99
Product Code: XEYO
COM_VIRTUEMART_PRODUCT_SALESPRICE2 £17.99
Product Code: FTOK
COM_VIRTUEMART_PRODUCT_SALESPRICE2 £13.35
Product Code: PPTV
COM_VIRTUEMART_PRODUCT_SALESPRICE2 £23.50
Product Code: IPYN
COM_VIRTUEMART_PRODUCT_SALESPRICE2 £24.75
Product Code: FLXT1
COM_VIRTUEMART_PRODUCT_SALESPRICE2 £16.99
Product Code: FLXT
COM_VIRTUEMART_PRODUCT_SALESPRICE2 £14.99
Product Code: RXXZ
COM_VIRTUEMART_PRODUCT_SALESPRICE2 £6.99
Product Code: ASYU
COM_VIRTUEMART_PRODUCT_SALESPRICE2 £382.00
Product Code: OFPK
COM_VIRTUEMART_PRODUCT_SALESPRICE2 £12.99
Product Code: LIRP
COM_VIRTUEMART_PRODUCT_SALESPRICE2 £38.50
Product Code: TSPT
COM_VIRTUEMART_PRODUCT_SALESPRICE2 £10.20
Product Code: BPOT
COM_VIRTUEMART_PRODUCT_SALESPRICE2 £18.99
Product Code: TNRS
COM_VIRTUEMART_PRODUCT_SALESPRICE2 £7.99
Product Code: BCOB
COM_VIRTUEMART_PRODUCT_SALESPRICE2 £42.99
Have a Question? Chat with Us.
Start Chat with
