From: Joe Hunt <joe.hunt.consulting@gmail.com>
Date: Sun, 14 Apr 2019 21:30:50 +0000 (+0200)
Subject: user_list_cells Real name shows empty when not entered in user table. @kvvaradha.
X-Git-Url: https://delta.frontaccounting.com/gitweb/?p=fa-stable.git;a=commitdiff_plain;h=d32bf132413c22c5a19966160fcd574346f63b24

user_list_cells Real name shows empty when not entered in user table. @kvvaradha.
---

diff --git a/includes/ui/ui_lists.inc b/includes/ui/ui_lists.inc
index c70343af..8e4da29d 100644
--- a/includes/ui/ui_lists.inc
+++ b/includes/ui/ui_lists.inc
@@ -2691,7 +2691,7 @@ function accounts_type_list_row($label, $name, $selected_id=null)
 function users_list_cells($label, $name, $selected_id=null, $submit_on_change=false, $spec_opt=true)
 {
     $where = false;
-    $sql = " SELECT user_id, real_name FROM ".TB_PREF."users";
+	$sql = " SELECT user_id, IF(real_name = ' ', user_id, real_name) FROM ".TB_PREF."users";
 
     if ($label != null)
         echo "<td>$label</td>\n";