Viewing file:  clsStudentStatus.php (2.82 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?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--
?>
|