Viewing file:  2551-11-11-1.0.01-processDefineSomeCourse.php (3.82 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
include_once "template.php";
showHeader();
include_once "../global1.php";
include_once "../../class/clsConnection.php";
include_once "../../class/clsDB.php";
include_once "../class/clsDefineAssessment.php";
include_once "../class/clsHoldCourseTmp.php";
include_once "../class/clsHoldCourse.php";
include_once "../link/function.php";
include_once "../class/clsDoAssessment.php";
include_once "../class/clsTimeTableAssess.php";
$oCA = new clsConnection($GLOBALS['HOST'], $GLOBALS['DB_EASS'], $GLOBALS['USER_EASS'], $GLOBALS['PASSWORD_EASS']);
$oDA = new DefineAssessment($oCA);
$oHCTmp = new HoldCourseTmp($oCA);
$oHC = new HoldCourse($oCA);
$oDo = new DoAssessment($oCA);
$oTTA = new TimeTableAssess($oCA);
if($link==main){
//ลบข้อมูลในตาราง HoldCourseTmp ทั้งหมด
$oHCTmp->DeleteAll();
if($menu == 'linkBackMenu'){
echo "<meta http-equiv='refresh' content='0; URL=index.php?mm=1;'>";
}else{
//$menu == 'linkSubMenu'
//processDefineSomeCourse.php?flag=1&menu='linkSubMenu'
$oHCTmp->DeleteAll();
echo "<meta http-equiv='refresh' content='0; URL=addDefineSomeCourse.php;'>";
}
}else{
$maxNoAss7 = $oDA->getMaxNoAssByAcadSemFlag($acadYear,$semester,7);
$maxNoAss6 = $oDA->getMaxNoAssByAcadSemFlag($acadYear,$semester,6);
$maxNoAss8 = $oDA->getMaxNoAssByAcadSemFlag($acadYear,$semester,8);
$maxNoAss = max($maxNoAss6,$maxNoAss7,$maxNoAss8);
/* if($maxNoAss7 < $maxNoAss6){
$maxNoAss = $maxNoAss6;
}else if($maxNoAss7 > $maxNoAss6){
$maxNoAss = $maxNoAss1;
}
*/
if(!$isPreAssess){
$isPreAssess='0';
}
if($method=="add"){
$oDA->AddNew();
$oDA->defineid=$defineid;
$oDA->assid=$assid;
$oDA->startDate=splitDateForm($startDate,"/");
$oDA->endDate=splitDateForm($endDate,"/");
$oDA->acadYear=$acadYear;
$oDA->semester=$semester;
$oDA->noAss=$maxNoAss + 1;
$oDA->flag=$selectFlag;
$oDA->closeDate=splitDateForm($closeDate,"/");
$oDA->isPreAssess=$isPreAssess;
$oDA->Save();
if($selectFlag==6){
$oHCTmp->RSClassIdByFlag6();
}elseif($selectFlag==7){
$oHCTmp->RSClassIdByFlag7();
}else{ // 8
$oHCTmp->RSClassIdByFlag8();
}
while($oHCTmp->GetRecord()){
$oHC->AddNew();
$oHC->defineid=$oDA->defineid;
$oHC->classId=$oHCTmp->classId;
$oHC->ttId=$oHCTmp->ttId;
$oHC->officerId=$oHCTmp->officerId;
$oHC->Save();
}
//ลบข้อมูลในตาราง HoldCourseTmp ทั้งหมด
$oHCTmp->DeleteAll();
}elseif($method=="edit"){
$oDA->SearchByKey($defineid, $acadYear, $semester, $noAss);
$oDA->GetRecord();
$oDA->Edit();
$oDA->defineid=$defineid;
$oDA->assid=$assid;
$oDA->startDate=splitDateForm($startDate,"/");
$oDA->endDate=splitDateForm($endDate,"/");
$oDA->acadYear=$acadYear;
$oDA->semester=$semester;
$oDA->noAss=$noAss;
$oDA->flag=$flag;
$oDA->closeDate=splitDateForm($closeDate,"/");
$oDA->isPreAssess=$isPreAssess;
$oDA->Save();
$oHC->SearchByDefineid($defineid);
while($oHC->GetRecord()){
$oHC->DeleteByDefineid();
}
if($selectFlag==6){
$oHCTmp->RSClassIdByFlag6();
}elseif($selectFlag==7){
$oHCTmp->RSClassIdByFlag7();
}else{ // 8
$oHCTmp->RSClassIdByFlag8();
}
while($oHCTmp->GetRecord()){
$oHC->AddNew();
$oHC->defineid=$oDA->defineid;
$oHC->classId=$oHCTmp->classId;
$oHC->ttId=$oHCTmp->ttId;
$oHC->officerId=$oHCTmp->officerId;
$oHC->Save();
}
//ลบข้อมูลในตาราง HoldCourseTmp ทั้งหมด
$oHCTmp->DeleteAll();
}else if($method=="delete"){
$oDA->SearchByKey($defineid, $acadYear, $semester, $noAss);
$oDA->GetRecord();
$oDA->Delete();
$oHC->SearchByDefineid($defineid);
while($oHC->GetRecord()){
$oHC->DeleteByDefineid();
}
}
echo "<meta http-equiv='refresh' content='0; URL=addDefineSomeCourse.php;'>";
}
$oDA->Close();
$oCA->Disconnect();
?>
|