Subversion Repositories eFlore/Applications.cel

Rev

Rev 1755 | Only display areas with differences | Regard whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 1755 Rev 2458
1 
<?php
 1 
<?php
2 
// ATTENTION ! Classe compatible uniquement avec nouveau format de bdd du cel //
 - 
 
3 
 
 - 
 
4 
/**
 - 
 
5 
* PHP Version 5
 - 
 
6 
*
 - 
 
7 
* @category  PHP
 - 
 
8 
* @package   jrest
 - 
 
9 
* @author    David Delon <david@tela-botania.org>
 - 
 
10 
* @author    Aurélien Peronnet <aurelien@tela-botania.org>
 - 
 
11 
* @copyright 2010 Tela-Botanica
 - 
 
12 
* @license   http://www.cecill.info/licences/Licence_CeCILL_V2-fr.txt Licence CECILL
 - 
 
13 
* @version   SVN: <svn_id>
 2 
// declare(encoding='UTF-8');
14 
* @link      /doc/jrest/
 - 
 
15 
*/
 - 
 
16 
 
 - 
 
17 
/**
 3 
/**
18 
* in:utf8
 - 
 
19 
* out:iso8859
 - 
 
20 
*
- 
 
21 
* Export vers feuille de calcul d'une selection de releves
 4 
 * Service d'export vers feuille de calcul d'une sélection de relevés.
22 
*
5 
 *
- 
 
 6 
 * @internal   Mininum PHP version : 5.2
- 
 
 7 
 * @category   CEL
- 
 
 8 
 * @package    Services
- 
 
 9 
 * @subpackage Observations
- 
 
 10 
 * @version    0.1
- 
 
 11 
 * @author     Mathias CHOUET <mathias@tela-botanica.org>
- 
 
 12 
 * @author     Jean-Pascal MILCENT <jpm@tela-botanica.org>
- 
 
 13 
 * @author     Aurelien PERONNET <aurelien@tela-botanica.org>
- 
 
 14 
 * @license    GPL v3 <http://www.gnu.org/licenses/gpl.txt>
- 
 
 15 
 * @license    CECILL v2 <http://www.cecill.info/licences/Licence_CeCILL_V2-en.txt>
- 
 
 16 
 * @copyright  1999-2014 Tela Botanica <accueil@tela-botanica.org>
23 
*/
 17 
 */
24 
 
 18 
 
25 
set_include_path(get_include_path() . PATH_SEPARATOR . dirname(dirname(realpath(__FILE__))) . '/lib');
 19 
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
 20 
// la sortie est binaire (xls), mais OLE n'est pas compatible E_ALL en PHP-5.4
27 
error_reporting(error_reporting() ^ E_STRICT);
 21 
error_reporting(error_reporting() ^ E_STRICT);
28 
require_once("lib/OLE.php");
 22 
require_once 'lib/OLE.php';
29 
require_once("lib/Spreadsheet/Excel/Writer.php");
 23 
require_once 'lib/Spreadsheet/Excel/Writer.php';
30 
 
 24 
 
31 
class InventoryExport extends Cel  {
 25 
class InventoryExport extends Cel  {
32 
 
 26 
 
33 
	private $extendSpreadsheetProductor;
 27 
	private $extendSpreadsheetProductor;
34 
 
 28 
 
35 
	function InventoryExport($config) {
 - 
 
36 
 
 29 
	public function __construct($config) {
37 
		parent::__construct($config);
 30 
		parent::__construct($config);
38 
 
 31 
 
39 
		$this->extendSpreadsheetProductor = new SpreadsheetProductor();
 32 
		$this->extendSpreadsheetProductor = new SpreadsheetProductor();
40 
		$this->extendSpreadsheetProductor->initSpreadsheet();
 33 
		$this->extendSpreadsheetProductor->initSpreadsheet();
41 
	}
 34 
	}
42 
 
