<?php

namespace App\Company\Admin;

use App\Company\AbstractObj;
use App\User\Entity as UserEntity;
use Zend_Db_Expr;
use Zend_Db_Select;

class Obj extends AbstractObj
{
    protected $_filterFields = ['name', 'city', 'address', 'address2'];

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

    protected function getActiveIndividualsCountExpr()
    {
        $select = $this->_db->select();
        $select->from($this->_getPair('User'), 'COUNT(*)')
            ->where('`User`.`companyId` = `' . $this->_getTableAlias() . '`.`id`')
            ->where('`User`.`status` = ?', UserEntity::STATUS_ACTIVE);
        return new Zend_Db_Expr('(' . $select . ')');
    }

    public function addStateFullname(Zend_Db_Select $select)
    {
        $select->join(
            $this->_getPair('DState', 'state'),
            '`state`.`id` = ' . $this->_getTableAlias() . '.state',
            ['stateFull' => 'title']
        );
        return $this;
    }


}