401,14 → 401,14 |
|
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 ! |
|
if ($this->parametresSontDemandes()) { |
$requete = $this->creerRequeteAvecParametres(); |
} else { |
571,12 → 571,13 |
$requete = "b.nom_referentiel LIKE '$referentiel%'"; |
return $requete; |
} |
|
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 = ' ('. |
'b.nom_ret LIKE "'.$chaine_requete.'%"'. |
' OR '. |
604,12 → 605,13 |
|
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; |
} |
|