[Phpgroupware-cvs] CVS: property/inc class.boXport.inc.php,NONE,1.1 class.invoice.inc.php,NONE,1.1 class.soXport.inc.php,NONE,1.1 class.uiXport.inc.php,NONE,1.1

[Sigurd Nes <address@hidden>]

Update of /cvsroot/phpgroupware/property/inc
In directory subversions:/tmp/cvs-serv9701/inc

Added Files:
        class.boXport.inc.php class.invoice.inc.php 
        class.soXport.inc.php class.uiXport.inc.php 
Log Message:
no message

***** Error reading new file: [Errno 2] No such file or directory: 
'class.boXport.inc.php'
***** Error reading new file: [Errno 2] No such file or directory: 
'class.invoice.inc.php'
--- NEW FILE ---
<?php

        class soXport
        {
                var $db = '';
                var $std_table='t_ecobilag';

                var $account_id = 0;
                var $total_records = 0;
                var $grants = '';

                /* The left side are the array elements used throughout phpgw, 
right side are the db field names. */
                var $stock_contact_fields = array(
                        'id'                            => 'id',
                        'bilagsnr'                      => 'bilagsnr',
                        'kidnr'                         => 'kidnr',
                        'typeid'                        => 'typeid',
                        'kildeid'                       => 'kildeid',
                        'pmwrkord_code'         => 'pmwrkord_code',
                        'belop'                         => 'belop',
                        'fakturadato'           => 'fakturadato',
                        'periode'                       => 'periode',
                        'forfallsdato'          => 'forfallsdato',
                        'fakturanr'                     => 'fakturanr',
                        'spbudact_code'         => 'spbudact_code',
                        'regtid'                        => 'regtid',
                        'artid'                         => 'artid',
                        'godkjentbelop'         => 'godkjentbelop',
                        'spvend_code'           => 'spvend_code',
                        'dima'                          => 'dima',
                        'dimb'                          => 'dimb',
                        'mvakode'                       => 'mvakode',
                        'dimd'                          => 'dimd',
                        'oppsynsmannid'         => 'oppsynsmannid',
                        'saksbehandlerid'       => 'saksbehandlerid',
                        'budsjettansvarligid'=> 'budsjettansvarligid',
                        'oppsynsigndato'        => 'oppsynsigndato',
                        'saksigndato'           => 'saksigndato',
                        'budsjettsigndato'      => 'budsjettsigndato',
                        'merknad'                       => 'merknad',
                        'splitt'                        => 'splitt',
                        'utbetalingid'          => 'utbetalingid',
                        'utbetalingsigndato'=> 'utbetalingsigndato',
                        'kreditnota'            => 'kreditnota'
                );

                function soXport($useacl=True)
                {
                        $this->db = $GLOBALS['phpgw']->db;
                        if($useacl)
                        {
                                $this->grants = 
$GLOBALS['phpgw']->acl->get_grants('property');
                        }
                        $this->account_id = 
$GLOBALS['phpgw_info']['user']['account_id'];


                        if 
($GLOBALS['phpgw_info']['server']['db_type']=='pgsql')
                        {
                                $this->join = " JOIN ";
                        }
                        else
                        {
                                $this->join = " LEFT JOIN ";
                        }
                        return $join;

                }


                function anleggsnr_to_objekt($anleggsnr)
                {
                        $GLOBALS['phpgw']->db->query("select 
fm_bms.point_name,fm_bms.objekt_id,fm_bms.bygg_id,fm_bms.seksjons_id,boei_bydel.omraade_id
 "
                        . " from fm_bms $this->join boei_objekt ON 
fm_bms.objekt_id = boei_objekt.objekt_id $this->join "
            . " boei_bydel ON boei_objekt.bydel_id = boei_bydel.bydel_id where 
fm_bms.id='$anleggsnr'");

                        $GLOBALS['phpgw']->db->next_record();
                        $objekt_id = $GLOBALS['phpgw']->db->f('objekt_id');
                        $bygg_id = $GLOBALS['phpgw']->db->f('bygg_id');
                        $seksjons_id = $GLOBALS['phpgw']->db->f('seksjons_id');
                        $dima=$objekt_id.$bygg_id.$seksjons_id;

                        $maalerinfo['dima']=$dima;
                        
$maalerinfo['maalernr']=$GLOBALS['phpgw']->db->f('point_name');
                        
$maalerinfo['omraade']=$GLOBALS['phpgw']->db->f('omraade_id');
                        return $maalerinfo;
                }
                function check_pmwrkord_code($pmwrkord_code)
                {

                        $GLOBALS['phpgw']->db->query("select count(*) from 
fm_wo_wrkorders where id='$pmwrkord_code'");
                        $GLOBALS['phpgw']->db->next_record();
                        return $GLOBALS['phpgw']->db->f(0);
                }

                function add($owner,$fields,$access='',$cat_id='',$tid='n')
                {

                        $pmwrkord_code=$fields['pmwrkord_code'];
                        $bilagsnr=$fields['bilagsnr'];
                        $splitt=$fields['splitt'];
                        $kildeid=$fields['kildeid'];
                        $kidnr=$fields['kidnr'];
                        $typeid=$fields[typeid];
                        $fakturadato=$fields['fakturadato'];
                        $forfallsdato=$fields['forfallsdato'];
                        $regtid=$fields['regtid'];
                        $artid=$fields['artid'];
                        $godkjentbelop=$fields['godkjentbelop'];
                        $spvend_code=$fields['spvend_code'];
                        $dimb=$fields['dimb'];
                        $oppsynsmannid=$fields['oppsynsmannid'];
                        if ($oppsynsmannid)
                        {
                                $oppsynsmannid_value="'$oppsynsmannid'";
                        }
                        else
                        {
                                $oppsynsmannid_value="Null";
                        }

                        $saksbehandlerid=$fields['saksbehandlerid'];
                        if ($saksbehandlerid)
                        {
                                $saksbehandlerid_value="'$saksbehandlerid'";
                        }
                        else
                        {
                                $saksbehandlerid_value="Null";
                        }

                        $budsjettansvarligid=$fields['budsjettansvarligid'];
                        $fakturanr=$fields['fakturanr'];
                        $spbudact_code=$fields['spbudact_code'];
                        $dima=$fields['dima'];
                        $dimd=$fields['dimd'];
                        $mvakode=$fields['mvakode'];
                        $belop=$fields['belop'];
                        $periode=$fields['periode'];
                        $merknad=$fields['merknad'];

                $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','$bilagsnr','$splitt','$kildeid','$kidnr','$typeid','$fakturadato','$forfallsdato','$regtid','$artid',CONVERT(MONEY,"."'$godkjentbelop'".",0),'$spvend_code','$dimb',$oppsynsmannid_value,$saksbehandlerid_value,'$budsjettansvarligid','$fakturanr','$spbudact_code','$dima','$dimd','$mvakode',CONVERT(MONEY,"."'$belop'".",0),'$periode','$merknad')";

//echo 'sql'.$sql.'<br>';

                        $this->db->query($sql,__LINE__,__FILE__);


                }

        }
?>

***** Error reading new file: [Errno 2] No such file or directory: 
'class.uiXport.inc.php'