<?php

abstract class App_ChimesNewsletter_AbstractObj extends Qs_Db_Obj
{
    protected $_tableAlias = 'ChimesNewsletter';
    protected $_hasFilter = true;
    protected $_filterFields = array('headline');

    public $itemName = 'Newsletter';
    public $itemsName = 'Newsletters';
    protected $_year;

    /**
     * Return years array
     *
     * @param bool $showActiveOnly
     * @param bool $ascOrder
     * @return array
     */
    public function getYearsList($showActiveOnly = true, $ascOrder = false)
    {
        $select = $this->db->select();
        $select->from($this->pair, array('year' => 'DATE_FORMAT(published, \'%Y\')'))
               ->distinct();
        if ($ascOrder) {
            $select->order('published');
        } else {
            $select->order('published DESC');
        }
        if ($showActiveOnly){
            $select->where('`show` = ?', 'y');
        }
        return $this->db->fetchCol($select);
    }

    public function setCurrentYear($year)
    {
        $this->_year = (int)$year;
        return $this;
    }

    public function getCurrentYear()
    {
        return $this->_year;
    }
}