Viewing file:  clsPayment.php (3.34 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
//--Class Payment--------------------------
include_once "clsbase_Payment.php";
class Payment extends base_Payment{
function GetSumLateFineByStId($xKey){
$this->SetQuery("select sum(lateFine) as num from EnrollFee, Payment where EnrollFee.studentId='$xKey' and EnrollFee.enrollFeeId=Payment.enrollFeeId and paymentLate='Y'");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function GetSumLateFineByStIdAndAcYAndStYAndSe($wKey, $xKey, $yKey, $zKey){
$this->SetQuery("select sum(lateFine) as num from EnrollFee, Payment where EnrollFee.studentId='$wKey' and EnrollFee.enrollFeeId=Payment.enrollFeeId and acadYear='$xKey' and studentYear='$yKey' and semester='$zKey' and paymentLate='Y'");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function GetSumLateFineByAcYAndStYAndSeAndPgId($wKey, $xKey, $yKey, $zKey){
$this->SetQuery("select sum(lateFine) as num from EnrollFee, Payment where EnrollFee.enrollFeeId=Payment.enrollFeeId and acadYear='$wKey' and studentYear='$xKey' and semester='$yKey' and programId='$zKey' and paymentLate='Y'");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function RSPaymentByPayDateGroupOrderPayDate($xKey, $yKey){
$this->SetQuery("select payDate from Payment where payDate between '$xKey' and '$yKey' group by payDate order by payDate");
}
function GetSumPayAmountByPayDate($xKey){
$this->SetQuery("select sum(payAmount) as num from Payment where payDate='$xKey'");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function RSPaymentByPayDateOrderPayDate($xKey, $yKey){
$this->SetQuery("select * from Payment where payDate between '$xKey' and '$yKey' order by payDate");
}
function GetSumPayAmountByEfIdAndPayDate($xKey, $yKey){
$this->SetQuery("select sum(payAmount) as num from Payment, EnrollFee where Payment.enrollFeeId='$xKey' and payDate<'$yKey' and EnrollFee.enrollFeeId=Payment.enrollFeeId");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function GetSumLateFineByEfId($xKey){
$this->SetQuery("select sum(lateFine) as num from Payment where enrollFeeId='$xKey' and paymentLate='Y'");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function GetMaxYearOfRefNo(){
$this->SetQuery("select max(substr(refNo, 5, 2)) as num from Payment");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function GetMaxNoOfRefNoByYear($xKey){
$this->SetQuery("select max(substr(refNo, 1, 3)) as num from Payment where substr(refNo, 5, 2)='$xKey'");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
//--Use on page paymentEnroll.php--
function RSPaymentByEfId($xKey){
$this->SetQuery("select * from Payment where enrollFeeId='$xKey'");
}
function numDateDiff($date1,$date2){
$this->SetQuery("SELECT DATEDIFF('$date1','$date2') as num");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function GetMaxRefNo(){
$this->SetQuery("select max(refNo) as num from Payment");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function GetMaxCodePayId($enrollFeeId){
$this->SetQuery("select max(payId) as num from Payment where enrollFeeId='$enrollFeeId'");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
//--The end--
} //--End class Payment--
?>
|