184,14 → 184,14 |
private $nb_obs = 0; |
|
private function compterObservations($params) { |
$requete = 'SELECT COUNT(*) AS nb '. |
$requete = 'SELECT COUNT(*) as nb '. |
'FROM cel_inventory AS i '. |
' LEFT JOIN locations AS l '. |
' ON (l.name = i.location AND l.code = i.id_location) '. |
"WHERE transmission = '1' ". |
" AND ". |
"(".$this->construireWhereRectangleStationOR()." OR ". |
$this->construireWhereRectangleCommuneOR(). |
" AND (". |
$this->construireWhereRectangleStationOR()." OR ". |
$this->construireWhereRectangleCommuneOR().") ". |
$this->construireWhereDept(). |
$this->construireWhereCommune(). |
$this->construireWhereUtilisateur(). |
1241,4 → 1241,5 |
} |
return $commentaire_infos; |
} |
} |
} |
?> |