[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] property/inc class.soXport.inc.php,1.17
From: |
sigurdne |
Subject: |
[Phpgroupware-cvs] property/inc class.soXport.inc.php,1.17 |
Date: |
Wed, 14 Sep 2005 12:21:00 +0200 |
Update of property/inc
Modified Files:
Branch: MAIN
class.soXport.inc.php lines: +8 -28
Log Message:
no message
====================================================
Index: property/inc/class.soXport.inc.php
diff -u property/inc/class.soXport.inc.php:1.16
property/inc/class.soXport.inc.php:1.17
--- property/inc/class.soXport.inc.php:1.16 Thu May 12 21:26:28 2005
+++ property/inc/class.soXport.inc.php Wed Sep 14 10:21:49 2005
@@ -485,36 +485,18 @@
$sql="INSERT INTO fm_ecoavvik
(bilagsnr,fakturadato,forfallsdato,oppsynsmannid,oppsynsigndato,saksbehandlerid,saksigndato,budsjettansvarligid,budsjettsigndato,artid,spvend_code,belop,godkjentbelop)
values "
.
"($bilagsnr','$fakturadato','$forfallsdato','$oppsynsmannid','$oppsynsigndato','$saksbehandlerid','$saksigndato','$budsjettansvarligid','$budsjettsigndato','$artid','$spvend_code','$belop','$godkjentbelop')";
$this->db->query($sql,__LINE__,__FILE__);
- }
+ }
function delete_avvik($bilagsnr)
- {
- $sql="delete from fm_ecoavvik where
bilagsnr='$bilagsnr'";
- $this->db->query($sql,__LINE__,__FILE__);
- }
- function delete_invoice($bilagsnr)
- {
- $sql="delete from fm_ecobilagoverf where
bilagsnr='$bilagsnr'";
- $this->db->query($sql,__LINE__,__FILE__);
- }
-
-
- //Hent DIM C
- function select_dimc($pmwrkord_code)
- {
- $sql= "select location_code from fm_workorder $this->join
fm_project on fm_workorder.project_id=fm_project.id where
fm_workorder.id='$pmwrkord_code'";
+ {
+ $sql="delete from fm_ecoavvik where
bilagsnr='$bilagsnr'";
$this->db->query($sql,__LINE__,__FILE__);
- $this->db->next_record();
- $location_code = $this->db->f('location_code');
- $location = split("-", $location_code);
- $loc1 = $location[0];
- $loc4 = $location[3];
+ }
- $sql= "select category from fm_location4 where
fm_location4.loc1='$loc1' and fm_location4.loc4='$loc4'";
+ function delete_invoice($bilagsnr)
+ {
+ $sql="delete from fm_ecobilagoverf where
bilagsnr='$bilagsnr'";
$this->db->query($sql,__LINE__,__FILE__);
- $this->db->next_record();
- $dimc = $this->db->f('category');
- return $dimc;
}
//Logg transaksjon
@@ -527,7 +509,6 @@
function increment_batchid()
{
-
$this->db->query("update fm_idgenerator set value =
value + 1 where name = 'Ecobatchid'");
$this->db->query("select value from fm_idgenerator
where name = 'Ecobatchid'");
$this->db->next_record();
@@ -555,6 +536,5 @@
}
}
-
?>
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] property/inc class.soXport.inc.php,1.17,
sigurdne <=