[Gforge-commits] gforge/common/reporting report_utils.php,1.1,1.2

[kikov]

Update of /cvsroot/gforge/gforge/common/reporting
In directory db.perdue.net:/tmp/cvs-serv11017/common/reporting

Modified Files:
        report_utils.php 
Log Message:
[#862] Change behaviour of Click Letter to seek an user by lastname instead 
realname


Index: report_utils.php
===================================================================
RCS file: /cvsroot/gforge/gforge/common/reporting/report_utils.php,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- report_utils.php    28 Jul 2004 17:31:26 -0000      1.1
+++ report_utils.php    4 Aug 2004 01:15:44 -0000       1.2
@@ -97,26 +97,26 @@
 function report_useract_box($name='dev_id', $selected='1', $start_with='') {
 
        if ($start_with) {
-               $sql2=" AND realname ILIKE '$start_with%' ";
+               $sql2=" AND lastname ILIKE '$start_with%' ";
        }
 
        $res=db_query("SELECT user_id,realname 
                FROM users 
                WHERE status='A' $sql2 
-               AND (exists (SELECT user_id FROM rep_user_act_daily WHERE 
user_id=users.user_id)) ORDER BY realname");
+               AND (exists (SELECT user_id FROM rep_user_act_daily WHERE 
user_id=users.user_id)) ORDER BY lastname");
        return html_build_select_box($res, $name, $selected, false);
 }
 
 function report_usertime_box($name='dev_id', $selected='1', $start_with='') {
 
        if ($start_with) {
-               $sql2=" AND realname ILIKE '$start_with%' ";
+               $sql2=" AND lastname ILIKE '$start_with%' ";
        }
 
        $res=db_query("SELECT user_id,realname 
                FROM users 
                WHERE status='A' $sql2 
-               AND (exists (SELECT user_id FROM rep_time_tracking WHERE 
user_id=users.user_id)) ORDER BY realname");
+               AND (exists (SELECT user_id FROM rep_time_tracking WHERE 
user_id=users.user_id)) ORDER BY lastname");
        return html_build_select_box($res, $name, $selected, false);
 }