WebSVN – eFlore/Applications.cel – Diff – /trunk/jrest/services/CelSyndicationObservation.php



			'FROM cel_obs '.
			(($this->etreFluxAdmin()) ? '' : 'WHERE transmission = 1 ').
			'ORDER BY '.(isset($this->orderby) && (!is_null($this->orderby)) ? $this->orderby  : 'date_modification DESC').' '.
			"LIMIT $this->start,$this->limit ";

 

		$elements = Cel::db()->requeter($requete);
 
		// Création du contenu
		$contenu = $this->executerService($elements);

 
	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 !
 
		// Construction de la requête

		}
		$requete = rtrim($requete, 'AND ');
		$requete .= ' ORDER BY '.(isset($this->orderby) && (!is_null($this->orderby)) ? $this->orderby  :
			'date_modification DESC, zone_geo ASC').' '.
				"LIMIT $this->start,$this->limit ";
 
		$elements = Cel::db()->requeter($requete);

 
		// Création du contenu
		if ($elements != false && count($elements) > 0) {
			$contenu = $this->executerService($elements);

		} else {
			$requete = "(mots_cles_texte LIKE ".Cel::db()->proteger('%'.$mot_cle.'%').') ';
		}
		return $requete;
	}
 
	private function creerSousRequeteTags($tag) {
		$requete = '(id_observation IN (SELECT id_observation FROM cel_obs_images coi INNER JOIN cel_images ci ON coi.id_image = ci.id_image WHERE ';
		$where = '';
		if (preg_match('/.*OU.*/', $tag)) {
			$mots_cles_tab = explode('OU',$tag);

			(($this->etreFluxAdmin()) ? '<li><a href="'.$lien_correction.'">Corriger cette observation</a></li>' : '').
			'</ul>';
		$description = $this->nettoyerTexte($description);
		return $description;
	}
 
	private function creerDescriptionChampsEtendus($obs, $item) {
		$champs_etendus = '';
		foreach($obs['obs_etendue'] as $cle => &$champ) {
			$champs_etendus .= '<li>'.$champ->label.' : '.$champ->valeur.' </li>';
		}
 
		if($champs_etendus != '') {
			$champs_etendus = '<li> Champs supplémentaires : <ul>'.$champs_etendus.'</ul></li>';
		}
		return $champs_etendus;
	}

			}
			$url_service .= '?'.implode('&amp;', $parametres_get);
		}
		return $url_service;
	}
 
	private function getIntituleAuteur($courriel) {
		$courriel = strtolower($courriel);
		if(isset($this->auteurs[$courriel])) {
			$intitule = $this->auteurs[$courriel];
		} else {
			$intitule = $courriel;
		}
		return $intitule;
	}
}


