| 3164 |
idir |
1 |
<?php
|
| 3122 |
delphine |
2 |
// declare(encoding='UTF-8');
|
|
|
3 |
/**
|
|
|
4 |
* Service affichant les dernières photo publiques du CEL ouvrable sous forme de diaporama.
|
|
|
5 |
* Encodage en entrée : utf8
|
|
|
6 |
* Encodage en sortie : utf8
|
|
|
7 |
*
|
|
|
8 |
* Cas d'utilisation et documentation :
|
|
|
9 |
* @link http://www.tela-botanica.org/wikini/eflore/wakka.php?wiki=AideCELWidgetPhoto
|
|
|
10 |
*
|
|
|
11 |
* Paramètres :
|
|
|
12 |
* ===> extra = booléen (1 ou 0) [par défaut : 1]
|
|
|
13 |
* Affiche / Cache la vignette en taille plus importante au bas du widget.
|
|
|
14 |
* ===> vignette = [0-9]+,[0-9]+ [par défaut : 4,3]
|
|
|
15 |
* Indique le nombre de vignette par ligne et le nombre de ligne.
|
|
|
16 |
*
|
| 3164 |
idir |
17 |
* @author Jean-Pascal MILCENT <jpm@tela-botanica.org>
|
|
|
18 |
* @license GPL v3 <http://www.gnu.org/licenses/gpl.txt>
|
|
|
19 |
* @license CECILL v2 <http://www.cecill.info/licences/Licence_CeCILL_V2-en.txt>
|
|
|
20 |
* @version $Id$
|
|
|
21 |
* @copyright Copyright (c) 2010, Tela Botanica (accueil@tela-botanica.org)
|
| 3122 |
delphine |
22 |
*/
|
|
|
23 |
class Manager extends WidgetCommun {
|
|
|
24 |
|
| 3233 |
idir |
25 |
const DS = DIRECTORY_SEPARATOR;
|
|
|
26 |
const SERVICE_DEFAUT = 'manager';
|
|
|
27 |
private $cel_url_tpl = null;
|
|
|
28 |
/** Si spécifié, on ajoute une barre de navigation inter-applications */
|
|
|
29 |
private $bar;
|
|
|
30 |
//private $parametres_autorises = array('projet', 'type', 'langue', 'order');
|
|
|
31 |
private $parametres_autorises = array(
|
|
|
32 |
'projet' => 'projet',
|
|
|
33 |
'type' => 'type',
|
|
|
34 |
'langue' => 'langue',
|
|
|
35 |
'order' => 'order'
|
|
|
36 |
);
|
|
|
37 |
/**
|
|
|
38 |
* Méthode appelée par défaut pour charger ce widget.
|
|
|
39 |
*/
|
|
|
40 |
public function executer() {
|
|
|
41 |
$retour = null;
|
| 3164 |
idir |
42 |
|
| 3233 |
idir |
43 |
// Pour la création de l'id du cache nous ne tenons pas compte du paramètre de l'url callback
|
|
|
44 |
unset( $this->parametres['callback'] );
|
|
|
45 |
extract( $this->parametres );
|
|
|
46 |
$this->bar = ( isset( $bar ) ) ? $bar : false;
|
| 3164 |
idir |
47 |
|
| 3233 |
idir |
48 |
$framework = dirname( __FILE__ ) . '/framework.php';
|
| 3164 |
idir |
49 |
|
| 3233 |
idir |
50 |
if ( !file_exists( $framework ) ) {
|
|
|
51 |
$e = 'Veuillez paramêtrer l\'emplacement et la version du Framework dans le fichier $framework';
|
|
|
52 |
trigger_error( $e, E_USER_ERROR );
|
|
|
53 |
} else {
|
|
|
54 |
// Inclusion du Framework
|
|
|
55 |
require_once $framework;
|
|
|
56 |
// Ajout d'information concernant cette application
|
|
|
57 |
Framework::setCheminAppli( __FILE__ );// Obligatoire
|
|
|
58 |
Framework::setInfoAppli( Config::get( 'info' ) );// Optionnel
|
|
|
59 |
}
|
| 3164 |
idir |
60 |
|
| 3233 |
idir |
61 |
if ( !isset( $mode ) ) {
|
|
|
62 |
$mode = self::SERVICE_DEFAUT;
|
|
|
63 |
}
|
| 3164 |
idir |
64 |
|
| 3233 |
idir |
65 |
$this->cel_url_tpl = $this->config['manager']['celUrlTpl'];
|
| 3166 |
idir |
66 |
|
| 3233 |
idir |
67 |
if ( $_POST !== array() ) { //print_r($_POST);
|
|
|
68 |
$this->parametres['projet'] = $_POST['projet'];
|
|
|
69 |
$this->parametres['langue'] = $_POST['langue'];
|
| 3164 |
idir |
70 |
|
| 3233 |
idir |
71 |
if ( $mode === 'modification' ) {
|
|
|
72 |
$parametres = $this->traiterParametresModif();
|
| 3358 |
idir |
73 |
$donnees = array_merge( $parametres, $this->traiterDonneesFiles() );
|
|
|
74 |
$json = $this->getDao()->modifier( $this->cel_url_tpl, $donnees );
|
| 3233 |
idir |
75 |
} else {
|
|
|
76 |
$donnees = array_merge( $_POST, $this->traiterDonneesFiles() );
|
|
|
77 |
// var_dump($donnees);
|
| 3358 |
idir |
78 |
$json = $this->getDao()->ajouter( $this->cel_url_tpl, $donnees );
|
|
|
79 |
$mode = $this->parametres['mode'] = 'modification';
|
| 3233 |
idir |
80 |
}
|
|
|
81 |
}
|
| 3226 |
idir |
82 |
|
| 3233 |
idir |
83 |
$methode = $this->traiterNomMethodeExecuter( $mode );
|
|
|
84 |
if ( method_exists( $this, $methode ) ) {
|
|
|
85 |
$retour = $this->$methode();
|
|
|
86 |
} else {
|
| 3226 |
idir |
87 |
|
| 3233 |
idir |
88 |
$this->messages[] = "Ce type de service '$methode' n'est pas disponible.";
|
|
|
89 |
}
|
| 3226 |
idir |
90 |
|
| 3233 |
idir |
91 |
$contenu = '';
|
|
|
92 |
if ( is_null( $retour ) ) {
|
|
|
93 |
$this->messages[] = 'La ressource demandée a retourné une valeur nulle.';
|
| 3226 |
idir |
94 |
|
| 3233 |
idir |
95 |
} else {
|
| 3226 |
idir |
96 |
|
| 3233 |
idir |
97 |
if ( isset( $retour['donnees'] ) ) {
|
|
|
98 |
$retour['donnees']['params'] = '&projet=' . $_POST['projet'] . '&langue=' . $_POST['langue'];
|
|
|
99 |
$retour['donnees']['prod'] = ( $this->config['parametres']['modeServeur'] === 'prod' );
|
|
|
100 |
$retour['donnees']['bar'] = $this->bar;
|
|
|
101 |
$retour['donnees']['url_base'] = sprintf( $this->config['chemins']['baseURLAbsoluDyn'], '' );
|
| 3359 |
idir |
102 |
$retour['donnees']['chemin_images'] = sprintf( $this->config['chemins']['baseURLAbsoluDyn'], $this->config['manager']['dossierTmp'] );
|
| 3233 |
idir |
103 |
$retour['donnees']['mode'] = $mode; //print_r($retour);
|
|
|
104 |
$squelette = dirname( __FILE__ ) . self::DS . 'squelettes' . self::DS . $retour['squelette'] . '.tpl.html';
|
|
|
105 |
$contenu = $this->traiterSquelettePhp( $squelette, $retour['donnees'] );
|
|
|
106 |
} else {
|
| 3226 |
idir |
107 |
|
| 3233 |
idir |
108 |
$this->messages[] = 'Les données à transmettre au squelette sont nulles.';
|
|
|
109 |
}
|
|
|
110 |
}
|
|
|
111 |
$this->envoyer($contenu);
|
|
|
112 |
}
|
| 3226 |
idir |
113 |
|
| 3233 |
idir |
114 |
private function executerManager() {
|
|
|
115 |
$params = array();
|
|
|
116 |
$retour['squelette'] = 'manager';
|
| 3226 |
idir |
117 |
|
| 3233 |
idir |
118 |
foreach ( $this->parametres_autorises as $id => $pa ) {
|
|
|
119 |
if ( isset( $this->parametres[$pa] ) ) {
|
|
|
120 |
$params[] = $pa . '=' . $this->parametres[$pa];
|
|
|
121 |
}
|
|
|
122 |
}
|
| 3226 |
idir |
123 |
|
| 3233 |
idir |
124 |
$param = implode( $params, '&' );
|
|
|
125 |
$url = $this->cel_url_tpl;
|
| 3226 |
idir |
126 |
|
| 3233 |
idir |
127 |
if ( $param !== '' ) {
|
|
|
128 |
$url .= '?' . $param;
|
|
|
129 |
}
|
| 3226 |
idir |
130 |
|
| 3233 |
idir |
131 |
$json = $this->getDao()->consulter( $url );
|
| 3241 |
idir |
132 |
$retour['donnees']['widget'] = (array) json_decode( $json, true );
|
|
|
133 |
$retour['donnees']['widgetUrlTpl'] = $this->config['manager']['widgetUrlTpl'];
|
| 3226 |
idir |
134 |
|
| 3233 |
idir |
135 |
return $retour;
|
|
|
136 |
}
|
| 3226 |
idir |
137 |
|
| 3233 |
idir |
138 |
private function executerCreation() {
|
|
|
139 |
//https://api.tela-botanica.org/service:cel:NomsChampsEtendus/cle
|
|
|
140 |
$jsonlangue = $this->getDao()->consulter( $this->config['manager']['languesUrl'] );
|
|
|
141 |
$tableaulangue = (array) json_decode( $jsonlangue, true );
|
|
|
142 |
$retour['squelette'] = 'creation';
|
|
|
143 |
$retour['donnees']['langues'] = $tableaulangue['resultat'] ;
|
|
|
144 |
$retour['donnees']['widget'] = array();
|
| 3226 |
idir |
145 |
|
| 3233 |
idir |
146 |
if ( isset( $this->parametres['projet'] ) ) {
|
|
|
147 |
$url = $this->cel_url_tpl . '?projet=' . $this->parametres['projet'];
|
|
|
148 |
$json = $this->getDao()->consulter( $url );
|
|
|
149 |
$tableau = (array) json_decode( $json, true );
|
|
|
150 |
$retour['donnees']['widget'] = $tableau[0];
|
|
|
151 |
}
|
| 3226 |
idir |
152 |
|
| 3233 |
idir |
153 |
$urltype = $this->cel_url_tpl . '?esttype=1';
|
|
|
154 |
$jsontype = $this->getDao()->consulter( $urltype );
|
|
|
155 |
$tableautype = (array) json_decode( $jsontype, true );
|
|
|
156 |
$retour['donnees']['type'] = $tableautype;
|
| 3226 |
idir |
157 |
|
| 3233 |
idir |
158 |
return $retour;
|
|
|
159 |
}
|
| 3226 |
idir |
160 |
|
|
|
161 |
|
|
|
162 |
|
| 3233 |
idir |
163 |
private function executerModification() {
|
|
|
164 |
$retour = array();
|
|
|
165 |
if ( isset( $this->parametres['projet'] ) ) {
|
| 3226 |
idir |
166 |
|
| 3233 |
idir |
167 |
$url = $this->cel_url_tpl . '?projet=' . $this->parametres['projet'] . '&langue=' . $this->parametres['langue'];
|
|
|
168 |
$json = $this->getDao()->consulter( $url );
|
|
|
169 |
$tableau = (array) json_decode( $json, true );
|
|
|
170 |
$retour['squelette'] = 'creation';
|
|
|
171 |
$retour['donnees']['widget'] = $tableau[0];
|
| 3360 |
idir |
172 |
// En prévision d'un service permettant la suppression/modification champs supp
|
|
|
173 |
$retour['donnees']['widget']['chpSupp'] = $this->rechercherChampsSupp();
|
| 3226 |
idir |
174 |
|
| 3233 |
idir |
175 |
$urltype = $this->cel_url_tpl .'?esttype=1';
|
|
|
176 |
$jsontype = $this->getDao()->consulter( $urltype );
|
|
|
177 |
$tableautype = (array) json_decode( $jsontype, true );
|
|
|
178 |
$retour['donnees']['type'] = $tableautype;
|
|
|
179 |
}//print_r($retour['donnees']);
|
| 3226 |
idir |
180 |
|
| 3233 |
idir |
181 |
return $retour;
|
|
|
182 |
}
|
|
|
183 |
private function traiterParametres() {
|
|
|
184 |
$parametres_flux = '?';
|
| 3281 |
delphine |
185 |
$criteres = array( 'projet', 'langue', 'titre' );
|
| 3226 |
idir |
186 |
|
| 3233 |
idir |
187 |
foreach( $this->parametres as $nom_critere => $valeur_critere ) {
|
|
|
188 |
if ( in_array( $nom_critere, $criteres ) ) {
|
|
|
189 |
$valeur_critere = str_replace( ' ', '%20', $valeur_critere );
|
|
|
190 |
$parametres_flux .= $nom_critere . '=' . $valeur_critere . '&';
|
|
|
191 |
}
|
|
|
192 |
}
|
| 3226 |
idir |
193 |
|
| 3233 |
idir |
194 |
$parametres_flux = ( $parametres_flux === '?' ) ? '' : rtrim( $parametres_flux, '&' );
|
| 3226 |
idir |
195 |
|
| 3233 |
idir |
196 |
return $parametres_flux;
|
|
|
197 |
}
|
| 3226 |
idir |
198 |
|
| 3233 |
idir |
199 |
private function traiterParametresModif() {
|
|
|
200 |
$parametres_modif = array();
|
| 3226 |
idir |
201 |
|
| 3233 |
idir |
202 |
foreach ( $_POST as $id => $parametres ) {
|
|
|
203 |
if ($parametres !== '' ) {
|
|
|
204 |
$parametres_modif[$id] = $parametres;
|
| 3282 |
delphine |
205 |
} else {
|
| 3358 |
idir |
206 |
$parametres_modif[$id] = ' ';
|
| 3233 |
idir |
207 |
}
|
|
|
208 |
}
|
|
|
209 |
return $parametres_modif;
|
|
|
210 |
}
|
| 3226 |
idir |
211 |
|
| 3233 |
idir |
212 |
private function traiterDonneesFiles() {
|
|
|
213 |
$return = array();
|
|
|
214 |
$transmettre_donnees = false;
|
|
|
215 |
$files_names = array();
|
|
|
216 |
$help_files_names = array();
|
|
|
217 |
$error =
|
|
|
218 |
"<div class=\"message-echec container\">Echec du téléchargement : ".
|
| 3358 |
idir |
219 |
"L\'extention de l\'image pour " . $nom . " n\'est pas bonne".
|
|
|
220 |
", formats acceptés : png, gif, jpg, jpeg, ou csv.".
|
| 3233 |
idir |
221 |
"</div>";
|
| 3241 |
idir |
222 |
$image_projet_langue = ( $this->parametres['langue'] !== 'fr' ) ? '_' . $this->parametres['langue'] : '';
|
|
|
223 |
$dossier_url = __DIR__ . '/squelettes/img/images_projets/' . $_POST['projet'] . $image_projet_langue . '/';
|
| 3226 |
idir |
224 |
|
| 3233 |
idir |
225 |
foreach ( array_keys( $_FILES ) as $file ) {
|
|
|
226 |
if ( $_FILES[$file]['name'] !== '' ) {
|
|
|
227 |
$extension = $this->obtenirExtension( $_FILES[$file] );
|
| 3226 |
idir |
228 |
|
| 3233 |
idir |
229 |
if ( $extension ) {
|
|
|
230 |
$transmettre_donnees = true;
|
| 3226 |
idir |
231 |
|
| 3358 |
idir |
232 |
if ( strstr( $file, 'help-') ) {
|
|
|
233 |
// Pas besoin de $return :
|
|
|
234 |
// Type déjà transmis dans le json des champs supp
|
| 3235 |
idir |
235 |
$real_file_key = str_replace( 'help-', '', $file );
|
|
|
236 |
$help_files_names[$real_file_key] = $real_file_key . '.' . $extension;
|
|
|
237 |
} else {
|
|
|
238 |
$return[$file] = $_FILES[$file]['type'];
|
| 3358 |
idir |
239 |
$files_names[$file] = $file .'.' . $extension;
|
| 3233 |
idir |
240 |
}
|
|
|
241 |
} else {
|
|
|
242 |
echo (
|
|
|
243 |
"<div class=\"message-echec container\">Echec du téléchargement : ".
|
| 3358 |
idir |
244 |
"L\'extention de l\'image pour " . $nom . " n\'est pas bonne".
|
|
|
245 |
", formats acceptés : png, gif, jpg, jpeg, ou csv.".
|
| 3233 |
idir |
246 |
"</div>"
|
|
|
247 |
);
|
|
|
248 |
}
|
|
|
249 |
}
|
|
|
250 |
}
|
| 3226 |
idir |
251 |
|
| 3233 |
idir |
252 |
if ( $transmettre_donnees ) {
|
|
|
253 |
if( !is_dir( $dossier_url ) ) {
|
|
|
254 |
mkdir( $dossier_url, 0755 );
|
|
|
255 |
}
|
|
|
256 |
// Téléversements
|
|
|
257 |
if ( count( $files_names ) > 0 ) {
|
|
|
258 |
foreach ( array_keys( $files_names ) as $file ) {
|
|
|
259 |
$this->televerser( $file, $files_names[ $file ], $dossier_url );
|
|
|
260 |
}
|
|
|
261 |
}
|
|
|
262 |
if ( count( $help_files_names ) > 0 ) {
|
|
|
263 |
foreach ( array_keys( $help_files_names ) as $file ) {
|
|
|
264 |
$this->televerser( 'help-' . $file, $help_files_names[ $file ], $dossier_url );
|
|
|
265 |
}
|
|
|
266 |
}
|
|
|
267 |
}
|
|
|
268 |
return $return;
|
|
|
269 |
}
|
| 3226 |
idir |
270 |
|
| 3233 |
idir |
271 |
private function televerser( $file, $full_name, $dossier_url ) {
|
| 3358 |
idir |
272 |
$taille_maxi = 5242880;
|
|
|
273 |
$taille = filesize( $_FILES[$file]['tmp_name'] );
|
|
|
274 |
$extension = $this->obtenirExtension( $_FILES[$file] );
|
|
|
275 |
$file_name = str_replace( '.' . $extension, '', $full_name );
|
|
|
276 |
$file_exists = file_exists( $dossier_url . $full_name );
|
|
|
277 |
$ex_file_name = $full_name;
|
| 3226 |
idir |
278 |
|
| 3358 |
idir |
279 |
// verifier l'existance d'un fichier avec une extention différente
|
|
|
280 |
// ex: logo.png vers logo.jpg
|
|
|
281 |
if ( !$file_exists ) {
|
|
|
282 |
switch ( $extension ) {
|
|
|
283 |
case 'png':
|
|
|
284 |
$ex_file_name = $file_name . '.jpg';
|
|
|
285 |
break;
|
|
|
286 |
case 'csv':
|
|
|
287 |
$ex_file_name = $file_name . '.tsv';
|
|
|
288 |
break;
|
|
|
289 |
case 'tsv':
|
|
|
290 |
$ex_file_name = $file_name . '.csv';
|
|
|
291 |
break;
|
|
|
292 |
case 'jpg':
|
|
|
293 |
default:
|
|
|
294 |
$ex_file_name = $file_name . '.png';
|
|
|
295 |
break;
|
|
|
296 |
}
|
|
|
297 |
$file_exists = file_exists( $dossier_url . $ex_file_name );
|
|
|
298 |
}
|
|
|
299 |
|
| 3233 |
idir |
300 |
//Début des vérifications de sécurité...
|
| 3358 |
idir |
301 |
if ( $file_exists ) {
|
|
|
302 |
if ( $this->parametres['mode'] === 'modification' ) {
|
| 3233 |
idir |
303 |
// Le fichier existe déjà, c'est normal si on est en mode modification
|
| 3358 |
idir |
304 |
unlink( $dossier_url . $ex_file_name );
|
| 3233 |
idir |
305 |
} else {
|
|
|
306 |
$erreur =
|
|
|
307 |
"<div class=\"message-echec container\">Echec du téléchargement : ".
|
|
|
308 |
"Un fichier pour \"" . $file_name.
|
|
|
309 |
"\", existe déjà dans un projet nommé \"" . $_POST['projet'] . "\".".
|
|
|
310 |
"<br>Vérifiez que le nom du projet n'est pas déjà pris, ".
|
|
|
311 |
"ou qu'un fichier \"" . $full_name . "\" n'ait pas déjà été téléchargé pour ce projet.".
|
|
|
312 |
"</div>";
|
|
|
313 |
}
|
|
|
314 |
}
|
| 3226 |
idir |
315 |
|
| 3233 |
idir |
316 |
if ( !$extension ) {
|
|
|
317 |
//Si le format n'est pas bon
|
|
|
318 |
$erreur =
|
|
|
319 |
"<div class=\"message-echec container\">".
|
|
|
320 |
"Echec du téléchargement pour ".
|
|
|
321 |
"\"" . $file_name . "\" ".
|
|
|
322 |
", formats acceptés : png, gif, jpg, jpeg, ou csv".
|
|
|
323 |
"</div>";
|
|
|
324 |
}
|
| 3226 |
idir |
325 |
|
| 3233 |
idir |
326 |
if ( $taille > $taille_maxi ) {
|
|
|
327 |
$erreur =
|
|
|
328 |
"<div class=\"message-echec container\">".
|
|
|
329 |
"Echec du téléchargement pour ".
|
|
|
330 |
"\"" . $file_name . "\" ".
|
|
|
331 |
": Max 5Mo".
|
|
|
332 |
"</div>";
|
|
|
333 |
}
|
| 3226 |
idir |
334 |
|
| 3233 |
idir |
335 |
if ( isset( $erreur ) ) {
|
|
|
336 |
echo $erreur;
|
|
|
337 |
} else {
|
| 3358 |
idir |
338 |
$dest_file = $dossier_url . $this->remove_accents( $full_name );
|
|
|
339 |
if ( !move_uploaded_file( $_FILES[$file]['tmp_name'], $dest_file ) ) {
|
| 3233 |
idir |
340 |
// move_uploaded_file() renvoie false si l'upload a échoué
|
|
|
341 |
echo
|
|
|
342 |
"<div class=\"message-echec container\">".
|
|
|
343 |
"Erreur du téléchargement pour ".
|
|
|
344 |
"\"" . $file_name . "\"".
|
|
|
345 |
"</div>";
|
| 3358 |
idir |
346 |
} else {
|
|
|
347 |
chmod($dest_file, 0666);
|
| 3233 |
idir |
348 |
}
|
|
|
349 |
}
|
|
|
350 |
}
|
| 3226 |
idir |
351 |
|
| 3233 |
idir |
352 |
private function obtenirExtension( $files ) {
|
|
|
353 |
$type = exif_imagetype( $files['tmp_name'] );
|
| 3358 |
idir |
354 |
|
| 3233 |
idir |
355 |
//une vérif pas mal pour les types image
|
|
|
356 |
if ( $type == ( IMAGETYPE_PNG || IMAGETYPE_JPEG || IMAGETYPE_GIF ) ) {
|
| 3358 |
idir |
357 |
switch ( $type ) {
|
|
|
358 |
case '1' :
|
|
|
359 |
$format = 'gif';
|
|
|
360 |
break;
|
|
|
361 |
case '2' :
|
|
|
362 |
$format = 'jpg';
|
|
|
363 |
break;
|
|
|
364 |
case '3' :
|
|
|
365 |
$format = 'png';
|
|
|
366 |
break;
|
|
|
367 |
default :
|
|
|
368 |
break;
|
|
|
369 |
}
|
|
|
370 |
} elseif ( str_replace( '.csv' , '', $files['name'] ) && substr( strrchr($files['type'], '/' ), 1 ) === 'csv' ) {
|
|
|
371 |
// Pas trouvé mieux pour csv :
|
|
|
372 |
// Les fonctions qui pourraient utiliser $_FILES[file]["tmp_path"] me répondent "text/plain"...
|
|
|
373 |
$format = 'csv';
|
|
|
374 |
} elseif ( str_replace( '.tsv' , '', $files['name'] ) && substr( strrchr($files['type'], '/' ), 1 ) === 'tsv' ) {
|
|
|
375 |
$format = 'tsv';
|
|
|
376 |
} else {
|
|
|
377 |
return false;
|
|
|
378 |
}
|
| 3233 |
idir |
379 |
return $format;
|
|
|
380 |
}
|
| 3360 |
idir |
381 |
// En prévision d'un service permettant la suppression/modification champs supp
|
|
|
382 |
/* Recherche si un projet a des champs de saisie supplémentaire */
|
|
|
383 |
private function rechercherChampsSupp() {
|
|
|
384 |
$retour = array();
|
|
|
385 |
$projet = $this->parametres['projet'];
|
|
|
386 |
$url = $this->config['manager']['celChpSupTpl'] .'?projet=' . $projet . '&langue=' . $this->parametres['langue'];
|
|
|
387 |
$json = $this->getDao()->consulter($url);
|
|
|
388 |
$retour = (array) json_decode($json, true);
|
| 3226 |
idir |
389 |
|
| 3360 |
idir |
390 |
foreach ( $retour[$projet]['champs-supp'] as $key => $chsup ) {
|
|
|
391 |
|
|
|
392 |
$retour[$projet]['champs-supp'][$key]['name'] = $this->clean_string( $chsup['name'] );
|
|
|
393 |
$retour[$projet]['champs-supp'][$key]['description'] = $this->clean_string( $chsup['description']);
|
|
|
394 |
$retour[$projet]['champs-supp'][$key]['unit'] = $this->clean_string( $chsup['unit'] );
|
|
|
395 |
|
|
|
396 |
if ( isset( $chsup['fieldValues'] ) ) {
|
|
|
397 |
$retour[$projet]['champs-supp'][$key]['fieldValues'] = json_decode( $this->clean_string( $chsup['fieldValues'] ), true );
|
|
|
398 |
|
|
|
399 |
if ( isset( $retour[$projet]['champs-supp'][$key]['fieldValues']['listValue'] ) ) {
|
|
|
400 |
foreach( $retour[$projet]['champs-supp'][$key]['fieldValues']['listValue'] as $list_key => $list_value_array ) {
|
|
|
401 |
// Obtenir une liste de valeurs utilisables dans les attributs for id ou name par exemple
|
|
|
402 |
$retour[$projet]['champs-supp'][$key]['fieldValues']['cleanListValue'][] = ($list_value_array !== 'other') ? 'val-' . preg_replace( '/[^A-Za-z0-9_\-]/', '', $this->remove_accents( strtolower($list_value_array[0] ) ) ) : '';
|
|
|
403 |
}
|
|
|
404 |
}
|
|
|
405 |
}
|
|
|
406 |
$retour[$projet]['champs-supp'][$key]['mandatory'] = intval( $chsup['mandatory'] );
|
|
|
407 |
}
|
|
|
408 |
return $retour;
|
|
|
409 |
}
|
|
|
410 |
|
|
|
411 |
// En prévision d'un service permettant la suppression/modification champs supp
|
|
|
412 |
private function clean_string( $string ) {
|
|
|
413 |
// les fonctions de base de php ne parviennent pas à une conversion satisfaisante des codes ascii
|
|
|
414 |
// qui ont été générés automatiquement lors de la transmission des chaines en json
|
|
|
415 |
// dans le widget cel manager vers la base
|
|
|
416 |
// Pour les mêmes raisons, @apos@ et @quot@ est une autre astuces utilisée dans ce même widget
|
|
|
417 |
// pour permettre la transmission des apostrophes et guillements sans erreur
|
|
|
418 |
$patterns = array( '/\@apos\@/', '/\@quot\@/', '/u00c0/', '/u00c1/', '/u00c2/', '/u00c3/', '/u00c4/', '/u00c5/', '/u00c6/', '/u00c7/', '/u00c8/', '/u00c9/', '/u00ca/', '/u00cb/', '/u00cc/', '/u00cd/', '/u00ce/', '/u00cf/', '/u00d1/', '/u00d2/', '/u00d3/', '/u00d4/', '/u00d5/', '/u00d6/', '/u00d8/', '/u00d9/', '/u00da/', '/u00db/', '/u00dc/', '/u00dd/', '/u00df/', '/u00e0/', '/u00e1/', '/u00e2/', '/u00e3/', '/u00e4/', '/u00e5/', '/u00e6/', '/u00e7/', '/u00e8/', '/u00e9/', '/u00ea/', '/u00eb/', '/u00ec/', '/u00ed/', '/u00ee/', '/u00ef/', '/u00f0/', '/u00f1/', '/u00f2/', '/u00f3/', '/u00f4/', '/u00f5/', '/u00f6/', '/u00f8/', '/u00f9/', '/u00fa/', '/u00fb/', '/u00fc/', '/u00fd/', '/u00ff/' );
|
|
|
419 |
$replacements = array( ''', '"', 'À', 'Á', 'Â', 'Ã', 'Ä', 'Å', 'Æ', 'Ç', 'È', 'É', 'Ê', 'Ë', 'Ì', 'Í', 'Î', 'Ï', 'Ñ', 'Ò', 'Ó', 'Ô', 'Õ', 'Ö', 'Ø', 'Ù', 'Ú', 'Û', 'Ü', 'Ý', 'ß', 'à', 'á', 'â', 'ã', 'ä', 'å', 'æ', 'ç', 'è', 'é', 'ê', 'ë', 'ì', 'í', 'î', 'ï', 'ð', 'ñ', 'ò', 'ó', 'ô', 'õ', 'ö', 'ø', 'ù', 'ú', 'û', 'ü', 'ý','ÿ' );
|
|
|
420 |
|
|
|
421 |
$clean_string = preg_replace( $patterns, $replacements, $string );
|
|
|
422 |
|
|
|
423 |
return $clean_string;
|
|
|
424 |
}
|
|
|
425 |
|
| 3233 |
idir |
426 |
private function remove_accents( $string ) {
|
|
|
427 |
if ( !preg_match( '/[\x80-\xff]/' , $string ) ) {
|
| 3226 |
idir |
428 |
|
| 3233 |
idir |
429 |
return $string;
|
|
|
430 |
}
|
| 3226 |
idir |
431 |
|
| 3233 |
idir |
432 |
$chars = array(
|
|
|
433 |
// Decompositions for Latin-1 Supplement
|
|
|
434 |
chr(195).chr(128) => 'A', chr(195).chr(129) => 'A',
|
|
|
435 |
chr(195).chr(130) => 'A', chr(195).chr(131) => 'A',
|
|
|
436 |
chr(195).chr(132) => 'A', chr(195).chr(133) => 'A',
|
|
|
437 |
chr(195).chr(135) => 'C', chr(195).chr(136) => 'E',
|
|
|
438 |
chr(195).chr(137) => 'E', chr(195).chr(138) => 'E',
|
|
|
439 |
chr(195).chr(139) => 'E', chr(195).chr(140) => 'I',
|
|
|
440 |
chr(195).chr(141) => 'I', chr(195).chr(142) => 'I',
|
|
|
441 |
chr(195).chr(143) => 'I', chr(195).chr(145) => 'N',
|
|
|
442 |
chr(195).chr(146) => 'O', chr(195).chr(147) => 'O',
|
|
|
443 |
chr(195).chr(148) => 'O', chr(195).chr(149) => 'O',
|
|
|
444 |
chr(195).chr(150) => 'O', chr(195).chr(153) => 'U',
|
|
|
445 |
chr(195).chr(154) => 'U', chr(195).chr(155) => 'U',
|
|
|
446 |
chr(195).chr(156) => 'U', chr(195).chr(157) => 'Y',
|
|
|
447 |
chr(195).chr(159) => 's', chr(195).chr(160) => 'a',
|
|
|
448 |
chr(195).chr(161) => 'a', chr(195).chr(162) => 'a',
|
|
|
449 |
chr(195).chr(163) => 'a', chr(195).chr(164) => 'a',
|
|
|
450 |
chr(195).chr(165) => 'a', chr(195).chr(167) => 'c',
|
|
|
451 |
chr(195).chr(168) => 'e', chr(195).chr(169) => 'e',
|
|
|
452 |
chr(195).chr(170) => 'e', chr(195).chr(171) => 'e',
|
|
|
453 |
chr(195).chr(172) => 'i', chr(195).chr(173) => 'i',
|
|
|
454 |
chr(195).chr(174) => 'i', chr(195).chr(175) => 'i',
|
|
|
455 |
chr(195).chr(177) => 'n', chr(195).chr(178) => 'o',
|
|
|
456 |
chr(195).chr(179) => 'o', chr(195).chr(180) => 'o',
|
|
|
457 |
chr(195).chr(181) => 'o', chr(195).chr(182) => 'o',
|
|
|
458 |
chr(195).chr(182) => 'o', chr(195).chr(185) => 'u',
|
|
|
459 |
chr(195).chr(186) => 'u', chr(195).chr(187) => 'u',
|
|
|
460 |
chr(195).chr(188) => 'u', chr(195).chr(189) => 'y',
|
|
|
461 |
chr(195).chr(191) => 'y',
|
|
|
462 |
// Decompositions for Latin Extended-A
|
|
|
463 |
chr(196).chr(128) => 'A', chr(196).chr(129) => 'a',
|
|
|
464 |
chr(196).chr(130) => 'A', chr(196).chr(131) => 'a',
|
|
|
465 |
chr(196).chr(132) => 'A', chr(196).chr(133) => 'a',
|
|
|
466 |
chr(196).chr(134) => 'C', chr(196).chr(135) => 'c',
|
|
|
467 |
chr(196).chr(136) => 'C', chr(196).chr(137) => 'c',
|
|
|
468 |
chr(196).chr(138) => 'C', chr(196).chr(139) => 'c',
|
|
|
469 |
chr(196).chr(140) => 'C', chr(196).chr(141) => 'c',
|
|
|
470 |
chr(196).chr(142) => 'D', chr(196).chr(143) => 'd',
|
|
|
471 |
chr(196).chr(144) => 'D', chr(196).chr(145) => 'd',
|
|
|
472 |
chr(196).chr(146) => 'E', chr(196).chr(147) => 'e',
|
|
|
473 |
chr(196).chr(148) => 'E', chr(196).chr(149) => 'e',
|
|
|
474 |
chr(196).chr(150) => 'E', chr(196).chr(151) => 'e',
|
|
|
475 |
chr(196).chr(152) => 'E', chr(196).chr(153) => 'e',
|
|
|
476 |
chr(196).chr(154) => 'E', chr(196).chr(155) => 'e',
|
|
|
477 |
chr(196).chr(156) => 'G', chr(196).chr(157) => 'g',
|
|
|
478 |
chr(196).chr(158) => 'G', chr(196).chr(159) => 'g',
|
|
|
479 |
chr(196).chr(160) => 'G', chr(196).chr(161) => 'g',
|
|
|
480 |
chr(196).chr(162) => 'G', chr(196).chr(163) => 'g',
|
|
|
481 |
chr(196).chr(164) => 'H', chr(196).chr(165) => 'h',
|
|
|
482 |
chr(196).chr(166) => 'H', chr(196).chr(167) => 'h',
|
|
|
483 |
chr(196).chr(168) => 'I', chr(196).chr(169) => 'i',
|
|
|
484 |
chr(196).chr(170) => 'I', chr(196).chr(171) => 'i',
|
|
|
485 |
chr(196).chr(172) => 'I', chr(196).chr(173) => 'i',
|
|
|
486 |
chr(196).chr(174) => 'I', chr(196).chr(175) => 'i',
|
|
|
487 |
chr(196).chr(176) => 'I', chr(196).chr(177) => 'i',
|
|
|
488 |
chr(196).chr(178) => 'IJ',chr(196).chr(179) => 'ij',
|
|
|
489 |
chr(196).chr(180) => 'J', chr(196).chr(181) => 'j',
|
|
|
490 |
chr(196).chr(182) => 'K', chr(196).chr(183) => 'k',
|
|
|
491 |
chr(196).chr(184) => 'k', chr(196).chr(185) => 'L',
|
|
|
492 |
chr(196).chr(186) => 'l', chr(196).chr(187) => 'L',
|
|
|
493 |
chr(196).chr(188) => 'l', chr(196).chr(189) => 'L',
|
|
|
494 |
chr(196).chr(190) => 'l', chr(196).chr(191) => 'L',
|
|
|
495 |
chr(197).chr(128) => 'l', chr(197).chr(129) => 'L',
|
|
|
496 |
chr(197).chr(130) => 'l', chr(197).chr(131) => 'N',
|
|
|
497 |
chr(197).chr(132) => 'n', chr(197).chr(133) => 'N',
|
|
|
498 |
chr(197).chr(134) => 'n', chr(197).chr(135) => 'N',
|
|
|
499 |
chr(197).chr(136) => 'n', chr(197).chr(137) => 'N',
|
|
|
500 |
chr(197).chr(138) => 'n', chr(197).chr(139) => 'N',
|
|
|
501 |
chr(197).chr(140) => 'O', chr(197).chr(141) => 'o',
|
|
|
502 |
chr(197).chr(142) => 'O', chr(197).chr(143) => 'o',
|
|
|
503 |
chr(197).chr(144) => 'O', chr(197).chr(145) => 'o',
|
|
|
504 |
chr(197).chr(146) => 'OE',chr(197).chr(147) => 'oe',
|
|
|
505 |
chr(197).chr(148) => 'R',chr(197).chr(149) => 'r',
|
|
|
506 |
chr(197).chr(150) => 'R',chr(197).chr(151) => 'r',
|
|
|
507 |
chr(197).chr(152) => 'R',chr(197).chr(153) => 'r',
|
|
|
508 |
chr(197).chr(154) => 'S',chr(197).chr(155) => 's',
|
|
|
509 |
chr(197).chr(156) => 'S',chr(197).chr(157) => 's',
|
|
|
510 |
chr(197).chr(158) => 'S',chr(197).chr(159) => 's',
|
|
|
511 |
chr(197).chr(160) => 'S', chr(197).chr(161) => 's',
|
|
|
512 |
chr(197).chr(162) => 'T', chr(197).chr(163) => 't',
|
|
|
513 |
chr(197).chr(164) => 'T', chr(197).chr(165) => 't',
|
|
|
514 |
chr(197).chr(166) => 'T', chr(197).chr(167) => 't',
|
|
|
515 |
chr(197).chr(168) => 'U', chr(197).chr(169) => 'u',
|
|
|
516 |
chr(197).chr(170) => 'U', chr(197).chr(171) => 'u',
|
|
|
517 |
chr(197).chr(172) => 'U', chr(197).chr(173) => 'u',
|
|
|
518 |
chr(197).chr(174) => 'U', chr(197).chr(175) => 'u',
|
|
|
519 |
chr(197).chr(176) => 'U', chr(197).chr(177) => 'u',
|
|
|
520 |
chr(197).chr(178) => 'U', chr(197).chr(179) => 'u',
|
|
|
521 |
chr(197).chr(180) => 'W', chr(197).chr(181) => 'w',
|
|
|
522 |
chr(197).chr(182) => 'Y', chr(197).chr(183) => 'y',
|
|
|
523 |
chr(197).chr(184) => 'Y', chr(197).chr(185) => 'Z',
|
|
|
524 |
chr(197).chr(186) => 'z', chr(197).chr(187) => 'Z',
|
|
|
525 |
chr(197).chr(188) => 'z', chr(197).chr(189) => 'Z',
|
|
|
526 |
chr(197).chr(190) => 'z', chr(197).chr(191) => 's'
|
|
|
527 |
);
|
| 3226 |
idir |
528 |
|
| 3233 |
idir |
529 |
$string = strtr( $string, $chars );
|
| 3226 |
idir |
530 |
|
| 3233 |
idir |
531 |
return preg_replace( '/([^.a-z0-9]+)/i', '-', $string );
|
|
|
532 |
}
|
| 3122 |
delphine |
533 |
}
|