vtiger

[opto]

Currently, vtiger 503 displays names as: lastname firstname.
A better option might be:
lastname, firstname
(for double names or foreign names, it is clearer where the firstname begins).

We preferred the order
firstname lastname.

If anybody is interested, to get this, change: \vtigercrm (root)\include\utils\Commanutil.php


The comment (//) is the vtiger setting, the following line the replacement


/**
* Function to get the Contact Name when a contact id is given
* Takes the input as $contact_id - contact id
* returns the Contact Name in string format.
*/

function getContactName($contact_id)
{
global $log;
$log->debug("Entering getContactName(".$contact_id.") method ...");
$log->info("in getContactName ".$contact_id);

global $adb;
$contact_name = '';
if($contact_id != '')
{
$sql = "select * from vtiger_contactdetails where contactid=".$contact_id;
$result = $adb->query($sql);
$firstname = $adb->query_result($result,0,"firstname");
$lastname = $adb->query_result($result,0,"lastname");
// $contact_name = $lastname.' '.$firstname;
$contact_name = $firstname.' '.$lastname;
}
$log->debug("Exiting getContactName method ...");
return $contact_name;
}

maybe this helps someone,

Klaus

[fixedamage]

I was not able to get this to work. I have replaced my text just as you have it and nothing has changed. What I really want is "Lastname, Firstname" but I can't get that to work either. Any suggestions?

[billdeng]

Thank you very much. I have changed my system as your direction.

I have tried to fix it by my self but I couldn't find out where the function getContactName is.

Thank you.

[razter]

I would like to keep it Lastname Firstname, but I would like Firstname to also go in alphabetical order.

For example,

Smith, Joe
Smith, Sally
Smith, Zoe

Right now it only puts Lastname in alphabetical order.
Lastname should be ascending (and it is) and then Firstname should be ascending.

Do you know how to make this change?

[pratim]

The following link will help you

http://forums.vtiger.com/viewtopic.php?t=20664