[Phpgroupware-cvs] CVS: property/inc/export Kemner_kvittering,1.1,1.2

[Sigurd Nes <address@hidden>]

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

Modified Files:
        Kemner_kvittering 
Log Message:
no message

Index: Kemner_kvittering
===================================================================
RCS file: /cvsroot/phpgroupware/property/inc/export/Kemner_kvittering,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -r1.1 -r1.2
*** Kemner_kvittering   21 Dec 2002 12:49:09 -0000      1.1
--- Kemner_kvittering   31 Mar 2003 21:14:14 -0000      1.2
***************
*** 11,16 ****
                        $this->$config->read_repository();
                        
!               }
  
  
                function overfor($download)
--- 11,26 ----
                        $this->$config->read_repository();
                        
!                       $this->db = $GLOBALS['phpgw']->db;
  
+                       if 
($GLOBALS['phpgw_info']['server']['db_type']=='pgsql')
+                       {
+                               $this->join = " JOIN ";
+                       }
+                       else
+                       {
+                               $this->join = " LEFT JOIN ";
+                       }
+ 
+               }
  
                function overfor($download)
***************
*** 23,48 ****
                        $periode = 
$this->select_periods_with_invoice_to_transfer();
                
                        for ($i=0;$i<count($periode);$i++)
                        {
!                               $message .= 
$this->OverforPeriode($batchid,$periode[$i],$download);
                        }
  
                        return $message;
!               }
!               
                function select_periods_with_invoice_to_transfer()
                {
!                       $sql= "select distinct periode from v_ecohovedbilag 
where not budsjettsigndato is null and (not saksigndato is null or not 
oppsynsigndato is null) and not utbetalingsigndato is null and spvend_code 
='20003' ";
!                       $GLOBALS['phpgw']->db->query($sql,__LINE__,__FILE__);
                        $i = 0;
!                       while ($GLOBALS['phpgw']->db->next_record())
                        {
!                               $periode[$i]    = 
$GLOBALS['phpgw']->db->f('periode');
                                $i++;
                        }
                        return $periode;
                }
- 
- 
  
                function errorhandler($error_desr)
--- 33,59 ----
                        $periode = 
$this->select_periods_with_invoice_to_transfer();
                
+ 
                        for ($i=0;$i<count($periode);$i++)
                        {
!                               $message[$i]['msg'] = 
$this->OverforPeriode($batchid,$periode[$i],$download);
                        }
  
+ 
                        return $message;
!               }               
! 
                function select_periods_with_invoice_to_transfer()
                {
!                       $sql= "select distinct periode from t_ecobilag where 
budsjettsigndato is not null and (saksigndato is not null or oppsynsigndato is 
not null) and utbetalingsigndato is not null and spvend_code ='20003' ";
!                       $this->db->query($sql,__LINE__,__FILE__);
                        $i = 0;
!                       while ($this->db->next_record())
                        {
!                               $periode[$i]    = $this->db->f('periode');
                                $i++;
                        }
+ //_debug_array($periode);
                        return $periode;
                }
  
                function errorhandler($error_desr)