Software: Apache/2.2.3 (CentOS). PHP/5.1.6 

uname -a: Linux mx-ll-110-164-51-230.static.3bb.co.th 2.6.18-194.el5PAE #1 SMP Fri Apr 2 15:37:44
EDT 2010 i686 

uid=48(apache) gid=48(apache) groups=48(apache) 

Safe-mode: OFF (not secure)

/var/www/html/manage/class/   drwxr-xr-x
Free 52.6 GB of 127.8 GB (41.15%)
                            Encoder    Tools    Proc.    FTP brute    Sec.    SQL    PHP-code    Update    Feedback    Self remove    Logout    

Viewing file:     clsStudentStatus.php (2.82 KB)      -rw-r--r--

<?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--
?>