<?php

class App_Newsletter_Obj extends App_Newsletter_Abstract_Obj
{
    protected function _getFromColumns()
    {
        $columns = parent::_getFromColumns();
        $columns['year'] = 'YEAR(date)';
        return $columns;
    }

    protected function _getYearsSelect()
    {
        $select = parent::_getYearsSelect();
        $this->_filterEnabled($select);
        return $select;
    }

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

    public function getObjectInfo()
    {
        $data = parent::getObjectInfo();

        if (!empty($data['title'])) {
            $data['itemTitle'] = '"' . $data['title'] . '"';
            if (false !== strpos($data['title'], $this->getConfig('itemName'))) {
                $data['itemTitle'] .= ' / ';
            } else {
                $data['itemTitle'] .= ' Newsletter / ';
            }
            $data['itemTitle'] .= date('F, Y', strtotime($data['date']));
        }

        return $data;
    }

    protected function _prepareSearchList(array &$list, array $providerOptions)
    {
        if (empty($list)) {
            return $this;
        }
        $this->_prepareList($list);

        $query = $this->_filter['query'];
        foreach ($list as &$row) {
            $row['searchUrl'] = Qs_ImageFs::get($row['file']);
            $row['title'] = Qs_Text_Mark::markSearchWords($row['title'], $query);
            $row['content'] = 'Published in ' . date('F Y', strtotime($row['date']));
            $row['downloadLogUrl'] = Qs_String::fill($this->getConfig('downloadLogUrl'), $row);
        }
        return $this;
    }
}