Subversion Repositories eFlore/Projets.eflore-projets

Compare Revisions

Ignore whitespace Rev 220 → Rev 216

/trunk/services/bibliotheque/nom/NomDAO.php
2,7 → 2,6
class NomDAO {
private $bdd = null;
private $versions = null;
private $requeteNbreNomsTotal = null;
 
public function __construct(Ressources $ressources, Parametres $parametres, Bdd $bdd, Versions $versions) {
$this->ressources = $ressources;
28,21 → 27,20
}
 
public function rechercher() {
$clause = $this->getClauseSelectSpeciale();
$table = $this->getTable();
$conditions = $this->getConditions();
$where = $this->getWhere($conditions);
$navigation = $this->getNavigation();
 
$requete = "SELECT $clause ns.*, ".
$requete = 'SELECT SQL_CALC_FOUND_ROWS ns.*, '.
' nr.nom_sci AS nr_nom_sci, nb.nom_sci AS nb_nom_sci '.
"FROM $table AS ns ".
" LEFT JOIN $table AS nr ON (ns.num_nom_retenu = nr.num_nom) ".
" LEFT JOIN $table AS nb ON (ns.basionyme = nb.num_nom) ".
$where.' '.$conditions.' '.
$where.$conditions.
'ORDER BY ns.nom_sci ASC '.
"LIMIT $navigation ";
$this->requeteNbreNomsTotal = $this->transformerRequetePourNbreNomsTotal($requete);
 
$resultats = $this->bdd->recupererTous($requete);
 
return $resultats;
49,13 → 47,11
}
 
public function rechercherFloue() {
$clause = $this->getClauseSelectSpeciale();
$table = $this->getTable();
$masque = $this->parametres->getMasquePourBdd();
$where = $this->getWhere();
$navigation = $this->getNavigation();
 
$requete = "SELECT $clause ns.*, ".
$requete = 'SELECT SQL_CALC_FOUND_ROWS ns.*, '.
' nr.nom_sci AS nr_nom_sci, nb.nom_sci AS nb_nom_sci '.
"FROM $table AS ns ".
" LEFT JOIN $table AS nr ON (ns.num_nom_retenu = nr.num_nom) ".
66,16 → 62,10
" OR (SOUNDEX(REVERSE(ns.nom_sci)) = SOUNDEX(REVERSE($masque))) " : '').
'ORDER BY ns.nom_sci ASC '.
"LIMIT $navigation ";
$this->requeteNbreNomsTotal = $this->transformerRequetePourNbreNomsTotal($requete);
$resultats = $this->bdd->recupererTous($requete);
return $resultats;
}
 
private function getClauseSelectSpeciale() {
$clause = (Config::get('bdd_protocole') == 'mysql') ? 'SQL_CALC_FOUND_ROWS' : '';
return $clause;
}
 
private function getTable() {
$versions = $this->versions->getVersions();
$derniereVersion = end($versions);
135,19 → 125,8
return $navigation;
}
 
private function transformerRequetePourNbreNomsTotal($requete) {
$requete = preg_replace('/SELECT .* FROM/', 'SELECT COUNT(*) AS nbre FROM', $requete);
$requete = preg_replace('/LIMIT [0-9]+,[0-9]+/', '', $requete);
return $requete;
}
 
public function recupererNombreNomsTotal() {
if (Config::get('bdd_protocole') == 'mysql') {
$requete = 'SELECT FOUND_ROWS() AS nbre';
} else {
$requete = $this->requeteNbreNomsTotal;
}
 
$requete = 'SELECT FOUND_ROWS() AS nbre';
$nombre = $this->bdd->recuperer($requete);
return (int) $nombre['nbre'];
}