editattendees.php

<?php

require_once '../../config.php';
require_once 'lib.php';
require_once 'signupmeeting.php';
require_once 'cancelsignupmeeting.php';
require_once 'sendemailsignup.php';
require_once 'sendemailcancelsignup.php';

define('MAX_USERS_PER_PAGE', 5000);

$s              = required_param('s', PARAM_INT); // webinar session ID
$add            = optional_param('add', 0, PARAM_BOOL);
$remove         = optional_param('remove', 0, PARAM_BOOL);
$showall        = optional_param('showall', 0, PARAM_BOOL);
$searchtext     = optional_param('searchtext', '', PARAM_RAW); // search string
$suppressemail  = optional_param('suppressemail', false, PARAM_BOOL); // send email notifications
$previoussearch = optional_param('previoussearch', 0, PARAM_BOOL);
$backtoallsessions = optional_param('backtoallsessions', 0, PARAM_INT); // webinar activity to go back to

if (!$session = webinar_get_session($s)) {
    print_error('error:incorrectcoursemodulesession', 'webinar');
}
if (!$webinar = $DB->get_record('webinar', array('id' => $session->webinar))) {
    print_error('error:incorrectwebinarid', 'webinar');
}
if (!$course = $DB->get_record('course', array('id' => $webinar->course))) {
    print_error('error:coursemisconfigured', 'webinar');
}
if (!$cm = get_coursemodule_from_instance('webinar', $webinar->id, $course->id)) {
    print_error('error:incorrectcoursemodule', 'webinar');
}

/// Check essential permissions
require_course_login($course);
$context = get_context_instance(CONTEXT_COURSE, $course->id);
require_capability('mod/webinar:viewattendees', $context);

/// Get some language strings
$strsearch = get_string('search');
$strshowall = get_string('showall');
$strsearchresults = get_string('searchresults');
$strwebinars = get_string('modulenameplural', 'webinar');
$strwebinar = get_string('modulename', 'webinar');

$errors = array();

/// Handle the POST actions sent to the page
if ($frm = data_submitted()) {

    // Add button
    if ($add and !empty($frm->addselect) and confirm_sesskey()) {
        require_capability('mod/webinar:addattendees', $context);

        foreach ($frm->addselect as $adduser) {
            if (!$adduser = clean_param($adduser, PARAM_INT)) {
                continue; // invalid userid
            }

            // Make sure that the user is enroled in the course
            if (!has_capability('moodle/course:view', $context, $adduser)) {
                $user = $DB->get_record('user', array('id' => $adduser));

            }

            if (!webinar_session_has_capacity($session, $context)) {
                    $errors[] = get_string('full', 'webinar');
                    break; // no point in trying to add other people
            }

            // Check if we are waitlisting or booking
             //if ($session->datetimeknown) {
              //      $status = WEBINAR_STATUS_BOOKED;
            //} 
			//else {
                    $status = WEBINAR_STATUS_WAITLISTED;
           //}

            if (!webinar_user_signup($session, $webinar, $course, '', WEBINAR_BOTH,
                                                $status, $adduser, !$suppressemail)) {
                    $erruser = $DB->get_record('user', array('id' => $adduser), 'id, firstname, lastname');
                    $errors[] = get_string('error:addattendee', 'webinar', fullname($erruser));
            }
			else {
				//Sign up user to this webinar through Adobe Connect API call
				signup_meeting($webinar, $session, $user);
					
				//Send registration email to user
				send_email_signup($webinar, $session, $cm, $user);
			}
        }
    }
    // Remove button
    else if ($remove and !empty($frm->removeselect) and confirm_sesskey()) {
        require_capability('mod/webinar:removeattendees', $context);

        foreach ($frm->removeselect as $removeuser) {
            if (!$removeuser = clean_param($removeuser, PARAM_INT)) {
                continue; // invalid userid
            }

            if (webinar_user_cancel($session, $removeuser, true, $cancelerr)) {
                // Notify the user of the cancellation if the session hasn't started yet
                $timenow = time();
                if (!$suppressemail and !webinar_has_session_started($session, $timenow)) {
                    webinar_send_cancellation_notice($webinar, $session, $removeuser);
                }
            }
            else {
                $errors[] = $cancelerr;
                $erruser = $DB->get_record('user', array('id' => $removeuser), 'id, firstname, lastname');
                $errors[] = get_string('error:removeattendee', 'webinar', fullname($erruser));
            }
        }

        // Update attendees
        webinar_update_attendees($session);
		
		$user = $DB->get_record('user', array('id' => $removeuser));
		
		//Unregister this user from this webinar through Adobe Connect API call
		cancelsignup_meeting($webinar, $session, $user);
		
		//Send cancel registration email to user
		send_email_cancelsignup($webinar, $session, $cm, $user);
    }
    // "Show All" button
    elseif ($showall) {
        $searchtext = '';
        $previoussearch = 0;
    }
}

