Subversion Repositories eFlore/Applications.del

Rev

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

Rev 1373 Rev 1380
Line 499... Line 499...
499 
			__FILE__ . ':' . __LINE__);
 499 
			__FILE__ . ':' . __LINE__);
Line 500... Line 500...
500 
 
 500 
 
501 
		return $this->bdd->recupererTous($requeteLiaisons);
 501 
		return $this->bdd->recupererTous($requeteLiaisons);
Line -... Line 502...
- 
 
 502 
	}
- 
 
 503 
 
- 
 
 504 
	/*
- 
 
 505 
	  SELECT SQL_CALC_FOUND_ROWS o.id_observation, o.mots_cles_texte FROM del_observation o
- 
 
 506 
	  INNER JOIN `tb_cel_test`.`cel_obs_images` oi on (`oi`.`id_observation` = `o`.`id_observation`)
- 
 
 507 
	  INNER join `tb_cel_test`.`cel_images` `i` on (`i`.`id_image` = `oi`.`id_image`)
- 
 
 508 
	  WHERE (SELECT COUNT(id_commentaire) FROM del_commentaire AS dc WHERE ce_observation = o.id_observation) > 1
- 
 
 509 
	  GROUP BY o.id_obsservation
- 
 
 510 
	  ORDER BY date_transmission DESC
- 
 
 511 
	  LIMIT 0, 12;
502 
	}
 512 
	  SELECT found_rows();'
503 
 
 513 
	*/
504 
	private function chargerLiaisonsSimple() {
 514 
	private function chargerLiaisonsSimple() {
505 
		$requeteObs = sprintf(
 515 
		$requeteObs = sprintf(
506 
			'SELECT SQL_CALC_FOUND_ROWS '.
 516 
			'SELECT SQL_CALC_FOUND_ROWS '.