Proyectos de Subversion LeadersLinked - Antes de SPA

        $select->where->equalTo('status', User::STATUS_ACTIVE);

        $select->where->equalTo('email_verified',User::EMAIL_VERIFIED_YES);

        return $this->executeFetchAllObject($select, $prototype);

    }

    /**

     * 

     * @param int $company_id

     * @return array

     */

    public function fetchAllByCompanyId($company_id)

    {

        $prototype = new User();

        $select = $this->sql->select();

        $select->from(['tb1' => self::_TABLE]);

        $select->join(['tb2' => CompanyUserMapper::_TABLE], 'tb1.id = tb2.user_id', []);

        $select->where->equalTo('tb2.company_id', $company_id);

        $select->where->in('tb2.status', [CompanyUser::STATUS_ACCEPTED, CompanyUser::STATUS_ADMIN_WILL_ADD]);

        $select->where->equalTo('tb1.status', User::STATUS_ACTIVE);

        $select->where->equalTo('tb1.email_verified',User::EMAIL_VERIFIED_YES);

        $select->order(['first_name DESC, last_name DESC, email_DESC']);