<?php
//--Class SummaryStudent--------------------------

include_once "clsbase_SummaryStudent.php";

class SummaryStudent extends base_SummaryStudent {

function RSSummaryStudentByAcY($xKey){
    $this->SetQuery("select * from SummaryStudent where acadYear='$xKey'");
}

function RSSummaryStudentByAcYAndAdmitStNum($xKey){
    $this->SetQuery("select * from SummaryStudent where acadYear='$xKey' and admitStNum<>0");
}

function RSSummaryStudentByAcYAndGraduateStNum($xKey){
    $this->SetQuery("select * from SummaryStudent where acadYear='$xKey' and graduateStNum<>0");
}

function RSSummaryStudentByAcYAndScholarStNum($xKey){
    $this->SetQuery("select * from SummaryStudent where acadYear='$xKey' and scholarStNum<>0");
}

function GetSumAdmitStNumByAcY($xKey){
    $this->SetQuery("select sum(admitStNum) as num from SummaryStudent where acadYear='$xKey'");
    if ($result=$this->GetResult()) {
        return $result['num'];
    }
}

function GetSumGraduateStNumByAcY($xKey){
    $this->SetQuery("select sum(graduateStNum) as num from SummaryStudent where acadYear='$xKey'");
    if ($result=$this->GetResult()) {
        return $result['num'];
    }
}

function GetSumScholarStNumByAcY($xKey){
    $this->SetQuery("select sum(scholarStNum) as num from SummaryStudent where acadYear='$xKey'");
    if ($result=$this->GetResult()) {
        return $result['num'];
    }
}

} //--End class SummaryStudent--
?>