98,10 → 98,10 |
private function obtenirLois(Array $id_lois) { |
$id_lois = array_map(array($this->bdd, 'proteger'), $id_lois); |
$requete = "SELECT * FROM ".Config::get('bdd_table_lois').' '. |
"WHERE id IN (".implode(',',$id_lois).") ORDER BY zone_application ASC"; |
"WHERE cd_protection IN (".implode(',',$id_lois).") ORDER BY zone_application ASC"; |
$lois = $this->bdd->recupererTous($requete, 'ASSOC'); |
foreach ($lois as $loi) { |
$retour[$loi['id']] = $loi; |
$retour[$loi['cd_protection']] = $loi; |
} |
return $retour; |
} |
109,7 → 109,7 |
private function obtenirLoisZoneGeo(Array $id_lois) { |
$id_lois = array_map(array($this->bdd, 'proteger'), $id_lois); |
$requete = "SELECT DISTINCT zone_application, code_zone_application FROM ".Config::get('bdd_table_lois').' '. |
"WHERE id IN (".implode(',',$id_lois).") ORDER BY zone_application ASC"; |
"WHERE cd_protection IN (".implode(',',$id_lois).") ORDER BY zone_application ASC"; |
return $this->bdd->recupererTous($requete); |
} |
|