Community Add-Ons

Made changes to the "statistics.php" file to format the statistics content to make it consistent with the style of the administration index page eg. with row over effect, same font face and table style, etc.

Now fixed to include the correct order total, currency is used and also added total orders for the day.

This code was took from some header addon I had integrated a long time ago.

Either install as further down below or optionally add this code to your admin/includes/column_left

<tr><td>
<?php echo '<font color="#000000">Statistics</font><br />'; ?>

<?php
// order total summary
if(!is_object($currencies)){include_once(DIR_WS_CLASSES . 'currencies.php'); $currencies = new currencies();}
$sum_query = tep_db_query("select sum(ot.value) as sum from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id) where ot.class = 'ot_total'");
$sum = tep_db_fetch_array($sum_query);

$today_sum_query = tep_db_query("select sum(ot.value) as sum from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id) where to_days(o.date_purchased) = to_days(now()) and ot.class = 'ot_total'");
$today_sum = tep_db_fetch_array($today_sum_query);

$orders_query = tep_db_query("select class, SUM(value) from " . TABLE_ORDERS_TOTAL . " where class = '" . 'ot_total' . "'");
$orders = tep_db_fetch_array($orders_query);

$musteri_adeti = mysql_num_rows(tep_db_query("select * from " . TABLE_CUSTOMERS . ""));
$toplam_siparis_adeti = mysql_num_rows(tep_db_query("select * from " . TABLE_ORDERS . ""));
$toplam_urun_adeti = mysql_num_rows(tep_db_query("select * from " . TABLE_PRODUCTS . ""));
$toplam_yorum_adeti = mysql_num_rows(tep_db_query("select * from " . TABLE_REVIEWS . ""));

echo '<font color="#000000" style="font-family:Arial" style="font-weight:bold" size="1px">Total Sales: </font>' . '<font color="#FF0000" style="font-family:Arial" size="1px">' . $currencies->format($sum['sum'])
. '<br><font color="#000000" style="font-family:Arial" style="font-weight:bold" size="1px">Total Sales Today: </font>' . $currencies->format($today_sum['sum'])
. '<br><font color="#000000" style="font-family:Arial" style="font-weight:bold" size="1px">Total Customers: </font>' . $musteri_adeti
. '<br><font color="#000000" style="font-family:Arial" style="font-weight:bold" size="1px">Total Orders : </font>' . $toplam_siparis_adeti
. '<br><font color="#000000" style="font-family:Arial" style="font-weight:bold" size="1px">Total Products: </font>' . $toplam_urun_adeti
. '<br><font color="#000000" style="font-family:Arial" style="font-weight:bold" size="1px">Total Reviews: </font>' . $toplam_yorum_adeti ;


?>
</td></tr>

This is a full package. Only translated to English

Some small statistics for the admin splash page like below:
total sales, total customers qty, total order qty, total review qty, total product qty etc.
Installation takes only 10 seconds.