libdir.'/blocklib.php');
require_once(dirname(__FILE__).'/locallib.php');
require_once(dirname(__FILE__).'/lib_ex.php');
$courseid = required_param('course', PARAM_INTEGER); // Course id
$confirm = optional_param('confirm','', PARAM_INTEGER);
$action = optional_param('action','', PARAM_ALPHA);
$submit = optional_param('submit','', PARAM_TEXT);
if (($formdata = data_submitted()) and !confirm_sesskey()) {
print_error('invalidsesskey');
}
$urlparams['course'] = $courseid;
if ($confirm) $urlparams['confirm'] = $confirm;
if ($action) $urlparams['action'] = $action;
$PAGE->set_url('/blocks/autoattend/deleteDB.php', $urlparams);
$wwwBlock = $CFG->wwwroot.'/blocks/autoattend';
$wwwMyURL = $wwwBlock.'/deleteDB.php';
//
if (isset($formdata->cancel)) {
redirect($CFG->wwwroot.'/course/view.php?id='.$courseid);
}
$course = $DB->get_record('course', array('id'=>$courseid));
if (!$course) {
print_error('courseidwrong', 'block_autoattend');
}
// Check User
require_login($course->id);
$isadmin = jbxl_is_admin($USER->id);
if (!$isadmin) {
print_error('notaccessnoadmin', 'block_autoattend');
}
// Print Header
$title = get_string('session','block_autoattend').' '.get_string('deletedb','block_autoattend');
$PAGE->set_title($title);
$PAGE->set_heading($title);
$PAGE->set_cacheable(true);
$PAGE->set_button(' ');
//$PAGE->set_headingmenu();
echo $OUTPUT->header();
if (!empty($confirm)) {
if (!empty($submit) && $submit==get_string('deletedbok','block_autoattend')) {
$delyear = required_param('delyear', PARAM_INTEGER);
$delmonth = required_param('delmonth', PARAM_INTEGER);
$delday = required_param('delday', PARAM_INTEGER);
$deldate = mktime(0, 0, 0, $delmonth, $delday, $delyear) - $TIME_OFFSET;
// Confirm
if ($confirm==1) {
$info = new stdClass();
$info->delnum = $DB->count_records_select('autoattend_sessions', 'endtime<'.$deldate);
$info->delstr = strftime(get_string('strftimedmy','block_autoattend'), $deldate);
include('html/delete_confirmDB.html');
}
// Delete old items of sessions table
else {
$num_sess = autoattend_delete_sessionsDB($deldate);
$num_stdt = autoattend_cleanup_studentsDB();
//
echo "--------------------------------------------------
";
echo 'autoattend_sessions: deleted '.$num_sess.' record(s).
';
echo "--------------------------------------------------
";
echo 'autoattend_students: deleted '.$num_stdt.' record(s).
';
echo "--------------------------------------------------
";
//
notice(get_string('deleteddb','block_autoattend'), $CFG->wwwroot.'/course/view.php?id='.$course->id);
}
}
}
//
else {
$date_name1 = get_string('date_1st_name', 'block_autoattend');
$date_name2 = get_string('date_2nd_name', 'block_autoattend');
$date_name3 = get_string('date_3rd_name', 'block_autoattend');
//// forst Table
include('html/deleteDB.html');
}
echo $OUTPUT->footer($course);