<?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 $_filterAllowedEmptyFields = ['categoryId'];
    protected $_rawDataFields = array('answer');
    protected $_nullableFields = ['categoryId'];

    protected $_reorderIsGroupedItems = true;
    protected $_reorderGroupKeyColumn = 'categoryId';
    protected $_reorderGroupSorterColumn = 'FaqCategory.sorter';

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

            $emptyTitle = $this->_db->quote(self::NO_CATEGORY_TITLE);
            $this->_select->joinLeft(
                $this->_getPair('FaqCategory'),
                '`FaqCategory`.`id` = `Faq`.`categoryId`',
                array(
                    'category'        => 'IFNULL(`FaqCategory`.`title`, ' . $emptyTitle . ')',
                    'categoryEnabled' => 'IFNULL(`FaqCategory`.`enabled`, "y")'
                )
            );
        }
        return $this->_select;
    }

    protected function _getCleanedFilter($filter)
    {
        if ('0' === $filter['categoryId']) {
            $filter['categoryId'] = null;
        } elseif ('' === $filter['categoryId']) {
            unset($filter['categoryId']);
        }
        return parent::_getCleanedFilter($filter);
    }

    public function getCategoriesCount()
    {
        $select = $this->_db->select();
        $select->from($this->_getPair(), new Zend_Db_Expr('COUNT(DISTINCT `Faq`.`categoryId`)'));
        return (int) $this->_db->fetchOne($select);
    }

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