WebSVN – eFlore/Applications.cel – Diff – /trunk/jrest/services/CelWidgetManager.php


<?php
// declare(encoding='UTF-8');
/**
 * Service fournissant des informations sur les widgets existants et permettant d'en créer d'autres.
 *
 * Format du service :
 * /CelWidgetExport/format
 * /CelWidgetExport/csv
 *
 * Les paramêtres :
 *  - "start" indique le numéro du premier item à afficher
 *  - "limit" nombre d'items à afficher
 *
 * @internal   Mininum PHP version : 5.2
 * @category   CEL
 * @package    Services
 * @subpackage Widget
 * @version    0.1
 * @author     Delphine CAUQUIL <delphine@tela-botanica.org>
 * @license    GPL v3 <http://www.gnu.org/licenses/gpl.txt>
 * @license    CECILL v2 <http://www.cecill.info/licences/Licence_CeCILL_V2-en.txt>
 * @copyright  1999-2017 Tela Botanica <accueil@tela-botanica.org>
 */
 
 
class CelWidgetManager extends Cel {
 
	// correspondance entre les champs de l'interface et les champs de la BD (format 2018 / 2019)
	private $parametres_autorises = array(
			'projet' => 'project',
			'type' => 'type',
			'esttype' => 'is_type',
			'langue' => 'language',
			'order' => 'order'
	);
	
	private $correspondance_config_widget= array(
			'projet' =>  'project',
			'langue' =>  'language',
			'titre' =>  'title',
			'logo' =>  'logo',
			'description' =>  'description',
			'type' =>  'type',
			'est_type' =>  'is_type',
			'style_css' =>  'css_style',
			'image_fond' =>  'image_font',
			'date_creation' =>  'date_created',
			'type_especes' =>  'taxo_restriction_type',
			'referentiel' =>  'taxo_restriction_value',
			'type_localisation' =>  'location_type',
			'localisation' =>  'location',
	        'fond_carte' => 'basemap', 
	        'adresse' => 'is_mandatory_address',
	        'photo_obligatoire' => 'is_mandatory_photo',
			'milieux' =>  'environment',
			'motscles' =>  'project_tag_name',
			'info' =>  'info',
	        'id_projet' => 'project_id'
	);
	
	private $correspondance_champs_etendus = array(
			"key" => "field_id",
			"element" => "data_type",
			"mandatory" => "is_mandatory",
			"unit" => "unit"
	);
	
	private $correspondance_champs_etendus_trad = array(
			"key" => "extended_field_id",
			"name" => "label",
			"description" => "description",
			"fieldValues" => "default_value",
			"help" => "help"
	);
 
	public function getRessource() {
		return $this->getElement(array());
	}
 
	/**
	 * Méthode appelée avec une requête de type GET.
	 */
	public function getElement($params = array()) { 
		switch(@strtolower($params[0])) { 
		case 'widget':
			$this->getWidget();
			break;
		case 'champsetendus';
			$this->getChampsEtendus();
			break;
		default:
			$this->getWidget();
		}
	}
	
	
	public function createElement($requeteDonnees) {
		unset($requeteDonnees['signup_submit']);
		if (isset($requeteDonnees['champs-supp'])) {
			$gestionchamps = new GestionChampsEtendus2($this->config);
			$champs = $this->traiterCorrespondanceChampsEtendusInterfaceBD($requeteDonnees); //var_dump($champs);exit;
			$liste = $gestionchamps->ajouterParProjet($champs); 
			unset($requeteDonnees['champs-supp']);
		}
		$requeteDonnees['est_type'] = (isset($requeteDonnees['est_type']) && $requeteDonnees['est_type']== "on") ? 1 : 0;
		$manager = new GestionWidget($this->config);
		$requeteDonnees = $this->traiterCorresponceConfigWidgetInterfaceBD($requeteDonnees);
		$retour = $manager->ajouterWidget($requeteDonnees);
 
		$this->envoyerJson($retour);
 
	}
	
	public function updateElement($uid,$params) {
		$retour = "";
		if (isset($params['projet']) && isset($params['langue'])) {
		    if (isset($params['champs-supp'])) {
		        $gestionchamps = new GestionChampsEtendus2($this->config);
		        $champs = $this->traiterCorrespondanceChampsEtendusInterfaceBD($params); //var_dump($champs);exit;
		        $liste = $gestionchamps->modifierParProjet($champs);
		        unset($params['champs-supp']);
		    }
		    $manager = new GestionWidget($this->config);
		    $params['est_type'] = (isset($params['est_type']) && $params['est_type']== "on") ? 1 : 0;
		    $requeteDonnees = $this->traiterCorresponceConfigWidgetInterfaceBD($params);
			$retour = $manager->modifierWidget($params['projet'], $params['langue'], $requeteDonnees);
			
		}
		$this->envoyerJson($retour);
		return "ff";
		
	}
 
	private function getWidget() {
		$criteres = $this->traiterParametresAutorises($_GET); 
		$manager = new GestionWidget($this->config);
		$liste = $manager->obtenirWidget($criteres);
		$liste = $this->traiterCorresponceConfigWidgetBDInterface($liste);
 
		$this->envoyerJson($liste);
	}
	
