Viewing file: clsCourseInProgram.php (2.14 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php //--Class CourseInProgram--------------------------
include_once "clsbase_CourseInProgram.php";
class CourseInProgram extends base_CourseInProgram{
function RSCourseInProgramByCoIdAndCoStatus($xKey){ $this->SetQuery("select c.conditionId1, c.conditionId2 from CourseInProgram c, Program p where c.courseId='$xKey' and c.courseStatus='Y' and c.programId=p.programId and p.programStatus='Y' group by c.conditionId1, c.conditionId2"); }
function RSCourseInProgramByCd1AndCd2AndCoId($xKey, $yKey, $zKey){ $this->SetQuery("select * from CourseInProgram where conditionId1='$xKey' and conditionId2='$yKey' and courseId='$zKey'"); }
function RSCourseInProgramByPgIdAndCoIdAndCoStatus($xKey, $yKey){ $this->SetQuery("select * from CourseInProgram where programId='$xKey' and courseId='$yKey' and courseStatus='Y'"); }
function RSCourseInProgramByPgIdAndCd1AndCd2($xKey, $yKey, $zKey){ $this->SetQuery("select * from CourseInProgram where programId='$xKey' and conditionId1='$yKey' and conditionId2='$zKey' and courseStatus='Y'"); }
function RSCourseInProgramByPgIdAndCdId1($xKey, $yKey){ $this->SetQuery("select CourseInProgram.*, Course.courseCode, Course.courseName, Course.courseUnit from CourseInProgram, Course where programId='$xKey' and conditionId1='$yKey' and CourseInProgram.courseStatus='Y' and CourseInProgram.courseId=Course.courseId "); }
function SearchByKeyDel($xKey1, $xKey2, $xKey3){ if ($this->SetQuery("select * from CourseInProgram where programId='$xKey1' and conditionId1='$xKey2' and conditionId2='$xKey3'")){ return 1; }else{ return 0; } }
function SearchByKeyPgIdAndCd1Cd2CourseId($wKey, $xKey, $yKey, $zKey){ if($this->SetQuery("select * from CourseInProgram where programId='$wKey' and conditionId1='$xKey' and conditionId2='$yKey' and courseId='$zKey' and courseStatus='Y' order by courseId")){ return 1; }else{ return 0; } }
function RSCountCourseId($yKey, $zKey){ $this->SetQuery("select count(courseId) as num from CourseInProgram where programId='$yKey' and courseStatus='Y' and courseId='$zKey' order by courseId"); if($result=$this->GetResult()) { return $result['num']; } }
} //--End class CourseInProgram-- ?>
|