Subversion Repositories eFlore/Applications.cel

Rev

Rev 1398 | Rev 1571 | Go to most recent revision | Only display areas with differences | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 1398 Rev 1527
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 
		 	$this->controleUtilisateur($uid[0]);
 39 
		 	$this->controleUtilisateur($uid[0]);
40 
 
 40 
 
41 
			$criteres = $_GET;
41 
			$criteres = $_GET;
42 
			$chercheur_observations = new RechercheObservation($this->config);
 42 
			$chercheur_observations = new RechercheObservation($this->config);
43 
 
 43 
 
44 
    	    // Creating a workbook
 44 
    	    // Creating a workbook
45 
			$workbook = new Spreadsheet_Excel_Writer();
 45 
			$workbook = new Spreadsheet_Excel_Writer();
46 
 
 46 
 
47 
			$workbook->send('liste.xls');
 47 
			$workbook->send('liste.xls');
48 
 
 48 
 
49 
			// Creating a worksheet
 49 
			// Creating a worksheet
50 
			$worksheet = $workbook->addWorksheet('Liste');
 50 
			$worksheet = $workbook->addWorksheet('Liste');
51
51
52 
            $worksheet->write(0,0,'Espece');
 52 
            $worksheet->write(0,0,'Espece');
53 
            $worksheet->write(0,1,'Numero nomenclatural');
 53 
            $worksheet->write(0,1,'Numero nomenclatural');
54 
            $worksheet->write(0,2,'Nom retenu');
 54 
            $worksheet->write(0,2,'Nom retenu');
55 
            $worksheet->write(0,3,'Numero nomenclatural nom retenu');
 55 
            $worksheet->write(0,3,'Numero nomenclatural nom retenu');
56 
            $worksheet->write(0,4,'Numero taxonomique');
 56 
            $worksheet->write(0,4,'Numero taxonomique');
57 
            $worksheet->write(0,5,'Famille');
 57 
            $worksheet->write(0,5,'Famille');
- 
 
 58 
            $worksheet->write(0,6,'Referentiel taxonomique');
58 
            $worksheet->write(0,6,'Commune');
 59 
            $worksheet->write(0,7,'Commune');
59 
            $worksheet->write(0,7,'Identifiant Commune');
 60 
            $worksheet->write(0,8,'Identifiant Commune');
60 
            $worksheet->write(0,8,'Date');
 61 
            $worksheet->write(0,9,'Date');
61 
            $worksheet->write(0,9,'Lieu-dit');
 62 
            $worksheet->write(0,10,'Lieu-dit');
62 
            $worksheet->write(0,10,'Station');
 63 
            $worksheet->write(0,11,'Station');
63 
            $worksheet->write(0,11,'Milieu');
 64 
            $worksheet->write(0,12,'Milieu');
64 
            $worksheet->write(0,12,'Notes');
 65 
            $worksheet->write(0,13,'Notes');
65 
            $worksheet->write(0,13,'Latitude');
 66 
            $worksheet->write(0,14,'Latitude');
66 
            $worksheet->write(0,14,'Longitude');
 67 
            $worksheet->write(0,15,'Longitude');
67 
            $worksheet->write(0,15,'Referentiel Geographique');
 68 
            $worksheet->write(0,16,'Referentiel Geographique');
68 
            $worksheet->write(0,16,'Ordre');
 69 
            $worksheet->write(0,17,'Ordre');
69 
            $worksheet->write(0,17,'Identifiant');
 70 
            $worksheet->write(0,18,'Identifiant');
70
71
71 
            $numero_page = isset($criteres['numero_page']) ? $criteres['numero_page'] : 0;
 72 
            $numero_page = isset($criteres['numero_page']) ? $criteres['numero_page'] : 0;
72 
            $limite = isset($criteres['limite']) ? $criteres['limite'] : 0;
 73 
            $limite = isset($criteres['limite']) ? $criteres['limite'] : 0;
73 
 
 74 
 
74 
			$observations = $chercheur_observations->rechercherObservations($uid[0], $criteres, $numero_page, $limite);
 75 
			$observations = $chercheur_observations->rechercherObservations($uid[0], $criteres, $numero_page, $limite);
75 
 
 76 
 
76 
			$i=1;
 77 
			$i=1;
