<?php
/**
 * This class has been auto-generated by the Doctrine ORM Framework
 */
class PracovnikTable extends Doctrine_Table
{
    public function getNonKurz($id,$id_zakaznik){
        $arg = array();
        $count = count($this->getKurz($id)->execute());
        if($count >0){
            foreach($this->getKurz($id)->execute() as $prac_tmp):
                $arg[] = 'p.id !='.$prac_tmp->getId();
            endforeach;
        }
        
        $this->pracovnik_list = Doctrine_Query::create()
             ->select('p.*')
             ->from('Pracovnik p')
             ->where('p.zakaznik_id = '.$id_zakaznik)
             ->orderBy('p.prijmeni');

        if($count > 0) $this->pracovnik_list = $this->pracovnik_list->andWhere(implode(" AND ",$arg));
        // $this->pracovnik_list = $this->pracovnik_list->groupBy('p.id');

        
       return $this->pracovnik_list;
    }

    public function getKurz($id){
       $this->pracovnik_list = Doctrine_Query::create()
              ->select('p.*')
              ->from('Pracovnik p')
              ->leftJoin('Pracovnik_kurz k')
              ->where('k.pracovnik_id = p.id')
              ->andWhere('k.kurz_id = '.$id)
              ->orderBy('p.prijmeni')
              ->groupBy('p.id');
       
       return $this->pracovnik_list;
    }

    public function getCurrentPracovnik($id){
        $q = Doctrine_Query::create()
              ->from('Pracovnik u')
              ->where('id = '.$id);

       return $q;
    }

    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());
    }
}