[Phpgroupware-cvs] property/inc/class.solocation.inc.php, 1.2.2.5

[nomail]

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

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

Log Message:
Using ilike if pgsql
=====================================================================
Index: property/inc/class.solocation.inc.php
diff -u property/inc/class.solocation.inc.php:1.2.2.4 
property/inc/class.solocation.inc.php:1.2.2.5
--- property/inc/class.solocation.inc.php:1.2.2.4       Thu Nov 18 22:12:08 2004
+++ property/inc/class.solocation.inc.php       Tue Dec  7 09:04:28 2004
@@ -41,6 +41,7 @@
 
                        $this->join                     = $this->socommon->join;
                        $this->left_join        = $this->socommon->left_join;
+                       $this->like                     = $this->socommon->like;
                }
 
                function read_entity_to_link()
@@ -467,15 +468,15 @@
 
                                        if($sub_query_tenant)
                                        {
-                                               $sub_query = "OR 
fm_tenant.last_name LIKE '%$query%' OR fm_tenant.first_name LIKE '%$query%' OR 
fm_tenant.contact_phone LIKE '%$query%'";
+                                               $sub_query = "OR 
fm_tenant.last_name $this->like '%$query%' OR fm_tenant.first_name $this->like 
'%$query%' OR fm_tenant.contact_phone $this->like '%$query%'";
                                        }
 
                                        if($sub_query_street)
                                        {
-                                               $sub_query .= "OR 
fm_streetaddress.descr LIKE '%$query%'";
+                                               $sub_query .= "OR 
fm_streetaddress.descr $this->like '%$query%'";
                                        }
 
-                                       $querymethod = " $where (fm_location" . 
($type_id).".loc1 LIKE '%$query%' $sub_query OR fm_location" . 
($type_id).".location_code LIKE '%$query%' OR loc" . ($type_id)."_name LIKE 
'%$query%')";
+                                       $querymethod = " $where (fm_location" . 
($type_id).".loc1 $this->like '%$query%' $sub_query OR fm_location" . 
($type_id).".location_code $this->like '%$query%' OR loc" . ($type_id)."_name 
$this->like '%$query%')";
                                }
                                $where= 'AND';
                        }