[Phpgroupware-cvs] property/inc/class.soagreement.inc.php, 1.3.2.8

[nomail]

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

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

Log Message:
Using ilike if pgsql
=====================================================================
Index: property/inc/class.soagreement.inc.php
diff -u property/inc/class.soagreement.inc.php:1.3.2.7 
property/inc/class.soagreement.inc.php:1.3.2.8
--- property/inc/class.soagreement.inc.php:1.3.2.7      Thu Nov 18 22:12:08 2004
+++ property/inc/class.soagreement.inc.php      Tue Dec  7 09:04:28 2004
@@ -39,6 +39,7 @@
 
                        $this->join                     = $this->bocommon->join;
                        $this->left_join        = $this->bocommon->left_join;
+                       $this->like                     = $this->bocommon->like;
 //                     $this->role             = 'agreement';
                }
 
@@ -257,7 +258,7 @@
 
                        if ($member_id>0)
                        {
-                               $filtermethod .= " $where fm_vendor.member_of 
LIKE '%,$member_id,%' ";
+                               $filtermethod .= " $where fm_vendor.member_of 
$this->like '%,$member_id,%' ";
                                $where= 'AND';
                        }
 
@@ -279,7 +280,7 @@
                                {
                                        if($this->db->f('datatype')=='V' || 
$this->db->f('datatype')=='email' || $this->db->f('datatype')=='CH')
                                        {
-                                               $querymethod[]= 
"$entity_table." . $this->db->f('column_name') . " LIKE '%$query%'";
+                                               $querymethod[]= 
"$entity_table." . $this->db->f('column_name') . " $this->like '%$query%'";
                                        }
                                        else
                                        {
@@ -479,7 +480,7 @@
 
                        if ($member_id>0)
                        {
-                               $filtermethod .= " $where fm_vendor.member_of 
LIKE '%,$member_id,%' ";
+                               $filtermethod .= " $where fm_vendor.member_of 
$this->like '%,$member_id,%' ";
                                $where= 'AND';
                        }
 
@@ -1036,7 +1037,7 @@
                                $query = ereg_replace("'",'',$query);
                                $query = ereg_replace('"','',$query);
 
-                               $querymethod = " $where 
($attribute_table.input_text LIKE '%$query%' or $attribute_table.column_name 
LIKE '%$query%')";
+                               $querymethod = " $where 
($attribute_table.input_text $this->like '%$query%' or 
$attribute_table.column_name $this->like '%$query%')";
                        }
 
                        $sql = "SELECT * FROM $attribute_table $filtermethod 
$querymethod";