Subversion Repositories eFlore/Applications.coel-consultation

<?php
// declare(encoding='UTF-8');
/**
 * Modèle d'accès à la base de données des Collections pour la Recherche
 *
 * @package             Collection
 * @category    php5
 * @author              aurelien <aurelien@tela-botanica.org>
 * @copyright   2010 Tela-Botanica
 * @license             http://www.cecill.info/licences/Licence_CeCILL_V2-fr.txt Licence CECILL
 * @license             http://www.gnu.org/licenses/gpl.html Licence GNU-GPL
 * @version             SVN: $Id: RechercheDao.php 10 2010-03-05 14:15:42Z jpm $
 *
 */
class RechercheDao extends ColModele {

        /**
         * Recherche une collection en fonction de paramêtres
         * @return array un tableau contenant des objets d'informations sur les collections
         */
   public function chercherStructureNbre($parametres) {
                $requete =      'SELECT COUNT(cc_id_collection) AS nbre '.
                                        'FROM  coel_collection LEFT JOIN coel_structure ON (cc_ce_structure = cs_id_structure) '.
                                        'WHERE ('.
                                        "       cc_nom LIKE '%{$parametres['mots']}%' ".
                                        "       OR cc_truk_nom_alternatif LIKE '%{$parametres['mots']}%' ".
                                        "       OR cc_truk_code LIKE '%{$parametres['mots']}%' ".
                                        "       OR cc_description LIKE '%{$parametres['mots']}%' ".
                                        "       OR cc_description_specialiste LIKE '%{$parametres['mots']}%' ".
                                        "       OR cc_historique LIKE '%{$parametres['mots']}%' ".
                
                                        "       OR cs_nom LIKE '%{$parametres['mots']}%' ".
                                        "       OR cs_adresse_01 LIKE '%{$parametres['mots']}%' ".
                                        "       OR cs_adresse_02 LIKE '%{$parametres['mots']}%' ".
                                        "       OR cs_ville LIKE '%{$parametres['mots']}%' ".
                                        "       OR cs_truk_identifiant_alternatif LIKE '%{$parametres['mots']}%' ".
                                        ') '.
                                        'ORDER BY cs_ville ASC, cc_nom ASC ';
                
                $donnees = $this->requeteUn($requete);
                //Debug::printr($requete);
                return $donnees['nbre'];
        }
        
        /**
         * Recherche une collection en fonction de paramêtres
         * @return array un tableau contenant des objets d'informations sur les collections
         */
   public function chercher($parametres) {
                $requete =      'SELECT cs_id_structure, cs_ville, cs_nom, '.
                                        '       cc_id_collection, cc_nom '.
                                        'FROM  coel_collection LEFT JOIN coel_structure ON (cc_ce_structure = cs_id_structure) '.
                                        'WHERE ('.
                                        "       cc_nom LIKE '%{$parametres['mots']}%' ".
                                        "       OR cc_truk_nom_alternatif LIKE '%{$parametres['mots']}%' ".
                                        "       OR cc_truk_code LIKE '%{$parametres['mots']}%' ".
                                        "       OR cc_description LIKE '%{$parametres['mots']}%' ".
                                        "       OR cc_description_specialiste LIKE '%{$parametres['mots']}%' ".
                                        "       OR cc_historique LIKE '%{$parametres['mots']}%' ".
                
                                        "       OR cs_nom LIKE '%{$parametres['mots']}%' ".
                                        "       OR cs_adresse_01 LIKE '%{$parametres['mots']}%' ".
                                        "       OR cs_adresse_02 LIKE '%{$parametres['mots']}%' ".
                                        "       OR cs_ville LIKE '%{$parametres['mots']}%' ".
                                        "       OR cs_truk_identifiant_alternatif LIKE '%{$parametres['mots']}%' ".
                                        ') '.
                                        'ORDER BY cs_ville ASC, cc_nom ASC '.
                                        ($this->avoirLimitation() ? "LIMIT {$this->getLimiteDebut()}, {$this->getLimiteNbre()} " : '');
                
                $donnees = $this->requeteTous($requete);
                //Debug::printr($requete);
                return $donnees;
        }
}
?>