Viewing file:  processDefineSomeCourse.php (5.02 KB) -rw-r--r--
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";
include_once "../class/clsHoldPlace.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);
$oHP = new HoldPlace($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{
$maxNoAss = 1;
$maxNoAss7 = $oDA->getMaxNoAssByAcadSemFlag($acadYear,$semester,7);
$maxNoAss6 = $oDA->getMaxNoAssByAcadSemFlag($acadYear,$semester,6);
$maxNoAss8 = $oDA->getMaxNoAssByAcadSemFlag($acadYear,$semester,8);
$maxNoAss9 = $oDA->getMaxNoAssByAcadSemFlag($acadYear,$semester,9);
$maxNoAss = max($maxNoAss6,$maxNoAss7,$maxNoAss8,$maxNoAss9);
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();
$oHCTmp->RSHoldCourseTmp();
if($selectFlag!=9){
while($oHCTmp->GetRecord()){
$oHC->AddNew();
$oHC->defineid=$oDA->defineid;
$oHC->classId=$oHCTmp->classId;
$oHC->ttId=$oHCTmp->ttId;
$oHC->officerId=$oHCTmp->officerId;
$oHC->Save();
}
}else{
while($oHCTmp->GetRecord()){
$oTTA->RSMepSepByClassId($oHCTmp->classId);
while($oTTA->GetRecord()){
$oHP->AddNew();
$oHP->defineid=$oDA->defineid;
$oHP->classId=$oHCTmp->classId;
$oHP->mepId=$oTTA->ttEpMepId;
$oHP->sepId=$oTTA->ttEpSepId;
$oHP->Save();
}
}
}
//ลบข้อมูลในตาราง HoldCourseTmp ทั้งหมด
$oHCTmp->DeleteAll();
$oDA->Close();
$oHCTmp->Close();
$oTTA->Close();
$oHP->Close();
}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();
}
$oHP->DeleteByDefineid($defineid);
$oHCTmp->RSHoldCourseTmp();
if($selectFlag!=9){
while($oHCTmp->GetRecord()){
$oHC->AddNew();
$oHC->defineid=$oDA->defineid;
$oHC->classId=$oHCTmp->classId;
$oHC->ttId=$oHCTmp->ttId;
$oHC->officerId=$oHCTmp->officerId;
$oHC->Save();
}
}else{
while($oHCTmp->GetRecord()){
$oTTA->RSMepSepByClassId($oHCTmp->classId);
while($oTTA->GetRecord()){
$oHP->AddNew();
$oHP->defineid=$oDA->defineid;
$oHP->classId=$oHCTmp->classId;
$oHP->mepId=$oTTA->ttEpMepId;
$oHP->sepId=$oTTA->ttEpSepId;
$oHP->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();
?>
|