| New file |
|---|
| 0,0 → 1,75 |
|---|
| <?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$ |
| * |
| */ |
| 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_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; |
| } |
| } |
| ?> |