[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] property/inc/class.soXport.inc.php, 1.7
From: |
nomail |
Subject: |
[Phpgroupware-cvs] property/inc/class.soXport.inc.php, 1.7 |
Date: |
Wed, 1 Sep 2004 23:00:18 +0200 |
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');
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] property/inc/class.soXport.inc.php, 1.7,
nomail <=