[Phpgroupware-cvs] property/inc/class.sogab.inc.php, 1.4

[nomail]

Update of /property/inc
Modified Files:
        Branch: 
          class.sogab.inc.php

date: 2004/10/09 11:56:12;  author: sigurdne;  state: Exp;  lines: +11 -1

Log Message:
no message
=====================================================================
Index: property/inc/class.sogab.inc.php
diff -u property/inc/class.sogab.inc.php:1.3 
property/inc/class.sogab.inc.php:1.4
--- property/inc/class.sogab.inc.php:1.3        Fri Oct  8 13:43:44 2004
+++ property/inc/class.sogab.inc.php    Sat Oct  9 11:56:12 2004
@@ -107,7 +107,17 @@
                                $where = 'AND';
                        }
 
-                       $sql = "SELECT gab_id,count(gab_id) as hits, loc1_name 
as address, fm_gab_location.owner as owner FROM fm_gab_location $this->join 
fm_location1 on fm_gab_location.loc1=fm_location1.loc1 $filtermethod GROUP BY 
gab_id,loc1_name,owner ";
+
+                       $j = $this->gab_insert_level;
+                       $joinmethod .= " $this->join fm_location". ($j);
+                       $on = 'ON';
+                       for ($i=($j); $i>0; $i--)
+                       {
+                               $joinmethod .= " $on (fm_gab_location.loc" . 
($i). " = fm_location" . ($j) . ".loc" . ($i) . ")";
+                               $on = 'AND';
+                       }
+
+                       $sql = "SELECT gab_id,count(gab_id) as hits, loc" . $j 
. "_name as address, fm_gab_location.owner as owner FROM fm_gab_location 
$joinmethod $filtermethod GROUP BY gab_id,address,owner ";
 
                        $this->db2->query($sql,__LINE__,__FILE__);
                        $this->total_records = $this->db2->num_rows();