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

[nomail]

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

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

Log Message:
Using ilike if pgsql
=====================================================================
Index: property/inc/class.soworkorder.inc.php
diff -u property/inc/class.soworkorder.inc.php:1.3.2.3 
property/inc/class.soworkorder.inc.php:1.3.2.4
--- property/inc/class.soworkorder.inc.php:1.3.2.3      Thu Nov 18 22:12:08 2004
+++ property/inc/class.soworkorder.inc.php      Tue Dec  7 09:04:28 2004
@@ -38,6 +38,7 @@
 
                        $this->join                     = $this->bocommon->join;
                        $this->left_join        = $this->bocommon->left_join;
+                       $this->like                     = $this->bocommon->like;
                        $this->grants           = 
$GLOBALS['phpgw']->session->appsession('grants_project',$this->currentapp);
 
                        if(!$this->grants)
@@ -313,7 +314,7 @@
                                        $query = ereg_replace("'",'',$query);
                                        $query = ereg_replace('"','',$query);
 
-                                       $querymethod = " $where 
(fm_workorder.title LIKE '%$query%' or fm_workorder.descr LIKE '%$query%' or 
fm_project.address LIKE '%$query%' or fm_project.location_code LIKE '%$query%' 
or fm_workorder.id LIKE '%$query%')";
+                                       $querymethod = " $where 
(fm_workorder.title $this->like '%$query%' or fm_workorder.descr $this->like 
'%$query%' or fm_project.address $this->like '%$query%' or 
fm_project.location_code $this->like '%$query%' or fm_workorder.id $this->like 
'%$query%')";
                                }
                                $where= 'AND';
 
@@ -327,7 +328,7 @@
                                }
                                else
                                {
-                                       $querymethod_vendor = " $where  
fm_vendor.org_name LIKE '%$search_vendor%'";
+                                       $querymethod_vendor = " $where  
fm_vendor.org_name $this->like '%$search_vendor%'";
                                }
                        }