X-Cart forums

[kmjperformance]

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...

[Shamun]

In the PHP you need to have the logic that gets the amount. It seems you have that, which is accessed by the function GetOrderCounts($CustLogin) where $CustLogin is an autopopulated variable.

If not, you will need something like this:

$TotalCustomer = GetOrderCounts($CustLogin);

Now the variable $TotalCustomer contains the amount. Next up, you need to pass that info to smarty via code similar to this:

$smarty->assign('varNameYouWantToUseInSmarty', $TotalCustomer);

[kmjperformance]

So, do I put the $smarty->assign() code in the "include/func/func.db.php" file, or in the smarty template, or do I put it in some other file?

[amy2203]

in the php file

its what makes smarty see the variable,

hth

[kmjperformance]

Got it!

Thanks everyone!

I'll be using this a lot. Once I get something I feel is useful, I'll post the code on here.

Thanks again!

[amy2203]

sounds like a good mod, love to see it completed!