[Phpgroupware-cvs] CVS: property/inc class.soXport.inc.php,1.4,1.5

[Sigurd Nes <address@hidden>]

Update of /cvsroot/phpgroupware/property/inc
In directory subversions:/tmp/cvs-serv5712/inc

Modified Files:
        class.soXport.inc.php 
Log Message:
no message

Index: class.soXport.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/property/inc/class.soXport.inc.php,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -r1.4 -r1.5
*** class.soXport.inc.php       29 Oct 2002 16:45:34 -0000      1.4
--- class.soXport.inc.php       11 Nov 2002 19:35:17 -0000      1.5
***************
*** 133,136 ****
--- 133,144 ----
                }
  
+               function check_spbudact_code($account_id)
+               {
+ 
+                       $this->db->query("select count(*) from fm_wo_accounts 
where account_id='$account_id'");
+                       $this->db->next_record();
+                       return $this->db->f(0);
+               }
+ 
                function add($owner,$fields,$access='',$cat_id='',$tid='n')
                {
***************
*** 190,193 ****
--- 198,210 ----
                        $fakturanr=$fields['fakturanr'];
                        $spbudact_code=$fields['spbudact_code'];
+                       if ($spbudact_code)
+                       {
+                               $spbudact_code_value="'$spbudact_code'";
+                       }
+                       else
+                       {
+                               $spbudact_code_value="Null";
+                       }
+ 
                        $dima=$fields['dima'];
                        $dimd=$fields['dimd'];
***************
*** 209,213 ****
  
                        $sql= "INSERT INTO t_ecobilag 
(pmwrkord_code,bilagsnr,splitt,kildeid,kidnr,typeid,fakturadato,forfallsdato,regtid,artid,godkjentbelop,spvend_code,dimb,oppsynsmannid,saksbehandlerid,budsjettansvarligid,fakturanr,spbudact_code,dima,dimd,mvakode,belop,periode,merknad)"
!                       . " values 
($pmwrkord_code_value,'$bilagsnr','$splitt','$kildeid','$kidnr','$typeid','$fakturadato','$forfallsdato','$regtid','$artid',CONVERT(MONEY,"."'$godkjentbelop'".",0),'$spvend_code',$dimb_value,$oppsynsmannid_value,$saksbehandlerid_value,'$budsjettansvarligid','$fakturanr','$spbudact_code','$dima',$dimd_value,'$mvakode',CONVERT(MONEY,"."'$belop'".",0),'$periode','$merknad')";
  
  //echo 'sql'.$sql.'<br>';
--- 226,230 ----
  
                        $sql= "INSERT INTO t_ecobilag 
(pmwrkord_code,bilagsnr,splitt,kildeid,kidnr,typeid,fakturadato,forfallsdato,regtid,artid,godkjentbelop,spvend_code,dimb,oppsynsmannid,saksbehandlerid,budsjettansvarligid,fakturanr,spbudact_code,dima,dimd,mvakode,belop,periode,merknad)"
!                       . " values 
($pmwrkord_code_value,'$bilagsnr','$splitt','$kildeid','$kidnr','$typeid','$fakturadato','$forfallsdato','$regtid','$artid',CONVERT(MONEY,"."'$godkjentbelop'".",0),'$spvend_code',$dimb_value,$oppsynsmannid_value,$saksbehandlerid_value,'$budsjettansvarligid','$fakturanr',$spbudact_code_value,'$dima',$dimd_value,'$mvakode',CONVERT(MONEY,"."'$belop'".",0),'$periode','$merknad')";
  
  //echo 'sql'.$sql.'<br>';