| 11,7 → 11,9 |
|---|
| * @copyright © 2010, Jean-Pascal MILCENT |
| */ |
| abstract class Cel { |
| |
| const TYPE_OBS = 'observation'; |
| const TYPE_IMG = 'image'; |
| |
| public $config; |
| public $parametres; |
| protected $bdd; |
| 276,10 → 278,6 |
|---|
| return $url; |
| } |
| |
| protected function encoderMotCle($mot_cle) { |
| return md5(mb_strtolower($mot_cle)); |
| } |
| |
| protected function creerAuteur($courriel, $pourAdmin = false) { |
| $auteur = ($pourAdmin) ? $courriel : $this->tronquerCourriel($courriel); |
| return $auteur; |
| 316,6 → 314,55 |
|---|
| return $etre_null; |
| } |
| |
| protected function formaterDate($date, $format = '%A %d %B %Y à %H:%M') { |
| return strftime($format, strtotime($date)); |
| } |
| |
| protected function encoderMotCle($mot_cle) { |
| return md5(mb_strtolower($mot_cle)); |
| } |
| |
| protected function decoderMotsClesObs($utilisateur_id, $mots_cles) { |
| return $this->decoderMotsCles($utilisateur_id, $mots_cles, self::TYPE_OBS); |
| } |
| |
| protected function decoderMotsClesImg($utilisateur_id, $mots_cles) { |
| return $this->decoderMotsCles($utilisateur_id, $mots_cles, self::TYPE_IMG); |
| } |
| |
| private function decoderMotsCles($utilisateur_id, $mots_cles, $type) { |
| $mots = array(); |
| if (! $this->etreNull($mots_cles)) { |
| $utilisateur_id = $this->bdd->quote($utilisateur_id); |
| |
| $mots_cles = $this->protegerMotsCles($mots_cles, $type); |
| |
| $table = ($type == self::TYPE_IMG) ? 'cel_mots_cles_images' : 'cel_mots_cles_obs' ; |
| |
| $requete = 'SELECT cmc_mot_cle '. |
| "FROM $table ". |
| "WHERE cmc_id_mot_cle_utilisateur IN ($mots_cles) ". |
| "AND cmc_id_proprietaire = $utilisateur_id "; |
| |
| $elements = $this->executerRequete($requete); |
| |
| foreach ($elements as $mot) { |
| $mots[] = $mot['cmc_mot_cle']; |
| } |
| } |
| return $mots; |
| } |
| |
| private function protegerMotsCles($mots_cles, $type) { |
| $separateur = ($type == self::TYPE_IMG) ? ',' : ';' ; |
| $mots_cles_a_proteger = explode($separateur,rtrim(trim($mots_cles), $separateur)); |
| foreach ($mots_cles_a_proteger as $mot) { |
| $mots_cles_proteges[] = $this->bdd->quote($mot); |
| } |
| $mots_cles = implode(',', $mots_cles_proteges); |
| return $mots_cles; |
| } |
| |
| //+----------------------------------------------------------------------------------------------------------------+ |
| // GESTION DES SQUELETTES PHP |
| |