<?php
/**
 * This class has been auto-generated by the Doctrine ORM Framework
 */
class PlanTable extends Doctrine_Table
{
    public function getPracovniciWithPlanQuery(Plan $plan, $level = null)
    {
        $query = Doctrine::getTable('Pracovnik')->createQuery('p')
                ->innerJoin('p.PlanRelations pr')
                ->addWhere('pr.plan_id = ?', $plan->getId());
        
        if(is_null($level))
        {
            $query->addWhere('pr.level_id = ?', $level->getId());
        }
        
        return $query;
    }
}