| 416 |
aurelien |
1 |
<?php
|
| 904 |
aurelien |
2 |
// ATTENTION ! Classe compatible uniquement avec nouveau format de bdd du cel //
|
| 416 |
aurelien |
3 |
|
| 904 |
aurelien |
4 |
/**
|
|
|
5 |
* PHP Version 5
|
|
|
6 |
*
|
|
|
7 |
* @category PHP
|
|
|
8 |
* @package jrest
|
|
|
9 |
* @author David Delon <delon@tela-botanica.org>
|
|
|
10 |
* @copyright 2010 Tela-Botanica
|
|
|
11 |
* @license http://www.cecill.info/licences/Licence_CeCILL_V2-fr.txt Licence CECILL
|
|
|
12 |
* @version SVN: <svn_id>
|
|
|
13 |
* @link /doc/
|
|
|
14 |
*/
|
| 416 |
aurelien |
15 |
|
| 904 |
aurelien |
16 |
/**
|
|
|
17 |
*
|
|
|
18 |
* in=utf8
|
|
|
19 |
* out=iso3859
|
|
|
20 |
*
|
|
|
21 |
* Liste des Nouvelles observations par departement
|
|
|
22 |
* A voir avec David mais ne devrait plus être utilisé
|
|
|
23 |
* ou fait autrement
|
|
|
24 |
*
|
|
|
25 |
*/
|
|
|
26 |
class InventoryByDept extends Cel {
|
| 416 |
aurelien |
27 |
|
|
|
28 |
var $extendSpreadsheetProductor;
|
|
|
29 |
|
|
|
30 |
function InventoryByDept($config) {
|
|
|
31 |
|
| 904 |
aurelien |
32 |
parent::__construct($config);
|
|
|
33 |
|
| 416 |
aurelien |
34 |
// Pas d'heritage multiple en php :(
|
|
|
35 |
$this->extendSpreadsheetProductor = new SpreadsheetProductor();
|
| 904 |
aurelien |
36 |
$this->extendSpreadsheetProductor->initSpreadsheet();
|
| 416 |
aurelien |
37 |
}
|
|
|
38 |
|
| 905 |
aurelien |
39 |
//TODO : faire une fonction qui prend en paramètre un departement
|
| 416 |
aurelien |
40 |
function getRessource(){
|
|
|
41 |
|
| 904 |
aurelien |
42 |
$requete_obs = "SELECT ce_zone_geo, ce_utilisateur, courriel_utilisateur, ordre, nom_sel, nom_sel_nn, nom_ret, nom_ret_nn, nt, famille, zone_geo, date_observation," .
|
|
|
43 |
" lieudit, station, milieu, commentaire, transmission FROM cel_obs ".
|
|
|
44 |
"WHERE ce_zone_geo != '000null' AND ce_zone_geo != '' AND transmission = 1 AND nt!=0 ORDER BY ce_zone_geo, nom_ret LIMIT 50";
|
|
|
45 |
|
|
|
46 |
$resultat_obs = $this->executerRequete($requete_obs);
|
| 416 |
aurelien |
47 |
|
| 904 |
aurelien |
48 |
// Creating a workbook
|
|
|
49 |
$workbook = new Spreadsheet_Excel_Writer();
|
|
|
50 |
// Creating a worksheet
|
|
|
51 |
$worksheet = $workbook->addWorksheet('Liste');
|
|
|
52 |
|
|
|
53 |
$worksheet->write(0,0,'Departement');
|
|
|
54 |
$worksheet->write(0,1,'Nom saisi');
|
|
|
55 |
$worksheet->write(0,2,'Numero nomenclatural');
|
|
|
56 |
$worksheet->write(0,3,'Nom retenu');
|
|
|
57 |
$worksheet->write(0,4,'Numero nomenclatural nom retenu');
|
|
|
58 |
$worksheet->write(0,5,'Numero taxonomique');
|
|
|
59 |
$worksheet->write(0,6,'Famille');
|
|
|
60 |
$worksheet->write(0,7,'Commune');
|
|
|
61 |
$worksheet->write(0,8,'Date Observation');
|
|
|
62 |
$worksheet->write(0,9,'Lieu dit');
|
|
|
63 |
$worksheet->write(0,10,'Station');
|
|
|
64 |
$worksheet->write(0,11,'Milieu');
|
|
|
65 |
$worksheet->write(0,12,'Commentaire');
|
|
|
66 |
$worksheet->write(0,13,'Observateur');
|
|
|
67 |
|
|
|
68 |
$i=1;
|
| 416 |
aurelien |
69 |
|
| 904 |
aurelien |
70 |
$observations = array();
|
|
|
71 |
$chercheur_infos_taxon = null;
|
|
|
72 |
if (is_array($resultat_obs)) {
|
|
|
73 |
$observations = &$resultat_obs;
|
|
|
74 |
$chercheur_infos_taxon = new RechercheInfosTaxon($this->config);
|
|
|
75 |
}
|
|
|
76 |
|
|
|
77 |
foreach ($observations as $obs) {
|
| 416 |
aurelien |
78 |
|
| 904 |
aurelien |
79 |
$code_departement = $this->convertirCodeZoneGeoVersDepartement($obs['ce_zone_geo']);
|
|
|
80 |
$taxon_deja_vu = $chercheur_infos_taxon->taxonEstPresentDansDepartement($obs['nt'], $code_departement);
|
|
|
81 |
|
|
|
82 |
if (!$taxon_deja_vu) {
|
|
|
83 |
// Denullifiage
|
|
|
84 |
foreach($obs as $k=>$v) {
|
|
|
85 |
if (($v=="null") || ($v=="000null")) {
|
|
|
86 |
$obs[$k]="";
|
|
|
87 |
}
|
|
|
88 |
else {
|
|
|
89 |
$obs[$k]=utf8_decode($v);
|
|
|
90 |
}
|
|
|
91 |
}
|
| 416 |
aurelien |
92 |
|
| 904 |
aurelien |
93 |
if ($obs['date_observation']!="0000-00-00 00:00:00") {
|
|
|
94 |
list($year,$month,$day)= split ('-',$obs['date_observation']);
|
|
|
95 |
list($day)= split (' ',$day);
|
|
|
96 |
$obs['date_observation']=$day."/".$month."/".$year;
|
|
|
97 |
}
|
|
|
98 |
else {
|
|
|
99 |
$obs['date_observation']="00/00/0000";
|
|
|
100 |
}
|
| 416 |
aurelien |
101 |
|
| 904 |
aurelien |
102 |
$worksheet->write($i,0,$code_departement);
|
|
|
103 |
$worksheet->write($i,1,$obs['nom_sel']);
|
|
|
104 |
$worksheet->write($i,2,$obs['nom_sel_nn']);
|
|
|
105 |
$worksheet->write($i,3,$obs['nom_ret']);
|
|
|
106 |
$worksheet->write($i,4,$obs['nom_ret_nn']);
|
|
|
107 |
$worksheet->write($i,5,$obs['nt']);
|
|
|
108 |
$worksheet->write($i,6,$obs['famille']);
|
|
|
109 |
$worksheet->write($i,7,$obs['zone_geo']);
|
|
|
110 |
$worksheet->write($i,8,$obs['date_observation']);
|
|
|
111 |
$worksheet->write($i,9,$obs['lieudit']);
|
|
|
112 |
$worksheet->write($i,10,$obs['station']);
|
|
|
113 |
$worksheet->write($i,11,$obs['milieu']);
|
|
|
114 |
$worksheet->write($i,12,$obs['commentaire']);
|
|
|
115 |
$worksheet->write($i,13,$obs['courriel_utilisateur']);
|
|
|
116 |
|
|
|
117 |
$i++;
|
|
|
118 |
}
|
|
|
119 |
}
|
|
|
120 |
|
|
|
121 |
// sending HTTP headers
|
|
|
122 |
$workbook->send('liste.xls');
|
|
|
123 |
$workbook->close();
|
| 416 |
aurelien |
124 |
|
| 904 |
aurelien |
125 |
exit();
|
|
|
126 |
}
|
| 416 |
aurelien |
127 |
}
|
|
|
128 |
|
|
|
129 |
/* +--Fin du code ---------------------------------------------------------------------------------------+
|
|
|
130 |
* $Log$
|
|
|
131 |
* Revision 1.1 2008-11-13 11:29:12 ddelon
|
|
|
132 |
* Reecriture gwt-ext
|
|
|
133 |
*
|
|
|
134 |
* Revision 1.2 2008-01-30 08:57:28 ddelon
|
|
|
135 |
* fin mise en place mygwt
|
|
|
136 |
*
|
|
|
137 |
* Revision 1.1 2007-06-06 13:31:16 ddelon
|
|
|
138 |
* v0.09
|
|
|
139 |
*
|
|
|
140 |
* Revision 1.3 2007-05-22 12:54:09 ddelon
|
|
|
141 |
* Securisation acces utilisateur
|
|
|
142 |
*
|
|
|
143 |
*
|
|
|
144 |
*
|
|
|
145 |
*/
|
| 904 |
aurelien |
146 |
?>
|