Add "Customer Orders Totals" to Customer Profile Page
If something like this has been covered, I apologize, I searched and didn't find anything...
I'm looking for a way to add a field visible only to non-customers that shows the total number of Processed, Failed, etc... orders the customer has placed with us.
I know the SQL and I already added a function to the include/func/func.db.php file that calculates these (GetOrderCounts($CustLogin)). It returns the total count of the different types of orders.
However I can't figure out how to display this on the page!
Really scratching my head here.
Thanks in advance!
P.S. If I get this to work, I'm planning on adding a customer total YTD $, MTD $, etc...
__________________
X-Cart 4.4.5
PHP 5.3.14-1
MySQL 5.0.51
Linux + Apache
Mods:
AlteredCart SmartSearch w/ AJAX Predictive Search w/ Extras Add-On v2, BuyTogether, Checkout One, OnSale
********* PowerFilter
WebsiteCM CDSEOPro
Phpmagicscripts Reviews-Controller
CFL Systems Products Page Layout, System Messages mod
Custom work by CFLSystems
Custom work by us
|