Subversion Repositories eFlore/Applications.cel

Rev

Rev 3283 | Rev 3517 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
3092 delphine 1 
<?php
2 
// declare(encoding='UTF-8');
3 
/**
4 
 * Service fournissant des informations sur les widgets existants et permettant d'en créer d'autres.
5 
 *
6 
 * Format du service :
7 
 * /CelWidgetExport/format
8 
 * /CelWidgetExport/csv
9 
 *
10 
 * Les paramêtres :
11 
 *  - "start" indique le numéro du premier item à afficher
12 
 *  - "limit" nombre d'items à afficher
13 
 *
14 
 * @internal   Mininum PHP version : 5.2
15 
 * @category   CEL
16 
 * @package    Services
17 
 * @subpackage Widget
18 
 * @version    0.1
19 
 * @author     Delphine CAUQUIL <delphine@tela-botanica.org>
20 
 * @license    GPL v3 <http://www.gnu.org/licenses/gpl.txt>
21 
 * @license    CECILL v2 <http://www.cecill.info/licences/Licence_CeCILL_V2-en.txt>
22 
 * @copyright  1999-2017 Tela Botanica <accueil@tela-botanica.org>
23 
 */
24 
 
25 
 
26 
class CelWidgetManager extends Cel {
27 
 
3193 delphine 28 
	// correspondance entre les champs de l'interface et les champs de la BD (format 2018 / 2019)
3092 delphine 29 
	private $parametres_autorises = array(
3193 delphine 30 
			'projet' => 'project',
31 
			'type' => 'type',
3486 delphine 32 
			'esttype' => 'is_type',
3193 delphine 33 
			'langue' => 'language',
34 
			'order' => 'order'
3092 delphine 35 
	);
3193 delphine 36 
 
37 
	private $correspondance_config_widget= array(
38 
			'projet' =>  'project',
39 
			'langue' =>  'language',
40 
			'titre' =>  'title',
41 
			'logo' =>  'logo',
42 
			'description' =>  'description',
43 
			'type' =>  'type',
44 
			'est_type' =>  'is_type',
45 
			'style_css' =>  'css_style',
46 
			'image_fond' =>  'image_font',
47 
			'date_creation' =>  'date_created',
48 
			'type_especes' =>  'taxo_restriction_type',
49 
			'referentiel' =>  'taxo_restriction_value',
50 
			'type_localisation' =>  'location_type',
51 
			'localisation' =>  'location',
52 
			'milieux' =>  'environments',
3216 delphine 53 
			'motscles' =>  'project_tag_name',
54 
			'info' =>  'info'
3193 delphine 55 
	);
56 
 
57 
	private $correspondance_champs_etendus = array(
58 
			"key" => "field_id",
59 
			"element" => "data_type",
60 
			"mandatory" => "is_mandatory",
61 
			"unit" => "unit"
62 
	);
63 
 
64 
	private $correspondance_champs_etendus_trad = array(
65 
			"key" => "extended_field_id",
66 
			"name" => "label",
67 
			"description" => "description",
3216 delphine 68 
			"fieldValues" => "default_value",
69 
			"help" => "help"
3193 delphine 70 
	);
3092 delphine 71 
 
72 
	public function getRessource() {
73 
		return $this->getElement(array());
74 
	}
75 
 
76 
	/**
77 
	 * Méthode appelée avec une requête de type GET.
78 
	 */
3193 delphine 79 
	public function getElement($params = array()) {
80 
		switch(@strtolower($params[0])) {
3092 delphine 81 
		case 'widget':
82 
			$this->getWidget();
83 
			break;
3193 delphine 84 
		case 'champsetendus';
85 
			$this->getChampsEtendus();
86 
			break;
3092 delphine 87 
		default:
88 
			$this->getWidget();
89 
		}
90 
	}
3193 delphine 91 
 
92 
 
3092 delphine 93 
	public function createElement($requeteDonnees) {
94 
		unset($requeteDonnees['signup_submit']);
3193 delphine 95 
		if (isset($requeteDonnees['champs-supp'])) {
96 
			$gestionchamps = new GestionChampsEtendus2($this->config);
97 
			$champs = $this->traiterCorrespondanceChampsEtendusInterfaceBD($requeteDonnees); //var_dump($champs);exit;
98 
			$liste = $gestionchamps->ajouterParProjet($champs);
99 
			unset($requeteDonnees['champs-supp']);
100 
		}
3283 delphine 101 
		$requeteDonnees['est_type'] = (isset($requeteDonnees['est_type']) && $requeteDonnees['est_type']== "on") ? 1 : 0;
3092 delphine 102 
		$manager = new GestionWidget($this->config);
3193 delphine 103 
		$requeteDonnees = $this->traiterCorresponceConfigWidgetInterfaceBD($requeteDonnees);
3092 delphine 104 
		$retour = $manager->ajouterWidget($requeteDonnees);
3193 delphine 105 
 
3092 delphine 106 
		$this->envoyerJson($retour);
107 
 
108 
	}
3193 delphine 109 
 
3121 delphine 110 
	public function updateElement($uid,$params) {
111 
		$retour = "";
112 
		if (isset($params['projet']) && isset($params['langue'])) {
3283 delphine 113 
		    $manager = new GestionWidget($this->config);
114 
		    $params['est_type'] = (isset($params['est_type']) && $params['est_type']== "on") ? 1 : 0;
115 
		    $requeteDonnees = $this->traiterCorresponceConfigWidgetInterfaceBD($params);
3193 delphine 116 
			$retour = $manager->modifierWidget($params['projet'], $params['langue'], $requeteDonnees);
117 
 
3121 delphine 118 
		}
119 
		$this->envoyerJson($retour);
120 
		return "ff";
3193 delphine 121 
 
3092 delphine 122 
	}
123 
 
124 
	private function getWidget() {
3193 delphine 125 
		$criteres = $this->traiterParametresAutorises($_GET);
3092 delphine 126 
		$manager = new GestionWidget($this->config);
127 
		$liste = $manager->obtenirWidget($criteres);
3193 delphine 128 
		$liste = $this->traiterCorresponceConfigWidgetBDInterface($liste);
3092 delphine 129 
 
130 
		$this->envoyerJson($liste);
131 
	}
3193 delphine 132 
 
133 
	private function getChampsEtendus() {
134 
		$champs = new GestionChampsEtendus2($this->config);
135 
		$projet = (isset($_GET['projet'])) ? $_GET['projet'] : "";
136 
		$langue = (isset($_GET['langue'])) ? $_GET['langue'] : "fr";
137 
		$liste = $champs->consulterProjetChampsEtendus($projet, $langue);
138 
		$liste = $this->traiterCorrespondanceChampsEtendusBDInterface($liste);
139 
 
140 
		$this->envoyerJson($liste);
141 
	}
3092 delphine 142 
 
143 
 
144 
	protected function traiterParametresAutorises(Array $parametres) {
145 
		$parametres_traites = array();
3193 delphine 146 
 
3092 delphine 147 
		foreach($parametres as $cle => $valeur) {
148 
			if(is_string($valeur) && !trim($valeur)) continue;
149 
			if(isset($this->parametres_autorises[$cle])) {
150 
				$parametres_traites[$this->parametres_autorises[$cle]] = $valeur;
151 
			}
152 
		}
153 
		return $parametres_traites;
154 
	}
3193 delphine 155 
 
156 
	protected function traiterCorresponceConfigWidgetBDInterface(Array $widgets) {
157 
		$parametres_traites = array();
158 
		$corresp = array_flip($this->correspondance_config_widget);
159 
		foreach($widgets as $id => $widget) {
160 
			foreach($widget as $cle => $valeur) {
161 
				if(is_string($valeur) && !trim($valeur)) continue;
162 
				if(isset($corresp[$cle])) {
163 
					$parametres_traites[$id][$corresp[$cle]] = $valeur;
164 
				}
165 
			}
166 
		}
167 
		return $parametres_traites;
168 
	}
169 
 
170 
	protected function traiterCorresponceConfigWidgetInterfaceBD(Array $parametres) {
171 
		$parametres_traites = array();
172 
		$corresp = $this->correspondance_config_widget;
173 
		foreach($parametres as $cle => $valeur) {
3283 delphine 174 
				if(is_string($valeur) && !trim($valeur)) $valeur=NULL;
3193 delphine 175 
				if(isset($corresp[$cle])) {
176 
					$parametres_traites[$corresp[$cle]] = $valeur;
177 
				}
178 
			}
179 
		return $parametres_traites;
180 
	}
181 
 
182 
	protected function traiterCorrespondanceChampsEtendusInterfaceBD(Array $champsinterface) {
183 
		$champsrequete = array(); $i = 0;
184 
		$champssupp = json_decode($champsinterface['champs-supp'], true);
185 
		// pour chaque champs-supp, mettre correspondance extended field et extended field trad
186 
		foreach ($champssupp as $champ) {
187 
			$champsrequete['ce'][$i]['project'] = $champsrequete['cet'][$i]['project'] = $champsinterface['projet'];
188 
			$champsrequete['cet'][$i]['language_iso_code'] = $champsinterface['langue'];
189 
			// pour la table extended fiels champs interface => champs bd
190 
			foreach ($this->correspondance_champs_etendus as $ci => $ce) {
191 
				if (isset($champ[$ci]) && $champ[$ci] != "") {
192 
					$champsrequete['ce'][$i][$ce] = $champ[$ci];
193 
				} else {
194 
					if ($ci == "mandatory") {
195 
						$champsrequete['ce'][$i][$ce] = "0";
196 
					} else {
197 
						$champsrequete['ce'][$i][$ce] = "";
198 
					}
199 
				}
200 
			}
201 
			// pour la table extended fiels trad champs interface => champs bd
202 
			foreach ($this->correspondance_champs_etendus_trad as $cit => $cr) {
203 
				if (isset($champ[$cit]) && is_array($champ[$cit])) {
204 
					$champsrequete['cet'][$i][$cr] = json_encode($champ[$cit]);
205 
				} elseif (isset($champ[$cit]) && $champ[$cit] != "") {
206 
					$champsrequete['cet'][$i][$cr] = $champ[$cit];
207 
				} else {
208 
					$champsrequete['cet'][$i][$cr] = "";
209 
				}
210 
			}
211 
			$i++;
212 
		}
213 
		return $champsrequete;
214 
	}
215 
	protected function traiterCorrespondanceChampsEtendusBDInterface(Array $champsrequete) {
216 
		$champssupp = array(); $i = 0;
217 
		foreach ($champsrequete as $champ) {
218 
			$champssupp[$champ['project']]['projet'] = $champ['project'];
219 
			$champssupp[$champ['project']]['langue'] = $champ['language_iso_code'];
220 
			// pour la table extended fiels champs interface => champs bd
221 
			foreach ($this->correspondance_champs_etendus as $ci => $ce) {
222 
				if (isset($champ[$ce]) && $champ[$ce] != "") {
223 
					$champssupp[$champ['project']]['champs-supp'][$i][$ci] = $champ[$ce];
224 
				} else {
225 
					$champssupp[$champ['project']]['champs-supp'][$i][$ci]= "";
226 
				}
227 
			}
228 
			// pour la table extended fiels trad champs interface => champs bd
229 
			foreach ($this->correspondance_champs_etendus_trad as $cet => $cr) {
230 
				if (isset($champ[$cr]) && $champ[$cr] != "") {
231 
					$champssupp[$champ['project']]['champs-supp'][$i][$cet]= $champ[$cr];
232 
				} else {
233 
					$champssupp[$champ['project']]['champs-supp'][$i][$cet]="";
234 
				}
235 
			}$i++;
236 
		}
237 
		return $champssupp;
238 
	}
3092 delphine 239 
 
240 
 
241 
}
3193 delphine 242 
?>