public function get_id_from_classe($classe){
$this->sql = "SELECT id FROM classes where classe ='".$classe."'";
$this->res = mysqli_query($GLOBALS["mysqli"], $this->sql);
$id=parent::set_array('array',$this->res);
return($id[0]['id']);
}
private function get_infos_incidents($choix,$titre,$du,$au,$critere=Null,$filtre_cat=Null,$filtre_mes=Null,$filtre_san=Null,$filtre_role=Null) {
$this->sql='SELECT DISTINCT sin.id_incident,sin.declarant,sin.date,sin.heure,
sin.nature,sin.id_categorie,sin.description,sin.etat
FROM s_incidents sin ';
if(!$filtre_san && !$filtre_mes &&!$filtre_role){
//on garde les incidents sans protagonistes si pas de filtres
$this->sql.="LEFT JOIN s_protagonistes spr ON sin.id_incident=spr.id_incident ";
} else{
//on supprime les incidents sans protagonistes
$this->sql.="INNER JOIN s_protagonistes spr ON sin.id_incident=spr.id_incident ";
}
if($filtre_san)$this->sql.=' INNER JOIN s_sanctions ssan ON sin.id_incident=ssan.id_incident';
if($filtre_mes)$this->sql.=' INNER JOIN s_traitement_incident str ON sin.id_incident=str.id_incident INNER JOIN s_mesures smes ON str.id_mesure=smes.id ';
$this->sql.=' WHERE date BETWEEN \''.$du.
'\' AND \''.$au.'\' ';
if($filtre_role) $this->sql.=" AND (spr.qualite IN ('".parent::make_list_for_request_in($filtre_role)."') OR spr.qualite IS NULL)";
if($filtre_san) {
$this->sql.=" AND (ssan.nature IN ('".parent::make_list_for_request_in($filtre_san)."')";
if ($critere) $this->sql.=" AND ssan.login IN('".$critere."'))"; else $this->sql.= ")";
}
if($filtre_mes) {
$this->sql.=" AND smes.type='prise' ";
$this->sql.=" AND (str.id_mesure IN ('".parent::make_list_for_request_in($filtre_mes)."')";
if ($critere ) $this->sql.=" AND str.login_ele IN ('".$critere."'))"; else $this->sql.= ")";
}
if($filtre_cat) {
$this->sql.=" AND ( sin.id_categorie IN ('".parent::make_list_for_request_in($filtre_cat)."')";
if (in_array('Null',$filtre_cat)) $this->sql.="OR sin.id_categorie is null)";
else $this->sql.=")";
}
$this->sql.=''.$this->filter_individu($choix,$critere);
$this->res=mysqli_query($GLOBALS["mysqli"], $this->sql);
return(parent::set_array('object',$this->res));
}
