Subversion Repositories eFlore/Applications.cel

Rev

Rev 3136 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 3136 Rev 3396
Line 23... Line 23...
23 
 */
 23 
 */
Line 24... Line 24...
24 
 
 24 
 
Line 25... Line 25...
25 
 
 25 
 
26 
class CelWidgetManager extends Cel {
 - 
 
27 
 
 26 
class CelWidgetManager extends Cel {
28 
	// certains paramètres apparaissent plusieurs fois car ils ont des alias
 27 
 
29 
	// dans certains widgets
 28 
	// correspondance entre les champs de l'interface et les champs de la BD (format 2018 / 2019)
30 
	private $parametres_autorises = array(
 29 
	private $parametres_autorises = array(
31 
		'projet' => 'projet',
 30 
			'projet' => 'project',
32 
		'type' => 'type',
 31 
			'type' => 'type',
- 
 
 32 
			'esttype' => 'istype',
- 
 
 33 
			'langue' => 'language',
- 
 
 34 
			'order' => 'order'
- 
 
 35 
	);
- 
 
 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',
- 
 
 53 
			'motscles' =>  'project_tag_name',
- 
 
 54 
			'info' =>  'info'
- 
 
 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",
33 
		'esttype' => 'est_type',
 67 
			"description" => "description",
Line 34... Line 68...
34 
		'langue' => 'langue',
 68 
			"fieldValues" => "default_value",
35 
		'order' => 'order'
 69 
			"help" => "help"
36 
	);
 70 
	);
Line 37... Line 71...
37 
 
 71 
 
38 
	public function getRessource() {
 72 
	public function getRessource() {
39 
		return $this->getElement(array());
 73 
		return $this->getElement(array());
40 
	}
 74 
	}
41 
 
 75 
 
42 
	/**
 76 
	/**
43 
	 * Méthode appelée avec une requête de type GET.
 77 
	 * Méthode appelée avec une requête de type GET.
44 
	 */
 78 
	 */
45 
	public function getElement($params = array()) {
- 
 
- 
 
 79 
	public function getElement($params = array()) {
- 
 
 80 
		switch(@strtolower($params[0])) {
46 
		switch(@strtolower($params[0])) {
 81 
		case 'widget':
47 
		case 'widget':
 82 
			$this->getWidget();
48 
			$this->getWidget();
 83 
			break;
49 
			break;
 84 
		case 'champsetendus';
50 
 
 85 
			$this->getChampsEtendus();
Line 51... Line 86...
51 
 
 86 
			break;
52 
		default:
 87 
		default:
- 
 
 88 
			$this->getWidget();
- 
 
 89 
		}
- 
 
 90 
	}
- 
 
 91
- 
 
 92
- 
 
 93 
	public function createElement($requeteDonnees) {
53 
			$this->getWidget();
 94 
		unset($requeteDonnees['signup_submit']);
54 
		}
 95 
		if (isset($requeteDonnees['champs-supp'])) {
- 
 
 96 
			$gestionchamps = new GestionChampsEtendus2($this->config);
55 
	}
 97 
			$champs = $this->traiterCorrespondanceChampsEtendusInterfaceBD($requeteDonnees); //var_dump($champs);exit;
- 
 
 98 
			$liste = $gestionchamps->ajouterParProjet($champs);
56
99 
			unset($requeteDonnees['champs-supp']);
Line 57... Line 100...
57
100 
		}
Line 58... Line 101...
58 
	public function createElement($requeteDonnees) {
 101 
		$requeteDonnees['est_type'] = (isset($requeteDonnees['est_type']) && $requeteDonnees['est_type']== "on") ? 1 : 0;
59 
		unset($requeteDonnees['signup_submit']);
 102 
		$manager = new GestionWidget($this->config);
60 
		$requeteDonnees['est_type'] = (isset($requeteDonnees['est_type']) && $requeteDonnees['est_type']== "on") ? '1' : '0';
 103 
		$requeteDonnees = $this->traiterCorresponceConfigWidgetInterfaceBD($requeteDonnees);
61 
		$manager = new GestionWidget($this->config);
 104 
		$retour = $manager->ajouterWidget($requeteDonnees);
62 
		$retour = $manager->ajouterWidget($requeteDonnees);
 105 
 
- 
 
 106 
		$this->envoyerJson($retour);
63 
		$this->envoyerJson($retour);
 107 
 
Line 64... Line 108...
64 
 
 108 
	}
65 
	}
 109
66
110 
	public function updateElement($uid,$params) {
Line 67... Line 111...
67 
	public function updateElement($uid,$params) {
 111 
		$retour = "";
Line 68... Line 112...
68 
		$retour = "";
 112 
		if (isset($params['projet']) && isset($params['langue'])) {
69 
		if (isset($params['projet']) && isset($params['langue'])) {
 113 
		    $manager = new GestionWidget($this->config);
70 
			$manager = new GestionWidget($this->config);
 114 
		    $params['est_type'] = (isset($params['est_type']) && $params['est_type']== "on") ? 1 : 0;
71 
			$params['est_type'] = (isset($params['est_type']) && $params['est_type']== "on") ? '1' : '0';
 115 
		    $requeteDonnees = $this->traiterCorresponceConfigWidgetInterfaceBD($params);
72 
			$retour = $manager->modifierWidget($params['projet'], $params['langue'], $params);
 - 
 
- 
 
 116 
			$retour = $manager->modifierWidget($params['projet'], $params['langue'], $requeteDonnees);
Line 73... Line 117...
73
117
74 
		}
 118 
		}
- 
 
 119 
		$this->envoyerJson($retour);
- 
 
 120 
		return "ff";
- 
 
 121
- 
 
 122 
	}
- 
 
 123 
 
- 
 
 124 
	private function getWidget() {
- 
 
 125 
		$criteres = $this->traiterParametresAutorises($_GET);
- 
 
 126 
		$manager = new GestionWidget($this->config);
- 
 
 127 
		$liste = $manager->obtenirWidget($criteres);
- 
 
 128 
		$liste = $this->traiterCorresponceConfigWidgetBDInterface($liste);
Line 75... Line 129...
75 
		$this->envoyerJson($retour);
 129 
 
76 
		return "ff";
 130 
		$this->envoyerJson($liste);
Line 96... Line 150...
96 
				$parametres_traites[$this->parametres_autorises[$cle]] = $valeur;
 150 
				$parametres_traites[$this->parametres_autorises[$cle]] = $valeur;
97 
			}
 151 
			}
98 
		}
 152 
		}
99 
		return $parametres_traites;
 153 
		return $parametres_traites;
100 
	}
 154 
	}
- 
 
 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) {
- 
 
 174 
				if(is_string($valeur) && !trim($valeur)) $valeur=NULL;
- 
 
 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 
	}
Line 101... Line 239...
101 
 
 239 
 
102 
 
 240 
 
103 
}
 241 
}