Viewing file:  clsEnroll.php (1.9 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
//--Class Enroll--------------------------
include_once "clsbase_Enroll.php";
class Enroll extends base_Enroll{
function GetMaxSeByAcYAndStYAndPgId($xKey, $yKey, $zKey){
$this->SetQuery("select max(semester) as num from Enroll where acadYear='$xKey' and studentYear='$yKey' and programId='$zKey'");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function RSEnrollByAcYAndSeAndStYAndPgId($wKey, $xKey, $yKey, $zKey){
$this->SetQuery("select * from Enroll where acadYear='$wKey' and semester='$xKey' and studentYear='$yKey' and programId='$zKey'");
}
function GetNextSeqByStIdAndAcYAndSe($xKey, $yKey, $zKey){
$this->SetQuery("select max(sequence) as num from Enroll where studentId='$xKey' and acadYear='$yKey' and semester='$zKey'");
if ($result=$this->GetResult()) {
return $result['num']+1;
}
}
function RSEnrollByStIdAndAcYAndSe($xKey, $yKey, $zKey){
$this->SetQuery("select * from Enroll where studentId='$xKey' and acadYear='$yKey' and semester='$zKey'");
}
function RSEnrollByStIdAndAcYAndSeAndErStatus($wKey, $xKey, $yKey, $zKey){
$this->SetQuery("select * from Enroll where studentId='$wKey' and acadYear='$xKey' and semester='$yKey' and enrollStatus='$zKey'");
}
function GetMaxAcYByStId($xKey){
$this->SetQuery("select max(acadYear) as num from Enroll where studentId='$xKey'");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function GetMaxSeByStIdAndAcY($xKey, $yKey){
$this->SetQuery("select max(semester) as num from Enroll where studentId='$xKey' and acadYear='$yKey'");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function RSEnrollByStIdGroupAcY($xKey){
$this->SetQuery("select acadYear from Enroll where studentId='$xKey' group by acadYear");
}
function RSEnrollByStIdAndAcYGroupSe($xKey, $yKey){
$this->SetQuery("select semester from Enroll where studentId='$xKey' and acadYear='$yKey' group by semester");
}
} //--End class Enroll--
?>
|