"New Orders" box in Admin Home view: Need mod please!

[StoryBook]

Hi.

When I login to my admin panel, or click admin home and go to the summery page, I see the "new orders" box on the right hand side.

What I would like to see happen is when an order has been updated to "shipped" (delivered) in customers->orders, I want the order to no longer show in the new orders box in the admin home view.

This will give me a quick view of outstanding orders.

Has this been done? Can it be done?

Thanks!

Kevin

[kuroi]

There's not a mod to do this, but you can do it yourself as follows. In the admin/index.php file replace the following (at about line 165)

  <?php  $orders = $db->Execute("select o.orders_id as orders_id, o.customers_name as customers_name, o.customers_id, o.date_purchased as date_purchased, o.currency, o.currency_value, ot.class, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id) where class = 'ot_total' order by orders_id DESC limit 5");

with this

  <?php  $orders = $db->Execute("select o.orders_id as orders_id, o.customers_name as customers_name, o.customers_id, o.date_purchased as date_purchased, o.currency, o.currency_value, o.orders_status, ot.class, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id) where class = 'ot_total' and orders_status != 3 order by orders_id DESC limit 5");

[StoryBook]

Perfect! Works like a charm.



Thanks for your help,
Kevin