public function show()
{
PHPWS_Core::initCoreClass('DBPager.php');
$tags = array();
$tags['TITLE'] = "View Final RLC Assignments " . Term::toString(Term::getSelectedTerm());
$pager = new DBPager('hms_learning_community_assignment', 'HMS_RLC_Assignment');
//$pager->db->addWhere('hms_learning_community_applications.hms_assignment_id','hms_learning_community_assignment.id','=');
$pager->db->addJoin('LEFT OUTER', 'hms_learning_community_assignment', 'hms_learning_community_applications', 'application_id', 'id');
$pager->db->addWhere('hms_learning_community_applications.term', Term::getSelectedTerm());
$pager->db->addWhere('hms_learning_community_assignment.state', 'confirmed');
$pager->joinResult('application_id', 'hms_learning_community_applications', 'id', 'username', 'username');
$pager->joinResult('application_id', 'hms_learning_community_applications', 'id', 'term', 'term');
$pager->setModule('hms');
$pager->setTemplate('admin/display_final_rlc_assignments.tpl');
$pager->setLink('index.php?module=hms&type=rlc&op=assign_applicants_to_rlcs');
$pager->setEmptyMessage('No RLC assignments have been made.');
$pager->addPageTags($tags);
$pager->addRowTags('getAdminPagerTags');
$pager->setReportRow('getAdminCsvRow');
Layout::addPageTitle("RLC Assignments");
return $pager->get();
}
/**
* Waiting List pager for On-campus Waiting List
* @return string HTML for pager
*/
public static function waitingListPager()
{
PHPWS_Core::initCoreClass('DBPager.php');
$term = PHPWS_Settings::get('hms', 'lottery_term');
$pager = new DBPager('hms_new_application', 'LotteryApplication');
$pager->db->addColumn('hms_new_application.*');
$pager->db->addColumn('hms_lottery_application.*');
$pager->db->addJoin('LEFT', 'hms_new_application', 'hms_lottery_application', 'id', 'id');
$pager->db->addJoin('LEFT OUTER', 'hms_new_application', 'hms_assignment', 'username', 'asu_username AND hms_new_application.term = hms_assignment.term');
$pager->db->addWhere('hms_assignment.asu_username', 'NULL');
$pager->db->addWhere('hms_new_application.term', $term);
$pager->db->addWhere('hms_new_application.cancelled', 0);
$pager->db->addWhere('hms_lottery_application.special_interest', 'NULL');
$pager->db->addWhere('hms_lottery_application.waiting_list_date', 'NULL', '!=');
// Order by class, then by application ID in order to keep a fixed order
// This accounts for the 'you are x of y students' message on the student's menu
$pager->db->addOrder(array('application_term DESC', 'hms_new_application.id ASC'));
$pager->setModule('hms');
$pager->setTemplate('admin/lottery_wait_list_pager.tpl');
$pager->setEmptyMessage('No students found.');
$pager->addPageTags(array('TITLE' => 'Re-application Waiting List - ' . Term::toString($term)));
$pager->addRowTags('waitingListTags');
$pager->setReportRow('waitingListCsvTags');
$pager->setSearch('hms_new_application.username', 'hms_new_application.banner_id');
return $pager->get();
}
public static function waitingListPager()
{
PHPWS_Core::initCoreClass('DBPager.php');
$term = PHPWS_Settings::get('hms', 'lottery_term');
$pager = new DBPager('hms_new_application', 'WaitingListApplication');
$pager->db->addJoin('LEFT', 'hms_new_application', 'hms_waitlist_application', 'id', 'id');
$pager->db->addJoin('LEFT OUTER', 'hms_new_application', 'hms_assignment', 'username', 'asu_username AND hms_new_application.term = hms_assignment.term');
$pager->db->addWhere('hms_assignment.asu_username', 'NULL');
$pager->db->addWhere('hms_new_application.term', $term);
$pager->db->addWhere('hms_new_application.application_type', 'offcampus_waiting_list');
$pager->db->addWhere('hms_new_application.physical_disability', 0);
$pager->db->addWhere('hms_new_application.psych_disability', 0);
$pager->db->addWhere('hms_new_application.medical_need', 0);
$pager->db->addWhere('hms_new_application.gender_need', 0);
$pager->db->addWhere('hms_new_application.cancelled', 0);
$pager->db->addOrder('hms_new_application.created_on ASC');
//$query = "select username from hms_new_application UNION ALL select asu_username from hms_assignment";
//$pager->db->setSQLQuery($query);
$pager->setModule('hms');
$pager->setTemplate('admin/lottery_wait_list_pager.tpl');
$pager->setEmptyMessage('No students found.');
$pager->addPageTags(array('TITLE' => 'Open Waiting List - ' . Term::toString($term)));
$pager->addRowTags('waitingListTags');
$pager->setReportRow('waitingListCsvTags');
$pager->setSearch('hms_new_application.username', 'hms_new_application.banner_id');
return $pager->get();
}
/**
* RLC Application pager for the RLC admin panel
*
* @return string HTML for application pager
*/
public function rlcApplicationPager()
{
PHPWS_Core::initCoreClass('DBPager.php');
$submitCmd = CommandFactory::getCommand('AssignRlcApplicants');
$form = new PHPWS_Form();
$submitCmd->initForm($form);
$form->addSubmit('submit', 'Submit Changes');
$form->setClass('submit', 'btn btn-primary');
$tags = $form->getTemplate();
$pager = new DBPager('hms_learning_community_applications', 'HMS_RLC_Application');
$pager->db->addColumn('hms_learning_community_applications.*');
$pager->db->addJoin('LEFT OUTER', 'hms_learning_community_applications', 'hms_learning_community_assignment', 'id', 'application_id');
$pager->db->addWhere('hms_learning_community_assignment.application_id', 'NULL', '=');
$pager->db->addWhere('term', $this->term);
$pager->db->addWhere('denied', 0);
// Only show non-denied applications in this pager
// If community filter is set, use it
if (isset($this->rlc)) {
$pager->db->addWhere('hms_learning_community_applications.rlc_first_choice_id', $this->rlc->getId(), '=');
}
// If student type filter is set, use it
if (isset($this->studentType)) {
if ($this->studentType == TYPE_FRESHMEN) {
$pager->db->addWhere('hms_learning_community_applications.application_type', 'freshmen');
} else {
if ($this->studentType == TYPE_CONTINUING) {
// TODO fix this so 'returning' is consistent with 'continuing'.. really just use student types
$pager->db->addWhere('hms_learning_community_applications.application_type', 'returning');
}
}
}
$pager->setModule('hms');
$pager->setLink('index.php?module=hms&action=SubmitRlcAssignments');
$pager->setTemplate('admin/rlc_assignments_pager.tpl');
$pager->setEmptyMessage("No pending RLC applications.");
$pager->addPageTags($tags);
$pager->addRowTags('getAdminPagerTags');
$pager->setReportRow('applicantsReport');
Layout::addPageTitle("RLC Assignments");
return $pager->get();
}
public static function entry_list()
{
PHPWS_Core::initCoreClass('DBPager.php');
$db = new PHPWS_DB('blog_stickies');
$db->addColumn('blog_id');
$GLOBALS['blog_stickies'] = $db->select('col');
$pageTags['SUMMARY'] = dgettext('blog', 'Summary');
$pageTags['ACTION'] = dgettext('blog', 'Action');
$pageTags['ADD'] = PHPWS_Text::secureLink(t('Create new blog entry'), 'blog', array('action' => 'admin', 'command' => 'new'), null, t('Create new blog entry'), 'btn btn-success pull-right');
$pageTags['ADD_URI'] = PHPWS_Text::linkAddress('blog', array('action' => 'admin', 'command' => 'new'), true);
$pageTags['ADD_TEXT'] = t('Create new blog entry');
$pager = new DBPager('blog_entries', 'Blog');
$pager->addSortHeader('title', dgettext('blog', 'Title'));
$pager->addSortHeader('create_date', dgettext('blog', 'Creation'));
$pager->addSortHeader('publish_date', dgettext('blog', 'Publish'));
$pager->addSortHeader('expire_date', dgettext('blog', 'Expire'));
$pager->setModule('blog');
$pager->setTemplate('list.tpl');
$pager->addToggle('class="toggle1"');
$pager->addRowTags('getPagerTags');
$pager->addPageTags($pageTags);
$pager->setSearch('title');
$pager->setDefaultOrder('create_date', 'desc');
$pager->cacheQueries();
$pager->setReportRow('report_rows');
$content = $pager->get();
return $content;
}
