X-Cart forums - Admin Sales Totals

Page 1 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)

Johnwiggity

12-07-2012 06:17 AM

Admin Sales Totals

1 Attachment(s)

On the Dashboard is it possible to show additional reports like yesterday, last week, last month, this year in the graphic?

Here's a screenshot of what it currently says.

totaltec

12-07-2012 08:01 AM

Re: Admin Sales Totals

There is a thread on this very subject...If I find it I'll point it out. But at least you know it is possible and the solution exists. Just need to find the needle in the haystack of this forum.

photo

12-07-2012 08:30 AM

Re: Admin Sales Totals

Quote:

Originally Posted by totaltec

There is a thread on this very subject...

This one? http://forum.x-cart.com/showthread.php?t=65186

Johnwiggity

12-07-2012 08:32 AM

Re: Admin Sales Totals

No. That's statistics and won't account for any orders other than processed.

totaltec

12-07-2012 09:29 AM

Re: Admin Sales Totals

Photo, that was the thread I had in mind. I thought it applied.

John, it looks relatively simple to do. Take a look at /admin/main.php

See line 57:

Code:

$start_dates[] = $previous_login_date;  // Since last login

$start_dates[] = func_prepare_search_date($curtime) - $config['Appearance']['timezone_offset']; // Today



$start_week = $curtime - date('w', $curtime) * 24 * 3600; // Week starts since Sunday



$start_dates[] = func_prepare_search_date($start_week) - $config['Appearance']['timezone_offset']; // Current week

$start_dates[] = mktime(0, 0, 0, date('m', $curtime), 1, date('Y', $curtime)) - $config['Appearance']['timezone_offset']; // Current month

These examples should give you what you need to setup your own searches. Just subtract from $curtime the number of seconds that you want to back.

Also take a look at the foreach statement

Code:

foreach($start_dates as $start_date) {

To see how the $start_dates array is treated, to better understand what is happening here.

Johnwiggity

12-07-2012 10:36 AM

Re: Admin Sales Totals

Thanks a lot I'll try it out.

Johnwiggity

12-08-2012 11:01 AM

Re: Admin Sales Totals

Still not really sure how to change the time period. A little confused on how to actually make that into a yesterday, last week, and last month.

totaltec

12-09-2012 09:37 AM

Re: Admin Sales Totals

Well, I would have to test it out and figure it out by trial and error myself.

1 week = 604800 seconds. I expect all of the values being processed by this script are in seconds.

This defines the current week, it simply adds another entry to the array $start_dates:
$start_dates[] = func_prepare_search_date($start_week) - $config['Appearance']['timezone_offset']; // Current week

You need to do the same. I would attempt first to simply use the equation above, and subtract 604800 seconds.

Why not:
$start_dates[] = func_prepare_search_date($start_week) - $config['Appearance']['timezone_offset'] - 604800; // Last week

Johnwiggity

12-10-2012 06:04 AM

Re: Admin Sales Totals

Thanks. That helps out and gives me an idea of how to mess with it.

minfinger

01-26-2013 01:25 PM

Re: Admin Sales Totals

Johnwiggity,

Did you ever figure out the line to put in the main.php to show the Year in the Admin Home?

All times are GMT -8. The time now is 07:33 AM.

Page 1 of 2

Show 40 posts from this thread on one page