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