<?php
//--Class ProgramFeeTP--------------------------

include_once "clsbase_ProgramFeeTP.php";

class ProgramFeeTP extends base_ProgramFeeTP{

function RSProgramFeeTPByPgIdAndAcYAndSe($xKey, $yKey, $zKey){
	$this->SetQuery("select * from ProgramFeeTP where programId='$xKey' and acadYear='$yKey' and semester='$zKey'");
}

function RSProgramFeeTPByPgIdAndAcYAndSeLimit($xKey, $yKey, $zKey, $start, $pageSize){
	$this->SetQuery("select * from ProgramFeeTP where programId='$xKey' and acadYear='$yKey' and semester='$zKey' limit $start, $pageSize");
}

function RSProgramFeeTPByAcYAndSeGroupFeeId($xKey, $yKey){
	$this->SetQuery("select feeId from ProgramFeeTP where acadYear='$xKey' and semester='$yKey' group by feeId");
}

function GetAmountByAcYAndSeAndFeeId($xKey, $yKey, $zKey){
	$this->SetQuery("select sum(amount) as num from ProgramFeeTP where acadYear='$xKey' and semester='$yKey' and feeId='$zKey'");
    if ($result=$this->GetResult()) {
        return $result['num'];
    }
}

} //--End class ProgramFeeTP--
?>