protected function savetimetable()
{
$required = array("exam_id" => "Examination Name", "check" => "Exam Timetable");
global $user;
if ($user->checkAdmin() == true) {
if (isset($_POST)) {
foreach ($required as $key => $value) {
if (!isset($_POST[$key]) || $_POST[$key] == '' || $_POST[$key] == 'select') {
echo $value . ' is Required<br/>';
return;
}
}
global $objPDO;
require_once $_SERVER['DOCUMENT_ROOT'] . '/cloud/model/exam_timetable_class.php';
require_once $_SERVER['DOCUMENT_ROOT'] . '/cloud/model/examination_section_subject_class.php';
require_once $_SERVER['DOCUMENT_ROOT'] . '/cloud/model/section_class.php';
$exam_id = $_POST['exam_id'];
$sec = new Section($objPDO);
$fn_an = array("0" => "FN", "1" => "AN");
$sec_name = $sec->getSectionArray();
foreach ($_POST as $k => $v) {
if ($k != 'exam_id' && $k != 'check' && $k != 'save_timetable') {
$parts_1 = explode('_', $k);
$section_id_1 = $parts_1[2];
foreach ($_POST as $r => $s) {
if ($r != 'exam_id' && $r != 'check' && $r != 'save_timetable') {
$parts_2 = explode('_', $r);
$section_id_2 = $parts_2[2];
if ($s == $v && $k != $r && $v != 0 && $section_id_1 == $section_id_2) {
echo 'Exam Clash.. Please Check Section [[' . $sec_name[$section_id_1] . ']] on ' . $parts_1[0] . '-' . $fn_an[$parts_1[1]] . ' and ' . $parts_2[0] . '-' . $fn_an[$parts_2[1]];
return;
}
}
}
}
}
echo 'Saving...';
foreach ($_POST as $key => $value) {
if ($key != 'exam_id' && $key != 'check' && $key != 'save_timetable') {
$parts = explode('_', $key);
$date = date('Y-m-d H:i:s T', strtotime($parts[0]));
$slot = $parts[1];
$section_id = $parts[2];
$subject_id = $value;
if ($subject_id == 0) {
continue;
} else {
$rel = new ExaminationSectionSubject($objPDO);
$rel->setSectionId($section_id);
$rel->setSubjectId($subject_id);
$rel->setExaminationId($exam_id);
$sub_rel_id = $rel->getIDByElems();
$tt = new ExamTimetable($objPDO);
if ($tt->checkExamSubjectId($sub_rel_id)) {
$tt->deleteByExamSubjectId($sub_rel_id);
}
$tt->setSlot($slot);
$tt->setDate($date);
$tt->setExamSubjectId($sub_rel_id);
$tt->save();
}
}
}
echo '<meta http-equiv="Refresh" content="0;url=http://localhost/cloud/examination/"/>';
}
} else {
header('Location:http://localhost/cloud');
}
}
public static function dropDownListEditable($val, $id, $name, $type, $class = NULL, $input = NULL, $textVal = NULL, $class_select = NULL)
{
Utility::editableSelectScript($id);
global $objPDO;
include_once $_SERVER['DOCUMENT_ROOT'] . '/cloud/model/subject_class.php';
include_once $_SERVER['DOCUMENT_ROOT'] . '/cloud/model/section_class.php';
include_once $_SERVER['DOCUMENT_ROOT'] . '/cloud/model/teacher_class.php';
$sec = new Section($objPDO);
$section = $sec->getSectionArray();
$tea = new Teacher($objPDO);
$teacher = $tea->getTeacherArray($input);
$sub = new Subject($objPDO);
$subject = $sub->getSubjectArray();
$numeric_level = array("select" => "--Select--", "0" => "0", "1" => "1", "2" => "2", "3" => "3", "4" => "4", "5" => "5", "6" => "6", "7" => "7", "8" => "8", "9" => "9", "10" => "10", "11" => "11", "12" => "12");
$blood_group = array("select" => "--Select--", "A+" => "A+", "B+" => "B+", "O+" => "O+", "AB+" => "AB+", "A-" => "A-", "B-" => "B-", "O-" => "O-", "AB-" => "AB-");
$category = array("select" => "--Select--", "OC" => "General(OC)", "SC" => "SC", "ST" => "ST", "OBC" => "OBC", "NRI" => "NRI", "Defence" => "Defence");
if ($class == NULL) {
$class = "text_editable";
}
$list = array();
if ($type == "numeric_level") {
$list = $numeric_level;
} else {
if ($type == "blood_group") {
$list = $blood_group;
} else {
if ($type == "category") {
$list = $category;
} else {
if ($type == "subject") {
$list = $subject;
} else {
if ($type == "section") {
$list = $section;
} else {
if ($type == "teacher") {
$list = $teacher;
}
}
}
}
}
}
$textVal = "";
if (array_key_exists($val, $list)) {
$textVal = $list[$val];
}
$html = '<input type="text" readonly="readonly" id="' . $id . '" class="' . $class . '" value="' . $textVal . '"/>';
$html .= '<select class="' . $class_select . '" style="display:none" id="' . $id . '" name="' . $name . '" >';
foreach ($list as $key => $value) {
if ($key == $val) {
$html .= '<option class="' . $class_select . '" selected="selected" value="' . $key . '">' . $value . '</option>';
} else {
$html .= '<option value="' . $key . '">' . $value . '</option>';
}
}
$html .= '</select>';
echo $html;
}
protected function teacherview()
{
global $user;
global $objPDO;
$student = new student($objPDO, $user->getuserId());
$headMenu = array("username" => $student->getName());
if ($user->checkAdmin() == true || $student->checkTeacher()) {
if ($user->checkAdmin()) {
$teacher = $_GET['uid'];
} else {
require_once $_SERVER['DOCUMENT_ROOT'] . '/cloud/model/teacher_class.php';
$teacherProfile = new Teacher($objPDO);
$teacherProfile->loadByUserId($student->getID());
$teacher = $teacherProfile->getID();
}
include $_SERVER['DOCUMENT_ROOT'] . '/cloud/model/timetable_settings_class.php';
$sett = new TimetableSettings($objPDO);
$slots = $sett->getAllSlots();
if (!isset($slots)) {
$num_slots = 0;
} else {
$num_slots = count($slots);
}
include_once $_SERVER['DOCUMENT_ROOT'] . '/cloud/model/subject_class.php';
include_once $_SERVER['DOCUMENT_ROOT'] . '/cloud/model/timetable_class.php';
include_once $_SERVER['DOCUMENT_ROOT'] . '/cloud/model/section_class.php';
$tt = new Timetable($objPDO);
$sec = new Section($objPDO);
$timetable = $tt->getByTeacherId($teacher);
$subject = $tt->getTeacherSubject($teacher);
$section = $sec->getSectionArray();
$total = 0;
$count = array();
foreach ($timetable as $key => $value) {
$total++;
if (array_key_exists($value, $count)) {
$count[$value]++;
} else {
$count[$value] = 1;
}
}
include $_SERVER['DOCUMENT_ROOT'] . '/cloud/view/teacher_timetable_view_template.php';
} else {
header('Location:http://localhost/cloud');
}
}
