[Fmsystem-commits] [11984] property: alter datatype

[Sigurd Nes]

Revision: 11984
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=11984
Author:   sigurdne
Date:     2014-05-16 11:53:54 +0000 (Fri, 16 May 2014)
Log Message:
-----------
property: alter datatype

Modified Paths:
--------------
    
trunk/property/inc/cron/default/import_oppdatering_av_bestilling_fra_agresso_bkb.php

Modified: 
trunk/property/inc/cron/default/import_oppdatering_av_bestilling_fra_agresso_bkb.php
===================================================================
--- 
trunk/property/inc/cron/default/import_oppdatering_av_bestilling_fra_agresso_bkb.php
        2014-05-16 08:51:59 UTC (rev 11983)
+++ 
trunk/property/inc/cron/default/import_oppdatering_av_bestilling_fra_agresso_bkb.php
        2014-05-16 11:53:54 UTC (rev 11984)
@@ -261,7 +261,7 @@
                        }
 
                        //prosjektnummer;prosjektstatus;bestillingsnummer;beløp
-               $agresso_prosjekt       = (int)$data[0];
+               $agresso_prosjekt       = trim($data[0]);
                        $prosjektstatus         = trim($data[1]);
                        $order_id                       = trim($data[2]);
                        $diff_actual_cost       = (float)trim($data[3]);
@@ -302,7 +302,7 @@
 
                private function update_status($data)
                {
-               $agresso_prosjekt       = (int)$data[0];
+               $agresso_prosjekt       = trim($data[0]);
                        $prosjektstatus         = trim($data[1]);
                        $order_id                       = trim($data[2]);
 
@@ -321,7 +321,7 @@
                                return false;
                        }
 
-                       $this->db->query("UPDATE fm_tts_tickets SET 
agresso_prosjekt = $agresso_prosjekt WHERE id={$id}",__LINE__,__FILE__);
+                       $this->db->query("UPDATE fm_tts_tickets SET 
agresso_prosjekt = '{$agresso_prosjekt}' WHERE id={$id}",__LINE__,__FILE__);
 
                        $ok = true;
                        if(preg_match('/(^C|^P)/i', $prosjektstatus))