Rev 1790	Rev 2143
Line 211...	Line 211...
211	`'FROM cel_obs '.`	211	`'FROM cel_obs '.`
212	`(($this->etreFluxAdmin()) ? '' : 'WHERE transmission = 1 ').`	212	`(($this->etreFluxAdmin()) ? '' : 'WHERE transmission = 1 ').`
213	`'ORDER BY '.(isset($this->orderby) && (!is_null($this->orderby)) ? $this->orderby : 'date_modification DESC').' '.`	213	`'ORDER BY '.(isset($this->orderby) && (!is_null($this->orderby)) ? $this->orderby : 'date_modification DESC').' '.`
214	`"LIMIT $this->start,$this->limit ";`	214	`"LIMIT $this->start,$this->limit ";`
Line 215...	Line 215...
215		215
Line 216...	Line 216...
216	`$elements = Cel::db()->executerRequete($requete);`	216	`$elements = Cel::db()->requeter($requete);`
217		217
218	`// Création du contenu`	218	`// Création du contenu`
219	`$contenu = $this->executerService($elements);`	219	`$contenu = $this->executerService($elements);`
Line 258...	Line 258...
258		258
259	`private function getServiceMultiCriteres() {`	259	`private function getServiceMultiCriteres() {`
260	`$contenu = '';`	260	`$contenu = '';`
261	`if (isset($_GET['debut'])) $this->start = $_GET['debut'];`	261	`if (isset($_GET['debut'])) $this->start = $_GET['debut'];`
262	`if (isset($_GET['limite'])) $this->limit = $_GET['limite'];`	262	`if (isset($_GET['limite'])) $this->limit = $_GET['limite'];`
263		263
Line 264...	Line 264...
264	`$this->limit = ($this->limit < 1000) ? $this->limit : 1000;// Pour éviter les abus !`	264	`$this->limit = ($this->limit < 1000) ? $this->limit : 1000;// Pour éviter les abus !`
265		265
266	`// Construction de la requête`	266	`// Construction de la requête`
Line 279...	Line 279...
279	`}`	279	`}`
280	`$requete = rtrim($requete, 'AND ');`	280	`$requete = rtrim($requete, 'AND ');`
281	`$requete .= ' ORDER BY '.(isset($this->orderby) && (!is_null($this->orderby)) ? $this->orderby :`	281	`$requete .= ' ORDER BY '.(isset($this->orderby) && (!is_null($this->orderby)) ? $this->orderby :`
282	`'date_modification DESC, zone_geo ASC').' '.`	282	`'date_modification DESC, zone_geo ASC').' '.`
283	`"LIMIT $this->start,$this->limit ";`	283	`"LIMIT $this->start,$this->limit ";`
284		284
285	`$elements = Cel::db()->executerRequete($requete);`	285	`$elements = Cel::db()->requeter($requete);`
Line 286...	Line 286...
286		286
287	`// Création du contenu`	287	`// Création du contenu`
288	`if ($elements != false && count($elements) > 0) {`	288	`if ($elements != false && count($elements) > 0) {`
289	`$contenu = $this->executerService($elements);`	289	`$contenu = $this->executerService($elements);`
Line 346...	Line 346...
346	`} else {`	346	`} else {`
347	`$requete = "(mots_cles_texte LIKE ".Cel::db()->proteger('%'.$mot_cle.'%').') ';`	347	`$requete = "(mots_cles_texte LIKE ".Cel::db()->proteger('%'.$mot_cle.'%').') ';`
348	`}`	348	`}`
349	`return $requete;`	349	`return $requete;`
350	`}`	350	`}`
351		351
352	`private function creerSousRequeteTags($tag) {`	352	`private function creerSousRequeteTags($tag) {`
353	`$requete = '(id_observation IN (SELECT id_observation FROM cel_obs_images coi INNER JOIN cel_images ci ON coi.id_image = ci.id_image WHERE ';`	353	`$requete = '(id_observation IN (SELECT id_observation FROM cel_obs_images coi INNER JOIN cel_images ci ON coi.id_image = ci.id_image WHERE ';`
354	`$where = '';`	354	`$where = '';`
355	`if (preg_match('/.OU./', $tag)) {`	355	`if (preg_match('/.OU./', $tag)) {`
356	`$mots_cles_tab = explode('OU',$tag);`	356	`$mots_cles_tab = explode('OU',$tag);`
Line 535...	Line 535...
535	`(($this->etreFluxAdmin()) ? '<li><a href="'.$lien_correction.'">Corriger cette observation</a></li>' : '').`	535	`(($this->etreFluxAdmin()) ? '<li><a href="'.$lien_correction.'">Corriger cette observation</a></li>' : '').`
536	`'</ul>';`	536	`'</ul>';`
537	`$description = $this->nettoyerTexte($description);`	537	`$description = $this->nettoyerTexte($description);`
538	`return $description;`	538	`return $description;`
539	`}`	539	`}`
540		540
541	`private function creerDescriptionChampsEtendus($obs, $item) {`	541	`private function creerDescriptionChampsEtendus($obs, $item) {`
542	`$champs_etendus = '';`	542	`$champs_etendus = '';`
543	`foreach($obs['obs_etendue'] as $cle => &$champ) {`	543	`foreach($obs['obs_etendue'] as $cle => &$champ) {`
544	`$champs_etendus .= '<li>'.$champ->label.' : '.$champ->valeur.' </li>';`	544	`$champs_etendus .= '<li>'.$champ->label.' : '.$champ->valeur.' </li>';`
545	`}`	545	`}`
546		546
547	`if($champs_etendus != '') {`	547	`if($champs_etendus != '') {`
548	`$champs_etendus = '<li> Champs supplémentaires : <ul>'.$champs_etendus.'</ul></li>';`	548	`$champs_etendus = '<li> Champs supplémentaires : <ul>'.$champs_etendus.'</ul></li>';`
549	`}`	549	`}`
550	`return $champs_etendus;`	550	`return $champs_etendus;`
551	`}`	551	`}`
Line 570...	Line 570...
570	`}`	570	`}`
571	`$url_service .= '?'.implode('&', $parametres_get);`	571	`$url_service .= '?'.implode('&', $parametres_get);`
572	`}`	572	`}`
573	`return $url_service;`	573	`return $url_service;`
574	`}`	574	`}`
575		575
576	`private function getIntituleAuteur($courriel) {`	576	`private function getIntituleAuteur($courriel) {`
577	`$courriel = strtolower($courriel);`	577	`$courriel = strtolower($courriel);`
578	`if(isset($this->auteurs[$courriel])) {`	578	`if(isset($this->auteurs[$courriel])) {`
579	`$intitule = $this->auteurs[$courriel];`	579	`$intitule = $this->auteurs[$courriel];`
580	`} else {`	580	`} else {`
581	`$intitule = $courriel;`	581	`$intitule = $courriel;`
582	`}`	582	`}`
583	`return $intitule;`	583	`return $intitule;`
584	`}`	584	`}`
585	`}`	585	`}`
586		586

Subversion Repositories eFlore/Applications.cel

(root)/trunk/jrest/services/CelSyndicationObservation.php – Rev 1790 → 2143