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