Subversion Repositories eFlore/Applications.cel

Rev

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

Rev 1606 Rev 1609
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 
 
 24 
 
25 
set_include_path(get_include_path() . PATH_SEPARATOR . dirname(dirname(realpath(__FILE__))) . '/lib');
 25 
set_include_path(get_include_path() . PATH_SEPARATOR . dirname(dirname(realpath(__FILE__))) . '/lib');
26 
// la sortie est binaire (xls), mais OLE n'est pas compatible E_ALL en PHP-5.4
 26 
// la sortie est binaire (xls), mais OLE n'est pas compatible E_ALL en PHP-5.4
27 
error_reporting(error_reporting() ^ E_STRICT);
 27 
error_reporting(error_reporting() ^ E_STRICT);
28 
require_once("lib/OLE.php");
 28 
require_once("lib/OLE.php");
29 
require_once("lib/Spreadsheet/Excel/Writer.php");
 29 
require_once("lib/Spreadsheet/Excel/Writer.php");
30 
 
 30 
 
31 
class InventoryExport extends Cel  {
 31 
class InventoryExport extends Cel  {
32 
 
 32 
 
33 
	private $extendSpreadsheetProductor;
 33 
	private $extendSpreadsheetProductor;
34 
 
 34 
 
35 
	function InventoryExport($config) {
 35 
	function InventoryExport($config) {
36 
 
 36 
 
37 
		parent::__construct($config);
 37 
		parent::__construct($config);
38 
 
 38 
 
39 
		$this->extendSpreadsheetProductor = new SpreadsheetProductor();
 39 
		$this->extendSpreadsheetProductor = new SpreadsheetProductor();
40 
		$this->extendSpreadsheetProductor->initSpreadsheet();
 40 
		$this->extendSpreadsheetProductor->initSpreadsheet();
41 
	}
 41 
	}
42 
 
