<?php
/**
 * This class has been auto-generated by the Doctrine ORM Framework
 */
class KurzTable extends Doctrine_Table
{
    public function getCurrentKurz($id){
      $q = Doctrine_Query::create()
              ->from('Kurz u')
              ->where('id = '.$id);
              
       return $q;
    }

    public function getCurrentKurzByBeh($id){
       $q = Doctrine_Query::create()
              ->from('Kurz_beh u')
              ->where('id = '.$id)
              ->orderBy("beh_do DESC")
              ->limit("1")
              ->execute();

       return $this->getCurrentKurz($q[0]->getKurzId());
    }

    public function getAllKurzOfPracovnik($id){
        return Doctrine_Query::create()
               ->select('k.*')
               ->from('Kurz k, Kurz_dochazka kd, Kurz_hodina kh, Kurz_beh kb')
               ->where('kd.pracovnik_id = '.$id)
               ->andWhere('kd.kurz_hodina_id = kh.id')
               ->andWhere('kh.kurz_beh_id = kb.id')
               ->andWhere('kb.kurz_id = k.id')
               ->groupBy('k.id');
    }

    public function saFormFilterTableMethod(Doctrine_Query $query)
    {
        $zakaznik = sfContext::getInstance()->getUser()->getAttribute('zakaznik');
        if (!$zakaznik instanceof Zakaznik)
        {
            throw new Exception('Nelze získat zákazníka.');
        }
        
        return $query->addWhere('zakaznik_id = ?', $zakaznik->getId());
    }
}