<?php
/**
 * @method array getFaqCategory4Select()
 */
class App_Faq_Admin_Obj extends App_Faq_Abstract_Obj
{
    protected $_reorderTitleColumn = 'question';
    protected $_hasFilter = true;
    protected $_filterFields = array('question', 'answer');
    protected $_rawDataFields = array('answer');

    public function getListSelect()
    {
        if (null == $this->_select) {
            $this->_select = parent::getListSelect();
            $this->_select->joinLeft(
                $this->_getPair('FaqCategory'),
                '`FaqCategory`.`id` = `Faq`.`categoryId`',
                array('category' => 'IFNULL(`FaqCategory`.`title`, ' . $this->_db->quote(self::NO_CATEGORY_TITLE) . ')')
            );
        }
        return $this->_select;
    }

    public function getObjectInfo()
    {
        if (($info = parent::getObjectInfo())) {
            $info['itemTitle'] = $info['question'];
        }
        return $info;
    }
}