/// Main page
$pagetitle = format_string($webinar->name);
$navlinks[] = array('name' => $strwebinars, 'link' => "index.php?id=$course->id", 'type' => 'title');
$navlinks[] = array('name' => $pagetitle, 'link' => "view.php?f=$webinar->id", 'type' => 'activityinstance');
$navlinks[] = array('name' => get_string('attendees', 'webinar'), 'link' => "attendees.php?s=$session->id", 'type' => 'activityinstance');
$navlinks[] = array('name' => get_string('addremoveattendees', 'webinar'), 'link' => '', 'type' => 'title');
$navigation = build_navigation($navlinks);
/*print_header_simple($pagetitle, '', $navigation, '', '', true,
                    update_module_button($cm->id, $course->id, $strwebinar), navmenu($course, $cm));*/
					
$PAGE->set_pagetype('webinar');
$PAGE->set_title($webinar->name);
$PAGE->set_heading($webinar->name);
$PAGE->set_url('/editattendees.php?s='.$session->id.'&amp;backtoallsessions='.$backtoallsessions);
echo $OUTPUT->header();

echo $OUTPUT->box_start();
echo $OUTPUT->heading(get_string('addremoveattendees', 'webinar'));

/// Get the list of currently signed-up users
$existingusers = webinar_get_attendees($session->id);
$existingcount = $existingusers ? count($existingusers) : 0;

$select  = "username <> 'guest' AND deleted = 0 AND confirmed = 1";

/// Apply search terms
$searchtext = trim($searchtext);
if ($searchtext !== '') {   // Search for a subset of remaining users
    $LIKE      = sql_ilike();
    $FULLNAME  = sql_fullname();

    $selectsql = " AND ($FULLNAME $LIKE '%$searchtext%' OR
                            email $LIKE '%$searchtext%' OR
                         idnumber $LIKE '%$searchtext%' OR
                         username $LIKE '%$searchtext%') ";
    $select  .= $selectsql;
}

/// All non-signed up system users

$availableusers = $DB->get_recordset_sql('SELECT u.id, u.firstname, u.lastname, u.email 
	FROM '.$CFG->prefix.'user u, '.$CFG->prefix.'enrol e, '.$CFG->prefix.'user_enrolments ue 
	WHERE 
	e.courseid = '.$course->id.'
	AND 
	ue.enrolid = e.id 
	AND 
	u.id = ue.userid 
	ORDER BY u.lastname ASC, u.firstname ASC');			  
										  
$availablecount = $DB->get_recordset_sql('SELECT COUNT(u.id) AS avusers
	FROM '.$CFG->prefix.'user u, '.$CFG->prefix.'enrol e, '.$CFG->prefix.'user_enrolments ue 
	WHERE 
	e.courseid = '.$course->id.'
	AND 
	ue.enrolid = e.id 
	AND 
	u.id = ue.userid');		

foreach ($availablecount as $ac) {
	$potential_users = $ac->avusers;
}

//$usercount = $DB->count_records_select('user', $select) - $existingcount;
$usercount = $potential_users;

// Get all signed up non-attendees
$nonattendees = 0;

$nonattendees_sql = "
        SELECT
            u.id,
            u.firstname,
            u.lastname,
            u.email,
            ss.statuscode
        FROM
            {$CFG->prefix}webinar_sessions s
        JOIN
            {$CFG->prefix}webinar_signups su
         ON s.id = su.sessionid
        JOIN
            {$CFG->prefix}webinar_signups_status ss
         ON su.id = ss.signupid
        JOIN
            {$CFG->prefix}user u
         ON u.id = su.userid
        WHERE
            s.id = {$session->id}
        AND ss.superceded != 1
        AND ss.statuscode = ".WEBINAR_STATUS_REQUESTED."
        ORDER BY
            u.lastname, u.firstname
    ";

$nonattendees_rs = $DB->get_recordset_sql($nonattendees_sql);

$table = new html_table();
$table->head = array(get_string('name'), get_string('email'), get_string('status'));
$table->align = array('left');
$table->size = array('50%');
$table->width = '70%';

if ($na_rs = $DB->get_recordset_sql($nonattendees_sql)) {
	foreach ($na_rs as $record) {
		$data[] = $record->firstname . ' ' . $record->lastname;
		
		$data[] = $record->email;
		//$data[] = get_string('status_'.webinar_get_status($user->statuscode), 'webinar');
		
		$table->data[] = $data;
	}
	
	$na_rs->close();
}

/// Prints a form to add/remove users from the session
include('editattendees.html');

if (!empty($errors)) {
    $msg = '<p>';
    foreach ($errors as $e) {
        $msg .= $e.'<br />';
    }
    $msg .= '</p>';
    print_simple_box_start('center');
    notify($msg);
    print_simple_box_end();
}

// Bottom of the page links
print '<p style="text-align: center">';
$url = $CFG->wwwroot.'/mod/webinar/attendees.php?s='.$session->id.'&amp;backtoallsessions='.$backtoallsessions;
print '<a href="'.$url.'">'.get_string('goback', 'webinar').'</a></p>';

echo $OUTPUT->box_end();
echo $OUTPUT->footer($course);