X-Cart forums

[Johnwiggity]

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]

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]

Originally Posted by totaltec

There is a thread on this very subject...

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

[Johnwiggity]

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

[totaltec]

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:

$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

 foreach($start_dates as $start_date) {

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

[Johnwiggity]

Thanks a lot I'll try it out.

[Johnwiggity]

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]

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]

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

[minfinger]

Johnwiggity,

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