Home
Customization
Products
Free Stuff
Templates
Support
Portfolio
Partners
Forum
Products     Magento Extension     PCI-Shopping-Carts     Templates       CRELoaded     WordPress Modules     osCommerce Modules       osCommerce Addons       osCommerce Features       osCommerce Management       Payment Modules     CRELoaded Modules       CRE Loaded Addons       CRE Loaded Features       CRE Loaded Management       Payment Modules       CRELoaded Services
Free Stuff
Customization
Templates
Compare Products
You have no items to compare.
Affiliate Info
Affiliate Program FAQ
Affiliate Log In
Recent Orders
Hot Keywords: Order Notification, Order Search, Coupon, Flash Board, Compare, Floating Message, Tracking, Moneris, RSS, Visitor Filter

  Admin Summary Info

    1 of 1494   Next >   Last >>  
The following osCommerce contribution is a free Opensource code originated from official osCommerce website and provided for your reference only, you may download the original contribution file(s) and install it on your own; or you may request a Paid Installation Service from Agents Of Power; Agents Of Power does the "AS IS" installation on your website, we do not guarantee it will work properly on your website. Extra Paid service is available for repairing the problem from the original contribution or from your website.
There was a problem with the order total summary, the field value in the table orders_total is shown the shop default value, not the foreign currency value.

That means the output, Total USD 1000.-, Total EUR 500.- was not true, in fact it is 1500.- USD.

So this new code is much smaller, and the annoying long output is now shorten to the default shop currency.

Change the whole order total summary section in admin/icludes/header.php to this:

// 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);

echo '<tr><td align="right" class="smallText">' . sprintf(TEXT_SUMMARY_INFO_ORDERS_TOTAL, $currencies->format($sum['sum']), $currencies->format($today_sum['sum'])) . '</td><td align="center" width="40"><a href="' . tep_href_link(FILENAME_STATS_SALES_REPORT, '', 'SSL') . '">' . tep_image(DIR_WS_IMAGES . 'icons/summary_totals.gif', HEADER_TITLE_SUPPORT_SITE) . '</a></td></tr>';
echo '</table></td>';

Thats it, have fun!

File contains only this bugfix.
Good idea in this contrib, but anybody may see the summary info in login page. I desided to show this info only after admin logon.

This is not a full package. Only modified header.php for version 1.1 by sugiartha is included.
   Posted on: 10/31/2008     See contribution details Request Installation with Paid service