vtiger

[its4you]

We have created a new feature which show user's full name instead of user login (fields Assign To) in all Modules - Listviews, Detailviews .....

File:
/modules/CustomView/CustomView.php
in function getCvColumnListSQL () - arround line: 796
Code: //Added for for assigned to sorting
   if($list[1] == "smownerid")
   {
    // *** ITS4YOU 8.2.2008  - user name in the liste view
      // $sqllist_column = "case when (vtiger_users.user_name not like '') then vtiger_users.user_name else vtiger_groups.groupname end as user_name";
    $sqllist_column = "case when (vtiger_users.user_name not like '') then CONCAT_WS(' ', vtiger_users.first_name, vtiger_users.last_name) else vtiger_groups.groupname end as user_name";
   }

/include/utils/DetailViewUtils.php
Update functions getUserName to getUserFullName - arround lines: 188, 212
Code:       // *** ITS4YOU 8.2.2008
    // $user_name = getUserName($user_id);
      $user_name = getUserFullName($user_id);


/include/utils/utils.php
in function: get_user_array() - arround lines: 170, 176, 182
change user_name to CONCAT_WS(' ',first_name, last_name) as user_name in queries