| Line 17... |
Line 17... |
| 17 |
class GestionChampsEtendus2 extends Cel {
|
17 |
class GestionChampsEtendus2 extends Cel {
|
| Line 18... |
Line 18... |
| 18 |
|
18 |
|
| 19 |
private $table_champs_etendus = "extended_field";
|
19 |
private $table_champs_etendus = "extended_field";
|
| 20 |
private $table_champs_etendus_trad = "extendedfield_translation";
|
20 |
private $table_champs_etendus_trad = "extendedfield_translation";
|
| 21 |
private $champ_id = "field_id";
|
21 |
private $champ_id = "field_id";
|
| 22 |
private $liste_champs = "ce.`project`, ce.field_id, ce.`data_type`, ce.`is_mandatory`, ce.`unit`, ".
|
22 |
private $liste_champs = "ce.`id`, ce.`project`, ce.field_id, ce.`data_type`, ce.`is_mandatory`, ce.`unit`, ".
|
| Line 23... |
Line 23... |
| 23 |
"cet.extended_field_id, cet.`label`, cet.`description`, cet.`default_value`, cet.`error_message`, cet.`language_iso_code`, cet.`help` ";
|
23 |
"cet.extended_field_id, cet.`label`, cet.`description`, cet.`default_value`, cet.`error_message`, cet.`language_iso_code`, cet.`help` ";
|
| 24 |
|
24 |
|
| Line 213... |
Line 213... |
| 213 |
'nom' => $groupe_champ['ce.`project`'],
|
213 |
'nom' => $groupe_champ['ce.`project`'],
|
| 214 |
'champs' => array()
|
214 |
'champs' => array()
|
| 215 |
);
|
215 |
);
|
| 216 |
}
|
216 |
}
|
| Line 217... |
Line 217... |
| 217 |
|
217 |
|
| - |
|
218 |
$infos_groupe['champs'][$groupe_champ['ce.field_id']] = array(
|
| 218 |
$infos_groupe['champs'][] = array(
|
219 |
'id' => $groupe_champ['ce.id'],
|
| 219 |
'cle' => $groupe_champ['ce.field_id'],
|
220 |
'cle' => $groupe_champ['ce.field_id'],
|
| 220 |
'label' => $groupe_champ['cet.`label`'],
|
221 |
'label' => $groupe_champ['cet.`label`'],
|
| 221 |
'type' => $groupe_champ['type_champ'],
|
222 |
'type' => $groupe_champ['type_champ'],
|
| 222 |
'valeur' => $groupe_champ['valeur_champ'],
|
223 |
'valeur' => $groupe_champ['valeur_champ'],
|
| Line 238... |
Line 239... |
| 238 |
|
239 |
|
| 239 |
/**
|
240 |
/**
|
| 240 |
* Renvoie le catalogue des champs étendus
|
241 |
* Renvoie le catalogue des champs étendus
|
| 241 |
*/
|
242 |
*/
|
| 242 |
public function consulterCatalogueChampsEtendusPredefinis($ordonner_par_cle = false, $groupe = "") {
|
243 |
public function consulterCatalogueChampsEtendusPredefinis($ordonner_par_cle = false, $groupe = "") {
|
| 243 |
$requete = 'SELECT ce.field_id as cle, cet.`label` as label, "0" as invisible, "0" as prive '.
|
244 |
$requete = 'SELECT ce.id as id, ce.field_id as cle, cet.`label` as label, "0" as invisible, "0" as prive '.
|
| 244 |
"FROM {$this->table_champs_etendus} ce ".
|
245 |
"FROM {$this->table_champs_etendus} ce ".
|
| 245 |
"INNER JOIN {$this->table_champs_etendus_trad} cet ON ce.field_id = cet.extended_field_id ";
|
246 |
"INNER JOIN {$this->table_champs_etendus_trad} cet ON ce.field_id = cet.extended_field_id ";
|
| 246 |
if ($groupe !== "") $requete .= " WHERE project = ".$groupe;
|
247 |
if ($groupe !== "") $requete .= " WHERE project = ".$groupe;
|
| 247 |
$requete .= ' -- '.__FILE__.':'.__LINE__;
|
248 |
$requete .= ' -- '.__FILE__.':'.__LINE__;
|
| Line 248... |
Line 249... |
| 248 |
$catalogue = Cel::db()->executerRequete($requete);
|
249 |
$catalogue = Cel::db()->executerRequete($requete);
|
| 249 |
|
250 |
|
| 250 |
$infos_champs = array();
|
251 |
$infos_champs = array();
|
| 251 |
if ($catalogue != false) {
|
252 |
if ($catalogue != false) {
|
| - |
|
253 |
foreach ($catalogue as $champ) {
|
| 252 |
foreach ($catalogue as $champ) {
|
254 |
$champ_fmt = array(
|
| 253 |
$champ_fmt = array(
|
255 |
'id' => $champ['id'],
|
| 254 |
'cle' => $champ['cle'],
|
256 |
'cle' => $champ['cle'],
|
| 255 |
'label' => $champ['label'],
|
257 |
'label' => $champ['label'],
|
| 256 |
'options' => array(
|
258 |
'options' => array(
|