<?php

/**
 * @method array getLeadershipCategory4Select()
 */

class App_Leadership_Admin_Obj extends App_Leadership_Abstract_Obj
{
    protected $_reorderTitleColumn = 'name';
    protected $_hasFilter = true;
    protected $_filterFields = array('name', 'description');
    protected $_reorderIsGroupedItems = true;
    protected $_reorderGroupKeyColumn = 'categoryId';

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

            
            $this->_select->joinLeft(
                $this->_getPair($this->_categoryTableAlias),
                '`' . $this->_categoryTableAlias . '`.`id` = `' . $this->_tableAlias . '`.`categoryId`',
                array(
                    'category'        => $this->_categoryTableAlias . '.title',
                    'categoryEnabled' => 'IFNULL(`' . $this->_categoryTableAlias . '`.`enabled`, "y")'
                )
            );
        }
        return $this->_select;
    }

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