77 
			foreach ($observations as $obs) {
 78 
			foreach ($observations as $obs) {
78 
 
 79 
 
79 
				$obs = $this->denullifierTableauValeurCel(&$obs);
 80 
				$obs = $this->denullifierTableauValeurCel(&$obs);
80 
 
 81 
 
81 
			  	if ($obs['date_observation'] != "0000-00-00 00:00:00") {
 82 
			  	if ($obs['date_observation'] != "0000-00-00 00:00:00") {
82 
	                $obs['date_observation'] = $this->formaterDate($obs['date_observation']);
 83 
	                $obs['date_observation'] = $this->formaterDate($obs['date_observation']);
83 
	        	}
 84 
	        	}
84 
	        	else {
 85 
	        	else {
85 
	                $obs['date_observation']="00/00/0000";
 86 
	                $obs['date_observation']="00/00/0000";
86 
	        	}
 87 
	        	}
87 
 
 88 
 
88 
                $worksheet->write($i,0,$obs['nom_sel']);
 89 
                $worksheet->write($i,0,$obs['nom_sel']);
89 
                $worksheet->write($i,1,$obs['nom_sel_nn']);
 90 
                $worksheet->write($i,1,$obs['nom_sel_nn']);
90 
                $worksheet->write($i,2,$obs['nom_ret']);
 91 
                $worksheet->write($i,2,$obs['nom_ret']);
91 
                $worksheet->write($i,3,$obs['nom_ret_nn']);
 92 
                $worksheet->write($i,3,$obs['nom_ret_nn']);
92 
                $worksheet->write($i,4,$obs['nt']);
 93 
                $worksheet->write($i,4,$obs['nt']);
93 
                $worksheet->write($i,5,$obs['famille']);
 94 
                $worksheet->write($i,5,$obs['famille']);
- 
 
 95 
                $worksheet->write($i,6,$obs['nom_referentiel']);
94 
                $worksheet->write($i,6,$obs['zone_geo']);
 96 
                $worksheet->write($i,7,$obs['zone_geo']);
95 
                $worksheet->write($i,7,$this->convertirCodeZoneGeoVersDepartement($obs['ce_zone_geo']));
 97 
                $worksheet->write($i,8,$this->convertirCodeZoneGeoVersDepartement($obs['ce_zone_geo']));
96 
                $worksheet->write($i,8,$obs['date_observation']);
 98 
                $worksheet->write($i,9,$obs['date_observation']);
97 
                $worksheet->write($i,9,$obs['lieudit']);
 99 
                $worksheet->write($i,10,$obs['lieudit']);
98 
                $worksheet->write($i,10,$obs['station']);
 100 
                $worksheet->write($i,11,$obs['station']);
99 
                $worksheet->write($i,11,$obs['milieu']);
 101 
                $worksheet->write($i,12,$obs['milieu']);
100 
                $worksheet->write($i,12,$obs['commentaire']);
 102 
                $worksheet->write($i,13,$obs['commentaire']);
101 
                $worksheet->write($i,13,$obs['latitude']);
 103 
                $worksheet->write($i,14,$obs['latitude']);
102 
                $worksheet->write($i,14,$obs['longitude']);
 104 
                $worksheet->write($i,15,$obs['longitude']);
103 
                $worksheet->write($i,15,$obs['geodatum']);
 105 
                $worksheet->write($i,16,$obs['geodatum']);
104 
                $worksheet->write($i,16,$obs['ordre']);
 106 
                $worksheet->write($i,17,$obs['ordre']);
105 
                $worksheet->write($i,17,$obs['id_observation']);
 107 
                $worksheet->write($i,18,$obs['id_observation']);
106 
                $i++;
 108 
                $i++;
107 
    	    }
 109 
    	    }
108 
 
 110 
 
109 
			$workbook->close();
 111 
			$workbook->close();
110 
 
 112 
 
111 
			exit();
 113 
			exit();
112 
	}
 114 
	}
113 
}
 115 
}
114 
/* +--Fin du code ---------------------------------------------------------------------------------------+
 116 
/* +--Fin du code ---------------------------------------------------------------------------------------+
115 
* $Log$
 117 
* $Log$
116 
* Revision 1.7  2008-11-13 11:29:12  ddelon
 118 
* Revision 1.7  2008-11-13 11:29:12  ddelon
117 
* Reecriture gwt-ext
 119 
* Reecriture gwt-ext
118 
*
 120 
*
119 
* Revision 1.6  2008-01-30 08:57:28  ddelon
 121 
* Revision 1.6  2008-01-30 08:57:28  ddelon
120 
* fin mise en place mygwt
 122 
* fin mise en place mygwt
121 
*
 123 
*
122 
* Revision 1.5  2007-06-06 13:31:16  ddelon
 124 
* Revision 1.5  2007-06-06 13:31:16  ddelon
123 
* v0.09
 125 
* v0.09
124 
*
 126 
*
125 
* Revision 1.4  2007-05-22 12:54:09  ddelon
 127 
* Revision 1.4  2007-05-22 12:54:09  ddelon
126 
* Securisation acces utilisateur
 128 
* Securisation acces utilisateur
127 
*/
 129 
*/
128 
?>
 130 
?>