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