} if(($mode=="suppr_sanction")&&(isset($id_sanction))) { check_token(); $suppression_sanction_possible="y"; if(($_SESSION['statut']=='professeur')&&(!sanction_saisie_par($id_sanction, $_SESSION['login']))) { $suppression_sanction_possible="n"; $msg.="Vous n'avez pas le droit de supprimer cette sanction.<br />"; // Tentative intrusion? } if($suppression_sanction_possible=="y") { $msg.=suppr_doc_joints_sanction($id_sanction); $sql="DELETE FROM s_travail WHERE id_sanction='$id_sanction';"; $res=mysqli_query($GLOBALS["mysqli"], $sql); $sql="DELETE FROM s_exclusions WHERE id_sanction='$id_sanction';"; $res=mysqli_query($GLOBALS["mysqli"], $sql); $sql="DELETE FROM s_retenues WHERE id_sanction='$id_sanction';"; $res=mysqli_query($GLOBALS["mysqli"], $sql); $sql="DELETE FROM s_autres_sanctions WHERE id_sanction='$id_sanction';"; $res=mysqli_query($GLOBALS["mysqli"], $sql); $sql="DELETE FROM s_sanctions WHERE id_sanction='$id_sanction';"; $res=mysqli_query($GLOBALS["mysqli"], $sql); $sql="DELETE FROM s_reports WHERE id_sanction='$id_sanction';"; $res=mysqli_query($GLOBALS["mysqli"], $sql); } }
function suppr_doc_joints_incident($id_incident, $suppr_doc_sanction = 'n') { global $dossier_documents_discipline; $retour = ""; $sql = "SELECT login FROM s_protagonistes WHERE id_incident='{$id_incident}';"; //echo "$sql<br />"; $res = mysqli_query($GLOBALS["mysqli"], $sql); if (mysqli_num_rows($res) > 0) { $temoin_erreur = "n"; while ($lig = mysqli_fetch_object($res)) { //echo "\$lig->login=$lig->login<br />"; $tab_doc_joints = get_documents_joints($id_incident, "mesure", $lig->login); //echo "count(\$tab_doc_joints)=".count($tab_doc_joints)."<br />"; if (count($tab_doc_joints) > 0) { $chemin = "../{$dossier_documents_discipline}/incident_" . $id_incident . "/mesures/" . $lig->login; //echo "$chemin<br />"; $temoin_erreur = "n"; for ($loop = 0; $loop < count($tab_doc_joints); $loop++) { if (!unlink($chemin . "/" . $tab_doc_joints[$loop])) { $retour .= "Erreur lors de la suppression de {$chemin}/{$tab_doc_joints[$loop]}<br />"; $temoin_erreur = "y"; } } if ($temoin_erreur == "n") { rmdir($chemin); } } } if ($temoin_erreur == "n") { if ($suppr_doc_sanction == 'y') { $sql = "SELECT id_sanction FROM s_sanctions WHERE id_incident='{$id_incident}';"; $res = mysqli_query($GLOBALS["mysqli"], $sql); if (mysqli_num_rows($res) > 0) { while ($lig = mysqli_fetch_object($res)) { $retour .= suppr_doc_joints_sanction($lig->id_sanction); } } } if (file_exists("../{$dossier_documents_discipline}/incident_" . $id_incident . "/mesures") && rmdir("../{$dossier_documents_discipline}/incident_" . $id_incident . "/mesures")) { if (file_exists("../{$dossier_documents_discipline}/incident_" . $id_incident)) { rmdir("../{$dossier_documents_discipline}/incident_" . $id_incident); } } } } return $retour; }