public function show()
{
$tpl = array();
PHPWS_Core::initModClass('hms', 'HMS_Roommate.php');
PHPWS_Core::initModClass('hms', 'HMS_Util.php');
$roommate = HMS_Roommate::get_confirmed_roommate(UserStatus::getUsername(), $this->term);
$requests = HMS_Roommate::countPendingRequests(UserStatus::getUsername(), $this->term);
$tpl['DATES'] = HMS_Util::getPrettyDateRange($this->startDate, $this->endDate);
$tpl['STATUS'] = "";
// Roommate has been selected and confirmed
if (!is_null($roommate)) {
$name = $roommate->getFullName();
$tpl['ROOMMATE_MSG'] = "<b>{$name}</b> has confirmed your roommate request. Roommate requests are subject to space availability.";
$tpl['ICON'] = FEATURE_COMPLETED_ICON;
if (time() < $this->editDate) {
$cmd = CommandFactory::GetCommand('ShowRoommateBreak');
$rm = HMS_Roommate::getByUsernames(UserStatus::getUsername(), $roommate->getUsername(), $this->term);
$cmd->setRoommateId($rm->id);
$tpl['ROOMMATE_BREAK'] = $cmd->getLink('Remove roommate request');
}
} else {
if (time() < $this->startDate) {
$tpl['ROOMMATE_MSG'] = '<b>It is too early to choose a roommate.</b> You can choose a roommate on ' . HMS_Util::getFriendlyDate($this->startDate) . '.';
$tpl['ICON'] = FEATURE_NOTYET_ICON;
} else {
if (time() > $this->endDate) {
$tpl['ROOMMATE_MSG'] = '<b>It is too late to choose a roommate.</b> The deadline passed on ' . HMS_Util::getFriendlyDate($this->endDate) . '.';
// fade out header
$tpl['STATUS'] = "locked";
$tpl['ICON'] = FEATURE_LOCKED_ICON;
} else {
if ($requests > 0) {
$tpl['ROOMMATE_REQUESTS'] = HMS_Roommate::display_requests(UserStatus::getUsername(), $this->term);
if ($requests == 1) {
$tpl['ROOMMATE_REQUESTS_MSG'] = "<b style='color: #F00'>You have a roommate request.</b> Please click the name below to confirm or reject the request.";
} else {
$tpl['ROOMMATE_REQUESTS_MSG'] = "<b style='color: #F00'>You have roommate requests.</b> Please click a name below to confirm or reject a request.";
}
} else {
if (HMS_Roommate::has_roommate_request(UserStatus::getUsername(), $this->term)) {
$tpl['ICON'] = FEATURE_COMPLETED_ICON;
$tpl['ROOMMATE_MSG'] = "<b>You have selected a roommate</b> and are awaiting their approval.";
$requestee = HMS_Roommate::get_unconfirmed_roommate(UserStatus::getUsername(), $this->term);
if (time() < $this->editDate) {
$rm = HMS_Roommate::getByUsernames(UserStatus::getUsername(), $requestee, $this->term);
$cmd = CommandFactory::getCommand('RoommateRequestCancel');
$cmd->setRoommateId($rm->id);
$tpl['ROOMMATE_BREAK'] = $cmd->getLink('Cancel Request');
}
} else {
$tpl['ICON'] = FEATURE_OPEN_ICON;
$tpl['ROOMMATE_MSG'] = 'If you know who you want your roommate to be, <b>you may select your roommate now</b>. You will need to know your roommate\'s ASU user name (their e-mail address). You have until ' . HMS_Util::getFriendlyDate($this->endDate) . ' to choose a roommate. Click the link below to select your roommate.';
$cmd = CommandFactory::getCommand('ShowRequestRoommate');
$cmd->setTerm($this->term);
$tpl['ROOMMATE_LINK'] = $cmd->getLink('Select Your Roommate');
}
}
}
}
}
Layout::addPageTitle("Roommate Selection");
return PHPWS_Template::process($tpl, 'hms', 'student/menuBlocks/roommateMenuBlock.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 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;
}
