[Phpgroupware-cvs] property/inc/class.soXport.inc.php, 1.7

[nomail]

Update of /property/inc
Modified Files:
        Branch: 
          class.soXport.inc.php

date: 2004/09/01 21:00:18;  author: sigurdne;  state: Exp;  lines: +12 -2

Log Message:
no message
=====================================================================
Index: property/inc/class.soXport.inc.php
diff -u property/inc/class.soXport.inc.php:1.6 
property/inc/class.soXport.inc.php:1.7
--- property/inc/class.soXport.inc.php:1.6      Thu Aug 12 18:56:23 2004
+++ property/inc/class.soXport.inc.php  Wed Sep  1 21:00:18 2004
@@ -111,6 +111,13 @@
                        return $this->db->f('type');
                }
 
+               function get_project($id)
+               {
+                       $this->db->query("select project_id from fm_workorder 
where id='$id'");
+                       $this->db->next_record();
+                       return $this->db->f('project_id');
+               }
+
                function check_spbudact_code($id)
                {
 
@@ -129,6 +136,7 @@
                                if(abs($fields['belop'])>0)
                                {
                                        $values= array(
+                                               $fields['project_id'],
                                                $fields['pmwrkord_code'],
                                                $fields['bilagsnr'],
                                                $fields['splitt'],
@@ -162,7 +170,7 @@
 
                                        $values = 
$this->bocommon->validate_db_insert($values);
 
-                                       $sql= "INSERT INTO fm_ecobilag 
(pmwrkord_code,bilagsnr,splitt,kildeid,kidnr,typeid,fakturadato,"
+                                       $sql= "INSERT INTO fm_ecobilag 
(project_id,pmwrkord_code,bilagsnr,splitt,kildeid,kidnr,typeid,fakturadato,"
                                        . " 
forfallsdato,regtid,artid,spvend_code,dimb,oppsynsmannid,saksbehandlerid,budsjettansvarligid,"
                                        . " 
fakturanr,spbudact_code,loc1,dima,dimd,mvakode,periode,merknad,oppsynsigndato,saksigndato,"
                                        . " 
budsjettsigndato,utbetalingsigndato,belop,godkjentbelop)"
@@ -189,6 +197,7 @@
                                $data['kidnr'],
                                $data['typeid'],
                                $data['kildeid'],
+                               $data['project_id'],
                                $data['pmwrkord_code'],
                                $data['fakturadato'],
                                $data['periode'],
@@ -219,7 +228,7 @@
 
                        $values = $this->bocommon->validate_db_insert($values);
 
-                       $sql="INSERT INTO fm_ecobilagoverf 
(id,bilagsnr,kidnr,typeid,kildeid,pmwrkord_code,fakturadato,"
+                       $sql="INSERT INTO fm_ecobilagoverf 
(id,bilagsnr,kidnr,typeid,kildeid,project_id,pmwrkord_code,fakturadato,"
                                . " 
periode,forfallsdato,fakturanr,spbudact_code,regtid,artid,spvend_code,dima,loc1,"
                                . " 
dimb,mvakode,dimd,oppsynsmannid,saksbehandlerid,budsjettansvarligid,oppsynsigndato,saksigndato,"
                                . " 
budsjettsigndato,merknad,splitt,utbetalingid,utbetalingsigndato,filnavn,overftid,"
@@ -358,6 +367,7 @@
                                $underbilag[$i]['dimb'] = $this->db->f('dimb');
                                $underbilag[$i]['mvakode']      = 
$this->db->f('mvakode');
                                $underbilag[$i]['dimd'] = $this->db->f('dimd');
+                               $underbilag[$i]['project_id']   = 
$this->db->f('project_id');
                                if($this->db->f('oppsynsmannid'))
                                {
                                        $underbilag[$i]['oppsynsmannid']        
= $this->db->f('oppsynsmannid');