[Fmsystem-commits] [11403] property: add address in search for tenant claim

[Sigurd Nes]

Revision: 11403
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=11403
Author:   sigurdne
Date:     2013-10-29 08:45:21 +0000 (Tue, 29 Oct 2013)
Log Message:
-----------
property: add address in search for tenant claim

Modified Paths:
--------------
    trunk/property/inc/class.sotenant_claim.inc.php

Modified: trunk/property/inc/class.sotenant_claim.inc.php
===================================================================
--- trunk/property/inc/class.sotenant_claim.inc.php     2013-10-28 09:53:06 UTC 
(rev 11402)
+++ trunk/property/inc/class.sotenant_claim.inc.php     2013-10-29 08:45:21 UTC 
(rev 11403)
@@ -111,7 +111,7 @@
                        {
                                $query = $this->db->db_addslashes($query);
 
-                               $querymethod = " $where ( first_name 
$this->like '%$query%' OR last_name $this->like '%$query%' OR project_id=" . 
(int)$query .')';
+                               $querymethod = " $where (address {$this->like} 
'%{$query}%' OR first_name {$this->like} '%{$query}%' OR last_name 
{$this->like} '%{$query}%' OR project_id=" . (int)$query .')';
                        }
 
                        $sql = "SELECT fm_tenant_claim.*, 
fm_tenant_claim_category.descr as claim_category, fm_tenant.last_name, 
fm_tenant.first_name,district_id,"
@@ -162,7 +162,7 @@
                function check_claim_project($project_id)
                {
                        $sql = "SELECT fm_tenant_claim.*, descr as category 
FROM fm_tenant_claim"
-                               . " $this->join fm_tenant_claim_category on 
fm_tenant_claim.category=fm_tenant_claim_category.id"
+                               . " {$this->join} fm_tenant_claim_category on 
fm_tenant_claim.category=fm_tenant_claim_category.id"
                                . " WHERE project_id = $project_id";
 
                        $this->db->query($sql,__LINE__,__FILE__);