PHP Course::all方法代码示例

 protected static function _init()
 {
     $session = Registry::get("session");
     if (!self::$_classroom) {
         if (!$session->get('StudentService:$classroom')) {
             $enrollment = \Enrollment::first(array("user_id = ?" => self::$_student->user_id), array("classroom_id"));
             $c = \Classroom::first(array("id = ?" => $enrollment->classroom_id), array("grade_id", "section", "year", "id", "created"));
             $g = \Grade::first(array("id = ?" => $c->grade_id), array("title", "id"));
             $classroom = array("id" => $c->id, "grade" => $g->title, "grade_id" => $g->id, "section" => $c->section, "year" => $c->year, "created" => $c->created);
             $classroom = ArrayMethods::toObject($classroom);
             $session->set('StudentService:$classroom', $classroom);
         }
         self::$_classroom = $session->get('StudentService:$classroom');
     }
     if (!self::$_courses) {
         if (!$session->get('StudentService:$courses')) {
             $courses = \Course::all(array("grade_id = ?" => self::$_classroom->grade_id));
             $subject = array();
             foreach ($courses as $c) {
                 $subject[$c->id] = $c;
             }
             $session->set('StudentService:$courses', $subject);
         }
         self::$_courses = $session->get('StudentService:$courses');
     }
 }

 public function profile($id)
 {
     $user = User::with('gender', 'course', 'userType')->where('StudentID', $id)->first();
     $courses = Course::all()->lists('CourseAbbr', 'CourseID');
     $genders = Gender::all()->lists('Gender', 'GenderID');
     return View::make('validated.profile.edit', compact('user', 'courses', 'genders'));
 }

 public static function sandbox()
 {
     // Testaa koodiasi täällä
     // echo 'Hello World!';
     // View::make('helloworld.html');
     $tali = Course::find(2);
     $courses = Course::all();
     Kint::dump($tali);
     Kint::dump($courses);
 }

 /**
  * @before _secure, _school
  */
 public function manage($grade_id)
 {
     $grade = \Grade::first(array("id = ?" => $grade_id), array("title", "id", "organization_id"));
     if (!$grade || $grade->organization_id != $this->organization->id) {
         self::redirect("/school");
     }
     $this->setSEO(array("title" => "School | Manage Subjects (Courses)"));
     $view = $this->getActionView();
     $courses = Course::all(array("grade_id = ?" => $grade_id));
     $view->set("courses", $courses);
     $view->set("grade", $grade);
 }

 /**
  * Checks if round is ready to be saved. If not, displays round edit page with information already inputted. If yes, attempts to update selected round and related scores.
  *
  * @param int $id Id of selected round.
  */
 public static function update($id)
 {
     $player = self::get_user_logged_in();
     if (!$player) {
         View::make('player/login.html', array('error' => 'Vain kirjautuneet käyttäjät voivat muokata ratoja.'));
     }
     $params = $_POST;
     $players = Player::all();
     $course = Course::find($params['course']);
     $courses = Course::all();
     $played = $params['played'];
     $round = Round::find($id);
     $holes = Hole::find_by_course($course->id);
     $scores = Score::find_by_round($id);
     $numberOfPlayers = sizeof($scores);
     if ($params['course'] != $params['course_orig']) {
         // If course selection has changed we need to display edit page again with new information.
         $playerScores = array();
         $numberOfHoles = Hole::count_holes($params['course_orig']);
         for ($i = 1; $i <= $numberOfPlayers; $i++) {
             $holeScores = array();
             for ($j = 1; $j <= $numberOfHoles; $j++) {
                 $holeScores[] = $params['p' . $i . '_h' . $j];
             }
             $playerScores[] = array('player' => Player::find($params['player_' . $i]), 'holes' => $holeScores);
         }
         View::make('round/edit.html', array('numberOfPlayers' => $numberOfPlayers, 'players' => $players, 'course' => $course, 'holes' => $holes, 'courses' => $courses, 'playerScores' => $playerScores, 'round' => $round, 'scores' => $scores, 'played' => $played));
     } else {
         $attributes = array('courseId' => $params['course'], 'played' => $params['played']);
         $playerScores = array();
         $numberOfHoles = Hole::count_holes($params['course_orig']);
         $round = new Round(array_merge(array("id" => $round->id), $attributes));
         $errors = $round->errors();
         if (count($errors) == 0) {
             $round->update();
             for ($i = 1; $i <= $numberOfPlayers; $i++) {
                 $holeScores = array();
                 $scoreId = $params['score_' . $i];
                 for ($j = 1; $j <= $numberOfHoles; $j++) {
                     $hole = Hole::find_by_course_and_holenumber($params['course_orig'], $j);
                     $holeScores[] = array('throws' => $params['p' . $i . '_h' . $j], 'holeId' => $hole->id, 'holenumber' => $j);
                 }
                 $score = new Score(array('id' => $scoreId, 'playerId' => $params['player_' . $i], 'roundId' => $round->id, 'scores' => $holeScores));
                 $score->update();
             }
             Redirect::to('/round/' . $round->id, array('message' => 'Kierrosta muokattu.'));
         } else {
             View::make('round/new.html', array('errors' => $errors, 'attributes' => $attributes));
         }
     }
 }

 public static function show($gameid)
 {
     $game = Game::find_format_gamedate($gameid);
     $games = array($game);
     View::make('game/show.html', array('games' => $games, 'courses' => Course::all()));
 }

 private function _findStudents()
 {
     $session = Registry::get("session");
     if (RequestMethods::post("action") == "findStudents") {
         $exam = RequestMethods::post("exam");
         preg_match("/(.*);(.*)/", $exam, $matches);
         $exam_type = $matches[1];
         $exam_year = $matches[2];
         $classroom_id = RequestMethods::post("classroom_id");
         $grade_id = RequestMethods::post("grade");
         $enrollments = Enrollment::all(array("classroom_id = ?" => $classroom_id));
         $exams = Exam::all(array("grade_id = ?" => $grade_id, "type = ?" => $exam_type), array("id", "grade_id", "course_id"));
         $courses = Course::all(array("organization_id = ?" => $this->organization->id), array("title", "id"));
         $arr = array();
         foreach ($courses as $c) {
             $arr["{$c->id}"] = $c->title;
         }
         $courses = array();
         foreach ($exams as $e) {
             $courses[] = array("title" => $arr["{$e->course_id}"], "id" => $e->course_id);
         }
         $courses = ArrayMethods::toObject($courses);
         $session->set('Exams\\Result:$exams', $exams);
         $session->set('Exams\\Result:$grade_id', $grade_id);
         return array("courses" => $courses, "exams" => $exams, "enrollments" => $enrollments);
     }
     return false;
 }

 public function index()
 {
     $courses = Course::all();
     $menu = 'project';
     return View::make('courses.index', compact('courses', 'menu'));
 }

 public static function index()
 {
     $courses = Course::all();
     View::make('course/index.html', array('courses' => $courses));
 }

 public static function list_courses()
 {
     $courses = Course::all();
     View::make('course/list.html', array('courses' => $courses));
 }

 /**
  * Attempts to update an edited users information.
  *
  * @param int $id Id of edited user.
  */
 public static function update($id)
 {
     $params = $_POST;
     if (!is_numeric($params['courseid'])) {
         $params['courseid'] = null;
     }
     $attributes = array('id' => $id, 'name' => $params['name'], 'courseId' => $params['courseid'], 'username' => $params['username'], 'password' => $params['new_password'], 'verify' => $params['password_verify'], 'newPassword' => strlen($params['new_password']) != 0);
     $player = new Player($attributes);
     $errors = $player->errors();
     if (Player::authenticate(self::get_user_logged_in()->username, $params['password']) == null) {
         $player = Player::find($id);
         $courses = Course::all();
         View::make('player/edit.html', array('errors' => $errors, 'attributes' => $attributes, 'player' => $player, 'courses' => $courses, 'error' => 'Väärä salasana tämänhetkiselle käyttäjälle.'));
     }
     if (count($errors) == 0) {
         $player->update();
         Redirect::to('/player', array('message' => 'Käyttäjän tietoja muutettu.'));
     } else {
         $player = Player::find($id);
         $courses = Course::all();
         View::make('player/edit.html', array('errors' => $errors, 'attributes' => $attributes, 'player' => $player, 'courses' => $courses));
     }
 }

 public function getMasterList()
 {
     $sql = "SELECT sm.*, cr.id AS course_id, cr.code AS course\n\t\t\t\tFROM student_master AS sm \n\t\t\t\tINNER JOIN course AS cr\n\t\t\t\tON sm.course_id = cr.id\n\t\t\t\tORDER BY last_name ASC";
     $master = DB::select($sql);
     $course = Course::all();
     return View::make('admin.master_list')->with('master', $master)->with('course', $course);
 }

 public function getSummaryEmploymentStatus()
 {
     // $test = $_GET['test'];
     // if($test == 1)
     // 	return '1';
     // else
     // 	return '2';
     $academic_years = array();
     $data = array();
     $program = array();
     $from = $_GET['from'];
     $to = $_GET['to'];
     $department = $_GET['department'];
     $emp_status = $_GET['emp_status'];
     $acad_in = 0;
     for ($i = $from; $i <= $to; $i++) {
         $academic_years[$acad_in] = $i;
         $acad_in++;
     }
     if ($department == 0) {
         $courses = Course::all();
         $i = 0;
         foreach ($courses as $crs) {
             $crs_id = $crs->id;
             $temp_data = array();
             $index = 0;
             for ($j = $from; $j <= $to; $j++) {
                 $sql = "SELECT tr.choice_id, COUNT(tr.choice_id) AS 'count'\n\t\t\t\t\t\t\tFROM alumni_tracer AS tr\n\t\t\t\t\t\t\tINNER JOIN alumni AS al\n\t\t\t\t\t\t\tON al.id = tr.alumni_id\n\t\t\t\t\t\t\tWHERE al.year_graduated = ? \n\t\t\t\t\t\t\tAND tr.choice_id = ? \n\t\t\t\t\t\t\tAND al.course_id = ?";
                 $result = DB::select($sql, array($j, $emp_status, $crs_id));
                 if ($result[0]->choice_id == null) {
                     $temp_data[$index] = 0;
                 } else {
                     $temp_data[$index] = $result[0]->count;
                 }
                 $index++;
             }
             $program[$i] = $crs->code;
             $data[$i] = $temp_data;
             $i++;
         }
     } else {
         $courses = DB::select("SELECT * FROM course WHERE dept_id = ?", array($department));
         $i = 0;
         foreach ($courses as $crs) {
             $crs_id = $crs->id;
             $temp_data = array();
             $index = 0;
             for ($j = $from; $j <= $to; $j++) {
                 $sql = "SELECT tr.choice_id, COUNT(tr.choice_id) AS 'count'\n\t\t\t\t\t\t\tFROM alumni_tracer AS tr\n\t\t\t\t\t\t\tINNER JOIN alumni AS al\n\t\t\t\t\t\t\tON al.id = tr.alumni_id\n\t\t\t\t\t\t\tWHERE al.year_graduated = ? \n\t\t\t\t\t\t\tAND tr.choice_id = ? \n\t\t\t\t\t\t\tAND al.course_id = ?";
                 $result = DB::select($sql, array($j, $emp_status, $crs_id));
                 if ($result[0]->choice_id == null) {
                     $temp_data[$index] = 0;
                 } else {
                     $temp_data[$index] = $result[0]->count;
                 }
                 $index++;
             }
             $program[$i] = $crs->code;
             $data[$i] = $temp_data;
             $i++;
         }
     }
     return View::make('analytics.summary_employment')->with('academic_years', $academic_years)->with('program', $program)->with('data', $data);
     // return json_encode($academic_years);
 }

 public static function display_score_card_pictures_by_year($year)
 {
     $full_path = getcwd();
     $path = str_replace("/disc-golf-stats/app/controllers", "", $full_path);
     $path = str_replace("/xamppfiles", "", $path);
     $echo = ImageDisplayer::display($path . "/score_cards", $year);
     View::make('game/score_card_images.html', array('current_year' => $year, 'images' => $echo, 'players' => Player::all(), 'courses' => Course::all(), 'game_years' => Game::game_years()));
 }

 public function filters($offset = 0)
 {
     $string = '%' . $this->input->post('curso') . '%';
     $c = $this->input->post('level_id');
     $div = $this->input->post('division_id');
     $condiciones = '';
     $valores = array();
     if ($string != '%%') {
         $condiciones .= " course LIKE ?";
         $valores['curso'] = $string;
     }
     if ($div > 0) {
         if ($condiciones != '') {
             $condiciones .= " AND ";
         }
         $condiciones .= " division_id = ?";
         $valores['div'] = $div;
     }
     if ($c > 0) {
         if ($condiciones != '') {
             $condiciones .= " AND ";
         }
         $condiciones .= " level_id = ?";
         $valores['nivel'] = $c;
     }
     $this->session->set_userdata('filtros_cursos', $valores);
     $conditions = array_merge(array($condiciones), $valores);
     $config['base_url'] = site_url('cursos/index');
     $config['total_rows'] = Course::count(array('joins' => array('level', 'division'), 'conditions' => $conditions));
     $config['per_page'] = '10';
     $config['num_links'] = '10';
     $config['first_link'] = '← primero';
     $config['last_link'] = 'último →';
     $this->load->library('pagination', $config);
     $cursos = Course::all(array('joins' => array('level', 'division'), 'conditions' => $conditions, 'limit' => $config['per_page'], 'offset' => $offset));
     $this->table->set_heading('Curso', 'División', 'Nivel', 'Acciones');
     foreach ($cursos as $curso) {
         $this->table->add_row($curso->course, $curso->division->division, $curso->level->descripcion, anchor('cursos/editar/' . $curso->id, img('static/img/icon/pencil.png'), 'class="tipwe" title="Editar"') . ' ' . anchor('cursos/eliminar/' . $curso->id, img('static/img/icon/trash.png'), 'class="tipwe eliminar" title="Eliminar"'));
     }
     echo $this->table->generate();
     echo '<div class="pagination">';
     echo $this->pagination->create_links();
     echo '</div>';
 }