public function show() { $term = Term::getSelectedTerm(); $db = new PHPWS_DB('hms_residence_hall'); $db->addWhere('is_online', '1'); $db->addWhere('term', $term); $num_online = $db->select('count'); unset($db); $db = new PHPWS_DB('hms_residence_hall'); $db->addWhere('is_online', '0'); $db->addWhere('term', $term); $num_offline = $db->select('count'); unset($db); $db = new PHPWS_DB('hms_learning_communities'); $num_lcs = $db->select('count'); unset($db); $db = new PHPWS_DB('hms_assignment'); $db->addWhere('term', $term); $num_assigned = $db->select('count'); unset($db); $db = new PHPWS_DB('hms_new_application'); $db->addWhere('term', $term); $db->addWhere('student_type', TYPE_FRESHMEN); $num_f_applications = $db->select('count'); unset($db); $db = new PHPWS_DB('hms_new_application'); $db->addWhere('term', $term); $db->addWhere('student_type', TYPE_TRANSFER); $num_t_applications = $db->select('count'); unset($db); $db = new PHPWS_DB('hms_learning_community_applications'); $db->addWhere('term', $term); $num_rlc_applications = $db->select('count'); unset($db); PHPWS_Core::initModClass('hms', 'HMS_Lottery.php'); $lottery_term = PHPWS_Settings::get('hms', 'lottery_term'); $db = new PHPWS_DB('hms_lottery_entry'); $db->addWhere('term', $lottery_term); $num_lottery_entries = $db->select('count'); unset($db); $db = new PHPWS_DB('hms_assignment'); $db->addWhere('term', $lottery_term); $db->addWhere('lottery', 1); $num_lottery_assigned = $db->select('count'); $tpl = array(); $tpl['TITLE'] = "HMS Overview - {$term}"; $tpl['NUM_LCS'] = $num_lcs; $tpl['NUM_ONLINE'] = $num_online; $tpl['NUM_OFFLINE'] = $num_offline; $tpl['NUM_ASSIGNED'] = $num_assigned; $tpl['NUM_F_APPLICATIONS'] = $num_f_applications; $tpl['NUM_T_APPLICATIONS'] = $num_t_applications; $tpl['NUM_RLC_APPLICATIONS'] = $num_rlc_applications; PHPWS_Core::initModClass('hms', 'HMS_Lottery.php'); $lottery_term = PHPWS_Settings::get('hms', 'lottery_term'); $tpl['LOTTERY_APPLICATIONS'] = $num_lottery_entries; $tpl['SOPH_APPLICATIONS'] = HMS_Lottery::count_applications_by_class($lottery_term, CLASS_SOPHOMORE); $tpl['JR_APPLICATIONS'] = HMS_Lottery::count_applications_by_class($lottery_term, CLASS_JUNIOR); $tpl['SR_APPLICATIONS'] = HMS_Lottery::count_applications_by_class($lottery_term, CLASS_SENIOR); $tpl['LOTTERY_ASSIGNED'] = $num_lottery_assigned; $tpl['SOPH_ASSIGNED'] = HMS_Lottery::count_assignments_by_class($lottery_term, CLASS_SOPHOMORE); $tpl['JR_ASSIGNED'] = HMS_Lottery::count_assignments_by_class($lottery_term, CLASS_JUNIOR); $tpl['SR_ASSIGNED'] = HMS_Lottery::count_assignments_by_class($lottery_term, CLASS_SENIOR); $tpl['SOPH_ENTRIES_REMAIN'] = HMS_Lottery::count_remaining_entries_by_class($lottery_term, CLASS_SOPHOMORE); $tpl['JR_ENTRIES_REMAIN'] = HMS_Lottery::count_remaining_entries_by_class($lottery_term, CLASS_JUNIOR); $tpl['SR_ENTRIES_REMAIN'] = HMS_Lottery::count_remaining_entries_by_class($lottery_term, CLASS_SENIOR); $tpl['OUTSTANDING_INVITES'] = HMS_Lottery::count_outstanding_invites($lottery_term, MALE) + HMS_Lottery::count_outstanding_invites($lottery_term, FEMALE); $tpl['SOPH_OUTSTANDING'] = HMS_Lottery::count_outstanding_invites_by_class($lottery_term, CLASS_SOPHOMORE); $tpl['JR_OUTSTANDING'] = HMS_Lottery::count_outstanding_invites_by_class($lottery_term, CLASS_JUNIOR); $tpl['SR_OUTSTANDING'] = HMS_Lottery::count_outstanding_invites_by_class($lottery_term, CLASS_SENIOR); $tpl['ROOMMATE_INVITES'] = HMS_Lottery::count_outstanding_roommate_invites($lottery_term); $tpl['REMAINING_ENTRIES'] = HMS_Lottery::count_remaining_entries($lottery_term); $tpl['SOPH_INVITES'] = HMS_Lottery::count_invites_by_class($lottery_term, CLASS_SOPHOMORE); $tpl['JR_INVITES'] = HMS_Lottery::count_invites_by_class($lottery_term, CLASS_JUNIOR); $tpl['SR_INVITES'] = HMS_Lottery::count_invites_by_class($lottery_term, CLASS_SENIOR); $final = PHPWS_Template::process($tpl, 'hms', 'admin/statistics.tpl'); Layout::addPageTitle("Statistics"); return $final; }