Proyectos de Subversion LeadersLinked - Antes de SPA

    }

    /**

     *

     * @param int[] $ids

     * @param string $search

     * @param int $current_user

     * @param string $status

     * @return User[]

     */

    public function fetchAllByIdsAndSearch($ids, $search, $current_user = 0, $status = User::STATUS_ACTIVE)

    {

        $prototype = new User();

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

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

        $select->where->and->in('id',$ids);

        $select->where->nest()

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

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

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

        if($current_user) {

            $select->where->and->notEqualTo('id ', $current_user);

        }

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

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

    }

    /**

     *

     * @param int $network_id

     * @param int $current_user_id;

     * @return int[]

     */

    public function fetchAllIdsByDefaultNetworkId($network_id, $current_user_id = 0)

    {

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

        $select->columns(['id']);

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

        $select->where->in('usertype_id', [UserType::ADMIN, UserType::USER]);

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

        if($current_user_id) {

            $select->where->notEqualTo('id', $current_user_id);

        }

        $ids = [];

        $records = $this->executeFetchAllArray($select);

        foreach($records as $record)

        {

            array_push($ids, $record['id']);

        }

        return $ids;

    }

    /**

     *

     * @param int $network_id

     * @param string $search

     * @param int $current_user_id;

     * @return int[]

     */

    public function fetchAllIdsByDefaultNetworkIdAndSearch($network_id, $search, $current_user_id = 0)

    {

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

        $select->columns(['id']);

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

        $select->where->in('usertype_id', [UserType::ADMIN, UserType::USER]);

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

        $select->where->nest()

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

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

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

        if($current_user_id) {

            $select->where->notEqualTo('id', $current_user_id);

        }

        $ids = [];

        $records = $this->executeFetchAllArray($select);

        foreach($records as $record)

        {

            array_push($ids, $record['id']);

        }

        return $ids;

    }

    /**

     *

     * @param int $network_id

     * @param int $current_user_id;

     * @return int[]

     */

    public function fetchAllIdsByNonDefaultNetworkId($network_id, $current_user_id = 0)

    {

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

        $select->columns(['id']);

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

        $select->where->in('usertype_id', [UserType::ADMIN, UserType::USER]);

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

        $select->where->equalTo('request_access', User::REQUEST_ACCESS_APPROVED);

        if($current_user_id) {

            $select->where->notEqualTo('id', $current_user_id);

        }

        $ids = [];

        $records = $this->executeFetchAllArray($select);

        foreach($records as $record)

        {

            array_push($ids, $record['id']);

        }

        return $ids;

    }

    /**

     *

     * @param int $network_id

     * @param string $search

     * @param int $current_user_id;

     * @return int[]

     */

    public function fetchAllIdsByNonDefaultNetworkIdAndSearch($network_id, $search, $current_user_id = 0)

    {

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

        $select->columns(['id']);

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

        $select->where->in('usertype_id', [UserType::ADMIN, UserType::USER]);

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

        $select->where->equalTo('request_access', User::REQUEST_ACCESS_APPROVED);

        $select->where->nest()

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

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

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

        if($current_user_id) {

            $select->where->notEqualTo('id', $current_user_id);

        }

        $ids = [];

        $records = $this->executeFetchAllArray($select);

        foreach($records as $record)

        {

            array_push($ids, $record['id']);

        }

        return $ids;

    }