$inputFileType = PHPExcel_IOFactory::identify($inputFileName);
$objReader = PHPExcel_IOFactory::createReader($inputFileType);
$objPHPExcel = $objReader->load($inputFileName);
$objPHPExcel->setActiveSheetIndex(0);
$objWorksheet = $objPHPExcel->getActiveSheet();
$highestRow = $objWorksheet->getHighestRow();
// COLUMNS
$SUBJECT = 0;
$STUDENT_ID = 1;
$NAME = 2;
$GRADE = 3;
//SUBJECT
$subject_code = $objPHPExcel->getActiveSheet()->getCellByColumnAndRow(0, 2)->getValue();
$subject = Subject::get_by_sql("SELECT * FROM tbl_subjects WHERE code = '" . $subject_code . "'")[0];
if ($subject) {
$subject_id = Subject::get_by_sql("SELECT * FROM tbl_subjects WHERE code = '" . $subject_code . "'")[0]->id;
for ($row = 2; $row <= $highestRow; $row++) {
$student_id = $objPHPExcel->getActiveSheet()->getCellByColumnAndRow($STUDENT_ID, $row)->getValue();
$grade = $objPHPExcel->getActiveSheet()->getCellByColumnAndRow($GRADE, $row)->getValue();
$student = Student::get_by_id($student_id);
if ($student) {
$grades = Grade::get_by_sql("SELECT * FROM tbl_student_grades WHERE subject_id = '" . $subject_id . "' AND student_id = " . $student_id)[0];
if ($grades) {
$grades->grade = $grade;
$grades->update();
} else {
$newgrades = new Grade();
$newgrades->grade = $grade;
$newgrades->student_id = $student_id;
$newgrades->subject_id = $subject_id;
$newgrades->create();
}
if (!$sidx) {
$sidx = 1;
}
$first = $_GET['first'];
if ($first == "true") {
$future_sem = 1;
} else {
if ($first == "2nd") {
$future_sem = 2;
} else {
$future_sem = $student->semester == 1 ? 2 : 1;
}
}
//$student_subjects = Grade::get_by_sql("SELECT * FROM " . T_STUDENT_GRADES . " WHERE ".C_GRADE_STUDENT_ID."=".$student->id);
$future_subjects = Subject::get_by_sql("SELECT * FROM " . T_SUBJECTS . " WHERE " . C_SUBJECT_COURSE_ID . "=" . $student->course_id . " AND " . C_SUBJECT_SEMESTER . " = " . $future_sem . " ORDER BY {$sidx} {$sord} LIMIT {$start} , {$limit}");
// $student_current_subjects = array();
// foreach($student_subjects as $student_subject)
// {
// array_push($student_current_subjects, Subject::get_by_id($student_subject->subject_id));
// }
header("Content-type: text/xml;charset=utf-8");
$s = "<?xml version='1.0' encoding='utf-8'?>";
$s .= "<rows>";
$s .= "<page>" . $page . "</page>";
$s .= "<total>" . $total_pages . "</total>";
$s .= "<records>" . $count . "</records>";
if (count($future_subjects) > 0) {
foreach ($future_subjects as $final_subject) {
$s .= "<row id='" . $final_subject->id . "'>";
$s .= "<cell>" . $final_subject->id . "</cell>";
require_once "../includes/initialize.php";
global $session;
if (!$session->is_logged_in()) {
redirect_to("index.php");
}
if ($_POST['oper'] == 'del') {
Subject::get_by_id($_POST['id'])->delete();
}
if ($_POST['prereq_subject_code'] == "NOTHING" || $_POST['prereq_subject_code'] == "") {
$prereq_subject_id = 0;
} else {
$prereq_subject_id = Subject::get_by_sql("SELECT * FROM " . T_SUBJECTS . " WHERE " . C_SUBJECT_CODE . "='" . trim($_POST['prereq_subject_code']) . "'")[0]->id;
}
$course_id = Course::get_by_sql("SELECT * FROM " . T_COURSES . " WHERE " . C_COURSE_CODE . "='" . trim($_POST['course_code']) . "'")[0]->id;
$rows = Subject::get_by_sql("SELECT * FROM " . T_SUBJECTS . " WHERE " . C_SUBJECT_CODE . "='" . $_POST['code'] . "' AND " . C_SUBJECT_COURSE_ID . "=" . $course_id);
if ($_POST['oper'] == 'add') {
if (count($rows) > 0) {
die("exists");
}
$subject = new Subject();
$subject->code = $_POST['code'];
$subject->description = $_POST['description'];
$subject->units = $_POST['units'];
$subject->prereq_subject_id = $prereq_subject_id;
$subject->course_id = $course_id;
$subject->year = $_POST['year'];
$subject->semester = $_POST['semester'];
$subject->curriculum_id = $_POST['curriculum_id'];
$subject->create();
} else {
if ($page > $total_pages) {
$page = $total_pages;
}
$start = $limit * $page - $limit;
if ($start < 0) {
$start = 0;
}
if (!$sidx) {
$sidx = 1;
}
if (isset($_GET['searchString']) && isset($_GET['searchField'])) {
$searchString = $_GET['searchString'];
$searchField = $_GET['searchField'];
$subjects = Subject::get_by_sql("SELECT * FROM " . T_SUBJECTS . " WHERE " . $searchField . " LIKE '%" . $searchString . "%' ORDER BY {$sidx} {$sord} LIMIT {$start} , {$limit}");
} else {
$subjects = Subject::get_by_sql("SELECT * FROM " . T_SUBJECTS . " ORDER BY {$sidx} {$sord} LIMIT {$start} , {$limit}");
}
if ($isteacher) {
$subjects = TeacherSubject::get_by_teacher_id($session->user_id);
}
header("Content-type: text/xml;charset=utf-8");
$s = "<?xml version='1.0' encoding='utf-8'?>";
$s .= "<rows>";
$s .= "<page>" . $page . "</page>";
$s .= "<total>" . $total_pages . "</total>";
$s .= "<records>" . $count . "</records>";
foreach ($subjects as $subjectobject) {
$subject = $subjectobject;
if ($isteacher) {
$subject = Subject::get_by_id($subjectobject->subject_id);
}