	private function getChampsEtendus() {
		$champs = new GestionChampsEtendus2($this->config);
		$projet = (isset($_GET['projet'])) ? $_GET['projet'] : "";
		$langue = (isset($_GET['langue'])) ? $_GET['langue'] : "fr";
		$liste = $champs->consulterProjetChampsEtendus($projet, $langue);
		$liste = $this->traiterCorrespondanceChampsEtendusBDInterface($liste, $projet);
		
		$this->envoyerJson($liste);
	}
 
 
	protected function traiterParametresAutorises(Array $parametres) {
		$parametres_traites = array();
		
		foreach($parametres as $cle => $valeur) {
			if(is_string($valeur) && !trim($valeur)) continue;
			if(isset($this->parametres_autorises[$cle])) {
				$parametres_traites[$this->parametres_autorises[$cle]] = $valeur;
			}
		}
		return $parametres_traites;
	}
	
	protected function traiterCorresponceConfigWidgetBDInterface(Array $widgets) {
		$parametres_traites = array();
		$corresp = array_flip($this->correspondance_config_widget);
		foreach($widgets as $id => $widget) {
			foreach($widget as $cle => $valeur) {
				if(is_string($valeur) && !trim($valeur)) continue;
				if(isset($corresp[$cle])) {
					$parametres_traites[$id][$corresp[$cle]] = $valeur;
				}
			}
		}
		return $parametres_traites;
	}
	
	protected function traiterCorresponceConfigWidgetInterfaceBD(Array $parametres) {
		$parametres_traites = array();
		$corresp = $this->correspondance_config_widget;
		foreach($parametres as $cle => $valeur) {
				if(is_string($valeur) && !trim($valeur)) $valeur=NULL;
				if(isset($corresp[$cle])) {
					$parametres_traites[$corresp[$cle]] = $valeur;
				}
			}
		return $parametres_traites;
	}
	
	protected function traiterCorrespondanceChampsEtendusInterfaceBD(Array $champsinterface) {
		$champsrequete = array(); $i = 0;
		$champssupp = json_decode($champsinterface['champs-supp'], true); 
		// pour chaque champs-supp, mettre correspondance extended field et extended field trad
		foreach ($champssupp as $champ) {
			$champsrequete['ce'][$i]['project'] = $champsrequete['cet'][$i]['project'] = $champsinterface['projet'];
			$champsrequete['cet'][$i]['language_iso_code'] = isset($champsinterface['langue']) && $champsinterface['langue'] != "" ? $champsinterface['langue'] : "fr"; 
			// pour la table extended fiels champs interface => champs bd
			foreach ($this->correspondance_champs_etendus as $ci => $ce) {
				if (isset($champ[$ci]) && $champ[$ci] != "") {
					$champsrequete['ce'][$i][$ce] = $champ[$ci];
				} else {
					if ($ci == "mandatory") {
						$champsrequete['ce'][$i][$ce] = "0";
					} else {
						$champsrequete['ce'][$i][$ce] = "";
					}
				}
			}
			$champsrequete['ce'][$i]["is_visible"] = "1";
			// pour la table extended fiels trad champs interface => champs bd
			foreach ($this->correspondance_champs_etendus_trad as $cit => $cr) {
				if (isset($champ[$cit]) && is_array($champ[$cit])) {
					$champsrequete['cet'][$i][$cr] = json_encode($champ[$cit]);
				} elseif (isset($champ[$cit]) && $champ[$cit] != "") {
					$champsrequete['cet'][$i][$cr] = $champ[$cit];
				} else {
					$champsrequete['cet'][$i][$cr] = "";
				}
			}
			$i++;
		} 
		return $champsrequete;
	}
	protected function traiterCorrespondanceChampsEtendusBDInterface(Array $champsrequete, $projet = "null") {
		$champssupp = array(); $i = 0;
		foreach ($champsrequete as $champ) {
			$champssupp[$projet]['projet'] = $champ['project'];
			$champssupp[$projet]['langue'] = $champ['language_iso_code'];
			// pour la table extended fiels champs interface => champs bd
			foreach ($this->correspondance_champs_etendus as $ci => $ce) {
				if (isset($champ[$ce]) && $champ[$ce] != "") {
				    $champssupp[$projet]['champs-supp'][$i][$ci] = $champ[$ce];
				} else {
				    $champssupp[$projet]['champs-supp'][$i][$ci]= "";
				}
			}
			// pour la table extended fiels trad champs interface => champs bd
			foreach ($this->correspondance_champs_etendus_trad as $cet => $cr) {
				if (isset($champ[$cr]) && $champ[$cr] != "") {
				    $champssupp[$projet]['champs-supp'][$i][$cet]= $champ[$cr];
				} else {
				    $champssupp[$projet]['champs-supp'][$i][$cet]="";
				}
			}$i++;
		}
		return $champssupp;
	}
 
 
}
?>

Subversion Repositories eFlore/Applications.cel

(root)/trunk/jrest/services/CelWidgetManager.php – Rev 3883 → 3884

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