<?php

class jobsComponents extends sfComponents
{
    public function executeCreateJobMailBody()
    {
        $this->job = $this->getVar('job');
        $this->page = Doctrine::getTable('Page')->findOneById(5);
    }

    public function executeExpirationJobMailBody()
    {
        $this->job = $this->getVar('job');
        $this->page = Doctrine::getTable('Page')->findOneById(9);
    }

    public function executeTop()
    {
        $this->topJob = Doctrine::getTable('TopJob')->getTopJobNow();
        if($this->topJob)
        {
            $this->job = $this->topJob->getJob();
        }
    }

    public function executeLasts()
    {
        $this->jobs = Doctrine::getTable('Job')->getValidTimeQuery()
                        ->addWhere('is_active = ? OR valid_from <= ?' , array(true, date('Y-m-d', strtotime('+'.saSettings::get('job_tmp_valid_days', 0).' days'))))
                        ->addWhere('type_id = ?', JobType::OFFER)
                        ->orderBy('valid_from DESC')
                        ->limit(7)
                        ->execute();
    }
}