$grades = Grade::get_by_sql("SELECT * FROM " . T_STUDENT_GRADES . " WHERE " . C_GRADE_STUDENT_ID . " = " . $student_id . " ORDER BY {$sidx} {$sord} LIMIT {$start} , {$limit}"); 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 ($grades as $grade) { if (Subject::get_by_id($grade->subject_id)->course_id != $student->course_id) { continue; } if (Subject::get_by_id($grade->subject_id)->semester != $student->semester) { //continue; } $s .= "<row id='" . $grade->id . "'>"; $s .= "<cell>" . $grade->id . "</cell>"; $s .= "<cell>" . Subject::get_by_id($grade->subject_id)->code . "</cell>"; $s .= "<cell>" . Subject::get_by_id($grade->subject_id)->description . "</cell>"; $s .= "<cell>" . $grade->grade . "</cell>"; $s .= "<cell>" . Subject::get_by_id($grade->subject_id)->units . "</cell>"; $s .= "<cell>" . Subject::get_by_id($grade->subject_id)->year . "</cell>"; if ($grade->grade >= 75) { $remarks = "PASSED"; } else { $remarks = "FAILED"; } $s .= "<cell>" . $remarks . "</cell>"; $s .= "</row>"; } $s .= "</rows>"; echo $s;
$newgrade = Grade::get_by_subj_stud($id, $student_id); $newgrade->delete(); } $newgrade = new Grade(); $newgrade->subject_id = $id; $newgrade->student_id = $student_id; $newgrade->grade = 0; $newgrade->create(); $pre_subject = Subject::get_by_id($id); if (!EvaluatedSubject::exists($id, $student_id)) { $grade = Grade::get_by_subj_stud($pre_subject->id, $student_id); $gradepre = Grade::get_by_subj_stud($pre_subject->prereq_subject_id, $student_id); if (has_prerequisite($pre_subject->prereq_subject_id, $student_subjects)) { if ($gradepre != null) { if (Grade::get_by_subj_stud($pre_subject->prereq_subject_id, $student_id)->grade <= 74) { $warnings .= "Cannot add " . $pre_subject->code . " because it's previous subject:" . Subject::get_by_id($pre_subject->prereq_subject_id)->code . " is failed\n\n"; } else { $eval_subject = new EvaluatedSubject(); $eval_subject->student_id = $student_id; $eval_subject->subject_id = $id; $eval_subject->create(); } } } else { $eval_subject = new EvaluatedSubject(); $eval_subject->student_id = $student_id; $eval_subject->subject_id = $id; $eval_subject->create(); } } }
<?php require_once "../includes/initialize.php"; global $session; if (!$session->is_logged_in()) { // redirect_to("index.php"); // }else{ // if(isset($session->student_id)){ redirect_to("index.php"); //} } $subject = Subject::get_by_id($_GET['subject_id']); ?> <!DOCTYPE HTML> <html> <head> <meta charset="UTF-8" /> <title>LasalTech Subject Advising System</title> <link href="css/fonts.css" rel="stylesheet"/> <link href="css/app.css" rel="stylesheet"/> <link href="css/bundledfun-ui/jquery-ui-1.8.23.custom.css" rel="stylesheet" media="screen" /> <link href="css/ui.jqgrid.css" rel="stylesheet" media="screen" /> <!-- <link href="css/bootstrap.min.css" rel="stylesheet"/> --> </head> <body style="background:#235c88;"> <div id="main_container">
} $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 ($_POST['oper'] == 'edit') { $subject = Subject::get_by_id($_POST['id']); $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->update(); } }
} //$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>"; $s .= "<cell>" . $final_subject->code . "</cell>"; $s .= "<cell>" . $final_subject->description . "</cell>"; $s .= "<cell>" . $final_subject->units . "</cell>"; $subject_code = $final_subject->prereq_subject_id == 0 ? "NONE" : Subject::get_by_id($final_subject->prereq_subject_id)->code; $s .= "<cell>" . $subject_code . "</cell>"; $s .= "<cell>" . Course::get_by_id($final_subject->course_id)->code . "</cell>"; $s .= "<cell>" . $final_subject->semester . "</cell>"; $s .= "<cell>" . $final_subject->year . "</cell>"; $s .= "</row>"; } } $s .= "</rows>"; echo $s;
require_once "../includes/initialize.php"; global $session; if (!$session->is_logged_in()) { redirect_to("index.php"); } $id = $_POST['id']; $teacher_id = $_POST['teacher_id']; $subject_id = $_POST['subject_id']; $operator = $_POST['oper']; if ($operator == 'add') { $object = new TeacherSubject(); $object->teacher_id = $teacher_id; $object->subject_id = $subject_id; if (Subject::get_by_id($object->subject_id) != null && User::get_by_id($object->teacher_id) != null) { $object->create(); } } else { if ($operator == 'edit') { $object = TeacherSubject::get_by_id($id); $object->teacher_id = $teacher_id; $object->subject_id = $subject_id; if (Subject::get_by_id($object->subject_id) != null && User::get_by_id($object->teacher_id) != null) { $object->update(); } } else { if ($operator == 'del') { TeacherSubject::get_by_id($id)->delete(); } } }
$page = $total_pages; } $start = $limit * $page - $limit; if ($start < 0) { $start = 0; } if (!$sidx) { $sidx = 1; } $TeacherSubjects = TeacherSubject::get_by_sql("SELECT * FROM " . T_TEACHER_SUBJECTS . " ORDER BY {$sidx} {$sord} LIMIT {$start} , {$limit}"); 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 ($TeacherSubjects as $TeacherSubject) { $subject = Subject::get_by_id($TeacherSubject->subject_id); $teacher = User::get_by_id($TeacherSubject->teacher_id); $s .= "<row id='" . $TeacherSubject->id . "'>"; $s .= "<cell></cell>"; $s .= "<cell>" . $TeacherSubject->id . "</cell>"; $s .= "<cell>" . $teacher->id . "</cell>"; $s .= "<cell>" . $teacher->name . "</cell>"; $s .= "<cell>" . $subject->id . "</cell>"; $s .= "<cell>" . $subject->code . "</cell>"; $s .= "<cell>" . $subject->description . "</cell>"; $s .= "</row>"; } $s .= "</rows>"; echo $s;
</style> <?php require_once "../../includes/initialize.php"; $student = Student::get_by_id($_GET['student_id']); $grades = Grade::get_by_sql("SELECT * FROM " . T_STUDENT_GRADES . " WHERE " . C_GRADE_STUDENT_ID . " = " . $student->id); $s = "<table>"; $s .= "<tr>"; $s .= "<td>SUBJECT</td>"; $s .= "<td>GRADE</td>"; $s .= "<td>REMARKS</td>"; $s .= "</tr>"; foreach ($grades as $grade) { $s .= "<tr>"; if (Subject::get_by_id($grade->subject_id)->course_id != $student->course_id) { continue; } if (Subject::get_by_id($grade->subject_id)->semester != $student->semester) { continue; } $s .= "<td>" . Subject::get_by_id($grade->subject_id)->code . "</td>"; $s .= "<td>" . $grade->grade . "</td>"; if ($grade->grade >= 75) { $remarks = "PASSED"; } else { $remarks = "FAILED"; } $s .= "<td>" . $remarks . "</td>"; $s .= "</tr>"; } $s .= "</table>"; echo $s;
<td>UNITS</td> <td>PREREQUISITE</td> <td>COURSE</td> <td>YEAR</td> <td>SEMESTER</td> <td>CURRICULUM</td> </tr> </thead> <?php $subjects = Subject::getByCurriculum($curriculumid); if (count($subjects) > 0) { foreach ($subjects as $subject) { $course = Course::get_by_id($subject->course_id); $curriculum = Curriculum::get_by_id($subject->curriculum_id); if ($subject->prereq_subject_id != "") { $prerequisitesubject = Subject::get_by_id($subject->prereq_subject_id); if (!$prerequisitesubject) { $prerequisitesubject = new Subject(); $prerequisitesubject->code = "NONE"; } } else { $prerequisitesubject = new Subject(); $prerequisitesubject->code = "NONE"; } if ($subject->semester == 1) { $subject->semester = "First"; } else { if ($subject->semester == 2) { $subject->semester = "Second"; } }