X-Cart forums - Admin Sales Totals

Page 2 of 2

Show 40 posts from this thread on one page

X-Cart forums (https://forum.x-cart.com/index.php)

- Changing design (https://forum.x-cart.com/forumdisplay.php?f=51)

- - Admin Sales Totals (https://forum.x-cart.com/showthread.php?t=65591)

minfinger

01-26-2013 05:59 PM

Re: Admin Sales Totals

I was looking at some thing and using the existing formulas in the main.php will only get my the previous 365 days. I want, for example from Jan 1, 2012 to Dec 31, 2012. But the existing query in the main.php and the $start_date formulas only account for a start date and do not set a range or end date. Or rather the formula does set the range, but it sets it as the $curtime.

Existing formula:

Code:

$date_condition = "AND $sql_tbl[orders].date>='$start_date' AND $sql_tbl[orders].date<='$curtime'";

Any help?

Johnwiggity

01-28-2013 11:40 AM

Re: Admin Sales Totals

I never got it to work the way I wanted to.

minfinger

01-28-2013 12:22 PM

Re: Admin Sales Totals

I found another thread where a guy figured out how to do yesterday, last 7 and last 30. I'm not in the office eight now, but I'll look when I get back.

I think the best way is to have 2 types formulas working for to desperate sections. Unless I can figure out how to make the php set the end time through the code.

minfinger

01-28-2013 05:38 PM

Re: Admin Sales Totals

John,

I found the thread: http://forum.x-cart.com/showthread.php?t=49889

He talks about changing/adding this code to the main.php

Code:

$start_dates[] = mktime() - 24*3600

$start_dates[] = mktime() - 7*24*3600

$start_dates[] = mktime() - 30*24*3600

All times are GMT -8. The time now is 01:21 PM.

Page 2 of 2

Show 40 posts from this thread on one page