} // if($formCorrectlySent) } //end if($_REQUEST['submitWrk']) /*============================================================================ ADMIN ONLY COMMANDS =============================================================================*/ if ($is_allowedToEditAll) { /*-------------------------------------------------------------------- CHANGE VISIBILITY --------------------------------------------------------------------*/ // change visibility of a work if ($cmd == 'exChVis' && isset($_REQUEST['wrkId'])) { if (isset($_REQUEST['vis'])) { $_REQUEST['vis'] == 'v' ? $visibility = 'VISIBLE' : ($visibility = 'INVISIBLE'); Submission::updateSubmissionVisibility($_REQUEST['wrkId'], $visibility); } } /*-------------------------------------------------------------------- DELETE A WORK --------------------------------------------------------------------*/ if ($cmd == "exRmWrk" && isset($_REQUEST['wrkId'])) { // get name of file to delete AND name of file of the feedback of this work $sql = "SELECT `id`, `submitted_doc_path`\n FROM `" . $tbl_wrk_submission . "`\n WHERE `id` = " . (int) $_REQUEST['wrkId'] . "\n OR `parent_id` = " . (int) $_REQUEST['wrkId']; $filesToDelete = claro_sql_query_fetch_all($sql); foreach ($filesToDelete as $fileToDelete) { // delete the file @unlink($assignment->getAssigDirSys() . $fileToDelete['submitted_doc_path']); // delete the database data of this work $sqlDelete = "DELETE FROM `" . $tbl_wrk_submission . "`\n WHERE `id` = " . (int) $fileToDelete['id']; claro_sql_query($sqlDelete);