[Phpgroupware-cvs] property/inc/custom synkroniser_med_boei.php

[Sigurd Nes]

CVSROOT:        /sources/phpgroupware
Module name:    property
Changes by:     Sigurd Nes <sigurdne>   07/01/16 14:26:56

Modified files:
        inc/custom     : synkroniser_med_boei.php 

Log message:
        update owner categories from master

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/property/inc/custom/synkroniser_med_boei.php?cvsroot=phpgroupware&r1=1.7&r2=1.8

Patches:
Index: synkroniser_med_boei.php
===================================================================
RCS file: /sources/phpgroupware/property/inc/custom/synkroniser_med_boei.php,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -b -r1.7 -r1.8
--- synkroniser_med_boei.php    16 Jan 2007 13:23:12 -0000      1.7
+++ synkroniser_med_boei.php    16 Jan 2007 14:26:56 -0000      1.8
@@ -8,7 +8,7 @@
        * @internal Development of this application was funded by 
http://www.bergen.kommune.no/bbb_/ekstern/
        * @package property
        * @subpackage custom
-       * @version $Id: synkroniser_med_boei.php,v 1.7 2007/01/16 13:23:12 
sigurdne Exp $
+       * @version $Id: synkroniser_med_boei.php,v 1.8 2007/01/16 14:26:56 
sigurdne Exp $
        */
 
        /**
@@ -169,6 +169,39 @@
 
                function legg_til_eier_phpgw()
                {
+                       $sql = " SELECT TOP 100 PERCENT v_Eier.id, 
v_Eier.category"
+                               . " FROM  v_Eier";
+
+                       $this->db_boei->query($sql,__LINE__,__FILE__);
+                       while ($this->db_boei->next_record())
+                       {
+                               if($this->db_boei->f('category')==0)
+                               {
+                                       $category = 4;
+                               }
+                               else
+                               {
+                                       $category = 
$this->db_boei->f('category');
+                               }
+                               $owner[]= array (
+                                'id'           => $this->db_boei->f('id'),
+                                'category'     => $category,
+                                );                     
+                       }
+                       
+                       $this->db->transaction_begin();
+                       $this->db_boei->transaction_begin();
+
+                       for ($i=0; $i<count($owner); $i++)
+                       {
+                               $sql2 = "UPDATE fm_owner set category = 
'{$owner[$i]['category']}' WHERE id = '{$owner[$i]['id']}'";
+
+                               $this->db->query($sql2,__LINE__,__FILE__);
+                               $this->db_boei->query($sql2,__LINE__,__FILE__);
+                       }
+
+                       unset($owner);
+
                        $sql = "SELECT v_Eier.id, 
v_Eier.org_name,v_Eier.category FROM  fm_owner RIGHT OUTER JOIN "
                                . " v_Eier ON fm_owner.id = v_Eier.id"
                                        . " WHERE (fm_owner.id IS NULL)";
@@ -583,7 +616,7 @@
                                . " WHERE  loc1 = '" . 
$this->db_boei->f('objekt_id') . "'";
 
 
-//_debug_array($sql2);
+_debug_array($sql2);
                                $this->db->query($sql2,__LINE__,__FILE__);
                                $this->db_boei2->query($sql2,__LINE__,__FILE__);
                                $i++;