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

[nomail]

Update of /property/inc
Modified Files:
        Branch: proposed-0_9_18-branch
          class.solookup.inc.php

date: 2004/12/07 09:04:28;  author: sigurdne;  state: Exp;  lines: +10 -10

Log Message:
Using ilike if pgsql
=====================================================================
Index: property/inc/class.solookup.inc.php
diff -u property/inc/class.solookup.inc.php:1.3.2.3 
property/inc/class.solookup.inc.php:1.3.2.4
--- property/inc/class.solookup.inc.php:1.3.2.3 Thu Nov 18 22:12:08 2004
+++ property/inc/class.solookup.inc.php Tue Dec  7 09:04:28 2004
@@ -38,7 +38,7 @@
                        $this->socommon         = 
CreateObject($this->currentapp.'.socommon');
 
                        $this->join                     = $this->socommon->join;
-
+                       $this->like                     = $this->socommon->like;
 
                }
 
@@ -76,7 +76,7 @@
 
                        if ($cat_id > 0)
                        {
-                               $filtermethod .= " $where cat_id LIKE 
'%,$cat_id,%' ";
+                               $filtermethod .= " $where cat_id $this->like 
'%,$cat_id,%' ";
                                $where= 'AND';
                        }
 
@@ -85,7 +85,7 @@
                                $query = ereg_replace("'",'',$query);
                                $query = ereg_replace('"','',$query);
 
-                               $querymethod = " $where (id LIKE '%$query%' or 
org_name LIKE '%$query%')";
+                               $querymethod = " $where (id $this->like 
'%$query%' or org_name $this->like '%$query%')";
                        }
 
                        $sql = "SELECT person_id,first_name,last_name FROM 
phpgw_contact_person $filtermethod $querymethod";
@@ -141,7 +141,7 @@
 
                        if ($cat_id > 0)
                        {
-                               $filtermethod .= " $where member_of LIKE 
'%,$cat_id,%' ";
+                               $filtermethod .= " $where member_of $this->like 
'%,$cat_id,%' ";
                                $where= 'AND';
                        }
 
@@ -150,7 +150,7 @@
                                $query = ereg_replace("'",'',$query);
                                $query = ereg_replace('"','',$query);
 
-                               $querymethod = " $where (id LIKE '%$query%' or 
org_name LIKE '%$query%')";
+                               $querymethod = " $where (id $this->like 
'%$query%' or org_name $this->like '%$query%')";
                        }
 
                        $sql = "SELECT id,org_name FROM fm_vendor $filtermethod 
$querymethod";
@@ -206,7 +206,7 @@
                                $query = ereg_replace("'",'',$query);
                                $query = ereg_replace('"','',$query);
 
-                               $querymethod = " where (id LIKE '%$query%' or 
descr LIKE '%$query%')";
+                               $querymethod = " where (id $this->like 
'%$query%' or descr $this->like '%$query%')";
                        }
 
                        $sql = "SELECT * FROM fm_b_account $querymethod  ";
@@ -261,7 +261,7 @@
                                $query = ereg_replace("'",'',$query);
                                $query = ereg_replace('"','',$query);
 
-                               $querymethod = " where ( descr LIKE 
'%$query%')";
+                               $querymethod = " where ( descr $this->like 
'%$query%')";
                        }
 
                        $sql = "SELECT * FROM fm_streetaddress $querymethod  ";
@@ -315,7 +315,7 @@
                                $query = ereg_replace("'",'',$query);
                                $query = ereg_replace('"','',$query);
 
-                               $querymethod = " where ( last_name LIKE 
'%$query%' or first_name LIKE '%$query%')";
+                               $querymethod = " where ( last_name $this->like 
'%$query%' or first_name $this->like '%$query%')";
                        }
 
                        $sql = "SELECT * FROM fm_tenant $querymethod  ";
@@ -370,7 +370,7 @@
                                $query = ereg_replace("'",'',$query);
                                $query = ereg_replace('"','',$query);
 
-                               $querymethod = " where ( tekst1 LIKE '%$query%' 
or tekst2 LIKE '%$query%' or tekst3 LIKE '%$query%' or tekst4 LIKE '%$query%' 
or tekst5 LIKE '%$query%' or tekst6 LIKE '%$query%')";
+                               $querymethod = " where ( tekst1 $this->like 
'%$query%' or tekst2 $this->like '%$query%' or tekst3 $this->like '%$query%' or 
tekst4 $this->like '%$query%' or tekst5 $this->like '%$query%' or tekst6 
$this->like '%$query%')";
                        }
 
                        $sql = "SELECT * FROM fm_ns3420  $querymethod  ";