Subversion Repositories eFlore/Applications.del

Compare Revisions

Ignore whitespace Rev 765 → Rev 766

/trunk/services/modules/0.1/observations/ListeObservations.php
215,7 → 215,7
$requeteLiaisons = 'SELECT SQL_CALC_FOUND_ROWS * '.
'FROM '.$this->gestionBdd->formaterTable('del_observation', 'dob').
'INNER JOIN '.$this->gestionBdd->formaterTable('del_obs_images', 'doi').
'INNER JOIN '.$this->gestionBdd->formaterTable('del_obs_image', 'doi').
'ON doi.id_observation = dob.id_observation '.
'INNER JOIN del_utilisateur du '.
'ON du.id_utilisateur = doi.id_utilisateur ';
233,7 → 233,7
private function compterObservations() {
$requete = 'SELECT FOUND_ROWS() AS nbre ';
$resultats = $this->bdd->recuperer($requete);
return $resultats['nbre'];
return (int) $resultats['nbre'];
}
/**
260,7 → 260,7
foreach ($observations as $id => $observation) {
$requeteImages = 'SELECT * FROM '. $this->gestionBdd->formaterTable('del_obs_images', 'doi').
$requeteImages = 'SELECT * FROM '. $this->gestionBdd->formaterTable('del_obs_image', 'doi').
'INNER JOIN '.$this->gestionBdd->formaterTable('del_image', 'di').
'ON doi.id_image = di.id_image '.
'WHERE doi.id_observation = '.$observation['id_observation'];