Subversion Repositories eFlore/Applications.cel

Compare Revisions

Ignore whitespace Rev 2142 → Rev 2143

/trunk/jrest/lib/GestionChampsEtendus.php
56,7 → 56,7
"WHERE {$this->champ_id} = $id ".
" AND cle = $cle ";
 
$resultat = Cel::db()->executerRequete($requete);
$resultat = Cel::db()->requeter($requete);
return ($resultat[0]['existe'] == '1');
}
 
69,7 → 69,7
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 ";
$resultat = Cel::db()->executerRequete($requete);
$resultat = Cel::db()->requeter($requete);
return $resultat;
}
 
88,7 → 88,7
$ids = implode(',', $ids_element_lies);
 
$requete = "SELECT * FROM {$this->table_champs_etendus} WHERE {$this->champ_id} IN ($ids) ";
$resultats = Cel::db()->executerRequete($requete);
$resultats = Cel::db()->requeter($requete);
 
foreach ($resultats as &$ligne) {
$id_element = $ligne[$this->champ_id];
127,7 → 127,7
 
// 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
$ajout = Cel::db()->executerRequeteSimple($requete);
$ajout = Cel::db()->executer($requete);
return ($ajout !== false);
}
 
153,7 → 153,7
 
// 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
$ajout = Cel::db()->executerRequeteSimple(sprintf(
$ajout = Cel::db()->executer(sprintf(
"INSERT INTO %s (%s, cle, label, valeur) VALUES %s ON DUPLICATE KEY UPDATE valeur = VALUES(valeur) -- %s:%d",
$this->table_champs_etendus,
$this->champ_id,
179,7 → 179,7
"WHERE cle = $cle".
" AND {$this->champ_id} = $id ";
 
$modif = Cel::db()->executerRequeteSimple($requete);
$modif = Cel::db()->executer($requete);
return ($modif !== false);
}
 
194,7 → 194,7
$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 ";
$suppr = Cel::db()->executerRequeteSimple($requete);
$suppr = Cel::db()->executer($requete);
return ($suppr !== false);
}
 
207,7 → 207,7
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 ";
$suppr = Cel::db()->executerRequeteSimple($requete);
$suppr = Cel::db()->executer($requete);
return ($suppr !== false);
}
 
220,10 → 220,10
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).") ";
$suppr = Cel::db()->executerRequeteSimple($requete);
$suppr = Cel::db()->executer($requete);
return ($suppr !== false);
}
 
/**
* Revnoie tous les intitules aux éléments passés en paramètre
*
235,7 → 235,7
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).") ";
$cles = Cel::db()->executerRequete($requete);
$cles = Cel::db()->requeter($requete);
$i = 0;
foreach($cles as &$cle) {
$cles_fmt[$cle['cle']] = $i++;
243,7 → 243,7
}
return array_values(array_flip($cles_fmt));
}
 
/**
* Renvoie la liste des groupes de champs étendus
*/
251,7 → 251,7
$groupes = array();
/*$requete = "SELECT * FROM {$this->table_champs_etendus}_groupes ";
$champs = Cel::db()->executerRequete($requete);
 
foreach ($champs as $champ) {
if(!isset($groupes[$champ['groupe']])) {
$groupes[$champ['groupe']] = array();