Viewing file:  clsClassInStructor.php (3.68 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
//--Class ClassInStructor--------------------------
include_once "clsbase_ClassInStructor.php";
class ClassInStructor extends base_ClassInStructor{
function RSClassInStructorBySeqAndClId($xKey, $yKey){
$this->SetQuery("select * from ClassInStructor where sequenceId='$xKey' and classId='$yKey' order by sequenceId");
}
function RSClassInStructorByClId($xKey){
$this->SetQuery("select officerId from ClassInStructor where classId='$xKey' group by officerId");
}
function RSClassInStructorDistinctClIdOfIdByClId($xKey){
$this->SetQuery("select distinct classId, officerId from ClassInStructor where classId='$xKey'");
}
function RSClassInStructorByClIdAndOfId($xKey, $yKey){
$this->SetQuery("select * from ClassInStructor where classId='$xKey' and officerId='$yKey'");
}
function RSClassInStructorByClIdAndResponsibilityIsY($xKey){
$this->SetQuery("select * from ClassInStructor where classId='$xKey' and responsibility='Y'");
}
function RSClassInStructorByClIdAndOfIdAndResponsibilityIsY($xKey, $yKey){
$this->SetQuery("select * from ClassInStructor where classId='$xKey' and officerId='$yKey' and responsibility='Y'");
}
// Use on page addGrade.php
function SearchByClassId($xKey){
if ($this->SetQuery("select distinct(officerId) from ClassInStructor where classId='$xKey'")){
return 1;
}else {
return 0;
}
}
//-- The End --
//-- Use on page beforeShowClassTeach.php --
function SearchCISByOfId($OfId){
$this->SetQuery("select * from ClassInStructor where officerId='$OfId' ");
}
//-- The end --
//-- Use on page classTable.php of teacher --
function SearchCISByOfIdAndClassId($OfId,$ClsId){
$this->SetQuery("select count(officerId) as num from ClassInStructor where officerId='$OfId' and classId='$ClsId'");
/* if($this->SetQuery("select * from ClassInStructor where officerId='$OfId' and classId='$ClsId'")){
return 1;
}else{
return 0;
}*/
$result=$this->GetResult();
return $result['num'];
}
//-- The end --
//-- Use on page processClass.php --
function SearchCISByAcYSeMClsIdWdRmIdS1E1OfId($AcY, $SeM, $WD, $rmId, $S1, $E1, $OfId){
$sql = "SELECT count(*) as num
from Class c, ClassTimeTable t, ClassInStructor s
where c.acadYear='$AcY' and c.semester='$SeM' and c.classId=s.classId
and c.classId=t.classId and t.sequenceId=s.sequenceId
and t.weekDay='$WD' and (t.timeSlotEnd >= '$S1' and t.timeSlotStart <= '$E1')
and s.officerId='$OfId'";
$this->SetQuery($sql);
/*$this->SetQuery("SELECT count(*) as num
from Class c, ClassTimeTable t, ClassInStructor s
where c.acadYear='$AcY' and c.semester='$SeM' and c.classId=s.classId and
c.classId=t.classId and t.weekDay='$WD' and (t.timeSlotEnd >= '$S1' and t.timeSlotStart <= '$E1')
and s.officerId='$OfId'");*/
$result=$this->GetResult();
return $result['num'];
}
function SearchCISByAcYSeMClsIdWdRmIdS1E1OfIdAndCoIdAndSectionAndOVL($AcY, $SeM, $WD, $rmId, $S1, $E1, $OfId, $coId, $section){
$sql = "SELECT count(*) as num
from Class c, ClassTimeTable t, ClassInStructor s
where c.acadYear='$AcY' and c.semester='$SeM' and c.classId=s.classId
and c.classId=t.classId and t.sequenceId=s.sequenceId
and t.weekDay='$WD' and t.timeSlotStart='$S1' and t.timeSlotEnd='$E1'
and s.officerId='$OfId'
and c.courseId='$coId' and c.section!='$section' and t.overlap='Y'";
$this->SetQuery($sql);
$result=$this->GetResult();
return $result['num'];
}
function CheckTeachOfficer($Seq, $ClsId, $OfId){
$this->SetQuery("SELECT count(officerId) as num from ClassInStructor where sequenceId='$Seq' and classId='$ClsId' and officerId='$OfId' ");
$result=$this->GetResult();
return $result['num'];
}
//-- The end --
} //--End class ClassInStructor--
?>
|