[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] CVS: property/inc class.soXport.inc.php,1.4,1.5
From: |
Sigurd Nes <address@hidden> |
Subject: |
[Phpgroupware-cvs] CVS: property/inc class.soXport.inc.php,1.4,1.5 |
Date: |
Mon, 11 Nov 2002 14:35:20 -0500 |
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>';
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] CVS: property/inc class.soXport.inc.php,1.4,1.5,
Sigurd Nes <address@hidden> <=
- Prev by Date:
[Phpgroupware-cvs] CVS: property/setup tables_current.inc.php,1.13,1.14 tables_update.inc.php,1.13,1.14 setup.inc.php,1.10,1.11
- Next by Date:
[Phpgroupware-cvs] CVS: property/inc/import Import_fra_Service,1.1,1.2
- Previous by thread:
[Phpgroupware-cvs] CVS: property/setup tables_current.inc.php,1.13,1.14 tables_update.inc.php,1.13,1.14 setup.inc.php,1.10,1.11
- Next by thread:
[Phpgroupware-cvs] CVS: property/inc/import Import_fra_Service,1.1,1.2
- Index(es):