<?php
//--Class CommonFee--------------------------

include_once "clsbase_CommonFee.php";

class CommonFee extends base_CommonFee{

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

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

function GetSumAmountByStIdAndAcYAndSeAndOutBudgetIsY($xKey, $yKey, $zKey){
	$this->SetQuery("select sum(amount) as num from CommonFee, Fee where studentId='$xKey' and acadYear='$yKey' and semester='$zKey' and CommonFee.feeId=Fee.feeId and outBudget='Y'");
	if ($result=$this->GetResult()) {
		return $result['num'];
	}
}

function GetSumAmountByStIdAndAcYAndSeAndOutBudgetIsN($xKey, $yKey, $zKey){
	$this->SetQuery("select sum(amount) as num from CommonFee, Fee where studentId='$xKey' and acadYear='$yKey' and semester='$zKey' and CommonFee.feeId=Fee.feeId and outBudget='N'");
	if ($result=$this->GetResult()) {
		return $result['num'];
	}
}

} //--End class CommonFee--
?>