<?php
//--Class EnrollFee--------------------------

include_once "clsbase_EnrollFee.php";

class EnrollFee extends base_EnrollFee{

/*function RSEnrollFeeByAcYAndStYAndSeAndPgId($wKey, $xKey, $yKey, $zKey){
	$this->SetQuery("select studentId from EnrollFee where acadYear='$wKey' and studentYear='$xKey' and semester='$yKey' and programId='$zKey' group by studentId");
}*/

function RSEnrollFeeByAcYAndStYAndSeAndPgIdAndNoPay($wKey, $xKey, $yKey, $zKey){
	$this->SetQuery("select studentId from EnrollFee where acadYear='$wKey' and studentYear='$xKey' and semester='$yKey' and programId='$zKey' and balance=totalAmount group by studentId");
}

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

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

function GetSumBlByStIdAndAcYAndStYAndSeAndNoPay($wKey, $xKey, $yKey, $zKey){
	$this->SetQuery("select sum(balance) as num from EnrollFee where studentId='$wKey' and acadYear='$xKey' and studentYear='$yKey' and semester='$zKey' and balance=totalAmount");
	if ($result=$this->GetResult()) {
		return $result['num'];
	}
}

function GetSumBlByStIdAndAcYAndStYAndSeAndTimePay($wKey, $xKey, $yKey, $zKey){
	$this->SetQuery("select sum(balance) as num from EnrollFee where studentId='$wKey' and acadYear='$xKey' and studentYear='$yKey' and semester='$zKey' and balance>0 and balance<totalAmount");
	if ($result=$this->GetResult()) {
		return $result['num'];
	}
}

function GetSumTtAmtByAcYAndStYAndSeAndPgId($wKey, $xKey, $yKey, $zKey){
	$this->SetQuery("select sum(totalAmount) as num from EnrollFee where acadYear='$wKey' and studentYear='$xKey' and semester='$yKey' and programId='$zKey'");
	if ($result=$this->GetResult()) {
		return $result['num'];
	}
}

function GetSumTtAmtByAcYAndSeAndPgIdAndAdYAndPay($wKey, $xKey, $yKey, $zKey){
	$this->SetQuery("select sum(totalAmount) as num from EnrollFee e, StudentMaster s where acadYear='$wKey' and semester='$xKey' and e.programId='$yKey' and balance=0 and e.studentId=s.studentId and admitAcadYear='$zKey'");
	if ($result=$this->GetResult()) {
		return $result['num'];
	}
}

function GetSumTtAmtByAcYAndSeAndPay($xKey, $yKey){
	$this->SetQuery("select sum(totalAmount) as num from EnrollFee where acadYear='$xKey' and semester='$yKey' and balance=0");
	if ($result=$this->GetResult()) {
		return $result['num'];
	}
}

function GetSumBlByAcYAndStYAndSeAndPgId($wKey, $xKey, $yKey, $zKey){
	$this->SetQuery("select sum(balance) as num from EnrollFee where acadYear='$wKey' and studentYear='$xKey' and semester='$yKey' and programId='$zKey'");
	if ($result=$this->GetResult()) {
		return $result['num'];
	}
}

function GetSumBlByAcYAndStYAndSeAndPgIdAndNoPay($wKey, $xKey, $yKey, $zKey){
	$this->SetQuery("select sum(balance) as num from EnrollFee where acadYear='$wKey' and studentYear='$xKey' and semester='$yKey' and programId='$zKey' and balance=totalAmount");
	if ($result=$this->GetResult()) {
		return $result['num'];
	}
}

function GetSumBlByAcYAndStYAndSeAndPgIdAndTimePay($wKey, $xKey, $yKey, $zKey){
	$this->SetQuery("select sum(balance) as num from EnrollFee where acadYear='$wKey' and studentYear='$xKey' and semester='$yKey' and programId='$zKey' and balance>0 and balance<totalAmount");
	if ($result=$this->GetResult()) {
		return $result['num'];
	}
}

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

function CalFee($stId, $acY, $stY, $se, $pgId, $etId){
	include_once "clsCommonFeeTP.php";
	include_once "clsCommonFee.php";
	include_once "clsFee.php";
	include_once "clsProgramFeeTP.php";
	include_once "clsProgramFee.php";
	include_once "clsStudentDom.php";
	include_once "clsDomFeeTP.php";
	include_once "clsCourseFeeTP.php";
	include_once "clsCourseFee.php";
	include_once "clsEnrollItem.php";
	
	$oCft = new CommonFeeTP();
	$oCf = new CommonFee();
	$oCf2 = new CommonFee();
	$oFe = new Fee();
	$oPft = new ProgramFeeTP();
	$oPf = new ProgramFee();
	$oPf2 = new ProgramFee();
	$oSd = new StudentDom();
	$oDft = new DomFeeTP();
	$oCoft = new CourseFeeTP();
	$oCof = new CourseFee();
	$oEi = new EnrollItem();
	
	/*$this->RSEnrollFeeByStIdAndAcYAndSe($stId, $acY, $se);
	// Not found
	if($this->GetRecord() == 0) {
		// Insert EnrollFee
		$this->AddNew();
		$this->enrollFeeId=$this->GetNextCode();
		$this->studentId=$stId;
		$this->acadYear=$acY;
		$this->studentYear=$stY;
		$this->semester=$se;
		$this->programId=$pgId;
		$this->totalAmount=$totalAmount;
		$this->balance=$balance;
		$this->refNo=$acY.$se.$stCode;
		$this->createDateTime=date('Y-m-d H:i:s');
		$this->createUserId=$createUserId;
		$this->updateDateTime=date('Y-m-d H:i:s');
		$this->updateUserId=$updateUserId;
		$this->Save();
	}*/
	
	// ---------- CommonFee ----------
	$oCf->RSCommonFeeByStIdAndAcYAndSe($stId, $acY, $se);
	while($oCf->GetRecord()) {
		$oCf2->SearchByKey($stId, $acY, $se, $oCf->feeId);
		$oCf2->GetRecord();
		$oCf2->Delete();
	}
	
	$sumCommonFee = 0;
	$oCft->RSCommonFeeTPByAcYAndSeAndIsNotDom($acY, $se);
	while($oCft->GetRecord()) {
		$oFe->SearchByKey($oCft->feeId);
		$oFe->GetRecord();
		if(($oFe->feePayType==1 && $stY==1) || $oFe->feePayType!=1) {
			$oCf->SearchByKey($stId, $acY, $se, $oCft->feeId);
			// Not found
			if($oCf->GetRecord() == 0) {
				// Insert CommonFee
				$oCf->AddNew();
				$oCf->studentId=$stId;
				$oCf->acadYear=$acY;
				$oCf->semester=$se;
				$oCf->feeId=$oCft->feeId;
				$oCf->amount=$oCft->amount;
				$oCf->Save();
			}
		}
	}
	$sumCommonFee = $oCf->GetSumAmountByStIdAndAcYAndSe($stId, $acY, $se);
	
	// ---------- ProgramFee ----------
	$oPf->RSProgramFeeByStIdAndAcYAndSe($stId, $acY, $se);
	while($oPf->GetRecord()) {
		$oPf2->SearchByKey($stId, $acY, $se, $oPf->feeId);
		$oPf2->GetRecord();
		$oPf2->Delete();
	}
	
	$sumProgramFee = 0;
	$oPft->RSProgramFeeTPByPgIdAndAcYAndSe($pgId, $acY, $se);
	while($oPft->GetRecord()) {
		$oFe->SearchByKey($oPft->feeId);
		$oFe->GetRecord();
		if(($oFe->feePayType==1 && $stY==1) || $oFe->feePayType!=1) {
			if(($oFe->onTop=='Y' && $etId==2) || $oFe->onTop=='N') {
				$oPf->SearchByKey($stId, $acY, $se, $oPft->feeId);
				// Not found
				if($oPf->GetRecord() == 0) {
					// Insert ProgramFee
					$oPf->AddNew();
					$oPf->studentId=$stId;
					$oPf->acadYear=$acY;
					$oPf->semester=$se;
					$oPf->feeId=$oPft->feeId;
					$oPf->amount=$oPft->amount;
					$oPf->Save();
				}
			}
		}
	}
	$sumProgramFee = $oPf->GetSumAmountByStIdAndAcYAndSe($stId, $acY, $se);
	
	// ---------- DomFee ----------
	$domFee = 0;
	$oCft->RSCommonFeeTPByAcYAndSeAndIsDom($acY, $se);
	if($oCft->GetRecord()) {
		$oSd->SearchByKey($stId, $acY, $se);
		// Student stay dom
		if($oSd->GetRecord()) {
			$oDft->SearchByKey($acY, $se, $oSd->domId);
			// Found dom fee
			if($oDft->GetRecord()) {
				$oCf->SearchByKey($stId, $acY, $se, $oCft->feeId);
				// Not found
				if($oCf->GetRecord() == 0) {
					// Insert CommonFee
					$oCf->AddNew();
					$oCf->studentId=$stId;
					$oCf->acadYear=$acY;
					$oCf->semester=$se;
					$oCf->feeId=$oCft->feeId;
					$oCf->amount=$oSd->monthAmount * $oDft->domFee;
					$oCf->Save();
					$domFee = $oCf->amount;
				}
			}
		}
	}
	
	// ---------- CourseFee ----------
	$sumCourseFee = 0;
	$oCoft->SearchByKey($pgId, $acY, $se);
	if($oCoft->GetRecord()) {
		$oCof->SearchByKey($stId, $acY, $se, $this->enrollFeeId);
		// Found
		if($oCof->GetRecord()) {
			// Update CourseFee
			$oCof->Edit();
			$oCof->lcFee=$oEi->GetSumCr1ByStIdAndAcYAndSe($stId, $acY, $se) * $oCoft->lcCreditFee;
			$oCof->lbFee=$oEi->GetSumCr2ByStIdAndAcYAndSe($stId, $acY, $se) * $oCoft->lbCreditFee;
			$oCof->Save();
		}
		// Not Found
		else {
			// Insert CourseFee
			$oCof->AddNew();
			$oCof->studentId=$stId;
			$oCof->acadYear=$acY;
			$oCof->semester=$se;
			$oCof->enrollFeeId=$this->enrollFeeId;
			$oCof->lcFee=$oEi->GetSumCr1ByStIdAndAcYAndSe($stId, $acY, $se) * $oCoft->lcCreditFee;
			$oCof->lbFee=$oEi->GetSumCr2ByStIdAndAcYAndSe($stId, $acY, $se) * $oCoft->lbCreditFee;
			$oCof->lateFine=$lateFine;
			$oCof->kssFee=$kssFee;
			$oCof->Save();
		}
		$sumCourseFee = $oCof->lcFee + $oCof->lbFee;
	}
	
	/*$this->SearchByKey($this->enrollFeeId);
	$this->GetRecord();
	$this->Edit();
	$this->totalAmount=$sumCommonFee + $sumProgramFee + $domFee + $sumCourseFee;
	$this->balance=$sumCommonFee + $sumProgramFee + $domFee + $sumCourseFee;
	$this->updateDateTime=date('Y-m-d H:i:s');
	$this->updateUserId=$updateUserId;
	$this->Save();*/
	
	return $sumCommonFee+$sumProgramFee+$domFee+$sumCourseFee;
}

function CalFeeAndKSSFee($stId, $acY, $stY, $se, $pgId, $etId){
	include_once "clsCommonFeeTP.php";
	include_once "clsCommonFee.php";
	include_once "clsFee.php";
	include_once "clsProgramFeeTP.php";
	include_once "clsProgramFee.php";
	include_once "clsStudentDom.php";
	include_once "clsDomFeeTP.php";
	include_once "clsCourseFeeTP.php";
	include_once "clsCourseFee.php";
	include_once "clsEnrollItem.php";
	
	$oCft = new CommonFeeTP();
	$oCf = new CommonFee();
	$oCf2 = new CommonFee();
	$oFe = new Fee();
	$oPft = new ProgramFeeTP();
	$oPf = new ProgramFee();
	$oPf2 = new ProgramFee();
	$oSd = new StudentDom();
	$oDft = new DomFeeTP();
	$oCoft = new CourseFeeTP();
	$oCof = new CourseFee();
	$oEi = new EnrollItem();
	
	/*$this->RSEnrollFeeByStIdAndAcYAndSe($stId, $acY, $se);
	// Not found
	if($this->GetRecord() == 0) {
		// Insert EnrollFee
		$this->AddNew();
		$this->enrollFeeId=$this->GetNextCode();
		$this->studentId=$stId;
		$this->acadYear=$acY;
		$this->studentYear=$stY;
		$this->semester=$se;
		$this->programId=$pgId;
		$this->totalAmount=$totalAmount;
		$this->balance=$balance;
		$this->refNo=$acY.$se.$stCode;
		$this->createDateTime=date('Y-m-d H:i:s');
		$this->createUserId=$createUserId;
		$this->updateDateTime=date('Y-m-d H:i:s');
		$this->updateUserId=$updateUserId;
		$this->Save();
	}*/
	
	// ---------- CommonFee ----------
	$oCf->RSCommonFeeByStIdAndAcYAndSe($stId, $acY, $se);
	while($oCf->GetRecord()) {
		$oCf2->SearchByKey($stId, $acY, $se, $oCf->feeId);
		$oCf2->GetRecord();
		$oCf2->Delete();
	}
	
	$sumCommonFee = 0;
	$oCft->RSCommonFeeTPByAcYAndSeAndIsNotDom($acY, $se);
	while($oCft->GetRecord()) {
		$oFe->SearchByKey($oCft->feeId);
		$oFe->GetRecord();
		if(($oFe->feePayType==1 && $stY==1) || $oFe->feePayType!=1) {
			$oCf->SearchByKey($stId, $acY, $se, $oCft->feeId);
			// Not found
			if($oCf->GetRecord() == 0) {
				// Insert CommonFee
				$oCf->AddNew();
				$oCf->studentId=$stId;
				$oCf->acadYear=$acY;
				$oCf->semester=$se;
				$oCf->feeId=$oCft->feeId;
				$oCf->amount=$oCft->amount;
				$oCf->Save();
			}
		}
	}
	$sumCommonFee = $oCf->GetSumAmountByStIdAndAcYAndSe($stId, $acY, $se);
	
	// ---------- ProgramFee ----------
	$oPf->RSProgramFeeByStIdAndAcYAndSe($stId, $acY, $se);
	while($oPf->GetRecord()) {
		$oPf2->SearchByKey($stId, $acY, $se, $oPf->feeId);
		$oPf2->GetRecord();
		$oPf2->Delete();
	}
	
	$sumProgramFee = 0;
	$oPft->RSProgramFeeTPByPgIdAndAcYAndSe($pgId, $acY, $se);
	while($oPft->GetRecord()) {
		$oFe->SearchByKey($oPft->feeId);
		$oFe->GetRecord();
		if(($oFe->feePayType==1 && $stY==1) || $oFe->feePayType!=1) {
			if(($oFe->onTop=='Y' && $etId==2) || $oFe->onTop=='N') {
				$oPf->SearchByKey($stId, $acY, $se, $oPft->feeId);
				// Not found
				if($oPf->GetRecord() == 0) {
					// Insert ProgramFee
					$oPf->AddNew();
					$oPf->studentId=$stId;
					$oPf->acadYear=$acY;
					$oPf->semester=$se;
					$oPf->feeId=$oPft->feeId;
					$oPf->amount=$oPft->amount;
					$oPf->Save();
				}
			}
		}
	}
	$sumProgramFee = $oPf->GetSumAmountByStIdAndAcYAndSe($stId, $acY, $se);
	
	// ---------- DomFee ----------
	$domFee = 0;
	$oCft->RSCommonFeeTPByAcYAndSeAndIsDom($acY, $se);
	if($oCft->GetRecord()) {
		$oSd->SearchByKey($stId, $acY, $se);
		// Student stay dom
		if($oSd->GetRecord()) {
			$oDft->SearchByKey($acY, $se, $oSd->domId);
			// Found dom fee
			if($oDft->GetRecord()) {
				$oCf->SearchByKey($stId, $acY, $se, $oCft->feeId);
				// Not found
				if($oCf->GetRecord() == 0) {
					// Insert CommonFee
					$oCf->AddNew();
					$oCf->studentId=$stId;
					$oCf->acadYear=$acY;
					$oCf->semester=$se;
					$oCf->feeId=$oCft->feeId;
					$oCf->amount=$oSd->monthAmount * $oDft->domFee;
					$oCf->Save();
					$domFee = $oCf->amount;
				}
			}
		}
	}
	
	// ---------- CourseFee ----------
	$sumCourseFee = 0;
	$oCoft->SearchByKey($pgId, $acY, $se);
	if($oCoft->GetRecord()) {
		$oCof->SearchByKey($stId, $acY, $se, $this->enrollFeeId);
		// Found
		if($oCof->GetRecord()) {
			// Update CourseFee
			$oCof->Edit();
			$oCof->lcFee=$oEi->GetSumCr1ByStIdAndAcYAndSe($stId, $acY, $se) * $oCoft->lcCreditFee;
			$oCof->lbFee=$oEi->GetSumCr2ByStIdAndAcYAndSe($stId, $acY, $se) * $oCoft->lbCreditFee;
			$oCof->kssFee=$oCoft->kssFee;
			$oCof->Save();
		}
		// Not Found
		else {
			// Insert CourseFee
			$oCof->AddNew();
			$oCof->studentId=$stId;
			$oCof->acadYear=$acY;
			$oCof->semester=$se;
			$oCof->enrollFeeId=$this->enrollFeeId;
			$oCof->lcFee=$oEi->GetSumCr1ByStIdAndAcYAndSe($stId, $acY, $se) * $oCoft->lcCreditFee;
			$oCof->lbFee=$oEi->GetSumCr2ByStIdAndAcYAndSe($stId, $acY, $se) * $oCoft->lbCreditFee;
			$oCof->lateFine=$lateFine;
			$oCof->kssFee=$oCoft->kssFee;
			$oCof->Save();
		}
		$sumCourseFee = $oCof->lcFee + $oCof->lbFee + $oCof->kssFee;
	}
	
	/*$this->SearchByKey($this->enrollFeeId);
	$this->GetRecord();
	$this->Edit();
	$this->totalAmount=$sumCommonFee + $sumProgramFee + $domFee + $sumCourseFee;
	$this->balance=$sumCommonFee + $sumProgramFee + $domFee + $sumCourseFee;
	$this->updateDateTime=date('Y-m-d H:i:s');
	$this->updateUserId=$updateUserId;
	$this->Save();*/
	
	return $sumCommonFee+$sumProgramFee+$domFee+$sumCourseFee;
}

function CalKSSFee($stId, $acY, $se, $pgId){
	include_once "clsCourseFeeTP.php";
	include_once "clsCourseFee.php";
	include_once "clsEnrollItem.php";
	
	$oCoft = new CourseFeeTP();
	$oCof = new CourseFee();
	$oEi = new EnrollItem();
	
	/*$this->RSEnrollFeeByStIdAndAcYAndSe($stId, $acY, $se);
	// Not found
	if($this->GetRecord() == 0) {
		// Insert EnrollFee
		$this->AddNew();
		$this->enrollFeeId=$this->GetNextCode();
		$this->studentId=$stId;
		$this->acadYear=$acY;
		$this->studentYear=$stY;
		$this->semester=$se;
		$this->programId=$pgId;
		$this->totalAmount=$totalAmount;
		$this->balance=$balance;
		$this->refNo=$acY.$se.$stCode;
		$this->createDateTime=date('Y-m-d H:i:s');
		$this->createUserId=$createUserId;
		$this->updateDateTime=date('Y-m-d H:i:s');
		$this->updateUserId=$updateUserId;
		$this->Save();
	}*/
	
	// ---------- CourseFee ----------
	$sumCourseFee = 0;
	$oCoft->SearchByKey($pgId, $acY, $se);
	$oCoft->GetRecord();
	// Insert CourseFee
	$oCof->AddNew();
	$oCof->studentId=$stId;
	$oCof->acadYear=$acY;
	$oCof->semester=$se;
	$oCof->enrollFeeId=$this->enrollFeeId;
	$oCof->lcFee=$oEi->GetSumCr1ByStIdAndAcYAndSe($stId, $acY, $se) * $oCoft->lcCreditFee;
	$oCof->lbFee=$oEi->GetSumCr2ByStIdAndAcYAndSe($stId, $acY, $se) * $oCoft->lbCreditFee;
	$oCof->lateFine=$lateFine;
	$oCof->kssFee=$oCoft->kssFee;
	$oCof->Save();
		
	$sumCourseFee = $oCof->kssFee;
	
	/*$this->SearchByKey($this->enrollFeeId);
	$this->GetRecord();
	$this->Edit();
	$this->totalAmount=$sumCommonFee + $sumProgramFee + $domFee + $sumCourseFee;
	$this->balance=$sumCommonFee + $sumProgramFee + $domFee + $sumCourseFee;
	$this->updateDateTime=date('Y-m-d H:i:s');
	$this->updateUserId=$updateUserId;
	$this->Save();*/
	
	return $sumCourseFee;
}

function RSEnrollFeeByPayDateAndBlIs0GroupEfId($xKey, $yKey){
	$this->SetQuery("select EnrollFee.enrollFeeId from EnrollFee, Payment where payDate between '$xKey' and '$yKey' and balance=0 and EnrollFee.enrollFeeId=Payment.enrollFeeId group by Payment.enrollFeeId");
}

//--Use on page paymentEnroll.php--
function GetSumBlByStId($xKey){
	$this->SetQuery("select sum(balance) as num from EnrollFee where studentId='$xKey'");
	if ($result=$this->GetResult()) {
		return $result['num'];
	}	
}

function RSEnrollFeeByStIdAndBl($xKey){
	$this->SetQuery("select * from EnrollFee where studentId='$xKey' and balance!=0");	
}

function RSEnrollFeeByStId($xKey){
	$this->SetQuery("select * from EnrollFee where studentId='$xKey'");	
}

function RSEnrollFeeByReNo($ReNo){
	if($this->SetQuery("select * from EnrollFee where refNo='$ReNo' and balance!=0")){
		return 1;
	}else {
		return 0;
	}		
}

function RSEnrollFeeByReNo2($ReNo){
	if($this->SetQuery("select * from EnrollFee where refNo='$ReNo'")){
		return 1;
	}else {
		return 0;
	}		
}

function RSEnrollFeeByPM($PM){
	if($this->SetQuery("select * from EnrollFee where balance>='$PM' and balance!=0")){
		return 1;
	}else {
		return 0;
	}		
}
//--The end--

} //--End class EnrollFee--
?>