Proyectos de Subversion LeadersLinked - Antes de SPA

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

    }

    /**

     *

     * @param string $uuid

     * @param int $network_id

     * @return User

     */

    public function fetchOneByUuidAndNetworkId($uuid, $network_id)

    {

        $prototype = new User();

        $select = $this->sql->select(self::_TABLE);

        $select->where->equalTo('uuid', $uuid);

        $select->where->equalTo('network_id', $network_id);

    /**

     *

     * @param string $email

     * @param int $network_id

     * @return void|User

     */

    public function fetchOneByEmailAndNetworkId($email, $network_id)

    {

        $prototype = new User();

        $select = $this->sql->select(self::_TABLE);

        $select->where->equalTo('email', $email);

        $select->where->equalTo('network_id', $network_id);

        //echo $select->getSqlString($this->adapter->platform); exit;

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

    }

    }

    /**

     *

     * @param int $network_id

     * @return int

     */

    public function fetchCountByNetworkId($network_id)

    {

        $select = $this->sql->select(self::_TABLE);

        $select->columns(['total' => new Expression('COUNT(*)')]);

        $select->where->equalTo('network_id', $network_id);

        $record = $this->executeFetchOneArray($select);

        return $record['total'];

     * @param int $user_id

     * @return boolean

     */

    public function leaveImpersonate($user_id)

    {

        $values = [

            'impersonate_user_id' => new Expression('NULL')

        ];

        $update = $this->sql->update(self::_TABLE);

        $update->set($values);

        $update->where->equalTo('id', $user_id);

        return $this->executeUpdate($update);

    }

    /**

     *

     * @param int $user_id

     * @param int $impersonate_user_id

     * @return boolean

     */

    public function startImpersonate($user_id, $impersonate_user_id)

    {

        $values = [

            'impersonate_user_id' => $impersonate_user_id

        ];

        $update = $this->sql->update(self::_TABLE);

        $update->set($values);

        $update->where->equalTo('id', $user_id);

        return $this->executeUpdate($update);

    }

    /**

     * 

    }

    /**

     *

     * @param int $network_id

     * @param string $search

     * @return User[]

     */

    public function fetchAllSuggestByNetworkIdAndSearch($network_id, $search)

    {

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

        $select->from(self::_TABLE);

        $select->where->equalTo('network_id', $network_id);

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

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

        if($search) {

            $select->where->nest()

            ->like('first_name', '%' . $search . '%')

            ->or->like('last_name', '%' . $search . '%')

            ->or->like('email', '%' . $search . '%')

            ->unnest();

        }

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

        // echo $select->getSqlString($this->adapter->platform); exit;

        $prototype = new User();

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

    }

    /**

     *

     * @param int $company_id

     * @param int $network_id

     * @param string $search

     * @return User[]

     */

    public function fetchAllSuggestForInvitationByCompanyIdAndNetworkIdAndSearch($company_id, $network_id, $search)

    {

        $selectCompanyUsers = $this->sql->select(CompanyUserMapper::_TABLE);

        $selectCompanyUsers->columns(['user_id']);

        $selectCompanyUsers->where->equalTo('company_id', $company_id);

        $selectCompanyUsers->where->in('status', [

            CompanyUser::STATUS_ACCEPTED,

            CompanyUser::STATUS_PENDING,

            CompanyUser::STATUS_SENT,

        ]);

        //echo $selectCompanyUsers->getSqlString($this->adapter->platform); exit;

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

        $select->from(self::_TABLE);

        $select->where->notIn('id', $selectCompanyUsers);

        $select->where->equalTo('network_id', $network_id);

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

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

        if($search) {

            $select->where->nest()

            ->like('first_name', '%' . $search . '%')

            ->or->like('last_name', '%' . $search . '%')

            ->or->like('email', '%' . $search . '%')

            ->unnest();

        }

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

        // echo $select->getSqlString($this->adapter->platform); exit;

        $prototype = new User();

     * @param int $group_id

     * @param int $network_id

     * @param string $search

     * @return User[]

     */

    public function fetchAllSuggestForInvitationByGroupIdAndNetworkIdAndSearch($group_id, $network_id, $search)

    {

        $selectGroupMembers = $this->sql->select(GroupMemberMapper::_TABLE);

        $selectGroupMembers->columns(['user_id']);

        $selectGroupMembers->where->equalTo('group_id', $group_id);

        $selectGroupMembers->where->in('status', [

            CompanyUser::STATUS_ACCEPTED,

        ]);

        //echo $selectGroupMembers->getSqlString($this->adapter->platform); exit;

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

        $select->from(self::_TABLE);

        $select->where->equalTo('network_id', $network_id);

        $select->where->notIn('id', $selectGroupMembers);

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

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

        if($search) {

            $select->where->nest()

            ->like('first_name', '%' . $search . '%')

            ->or->like('last_name', '%' . $search . '%')

            ->or->like('email', '%' . $search . '%')

            ->unnest();

        }

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

        // echo $select->getSqlString($this->adapter->platform); exit;

        $prototype = new User();

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

    }

    /**

     *

    }