 35 
 
43 
	function getElement($uid){
 - 
 
44 
 
 36 
	public function getElement($uid){
45 
		   // Controle detournement utilisateur
 37 
		// Controle detournement utilisateur
46 
		 	$this->controleUtilisateur($uid[0]);
 38 
		$this->controleUtilisateur($uid[0]);
47 
 
 39 
 
48 
			$criteres = $_GET;
40 
		$criteres = $_GET;
49 
			$chercheur_observations = new RechercheObservation($this->config);
 41 
		$chercheur_observations = new RechercheObservation($this->config);
50 
 
 42 
 
51 
    	    // Creating a workbook
 43 
		// Creating a workbook
52 
			$workbook = new Spreadsheet_Excel_Writer();
 44 
		$workbook = new Spreadsheet_Excel_Writer();
53 
			$workbook->setVersion(8);
 45 
		$workbook->setVersion(8);
54 
 
 - 
 
55 
			$workbook->send('liste.xls');
 46 
		$workbook->send('liste.xls');
56 
 
 47 
 
57 
			// Creating a worksheet
 48 
		// Creating a worksheet
58 
			$worksheet = $workbook->addWorksheet('Liste');
 49 
		$worksheet = $workbook->addWorksheet('Liste');
59 
			$worksheet->setInputEncoding('utf-8');
 50 
		$worksheet->setInputEncoding('utf-8');
60
- 
 
61 
            $worksheet->write(0,0,'Espece');
 51 
		$worksheet->write(0,0,'Espece');
62 
            $worksheet->write(0,1,'Numero nomenclatural');
 52 
		$worksheet->write(0,1,'Numero nomenclatural');
63 
            $worksheet->write(0,2,'Nom retenu');
 53 
		$worksheet->write(0,2,'Nom retenu');
64 
            $worksheet->write(0,3,'Numero nomenclatural nom retenu');
 54 
		$worksheet->write(0,3,'Numero nomenclatural nom retenu');
65 
            $worksheet->write(0,4,'Numero taxonomique');
 55 
		$worksheet->write(0,4,'Numero taxonomique');
66 
            $worksheet->write(0,5,'Famille');
 56 
		$worksheet->write(0,5,'Famille');
67 
            $worksheet->write(0,6,'Referentiel taxonomique');
 57 
		$worksheet->write(0,6,'Referentiel taxonomique');
68 
            $worksheet->write(0,7,'Commune');
 58 
		$worksheet->write(0,7,'Commune');
69 
            $worksheet->write(0,8,'Identifiant Commune');
 59 
		$worksheet->write(0,8,'Identifiant Commune');
70 
            $worksheet->write(0,9,'Date');
 60 
		$worksheet->write(0,9,'Date');
71 
            $worksheet->write(0,10,'Lieu-dit');
 61 
		$worksheet->write(0,10,'Lieu-dit');
72 
            $worksheet->write(0,11,'Station');
 62 
		$worksheet->write(0,11,'Station');
73 
            $worksheet->write(0,12,'Milieu');
 63 
		$worksheet->write(0,12,'Milieu');
74 
            $worksheet->write(0,13,'Notes');
 64 
		$worksheet->write(0,13,'Notes');
75 
            $worksheet->write(0,14,'Latitude');
 65 
		$worksheet->write(0,14,'Latitude');
76 
            $worksheet->write(0,15,'Longitude');
 66 
		$worksheet->write(0,15,'Longitude');
77 
            $worksheet->write(0,16,'Referentiel Geographique');
 67 
		$worksheet->write(0,16,'Referentiel Geographique');
78 
            $worksheet->write(0,17,'Ordre');
 68 
		$worksheet->write(0,17,'Ordre');
79 
            $worksheet->write(0,18,'Identifiant');
 69 
		$worksheet->write(0,18,'Identifiant');
80
70 
 
81 
            $numero_page = isset($criteres['numero_page']) ? $criteres['numero_page'] : 0;
 71 
		$numero_page = isset($criteres['numero_page']) ? $criteres['numero_page'] : 0;
82 
            $limite = isset($criteres['limite']) ? $criteres['limite'] : 0;
 72 
		$limite = isset($criteres['limite']) ? $criteres['limite'] : 0;
83 
 
 73 
 
84 
			$observations = $chercheur_observations->rechercherObservations($uid[0], $criteres, $numero_page, $limite)->get();
 74 
		$observations = $chercheur_observations->rechercherObservations($uid[0], $criteres, $numero_page, $limite)->get();
85 
			if(!$observations) {
 75 
		if (!$observations) {
86 
				header('HTTP/1.0 204 No Content');
 76 
			header('HTTP/1.0 204 No Content');
87 
				exit;
 77 
			exit;
88 
			}
 78 
		}
89 
 
 79 
 
90 
			$ids_obs = array();
 80 
		$ids_obs = array();
91 
			$indices_lignes_obs = array();
 81 
		$indices_lignes_obs = array();
92
82 
 
93 
			$i=1;
 83 
		$i = 1;
94 
			foreach ($observations as &$obs) {
 84 
		foreach ($observations as &$obs) {
95 
 
 - 
 
96 
				$obs = $this->denullifierTableauValeurCel($obs);
 85 
			$obs = $this->denullifierTableauValeurCel($obs);
97 
				$ids_obs[] = $obs['id_observation'];
 86 
			$ids_obs[] = $obs['id_observation'];
98 
				$indices_lignes_obs[$obs['id_observation']] = $i;
 87 
			$indices_lignes_obs[$obs['id_observation']] = $i;
99
88 
 
100 
			  	if ($obs['date_observation'] != "0000-00-00 00:00:00") {
 89 
			if ($obs['date_observation'] != '0000-00-00 00:00:00') {
101 
	                $obs['date_observation'] = $this->formaterDate($obs['date_observation']);
 - 
 
102 
	        	}
 90 
				$obs['date_observation'] = $this->formaterDate($obs['date_observation']);
103 
	        	else {
 91 
			} else {
104 
	                $obs['date_observation']="00/00/0000";
 92 
				$obs['date_observation'] = '00/00/0000';
105 
	        	}
 93 
			}
106 
 
 94 
 
107 
                $worksheet->write($i,0,$obs['nom_sel']);
 95 
			$worksheet->write($i,0,$obs['nom_sel']);
108 
                $worksheet->write($i,1,$obs['nom_sel_nn']);
 96 
			$worksheet->write($i,1,$obs['nom_sel_nn']);
109 
                $worksheet->write($i,2,$obs['nom_ret']);
 97 
			$worksheet->write($i,2,$obs['nom_ret']);
110 
                $worksheet->write($i,3,$obs['nom_ret_nn']);
 98 
			$worksheet->write($i,3,$obs['nom_ret_nn']);
111 
                $worksheet->write($i,4,$obs['nt']);
 99 
			$worksheet->write($i,4,$obs['nt']);
112 
                $worksheet->write($i,5,$obs['famille']);
 100 
			$worksheet->write($i,5,$obs['famille']);
113 
                $worksheet->write($i,6,$obs['nom_referentiel']);
 101 
			$worksheet->write($i,6,$obs['nom_referentiel']);
114 
                $worksheet->write($i,7,$obs['zone_geo']);
 102 
			$worksheet->write($i,7,$obs['zone_geo']);
115 
                $worksheet->write($i,8,$this->convertirCodeZoneGeoVersDepartement($obs['ce_zone_geo']));
 103 
			$worksheet->write($i,8,$this->convertirCodeZoneGeoVersDepartement($obs['ce_zone_geo']));
116 
                $worksheet->write($i,9,$obs['date_observation']);
 104 
			$worksheet->write($i,9,$obs['date_observation']);
117 
                $worksheet->write($i,10,$obs['lieudit']);
 105 
			$worksheet->write($i,10,$obs['lieudit']);
118 
                $worksheet->write($i,11,$obs['station']);
 106 
			$worksheet->write($i,11,$obs['station']);
119 
                $worksheet->write($i,12,$obs['milieu']);
 107 
			$worksheet->write($i,12,$obs['milieu']);
120 
                $worksheet->write($i,13,$obs['commentaire']);
 108 
			$worksheet->write($i,13,$obs['commentaire']);
121 
                $worksheet->write($i,14,$obs['latitude']);
 109 
			$worksheet->write($i,14,$obs['latitude']);
122 
                $worksheet->write($i,15,$obs['longitude']);
 110 
			$worksheet->write($i,15,$obs['longitude']);
123 
                $worksheet->write($i,16,$obs['geodatum']);
 111 
			$worksheet->write($i,16,$obs['geodatum']);
124 
                $worksheet->write($i,17,$obs['ordre']);
 112 
			$worksheet->write($i,17,$obs['ordre']);
125 
                $worksheet->write($i,18,$obs['id_observation']);
 113 
			$worksheet->write($i,18,$obs['id_observation']);
126 
                $i++;
 114 
			$i++;
127 
    	    }
 115 
		}
128
116 
 
129 
    	    $indice_dernier_champ_supp = 19;
 117 
		$indice_dernier_champ_supp = 19;
130 
    	    $indices_champs_supp = array();
 118 
		$indices_champs_supp = array();
131 
    	    $gestion_champs_etendus = new GestionChampsEtendus($this->config, 'obs');
 119 
		$gestion_champs_etendus = new GestionChampsEtendus($this->config, 'obs');
132 
    	    $champs_supp_par_obs = $gestion_champs_etendus->consulterParLots($ids_obs);
 120 
		$champs_supp_par_obs = $gestion_champs_etendus->consulterParLots($ids_obs);
133
121 
 
134 
    	    foreach($champs_supp_par_obs as $id_obs => &$champs_supp) {
 122 
		foreach ($champs_supp_par_obs as $id_obs => &$champs_supp) {
135 
	    	    foreach($champs_supp as  &$champ_etendu) {
 123 
			foreach ($champs_supp as  &$champ_etendu) {
136 
	    	    	$cle = $champ_etendu->cle;
 124 
				$cle = $champ_etendu->cle;
137 
	    	    	$label = $champ_etendu->label;
 125 
				$label = $champ_etendu->label;
138 
	    	    	$valeur = $champ_etendu->valeur;
 126 
				$valeur = $champ_etendu->valeur;
139 
	    	    	if(!isset($indices_champs_supp[$cle])) {
 127 
				if(!isset($indices_champs_supp[$cle])) {
140 
	    	    		$indices_champs_supp[$cle] = $indice_dernier_champ_supp;
 128 
					$indices_champs_supp[$cle] = $indice_dernier_champ_supp;
141 
	    	    		$worksheet->write(0, $indice_dernier_champ_supp, utf8_decode($label));
 129 
					$worksheet->write(0, $indice_dernier_champ_supp, utf8_decode($label));
142 
	    	    		$indice_dernier_champ_supp++;
 130 
					$indice_dernier_champ_supp++;
143 
	    	    	}
 131 
				}
144 
	    	    	$num_ligne_obs = $indices_lignes_obs[$id_obs];
 132 
				$num_ligne_obs = $indices_lignes_obs[$id_obs];
145 
	    	    	$worksheet->write($num_ligne_obs,$indices_champs_supp[$cle],utf8_decode($valeur));
 133 
				$worksheet->write($num_ligne_obs,$indices_champs_supp[$cle],utf8_decode($valeur));
146 
	    	    }
 134 
			}
147 
    	    }
 135 
		}
148
136 
 
149 
			$workbook->close();
 137 
		$workbook->close();
150 
			exit();
 138 
		exit();
151 
	}
 139 
	}
152 
}
 140 
}
153 
/* +--Fin du code ---------------------------------------------------------------------------------------+
 - 
 
154 
* $Log$
 - 
 
155 
* Revision 1.7  2008-11-13 11:29:12  ddelon
 - 
 
156 
* Reecriture gwt-ext
 - 
 
157 
*
 - 
 
158 
* Revision 1.6  2008-01-30 08:57:28  ddelon
 - 
 
159 
* fin mise en place mygwt
 - 
 
160 
*
 - 
 
161 
* Revision 1.5  2007-06-06 13:31:16  ddelon
 - 
 
162 
* v0.09
 - 
 
163 
*
 - 
 
164 
* Revision 1.4  2007-05-22 12:54:09  ddelon
 - 
 
165 
* Securisation acces utilisateur
 - 
 
166 
*/
 - 
 
167 
?>
 - 
 
168 

            141