<?php

namespace App\Leadership\Admin;

use App\Leadership\AbstractObj;
use Zend_Db_Expr;

class Obj extends AbstractObj
{
    protected $_reorderTitleColumn = 'name';

    protected function _getFromColumns()
    {
        $columns = parent::_getFromColumns();
        $columns['members'] = $this->_getMembersCountExpr();
        return $columns;
    }

    protected function _getMembersCountExpr()
    {
        $select = $this->_db->select();
        $select->from($this->_getPair('User'), 'COUNT(*)')
            ->where('`User`.`leadershipGroupId` = `' . $this->_tableAlias . '`.`id`');
        return new Zend_Db_Expr('(' . $select . ')');
    }

}