Viewing file: clsCourseFee.php (1.07 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php //--Class CourseFee--------------------------
include_once "clsbase_CourseFee.php";
class CourseFee extends base_CourseFee{
function RSCourseFeeByStIdAndAcYAndSe($xKey, $yKey, $zKey){ $this->SetQuery("select * from CourseFee where studentId='$xKey' and acadYear='$yKey' and semester='$zKey'"); }
function GetSumLcFeeByStIdAndAcYAndSe($xKey, $yKey, $zKey){ $this->SetQuery("select sum(lcFee) as num from CourseFee where studentId='$xKey' and acadYear='$yKey' and semester='$zKey'"); if ($result=$this->GetResult()) { return $result['num']; } }
function GetSumLbFeeByStIdAndAcYAndSe($xKey, $yKey, $zKey){ $this->SetQuery("select sum(lbFee) as num from CourseFee where studentId='$xKey' and acadYear='$yKey' and semester='$zKey'"); if ($result=$this->GetResult()) { return $result['num']; } }
function GetSumKssFeeByStIdAndAcYAndSe($xKey, $yKey, $zKey){ $this->SetQuery("select sum(kssFee) as num from CourseFee where studentId='$xKey' and acadYear='$yKey' and semester='$zKey'"); if ($result=$this->GetResult()) { return $result['num']; } }
} //--End class CourseFee-- ?>
|