225,14 → 225,14 |
$contenu = $this->executerService($elements); |
return $contenu; |
} |
|
private function getServiceMultiCriteres() { |
$contenu = ''; |
if (isset($_GET['debut'])) $this->start = $_GET['debut']; |
if (isset($_GET['limite'])) $this->limit = $_GET['limite']; |
|
$this->limit = ($this->limit < 1000) ? $this->limit : 1000;// Pour éviter les abus ! |
|
|
private function getServiceMultiCriteres() { |
$contenu = ''; |
if (isset($_GET['debut'])) $this->start = Cel::db()->proteger($_GET['debut']); |
if (isset($_GET['limite'])) $this->limit = Cel::db()->proteger($_GET['limite']); |
|
$this->limit = ($this->limit < 1000) ? $this->limit : 1000;// Pour éviter les abus ! |
|
// Construction de la requête |
$requete = (isset($this->distinct) ? 'SELECT DISTINCT' : 'SELECT').' * '. |
'FROM cel_export_total '. |
356,20 → 356,22 |
|
private function traiterCriteresMultiples($tableau_criteres) { |
$tableau_criteres_pour_bdd = array(); |
|
foreach($tableau_criteres as $nom_critere => $valeur_critere) { |
if (isset($this->criteres[$nom_critere])) { |
$tableau_criteres_pour_bdd[] = $this->criteres[$nom_critere].'='.$valeur_critere; |
} |
} |
|
foreach($tableau_criteres as $nom_critere => $valeur_critere) { |
if (isset($this->criteres[$nom_critere])) { |
$valeur_critere = Cel::deb()->proteger($valeur_critere); |
$tableau_criteres_pour_bdd[] = $this->criteres[$nom_critere].'='.$valeur_critere; |
} |
} |
return $tableau_criteres_pour_bdd; |
} |
|
private function creerSousRequeteRechercheGenerale($chaine_requete) { |
$requete = ''; |
if (trim($chaine_requete) != '') { |
$chaine_requete = strtolower($chaine_requete); |
$chaine_requete = str_replace(' ', '_', $chaine_requete); |
|
private function creerSousRequeteRechercheGenerale($chaine_requete) { |
$requete = ''; |
$chaine_requete = Cel::deb()->proteger($chaine_requete); |
if (trim($chaine_requete) != '') { |
$chaine_requete = strtolower($chaine_requete); |
$chaine_requete = str_replace(' ', '_', $chaine_requete); |
$requete = ' ('. |
'nom_ret LIKE "'.$chaine_requete.'%"'. |
' OR '. |