WebSVN – eFlore/Applications.cel – Diff – /branches/v3.01-serpe/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'])) {
		    $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)/branches/v3.01-serpe/jrest/services/CelWidgetManager.php @ 3895 – Rev 3857 → 3881

Rev 3857		Rev 3881
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',`
-		53	`'adresse' => 'is_mandatory_address',`
-		54	`'photo_obligatoire' => 'is_mandatory_photo',`
52	`'milieux' => 'environment',`	55	`'milieux' => 'environment',`
53	`'motscles' => 'project_tag_name',`	56	`'motscles' => 'project_tag_name',`
54	`'info' => 'info',`	57	`'info' => 'info',`
55	`'id_projet' => 'project_id'`	58	`'id_projet' => 'project_id'`
56	`);`	59	`);`
57		60
58	`private $correspondance_champs_etendus = array(`	61	`private $correspondance_champs_etendus = array(`
59	`"key" => "field_id",`	62	`"key" => "field_id",`
60	`"element" => "data_type",`	63	`"element" => "data_type",`
61	`"mandatory" => "is_mandatory",`	64	`"mandatory" => "is_mandatory",`
62	`"unit" => "unit"`	65	`"unit" => "unit"`
63	`);`	66	`);`
64		67
65	`private $correspondance_champs_etendus_trad = array(`	68	`private $correspondance_champs_etendus_trad = array(`
66	`"key" => "extended_field_id",`	69	`"key" => "extended_field_id",`
67	`"name" => "label",`	70	`"name" => "label",`
68	`"description" => "description",`	71	`"description" => "description",`
69	`"fieldValues" => "default_value",`	72	`"fieldValues" => "default_value",`
70	`"help" => "help"`	73	`"help" => "help"`
71	`);`	74	`);`
72		75
73	`public function getRessource() {`	76	`public function getRessource() {`
74	`return $this->getElement(array());`	77	`return $this->getElement(array());`
75	`}`	78	`}`
76		79
77	`/**`	80	`/**`
78	`* Méthode appelée avec une requête de type GET.`	81	`* Méthode appelée avec une requête de type GET.`
79	`*/`	82	`*/`
80	`public function getElement($params = array()) {`	83	`public function getElement($params = array()) {`
81	`switch(@strtolower($params[0])) {`	84	`switch(@strtolower($params[0])) {`
82	`case 'widget':`	85	`case 'widget':`
83	`$this->getWidget();`	86	`$this->getWidget();`
84	`break;`	87	`break;`
85	`case 'champsetendus';`	88	`case 'champsetendus';`
86	`$this->getChampsEtendus();`	89	`$this->getChampsEtendus();`
87	`break;`	90	`break;`
88	`default:`	91	`default:`
89	`$this->getWidget();`	92	`$this->getWidget();`
90	`}`	93	`}`
91	`}`	94	`}`
92		95
93		96
94	`public function createElement($requeteDonnees) {`	97	`public function createElement($requeteDonnees) {`
95	`unset($requeteDonnees['signup_submit']);`	98	`unset($requeteDonnees['signup_submit']);`
96	`if (isset($requeteDonnees['champs-supp'])) {`	99	`if (isset($requeteDonnees['champs-supp'])) {`
97	`$gestionchamps = new GestionChampsEtendus2($this->config);`	100	`$gestionchamps = new GestionChampsEtendus2($this->config);`
98	`$champs = $this->traiterCorrespondanceChampsEtendusInterfaceBD($requeteDonnees); //var_dump($champs);exit;`	101	`$champs = $this->traiterCorrespondanceChampsEtendusInterfaceBD($requeteDonnees); //var_dump($champs);exit;`
99	`$liste = $gestionchamps->ajouterParProjet($champs);`	102	`$liste = $gestionchamps->ajouterParProjet($champs);`
100	`unset($requeteDonnees['champs-supp']);`	103	`unset($requeteDonnees['champs-supp']);`
101	`}`	104	`}`
102	`$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;`
103	`$manager = new GestionWidget($this->config);`	106	`$manager = new GestionWidget($this->config);`
104	`$requeteDonnees = $this->traiterCorresponceConfigWidgetInterfaceBD($requeteDonnees);`	107	`$requeteDonnees = $this->traiterCorresponceConfigWidgetInterfaceBD($requeteDonnees);`
105	`$retour = $manager->ajouterWidget($requeteDonnees);`	108	`$retour = $manager->ajouterWidget($requeteDonnees);`
106		109
107	`$this->envoyerJson($retour);`	110	`$this->envoyerJson($retour);`
108		111
109	`}`	112	`}`
110		113
111	`public function updateElement($uid,$params) {`	114	`public function updateElement($uid,$params) {`
112	`$retour = "";`	115	`$retour = "";`
113	`if (isset($params['projet']) && isset($params['langue'])) {`	116	`if (isset($params['projet']) && isset($params['langue'])) {`
114	`$manager = new GestionWidget($this->config);`	117	`$manager = new GestionWidget($this->config);`
115	`$params['est_type'] = (isset($params['est_type']) && $params['est_type']== "on") ? 1 : 0;`	118	`$params['est_type'] = (isset($params['est_type']) && $params['est_type']== "on") ? 1 : 0;`
116	`$requeteDonnees = $this->traiterCorresponceConfigWidgetInterfaceBD($params);`	119	`$requeteDonnees = $this->traiterCorresponceConfigWidgetInterfaceBD($params);`
117	`$retour = $manager->modifierWidget($params['projet'], $params['langue'], $requeteDonnees);`	120	`$retour = $manager->modifierWidget($params['projet'], $params['langue'], $requeteDonnees);`
118		121
119	`}`	122	`}`
120	`$this->envoyerJson($retour);`	123	`$this->envoyerJson($retour);`
121	`return "ff";`	124	`return "ff";`
122		125
123	`}`	126	`}`
124		127
125	`private function getWidget() {`	128	`private function getWidget() {`
126	`$criteres = $this->traiterParametresAutorises($_GET);`	129	`$criteres = $this->traiterParametresAutorises($_GET);`
127	`$manager = new GestionWidget($this->config);`	130	`$manager = new GestionWidget($this->config);`
128	`$liste = $manager->obtenirWidget($criteres);`	131	`$liste = $manager->obtenirWidget($criteres);`
129	`$liste = $this->traiterCorresponceConfigWidgetBDInterface($liste);`	132	`$liste = $this->traiterCorresponceConfigWidgetBDInterface($liste);`
130		133
131	`$this->envoyerJson($liste);`	134	`$this->envoyerJson($liste);`
132	`}`	135	`}`
133		136
134	`private function getChampsEtendus() {`	137	`private function getChampsEtendus() {`
135	`$champs = new GestionChampsEtendus2($this->config);`	138	`$champs = new GestionChampsEtendus2($this->config);`
136	`$projet = (isset($_GET['projet'])) ? $_GET['projet'] : "";`	139	`$projet = (isset($_GET['projet'])) ? $_GET['projet'] : "";`
137	`$langue = (isset($_GET['langue'])) ? $_GET['langue'] : "fr";`	140	`$langue = (isset($_GET['langue'])) ? $_GET['langue'] : "fr";`
138	`$liste = $champs->consulterProjetChampsEtendus($projet, $langue);`	141	`$liste = $champs->consulterProjetChampsEtendus($projet, $langue);`
139	`$liste = $this->traiterCorrespondanceChampsEtendusBDInterface($liste, $projet);`	142	`$liste = $this->traiterCorrespondanceChampsEtendusBDInterface($liste, $projet);`
140		143
141	`$this->envoyerJson($liste);`	144	`$this->envoyerJson($liste);`
142	`}`	145	`}`
143		146
144		147
145	`protected function traiterParametresAutorises(Array $parametres) {`	148	`protected function traiterParametresAutorises(Array $parametres) {`
146	`$parametres_traites = array();`	149	`$parametres_traites = array();`
147		150
148	`foreach($parametres as $cle => $valeur) {`	151	`foreach($parametres as $cle => $valeur) {`
149	`if(is_string($valeur) && !trim($valeur)) continue;`	152	`if(is_string($valeur) && !trim($valeur)) continue;`
150	`if(isset($this->parametres_autorises[$cle])) {`	153	`if(isset($this->parametres_autorises[$cle])) {`
151	`$parametres_traites[$this->parametres_autorises[$cle]] = $valeur;`	154	`$parametres_traites[$this->parametres_autorises[$cle]] = $valeur;`
152	`}`	155	`}`
153	`}`	156	`}`
154	`return $parametres_traites;`	157	`return $parametres_traites;`
155	`}`	158	`}`
156		159
157	`protected function traiterCorresponceConfigWidgetBDInterface(Array $widgets) {`	160	`protected function traiterCorresponceConfigWidgetBDInterface(Array $widgets) {`
158	`$parametres_traites = array();`	161	`$parametres_traites = array();`
159	`$corresp = array_flip($this->correspondance_config_widget);`	162	`$corresp = array_flip($this->correspondance_config_widget);`
160	`foreach($widgets as $id => $widget) {`	163	`foreach($widgets as $id => $widget) {`
161	`foreach($widget as $cle => $valeur) {`	164	`foreach($widget as $cle => $valeur) {`
162	`if(is_string($valeur) && !trim($valeur)) continue;`	165	`if(is_string($valeur) && !trim($valeur)) continue;`
163	`if(isset($corresp[$cle])) {`	166	`if(isset($corresp[$cle])) {`
164	`$parametres_traites[$id][$corresp[$cle]] = $valeur;`	167	`$parametres_traites[$id][$corresp[$cle]] = $valeur;`
165	`}`	168	`}`
166	`}`	169	`}`
167	`}`	170	`}`
168	`return $parametres_traites;`	171	`return $parametres_traites;`
169	`}`	172	`}`
170		173
171	`protected function traiterCorresponceConfigWidgetInterfaceBD(Array $parametres) {`	174	`protected function traiterCorresponceConfigWidgetInterfaceBD(Array $parametres) {`
172	`$parametres_traites = array();`	175	`$parametres_traites = array();`
173	`$corresp = $this->correspondance_config_widget;`	176	`$corresp = $this->correspondance_config_widget;`
174	`foreach($parametres as $cle => $valeur) {`	177	`foreach($parametres as $cle => $valeur) {`
175	`if(is_string($valeur) && !trim($valeur)) $valeur=NULL;`	178	`if(is_string($valeur) && !trim($valeur)) $valeur=NULL;`
176	`if(isset($corresp[$cle])) {`	179	`if(isset($corresp[$cle])) {`
177	`$parametres_traites[$corresp[$cle]] = $valeur;`	180	`$parametres_traites[$corresp[$cle]] = $valeur;`
178	`}`	181	`}`
179	`}`	182	`}`
180	`return $parametres_traites;`	183	`return $parametres_traites;`
181	`}`	184	`}`
182		185
183	`protected function traiterCorrespondanceChampsEtendusInterfaceBD(Array $champsinterface) {`	186	`protected function traiterCorrespondanceChampsEtendusInterfaceBD(Array $champsinterface) {`
184	`$champsrequete = array(); $i = 0;`	187	`$champsrequete = array(); $i = 0;`
185	`$champssupp = json_decode($champsinterface['champs-supp'], true);`	188	`$champssupp = json_decode($champsinterface['champs-supp'], true);`
186	`// pour chaque champs-supp, mettre correspondance extended field et extended field trad`	189	`// pour chaque champs-supp, mettre correspondance extended field et extended field trad`
187	`foreach ($champssupp as $champ) {`	190	`foreach ($champssupp as $champ) {`
188	`$champsrequete['ce'][$i]['project'] = $champsrequete['cet'][$i]['project'] = $champsinterface['projet'];`	191	`$champsrequete['ce'][$i]['project'] = $champsrequete['cet'][$i]['project'] = $champsinterface['projet'];`
189	`$champsrequete['cet'][$i]['language_iso_code'] = $champsinterface['langue'];`	192	`$champsrequete['cet'][$i]['language_iso_code'] = isset($champsinterface['langue']) && $champsinterface['langue'] != "" ? $champsinterface['langue'] : "fr";`
190	`// pour la table extended fiels champs interface => champs bd`	193	`// pour la table extended fiels champs interface => champs bd`
191	`foreach ($this->correspondance_champs_etendus as $ci => $ce) {`	194	`foreach ($this->correspondance_champs_etendus as $ci => $ce) {`
192	`if (isset($champ[$ci]) && $champ[$ci] != "") {`	195	`if (isset($champ[$ci]) && $champ[$ci] != "") {`
193	`$champsrequete['ce'][$i][$ce] = $champ[$ci];`	196	`$champsrequete['ce'][$i][$ce] = $champ[$ci];`
194	`} else {`	197	`} else {`
195	`if ($ci == "mandatory") {`	198	`if ($ci == "mandatory") {`
196	`$champsrequete['ce'][$i][$ce] = "0";`	199	`$champsrequete['ce'][$i][$ce] = "0";`
197	`} else {`	200	`} else {`
198	`$champsrequete['ce'][$i][$ce] = "";`	201	`$champsrequete['ce'][$i][$ce] = "";`
199	`}`	202	`}`
200	`}`	203	`}`
201	`}`	204	`}`
-		205	`$champsrequete['ce'][$i]["is_visible"] = "1";`
202	`// pour la table extended fiels trad champs interface => champs bd`	206	`// pour la table extended fiels trad champs interface => champs bd`
203	`foreach ($this->correspondance_champs_etendus_trad as $cit => $cr) {`	207	`foreach ($this->correspondance_champs_etendus_trad as $cit => $cr) {`
204	`if (isset($champ[$cit]) && is_array($champ[$cit])) {`	208	`if (isset($champ[$cit]) && is_array($champ[$cit])) {`
205	`$champsrequete['cet'][$i][$cr] = json_encode($champ[$cit]);`	209	`$champsrequete['cet'][$i][$cr] = json_encode($champ[$cit]);`
206	`} elseif (isset($champ[$cit]) && $champ[$cit] != "") {`	210	`} elseif (isset($champ[$cit]) && $champ[$cit] != "") {`
207	`$champsrequete['cet'][$i][$cr] = $champ[$cit];`	211	`$champsrequete['cet'][$i][$cr] = $champ[$cit];`
208	`} else {`	212	`} else {`
209	`$champsrequete['cet'][$i][$cr] = "";`	213	`$champsrequete['cet'][$i][$cr] = "";`
210	`}`	214	`}`
211	`}`	215	`}`
212	`$i++;`	216	`$i++;`
213	`}`	217	`}`
214	`return $champsrequete;`	218	`return $champsrequete;`
215	`}`	219	`}`
216	`protected function traiterCorrespondanceChampsEtendusBDInterface(Array $champsrequete, $projet = "null") {`	220	`protected function traiterCorrespondanceChampsEtendusBDInterface(Array $champsrequete, $projet = "null") {`
217	`$champssupp = array(); $i = 0;`	221	`$champssupp = array(); $i = 0;`
218	`foreach ($champsrequete as $champ) {`	222	`foreach ($champsrequete as $champ) {`
219	`$champssupp[$projet]['projet'] = $champ['project'];`	223	`$champssupp[$projet]['projet'] = $champ['project'];`
220	`$champssupp[$projet]['langue'] = $champ['language_iso_code'];`	224	`$champssupp[$projet]['langue'] = $champ['language_iso_code'];`
221	`// pour la table extended fiels champs interface => champs bd`	225	`// pour la table extended fiels champs interface => champs bd`
222	`foreach ($this->correspondance_champs_etendus as $ci => $ce) {`	226	`foreach ($this->correspondance_champs_etendus as $ci => $ce) {`
223	`if (isset($champ[$ce]) && $champ[$ce] != "") {`	227	`if (isset($champ[$ce]) && $champ[$ce] != "") {`
224	`$champssupp[$projet]['champs-supp'][$i][$ci] = $champ[$ce];`	228	`$champssupp[$projet]['champs-supp'][$i][$ci] = $champ[$ce];`
225	`} else {`	229	`} else {`
226	`$champssupp[$projet]['champs-supp'][$i][$ci]= "";`	230	`$champssupp[$projet]['champs-supp'][$i][$ci]= "";`
227	`}`	231	`}`
228	`}`	232	`}`
229	`// pour la table extended fiels trad champs interface => champs bd`	233	`// pour la table extended fiels trad champs interface => champs bd`
230	`foreach ($this->correspondance_champs_etendus_trad as $cet => $cr) {`	234	`foreach ($this->correspondance_champs_etendus_trad as $cet => $cr) {`
231	`if (isset($champ[$cr]) && $champ[$cr] != "") {`	235	`if (isset($champ[$cr]) && $champ[$cr] != "") {`
232	`$champssupp[$projet]['champs-supp'][$i][$cet]= $champ[$cr];`	236	`$champssupp[$projet]['champs-supp'][$i][$cet]= $champ[$cr];`
233	`} else {`	237	`} else {`
234	`$champssupp[$projet]['champs-supp'][$i][$cet]="";`	238	`$champssupp[$projet]['champs-supp'][$i][$cet]="";`
235	`}`	239	`}`
236	`}$i++;`	240	`}$i++;`
237	`}`	241	`}`
238	`return $champssupp;`	242	`return $champssupp;`
239	`}`	243	`}`
240		244
241		245
242	`}`	246	`}`
243	`?>`	247	`?>`