<?php

class App_Career_Obj extends App_Career_AbstractObj
{
    protected $_hasFilter = true;

    protected function _filterWhere(Zend_Db_Select $select)
    {
        parent::_filterWhere($select);
        $this->_filterEnabled($select);
        $this->_filterExpirationDate($select);
        return $this;
    }

    protected function _filterEnabled(Zend_Db_Select $select)
    {
        $select->where('`' . $this->_tableAlias . '`.`enabled` = "y"');
        return $this;
    }

    protected function _filterExpirationDate(Zend_Db_Select $select)
    {
        $select->where('`' . $this->_tableAlias . '`.`expirationDate` >= CURDATE()');
        return $this;
    }

    protected function _joinFromDb(Zend_Db_Select $select)
    {
        parent::_joinFromDb($select);
        $this->_filterEnabled($select);
        $this->_filterExpirationDate($select);
        return $this;
    }
 
}