<?php // vim: set binary noeol et sts=4 sw=4 :

require_once 'DB.php';
require_once 'DB/DataObject.php';

class T_DBO_Docente extends DB_DataObject
{
    var $_database = 'taller';
    var $__table = 'docente';
    var $id;
    var $nombre;
    var $mail;
    var $corrige;

    /* Static get */
    function staticGet($k, $v = NULL)
    {
        return DB_DataObject::staticGet('T_DBO_Docente', $k, $v);
    }

    // now define your table structure.
    // key is column name, value is type
    function table()
    {
        return array(
            'id'        => DB_DATAOBJECT_INT,
            'nombre'    => DB_DATAOBJECT_STR,
            'mail'      => DB_DATAOBJECT_STR,
            'corrige'   => DB_DATAOBJECT_INT + DB_DATAOBJECT_BOOL,
        );
    }

    // now define the keys.
    function keys()
    {
        return array('id');
    }

    /**
     *
     * @return array Cursos en los que está el docente.
     */
    function getCursos($activo = true)
    {
        $c = DB_DataObject::factory('curso');
        if ($activo)
        {
            $c->anio = date('Y');
            $c->cuatrimestre = (date('n') < 8) ? 1 : 2; // Hasta agosto es 1er cuat
        }
        $cd = DB_DataObject::factory('curso_docente');
        $cd->selectAs();
        $cd->joinAdd($c);
        $cd->joinAdd($this);
        $cd->find();
        $ret = array();
        while ($cd->fetch())
        {
            $c->get($cd->curso_id);
            $ret[] = $c;
        }
        return $ret;
    }

}

?>