Show Status of order in the NEW ORDERS table

still showing the "DELIVERED" code [4]

my complete code is

<?php // "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 and class = 'ot_total') order by orders_id DESC limit 5"

$orders = $db->Execute("select o.orders_id as orders_id, o.customers_id, o.customers_name as customers_name, o.payment_method, o.shipping_method, o.date_purchased as date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total" .
$new_fields . "
from (" . TABLE_ORDERS_STATUS . " s, " .
TABLE_ORDERS . " o " .
$new_table . ")
left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id and ot.class = 'ot_total') " . "
where o.orders_status = s.orders_status_id and s.language_id = '" . (int)$_SESSION['languages_id'] . "'
and o.orders_status < 5
order by orders_id DESC limit 5" );

while (!$orders->EOF) { echo ' <div class="row"><span class="left"><a href="' . zen_href_link(FILENAME_ORDERS, 'oID=' . $orders->fields['orders_id'] . '&origin=' . FILENAME_DEFAULT, 'NONSSL') . '" class="contentlink"> ' . $orders->fields['customers_name'] . '</a></span><span class="center">' . $orders->fields['order_total'] . ' - ' . $orders->fields['orders_status_name'] . '</span><span class="rigth">' . "\n"; echo zen_date_short($orders->fields['date_purchased']); echo ' </span></div>' . "\n"; $orders->MoveNext(); } ?>

got it,

I chaged
and o.orders_status < 5
order by orders_id DESC limit 5" );

to

and o.orders_status < 4
order by orders_id DESC limit 5" );

as the 4 is the DELIVERD number.
Thx so much..

hope this can help others looking to do the same.

Thanks for the update that you now have this working for you ... :smile:

Hello Ajeh,

This MOd for the NEW ORDERS in the admin is working great,
however it only shows 5 new orders at a time, and I have more than that to keep track of
until marked as delivered.

Where can I change the max display for that from 5 to say 50 so I do not have to worry about it again ?

Thx,
Erick

GOT it..


Folowed your posting back to admin/index.php
looked for "5" added a 0 and refreshed.. :-) crude but got it :-)

also made the new customer list to 20 from 5 :-)

Thx.. I'm learning :-)

Erick

Thanks for the update that you were able to change the number displayed ... :smile: