WebSVN – eFlore/Applications.cel – Diff – /trunk/jrest/services/InventoryExport.php


<?php
// ATTENTION ! Classe compatible uniquement avec nouveau format de bdd du cel //
 
/**
* PHP Version 5
*
* @category  PHP
* @package   jrest
* @author    David Delon <david@tela-botania.org>
* @author    Aurélien Peronnet <aurelien@tela-botania.org>
* @copyright 2010 Tela-Botanica
* @license   http://www.cecill.info/licences/Licence_CeCILL_V2-fr.txt Licence CECILL
* @version   SVN: <svn_id>
* @link      /doc/jrest/
*/
 
/**
* in:utf8
* out:iso8859
* 
* Export vers feuille de calcul d'une selection de releves
* 
*/
class InventoryExport extends Cel  {
 
	private $extendSpreadsheetProductor;
 
	function InventoryExport($config) {
 
		parent::__construct($config);
 
		$this->extendSpreadsheetProductor = new SpreadsheetProductor();
		$this->extendSpreadsheetProductor->initSpreadsheet();
	}
 
	function getElement($uid){
 
		   // Controle detournement utilisateur
 
		 	$this->controleUtilisateur($uid[0]);
 
			$criteres = array();
			
			$chercheur_observations = new RechercheObservation($this->config);
 
			if(isset($uid[1]))
			{
				$criteres = $chercheur_observations->parserRequeteCriteres($uid[1]);
			}
 
    	    // Creating a workbook
			$workbook = new Spreadsheet_Excel_Writer();
 
			$workbook->send('liste.xls');
 
			// Creating a worksheet
			$worksheet = $workbook->addWorksheet('Liste');
			
            $worksheet->write(0,0,'Espece');
            $worksheet->write(0,1,'Numero nomenclatural');
            $worksheet->write(0,2,'Nom retenu');
            $worksheet->write(0,3,'Numero nomenclatural nom retenu');
            $worksheet->write(0,4,'Numero taxonomique');
            $worksheet->write(0,5,'Famille');
            $worksheet->write(0,6,'Commune');
            $worksheet->write(0,7,'Identifiant Commune');
            $worksheet->write(0,8,'Date');
            $worksheet->write(0,9,'Lieu-dit');
            $worksheet->write(0,10,'Station');
            $worksheet->write(0,11,'Milieu');
            $worksheet->write(0,12,'Notes');
            $worksheet->write(0,13,'Latitude');
            $worksheet->write(0,14,'Longitude');
            $worksheet->write(0,15,'Referentiel Geographique');
            
            $numero_page = isset($criteres['numero_page']) ? $criteres['numero_page'] : 0;
            $limite = isset($criteres['limite']) ? $criteres['limite'] : 50;
 
			$observations = $chercheur_observations->rechercherObservations($uid[0], $criteres, $numero_page, $limite);
 
			$i=1;
			foreach ($observations as $obs) {
 
				$obs = $this->denullifierTableauValeurCel(&$obs);
 
			  	if ($obs['date_observation'] != "0000-00-00 00:00:00") {
	                $obs['date_observation'] = $this->formaterDate($obs['date_observation']);
	        	}
	        	else {
	                $obs['date_observation']="00/00/0000";
	        	}
 
                $worksheet->write($i,0,$obs['nom_sel']);
                $worksheet->write($i,1,$obs['nom_sel_nn']);
                $worksheet->write($i,2,$obs['nom_ret']);
                $worksheet->write($i,3,$obs['nom_ret_nn']);
                $worksheet->write($i,4,$obs['nt']);
                $worksheet->write($i,5,$obs['famille']);
                $worksheet->write($i,6,$obs['zone_geo']);
                $worksheet->write($i,7,$this->convertirCodeZoneGeoVersDepartement($obs['ce_zone_geo']));
                $worksheet->write($i,8,$obs['date_observation']);
                $worksheet->write($i,9,$obs['lieudit']);
                $worksheet->write($i,10,$obs['station']);
                $worksheet->write($i,11,$obs['milieu']);
                $worksheet->write($i,12,$obs['commentaire']);
                $worksheet->write($i,13,$obs['latitude']);
                $worksheet->write($i,14,$obs['longitude']);
                $worksheet->write($i,15,$obs['geodatum']);
                $i++;
    	    }
 
			$workbook->close();
 
			exit();
	}
}
/* +--Fin du code ---------------------------------------------------------------------------------------+
* $Log$
* Revision 1.7  2008-11-13 11:29:12  ddelon
* Reecriture gwt-ext
*
* Revision 1.6  2008-01-30 08:57:28  ddelon
* fin mise en place mygwt
*
* Revision 1.5  2007-06-06 13:31:16  ddelon
* v0.09
*
* Revision 1.4  2007-05-22 12:54:09  ddelon
* Securisation acces utilisateur
*/
?>

Subversion Repositories eFlore/Applications.cel

(root)/trunk/jrest/services/InventoryExport.php – Rev 984 → 996

Rev 984		Rev 996
1	`<?php`	1	`<?php`
2	`// ATTENTION ! Classe compatible uniquement avec nouveau format de bdd du cel //`	2	`// ATTENTION ! Classe compatible uniquement avec nouveau format de bdd du cel //`
3		3
4	`/**`	4	`/**`
5	`* PHP Version 5`	5	`* PHP Version 5`
6	`*`	6	`*`
7	`* @category PHP`	7	`* @category PHP`
8	`* @package jrest`	8	`* @package jrest`
9	`* @author David Delon <david@tela-botania.org>`	9	`* @author David Delon <david@tela-botania.org>`
10	`* @author Aurélien Peronnet <aurelien@tela-botania.org>`	10	`* @author Aurélien Peronnet <aurelien@tela-botania.org>`
11	`* @copyright 2010 Tela-Botanica`	11	`* @copyright 2010 Tela-Botanica`
12	`* @license http://www.cecill.info/licences/Licence_CeCILL_V2-fr.txt Licence CECILL`	12	`* @license http://www.cecill.info/licences/Licence_CeCILL_V2-fr.txt Licence CECILL`
13	`* @version SVN: <svn_id>`	13	`* @version SVN: <svn_id>`
14	`* @link /doc/jrest/`	14	`* @link /doc/jrest/`
15	`*/`	15	`*/`
16		16
17	`/**`	17	`/**`
18	`* in:utf8`	18	`* in:utf8`
19	`* out:iso8859`	19	`* out:iso8859`
20	`*`	20	`*`
21	`* Export vers feuille de calcul d'une selection de releves`	21	`* Export vers feuille de calcul d'une selection de releves`
22	`*`	22	`*`
23	`*/`	23	`*/`
24	`class InventoryExport extends Cel {`	24	`class InventoryExport extends Cel {`
25		25
26	`private $extendSpreadsheetProductor;`	26	`private $extendSpreadsheetProductor;`
27		27
28	`function InventoryExport($config) {`	28	`function InventoryExport($config) {`
29		29
30	`parent::__construct($config);`	30	`parent::__construct($config);`
31		31
32	`$this->extendSpreadsheetProductor = new SpreadsheetProductor();`	32	`$this->extendSpreadsheetProductor = new SpreadsheetProductor();`
33	`$this->extendSpreadsheetProductor->initSpreadsheet();`	33	`$this->extendSpreadsheetProductor->initSpreadsheet();`
34	`}`	34	`}`
35		35
36	`function getElement($uid){`	36	`function getElement($uid){`
37		37
38	`// Controle detournement utilisateur`	38	`// Controle detournement utilisateur`
39	`session_start();`	-
40	`$this->controleUtilisateur($uid[0]);`	39	`$this->controleUtilisateur($uid[0]);`
41		40
42	`$criteres = array();`	41	`$criteres = array();`
43		42
44	`$chercheur_observations = new RechercheObservation($this->config);`	43	`$chercheur_observations = new RechercheObservation($this->config);`
45		44
46	`if(isset($uid[1]))`	45	`if(isset($uid[1]))`
47	`{`	46	`{`
48	`$criteres = $chercheur_observations->parserRequeteCriteres($uid[1]);`	47	`$criteres = $chercheur_observations->parserRequeteCriteres($uid[1]);`
49	`}`	48	`}`
50		49
51	`// Creating a workbook`	50	`// Creating a workbook`
52	`$workbook = new Spreadsheet_Excel_Writer();`	51	`$workbook = new Spreadsheet_Excel_Writer();`
53		52
54	`$workbook->send('liste.xls');`	53	`$workbook->send('liste.xls');`
55		54
56	`// Creating a worksheet`	55	`// Creating a worksheet`
57	`$worksheet = $workbook->addWorksheet('Liste');`	56	`$worksheet = $workbook->addWorksheet('Liste');`
58		57
59	`$worksheet->write(0,0,'Espece');`	58	`$worksheet->write(0,0,'Espece');`
60	`$worksheet->write(0,1,'Numero nomenclatural');`	59	`$worksheet->write(0,1,'Numero nomenclatural');`
61	`$worksheet->write(0,2,'Nom retenu');`	60	`$worksheet->write(0,2,'Nom retenu');`
62	`$worksheet->write(0,3,'Numero nomenclatural nom retenu');`	61	`$worksheet->write(0,3,'Numero nomenclatural nom retenu');`
63	`$worksheet->write(0,4,'Numero taxonomique');`	62	`$worksheet->write(0,4,'Numero taxonomique');`
64	`$worksheet->write(0,5,'Famille');`	63	`$worksheet->write(0,5,'Famille');`
65	`$worksheet->write(0,6,'Commune');`	64	`$worksheet->write(0,6,'Commune');`
66	`$worksheet->write(0,7,'Identifiant Commune');`	65	`$worksheet->write(0,7,'Identifiant Commune');`
67	`$worksheet->write(0,8,'Date');`	66	`$worksheet->write(0,8,'Date');`
68	`$worksheet->write(0,9,'Lieu-dit');`	67	`$worksheet->write(0,9,'Lieu-dit');`
69	`$worksheet->write(0,10,'Station');`	68	`$worksheet->write(0,10,'Station');`
70	`$worksheet->write(0,11,'Milieu');`	69	`$worksheet->write(0,11,'Milieu');`
71	`$worksheet->write(0,12,'Notes');`	70	`$worksheet->write(0,12,'Notes');`
72	`$worksheet->write(0,13,'Latitude');`	71	`$worksheet->write(0,13,'Latitude');`
73	`$worksheet->write(0,14,'Longitude');`	72	`$worksheet->write(0,14,'Longitude');`
74	`$worksheet->write(0,15,'Referentiel Geographique');`	73	`$worksheet->write(0,15,'Referentiel Geographique');`
75		74
76	`$numero_page = isset($criteres['numero_page']) ? $criteres['numero_page'] : 0;`	75	`$numero_page = isset($criteres['numero_page']) ? $criteres['numero_page'] : 0;`
77	`$limite = isset($criteres['limite']) ? $criteres['limite'] : 50;`	76	`$limite = isset($criteres['limite']) ? $criteres['limite'] : 50;`
78		77
79	`$observations = $chercheur_observations->rechercherObservations($uid[0], $criteres, $numero_page, $limite);`	78	`$observations = $chercheur_observations->rechercherObservations($uid[0], $criteres, $numero_page, $limite);`
80		79
81	`$i=1;`	80	`$i=1;`
82	`foreach ($observations as $obs) {`	81	`foreach ($observations as $obs) {`
83		82
84	`$obs = $this->denullifierTableauValeurCel(&$obs);`	83	`$obs = $this->denullifierTableauValeurCel(&$obs);`
85		84
86	`if ($obs['date_observation'] != "0000-00-00 00:00:00") {`	85	`if ($obs['date_observation'] != "0000-00-00 00:00:00") {`
87	`$obs['date_observation'] = $this->formaterDate($obs['date_observation']);`	86	`$obs['date_observation'] = $this->formaterDate($obs['date_observation']);`
88	`}`	87	`}`
89	`else {`	88	`else {`
90	`$obs['date_observation']="00/00/0000";`	89	`$obs['date_observation']="00/00/0000";`
91	`}`	90	`}`
92		91
93	`$worksheet->write($i,0,$obs['nom_sel']);`	92	`$worksheet->write($i,0,$obs['nom_sel']);`
94	`$worksheet->write($i,1,$obs['nom_sel_nn']);`	93	`$worksheet->write($i,1,$obs['nom_sel_nn']);`
95	`$worksheet->write($i,2,$obs['nom_ret']);`	94	`$worksheet->write($i,2,$obs['nom_ret']);`
96	`$worksheet->write($i,3,$obs['nom_ret_nn']);`	95	`$worksheet->write($i,3,$obs['nom_ret_nn']);`
97	`$worksheet->write($i,4,$obs['nt']);`	96	`$worksheet->write($i,4,$obs['nt']);`
98	`$worksheet->write($i,5,$obs['famille']);`	97	`$worksheet->write($i,5,$obs['famille']);`
99	`$worksheet->write($i,6,$obs['zone_geo']);`	98	`$worksheet->write($i,6,$obs['zone_geo']);`
100	`$worksheet->write($i,7,$this->convertirCodeZoneGeoVersDepartement($obs['ce_zone_geo']));`	99	`$worksheet->write($i,7,$this->convertirCodeZoneGeoVersDepartement($obs['ce_zone_geo']));`
101	`$worksheet->write($i,8,$obs['date_observation']);`	100	`$worksheet->write($i,8,$obs['date_observation']);`
102	`$worksheet->write($i,9,$obs['lieudit']);`	101	`$worksheet->write($i,9,$obs['lieudit']);`
103	`$worksheet->write($i,10,$obs['station']);`	102	`$worksheet->write($i,10,$obs['station']);`
104	`$worksheet->write($i,11,$obs['milieu']);`	103	`$worksheet->write($i,11,$obs['milieu']);`
105	`$worksheet->write($i,12,$obs['commentaire']);`	104	`$worksheet->write($i,12,$obs['commentaire']);`
106	`$worksheet->write($i,13,$obs['latitude']);`	105	`$worksheet->write($i,13,$obs['latitude']);`
107	`$worksheet->write($i,14,$obs['longitude']);`	106	`$worksheet->write($i,14,$obs['longitude']);`
108	`$worksheet->write($i,15,$obs['geodatum']);`	107	`$worksheet->write($i,15,$obs['geodatum']);`
109	`$i++;`	108	`$i++;`
110	`}`	109	`}`
111		110
112	`$workbook->close();`	111	`$workbook->close();`
113		112
114	`exit();`	113	`exit();`
115	`}`	114	`}`
116	`}`	115	`}`
117	`/* +--Fin du code ---------------------------------------------------------------------------------------+`	116	`/* +--Fin du code ---------------------------------------------------------------------------------------+`
118	`* $Log$`	117	`* $Log$`
119	`* Revision 1.7 2008-11-13 11:29:12 ddelon`	118	`* Revision 1.7 2008-11-13 11:29:12 ddelon`
120	`* Reecriture gwt-ext`	119	`* Reecriture gwt-ext`
121	`*`	120	`*`
122	`* Revision 1.6 2008-01-30 08:57:28 ddelon`	121	`* Revision 1.6 2008-01-30 08:57:28 ddelon`
123	`* fin mise en place mygwt`	122	`* fin mise en place mygwt`
124	`*`	123	`*`
125	`* Revision 1.5 2007-06-06 13:31:16 ddelon`	124	`* Revision 1.5 2007-06-06 13:31:16 ddelon`
126	`* v0.09`	125	`* v0.09`
127	`*`	126	`*`
128	`* Revision 1.4 2007-05-22 12:54:09 ddelon`	127	`* Revision 1.4 2007-05-22 12:54:09 ddelon`
129	`* Securisation acces utilisateur`	128	`* Securisation acces utilisateur`
130	`*/`	129	`*/`
131	`?>`	130	`?>`