sorting and showing?

[deansmar]

Hi Folks

 

i now its in here somewere and i have been looking for it for most of today

 

can anyone point me in the right direction??

 

i would like to:

 

1. sort the customers by create and only show the newest 10

 

2. sort the orders in other words show only the pending and Processing (not the dispatched)

 

this would look a little like the new version 3 admin Index but for version 2.2rc2a

 

as i have the Mod 4543 (admin_horizontal_navigation) installed and its fantastic but it shows all orders and customers (in pages)

 

thanks for any help

[deansmar]

Hi,

 

just to let you all know that one of the Problems have been solved through changing the

 

file: /catalog/admin/index.php

 

(this is the Moded Index.php from Addon Mod-4543-admin_horizontal_navigation)

 

There are 6 instances of MAX_DISPLAY_SEARCH_RESULTS:

 

this i have changed to '10' and now i only get 10 shown in Orders and Customers on the Index Page:

 

changed from:

<td class="smallText" valign="top"><?php echo $orders_split->display_count($orders_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $HTTP_GET_VARS['page'], TEXT_DISPLAY_NUMBER_OF_ORDERS); ?></td>

 

to:

<td class="smallText" valign="top"><?php echo $orders_split->display_count($orders_query_numrows, '10', $HTTP_GET_VARS['page'], TEXT_DISPLAY_NUMBER_OF_ORDERS); ?></td>

 

 

hope this helps others that are useing this Mod

[deansmar]

i have managed to sort out Problem 1. compleatly, hop this might help others... so heres the answer

 

which customers list "php" are you using?? the one that came with OSC or the one from the contribution Mod No.3463 "Customers List Improved"

 

if you are using the normal built in one that came with OSC then the Contribution:

Mod-2940-Customers_By_Date_OSC_Contrib

 

should help you

 

if you are using the Mod 3463 then there is a little bit of PHP to do:

 

in catolog/admin/customers.php

on or around line 790

change:

if(!$sort) $sort = 'ASC';

to:

if(!$sort) $sort = 'DESC';

 

on or around line 800

change:

$customers_query_raw = "select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, c.customers_telephone, c.customers_dob, ci.customers_info_date_of_last_logon as last_logon, ci.customers_info_number_of_logons as num_logons, ci.customers_info_date_account_created as date_account_created, a.entry_city as city, a.entry_state as state_alt, z.zone_name as state, ctry.countries_iso_code_2 as country, c.customers_newsletter, a.entry_country_id from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id left join " . TABLE_CUSTOMERS_INFO . " ci on c.customers_id = ci.customers_info_id left join " . TABLE_COUNTRIES . " ctry on a.entry_country_id = ctry.countries_id left join " . TABLE_ZONES . " z on a.entry_zone_id = z.zone_id " . $search . " order by " . $db_orderby . " " . $sort;

To:

$customers_query_raw = "select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, c.customers_telephone, c.customers_dob, ci.customers_info_date_of_last_logon as last_logon, ci.customers_info_number_of_logons as num_logons, ci.customers_info_date_account_created as date_account_created, a.entry_city as city, a.entry_state as state_alt, z.zone_name as state, ctry.countries_iso_code_2 as country, c.customers_newsletter, a.entry_country_id from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id left join " . TABLE_CUSTOMERS_INFO . " ci on c.customers_id = ci.customers_info_id left join " . TABLE_COUNTRIES . " ctry on a.entry_country_id = ctry.countries_id left join " . TABLE_ZONES . " z on a.entry_zone_id = z.zone_id " . $search . " order by " . $db_orderby = 'date_account_created ' . $sort . ', c.customers_lastname';