Viewing file:  clsCommonFee.php (1.21 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?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--
?>
|