<?php

namespace App\Job;

class Obj extends AbstractObj
{
    protected $_filterFields = array('title', 'company', 'brief', 'description', 'apply');

    public function getListSelect()
    {
        if (null === $this->_select) {
            $this->_select = parent::getListSelect();
            $this->_select->where('`j`.`removeDate` >  ?', date('Y-m-d'))
                          ->order('j.added DESC');
        }
        return $this->_select;
    }

    protected function _getFromDbSelect($primaryKey)
    {
        $select = parent::_getFromDbSelect($primaryKey);
        $select->where('`j`.`removeDate` > ?', date('Y-m-d'));
        return $select;
    }

    public function initFromForm(array $data)
    {
        $data['userId'] = \App_User_Auth::getInstance()->getData('id');
        $data['removeDate'] = new \Zend_Db_Expr('NULL');
        return parent::initFromForm($data);
    }

    public static function getCompanyForSearch()
    {
        $select = \Qs_Db::getSelect();
        $select->from(\Qs_Db::getPair('Job'), array('company', 'company'));
        $select->distinct(true);
        $select->order('company');
        $select->where('removeDate > ?', date('Y-m-d'));
        return \Qs_Db::getInstance()->fetchPairs($select);
    }

    protected function _getCleanedFilter($filter)
    {
        if (isset($filter['userId']) && !$filter['userId']) {
            unset($filter['userId']);
        }
        return parent::_getCleanedFilter($filter);
    }

}