<?php

class App_Search_Association_Obj extends Qs_Db_Obj
{
    protected $_tableAlias = 'Association';
    protected $_isService = false;
    protected $_filterFields = array('title', 'introduction', 'searchContent');
    protected $_hasFilter = true;

    protected function _prepareList(&$list)
    {
        parent::_prepareList($list);
        Qs_Text_Mark::setCharactersBefore(200);
        Qs_Text_Mark::setCharactersAfter(200);

        foreach ($list as $k => &$row) {
            switch ($row['type']) {
                case 'Association':
                    $page = Qs_SiteMap::findFirst(array(), array('type' => 'Association_', 'idGroup' => 1));
                    $row['url'] = $page['url'] . '/' . $row['id'];
                    break;
                default:
                    break;
            }
            Qs_Text_Mark::setWordSplitters(array());
            $row['searchContent'] = $row['introduction'] . ' | ' . $row['searchContent'];
            $row['searchContent'] = Qs_Text_Mark::markSearchWords($row['searchContent'], trim($_REQUEST['query']));
            $row['title'] = Qs_Text_Mark::markSearchWords($row['title'], trim($_REQUEST['query']));
        }
        return true;
    }

    public function getListSelect($options = array())
    {
        $query = $this->_filter['query'];
        $AssociationSelect = $this->_db->select()
            ->from($this->_getPair('Association', false),
                array('id', 'title', 'introduction', 'searchContent', 'image', 'type' => new Zend_Db_Expr('"Association"')));
        $anyWordResultAssociation = clone $AssociationSelect;
        $simpleResultAssociation = clone $AssociationSelect;

        Qs_Db_Filter::match($AssociationSelect, $this->_filterFields, $query, true);
        Qs_Db_Filter::match($anyWordResultAssociation, $this->_filterFields, $query);
        Qs_Db_Filter::where($simpleResultAssociation, $this->_filterFields, $query);

        $this->select->reset()->union(array(
            $AssociationSelect, $anyWordResultAssociation, $simpleResultAssociation,
        ));
        $this->_prepareListOptions($options);
        return $this->select;
    }

    public function getList($options = array())
    {
        $stmt = $this->getListStatement($options);
        $list = $stmt->fetchAll();
        $this->_prepareList($list);
        if (is_array($list) && count($list)) {
            $session = new Qs_Session_Namespace('JC_SEARCH');
            $session->flagContent = true;
        }
        return $list;
    }

    public function getPaginatorAdapter()
    {
        $select = $this->_getSelect()->reset(Zend_Db_Select::LIMIT_COUNT)->reset(Zend_Db_Select::LIMIT_OFFSET);
        return $select;
    }

    protected function _filterWhere(Zend_Db_Select $select)
    {
        if (!empty($this->_filterFields) && array_key_exists('query', $this->_filter)) {
            Qs_Db_Filter::where($select, $this->_filterFields, $this->_filter['query']);
        }
        return $select;
    }
}