<?php

/**
 * This class has been auto-generated by the Doctrine ORM Framework
 */
class Zakaznik extends BaseZakaznik
{
    public function  __toString() {
        return $this->get('nazev');
    }

    public function getEmailWarningRozpocet(){
        $pracObject = new Pracovnik();
        $pracovnici = "";
        $arg        = array();


        $zakaznici = Doctrine::getTable('Zakaznik')->createQuery("a")->execute();
        foreach($zakaznici as $zakaznik):
            $pomocnik   =  Doctrine::getTable('Pomocnici_personalisty')->createQuery('u')->where("u.zakaznik_id = ".$zakaznik->getId())->execute();
            $rozpocet_a = $pomocnik[0]->getMinHraniceA();

            if(empty($rozpocet_a)):
                $pracovnici = $pracObject->getError("getErrorPracovniciRozpocet",$zakaznik->getId());
                if(!empty($pracovnici)){
                    foreach($pracovnici as $pracovnik):
                        $arg[] = $pracovnik;
                     endforeach;
                }
                if(!empty($arg)){
                    $mail['name']    = $zakaznik->getNazev();
                    $mail['sendNow'] = 1;
                    $mail['subject'] = $zakaznik->getNazev()." překročení rozpočtu zákazníka";
                    $mail['html']    = "";

                    foreach($zakaznik->Personalista_list as $personalista):
                        $mail['email']   =  $personalista->getEmail();

                        foreach($arg as $a):
                            $mail['html'] .= "Pracovník ".$a->Pracovnik->getPrijmeni()." ".$a->Pracovnik->getJmeno()." se blíží vyčerpání svého rozpočtu na vzdělávání .";
                        endforeach;

                        new jnEmailFront($mail);
                    endforeach;
                }
            endif;
        endforeach;

    }

    public function getEmailWarningDochazka(){
        $pracObject = new Pracovnik();
        $pracovnici = "";
        $arg        = array();


        $zakaznici = Doctrine::getTable('Zakaznik')->createQuery("a")->execute();
        foreach($zakaznici as $zakaznik):
            $pomocnik   =  Doctrine::getTable('Pomocnici_personalisty')->createQuery('u')->where("u.zakaznik_id = ".$zakaznik->getId())->execute();
            $dochazka_a = $pomocnik[0]->getMinDochazkaA();

            if(empty($dochazka_a)):
                $pracovnici = $pracObject->getError("getErrorPracovniciDochazka",$zakaznik->getId());
                if(!empty($pracovnici)){
                    foreach($pracovnici as $pracovnik):
                        $arg[] = $prcovnik;
                     endforeach;
                }

                if(!empty($arg)){
                    $mail['name']    = $zakaznik->getNazev();
                    $mail['sendNow'] = 1;
                    $mail['subject'] = "Problémy s docházkou";
                    $mail['html']    = "";

                    foreach($zakaznik->Personalista_list as $personalista):
                        $mail['email']   =  $personalista->getEmail();

                        foreach($arg as $a):
                            $mail['html'] .= $a['pracovnik'];
                            $mail['html'] .= $a['kurz'].' '.$a['prumer'];
                        endforeach;

                        new jnEmailFront($mail);
                    endforeach;
                }
            endif;
        endforeach;
    }

    /**
     * Vrátí datum aktuální závory hodin pro agentury nebo null.
     *
     * @return string
     */
    public function getZavoraAgentury()
    {
        $zavora = Doctrine::getTable('Zavora')->createQuery()
                ->addWhere('zakaznik_id = ?', $this->getId())
                ->orderBy('created_at DESC')
                ->fetchOne();

        if($zavora instanceof Zavora)
        {
            return $zavora->getDatum();
        }

        return null;
    }

    public function setZavoraAgentury($datum)
    {
        if(strtotime($this->getZavoraAgentury()) != strtotime($datum))
        {
            $zavora = new Zavora();
            $zavora->setZakaznikId($this->getId());
            $zavora->setDatum(date('Y-m-d', strtotime($datum)));
            $zavora->save();
        }
    }

    public function fullDelete()
    {
        Doctrine::getTable('Pracovnik')->setOption('ignore_archive', true);
        foreach($this->getPracovnik_list() as $pracovnik)
        {
            $pracovnik->fullDelete();
        }

        Doctrine::getTable('Kurz')->setOption('ignore_archive', true);
        foreach($this->getKurz_list() as $kurz)
        {
            $kurz->fullDelete();
        }

        foreach($this->getPersonalista_list() as $personalista)
        {
            $personalista->fullDelete();
        }

        Doctrine::getTable('Agentura')->setOption('ignore_archive', true);
        foreach($this->getAgentury() as $agentura)
        {
            $agentura->fullDelete();
        }

        foreach($this->getDotaznik_list() as $dotaznik)
        {
            $dotaznik->fullDelete();
        }

        foreach($this->getFullTestZakaznikList() as $tz)
        {
            $tz->fullDelete();
        }

        foreach($this->getVlny() as $v)
        {
            $v->delete();
        }
        
        foreach($this->getSpecifikaceKurzList() as $sp)
        {
            $sp->delete();
        }

        foreach($this->getPomocnici_personalisty_list() as $pp)
        {
            $pp->delete();
        }

        foreach($this->getMistnost_list() as $m)
        {
            $m->delete();
        }

        foreach($this->getModuly_zakaznik_list() as $m)
        {
            $m->delete();
        }
        
        foreach($this->getSpecifikacePracovniku() as $s)
        {
            $s->delete();
        }

        $this->delete();
    }

    public function getSpecifikaceKurzList()
    {
        return Doctrine::getTable('Specifikace_kurzu')->createQuery()
                ->addWhere('zakaznik_id = ?', $this->getId())
                ->execute();
    }

    public function getFullTestZakaznikList()
    {   
        $table = Doctrine::getTable('Test_zakaznik');
        $table->getConnection()->setAttribute('use_dql_callbacks', false);
        return $table->findByZakaznikId($this->getId());
    }

    /**
     *
     * @return Doctrine_Query
     */
    public function getDocumentEventsYesterdayQuery()
    {
        $today = date('Y-m-d');
        $yesterday = date('Y-m-d', strtotime('-1 day'));

        return Doctrine::getTable('DocumentEvent')->createQuery()
                ->addWhere('zakaznik_id = ?', $this->getId())
                ->addWhere('created_at >= ? AND created_at < ?', array($yesterday, $today))
                ->orderBy('created_at ASC');
    }
}