<?php
//--Class StudentStatus--------------------------

include_once "clsbase_StudentStatus.php";

class StudentStatus extends base_StudentStatus {

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

function GetMaxAcadYearByStId($xKey){
	$this->SetQuery("select max(acadYear) as num from StudentStatus where studentId='$xKey'");
	if ($result=$this->GetResult()) {
		return $result['num'];
	}
}

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

function GetMaxAcadYearByPgIdAndAdYAndStY($xKey, $yKey, $zKey){
	$this->SetQuery("select max(acadYear) as num from StudentStatus, StudentMaster where programId='$xKey' and admitAcadYear='$yKey' and studentYear='$zKey' and StudentMaster.studentId=StudentStatus.studentId");
	if ($result=$this->GetResult()) {
		return $result['num'];
	}
}

function GetMaxSemesterByPgIdAndAdYAndStYAndAcY($wKey, $xKey, $yKey, $zKey){
	$this->SetQuery("select max(semester) as num from StudentStatus, StudentMaster where programId='$wKey' and admitAcadYear='$xKey' and studentYear='$yKey' and StudentMaster.studentId=StudentStatus.studentId and acadYear='$zKey'");
	if ($result=$this->GetResult()) {
		return $result['num'];
	}
}

function RSStudentStatusGroupByStId($StID){
	$this->SetQuery("select studentId from StudentStatus where studentId='$StID' and studentStatus!='4' group by studentId");
}

function RSStudentStatusGroupByStIdMAcYMSeM($StID,$AcY,$SeM){
//	$this->SetQuery("select max(acadYear) as num1, max(semester) as num2 from StudentStatus where studentId='$StID' and studentStatus!='4' group by studentId");
	$this->SetQuery("select passStatus from StudentStatus where studentId='$StID' and acadYear='$AcY' and semester='$SeM' and studentStatus!='4' group by studentId");
//	$result=$this->GetResult();
//	return $result['num1']."-".$result['num2'];	
}

function GetCountStIdByPgIdAndAdYAndAcYAndSeAndPassStatus($pgId, $adY, $acY, $se, $passStatus){
	$this->SetQuery("select count(s.studentId) as num 
						from StudentStatus s, StudentMaster m 
						where m.programId='$pgId' and m.admitAcadYear='$adY' 
						and m.studentId=s.studentId 
						and s.acadYear='$acY' and s.semester='$se' 
						and s.passStatus='$passStatus' and s.studentStatus!=4 and m.studentStatus!=4");
	if ($result=$this->GetResult()) {
		return $result['num'];
	}	
}

//-- Use on page processChgStudProg.php --
function CountGPAAndGPAXNoZero($AcY, $SeM){
	$this->SetQuery("select count(studentId) as num from StudentStatus where acadYear='$AcY' and semester='$SeM' and GPA!=0 and GPAX!=0  order by studentId");
	$result=$this->GetResult();
	return $result['num'];	
}
//-- The end --

} //--End class StudentStatus--
?>