Subversion Repositories eFlore/Applications.del

Rev

Rev 1269 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 1269 Rev 1271
Line 430... Line 430...
430 
						   'ON du.id_utilisateur = dob.ce_utilisateur '.
 430 
						   'ON du.id_utilisateur = dob.ce_utilisateur '.
431 
						   'LEFT JOIN '.$this->gestionBdd->formaterTable('del_obs_image', 'doi').
 431 
						   'LEFT JOIN '.$this->gestionBdd->formaterTable('del_obs_image', 'doi').
432 
						   'ON doi.id_observation = dob.id_observation '.
 432 
						   'ON doi.id_observation = dob.id_observation '.
433 
						   'LEFT JOIN del_image di '.
 433 
						   'LEFT JOIN del_image di '.
434 
						   'ON di.id_image = doi.id_image ';
 434 
						   'ON di.id_image = doi.id_image ';
435 
 
 - 
 
436 
		$requeteLiaisons .= $this->chargerClauseWhere();
 435 
		$requeteLiaisons .= $this->chargerClauseWhere();
437 
		$requeteLiaisons .= ' GROUP BY doi.id_observation';
 436 
		$requeteLiaisons .= ' GROUP BY doi.id_observation';
438 
		$requeteLiaisons .= ' ORDER BY '.$this->tri.' '.$this->directionTri.' ';
 437 
		$requeteLiaisons .= ' ORDER BY '.$this->tri.' '.$this->directionTri.' ';
439 
		$requeteLiaisons .= $this->gestionBdd->getLimitSql();
 438 
		$requeteLiaisons .= $this->gestionBdd->getLimitSql();
440 
 
 439
441 
		return $this->bdd->recupererTous($requeteLiaisons);
 440 
		return $this->bdd->recupererTous($requeteLiaisons);
442 
	}
 441 
	}
Line 443... Line 442...
443
442
444 
	/**
 443 
	/**