<?php

class App_Search_Work_Obj extends Qs_Db_Obj
{
    protected $_tableAlias = 'Work';
    protected $_isService = false;
    protected $_filterFields = array('title', 'location', '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 'Work':
                    $page = Qs_SiteMap::findFirst(array(), array('type' => 'Work_'));
                    $row['url'] = $page['url'] . '/' . $row['id'];
                default:
                    break;
            }
            Qs_Text_Mark::setWordSplitters(array());

            $row['searchContent'] =  $row['location'] . ' | ' .  $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'];
        $WorkSelect = $this->_db->select()
            ->from($this->_getPair('Work', false),
                array('id', 'title', 'location', 'introduction', 'searchContent', 'image',
                    'type' => new Zend_Db_Expr('"Work"')));
        $anyWordResultWork = clone $WorkSelect;
        $simpleResultWork = clone $WorkSelect;

        Qs_Db_Filter::match($WorkSelect, $this->_filterFields, $query, true);
        Qs_Db_Filter::match($anyWordResultWork, $this->_filterFields, $query);
        Qs_Db_Filter::where($simpleResultWork, $this->_filterFields, $query);

        $this->select->reset()->union(array(
            $WorkSelect, $anyWordResultWork, $simpleResultWork,
        ));
        $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;
    }
}