Viewing file: clsClass.php (17.82 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
//--Class Class1--------------------------
include_once "clsbase_Class.php";
class Class1 extends base_Class{
function RSClassLimit($start, $pageSize){
$this->SetQuery("select * from Class order by classId limit $start, $pageSize");
}
function RSClassByPgIdIsNullAndAcYAndSe($xKey, $yKey){
$this->SetQuery("select * from Class where programId is null and acadYear='$xKey' and semester='$yKey'");
}
function RSClassByPgIdAndPgIdIsNullOrderAcYAndStYAndSe($xKey){
$this->SetQuery("select * from Class where section='1' and (programId='$xKey' or programId is null) order by acadYear, studentYear, semester");
}
function RSClassByPgIdAndAcYAndStYAndSeAndCoIdAndEmpty($pgId, $acY, $stY, $se, $coId){
$this->SetQuery("select * from Class
where programId='$pgId' and acadYear='$acY' and studentYear='$stY'
and semester='$se' and courseId='$coId' and enrollSeat<totalSeat
order by classId");
}
function RSClassByPgIdIsNullAndAcYAndStYAndSeAndCoIdAndEmptyOpenFor($acY, $stY, $se, $coId, $pgId){
$this->SetQuery("select c.* from Class c, ClassOpenFor f
where c.programId is null and c.acadYear='$acY' and c.studentYear='$stY'
and c.semester='$se' and c.courseId='$coId' and c.enrollSeat<c.totalSeat
and c.classId=f.classId and f.programId='$pgId' and f.erSeat<f.bookSeat
order by c.classId");
}
function RSClassByPgIdAndStYAndSeAndAcY($wKey, $xKey, $yKey, $zKey){
$this->SetQuery("select * from Class where programId='$wKey' and studentYear='$xKey' and semester='$yKey' and acadYear='$zKey'");
}
function RSClassByPgIdAndStYAndSeAndAcYNULL($wKey, $xKey, $yKey, $zKey){
$this->SetQuery("select * from Class where programId is null and studentYear='$xKey' and semester='$yKey' and acadYear='$zKey'");
}
function RSClassByPgIdAndStYAndSeAndAcYAndCdIdAndSection($vKey, $wKey, $xKey, $yKey, $zKey){
$this->SetQuery("select * from Class where programId='$vKey' and studentYear='$wKey' and semester='$xKey' and acadYear='$yKey' and conditionId='$zKey' and section='1'");
}
function RSClassByPgIdAndStYAndSeAndAcYAndEmpty($wKey, $xKey, $yKey, $zKey){
$this->SetQuery("select * from Class where programId='$wKey' and studentYear='$xKey' and semester='$yKey' and acadYear='$zKey' and enrollSeat<totalSeat");
}
function RSClassByPgIdIsNullAndAcYAndStYAndSeAndCdIdOpenFor($acY, $stY, $se, $cdId, $pgId){
$this->SetQuery("select c.courseId, c.conditionId2, min(c.classId) as classId
from Class c, ClassOpenFor f
where c.programId is null and c.acadYear='$acY' and c.studentYear='$stY'
and c.semester='$se' and c.conditionId='$cdId' and c.classId=f.classId
and f.programId='$pgId' group by c.courseId, c.conditionId2");
}
function RSClassByStYAndSeAndAcYAndPgIdIsNullAndEmpty($xKey, $yKey, $zKey){
$this->SetQuery("select * from Class where studentYear='$xKey' and semester='$yKey' and acadYear='$zKey' and programId is null and enrollSeat<totalSeat");
}
function RSClassByPgIdAndStYAndSeAndCoIdAndAcY($vKey, $wKey, $xKey, $yKey, $zKey){
$sql = "select * from Class
where programId='$vKey' and studentYear='$wKey' and semester='$xKey'
and courseId='$yKey' and acadYear='$zKey' and section='1'";
$this->SetQuery($sql);
}
function RSClassByClIdAndEmpty($xKey){
$this->SetQuery("select * from Class where classId='$xKey' and enrollSeat<totalSeat");
}
function RSClassByClIdAndPgIdAndEmptyOpenFor($clId, $pgId){
$this->SetQuery("select c.* from Class c, ClassOpenFor f
where c.programId is null and c.classId='$clId' and c.enrollSeat<c.totalSeat
and c.classId=f.classId and f.programId='$pgId' and f.erSeat<f.bookSeat");
}
function RSClassByAcYAndStYAndSeAndCoId($wKey, $xKey, $yKey, $zKey){
$this->SetQuery("select * from Class where acadYear='$wKey' and studentYear='$xKey' and semester='$yKey' and courseId='$zKey' and section='1'");
}
function RSClassByAcYAndStYAndSeAndCoIdAndNoPgId($wKey, $xKey, $yKey, $zKey){
$this->SetQuery("select * from Class where acadYear='$wKey' and studentYear='$xKey' and semester='$yKey' and courseId='$zKey'");
}
function RSClassByPgIdIsNullAndAcYAndStYAndSeAndCoId($wKey, $xKey, $yKey, $zKey){
$this->SetQuery("select * from Class where programId is null and acadYear='$wKey' and studentYear='$xKey' and semester='$yKey' and courseId='$zKey'");
}
function RSClassByPgIdIsNullAndAcYAndStYAndSeOpenFor($acY, $stY, $se, $pgId){
$this->SetQuery("select c.* from Class c, ClassOpenFor f
where c.programId is null and c.acadYear='$acY' and c.studentYear='$stY'
and c.semester='$se' and c.classId=f.classId and f.programId='$pgId'");
}
function RSClassByPgIdIsNullAndAcYAndStYAndSeAndCoIdOpenFor($acY, $stY, $se, $coId, $pgId){
$this->SetQuery("select c.* from Class c, ClassOpenFor f
where c.programId is null and c.acadYear='$acY' and c.studentYear='$stY'
and c.semester='$se' and c.courseId='$coId' and c.classId=f.classId
and f.programId='$pgId' order by c.section");
}
function RSClassByRealSPId($xKey){
$this->SetQuery("select * from Class where realStudyPlanId='$xKey'");
}
function RSClassByPgIdAndCoId($xKey, $yKey){
$this->SetQuery("select courseId from Class where programId='$xKey' and courseId='$yKey' order by classId");
}
function SearchByKeyPgIdAndCoIdAndStudy($pgId, $coId, $stY, $se, $acY){
if($this->SetQuery("select * from Class where programId='$pgId' and acadYear='$acY' and studentYear='$stY' and semester='$se' and courseId='$coId' order by classId")){
return 1;
}else {
return 0;
}
}
function RSClassMaxSection($xKey, $yKey, $zKey, $sKey, $aKey){
$this->SetQuery("select max(cast(section as signed)) as num from Class
where programId='$xKey' and courseId='$yKey' and studentYear='$zKey'
and semester='$sKey' and acadYear='$aKey'
order by classId");
$result=$this->GetResult();
return $result['num'];
}
function RSClassMaxSectionNULL($xKey, $yKey, $zKey, $sKey, $aKey){
$this->SetQuery("select max(cast(section as signed)) as num from Class
where programId is null and courseId='$yKey' and studentYear='$zKey'
and semester='$sKey' and acadYear='$aKey'
order by classId");
$result=$this->GetResult();
return $result['num'];
}
function RSClassSumTotalSeat($xKey, $yKey, $zKey, $sKey, $aKey, $StY){
$this->SetQuery("select sum(totalSeat) as num from Class where programId='$xKey' and courseId='$yKey' and studentYear='$zKey' and semester='$sKey' and acadYear='$aKey' and studentYear='$StY' order by classId");
$result=$this->GetResult();
return $result['num'];
}
function RSClassSumTotalSeatNULL($xKey, $yKey, $zKey, $sKey, $aKey, $StY){
$this->SetQuery("select sum(totalSeat) as num from Class where programId is null and courseId='$yKey' and studentYear='$zKey' and semester='$sKey' and acadYear='$aKey' and studentYear='$StY' order by classId");
$result=$this->GetResult();
return $result['num'];
}
function RSClassByCourseId($cKey){
$this->SetQuery("select * from Class where courseId='$cKey' and sendGradeStatus='N' order by classId");
}
function RSClassByCourseIdY($cKey){
$this->SetQuery("select * from Class where courseId='$cKey' and sendGradeStatus='Y' order by classId");
}
function RSClassByCoIdAndAcYSeM($xKey, $yKey, $zKey){
$this->SetQuery("select * from Class where courseId='$xKey' and acadYear='$yKey' and semester='$zKey'");
}
function RSClassByCoCodeAndAcYAndSeAndSection($wKey, $xKey, $yKey, $zKey){
$this->SetQuery("select * from Class cl, Course co
where co.courseCode like '%$wKey%' and co.courseId=cl.courseId
and cl.acadYear='$xKey' and cl.semester='$yKey' and cl.section='$zKey'
order by cl.programId, co.courseCode, co.courseName");
}
function GetSumCrAtByPgIdAndAcYAndSeAndAdY($pgId, $acY, $se, $adY){
$sql = "select sum(e.creditAttempt) as num from Class c, EnrollItem e, StudentMaster s
where c.programId='$pgId' and c.acadYear='$acY' and c.semester='$se'
and c.classId=e.classId and e.studentId=s.studentId and c.programId=s.programId
and s.admitAcadYear='$adY'";
$this->SetQuery($sql);
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function GetSumCrAtByPgIdIsNullAndAcYAndSeAndAdYOpenFor($pgId, $acY, $se, $adY){
$sql = "select sum(e.creditAttempt) as num from Class c, ClassOpenFor f, EnrollItem e, StudentMaster s
where c.programId is null and c.acadYear='$acY' and c.semester='$se'
and c.classId=f.classId and f.programId='$pgId'
and c.classId=e.classId and e.studentId=s.studentId and f.programId=s.programId
and s.admitAcadYear='$adY'";
$this->SetQuery($sql);
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function GetSumCrAtByPgIdAndAcYAndAdY($pgId, $acY, $adY){
$sql = "select sum(e.creditAttempt) as num from Class c, EnrollItem e, StudentMaster s
where c.programId='$pgId' and c.acadYear='$acY'
and c.classId=e.classId and e.studentId=s.studentId and c.programId=s.programId and s.admitAcadYear='$adY'";
$this->SetQuery($sql);
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function GetSumCrAtByPgIdIsNullAndAcYAndAdYOpenFor($pgId, $acY, $adY){
$sql = "select sum(e.creditAttempt) as num from Class c, ClassOpenFor f, EnrollItem e, StudentMaster s
where c.programId is null and c.acadYear='$acY'
and c.classId=f.classId and f.programId='$pgId'
and c.classId=e.classId and e.studentId=s.studentId and f.programId=s.programId and s.admitAcadYear='$adY'";
$this->SetQuery($sql);
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function RSClassByAcYAndSeAndDayGroupPgId($acY, $se, $wDay){
$sql = "select c.programId from Class c, ClassTimeTable t
where c.acadYear='$acY' and c.semester='$se' and c.classId=t.classId and t.weekDay='$wDay'
group by c.programId
union
select f.programId from Class c, ClassTimeTable t, ClassOpenFor f
where c.acadYear='$acY' and c.semester='$se' and c.classId=t.classId and t.weekDay='$wDay'
and c.classId=f.classId group by f.programId";
$this->SetQuery($sql);
}
function RSClassByPgIdAndAcYAndSeAndDayGroupStY($pgId, $acY, $se, $wDay){
$sql = "select c.studentYear from Class c, ClassTimeTable t
where c.programId='$pgId' and c.acadYear='$acY' and c.semester='$se' and c.classId=t.classId
and t.weekDay='$wDay' group by c.studentYear
union
select c.studentYear from Class c, ClassTimeTable t, ClassOpenFor f
where c.programId is null and c.acadYear='$acY' and c.semester='$se' and c.classId=t.classId
and t.weekDay='$wDay' and c.classId=f.classId and f.programId='$pgId' group by c.studentYear";
$this->SetQuery($sql);
}
function RSClassByPgIdAndAcYAndStYAndSeAndDayAndBetweenPr($pgId, $acY, $stY, $se, $wDay, $pr){
$sql = "select c.* from Class c, ClassTimeTable t
where c.programId='$pgId' and c.acadYear='$acY' and c.studentYear='$stY' and c.semester='$se'
and c.classId=t.classId and t.weekDay='$wDay' and '$pr' between t.timeSlotStart and t.timeSlotEnd
union
select c.* from Class c, ClassTimeTable t, ClassOpenFor f
where c.programId is null and c.acadYear='$acY' and c.studentYear='$stY' and c.semester='$se'
and c.classId=t.classId and t.weekDay='$wDay' and '$pr' between t.timeSlotStart and t.timeSlotEnd
and c.classId=f.classId and f.programId='$pgId'";
$this->SetQuery($sql);
}
function RSClassByPgIdAndAcYAndStYGroupSe($pgId, $acY, $stY){
$sql = "select c.semester from Class c
where c.programId='$pgId' and c.acadYear='$acY' and c.studentYear='$stY'
group by c.semester
union
select c.semester from Class c, ClassOpenFor f
where c.programId is null and c.acadYear='$acY' and c.studentYear='$stY'
and c.classId=f.classId and f.programId='$pgId'
group by c.semester";
$this->SetQuery($sql);
}
function RSClassByPgIdAndAcYAndStYAndSeAndErSeat($pgId, $acY, $stY, $se){
$sql = "select c.courseId from Class c
where c.programId='$pgId' and c.acadYear='$acY' and c.studentYear='$stY'
and c.semester='$se' and c.enrollSeat>0
group by c.courseId
union
select c.courseId from Class c, ClassOpenFor f
where c.programId is null and c.acadYear='$acY' and c.studentYear='$stY'
and c.semester='$se' and c.enrollSeat>0
and c.classId=f.classId and f.programId='$pgId'
group by c.courseId";
$this->SetQuery($sql);
}
function RSClassByPgIdAndAcYAndStYAndSeAndShowLabTS($pgId, $acY, $stY, $se){
$sql = "select cl.* from Class cl, Course co
where cl.programId='$pgId' and cl.acadYear='$acY' and cl.studentYear='$stY' and cl.semester='$se'
and cl.courseId=co.courseId and co.showLabTS='Y'
union
select cl.* from Class cl, Course co, ClassOpenFor f
where cl.programId is null and cl.acadYear='$acY' and cl.studentYear='$stY' and cl.semester='$se'
and cl.classId=f.classId and f.programId='$pgId'
and cl.courseId=co.courseId and co.showLabTS='Y'";
$this->SetQuery($sql);
}
function RSClassByPgIdAndAcYAndStYAndSeAndCoCodeAndCoNameAndCoNameE($pgId, $acY, $stY, $se, $coCode, $coName, $coNameE){
$sql = "select cl.* from Class cl, Course co
where cl.courseId=co.courseId".$pgId.$acY.$stY.$se." and co.courseCode like '%$coCode%'
and co.courseName like '%$coName%' and co.courseNameEng like '%$coNameE%'";
$this->SetQuery($sql);
}
function RSClassGroupAcY(){
$sql = "select coAcY from rg_CourseOpen group by coAcY";
$this->SetQuery($sql);
}
function RSClassByPgIdIsNullAndAcYAndStYAndSeAndSecClIsNot1GroupCoId($acY, $stY, $se){
$this->SetQuery("select courseId from Class where programId is null and acadYear='$acY' and studentYear='$stY' and semester='$se' and sectionClass>1 group by courseId");
}
function RSClassByPgIdAndAcYAndStYAndSeAndSecClIsNot1GroupCoId($pgId, $acY, $stY, $se){
$this->SetQuery("select courseId from Class where programId='$pgId' and acadYear='$acY' and studentYear='$stY' and semester='$se' and sectionClass>1 group by courseId");
}
// ***** Start TIMETABLE *****
function RSClassByStIdAndClIdAndEmpty($stId, $clId){
$this->SetQuery("select * from rg_CourseOpenStudent s, rg_CourseOpen c
where cosStdId='$stId' and cosCoId='$clId' and s.cosCoId=c.coId and coNumSeatReg<coNumSeatOpen");
}
function RSClassByPgIdIsNullAndAcYAndStYAndSeGroupCoIdOrderCoCodeCoName($acY, $stY, $se){
$this->SetQuery("select cl.coCrsId from rg_CourseOpen cl, rg_Course co
where cl.coCurId is null and cl.coAcY='$acY' and cl.coSyId='$stY' and cl.coTmId='$se' and cl.coCrsId=co.crsId
group by cl.coCrsId order by co.crsCode, co.crsName");
}
function RSClassByPgIdAndAcYAndStYAndSeGroupCoIdOrderCoCodeCoName($pgId, $acY, $stY, $se){
$this->SetQuery("select cl.coCrsId from rg_CourseOpen cl, rg_Course co
where cl.coCurId='$pgId' and cl.coAcY='$acY' and cl.coSyId='$stY' and cl.coTmId='$se' and cl.coCrsId=co.crsId
group by cl.coCrsId order by co.crsCode, co.crsName");
}
function RSClassByAcYGroupCoIdOrderCoCodeCoName($acY){
$this->SetQuery("select cl.coCrsId from rg_CourseOpen cl, rg_Course co
where cl.coAcY='$acY' and cl.coCrsId=co.crsId
group by cl.coCrsId order by co.crsCode, co.crsName");
}
function RSClassByPgIdIsNullAndAcYAndStYAndSeAndCoIdOrderSection($acY, $stY, $se, $coId){
$this->SetQuery("select * from rg_CourseOpen
where coCurId is null and coAcY='$acY' and coSyId='$stY'
and coTmId='$se' and coCrsId='$coId' order by cast(coSection as signed)");
}
function RSClassByPgIdAndAcYAndStYAndSeAndCoIdOrderSection($pgId, $acY, $stY, $se, $coId){
$this->SetQuery("select * from rg_CourseOpen
where coCurId='$pgId' and coAcY='$acY' and coSyId='$stY'
and coTmId='$se' and coCrsId='$coId' order by cast(coSection as signed)");
}
function RSClassByAcYAndCoIdOrderSection($acY, $coId){
$this->SetQuery("select * from rg_CourseOpen where coAcY='$acY' and coCrsId='$coId' order by cast(coSection as signed)");
}
function RSClassByClIdStrAndOfIdIsNull($clIdStr){
$this->SetQuery("select * from rg_CourseOpen where coId in ($clIdStr) and coPrsId is null");
}
function RSClassByClIdStrAndNotOfId($clIdStr, $ofId){
$this->SetQuery("select * from rg_CourseOpen where coId in ($clIdStr) and coPrsId<>'$ofId'");
}
// ***** End TIMETABLE *****
// ***** Start TEACHINGWORKLOAD *****
function RSClassByTTGroupAcY(){
$this->SetQuery("select c.coAcY from rg_TimeTable t, rg_CourseOpen c
where t.ttCoId=c.coId group by c.coAcY");
}
function RSClassByTTGroupSe(){
$this->SetQuery("select c.coTmId from rg_TimeTable t, rg_CourseOpen c
where t.ttCoId=c.coId group by c.coTmId");
}
function RSClassByCTGroupAcY(){
$this->SetQuery("select c.coAcY from rg_TimeTableCopy t, rg_CourseOpen c
where t.ttcCoId=c.coId group by c.coAcY");
}
function RSClassByCTGroupAcYOrderAcYDesc(){
$this->SetQuery("select c.coAcY from rg_TimeTableCopy t, rg_CourseOpen c
where t.ttcCoId=c.coId group by c.coAcY order by c.coAcY desc");
}
function RSClassByCTGroupSe(){
$this->SetQuery("select c.coTmId from rg_TimeTableCopy t, rg_CourseOpen c
where t.ttcCoId=c.coId group by c.coTmId");
}
function RSClassByAcYAndStYAndSeGroupCoId($acY, $stY, $se){
$this->SetQuery("select coCrsId from rg_CourseOpen c, rg_TimeTableCopy t
where coAcY='$acY'".$stY.$se." and c.coId=t.ttcCoId
group by coCrsId");
}
function RSClassByAcYAndStYAndSeAndOfIdGroupCoId($acY, $stY, $se, $ofId){
$this->SetQuery("select coCrsId from rg_CourseOpen c, rg_TimeTableCopy t
where coAcY='$acY'".$stY.$se." and c.coId=t.ttcCoId
and ttcPrsId='$ofId' group by coCrsId");
}
function RSClassByAcYAndSeAndCtConfirmIsN($acY, $se){
$this->SetQuery("select * from rg_CourseOpen c, rg_TimeTableCopy t
where coAcY='$acY' and coTmId='$se' and c.coId=t.ttcCoId
and ttcConfirm='N'");
}
// ***** End TEACHINGWORKLOAD *****
} //--End class Class1--
?>
|