Viewing file:  clsProgram.php (1.39 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
//--Class Program--------------------------
include_once "clsbase_Program.php";
class Program extends base_Program{
function RSProgramLimit($start, $pageSize){
$this->SetQuery("select * from Program where programStatus='Y' order by programId limit $start, $pageSize");
}
function RSAllProgram(){
$this->SetQuery("select * from Program order by programConfId");
}
function RSAllProgramLimit($start, $pageSize){
$this->SetQuery("select * from Program order by programConfId limit $start, $pageSize");
}
function RSProgramGroupLevelId(){
$this->SetQuery("select levelId from Program where programStatus='Y' group by levelId");
}
function RSAllProgramGroupLevelId(){
$this->SetQuery("select levelId from Program group by levelId");
}
function RSProgramByLevelId($xKey){
$this->SetQuery("select * from Program where levelId='$xKey' and programStatus='Y'");
}
// ***** Start TIMETABLE *****
function RSProgramByStatusIsYOrderName(){
$this->SetQuery("select * from rg_Curriculum where curStatus='Y' order by curName");
}
// ***** End TIMETABLE *****
/*
function selectHTML($name, $ID=""){
$s="<select name=\"$name\">\n";
$s.="<option value=\"\">---เลือกหลักสูตร---\n";
$this->RSProgram();
while($this->GetRecord()){
$s.="<option value=\"$this->programId\" ";
$s.=($this->programId==$ID) ? "Selected" : "" ;
$s.=">$this->programName\n";
}
return $s.="</select>\n";
}
*/
} //--End class Program--
?>
|