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; }