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

[Sigurd Nes]

CVSROOT:        /sources/phpgroupware
Module name:    property
Changes by:     Sigurd Nes <sigurdne>   07/03/23 12:05:42

Modified files:
        inc/cron       : synkroniser_med_boei.php 

Log message:
        update

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/property/inc/cron/synkroniser_med_boei.php?cvsroot=phpgroupware&r1=1.4&r2=1.5

Patches:
Index: synkroniser_med_boei.php
===================================================================
RCS file: /sources/phpgroupware/property/inc/cron/synkroniser_med_boei.php,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -b -r1.4 -r1.5
--- synkroniser_med_boei.php    18 Mar 2007 20:13:55 -0000      1.4
+++ synkroniser_med_boei.php    23 Mar 2007 12:05:41 -0000      1.5
@@ -24,7 +24,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.4 2007/03/18 20:13:55 
sigurdne Exp $
+       * @version $Id: synkroniser_med_boei.php,v 1.5 2007/03/23 12:05:41 
sigurdne Exp $
        */
 
        /**
@@ -625,8 +625,11 @@
                //      $this->db->transaction_begin();
                //      $this->db_boei->transaction_begin();
 
-                       for ($i=0; $i<count($leietaker); $i++)
+                       for ($i=0; $i<count($leietaker_latin); $i++)
                        {
+                               $this->db->query("DELETE FROM fm_tenant WHERE 
id=" . (int)$leietaker_latin[$i]['id'],__LINE__,__FILE__);
+                               $this->db_boei->query("DELETE FROM fm_tenant 
WHERE id=" . (int)$leietaker_latin[$i]['id'],__LINE__,__FILE__);
+
                                $sql2_utf = "INSERT INTO fm_tenant (id, 
first_name, last_name, category, status_eco, status_drift,entry_date,owner_id)"
                                        . "VALUES (" . 
$this->bocommon->validate_db_insert($leietaker_utf[$i]) . ")";
                                $sql2_latin = "INSERT INTO fm_tenant (id, 
first_name, last_name, category, status_eco, status_drift,entry_date,owner_id)"
@@ -641,7 +644,7 @@
                //      $this->db->transaction_commit();
                //      $this->db_boei->transaction_commit();
 
-                       $msg = count($leietaker) . ' Leietaker er lagt til: ' . 
@implode(",", $leietaker_msg);
+                       $msg = count($leietaker_latin) . ' Leietaker er lagt 
til: ' . @implode(",", $leietaker_msg);
                        $this->receipt['message'][]=array('msg'=> $msg);
                        unset ($leietaker);
                        unset ($leietaker_msg);
@@ -651,7 +654,6 @@
 
                function oppdater_leieobjekt()
                {
-
                        $sql = " SELECT TOP 100 PERCENT 
objekt_id,leie_id,leietaker_id, boareal, formaal_id, gateadresse_id, gatenr, 
etasje,driftsstatus_id"
                                . " FROM  v_Leieobjekt"; // WHERE 
v_Leieobjekt.formaal_id NOT IN (99)";