Viewing file:  clsClassTimeTable.php (3.09 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
//--Class ClassTimeTable--------------------------
include_once "clsbase_ClassTimeTable.php";
class ClassTimeTable extends base_ClassTimeTable{
function RSClassTimeTableLimit($xKey, $start, $pageSize){
$this->SetQuery("select * from ClassTimeTable where classId='$xKey' order by classId limit $start, $pageSize");
}
function RSClassTimeTableByClId($xKey){
$this->SetQuery("select * from ClassTimeTable where classId='$xKey' order by sequenceId");
}
function RSClassTimeTableByClIdAndDayAndPr($xKey, $yKey, $zKey){
$this->SetQuery("select * from ClassTimeTable where classId='$xKey' and weekDay='$yKey' and '$zKey' between timeSlotStart and timeSlotEnd order by sequenceId");
}
//-- Use on page processClass.php --
function SearchByKeyRoIdAndWD($ClsId, $xKey, $yKey){
$this->SetQuery("select * from ClassTimeTable where classId='$ClsId' and roomId='$xKey' and weekDay='$yKey'");
}
function SearchByKeyRoIdAndWDAndTss($AcY, $SeM, $Dy, $rm, $S1, $E1){
/* $sql="SELECT count(*) as num
from Class c, ClassTimeTable t
where c.acadYear='$AcY' and c.semester='$SeM' and c.classId=t.classId and t.weekDay='$Dy'
and t.roomId='$rm' and (t.timeSlotEnd >= '$S1' and t.timeSlotStart <= '$E1')";
die($sql); */
$this->setQuery("select count(*) as num
from Class c, ClassTimeTable t
where c.acadYear='$AcY' and c.semester='$SeM' and c.classId=t.classId and t.weekDay='$Dy'
and t.roomId='$rm' and (t.timeSlotEnd >= '$S1' and t.timeSlotStart <= '$E1')");
$result=$this->GetResult();
return $result['num'];
}
function RSClassTimeTableByRoIdAndWDAndTss($AcY, $SeM, $Dy, $rm, $S1, $E1){
$sql = "select * from Class c, ClassTimeTable t
where c.acadYear='$AcY' and c.semester='$SeM' and c.classId=t.classId and t.weekDay='$Dy'
and t.roomId='$rm' and (t.timeSlotEnd >= '$S1' and t.timeSlotStart <= '$E1')";
$this->setQuery($sql);
}
function SearchByKeyRoIdAndWDAndTssAndCoIdAndSectionAndOVL($AcY, $SeM, $Dy, $rm, $S1, $E1, $coId, $section){
$this->setQuery("select count(*) as num
from Class c, ClassTimeTable t
where c.acadYear='$AcY' and c.semester='$SeM' and c.classId=t.classId and t.weekDay='$Dy'
and t.roomId='$rm' and t.timeSlotStart='$S1' and t.timeSlotEnd='$E1'
and c.courseId='$coId' and c.section!='$section' and t.overlap='Y'");
$result=$this->GetResult();
return $result['num'];
}
function RSClassTimeTableByAcYAndSe($xKey, $yKey){
$this->SetQuery("select * from ClassTimeTable t, Class c where t.classId=c.classId and acadYear='$xKey' and semester='$yKey' order by sequenceId");
}
function SearchByKeyClsIdTseTssWD($ClsId, $S1, $E1, $WD){
$this->SetQuery("SELECT count(*) as num from ClassTimeTable t where t.classId='$ClsId' and (t.timeSlotEnd >= '$S1' and t.timeSlotStart <= '$E1') and (t.weekDay='$WD')");
$result=$this->GetResult();
return $result['num'];
}
//-- Use on page beforeShowClassStudy.php --
function SearchCTTByClsIdWdSt($ClsId,$wd,$st){
if($this->SetQuery("select * from ClassTimeTable where classId='$ClsId' and weekDay='$wd' and timeSlotStart='$st' ")){
return 1;
}else{
return 0;
}
}
//-- The end --
} //--End class ClassTimeTable--
?>
|