<?php

class planCheckerTask extends sfBaseTask
{
    protected function configure()
    {
        $this->addOptions(array(
            new sfCommandOption('application', null, sfCommandOption::PARAMETER_REQUIRED, 'The application name', 'zakaznik'),
            new sfCommandOption('env', null, sfCommandOption::PARAMETER_REQUIRED, 'The environment', 'dev'),
            new sfCommandOption('connection', null, sfCommandOption::PARAMETER_REQUIRED, 'The connection name', 'propel'),
        ));

        $this->namespace = '';
        $this->name = 'planChecker';
        $this->briefDescription = 'Skontroluje jestli plnění IPR';
        $this->detailedDescription = '';
    }

    protected function execute($arguments = array(), $options = array())
    {
        $databaseManager = new sfDatabaseManager($this->configuration);
        $connection = $databaseManager->getDatabase($options['connection'] ? $options['connection'] : null)->getConnection();
        
        $prs = Doctrine::getTable('PlanPracovnik')->createQuery('pr')
                ->addWhere('is_met = ?', false)
                ->addWhere('met_date < ?', date('Y-m-d'))
                ->execute();
        
        foreach($prs as $pr)
        {
            $plan = $pr->getPlan();
            $pracovnik = $pr->getPracovnik();
            
//            $mail['sendNow'] = true;
//            $mail['name'] = $pracovnik->getName();
//            $mail['email'] = $pracovnik->getEmail();
//            //$mail['email'] = 'vyskocil@klape.cz';
//            $mail['subject'] = '';
//            $mail['html'] = '';
//
//            $jnEmail = new jnEmailFront($mail);
            
            $this->log('Pracovník', $pracovnik->getName().' nesplnil plán '.$plan->getName().' v požadovaném termínu.');
        }
    }
}