<?php

namespace App\Event\Upcoming;

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

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

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

    protected function _filterUpcoming(Zend_Db_Select $select)
    {
        $select->where('`e`.`endDate` >= CURDATE()');
        $select->having('`eventEnd` > NOW()');
        $select->order('eventStart ASC');
        return $this;
    }

    public function getSpecialEventIds()
    {
        if (!($specialEvents = $this->getConfigArray('specialEvents'))) {
            return [];
        }
        $map = [];
        foreach ($specialEvents as $showAs) {
            if (($eventId = $this->getSpecialEventId($showAs))) {
                $map[$showAs] = $eventId;
            }
        }
        return $map;
    }
}