<?php defined('SYSPATH') or die('No direct script access.');

class Model_Discipline extends Model
{
    /**
     * @param $id int discipline id
     * @return array data from <tt>view_disciplines</tt> table
     */
    public static function getInfo($id) {
        $sql = "CALL `GetDisciplineInfo`('$id'); ";
        return DB::query(Database::SELECT, $sql)->execute()->offsetGet(0);
    }

    /**
     * Get the disciplines's roadmap (учебная карта) for a student.
     * @param $discipline int subject id
     * @param $student int student id
     * @return Database_Result select from <tt>view_roadmap</tt> table
     */
    public static function getMap($discipline, $student) {
        $sql = "CALL `GetRates`('$student', '$discipline'); ";
        return DB::query(Database::SELECT, $sql)->execute();
    }
}