<?php

namespace App\CommunicationList\Admin;

use App\CommunicationList\AbstractObj;
use Zend_Db_Expr;

class Obj extends AbstractObj
{
    protected $_checkForeignKeyDependencies = true;
    protected $_foreignKeyLocksMessages = [
        'UserLists' => 'This %itemName% is linked with Individual(s) and can\'t be removed. Please remove the connections first.',
    ];

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

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