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)); }