Changeset 5172 for trunk/services/class.db.php

Timestamp:

11/11/11 16:42:49 (12 years ago)

Author:

wmerlotto

Message:

Ticket #2305 - Enviando alteracoes, desenvolvidas internamente na Prognus. Ultimas sincronizacoes...

File:

• trunk/services/class.db.php (modified) (2 diffs)

trunk/services/class.db.php

@@ -110 +110 @@
                                 $query .= ' where '
                                         . 'A.id_owner=' . $_SESSION['phpgw_info']['expressomail']['user']['account_id']
-                                        . ' and lower(to_ascii(names_ordered)) LIKE lower(to_ascii(\'%' . $search_for . '%\'))';                         
+                                        . ' and lower(translate(names_ordered, \'áàâãäéèêëíìïóòôõöúùûüÁÀÂÃÄÉÈÊËÍÌÏÓÒÔÕÖÚÙÛÜçÇñÑ\',\'aaaaaeeeeiiiooooouuuuAAAAAEEEEIIIOOOOOUUUUcCnN\'))'
+                                                                                . ' LIKE lower(translate(\'%' . $search_for . '%\', \'áàâãäéèêëíìïóòôõöúùûüÁÀÂÃÄÉÈÊËÍÌÏÓÒÔÕÖÚÙÛÜçÇñÑ\',\'aaaaaeeeeiiiooooouuuuAAAAAEEEEIIIOOOOOUUUUcCnN\'))';                    
                                 
         if (!$this->db->query($query))
@@ -251 +252 @@
         }
 
+        function search_groups($search_for)
+    { 
+        $result = array();
+                $query = 'select'
+                                                . ' G.oid,'
+                                                . ' G.title,'
+                                                . ' G.short_name';
+                $query .= ' from'
+                        . ' phpgw_cc_groups G';
+                $query .= ' where '
+                                                . ' G.owner=' . $_SESSION['phpgw_info']['expressomail']['user']['account_id']
+                                                . ' and lower(translate(G.title, \'áàâãäéèêëíìïóòôõöúùûüÁÀÂÃÄÉÈÊËÍÌÏÓÒÔÕÖÚÙÛÜçÇñÑ\',\'aaaaaeeeeiiiooooouuuuAAAAAEEEEIIIOOOOOUUUUcCnN\'))' 
+                                                . ' LIKE lower(translate(\'%' . $search_for . '%\', \'áàâãäéèêëíìïóòôõöúùûüÁÀÂÃÄÉÈÊËÍÌÏÓÒÔÕÖÚÙÛÜçÇñÑ\',\'aaaaaeeeeiiiooooouuuuAAAAAEEEEIIIOOOOOUUUUcCnN\'))';        
+                                                
+                if (!$this->db->query($query))
+             return null;
+         
+         while($this->db->next_record())
+            $result[] = $this->db->row();
+
+                $all_contacts = array(); 
+                foreach( $result as $i => $object )
+                {
+                        if ( ! array_key_exists( $object[ 'oid' ], $all_contacts ) )
+                                $all_contacts[ $object[ 'oid' ] ] = array(
+                                        'title' => '',
+                                        'short_name' => '',
+                                );
+                                $all_contacts[ $object[ 'oid' ] ]['title'] = $object['title'];
+                                $all_contacts[ $object[ 'oid' ] ]['short_name'] = $object['short_name'];
+                }
+                return array_values($all_contacts);
+        }
 }