public function execute(CommandContext $context)
{
if (!UserStatus::isUser()) {
PHPWS_Core::initModClass('hms', 'exception/PermissionException.php');
throw new PermissionException('You do not have permission to request a roommate.');
}
$term = $context->get('term');
if (is_null($term)) {
throw new InvalidArgumentException('Must specify a term.');
}
PHPWS_Core::initModClass('hms', 'HMS_Roommate.php');
$username = UserStatus::getUsername();
$err = CommandFactory::getCommand('ShowStudentMenu');
// Make sure the user doesn't already have a request pending
$result = HMS_Roommate::has_roommate_request($username, $term);
if ($result === TRUE) {
NQ::simple('hms', hms\NotificationView::WARNING, 'You have a pending roommate request. You can not request another roommate request until your current request is either denied or expires.');
$err->redirect();
}
// Make sure the user doesn't already have a confirmed roommate
$result = HMS_Roommate::has_confirmed_roommate($username, $term);
if ($result === TRUE) {
NQ::simple('hms', hms\NotificationView::WARNING, 'You already have a confirmed roommate.');
$err->redirect();
}
$form = new PHPWS_Form();
$cmd = CommandFactory::getCommand('RequestRoommate');
$cmd->setTerm($term);
$cmd->initForm($form);
$form->addText('username');
$form->addCssClass('username', 'form-control');
$form->setExtra('username', 'autofocus');
$form->addSubmit('submit', 'Request Roommate');
$form->addButton('cancel', 'Cancel');
$form->setExtra('cancel', 'onClick="document.location=\'index.php\'"');
$tpl = $form->getTemplate();
$context->setContent(PHPWS_Template::process($tpl, 'hms', 'student/select_roommate.tpl'));
}
public function applicantsReport()
{
PHPWS_Core::initModClass('hms', 'HMS_Roommate.php');
PHPWS_Core::initModClass('hms', 'HMS_Util.php');
$term = Term::getSelectedTerm();
$rlc_list = HMS_Learning_Community::getRlcList();
$student = StudentFactory::getStudentByUsername($this->username, $this->term);
$application_date = isset($this->date_submitted) ? HMS_Util::get_long_date($this->date_submitted) : 'Error with the submission date';
$roomie = null;
if (HMS_Roommate::has_confirmed_roommate($this->username, $term)) {
$roomie = HMS_Roommate::get_Confirmed_roommate($this->username, $term);
} elseif (HMS_Roommate::has_roommate_request($this->username, $term)) {
$roomie = HMS_Roommate::get_unconfirmed_roommate($this->username, $term) . ' *pending* ';
}
$row = array();
$row['last_name'] = $student->getLastName();
$row['first_name'] = $student->getFirstName();
$row['middle_name'] = $student->getMiddleName();
$row['gender'] = $student->getPrintableGender();
if ($roomie instanceof Student) {
$row['roommate'] = $roomie->getUsername();
} else {
$row['roommate'] = '';
}
$row['email'] = $student->getUsername() . '@appstate.edu';
$row['first_chocie'] = $rlc_list[$this->getFirstChoice()];
$row['second_choice'] = $rlc_list[$this->getSecondChoice()];
$row['third_choice'] = $rlc_list[$this->getThirdChoice()];
$row['application_date'] = $application_date;
$row['denied'] = isset($this->denied) && $this->denied == 0 ? 'no' : 'yes';
return $row;
}
public function canLiveTogetherAdmin(Student $roommate1, Student $roommate2, $term)
{
// Sanity Checking
if (is_null($roommate1)) {
throw new RoommateException('Null student object for roommate 1.');
}
if (is_null($roommate2)) {
throw new RoommateException('Null student object for roommate 1.');
}
// Check that the two user names aren't the same
if ($roommate1->getUsername() == $roommate2->getUsername()) {
throw new RoommateException('Roommate user names must be unique.');
}
// Use SOAP for the following checks
// Make that both roommate have some sort of soap info
$name = $roommate1->getLastName();
if (empty($name)) {
throw new RoommateException('No banner information for first roommate.');
}
$name = $roommate2->getLastName();
if (empty($name)) {
throw new RoommateException('No banner information for second roommate.');
}
// Make sure the genders match
if ($roommate1->getGender() != $roommate2->getGender()) {
throw new RoommateException('Roommate genders do not match.');
}
// Check if either has a confirmed roommate
if (HMS_Roommate::has_confirmed_roommate($roommate1->getUsername(), $term)) {
throw new RoommateException('The first roommate already has a confirmed roommate.');
}
if (HMS_Roommate::has_confirmed_roommate($roommate2->getUsername(), $term)) {
throw new RoommateException('The second roommate already has a confirmed roommate.');
}
true;
}
public function execute(CommandContext $context)
{
if (!Current_User::allow('hms', 'view_rlc_applications')) {
PHPWS_Core::initModClass('hms', 'exception/PermissionException.php');
throw new PermissionException('You do not have permission to view rlc applications');
}
$term = Term::getSelectedTerm();
$db = new PHPWS_DB('hms_learning_communities');
$db->addColumn('community_name');
$db->addWhere('id', $_REQUEST['rlc_list']);
$title = $db->select('one');
$filename = $title . '-applications-' . date('Ymd') . ".csv";
// setup the title and headings
$buffer = $title . "\n";
$buffer .= '"last_name","first_name","middle_name","gender","roommate","email","second_choice","third_choice","major","application_date","denied"' . "\n";
// get the userlist
$db = new PHPWS_DB('hms_learning_community_applications');
$db->addColumn('username');
$db->addColumn('rlc_second_choice_id');
$db->addColumn('rlc_third_choice_id');
$db->addColumn('date_submitted');
$db->addWhere('rlc_first_choice_id', $_REQUEST['rlc_list']);
$db->addWhere('term', Term::getSelectedTerm());
$db->addOrder('denied asc');
//$db->addWhere('denied', 0); // Only show non-denied applications
$users = $db->select();
foreach ($users as $user) {
PHPWS_Core::initModClass('hms', 'HMS_Roommate.php');
$roomie = NULL;
$roomie = HMS_Roommate::has_confirmed_roommate($user['username'], $term) ? HMS_Roommate::get_Confirmed_roommate($user['username'], $term) : NULL;
if ($roomie == NULL) {
$roomie = HMS_Roommate::has_roommate_request($user['username'], $term) ? HMS_Roommate::get_unconfirmed_roommate($user['username'], $term) . ' *pending* ' : NULL;
}
$student = StudentFactory::getStudentByUsername($user['username'], Term::getSelectedTerm());
$buffer .= '"' . $student->getLastName() . '",';
$buffer .= '"' . $student->getFirstName() . '",';
$buffer .= '"' . $student->getMiddleName() . '",';
$buffer .= '"' . $student->getPrintableGender() . '",';
if ($roomie != NULL) {
$buffer .= '"' . $roomie->getFullName() . '",';
} else {
$buffer .= '"",';
}
$buffer .= '"' . $student->getUsername() . '@appstate.edu' . '",';
if (isset($user['rlc_second_choice_id'])) {
$db = new PHPWS_DB('hms_learning_communities');
$db->addColumn('community_name');
$db->addWhere('id', $user['rlc_second_choice_id']);
$result = $db->select('one');
if (!PHPWS_Error::logIfError($result)) {
$buffer .= '"' . $result . '",';
}
} else {
$buffer .= '"",';
}
if (isset($user['rlc_third_choice_id'])) {
$db = new PHPWS_DB('hms_learning_communities');
$db->addColumn('community_name');
$db->addWhere('id', $user['rlc_third_choice_id']);
$result = $db->select('one');
if (!PHPWS_Error::logIfError($result)) {
$buffer .= '"' . $result . '",';
}
} else {
$buffer .= '"",';
}
//Major for this user, N/A for now
$buffer .= '"N/A",';
//Application Date
if (isset($user['date_submitted'])) {
PHPWS_Core::initModClass('hms', 'HMS_Util.php');
$buffer .= '"' . HMS_Util::get_long_date($user['date_submitted']) . '",';
} else {
$buffer .= '"Error with the submission Date",';
}
//Denied
$buffer .= isset($user['denied']) && $user['denied'] == 1 ? '"yes"' : '"no"';
$buffer .= "\n";
}
//HERES THE QUERY:
//select hms_learning_community_applications.user_id, date_submitted, rlc_first_choice.abbreviation as first_choice, rlc_second_choice.abbreviation as second_choice, rlc_third_choice.abbreviation as third_choice FROM (SELECT hms_learning_community_applications.user_id, hms_learning_communities.abbreviation FROM hms_learning_communities,hms_learning_community_applications WHERE hms_learning_communities.id = hms_learning_community_applications.rlc_first_choice_id) as rlc_first_choice, (SELECT hms_learning_community_applications.user_id, hms_learning_communities.abbreviation FROM hms_learning_communities,hms_learning_community_applications WHERE hms_learning_communities.id = hms_learning_community_applications.rlc_second_choice_id) as rlc_second_choice, (SELECT hms_learning_community_applications.user_id, hms_learning_communities.abbreviation FROM hms_learning_communities,hms_learning_community_applications WHERE hms_learning_communities.id = hms_learning_community_applications.rlc_third_choice_id) as rlc_third_choice, hms_learning_community_applications WHERE rlc_first_choice.user_id = hms_learning_community_applications.user_id AND rlc_second_choice.user_id = hms_learning_community_applications.user_id AND rlc_third_choice.user_id = hms_learning_community_applications.user_id;
//Download file
if (ob_get_contents()) {
print 'Some data has already been output, can\'t send file';
}
if (isset($_SERVER['HTTP_USER_AGENT']) && strpos($_SERVER['HTTP_USER_AGENT'], 'MSIE')) {
header('Content-Type: application/force-download');
} else {
header('Content-Type: application/octet-stream');
}
if (headers_sent()) {
print 'Some data has already been output to browser, can\'t send file';
}
header('Content-Length: ' . strlen($buffer));
header('Content-disposition: attachment; filename="' . $filename . '"');
echo $buffer;
die;
}
