Proyectos de Subversion LeadersLinked - Antes de SPA

Rev

Rev 5994 | Rev 6023 | Ir a la última revisión | Mostrar el archivo completo | | | Autoría | Ultima modificación | Ver Log |

Rev 5994 Rev 6011
Línea 386... Línea 386...
386 
 
 386 
 
387 
        return $this->executeFetchAllObject($select, $prototype);
 387 
        return $this->executeFetchAllObject($select, $prototype);
Línea -... Línea 388...
- 
 
 388 
    }
- 
 
 389 
 
- 
 
 390 
 
- 
 
 391
- 
 
 392 
    /**
- 
 
 393 
     *
- 
 
 394 
     * @param int $network_id
- 
 
 395 
     * @param int[] $ids
- 
 
 396 
     * @param string $search
- 
 
 397 
     * @param int $current_user
- 
 
 398 
     * @param string $status
- 
 
 399 
     * @return User[]
- 
 
 400 
     */
- 
 
 401 
    public function fetchAllByNetworkIdAndIdsAndSearch($network_id, $ids, $search, $current_user = 0, $status = User::STATUS_ACTIVE)
- 
 
 402 
    {
- 
 
 403
- 
 
 404 
        $prototype = new User();
- 
 
 405 
        $select = $this->sql->select(self::_TABLE);
- 
 
 406
- 
 
 407
- 
 
 408 
        $select->where->equalTo('status', User::STATUS_ACTIVE);
- 
 
 409 
        $select->where->equalTo('network_id', $network_id);
- 
 
 410 
        $select->where->and->in('id', $ids);
- 
 
 411 
        $select->where->nest()
- 
 
 412 
        ->like('first_name', '%' . $search . '%')
- 
 
 413 
        ->or->like('last_name', '%' . $search . '%')
- 
 
 414 
        ->or->like('email', '%' . $search . '%')->unnest();
- 
 
 415
- 
 
 416 
        if ($current_user) {
- 
 
 417 
            $select->where->and->notEqualTo('id ', $current_user);
- 
 
 418 
        }
- 
 
 419 
        $select->order(['first_name ASC', 'last_name ASC', 'email ASC']);
Línea 388... Línea 420...
388 
    }
 420
Línea 425... Línea 457...
425 
        $select = $this->sql->select(self::_TABLE);
 457 
        $select = $this->sql->select(self::_TABLE);
426 
        $select->columns(['id']);
 458 
        $select->columns(['id']);
427 
        $select->where->equalTo('network_id', $network_id);
 459 
        $select->where->equalTo('network_id', $network_id);
428 
        $select->where->in('usertype_id', [UserType::ADMIN, UserType::USER]);
 460 
        $select->where->in('usertype_id', [UserType::ADMIN, UserType::USER]);
429 
        $select->where->equalTo('status', User::STATUS_ACTIVE);
 461 
        $select->where->equalTo('status', User::STATUS_ACTIVE);
- 
 
 462 
        $select->where->equalTo('email_verified', User::EMAIL_VERIFIED_YES);
Línea 430... Línea 463...
430 
 
 463 
 
431 
        if ($current_user_id) {
 464 
        if ($current_user_id) {
432 
            $select->where->notEqualTo('id', $current_user_id);
 465 
            $select->where->notEqualTo('id', $current_user_id);
Línea 490... Línea 523...
490 
        $select = $this->sql->select(self::_TABLE);
 523 
        $select = $this->sql->select(self::_TABLE);
491 
        $select->columns(['id']);
 524 
        $select->columns(['id']);
492 
        $select->where->equalTo('network_id', $network_id);
 525 
        $select->where->equalTo('network_id', $network_id);
493 
        $select->where->in('usertype_id', [UserType::ADMIN, UserType::USER]);
 526 
        $select->where->in('usertype_id', [UserType::ADMIN, UserType::USER]);
494 
        $select->where->equalTo('status', User::STATUS_ACTIVE);
 527 
        $select->where->equalTo('status', User::STATUS_ACTIVE);
- 
 
 528 
        $select->where->equalTo('email_verified', User::EMAIL_VERIFIED_YES);
495 
        $select->where->equalTo('request_access', User::REQUEST_ACCESS_APPROVED);
 529 
        $select->where->equalTo('request_access', User::REQUEST_ACCESS_APPROVED);
Línea 496... Línea 530...
496 
 
 530 
 
497 
        if ($current_user_id) {
 531 
        if ($current_user_id) {
498 
            $select->where->notEqualTo('id', $current_user_id);
 532 
            $select->where->notEqualTo('id', $current_user_id);