<?php
/**
 * This class has been auto-generated by the Doctrine ORM Framework
 */
class Kurz_hodinaTable extends Doctrine_Table
{
    public function getHodina($id){
        $pracovnik_list = Doctrine_Query::create()
              ->from('Kurz_hodina h')
              ->where('h.kurz_beh_id    = '.$id)
              ->orderBy('h.id DESC');

       return $pracovnik_list;
    }

    public function getHodinyKurzu($kurz_id) {
        return Doctrine_Query::create()
                ->select('*')
                ->from('Kurz_hodina kh')
                ->addFrom('Kurz_beh kb')
                ->where('kb.kurz_id = ?', $kurz_id)
                ->andWhere('kh.kurz_beh_id = kb.id')
                ->orderBy('kh.datum DESC');
    }


}