public function planAction() { $group_id = $this->_request->getParam('g'); $target_id = $this->_request->getParam('t'); $level_id = $this->_request->getParam('l'); $game_id = $this->_request->getParam('gm'); if ($group_id && $target_id && $level_id && $game_id) { $plan_DB = new Application_Model_DbTable_Planing(); $new_plan = array('group_id' => $group_id, 'target_id' => $target_id, 'level_id' => $level_id, 'game_id' => $game_id, 'create_date' => time()); try { $plan_id = $plan_DB->insert($new_plan); $plans = $plan_DB->getAll($plan_id); $this->view->plan_id = $plan_id; $this->view->plans = $plans; } catch (Exception $ex) { die(json_encode(array('status' => 'danger', 'msg' => $this->lang->_('FAILED_DOC')))); } } }
public function planAction() { $group_id = $this->_request->getParam('g'); $target_id = $this->_request->getParam('t'); $game_id = $this->_request->getParam('gm'); if ($group_id && $target_id && $game_id) { $plan_DB = new Application_Model_DbTable_Planing(); //date_default_timezone_set('Asia/Jerusalem'); $new_plan = array('groupID' => $group_id, 'gameID' => $game_id, 'date' => date('Y-m-d H:i:s'), 'fieldID' => $_SESSION['Default']['field']); try { $plan_id = $plan_DB->insert($new_plan); $plans = $plan_DB->getAll($plan_id); $this->view->plan_id = $plan_id; $this->view->plans = $plans; $this->_redirect('/groups/group/g/' . $group_id . '/t/' . $target_id . '/gm/' . $game_id); } catch (Exception $ex) { die(json_encode(array('status' => 'danger', 'msg' => $this->lang->_('FAILED_DOC')))); } $groups_DB = new Application_Model_DbTable_Group(); $this->view->groupName = $groups_DB->getName($group_id); } }
public function recommend() { $group_id = $this->_request->getParam('g'); $plans_DB = new Application_Model_DbTable_Planing(); $last_plan = $plans_DB->getLastPlan($group_id, $_SESSION['Default']['field']); if ($last_plan) { $target_id = $last_plan['goal_id']; $game_id = $last_plan['game_id']; $related_plan_id = $last_plan['planID']; $targets_DB = new Application_Model_DbTable_Target(); $target_level = $targets_DB->getGoalLevel($target_id); settype($target_level, "integer"); $records_DB = new Application_Model_DbTable_Records(); $records = $records_DB->getAll($group_id, $game_id); $count_1 = 0; $count_2 = 0; $count_3 = 0; $count_4 = 0; foreach ($records as $r) { $grade = $r['grade_value']; settype($grade, "integer"); if ($grade == 1) { $count_1++; } else { if ($grade == 2) { $count_2++; } else { if ($grade == 3) { $count_3++; } else { if ($grade == 4) { $count_4++; } } } } } $num_of_students = count($records); $continue_childrenless = false; $students_DB = new Application_Model_DbTable_StudentsInField(); $real_num_of_students = count($students_DB->getAll($group_id)); if ($num_of_students < $real_num_of_students) { $continue_childrenless = true; } $num_of_levels = count($targets_DB->getLevels()); //current target $recommended_target = $target_id; $recommendation = $this->lang->_('RECOMMEND_CURRENT_LEVEL'); if ($num_of_students > 2 && $count_1 >= $num_of_students / 2 || $num_of_students == 1 && $count_1 == 1 || $num_of_students == 2 && ($count_1 == 2 || $count_1 == 1 && $count_2 == 1)) { //return to a game from prev goal if ($target_level > 1) { $target_level = $target_level - 1; $recommended_target = $targets_DB->getAllByLevel($target_level, $_SESSION['Default']['field']); $recommendation = $this->lang->_('RECOMMEND_PREV_LEVEL'); } } else { if ($num_of_students > 2 && $count_4 >= $num_of_students - 1 || $num_of_students == 1 && $count_4 == 1 || $num_of_students == 2 && ($count_4 == 2 || $count_4 == 1 && $count_3 == 1)) { $unlearned_targets = $targets_DB->getUnlearnedInLevel($target_level, $group_id, $_SESSION['Default']['field']); //next target in current level if (count($unlearned_targets) > 0) { $recommended_target = $unlearned_targets[0]['goalID']; $recommendation = $this->lang->_('RECOMMEND_NEXT_LEVEL'); } else { if ($target_level < $num_of_levels) { $target_level = $target_level + 1; $recommended_target = $targets_DB->getAllByLevel($target_level, $_SESSION['Default']['field']); $recommendation = $this->lang->_('RECOMMEND_NEXT_LEVEL'); } } } } $games_DB = new Application_Model_DbTable_Game(); settype($recommended_target, "integer"); $unplayed_games = $games_DB->getGamesNotPlayed($group_id, $recommended_target); //check if all games were played if (count($unplayed_games) == 0) { $recommended_game = $games_DB->getRandomGame($recommended_target); } else { $recommended_game = $unplayed_games[0]; } $recommended_target_name = $targets_DB->getGoalName($recommended_target); $this->view->recommended_target = $recommended_target_name; $this->view->recommendation = $recommendation; $this->view->recommended_game = $recommended_game['name']; //insert to DB as last plan $plan_DB = new Application_Model_DbTable_Planing(); $new_plan = array('groupID' => $group_id, 'gameID' => $recommended_game['gameID'], 'date' => date('Y-m-d H:i:s'), 'recommendation' => $recommendation, 'relatedPlanID' => $related_plan_id, 'fieldID' => $_SESSION['Default']['field']); try { $plan_id = $plan_DB->insert($new_plan); } catch (Exception $ex) { die(json_encode(array('status' => 'danger', 'msg' => $this->lang->_('FAILED_DOC')))); } //return json to ajax $this->getHelper('Layout')->disableLayout(); $this->getHelper('ViewRenderer')->setNoRender(); echo json_encode(array('recommendation' => $recommendation, 'recommended_game' => $recommended_game['name'], 'recommended_target' => $recommended_target_name, 'continue_childrenless' => $continue_childrenless)); } }