Subversion Repositories eFlore/Applications.cel

Compare Revisions

Regard whitespace Rev 2461 → Rev 2462

/trunk/jrest/bibliotheque/GestionChampsEtendus.php
1,21 → 1,21
<?php
// declare(encoding='UTF-8');
/**
* PHP Version 5
* in=utf8
* out=utf8
* Classe de gestion de l'ajout, modification et suppression des champs supplémentaires des obs et images.
*
* @category PHP
* @package jrest
* @author Aurelien Peronnet <aurelien@tela-botanica.org>
* @copyright 2010 Tela-Botanica
* @license http://www.cecill.info/licences/Licence_CeCILL_V2-fr.txt Licence CECILL
* @version SVN: <svn_id>
* @link /doc/jrest/
* @internal Mininum PHP version : 5.2
* @category CEL
* @package Services
* @subpackage Bibliothèques
* @version 0.1
* @author Mathias CHOUET <mathias@tela-botanica.org>
* @author Raphaël Droz <raphael@tela-botania.org>
* @author Jean-Pascal MILCENT <jpm@tela-botanica.org>
* @author Aurelien PERONNET <aurelien@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-2014 Tela Botanica <accueil@tela-botanica.org>
*/
 
/**
* Classe de gestion de l'ajout, modification et suppression des champs supplémentaires des obs et images
*/
class GestionChampsEtendus extends Cel {
 
private $mode = null;
54,7 → 54,8
$requete = 'SELECT COUNT(*) >= 1 AS existe '.
"FROM {$this->table_champs_etendus} ".
"WHERE {$this->champ_id} = $id ".
" AND cle = $cle ";
" AND cle = $cle ".
' -- '.__FILE__.':'.__LINE__;;
 
$resultat = Cel::db()->requeter($requete);
return ($resultat[0]['existe'] == '1');
68,7 → 69,10
*/
public function consulter($id_element_lie) {
$id = Cel::db()->proteger($id_element_lie);
$requete = "SELECT * FROM {$this->table_champs_etendus} WHERE {$this->champ_id} = $id ";
$requete = 'SELECT * '.
"FROM {$this->table_champs_etendus} ".
"WHERE {$this->champ_id} = $id ".
' -- '.__FILE__.':'.__LINE__;
$resultat = Cel::db()->requeter($requete);
return $resultat;
}
121,7 → 125,8
$requete = "INSERT INTO {$this->table_champs_etendus} ".
"( {$this->champ_id}, cle, valeur) ".
"VALUES ($id, $cle, $valeur) ".
"ON DUPLICATE KEY UPDATE valeur = VALUES(valeur)";
"ON DUPLICATE KEY UPDATE valeur = VALUES(valeur) ".
' -- '.__FILE__.':'.__LINE__;
 
// la partie on duplicate key est spécifique mysql mais il sera facile de s'en passer le jour
// où l'on change de sgbd
173,8 → 178,8
$requete = "UPDATE {$this->table_champs_etendus} ".
"SET valeur = $valeur ".
"WHERE cle = $cle".
" AND {$this->champ_id} = $id ";
 
" AND {$this->champ_id} = $id ".
' -- '.__FILE__.':'.__LINE__;
$modif = Cel::db()->executer($requete);
return ($modif !== false);
}
189,7 → 194,10
public function supprimer($id_element_lie, $cle) {
$id = Cel::db()->proteger($id_element_lie);
$cle = Cel::db()->proteger($cle);
$requete = "DELETE FROM {$this->table_champs_etendus} WHERE cle = $cle AND {$this->champ_id} = $id ";
$requete = "DELETE FROM {$this->table_champs_etendus} ".
"WHERE cle = $cle ".
"AND {$this->champ_id} = $id ".
' -- '.__FILE__.':'.__LINE__;
$suppr = Cel::db()->executer($requete);
return ($suppr !== false);
}
202,7 → 210,9
*/
public function vider($id_element_lie) {
$id = Cel::db()->proteger($id_element_lie);
$requete = "DELETE FROM {$this->table_champs_etendus} WHERE {$this->champ_id} = $id ";
$requete = "DELETE FROM {$this->table_champs_etendus} ".
"WHERE {$this->champ_id} = $id ".
' -- '.__FILE__.':'.__LINE__;
$suppr = Cel::db()->executer($requete);
return ($suppr !== false);
}
215,7 → 225,9
*/
public function viderParLots($ids_elements_lies) {
$ids = $this->protegerTableau($ids_elements_lies);
$requete = "DELETE FROM {$this->table_champs_etendus} WHERE {$this->champ_id} IN (".implode(',',$ids).") ";
$requete = "DELETE FROM {$this->table_champs_etendus} ".
"WHERE {$this->champ_id} IN (".implode(',',$ids).") ".
' -- '.__FILE__.':'.__LINE__;
$suppr = Cel::db()->executer($requete);
return ($suppr !== false);
}
230,7 → 242,10
$cles_fmt = array();
if(!empty($ids_elements_lies)) {
$ids = $this->protegerTableau($ids_elements_lies);
$requete = "SELECT cle FROM {$this->table_champs_etendus} WHERE {$this->champ_id} IN (".implode(',',$ids).") ";
$requete = 'SELECT cle '.
"FROM {$this->table_champs_etendus} ".
"WHERE {$this->champ_id} IN (".implode(',',$ids).") ".
' -- '.__FILE__.':'.__LINE__;
$cles = Cel::db()->requeter($requete);
$i = 0;
foreach($cles as &$cle) {
248,11 → 263,11
$requete = "SELECT cc.cle as cle_groupe, cc.label as nom_groupe, ccc.cle as cle_champ, ccc.label as label_champ, ccc.invisible, ccc.prive ".
"FROM `cel_catalogue_champs_etendus` cc ".
"INNER JOIN cel_catalogue_champs_etendus_liaison cl ON cc.cle = cl.groupe ".
"INNER JOIN cel_catalogue_champs_etendus ccc ON ccc.cle = cl.champ";
 
"INNER JOIN cel_catalogue_champs_etendus ccc ON ccc.cle = cl.champ ".
' -- '.__FILE__.':'.__LINE__;
$groupes_champs = Cel::db()->executerRequete($requete);
$cle_groupe = "";
$cle_groupe = '';
$infos_groupe = null;
foreach ($groupes_champs as $groupe_champ) {
278,9 → 293,9
$infos_groupe['champs'][] = array(
'cle' => $groupe_champ['cle_champ'],
'label' => $groupe_champ['label_champ'],
'options' => array('invisible' => $groupe_champ['invisible'],
'prive' => $groupe_champ['prive']
)
'options' => array(
'invisible' => $groupe_champ['invisible'],
'prive' => $groupe_champ['prive'])
);
}
298,19 → 313,19
* Renvoie le catalogue des champs étendus
*/
public function consulterCatalogueChampsEtendusPredefinis($ordonner_par_cle = false) {
$requete = "SELECT cle, label, invisible, prive ".
"FROM cel_catalogue_champs_etendus cc ";
$requete = 'SELECT cle, label, invisible, prive '.
'FROM cel_catalogue_champs_etendus AS cc '.
' -- '.__FILE__.':'.__LINE__;
$catalogue = Cel::db()->executerRequete($requete);
$catalogue = Cel::db()->executerRequete($requete);
$infos_champs = array();
foreach ($catalogue as $champ) {
$champ_fmt = array(
'cle' => $champ['cle'],
'label' => $champ['label'],
'options' => array('invisible' => $champ['invisible'],
'prive' => $champ['prive']
)
'options' => array(
'invisible' => $champ['invisible'],
'prive' => $champ['prive'])
);
if($ordonner_par_cle) {
$infos_champs[$champ_fmt['cle']] = $champ_fmt;
359,5 → 374,4
 
return $cle;
}
}
?>
}