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 updategoalAction() { $request = $this->getRequest(); $goal_data = $request->getPost(); $goal_DB = new Application_Model_DbTable_Target(); $goalID_parent = $this->_request->getParam('gp'); $goalID = $this->_request->getParam('g'); $grade_DB = new Application_Model_DbTable_Grade(); if ($_FILES["photo"]["name"] && !$goalID_parent) { if (isset($_FILES["photo"]["error"])) { if ($_FILES["photo"]["error"] > 0) { $this->msger->addMessage('<div class="alert alert-danger text-center" role="alert"><button type="button" class="close" data-dismiss="alert">×</button>' . $_FILES["photo"]["error"] . '</div>'); $this->_redirect('/admin/editgoal/g/' . $goalID . '/gp/' . $goalID_parent); } else { $allowed = array("jpg" => "image/jpg", "jpeg" => "image/jpeg", "gif" => "image/gif", "png" => "image/png"); $filename = $_FILES["photo"]["name"]; $filetype = $_FILES["photo"]["type"]; $filesize = $_FILES["photo"]["size"]; // Verify file extension $ext = pathinfo($filename, PATHINFO_EXTENSION); if (!array_key_exists($ext, $allowed)) { $this->msger->addMessage('<div class="alert alert-danger text-center" role="alert"><button type="button" class="close" data-dismiss="alert">×</button>' . $this->lang->_('FILE_WRONG_FORMAT') . '</div>'); $this->_redirect('/admin/editgoal/g/' . $goalID . '/gp/' . $goalID_parent); } // Verify file size - 5MB maximum $maxsize = 5 * 1024 * 1024; if ($filesize > $maxsize) { $this->msger->addMessage('<div class="alert alert-danger text-center" role="alert"><button type="button" class="close" data-dismiss="alert">×</button>' . $this->lang->_('FILE_SIZE_LIMIT') . '</div>'); $this->_redirect('/admin/editgoal/g/' . $goalID . '/gp/' . $goalID_parent); } // Verify MYME type of the file if (in_array($filetype, $allowed)) { // Check whether file exists before uploading it if (!file_exists($this->config->paths->upload->goals . $_FILES["photo"]["name"])) { move_uploaded_file($_FILES["photo"]["tmp_name"], $this->config->paths->upload->goals . $_FILES["photo"]["name"]); } } else { $this->msger->addMessage('<div class="alert alert-danger text-center" role="alert"><button type="button" class="close" data-dismiss="alert">×</button>' . $this->lang->_('FILE_ERROR') . '</div>'); $this->_redirect('/admin/editgoal/g/' . $goalID . '/gp/' . $goalID_parent); } } } else { $this->msger->addMessage('<div class="alert alert-danger text-center" role="alert"><button type="button" class="close" data-dismiss="alert">×</button>' . $this->lang->_('FILE_ERROR') . '</div>'); $this->_redirect('/admin/editgoal/g/' . $goalID . '/gp/' . $goalID_parent); } } $goalName = trim($goal_data['goalName']); if (!strlen($goalName)) { $this->msger->addMessage('<div class="alert alert-danger text-center" role="alert"><button type="button" class="close" data-dismiss="alert">×</button>' . $this->lang->_('REQUIRED_GOAL_NAME') . '</div>'); $this->_redirect('/admin/editgoal/g/' . $goalID . '/gp/' . $goalID_parent); } $goalLevel = trim($goal_data['goalLevel']); if ($goalID_parent) { if (!strlen($goalLevel)) { $this->msger->addMessage('<div class="alert alert-danger text-center" role="alert"><button type="button" class="close" data-dismiss="alert">×</button>' . $this->lang->_('REQUIRED_GOAL_LEVEL') . '</div>'); $this->_redirect('/admin/editgoal/g/' . $goalID . '/gp/' . $goalID_parent); } else { if (!is_numeric($goal_data['goalLevel'])) { $this->msger->addMessage('<div class="alert alert-danger text-center" role="alert"><button type="button" class="close" data-dismiss="alert">×</button>' . $this->lang->_('REQUIRED_GOAL_LEVEL_INT') . '</div>'); $this->_redirect('/admin/editgoal/g/' . $goalID . '/gp/' . $goalID_parent); } } $grade1 = trim($goal_data['grade1']); $grade2 = trim($goal_data['grade2']); $grade3 = trim($goal_data['grade3']); $grade4 = trim($goal_data['grade4']); if (!strlen($grade1) || !strlen($grade2) || !strlen($grade3) || !strlen($grade4)) { $this->msger->addMessage('<div class="alert alert-danger text-center" role="alert"><button type="button" class="close" data-dismiss="alert">×</button>' . $this->lang->_('REQUIRED_GRADE_NAME') . '</div>'); $this->_redirect('/admin/editgoal/g/' . $goalID . '/gp/' . $goalID_parent); } $updated_goal = array('goalID_parent' => $goalID_parent, 'name' => $goal_data['goalName'], 'level' => $goalLevel, 'fieldID' => $_SESSION['Default']['field']); } else { $goalLevel = 0; if ($_FILES["photo"]["name"]) { //icon selected $updated_goal = array('name' => $goal_data['goalName'], 'icon' => $_FILES["photo"]["name"]); } else { $updated_goal = array('name' => $goal_data['goalName']); } } try { $where_goal = $goal_DB->getAdapter()->quoteInto('goalID = ?', $goalID); $goal_DB->update($updated_goal, $where_goal); } catch (Exception $ex) { die(json_encode(array('status' => 'danger', 'msg' => $ex->getMessage()))); } if ($goalID_parent) { $new_grade1 = array('goalID' => $goalID, 'name' => $goal_data['grade1'], 'value' => 1); $new_grade2 = array('goalID' => $goalID, 'name' => $goal_data['grade2'], 'value' => 2); $new_grade3 = array('goalID' => $goalID, 'name' => $goal_data['grade3'], 'value' => 3); $new_grade4 = array('goalID' => $goalID, 'name' => $goal_data['grade4'], 'value' => 4); try { $where_grade1['goalID = ?'] = $goalID; $where_grade1['value = ?'] = 1; $grade_DB->update($new_grade1, $where_grade1); $where_grade2['goalID = ?'] = $goalID; $where_grade2['value = ?'] = 2; $grade_DB->update($new_grade2, $where_grade2); $where_grade3['goalID = ?'] = $goalID; $where_grade3['value = ?'] = 3; $grade_DB->update($new_grade3, $where_grade3); $where_grade4['goalID = ?'] = $goalID; $where_grade4['value = ?'] = 4; $grade_DB->update($new_grade4, $where_grade4); } catch (Exception $ex) { die(json_encode(array('status' => 'danger', 'msg' => $ex->getMessage()))); } } if ($goalID_parent) { $this->_redirect("/admin/subgoals/g/" . $goalID_parent); } else { $this->_redirect("/admin/goals"); } }
public function studentsAction() { $group_id = $this->_request->getParam('g'); $target_id = $this->_request->getParam('t'); $game_id = $this->_request->getParam('gm'); $is_recommend = $this->_request->getParam('recommend'); //Return After Planining if ($group_id && $target_id) { $student_DB = new Application_Model_DbTable_StudentsInField(); $grade_DB = new Application_Model_DbTable_Grade(); $students = $student_DB->getAll($group_id); $grades = $grade_DB->getAll($target_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->game_id = $game_id; $groups_DB = new Application_Model_DbTable_Group(); $this->view->groupName = $groups_DB->getName($group_id); } else { $plans_DB = new Application_Model_DbTable_Planing(); $last_plan = $plans_DB->getLastPlan($group_id, $_SESSION['Default']['field']); if ($last_plan) { $group_id = $last_plan['groupID']; $target_id = $last_plan['goal_id']; $game_id = $last_plan['game_id']; $student_DB = new Application_Model_DbTable_StudentsInField(); $grade_DB = new Application_Model_DbTable_Grade(); $students = $student_DB->getAll($group_id); $grades = $grade_DB->getAll($target_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->game_id = $game_id; $groups_DB = new Application_Model_DbTable_Group(); $this->view->groupName = $groups_DB->getName($group_id); } else { $this->view->group_id = $group_id; $groups_DB = new Application_Model_DbTable_Group(); $this->view->groupName = $groups_DB->getName($group_id); } } $games_DB = new Application_Model_DbTable_Game(); $this->view->gameName = $games_DB->getGameName($game_id); $notes = $this->getRequest()->getPost('notes'); if ($notes) { $comments_DB = new Application_Model_DbTable_Comments(); $new_comment = array('groupID' => $group_id, 'gameID' => $game_id, 'date' => date('Y-m-d H:i:s'), 'text' => $notes, 'fieldID' => $_SESSION['Default']['field']); try { $comment_id = $comments_DB->insert($new_comment); } catch (Exception $ex) { die(json_encode(array('status' => 'danger', 'msg' => $this->lang->_('FAILED_DOC')))); } } if ($is_recommend) { $this->recommend(); } }