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'))));
}
}