 42 
 
43 
	function getElement($uid){
 43 
	function getElement($uid){
44 
 
 44 
 
45 
		   // Controle detournement utilisateur
 45 
		   // Controle detournement utilisateur
46 
		 	$this->controleUtilisateur($uid[0]);
 46 
		 	$this->controleUtilisateur($uid[0]);
47 
 
 47 
 
48 
			$criteres = $_GET;
48 
			$criteres = $_GET;
49 
			$chercheur_observations = new RechercheObservation($this->config);
 49 
			$chercheur_observations = new RechercheObservation($this->config);
50 
 
 50 
 
51 
    	    // Creating a workbook
 51 
    	    // Creating a workbook
52 
			$workbook = new Spreadsheet_Excel_Writer();
 52 
			$workbook = new Spreadsheet_Excel_Writer();
- 
 
 53 
			$workbook->setVersion(8);
53 
 
 54 
 
54 
			$workbook->send('liste.xls');
 55 
			$workbook->send('liste.xls');
55 
 
 56 
 
56 
			// Creating a worksheet
 57 
			// Creating a worksheet
57 
			$worksheet = $workbook->addWorksheet('Liste');
 58 
			$worksheet = $workbook->addWorksheet('Liste');
- 
 
 59 
			$worksheet->setInputEncoding('utf-8');
58
60
59 
            $worksheet->write(0,0,'Espece');
 61 
            $worksheet->write(0,0,'Espece');
60 
            $worksheet->write(0,1,'Numero nomenclatural');
 62 
            $worksheet->write(0,1,'Numero nomenclatural');
61 
            $worksheet->write(0,2,'Nom retenu');
 63 
            $worksheet->write(0,2,'Nom retenu');
62 
            $worksheet->write(0,3,'Numero nomenclatural nom retenu');
 64 
            $worksheet->write(0,3,'Numero nomenclatural nom retenu');
63 
            $worksheet->write(0,4,'Numero taxonomique');
 65 
            $worksheet->write(0,4,'Numero taxonomique');
64 
            $worksheet->write(0,5,'Famille');
 66 
            $worksheet->write(0,5,'Famille');
65 
            $worksheet->write(0,6,'Referentiel taxonomique');
 67 
            $worksheet->write(0,6,'Referentiel taxonomique');
66 
            $worksheet->write(0,7,'Commune');
 68 
            $worksheet->write(0,7,'Commune');
67 
            $worksheet->write(0,8,'Identifiant Commune');
 69 
            $worksheet->write(0,8,'Identifiant Commune');
68 
            $worksheet->write(0,9,'Date');
 70 
            $worksheet->write(0,9,'Date');
69 
            $worksheet->write(0,10,'Lieu-dit');
 71 
            $worksheet->write(0,10,'Lieu-dit');
70 
            $worksheet->write(0,11,'Station');
 72 
            $worksheet->write(0,11,'Station');
71 
            $worksheet->write(0,12,'Milieu');
 73 
            $worksheet->write(0,12,'Milieu');
72 
            $worksheet->write(0,13,'Notes');
 74 
            $worksheet->write(0,13,'Notes');
73 
            $worksheet->write(0,14,'Latitude');
 75 
            $worksheet->write(0,14,'Latitude');
74 
            $worksheet->write(0,15,'Longitude');
 76 
            $worksheet->write(0,15,'Longitude');
75 
            $worksheet->write(0,16,'Referentiel Geographique');
 77 
            $worksheet->write(0,16,'Referentiel Geographique');
76 
            $worksheet->write(0,17,'Ordre');
 78 
            $worksheet->write(0,17,'Ordre');
77 
            $worksheet->write(0,18,'Identifiant');
 79 
            $worksheet->write(0,18,'Identifiant');
78
80
79 
            $numero_page = isset($criteres['numero_page']) ? $criteres['numero_page'] : 0;
 81 
            $numero_page = isset($criteres['numero_page']) ? $criteres['numero_page'] : 0;
80 
            $limite = isset($criteres['limite']) ? $criteres['limite'] : 0;
 82 
            $limite = isset($criteres['limite']) ? $criteres['limite'] : 0;
81 
 
 83 
 
82 
			$observations = $chercheur_observations->rechercherObservations($uid[0], $criteres, $numero_page, $limite);
 84 
			$observations = $chercheur_observations->rechercherObservations($uid[0], $criteres, $numero_page, $limite);
83 
			$ids_obs = array();
 85 
			$ids_obs = array();
84 
			$indices_lignes_obs = array();
 86 
			$indices_lignes_obs = array();
85
87
86 
			$i=1;
 88 
			$i=1;
87 
			foreach ($observations as &$obs) {
 89 
			foreach ($observations as &$obs) {
88 
 
 90 
 
89 
				$obs = $this->denullifierTableauValeurCel($obs);
 91 
				$obs = $this->denullifierTableauValeurCel($obs);
90 
				$ids_obs[] = $obs['id_observation'];
 92 
				$ids_obs[] = $obs['id_observation'];
91 
				$indices_lignes_obs[$obs['id_observation']] = $i;
 93 
				$indices_lignes_obs[$obs['id_observation']] = $i;
92
94
93 
			  	if ($obs['date_observation'] != "0000-00-00 00:00:00") {
 95 
			  	if ($obs['date_observation'] != "0000-00-00 00:00:00") {
94 
	                $obs['date_observation'] = $this->formaterDate($obs['date_observation']);
 96 
	                $obs['date_observation'] = $this->formaterDate($obs['date_observation']);
95 
	        	}
 97 
	        	}
96 
	        	else {
 98 
	        	else {
97 
	                $obs['date_observation']="00/00/0000";
 99 
	                $obs['date_observation']="00/00/0000";
98 
	        	}
 100 
	        	}
99 
 
 101 
 
100 
                $worksheet->write($i,0,$obs['nom_sel']);
 102 
                $worksheet->write($i,0,$obs['nom_sel']);
101 
                $worksheet->write($i,1,$obs['nom_sel_nn']);
 103 
                $worksheet->write($i,1,$obs['nom_sel_nn']);
102 
                $worksheet->write($i,2,$obs['nom_ret']);
 104 
                $worksheet->write($i,2,$obs['nom_ret']);
103 
                $worksheet->write($i,3,$obs['nom_ret_nn']);
 105 
                $worksheet->write($i,3,$obs['nom_ret_nn']);
104 
                $worksheet->write($i,4,$obs['nt']);
 106 
                $worksheet->write($i,4,$obs['nt']);
105 
                $worksheet->write($i,5,$obs['famille']);
 107 
                $worksheet->write($i,5,$obs['famille']);
106 
                $worksheet->write($i,6,$obs['nom_referentiel']);
 108 
                $worksheet->write($i,6,$obs['nom_referentiel']);
107 
                $worksheet->write($i,7,$obs['zone_geo']);
 109 
                $worksheet->write($i,7,$obs['zone_geo']);
108 
                $worksheet->write($i,8,$this->convertirCodeZoneGeoVersDepartement($obs['ce_zone_geo']));
 110 
                $worksheet->write($i,8,$this->convertirCodeZoneGeoVersDepartement($obs['ce_zone_geo']));
109 
                $worksheet->write($i,9,$obs['date_observation']);
 111 
                $worksheet->write($i,9,$obs['date_observation']);
110 
                $worksheet->write($i,10,$obs['lieudit']);
 112 
                $worksheet->write($i,10,$obs['lieudit']);
111 
                $worksheet->write($i,11,$obs['station']);
 113 
                $worksheet->write($i,11,$obs['station']);
112 
                $worksheet->write($i,12,$obs['milieu']);
 114 
                $worksheet->write($i,12,$obs['milieu']);
113 
                $worksheet->write($i,13,$obs['commentaire']);
 115 
                $worksheet->write($i,13,$obs['commentaire']);
114 
                $worksheet->write($i,14,$obs['latitude']);
 116 
                $worksheet->write($i,14,$obs['latitude']);
115 
                $worksheet->write($i,15,$obs['longitude']);
 117 
                $worksheet->write($i,15,$obs['longitude']);
116 
                $worksheet->write($i,16,$obs['geodatum']);
 118 
                $worksheet->write($i,16,$obs['geodatum']);
117 
                $worksheet->write($i,17,$obs['ordre']);
 119 
                $worksheet->write($i,17,$obs['ordre']);
118 
                $worksheet->write($i,18,$obs['id_observation']);
 120 
                $worksheet->write($i,18,$obs['id_observation']);
119 
                $i++;
 121 
                $i++;
120 
    	    }
 122 
    	    }
121
123
122 
    	    $indice_dernier_champ_supp = 19;
 124 
    	    $indice_dernier_champ_supp = 19;
123 
    	    $indices_champs_supp = array();
 125 
    	    $indices_champs_supp = array();
124 
    	    $gestion_champs_etendus = new GestionChampsEtendus($this->config, 'obs');
 126 
    	    $gestion_champs_etendus = new GestionChampsEtendus($this->config, 'obs');
125 
    	    $champs_supp_par_obs = $gestion_champs_etendus->consulterParLots($ids_obs);
 127 
    	    $champs_supp_par_obs = $gestion_champs_etendus->consulterParLots($ids_obs);
126
128
127 
    	    foreach($champs_supp_par_obs as $id_obs => &$champs_supp) {
 129 
    	    foreach($champs_supp_par_obs as $id_obs => &$champs_supp) {
128 
	    	    foreach($champs_supp as  &$champ_etendu) {
 130 
	    	    foreach($champs_supp as  &$champ_etendu) {
129 
	    	    	$cle = $champ_etendu->cle;
 131 
	    	    	$cle = $champ_etendu->cle;
130 
	    	    	$label = $champ_etendu->label;
 132 
	    	    	$label = $champ_etendu->label;
131 
	    	    	$valeur = $champ_etendu->valeur;
 133 
	    	    	$valeur = $champ_etendu->valeur;
132 
	    	    	if(!isset($indices_champs_supp[$cle])) {
 134 
	    	    	if(!isset($indices_champs_supp[$cle])) {
133 
	    	    		$indices_champs_supp[$cle] = $indice_dernier_champ_supp;
 135 
	    	    		$indices_champs_supp[$cle] = $indice_dernier_champ_supp;
134 
	    	    		$worksheet->write(0, $indice_dernier_champ_supp, utf8_decode($label));
 136 
	    	    		$worksheet->write(0, $indice_dernier_champ_supp, utf8_decode($label));
135 
	    	    		$indice_dernier_champ_supp++;
 137 
	    	    		$indice_dernier_champ_supp++;
136 
	    	    	}
 138 
	    	    	}
137 
	    	    	$num_ligne_obs = $indices_lignes_obs[$id_obs];
 139 
	    	    	$num_ligne_obs = $indices_lignes_obs[$id_obs];
138 
	    	    	$worksheet->write($num_ligne_obs,$indices_champs_supp[$cle],utf8_decode($valeur));
 140 
	    	    	$worksheet->write($num_ligne_obs,$indices_champs_supp[$cle],utf8_decode($valeur));
139 
	    	    }
 141 
	    	    }
140 
    	    }
 142 
    	    }
141
143
142 
			$workbook->close();
 144 
			$workbook->close();
143 
			exit();
 145 
			exit();
144 
	}
 146 
	}
145 
}
 147 
}
146 
/* +--Fin du code ---------------------------------------------------------------------------------------+
 148 
/* +--Fin du code ---------------------------------------------------------------------------------------+
147 
* $Log$
 149 
* $Log$
148 
* Revision 1.7  2008-11-13 11:29:12  ddelon
 150 
* Revision 1.7  2008-11-13 11:29:12  ddelon
149 
* Reecriture gwt-ext
 151 
* Reecriture gwt-ext
150 
*
 152 
*
151 
* Revision 1.6  2008-01-30 08:57:28  ddelon
 153 
* Revision 1.6  2008-01-30 08:57:28  ddelon
152 
* fin mise en place mygwt
 154 
* fin mise en place mygwt
153 
*
 155 
*
154 
* Revision 1.5  2007-06-06 13:31:16  ddelon
 156 
* Revision 1.5  2007-06-06 13:31:16  ddelon
155 
* v0.09
 157 
* v0.09
156 
*
 158 
*
157 
* Revision 1.4  2007-05-22 12:54:09  ddelon
 159 
* Revision 1.4  2007-05-22 12:54:09  ddelon
158 
* Securisation acces utilisateur
 160 
* Securisation acces utilisateur
159 
*/
 161 
*/
160 
?>
 162 
?>