| /branches/v3.00-serfouette/jrest/services/CelSyndicationObservation.php |
|---|
| 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 '. |
| /branches/v3.00-serfouette/jrest/services/CelSyndicationImage.php |
|---|
| 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; |
| } |