View Single Post
  #1  
Old 10-30-2010, 08:20 AM
 
kmjperformance kmjperformance is offline
 

Advanced Member
  
Join Date: Jul 2008
Location: Iowa
Posts: 42
 

Question 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
Reply With Quote