<?php

namespace App\Event\PastAnnual;

use App\Event\AbstractObj;
use App\Event\Entity;
use App\Event\Model;
use Zend_Db_Select;

class Obj extends AbstractObj
{
    protected function _getFromColumns()
    {
        $columns = parent::_getFromColumns();
        $columns['year'] = 'YEAR(startDate)';
        $columns['eventStart'] = Model::getStartDateTimeExpr();
        $columns['eventEnd'] = Model::getEndDateTimeExpr();
        return $columns;
    }

    public function getListSelect()
    {
        if (null === $this->_select) {
            parent::getListSelect();
            $this->_filterEnabled($this->_select);
            $this->_filterPastAnnual($this->_select);
        }
        return $this->_select;
    }

    protected function _filterPastAnnual(Zend_Db_Select $select)
    {
        $select->where('`e`.`endDate` < CURDATE()');
        $select->where('`e`.`showAs` = ?', Entity::ANNUAL_MEETING);
        $select->order('e.endDate DESC');
        return $this;
    }
}