Default Sorting For Customer Listing

Quote

Post by shiokguy » Fri Sep 16, 2011 12:24 pm

Dear All

I am using 1.5.1.1

I would like to have Admin >Sales > Customers > Customers listing to have default of sort by date_added in DESC order, meaning when i click Admin > Sales > Customers > Customers, the first entry shall be the latest customer who has register.

Can you help to point to which file and what to change?

Many Thank in advance.

Regards
Mike aka ShiokGuy
shiokguy
New member
Posts
34
Joined
Wed Jul 13, 2011 3:28 pm
Top

Re: Default Sorting For Customer Listing

Quote

Post by uksitebuilder » Fri Sep 16, 2011 5:15 pm

admin/model/sale/customer.php

find

Code: Select all

		if (isset($data['sort']) && in_array($data['sort'], $sort_data)) {
			$sql .= " ORDER BY " . $data['sort'];	
		} else {
			$sql .= " ORDER BY name";	
		}
			
		if (isset($data['order']) && ($data['order'] == 'DESC')) {
			$sql .= " DESC";
		} else {
			$sql .= " ASC";
		}
change to

Code: Select all

		if (isset($data['sort']) && in_array($data['sort'], $sort_data)) {
			$sql .= " ORDER BY " . $data['sort'];	
		} else {
			$sql .= " ORDER BY date_added";	
		}
			
		if (isset($data['order']) && ($data['order'] == 'ASC')) {
			$sql .= " ASC";
		} else {
			$sql .= " DESC";
		}
User avatar
uksitebuilder
Guru Member
Posts
7716
Joined
Thu Jun 09, 2011 11:37 pm
Location - United Kindgom
Top

Re: Default Sorting For Customer Listing

Quote

Post by shiokguy » Fri Sep 16, 2011 8:57 pm

Dear Simon,

Thank you for helping me out. This is what I have changed

Code: Select all

		if (isset($data['sort']) && in_array($data['sort'], $sort_data)) {
			$sql .= " ORDER BY " . $data['sort'];	
		} else {
//			$sql .= " ORDER BY name"; Edit by Yong
			$sql .= " ORDER BY date_added";

		}
			
//		if (isset($data['order']) && ($data['order'] == 'DESC')) { Edit by Yong
		if (isset($data['order']) && ($data['order'] == 'ASC')) {
//		$sql .= " DESC"; Edit By Yong
		$sql .= " ASC";
		} else {
//			$sql .= " ASC"; Edit By Yong
			$sql .= " DESC";
			}
However when I click, Admin>Sales>Customers>Customers, the default sorting is still by customer name.

Regards
Mike
shiokguy
New member
Posts
34
Joined
Wed Jul 13, 2011 3:28 pm
Top

Re: Default Sorting For Customer Listing

Quote

Post by Ulf » Sat Apr 21, 2012 11:20 pm

Here is the code to sort Admin >Sales > Customers > Customers listing to have default of sort by date in DESC

admin/model/sale/customer.php

Code: Select all

if (isset($data['sort']) && in_array($data['sort'], $sort_data)) {
         $sql .= " ORDER BY " . $data['sort'];   
      } else {
         $sql .= " ORDER BY c.date_added";   
      }
         
      if (isset($data['order']) && ($data['order'] == 'ASC')) {
         $sql .= " ASC";
      } else {
         $sql .= " DESC";
      }
admin/controller/sale/customer.php

Code: Select all

if (isset($this->request->get['sort'])) {
			$sort = $this->request->get['sort'];
		} else {
			$sort = 'c.date_added'; 
		}
		
		if (isset($this->request->get['order'])) {
			$order = $this->request->get['order'];
		} else {
			$order = 'DESC';
		}
Ulf
New member
Posts
60
Joined
Sat Oct 16, 2010 4:41 pm
Top

Re: Default Sorting For Customer Listing

Quote

Post by rbuckthal » Thu Sep 19, 2013 3:37 am

It is far easier to set the default sort column and order where the default it detected.

/admin/controller/sale/customer.php

Find

Code: Select all

		if (isset($this->request->get['sort'])) {
			$sort = $this->request->get['sort'];
		} else {
			$sort = 'name';
Change last line to:

Code: Select all

$sort = 'c.date_added';
Find:

Code: Select all

		if (isset($this->request->get['order'])) {
			$order = $this->request->get['order'];
		} else {
			$order = 'ASC';
Change last line to:

Code: Select all

$order = 'DESC';
Easy peasy...
rbuckthal
Newbie
Posts
14
Joined
Tue Dec 09, 2008 2:38 am
Top

Re: Default Sorting For Customer Listing

Quote

Post by sunsys » Sat Jun 13, 2015 9:24 pm

rbuckthal wrote:It is far easier to set the default sort column and order where the default it detected.
Easy peasy...
@rbuckthal:

Thank you for your excellent advice, this works perfectly in OC-1564.

Regards,
Sun Systems
Industrial Electronics and Instrumentation

User avatar
sunsys
Active Member
Posts
204
Joined
Tue Jan 27, 2015 5:19 am
Top
Post Reply
Return to “General Support”
Who is online

Users browsing this forum: No registered users and 22 guests