<?php defined('SYSPATH') or die('No direct script access.');
  
class Model_Teacher_Map extends Model
{
    public function getMapForDiscipline($teacherID, $disciplineID)
    {
        $sql = "CALL `GetMapForDiscipline`('$teacherID', '$disciplineID'); ";
        return DB::query(Database::SELECT, $sql)->execute();
    }
    
    public function addModule($teacherID, $disciplineID, $order, $title)
    {
        $sql = "SELECT `AddModule`('$teacherID', '$disciplineID', '$order', '$title') AS `Num`;";
        return DB::query(Database::SELECT, $sql)->execute();
    }    
    
    public function deleteModule($teacherID, $moduleID)
    {
		$sql = "SELECT `DeleteModule`('$teacherID', '$moduleID') AS `Num`;";
        //$sql = "CALL `DeleteModule`('$teacherID', '$moduleID'); ";
		return DB::query(Database::SELECT, $sql)->execute();
    }
	
    public function ChangeModuleName($teacherID, $moduleID, $Name)
    {
        $sql = "SELECT `ChangeModuleName`('$teacherID', '$moduleID', '$Name') AS `Num`;";
        return DB::query(Database::SELECT, $sql)->execute();
    }
	
    public function addSubmodule($teacherID, $moduleID, $maxRate, $order, $title, $description, $typeControl)
    {
        $sql = "SELECT `AddSubmodule`('$teacherID', '$moduleID', '$maxRate', '$order', '$title', '$description', '$typeControl') AS `Num`;";
        return DB::query(Database::SELECT, $sql)->execute();
    }
	
    public function deleteSubmodule($teacherID, $submoduleID)
    {
        $sql = "SELECT `DeleteSubmodule`('$teacherID', '$submoduleID') AS `Num`;";
        return DB::query(Database::SELECT, $sql)->execute();
    }
	
    public function changeSubmoduleName($teacherID, $submoduleID, $Name)
    {
        $sql = "SELECT `ChangeSubmoduleName`('$teacherID', '$submoduleID', '$Name') AS `Num`;";
        return DB::query(Database::SELECT, $sql)->execute();
    }
	
    public function changeModule($teacherID, $moduleID, $order, $title)
    {
        $sql = "SELECT `ChangeModule`('$teacherID', '$moduleID', '$order', '$title') AS `Num`;";
        return DB::query(Database::SELECT, $sql)->execute();
    }
    
    public function changeSubmodule($teacherID, $submoduleID, $maxRate, $order, $title, $description)
    {
        $sql = "SELECT `ChangeSubmodule`('$teacherID', '$submoduleID', '$maxRate', '$order', '$title', '$description') AS `Num`;";
        return DB::query(Database::SELECT, $sql)->execute();
    }
	
    public function getDisciplineInfoByID($discipline_id)
    {
        $sql = "CALL `GetDisciplineInfoByID`('$discipline_id'); ";
        return DB::query(Database::SELECT, $sql)->execute();
    }
    
    public function getTeachersForDiscipline($discipline_id)
    {
        $sql = "CALL `GetTeachersForDiscipline`('$discipline_id'); ";
        return DB::query(Database::SELECT, $sql)->execute();
    }        
}