PHP delete_attendance_activity Examples

Example #1

File: index.php Project: nikosv/openeclass

             //insert
             $insertAct = Database::get()->query("INSERT INTO attendance_activities SET attendance_id = ?d, title = ?s, 
                                                         `date` = ?t, description = ?s", 
                                                 $attendance_id, $actTitle, $actDate, $actDesc);
             Session::Messages("$langGradebookSucInsert","alert-success");
             redirect_to_home_page("modules/attendance/index.php?course=$course_code&attendance_id=$attendance_id");
         }            
     } else {
         Session::flashPost()->Messages($langFormErrors)->Errors($v->errors());
         $new_or_edit = $_POST['id'] ?  "&modify=".getIndirectReference($_POST['id']) : "&addActivity=1";
         redirect_to_home_page("modules/attendance/index.php?course=$course_code&attendance_id=".$attendance_id.$new_or_edit);            
     }        
 }
 
 elseif (isset($_GET['delete'])) {
     delete_attendance_activity($attendance_id, getDirectReference($_GET['delete']));
     redirect_to_home_page("modules/attendance/index.php?course=$course_code&attendance_id=$attendance_id");
 
 // delete attendance
 } elseif (isset($_GET['delete_at'])) {        
     delete_attendance($_GET['delete_at']);
     redirect_to_home_page("modules/attendance/index.php?course=$course_code");
 }
 
 //DISPLAY: list of users and form for each user
 elseif(isset($_GET['attendanceBook']) or isset($_GET['book'])) {        
     if (isset($_GET['update']) and $_GET['update']) {
         $tool_content .= "<div class='alert alert-success'>$langAttendanceUsers</div>";
     }
     //record booking
     if(isset($_POST['bookUser'])) {

Example #2

File: functions.php Project: nikosv/openeclass

/**
 * @brief delete attendance
 * @global type $course_id
 * @global type $langAttendanceDeleted
 * @param type $attendance_id
 */
function delete_attendance($attendance_id) {
    
    global $course_id, $langAttendanceDeleted;
    
    $r = Database::get()->queryArray("SELECT id FROM attendance_activities WHERE attendance_id = ?d", $attendance_id);
    foreach ($r as $act) {
        delete_attendance_activity($attendance_id, $act->id);
    }
    Database::get()->query("DELETE FROM attendance_users WHERE attendance_id = ?d", $attendance_id);
    $action = Database::get()->query("DELETE FROM attendance WHERE id = ?d AND course_id = ?d", $attendance_id, $course_id);
    if ($action) {
        Session::Messages("$langAttendanceDeleted", "alert-success");
    }
}