Subversion Repositories Sites.obs-saisons.fr

Rev

Rev 324 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 324 Rev 334
Line 211... Line 211...
211 
			'ON oe.oe_espece_active = 1 '.
 211 
			'ON oe.oe_espece_active = 1 '.
212 
			'AND oi.oi_ce_espece = oe.oe_id_espece '.
 212 
			'AND oi.oi_ce_espece = oe.oe_id_espece '.
213 
			'WHERE oo_ce_participant != '.$this->config['appli']['id_participant_demo'].' '.
 213 
			'WHERE oo_ce_participant != '.$this->config['appli']['id_participant_demo'].' '.
214 
			'AND oo_ce_participant != '.$this->config['appli']['id_participant_admin'].' '.
 214 
			'AND oo_ce_participant != '.$this->config['appli']['id_participant_admin'].' '.
215 
			'AND DAY(oo_date) != "00" '.
 215 
			'AND DAY(oo_date) != "00" '.
- 
 
 216 
			'AND oo_absence_evenement = "0" '.
216 
			'ORDER BY '.$this->tri.' '.$this->tri_dir.' '.
 217 
			'ORDER BY '.$this->tri.' '.$this->tri_dir.' '.
217 
			"LIMIT $this->start,$this->limit ";
 218 
			"LIMIT $this->start,$this->limit ";
Line 218... Line 219...
218 
 
 219 
 
Line 398... Line 399...
398 
		if(is_numeric($commune)) {
 399 
		if(is_numeric($commune)) {
399 
			$requete_lieu = 'SELECT * FROM ods_communes '.
 400 
			$requete_lieu = 'SELECT * FROM ods_communes '.
400 
						'WHERE oc_code_insee = '.$this->proteger($commune);
 401 
						'WHERE oc_code_insee = '.$this->proteger($commune);
Line 401... Line 402...
401 
 
 402 
 
- 
 
 403 
			$resultat_lieu = $this->executerRequete($requete_lieu);
402 
			$resultat_lieu = $this->executerRequete($requete_lieu);
 404 
			if(!empty($resultat_lieu)) {
- 
 
 405 
				$lieu = $resultat_lieu[0]['oc_nom']. ' ('.substr($commune,0,2).')';
- 
 
 406 
			} else {
- 
 
 407 
				$lieu = $commune;
403 
			$lieu = $resultat_lieu[0]['oc_nom']. ' ('.substr($commune,0,2).')';
 408 
			}
404 
		} else {
 409 
		} else {
405 
			$lieu = $commune;
 410 
			$lieu = $commune;
Line 406... Line 411...
406 
		}
 411 
		}