<?php

class App_Faq_Abstract_Obj extends Qs_Db_Obj
{
    const NO_CATEGORY_TITLE = 'No Category';
    protected $_tableAlias = 'Faq';

    protected $_urlParseFields = array('question', 'answer');

    /** @var App_Faq_Abstract_Obj */
    protected static $_instance;

    public static function getInstance()
    {
        if (null == self::$_instance) {
            self::$_instance = new self();
        }
        return self::$_instance;
    }

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