Subjects.php

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

class Model_Subjects
{
    public static function create() {
        return new self();
    }

    public function getSubjects($facultyID) {
        $sql = "CALL `GetSubjects`('$facultyID');";
        return DB::query(Database::SELECT, $sql)->execute();
    }

    public function byFaculty($FacultyID) {
        $subjects = $this->getSubjects($FacultyID);

        $list = array();
        foreach ($subjects as $row) {
            $row['Title'] = $row['Name'];
            $list[] = $row;
        }
        
        return new DataArray_Result($list);
    }
}