public function getAction() { if ($this->getRequest()->isGet()) { $student_id = $this->_request->getParam('s'); $student_DB = new Application_Model_DbTable_Student(); $student = $student_DB->get($student_id); $results = array(); foreach ($student as $row) { if ($row['grade'] && $row['target'] && $row['create_date']) { $results[] = $row; } } if ($student && isset($student[0]) && isset($student[0]['student'])) { $this->view->student_name = $student[0]['student']; } $this->view->student = $results; } }
public function studentsAction() { $group_id = $this->_request->getParam('g'); $target_id = $this->_request->getParam('t'); $level_id = $this->_request->getParam('l'); $game_id = $this->_request->getParam('gm'); //Return After Planining if ($group_id && $target_id && $level_id) { $student_DB = new Application_Model_DbTable_Student(); $grade_DB = new Application_Model_DbTable_Grade(); $students = $student_DB->getAll($group_id); $grades = $grade_DB->getAll($target_id, $level_id); $_students = array(); foreach ($students as $s) { $s['grades'] = $grades; $_students[] = $s; } $this->view->students = $_students; $this->view->group_id = $group_id; $this->view->target_id = $target_id; $this->view->level_id = $level_id; $this->view->game_id = $game_id; } }
public function deletestudentAction() { $studentID = $this->_request->getParam('s'); $groupID = $this->_request->getParam('g'); $students_DB = new Application_Model_DbTable_Student(); $id = $students_DB->getID($studentID, $_SESSION['Default']['field']); $student_DB = new Application_Model_DbTable_StudentsInField(); $data = array('groupID' => NULL); $student_DB->update($data, "id = {$id}"); $this->_redirect("/managegroups"); }
public function editstudentAction() { $studentID = $this->_request->getParam('s'); $student_DB = new Application_Model_DbTable_Student(); $student = $student_DB->get($studentID); $form = new Application_Form_AddStudent(array('studentname' => $student['name'], 'studentlastname' => $student['lastName'], 'gender' => $student['gender'], 'birthdate' => $student['birthDate'], 'fathername' => $student['fatherName'], 'fatherphone' => $student['fatherPhone'], 'mothername' => $student['motherName'], 'motherphone' => $student['motherPhone'], 'idnumber' => $student['idNumber'])); $this->view->form = $form; }
public function savegradeAction() { if ($this->getRequest()->isPost()) { $_params = $this->_request->getParams(); if ($_params['studentID'] && $_params['gradeID'] && $_params['gameID'] && $_params['groupID']) { $student_DB = new Application_Model_DbTable_Student(); $studentinfieldID = $student_DB->getID($_params['studentID'], $_SESSION['Default']['field']); $records_DB = new Application_Model_DbTable_Records(); //if record in this game already exists, delete and insert again $prev_record = $records_DB->isExists($studentinfieldID, $_params['gameID']); $isUpdate = false; if ($prev_record && isset($_SESSION['Default']['updateGrade'])) { $where['studentinfieldID = ?'] = $studentinfieldID; $where['gameID = ?'] = $_params['gameID']; $where['gradeID = ?'] = $prev_record['gradeID']; $where['date = ?'] = $prev_record['date']; try { $records_DB->delete($where); } catch (Exception $ex) { die(json_encode(array('status' => 'danger', 'msg' => $this->lang->_('FAILED_DOC')))); } $isUpdate = true; } $new_record = array('studentinfieldID' => $studentinfieldID, 'gameID' => $_params['gameID'], 'gradeID' => $_params['gradeID'], 'date' => date('Y-m-d H:i:s'), 'groupID' => $_params['groupID'], 'fieldID' => $_SESSION['Default']['field']); try { $doc_id = $records_DB->insert($new_record); $_SESSION['Default']['updateGrade'] = true; } catch (Exception $ex) { die(json_encode(array('status' => 'danger', 'msg' => $this->lang->_('FAILED_DOC')))); } if ($isUpdate) { die(json_encode(array('status' => 'success', 'msg' => $this->lang->_('SUCCESS_UPDATE')))); } else { die(json_encode(array('status' => 'success', 'msg' => $this->lang->_('SUCCESS_DOC')))); } } die(json_encode(array('status' => 'danger', 'msg' => $this->lang->_('FAILED_DOC')))); } }