<?php

class App_ChimesNewsletter_Obj extends App_ChimesNewsletter_AbstractObj
{
    protected function _where(Zend_Db_Select $select = null)
    {
        $select = parent::_where($select);
        $select->where('`' . $this->_tableAlias . '`.`show` = ?', 'y');
        if (!empty($this->_year)){
            $select->where('DATE_FORMAT(`published`, \'%Y\') = ?', $this->_year, Zend_Db::INT_TYPE);
        } elseif ($this->hasFilter()) {
            $subselect = $this->db->select();
            $subselect->from($this->pair, 'MIN(DATE_FORMAT(`published`, \'%Y\'))');
            $select->where('DATE_FORMAT(`published`, \'%Y\') = (' . $subselect . ')');
        }
        return $select;
    }
}