Viewing file:  clsRealStudyPlan.php (3.13 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
//--Class RealStudyPlan--------------------------
include_once "clsbase_RealStudyPlan.php";
class RealStudyPlan extends base_RealStudyPlan {
function RSRealStudyPlanByPgIdAndStYAndSe($xKey, $yKey, $zKey){
$this->SetQuery("select * from RealStudyPlan where programId='$xKey' and studentYear='$yKey' and semester='$zKey'");
}
function RSRealStudyPlanByPgIdAndStYAndSeAndAdY($wKey, $xKey, $yKey, $zKey){
$this->SetQuery("select * from RealStudyPlan where programId='$wKey' and studentYear='$xKey' and semester='$yKey' and admitAcadYear='$zKey'");
}
function RSRealStudyPlanByPgIdAndStYAndSeAndAdYAndCdId($vKey, $wKey, $xKey, $yKey, $zKey){
$this->SetQuery("select * from RealStudyPlan where programId='$vKey' and studentYear='$wKey' and semester='$xKey' and admitAcadYear='$yKey' and conditionId='$zKey'");
}
function RSRealStudyPlanByAll($vKey, $wKey, $xKey, $yKey, $zKey){
$this->SetQuery("select * from RealStudyPlan where programId='$vKey' and studentYear='$wKey' and semester='$xKey' and classId='$yKey' and admitAcadYear='$zKey'");
}
function RSRealStudyPlanByPgIdAndAdYGroupStY($xKey, $yKey){
$this->SetQuery("select studentYear from RealStudyPlan where programId='$xKey' and admitAcadYear='$yKey' group by studentYear");
}
function RSRealStudyPlanByPgIdAndAdYAndStYGroupSe($xKey, $yKey, $zKey){
$this->SetQuery("select semester from RealStudyPlan where programId='$xKey' and admitAcadYear='$yKey' and studentYear='$zKey' group by semester");
}
function RSRealStudyPlanByPgIdAndAdYAndStYAndSe($wKey, $xKey, $yKey, $zKey){
$this->SetQuery("select * from RealStudyPlan where programId='$wKey' and admitAcadYear='$xKey' and studentYear='$yKey' and semester='$zKey'");
}
function GetSumCreditTotalByPgIdAndStYAndSeAndAdY($wKey, $xKey, $yKey, $zKey){
$this->SetQuery("select sum(creditTotal) as num from RealStudyPlan,Class,Course where RealStudyPlan.programId='$wKey' and RealStudyPlan.studentYear='$xKey' and RealStudyPlan.semester='$yKey' and admitAcadYear='$zKey' and RealStudyPlan.classId=Class.classId and Class.courseId=Course.courseId");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function GetSumCreditTotalByPgIdAndAdY($xKey, $yKey){
$this->SetQuery("select sum(creditTotal) as num from RealStudyPlan,Class,Course where RealStudyPlan.programId='$xKey' and admitAcadYear='$yKey' and RealStudyPlan.classId=Class.classId and Class.courseId=Course.courseId");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function RSRealStudyPlanByPgIdAndStYAndSeAndCoId($wKey, $xKey, $yKey, $zKey){
$this->SetQuery("select * from RealStudyPlan where programId='$wKey' and studentYear='$xKey' and semester='$yKey' and courseId='$zKey'");
}
function RSRealStudyPlanByPgIdAndClId($xKey, $yKey){
$this->SetQuery("select * from RealStudyPlan where programId='$xKey' and classId='$yKey'");
}
/*function RSStudyPlanByPgIdGroupStY($xKey){
$this->SetQuery("select studentYear from StudyPlan where programId='$xKey' group by studentYear");
}
function RSStudyPlanByPgIdAndStYGroupSe($xKey, $yKey){
$this->SetQuery("select semester from StudyPlan where programId='$xKey' and studentYear='$yKey' group by semester");
}*/
} //--End class RealStudyPlan--
?>
|