<?php
/**
 * This class has been auto-generated by the Doctrine ORM Framework
 */
class Kurz_behTable extends Doctrine_Table
{

    public function getIdKurzFromBeh($id){
        $q = Doctrine_Query::create()
              ->from('Kurz_beh u')
              ->where('u.kurz_id = '.$id);
       return $q;
    }

    public function getBehFromKurz($id){        
       $q = Doctrine_Query::create()
              ->from('Kurz_beh u')
              ->where('u.kurz_id = '.$id)
              ->andWhere("u.beh_od <= NOW()")
              ->andWhere("u.beh_do >= NOW()")
              ->limit("1");
       return $q;
    }

    public function getBehByDate($kurz_id,$date){
       $q = Doctrine_Query::create()
              ->from('Kurz_beh u')
              ->where('u.kurz_id = '.$kurz_id)
              ->andWhere("u.beh_od <= '".$date."'")
              ->andWhere("u.beh_do >= '".$date."'")
              ->limit("1");
       return $q;
    }

}