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(); |