[Phpgroupware-cvs] property/inc/class.solookup.inc.php, 1.3

[nomail]

Update of /property/inc
Modified Files:
        Branch: 
          class.solookup.inc.php

date: 2004/10/23 22:11:00;  author: sigurdne;  state: Exp;  lines: +4 -4

Log Message:
no message
=====================================================================
Index: property/inc/class.solookup.inc.php
diff -u property/inc/class.solookup.inc.php:1.2 
property/inc/class.solookup.inc.php:1.3
--- property/inc/class.solookup.inc.php:1.2     Wed Jun  2 18:54:28 2004
+++ property/inc/class.solookup.inc.php Sat Oct 23 22:11:00 2004
@@ -58,7 +58,7 @@
                        }
                        else
                        {
-                               $ordermethod = ' order by org_name DESC';
+                               $ordermethod = ' order by last_name DESC';
                        }
 
 
@@ -78,7 +78,7 @@
                                $querymethod = " $where (id LIKE '%$query%' or 
org_name LIKE '%$query%')";
                        }
 
-                       $sql = "SELECT id,org_name FROM phpgw_addressbook 
$filtermethod $querymethod";
+                       $sql = "SELECT person_id,first_name,last_name FROM 
phpgw_contact_person $filtermethod $querymethod";
 
                        $this->db2->query($sql,__LINE__,__FILE__);
                        $this->total_records = $this->db2->num_rows();
@@ -88,8 +88,8 @@
                        {
                                $contact[] = array
                                (
-                                       'id'    => $this->db->f('id'),
-                                       'org_name'      => 
$this->db->f('org_name'),
+                                       'id'                    => 
$this->db->f('person_id'),
+                                       'contact_name'  => 
$this->db->f('last_name') . ', ' . $this->db->f('first_name'),
                                        );
                        }
 //_debug_array($vendor);