AppStateESS/homestead

<?php

namespace Homestead;

use \PHPWS_DB;

class StatsView extends View {

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

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

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

}