<?php
/**
 * This class has been auto-generated by the Doctrine ORM Framework
 */
class Kurz_dochazkaTable extends Doctrine_Table
{
    public function getAllDochazka($id){
        $q   = Doctrine_Query::create()
              ->from('Kurz_dochazka d')
              ->where('d.kurz_hodina_id    = '.$id);

        return $q;
    }
    public function getPresentPersons($id){
        $q   = Doctrine_Query::create()
              ->from('Kurz_dochazka d')
              ->where('d.kurz_hodina_id    = '.$id)
              ->andWhere("d.stav = 'A' ");

        return $q;
    }

    public function getDochazkaFromPracovnik($pracovnik){
         $q   = Doctrine_Query::create()
              ->from('Kurz_dochazka d')
              ->Where('d.pracovnik_id   = '.$pracovnik);

        return $q;
    }

    public function getDochazkaFromPracovnikA($pracovnik){
         $q   = Doctrine_Query::create()
              ->from('Kurz_dochazka d')
              ->Where('d.pracovnik_id   = '.$pracovnik)
              ->andWhere("d.stav = 'A'");
        return $q;
    }

    public function getCurrentDochazkaWithPracovnik($pracovnik,$id){
        $q   = Doctrine_Query::create()
              ->from('Kurz_dochazka d')
              ->where('d.kurz_hodina_id    = '.$id)
              ->andWhere('d.pracovnik_id    = '.$pracovnik)
              ->limit("1");
              //->execute();
              
        return $q;
    }

    public function getHodinaByBeh($id_pracovnik,$id_beh){
        $q   = Doctrine_Query::create()
              ->from('Kurz_dochazka d')
              ->where('d.kurz_hodina_id    = '.$id_beh)
              ->andWhere('d.pracovnik_id   = '.$id_pracovnik)
              ->andWhere("d.stav = 'A' ");

        return $q;
    }


}