[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] property/class.soXport.php, 1.1.1.3
From: |
nomail |
Subject: |
[Phpgroupware-cvs] property/class.soXport.php, 1.1.1.3 |
Date: |
Fri, 21 May 2004 16:33:05 -0000 |
Update of /property
Modified Files:
Branch:
class.soXport.php
date: 2004/04/23 21:26:33; author: sigurdne; state: Exp; lines: +478 -478
Log Message:
no message
=====================================================================
Index: property/class.soXport.php
diff -u property/class.soXport.php:1.1.1.2 property/class.soXport.php:1.1.1.3
--- property/class.soXport.php:1.1.1.2 Fri Apr 23 20:26:09 2004
+++ property/class.soXport.php Fri Apr 23 21:26:33 2004
@@ -1,478 +1,478 @@
-<?php
-
/**************************************************************************\
- * phpGroupWare - property
*
- * http://www.phpgroupware.org
*
- *
*
- * Facilities Management
*
- * Written by Sigurd Nes [sigurdne at online.no]
*
- *
------------------------------------------------------------------------ *
- * Copyright 2000 - 2003 Free Software Foundation, Inc
*
- * This program is part of the GNU project, see http://www.gnu.org/
*
- *
------------------------------------------------------------------------ *
- * This program is free software; you can redistribute it and/or modify
it *
- * under the terms of the GNU General Public License as published by the
*
- * Free Software Foundation; either version 2 of the License, or (at
your *
- * option) any later version.
*
-
\**************************************************************************/
-
- class property_soXport
- {
- var $db = '';
- var $account_id = 0;
- var $total_records = 0;
-
- function property_soXport($useacl=True)
- {
- $this->currentapp = 'property';
//$GLOBALS['phpgw_info']['flags']['currentapp'];
- $this->db =
$GLOBALS['phpgw']->db;
- $this->bocommon =
CreateObject($this->currentapp.'_bocommon');
-
- $this->join =
$this->bocommon->join;
- $this->datetimeformat =
$this->bocommon->datetimeformat;
- $this->account_id =
$GLOBALS['phpgw_data']['user']['id'];
- }
-
-
- function auto_tax($dima='')
- {
- if(!$dima)
- {
- return;
- }
- $sql = "select mva as tax_code from fm_location1 where
loc1=" . substr($dima,0,4);
- $dbresult = $GLOBALS['phpgw']->db->Execute($sql);
-
-
- return $dbresult->fields['tax_code'];
-
- }
-
- function anleggsnr_to_objekt($anleggsnr)
- {
- $dbresult = $GLOBALS['phpgw']->db->Execute("SELECT
fm_meter.name,fm_meter.loc1,fm_meter.loc2,fm_meter.loc3,fm_part_of_town.district_id
"
- . " from fm_meter $this->join fm_location1 ON
fm_meter.loc1 = fm_location1.loc1 $this->join "
- . " fm_part_of_town ON fm_location1.part_of_town_id =
fm_part_of_town.part_of_town_id where fm_meter.num='$anleggsnr'");
-
-
-
-// $location = split("-",
$dbresult->fields['location_code']);
-
- $loc1 = $dbresult->fields['loc1'];
- $loc2 = $dbresult->fields['loc2'];
- $loc3 = $dbresult->fields['loc3'];
- $dima=$loc1.$loc2.$loc3;
-
- $maalerinfo['loc1']=$loc1;
- $maalerinfo['dima']=$dima;
- $maalerinfo['maalernr']=$dbresult->fields['name'];
-
$maalerinfo['district']=$dbresult->fields['district_id'];
- return $maalerinfo;
-
- }
-
- function gabnr_to_objekt($Gnr,$Bnr,$sekjonnr)
- {
- //Finn dima fra Boei
- $sql = "select fm_gab_location.loc1,
fm_gab_location.loc2, fm_gab_location.loc3 from fm_gab_location, fm_location1,
fm_owner "
- . "where substring(fm_gab_location.gab_id,5,5)='$Gnr'
and "
- . " substring(fm_gab_location.gab_id,10,4)='$Bnr'
and "
- . "
substring(fm_gab_location.gab_id,18,3)='$sekjonnr' and "
- . " fm_gab_location.loc1=fm_location1.loc1 and "
- . " fm_location1.owner_id=fm_owner.owner_id ";
- // . " and (fm_owner.category=0 or
fm_owner.category=2)";
-
- $dbresult = $GLOBALS['phpgw']->db->Execute($sql);
-
- $gabinfo['loc1']=$dbresult->fields['loc1'];
-
$gabinfo['dima']=$dbresult->fields['loc1'].$dbresult->fields['loc2'].$dbresult->fields['loc3'];
-
- return $gabinfo;
- }
-
-
- function dima_to_address($dima)
- {
- $loc1=substr($dima,0,4);
- $loc2=substr($dima,4,2);
- $loc3=substr($dima,6,2);
- $sql = "select loc3_name from fm_location3 where loc1 =
'$loc1' and loc2= '$loc2' and loc3 = '$loc3' ";
- $dbresult = $GLOBALS['phpgw']->db->Execute($sql);
- $address=$dbresult->fields['loc3_name'];
- return $address;
-
- }
-
- function check_pmwrkord_code($pmwrkord_code)
- {
-
- $dbresult = $GLOBALS['phpgw']->db->Execute("SELECT
count(*) from fm_workorder where id='$pmwrkord_code'");
-
- return $dbresult->fields[0];
- }
-
- function check_spbudact_code($id)
- {
-
- $dbresult = $GLOBALS['phpgw']->db->Execute("SELECT
count(*) from fm_b_account where id='$id'");
-
- return $dbresult->fields[0];
- }
-
- function add($buffer)
- {
- $GLOBALS['phpgw']->db->begintrans();
-
- $num=0;
- foreach ($buffer as $fields)
- {
- if(abs($fields['belop'])>0)
- {
- $values= array(
- $fields['pmwrkord_code'],
- $fields['bilagsnr'],
- $fields['splitt'],
- $fields['kildeid'],
- $fields['kidnr'],
- $fields['typeid'],
- $fields['fakturadato'],
- $fields['forfallsdato'],
- $fields['regtid'],
- $fields['artid'],
- $fields['spvend_code'],
- $fields['dimb'],
- $fields['oppsynsmannid'],
- $fields['saksbehandlerid'],
- $fields['budsjettansvarligid'],
- $fields['fakturanr'],
- $fields['spbudact_code'],
- $fields['loc1'],
- $fields['dima'],
- $fields['dimd'],
- $fields['mvakode'],
- $fields['periode'],
- $fields['merknad'],
- False,
- False,
- False,
- False
- );
-
- $bilagsnr = $fields['bilagsnr'];
-
- $values =
$this->bocommon->validate_db_insert($values);
-
- $sql= "INSERT INTO fm_ecobilag
(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)"
- . " VALUES ($values," .
$this->bocommon->moneyformat($fields['belop']) . "," .
$this->bocommon->moneyformat($fields['godkjentbelop']) . ")";
-
- $dbresult =
$GLOBALS['phpgw']->db->Execute($sql);
-
- $num++;
- }
- }
-
- $GLOBALS['phpgw']->db->Execute("UPDATE fm_idgenerator
set value =$bilagsnr WHERE name = 'Bilagsnummer'");
-
- $GLOBALS['phpgw']->db->committrans();
-
- return $num;
- }
-
- function add_OverfBilag ($data)
- {
- $values= array(
- $data['id'],
- $data['bilagsnr'],
- $data['kidnr'],
- $data['typeid'],
- $data['kildeid'],
- $data['pmwrkord_code'],
- $data['fakturadato'],
- $data['periode'],
- $data['forfallsdato'],
- $data['fakturanr'],
- $data['spbudact_code'],
- $data['regtid'],
- $data['artid'],
- $data['spvend_code'],
- $data['dima'],
- $data['loc1'],
- $data['dimb'],
- $data['mvakode'],
- $data['dimd'],
- $data['oppsynsmannid'],
- $data['saksbehandlerid'],
- $data['budsjettansvarligid'],
- $data['oppsynsigndato'],
- $data['saksigndato'],
- $data['budsjettsigndato'],
- $data['merknad'],
- $data['splitt'],
- $data['utbetalingid'],
- $data['utbetalingsigndato'],
- $data['filnavn'],
- date("Y-m-d G:i:s")
- );
-
- $values = $this->bocommon->validate_db_insert($values);
-
- $sql="INSERT INTO fm_ecobilagoverf
(id,bilagsnr,kidnr,typeid,kildeid,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,"
- . " belop,godkjentbelop,ordrebelop)"
- . "values ($values, "
- . $this->bocommon->moneyformat($data['belop'])
. ","
- .
$this->bocommon->moneyformat($data['godkjentbelop']) . ","
- .
$this->bocommon->moneyformat($data['ordrebelop']) . ")";
-
- $dbresult = $GLOBALS['phpgw']->db->Execute($sql);
-//echo 'sql ' . $sql.'<br>';
- }
-
- function delete_from_fm_ecobilag($id)
- {
- $sql="delete from fm_ecobilag where id=$id";
- $dbresult = $GLOBALS['phpgw']->db->Execute($sql);
- }
-
- // Velg ut alle hoved bilag som skal overføres
- function hoved_bilag ($periode)
- {
- $sql="select sum(belop) as belop, bilagsnr from fm_ecobilag
where periode='$periode' AND budsjettsigndato is not NULL AND ( saksigndato
is not NULL OR oppsynsigndato is not NULL ) AND utbetalingsigndato is not
NULL group by bilagsnr";
-//echo 'sql ' . $sql.'<br>';
-
- $dbresult = $GLOBALS['phpgw']->db->Execute($sql);
- $i = 0;
- while (!$dbresult->EOF)
- {
- $hoved_bilag_temp[$i]['belop'] =
$dbresult->fields['belop'];
- $hoved_bilag_temp[$i]['bilagsnr'] =
$dbresult->fields['bilagsnr'];
- $i++;
- $dbresult->MoveNext();
- }
-
-//html_print_r($hoved_bilag_temp);
-
- if ($hoved_bilag_temp)
- {
- $i = 0;
- while(each($hoved_bilag_temp))
- {
- $bilagsnr =
$hoved_bilag_temp[$i]['bilagsnr'];
-
- $sql= "select
fm_ecobilag.*,fm_ecouser.initials as saksbehandler from fm_ecobilag $this->join
fm_ecouser on fm_ecobilag.budsjettansvarligid=fm_ecouser.lid where
bilagsnr=$bilagsnr ";
- $dbresult =
$GLOBALS['phpgw']->db->Execute($sql);
-
-
-
- $hoved_bilag[$i]['id']
= $dbresult->fields['id'];
- $hoved_bilag[$i]['bilagsnr']
= $bilagsnr;
- $hoved_bilag[$i]['kidnr']
= $dbresult->fields['kidnr'];
- $hoved_bilag[$i]['typeid']
= $dbresult->fields['typeid'];
- $hoved_bilag[$i]['kildeid']
= $dbresult->fields['kildeid'];
- $hoved_bilag[$i]['pmwrkord_code']
= $dbresult->fields['pmwrkord_code'];
- $hoved_bilag[$i]['belop']
= $hoved_bilag_temp[$i]['belop'];
- $hoved_bilag[$i]['fakturadato']
= $dbresult->fields['fakturadato'];
- $hoved_bilag[$i]['periode']
= $dbresult->fields['periode'];
- $hoved_bilag[$i]['forfallsdato']
= $dbresult->fields['forfallsdato'];
- $hoved_bilag[$i]['fakturanr']
= $dbresult->fields['fakturanr'];
- $hoved_bilag[$i]['spbudact_code']
= $dbresult->fields['spbudact_code'];
- $hoved_bilag[$i]['regtid']
= $dbresult->fields['regtid'];
- $hoved_bilag[$i]['artid']
= $dbresult->fields['artid'];
- $hoved_bilag[$i]['godkjentbelop']
= $hoved_bilag_temp[$i]['belop'];
- $hoved_bilag[$i]['spvend_code']
= $dbresult->fields['spvend_code'];
- $hoved_bilag[$i]['dima']
= $dbresult->fields['dima'];
- $hoved_bilag[$i]['dimb']
= $dbresult->fields['dimb'];
- $hoved_bilag[$i]['mvakode']
= $dbresult->fields['mvakode'];
- $hoved_bilag[$i]['dimd']
= $dbresult->fields['dimd'];
- if($dbresult->fields['oppsynsmannid'])
- {
-
$hoved_bilag[$i]['oppsynsmannid'] = $dbresult->fields['oppsynsmannid'];
- }
- if($dbresult->fields['saksbehandlerid'])
- {
-
$hoved_bilag[$i]['saksbehandlerid'] = $dbresult->fields['saksbehandlerid'];
- }
-
- $hoved_bilag[$i]['budsjettansvarligid']
= $dbresult->fields['budsjettansvarligid'];
-
- if($dbresult->fields['oppsynsigndato'])
- {
-
$hoved_bilag[$i]['oppsynsigndato'] = $dbresult->fields['oppsynsigndato'];
- }
- if($dbresult->fields['saksigndato'])
- {
- $hoved_bilag[$i]['saksigndato']
= $dbresult->fields['saksigndato'];
- }
-
- $hoved_bilag[$i]['budsjettsigndato']
= $dbresult->fields['budsjettsigndato'];
- $hoved_bilag[$i]['merknad']
= $dbresult->fields['merknad'];
- $hoved_bilag[$i]['splitt']
= $dbresult->fields['splitt'];
- $hoved_bilag[$i]['utbetalingid']
= $dbresult->fields['utbetalingid'];
- $hoved_bilag[$i]['utbetalingsigndato']
= $dbresult->fields['utbetalingsigndato'];
- $hoved_bilag[$i]['saksbehandler']
= $dbresult->fields['saksbehandler'];
- $i++;
- }
- }
-//html_print_r($hoved_bilag);
-
- return $hoved_bilag;
- }
-
- //Velg ut alle underbilag
-
- function select_underbilag ($bilagsnr)
- {
- $sql= "select * from fm_ecobilag where
bilagsnr='$bilagsnr'";
- $dbresult = $GLOBALS['phpgw']->db->Execute($sql);
- $i = 0;
- while (!$dbresult->EOF)
- {
- $underbilag[$i]['id'] =
$dbresult->fields['id'];
- $underbilag[$i]['bilagsnr'] =
$dbresult->fields['bilagsnr'];
- $underbilag[$i]['kidnr'] =
$dbresult->fields['kidnr'];
- $underbilag[$i]['typeid'] =
$dbresult->fields['typeid'];
- $underbilag[$i]['kildeid'] =
$dbresult->fields['kildeid'];
- $underbilag[$i]['pmwrkord_code'] =
$dbresult->fields['pmwrkord_code'];
- $underbilag[$i]['belop'] =
$dbresult->fields['belop'];
- $underbilag[$i]['fakturadato'] =
$dbresult->fields['fakturadato'];
- $underbilag[$i]['periode'] =
$dbresult->fields['periode'];
- $underbilag[$i]['forfallsdato'] =
$dbresult->fields['forfallsdato'];
- $underbilag[$i]['fakturanr'] =
$dbresult->fields['fakturanr'];
- $underbilag[$i]['spbudact_code'] =
$dbresult->fields['spbudact_code'];
- $underbilag[$i]['regtid'] =
$dbresult->fields['regtid'];
- $underbilag[$i]['artid'] =
$dbresult->fields['artid'];
- $underbilag[$i]['godkjentbelop'] =
$dbresult->fields['godkjentbelop'];
- $underbilag[$i]['spvend_code'] =
$dbresult->fields['spvend_code'];
- $underbilag[$i]['dima'] =
$dbresult->fields['dima'];
- $underbilag[$i]['loc1'] =
$dbresult->fields['loc1'];
- $underbilag[$i]['dimb'] =
$dbresult->fields['dimb'];
- $underbilag[$i]['mvakode'] =
$dbresult->fields['mvakode'];
- $underbilag[$i]['dimd'] =
$dbresult->fields['dimd'];
- if($dbresult->fields['oppsynsmannid'])
- {
- $underbilag[$i]['oppsynsmannid']
= $dbresult->fields['oppsynsmannid'];
- }
- if($dbresult->fields['saksbehandlerid'])
- {
- $underbilag[$i]['saksbehandlerid']
= $dbresult->fields['saksbehandlerid'];
- }
-
- $underbilag[$i]['budsjettansvarligid'] =
$dbresult->fields['budsjettansvarligid'];
-
- if($dbresult->fields['oppsynsigndato'])
- {
- $underbilag[$i]['oppsynsigndato']
= $dbresult->fields['oppsynsigndato'];
- }
- if($dbresult->fields['saksigndato'])
- {
- $underbilag[$i]['saksigndato'] =
$dbresult->fields['saksigndato'];
- }
-
- $underbilag[$i]['budsjettsigndato'] =
$dbresult->fields['budsjettsigndato'];
- $underbilag[$i]['merknad'] =
$dbresult->fields['merknad'];
- $underbilag[$i]['splitt'] =
$dbresult->fields['splitt'];
- $underbilag[$i]['utbetalingid'] =
$dbresult->fields['utbetalingid'];
- $underbilag[$i]['utbetalingsigndato'] =
$dbresult->fields['utbetalingsigndato'];
- $i++;
- $dbresult->MoveNext();
-
- }
-
- return $underbilag;
- }
-
-/* function update_avvik($avvik)
- {
- }
-
-*/
- function log_to_deviation_table($oRsBilag)
- {
- $bilagsnr=$oRsBilag['bilagsnr'];
- $fakturadato=$oRsBilag['fakturadato'];
- $forfallsdato=$oRsBilag['forfallsdato'];
- $oppsynsmannid=$oRsBilag['oppsynsmannid'];
- $oppsynsigndato=$oRsBilag['oppsynsigndato'];
- $saksbehandlerid=$oRsBilag['saksbehandlerid'];
- $saksigndato=$oRsBilag['saksigndato'];
- $budsjettansvarligid=$oRsBilag['budsjettansvarligid'];
- $budsjettsigndato=$oRsBilag['budsjettsigndato'];
- $artid=$oRsBilag['artid'];
- $spvend_code=$oRsBilag['spvend_code'];
- $belop=$oRsBilag['belop'];
- $godkjentbelop=$oRsBilag['godkjentbelop'];
-
- $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')";
- $dbresult = $GLOBALS['phpgw']->db->Execute($sql);
- }
-
- function delete_avvik($bilagsnr)
- {
- $sql="delete from fm_ecoavvik where
bilagsnr='$bilagsnr'";
- $dbresult = $GLOBALS['phpgw']->db->Execute($sql);
- }
- function delete_invoice($bilagsnr)
- {
- $sql="delete from fm_ecobilagoverf where
bilagsnr='$bilagsnr'";
- $dbresult = $GLOBALS['phpgw']->db->Execute($sql);
- }
-
-
- //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'";
- $dbresult = $GLOBALS['phpgw']->db->Execute($sql);
-
- $location_code = $dbresult->fields['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'";
- $dbresult = $GLOBALS['phpgw']->db->Execute($sql);
-
- $dimc = $dbresult->fields['category'];
- return $dimc;
- }
-
- //Logg transaksjon
- function log_transaction($batchid,$bilagid)
- {
- $message=lang('Invoice tranferred');
- $tid=date($this->datetimeformat);
- $sql= "insert into fm_ecologg
(batchid,ecobilagid,melding,tid) values ('$batchid','$bilagid'
,'$message','$tid')";
- $dbresult = $GLOBALS['phpgw']->db->Execute($sql);
- }
-
- function increment_batchid()
- {
-
- $GLOBALS['phpgw']->db->Execute("UPDATE fm_idgenerator
set value = value + 1 where name = 'Ecobatchid'");
- $dbresult = $GLOBALS['phpgw']->db->Execute("SELECT
value from fm_idgenerator where name = 'Ecobatchid'");
-
- $bilagsnr = $dbresult->fields['value'];
- return $bilagsnr;
-
- }
-
- function next_batchid()
- {
-
- $dbresult = $GLOBALS['phpgw']->db->Execute("SELECT
value from fm_idgenerator where name = 'Ecobatchid'");
-
- $batchid = $dbresult->fields['value']+1;
-
- return $batchid;
- }
-
-
- }
-
-
-?>
+<?php
+
/**************************************************************************\
+ * phpGroupWare - property
*
+ * http://www.phpgroupware.org
*
+ *
*
+ * Facilities Management
*
+ * Written by Sigurd Nes [sigurdne at online.no]
*
+ *
------------------------------------------------------------------------ *
+ * Copyright 2000 - 2003 Free Software Foundation, Inc
*
+ * This program is part of the GNU project, see http://www.gnu.org/
*
+ *
------------------------------------------------------------------------ *
+ * This program is free software; you can redistribute it and/or modify
it *
+ * under the terms of the GNU General Public License as published by the
*
+ * Free Software Foundation; either version 2 of the License, or (at
your *
+ * option) any later version.
*
+
\**************************************************************************/
+
+ class property_soXport
+ {
+ var $db = '';
+ var $account_id = 0;
+ var $total_records = 0;
+
+ function property_soXport($useacl=True)
+ {
+ $this->currentapp = 'property';
//$GLOBALS['phpgw_info']['flags']['currentapp'];
+ $this->db =
$GLOBALS['phpgw']->db;
+ $this->bocommon =
CreateObject($this->currentapp.'_bocommon');
+
+ $this->join =
$this->bocommon->join;
+ $this->datetimeformat =
$this->bocommon->datetimeformat;
+ $this->account_id =
$GLOBALS['phpgw_data']['user']['id'];
+ }
+
+
+ function auto_tax($dima='')
+ {
+ if(!$dima)
+ {
+ return;
+ }
+ $sql = "select mva as tax_code from fm_location1 where
loc1=" . substr($dima,0,4);
+ $dbresult = $GLOBALS['phpgw']->db->Execute($sql);
+
+
+ return $dbresult->fields['tax_code'];
+
+ }
+
+ function anleggsnr_to_objekt($anleggsnr)
+ {
+ $dbresult = $GLOBALS['phpgw']->db->Execute("SELECT
fm_meter.name,fm_meter.loc1,fm_meter.loc2,fm_meter.loc3,fm_part_of_town.district_id
"
+ . " from fm_meter $this->join fm_location1 ON
fm_meter.loc1 = fm_location1.loc1 $this->join "
+ . " fm_part_of_town ON fm_location1.part_of_town_id =
fm_part_of_town.part_of_town_id where fm_meter.num='$anleggsnr'");
+
+
+
+// $location = split("-",
$dbresult->fields['location_code']);
+
+ $loc1 = $dbresult->fields['loc1'];
+ $loc2 = $dbresult->fields['loc2'];
+ $loc3 = $dbresult->fields['loc3'];
+ $dima=$loc1.$loc2.$loc3;
+
+ $maalerinfo['loc1']=$loc1;
+ $maalerinfo['dima']=$dima;
+ $maalerinfo['maalernr']=$dbresult->fields['name'];
+
$maalerinfo['district']=$dbresult->fields['district_id'];
+ return $maalerinfo;
+
+ }
+
+ function gabnr_to_objekt($Gnr,$Bnr,$sekjonnr)
+ {
+ //Finn dima fra Boei
+ $sql = "select fm_gab_location.loc1,
fm_gab_location.loc2, fm_gab_location.loc3 from fm_gab_location, fm_location1,
fm_owner "
+ . "where substring(fm_gab_location.gab_id,5,5)='$Gnr'
and "
+ . " substring(fm_gab_location.gab_id,10,4)='$Bnr'
and "
+ . "
substring(fm_gab_location.gab_id,18,3)='$sekjonnr' and "
+ . " fm_gab_location.loc1=fm_location1.loc1 and "
+ . " fm_location1.owner_id=fm_owner.owner_id ";
+ // . " and (fm_owner.category=0 or
fm_owner.category=2)";
+
+ $dbresult = $GLOBALS['phpgw']->db->Execute($sql);
+
+ $gabinfo['loc1']=$dbresult->fields['loc1'];
+
$gabinfo['dima']=$dbresult->fields['loc1'].$dbresult->fields['loc2'].$dbresult->fields['loc3'];
+
+ return $gabinfo;
+ }
+
+
+ function dima_to_address($dima)
+ {
+ $loc1=substr($dima,0,4);
+ $loc2=substr($dima,4,2);
+ $loc3=substr($dima,6,2);
+ $sql = "select loc3_name from fm_location3 where loc1 =
'$loc1' and loc2= '$loc2' and loc3 = '$loc3' ";
+ $dbresult = $GLOBALS['phpgw']->db->Execute($sql);
+ $address=$dbresult->fields['loc3_name'];
+ return $address;
+
+ }
+
+ function check_pmwrkord_code($pmwrkord_code)
+ {
+
+ $dbresult = $GLOBALS['phpgw']->db->Execute("SELECT
count(*) from fm_workorder where id='$pmwrkord_code'");
+
+ return $dbresult->fields[0];
+ }
+
+ function check_spbudact_code($id)
+ {
+
+ $dbresult = $GLOBALS['phpgw']->db->Execute("SELECT
count(*) from fm_b_account where id='$id'");
+
+ return $dbresult->fields[0];
+ }
+
+ function add($buffer)
+ {
+ $GLOBALS['phpgw']->db->begintrans();
+
+ $num=0;
+ foreach ($buffer as $fields)
+ {
+ if(abs($fields['belop'])>0)
+ {
+ $values= array(
+ $fields['pmwrkord_code'],
+ $fields['bilagsnr'],
+ $fields['splitt'],
+ $fields['kildeid'],
+ $fields['kidnr'],
+ $fields['typeid'],
+ $fields['fakturadato'],
+ $fields['forfallsdato'],
+ $fields['regtid'],
+ $fields['artid'],
+ $fields['spvend_code'],
+ $fields['dimb'],
+ $fields['oppsynsmannid'],
+ $fields['saksbehandlerid'],
+ $fields['budsjettansvarligid'],
+ $fields['fakturanr'],
+ $fields['spbudact_code'],
+ $fields['loc1'],
+ $fields['dima'],
+ $fields['dimd'],
+ $fields['mvakode'],
+ $fields['periode'],
+ $fields['merknad'],
+ False,
+ False,
+ False,
+ False
+ );
+
+ $bilagsnr = $fields['bilagsnr'];
+
+ $values =
$this->bocommon->validate_db_insert($values);
+
+ $sql= "INSERT INTO fm_ecobilag
(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)"
+ . " VALUES ($values," .
$this->bocommon->moneyformat($fields['belop']) . "," .
$this->bocommon->moneyformat($fields['godkjentbelop']) . ")";
+
+ $dbresult =
$GLOBALS['phpgw']->db->Execute($sql);
+
+ $num++;
+ }
+ }
+
+ $GLOBALS['phpgw']->db->Execute("UPDATE fm_idgenerator
set value =$bilagsnr WHERE name = 'Bilagsnummer'");
+
+ $GLOBALS['phpgw']->db->committrans();
+
+ return $num;
+ }
+
+ function add_OverfBilag ($data)
+ {
+ $values= array(
+ $data['id'],
+ $data['bilagsnr'],
+ $data['kidnr'],
+ $data['typeid'],
+ $data['kildeid'],
+ $data['pmwrkord_code'],
+ $data['fakturadato'],
+ $data['periode'],
+ $data['forfallsdato'],
+ $data['fakturanr'],
+ $data['spbudact_code'],
+ $data['regtid'],
+ $data['artid'],
+ $data['spvend_code'],
+ $data['dima'],
+ $data['loc1'],
+ $data['dimb'],
+ $data['mvakode'],
+ $data['dimd'],
+ $data['oppsynsmannid'],
+ $data['saksbehandlerid'],
+ $data['budsjettansvarligid'],
+ $data['oppsynsigndato'],
+ $data['saksigndato'],
+ $data['budsjettsigndato'],
+ $data['merknad'],
+ $data['splitt'],
+ $data['utbetalingid'],
+ $data['utbetalingsigndato'],
+ $data['filnavn'],
+ date("Y-m-d G:i:s")
+ );
+
+ $values = $this->bocommon->validate_db_insert($values);
+
+ $sql="INSERT INTO fm_ecobilagoverf
(id,bilagsnr,kidnr,typeid,kildeid,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,"
+ . " belop,godkjentbelop,ordrebelop)"
+ . "values ($values, "
+ . $this->bocommon->moneyformat($data['belop'])
. ","
+ .
$this->bocommon->moneyformat($data['godkjentbelop']) . ","
+ .
$this->bocommon->moneyformat($data['ordrebelop']) . ")";
+
+ $dbresult = $GLOBALS['phpgw']->db->Execute($sql);
+//echo 'sql ' . $sql.'<br>';
+ }
+
+ function delete_from_fm_ecobilag($id)
+ {
+ $sql="delete from fm_ecobilag where id=$id";
+ $dbresult = $GLOBALS['phpgw']->db->Execute($sql);
+ }
+
+ // Velg ut alle hoved bilag som skal overføres
+ function hoved_bilag ($periode)
+ {
+ $sql="select sum(belop) as belop, bilagsnr from fm_ecobilag
where periode='$periode' AND budsjettsigndato is not NULL AND ( saksigndato
is not NULL OR oppsynsigndato is not NULL ) AND utbetalingsigndato is not
NULL group by bilagsnr";
+//echo 'sql ' . $sql.'<br>';
+
+ $dbresult = $GLOBALS['phpgw']->db->Execute($sql);
+ $i = 0;
+ while (!$dbresult->EOF)
+ {
+ $hoved_bilag_temp[$i]['belop'] =
$dbresult->fields['belop'];
+ $hoved_bilag_temp[$i]['bilagsnr'] =
$dbresult->fields['bilagsnr'];
+ $i++;
+ $dbresult->MoveNext();
+ }
+
+//html_print_r($hoved_bilag_temp);
+
+ if ($hoved_bilag_temp)
+ {
+ $i = 0;
+ while(each($hoved_bilag_temp))
+ {
+ $bilagsnr =
$hoved_bilag_temp[$i]['bilagsnr'];
+
+ $sql= "select
fm_ecobilag.*,fm_ecouser.initials as saksbehandler from fm_ecobilag $this->join
fm_ecouser on fm_ecobilag.budsjettansvarligid=fm_ecouser.lid where
bilagsnr=$bilagsnr ";
+ $dbresult =
$GLOBALS['phpgw']->db->Execute($sql);
+
+
+
+ $hoved_bilag[$i]['id']
= $dbresult->fields['id'];
+ $hoved_bilag[$i]['bilagsnr']
= $bilagsnr;
+ $hoved_bilag[$i]['kidnr']
= $dbresult->fields['kidnr'];
+ $hoved_bilag[$i]['typeid']
= $dbresult->fields['typeid'];
+ $hoved_bilag[$i]['kildeid']
= $dbresult->fields['kildeid'];
+ $hoved_bilag[$i]['pmwrkord_code']
= $dbresult->fields['pmwrkord_code'];
+ $hoved_bilag[$i]['belop']
= $hoved_bilag_temp[$i]['belop'];
+ $hoved_bilag[$i]['fakturadato']
= $dbresult->fields['fakturadato'];
+ $hoved_bilag[$i]['periode']
= $dbresult->fields['periode'];
+ $hoved_bilag[$i]['forfallsdato']
= $dbresult->fields['forfallsdato'];
+ $hoved_bilag[$i]['fakturanr']
= $dbresult->fields['fakturanr'];
+ $hoved_bilag[$i]['spbudact_code']
= $dbresult->fields['spbudact_code'];
+ $hoved_bilag[$i]['regtid']
= $dbresult->fields['regtid'];
+ $hoved_bilag[$i]['artid']
= $dbresult->fields['artid'];
+ $hoved_bilag[$i]['godkjentbelop']
= $hoved_bilag_temp[$i]['belop'];
+ $hoved_bilag[$i]['spvend_code']
= $dbresult->fields['spvend_code'];
+ $hoved_bilag[$i]['dima']
= $dbresult->fields['dima'];
+ $hoved_bilag[$i]['dimb']
= $dbresult->fields['dimb'];
+ $hoved_bilag[$i]['mvakode']
= $dbresult->fields['mvakode'];
+ $hoved_bilag[$i]['dimd']
= $dbresult->fields['dimd'];
+ if($dbresult->fields['oppsynsmannid'])
+ {
+
$hoved_bilag[$i]['oppsynsmannid'] = $dbresult->fields['oppsynsmannid'];
+ }
+ if($dbresult->fields['saksbehandlerid'])
+ {
+
$hoved_bilag[$i]['saksbehandlerid'] = $dbresult->fields['saksbehandlerid'];
+ }
+
+ $hoved_bilag[$i]['budsjettansvarligid']
= $dbresult->fields['budsjettansvarligid'];
+
+ if($dbresult->fields['oppsynsigndato'])
+ {
+
$hoved_bilag[$i]['oppsynsigndato'] = $dbresult->fields['oppsynsigndato'];
+ }
+ if($dbresult->fields['saksigndato'])
+ {
+ $hoved_bilag[$i]['saksigndato']
= $dbresult->fields['saksigndato'];
+ }
+
+ $hoved_bilag[$i]['budsjettsigndato']
= $dbresult->fields['budsjettsigndato'];
+ $hoved_bilag[$i]['merknad']
= $dbresult->fields['merknad'];
+ $hoved_bilag[$i]['splitt']
= $dbresult->fields['splitt'];
+ $hoved_bilag[$i]['utbetalingid']
= $dbresult->fields['utbetalingid'];
+ $hoved_bilag[$i]['utbetalingsigndato']
= $dbresult->fields['utbetalingsigndato'];
+ $hoved_bilag[$i]['saksbehandler']
= $dbresult->fields['saksbehandler'];
+ $i++;
+ }
+ }
+//html_print_r($hoved_bilag);
+
+ return $hoved_bilag;
+ }
+
+ //Velg ut alle underbilag
+
+ function select_underbilag ($bilagsnr)
+ {
+ $sql= "select * from fm_ecobilag where
bilagsnr='$bilagsnr'";
+ $dbresult = $GLOBALS['phpgw']->db->Execute($sql);
+ $i = 0;
+ while (!$dbresult->EOF)
+ {
+ $underbilag[$i]['id'] =
$dbresult->fields['id'];
+ $underbilag[$i]['bilagsnr'] =
$dbresult->fields['bilagsnr'];
+ $underbilag[$i]['kidnr'] =
$dbresult->fields['kidnr'];
+ $underbilag[$i]['typeid'] =
$dbresult->fields['typeid'];
+ $underbilag[$i]['kildeid'] =
$dbresult->fields['kildeid'];
+ $underbilag[$i]['pmwrkord_code'] =
$dbresult->fields['pmwrkord_code'];
+ $underbilag[$i]['belop'] =
$dbresult->fields['belop'];
+ $underbilag[$i]['fakturadato'] =
$dbresult->fields['fakturadato'];
+ $underbilag[$i]['periode'] =
$dbresult->fields['periode'];
+ $underbilag[$i]['forfallsdato'] =
$dbresult->fields['forfallsdato'];
+ $underbilag[$i]['fakturanr'] =
$dbresult->fields['fakturanr'];
+ $underbilag[$i]['spbudact_code'] =
$dbresult->fields['spbudact_code'];
+ $underbilag[$i]['regtid'] =
$dbresult->fields['regtid'];
+ $underbilag[$i]['artid'] =
$dbresult->fields['artid'];
+ $underbilag[$i]['godkjentbelop'] =
$dbresult->fields['godkjentbelop'];
+ $underbilag[$i]['spvend_code'] =
$dbresult->fields['spvend_code'];
+ $underbilag[$i]['dima'] =
$dbresult->fields['dima'];
+ $underbilag[$i]['loc1'] =
$dbresult->fields['loc1'];
+ $underbilag[$i]['dimb'] =
$dbresult->fields['dimb'];
+ $underbilag[$i]['mvakode'] =
$dbresult->fields['mvakode'];
+ $underbilag[$i]['dimd'] =
$dbresult->fields['dimd'];
+ if($dbresult->fields['oppsynsmannid'])
+ {
+ $underbilag[$i]['oppsynsmannid']
= $dbresult->fields['oppsynsmannid'];
+ }
+ if($dbresult->fields['saksbehandlerid'])
+ {
+ $underbilag[$i]['saksbehandlerid']
= $dbresult->fields['saksbehandlerid'];
+ }
+
+ $underbilag[$i]['budsjettansvarligid'] =
$dbresult->fields['budsjettansvarligid'];
+
+ if($dbresult->fields['oppsynsigndato'])
+ {
+ $underbilag[$i]['oppsynsigndato']
= $dbresult->fields['oppsynsigndato'];
+ }
+ if($dbresult->fields['saksigndato'])
+ {
+ $underbilag[$i]['saksigndato'] =
$dbresult->fields['saksigndato'];
+ }
+
+ $underbilag[$i]['budsjettsigndato'] =
$dbresult->fields['budsjettsigndato'];
+ $underbilag[$i]['merknad'] =
$dbresult->fields['merknad'];
+ $underbilag[$i]['splitt'] =
$dbresult->fields['splitt'];
+ $underbilag[$i]['utbetalingid'] =
$dbresult->fields['utbetalingid'];
+ $underbilag[$i]['utbetalingsigndato'] =
$dbresult->fields['utbetalingsigndato'];
+ $i++;
+ $dbresult->MoveNext();
+
+ }
+
+ return $underbilag;
+ }
+
+/* function update_avvik($avvik)
+ {
+ }
+
+*/
+ function log_to_deviation_table($oRsBilag)
+ {
+ $bilagsnr=$oRsBilag['bilagsnr'];
+ $fakturadato=$oRsBilag['fakturadato'];
+ $forfallsdato=$oRsBilag['forfallsdato'];
+ $oppsynsmannid=$oRsBilag['oppsynsmannid'];
+ $oppsynsigndato=$oRsBilag['oppsynsigndato'];
+ $saksbehandlerid=$oRsBilag['saksbehandlerid'];
+ $saksigndato=$oRsBilag['saksigndato'];
+ $budsjettansvarligid=$oRsBilag['budsjettansvarligid'];
+ $budsjettsigndato=$oRsBilag['budsjettsigndato'];
+ $artid=$oRsBilag['artid'];
+ $spvend_code=$oRsBilag['spvend_code'];
+ $belop=$oRsBilag['belop'];
+ $godkjentbelop=$oRsBilag['godkjentbelop'];
+
+ $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')";
+ $dbresult = $GLOBALS['phpgw']->db->Execute($sql);
+ }
+
+ function delete_avvik($bilagsnr)
+ {
+ $sql="delete from fm_ecoavvik where
bilagsnr='$bilagsnr'";
+ $dbresult = $GLOBALS['phpgw']->db->Execute($sql);
+ }
+ function delete_invoice($bilagsnr)
+ {
+ $sql="delete from fm_ecobilagoverf where
bilagsnr='$bilagsnr'";
+ $dbresult = $GLOBALS['phpgw']->db->Execute($sql);
+ }
+
+
+ //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'";
+ $dbresult = $GLOBALS['phpgw']->db->Execute($sql);
+
+ $location_code = $dbresult->fields['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'";
+ $dbresult = $GLOBALS['phpgw']->db->Execute($sql);
+
+ $dimc = $dbresult->fields['category'];
+ return $dimc;
+ }
+
+ //Logg transaksjon
+ function log_transaction($batchid,$bilagid)
+ {
+ $message=lang('Invoice tranferred');
+ $tid=date($this->datetimeformat);
+ $sql= "insert into fm_ecologg
(batchid,ecobilagid,melding,tid) values ('$batchid','$bilagid'
,'$message','$tid')";
+ $dbresult = $GLOBALS['phpgw']->db->Execute($sql);
+ }
+
+ function increment_batchid()
+ {
+
+ $GLOBALS['phpgw']->db->Execute("UPDATE fm_idgenerator
set value = value + 1 where name = 'Ecobatchid'");
+ $dbresult = $GLOBALS['phpgw']->db->Execute("SELECT
value from fm_idgenerator where name = 'Ecobatchid'");
+
+ $bilagsnr = $dbresult->fields['value'];
+ return $bilagsnr;
+
+ }
+
+ function next_batchid()
+ {
+
+ $dbresult = $GLOBALS['phpgw']->db->Execute("SELECT
value from fm_idgenerator where name = 'Ecobatchid'");
+
+ $batchid = $dbresult->fields['value']+1;
+
+ return $batchid;
+ }
+
+
+ }
+
+
+?>
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] property/class.soXport.php, 1.1.1.3,
nomail <=