Clients Listing

From PhpCOIN Documentation

The clients listing can be viewed only by a logged-in admin. It allows you to see a listing of all your clients in one place.

You can specify how may clients should be listed per page via Admin -> Parameters -> common -> clients -> Listing Items Per Page for: Clients

You can also specify the "two-out-of-three" columns that you wish displayed when viewing a list of clients. The two-out-of-three are Full Name and Email Address OR Full Name and Logon Name OR Logon Name and Email Address. The option is chosen via Admin -> Parameters -> common -> clients -> Optional Data Display for Listing

The default listing sort is by Last Name then First Name in ASCending order. You can edit the source code to change what the sort is, as well as the order. In file /coin_modules/clients/clients_admin.php find the function do_select_listing_clients(). Within that function is the following code block:

# Set Order ASC / DESC part of sort
	IF (!$adata['so'])		{$adata['so'] = 'A';}
	IF ($adata['so'] == 'A')	{$order_AD = ' ASC';}
	IF ($adata['so'] == 'D')	{$order_AD = ' DESC';}

Set the first line to A or D, depending on whether you want ASCending or DESCending sort

Immediately below that block is:

# Set Sort orders
IF (!$adata['sb'])		{$adata['sb'] = '4';}
IF ($adata['sb'] == '1') {$_order = ' ORDER BY '.$_DBCFG['clients'].'.cl_id'.$order_AD;}
IF ($adata['sb'] == '2') {$_order = ' ORDER BY '$_DBCFG['clients']. 
'.cl_status'.$order_AD;}
IF ($adata['sb'] == '3') {$_order = ' ORDER BY '.$_DBCFG['clients']. 
'.cl_join_ts'.$order_AD;}
IF ($adata['sb'] == '4') {$_order = ' ORDER BY '.$_DBCFG['clients'].  
'.cl_name_last'.$order_AD.', '.$_DBCFG['clients'].".cl_name_first".$order_AD;}
IF ($adata['sb'] == '5') {$_order = ' ORDER BY '.$_DBCFG['clients']. 
'.cl_user_name'.$order_AD;}

Set the first line to the number of the ORDER BY fields that you want.