[Phpgroupware-cvs] property/inc/cron export_info_as_files.php

[Sigurd Nes]

CVSROOT:        /sources/phpgroupware
Module name:    property
Changes by:     Sigurd Nes <sigurdne>   07/08/15 13:59:21

Added files:
        inc/cron       : export_info_as_files.php 

Log message:
        Export info as xls or csv as cron-job to files

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/property/inc/cron/export_info_as_files.php?cvsroot=phpgroupware&rev=1.1

Patches:
Index: export_info_as_files.php
===================================================================
RCS file: export_info_as_files.php
diff -N export_info_as_files.php
--- /dev/null   1 Jan 1970 00:00:00 -0000
+++ export_info_as_files.php    15 Aug 2007 13:59:21 -0000      1.1
@@ -0,0 +1,301 @@
+<?php
+       /**
+       * phpGroupWare - property: a Facilities Management System.
+       *
+       * @author Sigurd Nes <address@hidden>
+       * @copyright Copyright (C) 2003,2004,2005,2006,2007 Free Software 
Foundation, Inc. http://www.fsf.org/
+       * This file is part of phpGroupWare.
+       *
+       * phpGroupWare 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.
+       *
+       * phpGroupWare is distributed in the hope that it will be useful,
+       * but WITHOUT ANY WARRANTY; without even the implied warranty of
+       * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+       * GNU General Public License for more details.
+       *
+       * You should have received a copy of the GNU General Public License
+       * along with phpGroupWare; if not, write to the Free Software
+       * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301 
 USA
+       *
+       * @license http://www.gnu.org/licenses/gpl.html GNU General Public 
License
+       * @internal Development of this application was funded by 
http://www.bergen.kommune.no/bbb_/ekstern/
+       * @package property
+       * @subpackage custom
+       * @version $Id: export_info_as_files.php,v 1.1 2007/08/15 13:59:21 
sigurdne Exp $
+       */
+
+       /**
+        * Description
+        * @package property
+        */
+
+       class export_info_as_files
+       {
+               var     $function_name = 'export_info_as_files';
+
+               function export_info_as_files()
+               {
+                       $this->currentapp               = 
$GLOBALS['phpgw_info']['flags']['currentapp'];
+                       $this->bocommon                 = 
CreateObject($this->currentapp.'.bocommon');
+                       $this->db                       = & 
$GLOBALS['phpgw']->db;
+                       $this->db2                              = 
clone($this->db);
+                       $this->soadmin_location = 
CreateObject($this->currentapp.'.soadmin_location');
+
+                       $this->join                             = 
$this->db->join;
+                       $this->like                             = 
$this->db->like;
+                       $this->left_join                = " LEFT JOIN ";
+                       $this->saveto                   = 
'/mnt/filer2/VaktPC_filer';
+               //      $this->export_method = 'csv';
+                       $this->export_method = 'excel'; 
+
+               }
+
+               function pre_run($data='')
+               {
+                       if($data['enabled']==1)
+                       {
+                               $confirm        = True;
+                               $cron           = True;
+                       }
+                       else
+                       {
+                               $confirm        = 
get_var('confirm',array('POST'));
+                               $execute        = 
get_var('execute',array('GET'));
+                       }
+
+                       if ($confirm)
+                       {
+                               $this->execute($cron);
+                       }
+                       else
+                       {
+                               $this->confirm($execute=False);
+                       }
+               }
+
+
+               function confirm($execute='')
+               {
+                       $link_data = array
+                       (
+                               'menuaction' => 
$this->currentapp.'.custom_functions.index',
+                               'function'      =>$this->function_name,
+                               'execute'       => $execute,
+                       );
+
+
+                       if(!$execute)
+                       {
+                               $lang_confirm_msg       = lang('do you want to 
perform this action');
+                       }
+
+                       $lang_yes                       = lang('yes');
+
+                       
$GLOBALS['phpgw']->xslttpl->add_file(array('confirm_custom'));
+
+
+                       $msgbox_data = 
$this->bocommon->msgbox_data($this->receipt);
+
+                       $data = array
+                       (
+                               'msgbox_data'                   => 
$GLOBALS['phpgw']->common->msgbox($msgbox_data),
+                               'done_action'                   => 
$GLOBALS['phpgw']->link('/admin/index.php'),
+                               'run_action'                    => 
$GLOBALS['phpgw']->link('/index.php',$link_data),
+                               'message'                               => 
$this->receipt['message'],
+                               'lang_confirm_msg'              => 
$lang_confirm_msg,
+                               'lang_yes'                              => 
$lang_yes,
+                               'lang_yes_statustext'   => lang('Export info as 
files'),
+                               'lang_no_statustext'    => 'tilbake',
+                               'lang_no'                               => 
lang('no'),
+                               'lang_done'                             => 
'Avbryt',
+                               'lang_done_statustext'  => 'tilbake'
+                       );
+
+                       $appname                = lang('location');
+                       $function_msg   = lang('Export info as files');
+                       $GLOBALS['phpgw_info']['flags']['app_header'] = 
lang($this->currentapp) . ' - ' . $appname . ': ' . $function_msg;
+                       
$GLOBALS['phpgw']->xslttpl->set_var('phpgw',array('confirm' => $data));
+                       $GLOBALS['phpgw']->xslttpl->pp();
+               }
+
+               function execute($cron='')
+               {
+
+                       $this->export_heiser();
+                       $this->export_brannalarm();
+                       $this->export_ventilasjon();
+                       $this->export_kabeltv();
+                       $this->export_sprinkler();
+                       $this->export_smokevent();
+
+
+                       if(!$cron)
+                       {
+                               $this->confirm($execute=False);
+                       }
+
+                       $msgbox_data = 
$this->bocommon->msgbox_data($this->receipt);
+
+                       $insert_values= array(
+                               $cron,
+                               date($this->bocommon->datetimeformat),
+                               $this->function_name,
+                               implode(',',(array_keys($msgbox_data)))
+                               );
+
+                       $insert_values  = 
$this->bocommon->validate_db_insert($insert_values);
+
+                       $sql = "INSERT INTO fm_cron_log 
(cron,cron_date,process,message) "
+                                       . "VALUES ($insert_values)";
+                       $this->db->query($sql,__LINE__,__FILE__);
+               }
+
+               function export_heiser()
+               {
+                       $descr = 
array('ID','Lokalisering','Adresse','status','Garanti 
faser','servicefrekvens','service firma','tlf service',
+                               'tlf 
service','Alarmtype','merknad_telefon','nhk_nummer','fabrikasjons_nr','heis_type',
+                               'Alarm til', 'Service kontrakt','Merknad');
+                       $name = array('num', 'location_code', 'address', 
'status', 'garanti_faser', 'servicefrekvens',
+                       'service_firma', 'tlf_service', 'tlf_heishus', 
'alarmtype', 'merknad_telefon', 'nhk_nummer',
+                       'fabrikasjons_nr', 'heis_type', 'alarm_til', 
'service_kontrakt', 'merknad');
+                       
+                       $filename= 'HEISER';
+                       $sql = "SELECT * from fm_entity_1_1";
+
+                       $this->export_to_file($name,$descr,$filename, $sql);
+               }
+
+               function export_to_file($name,$descr,$filename, $sql)
+               {
+                       switch ($this->export_method)
+                       {
+                               case 'excel':
+                                       
$this->export_as_excel($name,$descr,$filename, $sql);
+                                       break;
+                               case 'csv':
+                                       
$this->export_as_csv($name,$descr,$filename, $sql);
+                                       break;
+                       }
+               
+               }
+
+               function export_brannalarm()
+               {
+                       $descr = array('ID', 'Objekt', 'Bygg', 'Inngang', 
'addresse', 'adresserbart', 'service_firma', 'Leverandør kontakt', 
'vakttelefon', 'merknad_bbb', 'type anlegg', 'sprinkelanlegg', 'securitnet nr', 
'tidsforsinkelse', 'Telenor tlf 1', 'Telenor tlf 12', 'BBB vakt 24 T');
+                       $name = array('num', 'loc1', 'loc2', 'loc3', 'address', 
'adreserbart', 'service_firma', 'lev_kontakt', 'vakttelefon', 'merknad_bbb', 
'type_anlegg', 'sprinkel', 'securitnet_nr', 'tidsforsinkelse', 'telenor_1', 
'telenor_2', 'vakt_24_bbb');
+                       
+                       $filename= 'BRANNALARMER';
+                       $sql = "SELECT * from fm_entity_1_2";
+
+                       $this->export_to_file($name,$descr,$filename, $sql);
+               }
+
+               function export_ventilasjon()
+               {
+                       $descr = array('ID', 'Objekt', 'Bygg', 'addresse', 
'status', 'Anleggs type', 'Aggregat type', 'Filtertype', 'Antall filte', 
'Plassering', 'Merknad');
+                       $name = array('num', 'loc1', 'loc2', 'address', 
'status', 'v_type', 'aggr_type', 'filtertype', 'f_antall', 'plassering', 
'merknad');
+                       
+                       $filename= 'VENTILASJON';
+                       $sql = "SELECT * from fm_entity_1_7";
+
+                       $this->export_to_file($name,$descr,$filename, $sql);
+               }
+
+               function export_kabeltv()
+               {
+                       $descr = array('ID', 'Objekt', 'Bygg', 'addresse', 
'antall leiligh. PT', 'leverandør', 'kontakt person', 'kotakt tlf (bbb)', 
'kotakt tlf (beboer)', 'Kunde nr leverandør', 'Kunde nr PT', 'Nett nr 
Post/tele', 'merknad');
+                       $name = array('num', 'loc1', 'loc2', 'address', 
'ant_leil_pt', 'leverandor', 'kontakt_person', 'k_tlf_bbb', 'k_tlf_beboer', 
'kunde_nr_lev', 'kunde_nr_pt', 'nett_nr_pt', 'merknad');
+                       
+                       $filename= 'KABEL-TV';
+                       $sql = "SELECT * from fm_entity_1_3";
+
+                       $this->export_to_file($name,$descr,$filename, $sql);
+               }
+
+               function export_sprinkler()
+               {
+                       $descr = array('ID', 'Objekt', 'Bygg', 'Inngang', 
'addresse', 'status', 'eier', 'type anlegg', 'Drift start', 'Leverandør', 
'Telefon nr', 'Kontakt person', 'service avtale', 'plassering av sentral', 
'merknad');
+                       $name = array('num', 'loc1', 'loc2', 'loc3', 'address', 
'status', 'eier', 'type', 'dr_start', 'org_name', 'lev_tlf', 'kont_person', 
'service_avtale', 'plassering', 'merknad');
+                       
+                       $filename= 'SPRINKLER';
+                       $sql = "SELECT fm_entity_1_9.* , fm_vendor.org_name 
from fm_entity_1_9 left join fm_vendor on fm_entity_1_9.leverandor = 
fm_vendor.id ";
+
+                       $this->export_to_file($name,$descr,$filename, $sql);
+               }
+
+
+               function export_smokevent()
+               {
+                       $descr = array('ID', 'Objekt', 'Bygg', 'addresse', 
'status', 'beskrivelse', 'merknad');
+                       $name = array('num', 'loc1', 'loc2', 'address', 
'status', 'beskrivelse', 'merknad');
+                       
+                       $filename= 'ROYKVENTILASJON';
+                       $sql = "SELECT * from fm_entity_1_8";
+
+                       $this->export_to_file($name,$descr,$filename, $sql);
+               }
+
+               
+               function export_as_excel($name,$descr,$filename, $sql)
+               {
+                       $workbook       = 
CreateObject('phpgwapi.excel',$this->saveto . SEP . $filename . '.xls');
+
+                       $worksheet1 =& $workbook->add_worksheet('First One');
+
+                       $this->db->query($sql,__LINE__,__FILE__);
+                       
+                       for ($i=0;$i<count($descr);$i++)
+                       {
+                               $worksheet1->write_string(0, $i, 
$this->bocommon->utf2ascii($descr[$i]));
+                       }
+
+                       $worksheet1->write_string(0, $i, lang('date'));
+                       
+                       $line =1;
+                       while ($this->db->next_record())
+                       {
+                               for ($i=0;$i<count($name);$i++)
+                               {
+                                       $worksheet1->write($line,$i, 
$this->bocommon->utf2ascii($this->db->f($name[$i])));                           
           
+                               }
+                               $worksheet1->write($line,$i, 
$GLOBALS['phpgw']->common->show_date(time(),$GLOBALS['phpgw_info']['user']['preferences']['common']['dateformat']));
+                               $line++;
+                       }
+                       
+                       
+                       $workbook->close();
+               }
+
+               function export_as_csv($name,$descr,$filename, $sql)
+               {
+
+                       $fp = fopen($this->saveto . SEP . $filename . 
'.csv','w');
+                       
+                   $descr[] = lang('date');
+                   fputcsv($fp, $descr, ';');
+
+                       $this->db->query($sql,__LINE__,__FILE__);
+                                               
+                       $j=0;
+                       while ($this->db->next_record())
+                       {
+                               for ($i=0;$i<count($name);$i++)
+                               {
+                                       $content[$j][] = 
str_replace(array("\r","\n")," 
",$this->bocommon->utf2ascii($this->db->f($name[$i])));
+                               }
+                               $content[$j][] = 
$GLOBALS['phpgw']->common->show_date(time(),$GLOBALS['phpgw_info']['user']['preferences']['common']['dateformat']);
+                               $j++;
+                       }
+
+                       foreach ($content as $line)
+                       {
+                           fputcsv($fp, $line, ';');
+                       }
+
+                       fclose($fp);                    
+               }
+       }
+?>