[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Fmsystem-commits] [11111] property - sync with boei
From: |
Sigurd Nes |
Subject: |
[Fmsystem-commits] [11111] property - sync with boei |
Date: |
Thu, 16 May 2013 07:33:32 +0000 |
Revision: 11111
http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=11111
Author: sigurdne
Date: 2013-05-16 07:33:30 +0000 (Thu, 16 May 2013)
Log Message:
-----------
property - sync with boei
Modified Paths:
--------------
trunk/property/inc/cron/default/synkroniser_med_boei.php
Modified: trunk/property/inc/cron/default/synkroniser_med_boei.php
===================================================================
--- trunk/property/inc/cron/default/synkroniser_med_boei.php 2013-05-15
14:10:36 UTC (rev 11110)
+++ trunk/property/inc/cron/default/synkroniser_med_boei.php 2013-05-16
07:33:30 UTC (rev 11111)
@@ -292,11 +292,13 @@
function legg_til_gateadresse_phpgw()
{
- $sql = "SELECT v_Gateadresse.gateadresse_id,
v_Gateadresse.gatenavn FROM fm_streetaddress RIGHT OUTER JOIN "
+ //legg til
+ $sql = "SELECT v_Gateadresse.gateadresse_id,
v_Gateadresse.gatenavn FROM fm_streetaddress RIGHT OUTER JOIN "
. " v_Gateadresse ON fm_streetaddress.id =
v_Gateadresse.gateadresse_id"
. " WHERE (fm_streetaddress.id IS
NULL)";
$this->db_boei->query($sql,__LINE__,__FILE__);
+ $gate = array();
while ($this->db_boei->next_record())
{
$gate[]= array (
@@ -325,6 +327,29 @@
$gate_msg[]=utf8_encode($gate[$i]['descr']);
}
+
+ //oppdater gatenavn - om det er endret
+
+ $sql = "SELECT v_Gateadresse.gateadresse_id,
v_Gateadresse.gatenavn FROM v_Gateadresse";
+
+ $this->db_boei->query($sql,__LINE__,__FILE__);
+ $gate = array();
+ while ($this->db_boei->next_record())
+ {
+ $gate[]= array
+ (
+ 'id' =>
$this->db_boei->f('gateadresse_id'),
+ 'descr' =>
$this->db_boei->f('gatenavn')
+ );
+ }
+
+ foreach ($gate as $gate_info)
+ {
+ $descr = utf8_encode($gate_info['descr']);
+ $sql_utf = "UPDATE fm_streetaddress SET descr =
'{$descr}' WHERE id = " . (int)$gate_info['id'];
+ $this->db->query($sql_utf,__LINE__,__FILE__);
+ }
+
$this->db->transaction_commit();
$this->db_boei->transaction_commit();
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Fmsystem-commits] [11111] property - sync with boei,
Sigurd Nes <=