Proyectos de Subversion LeadersLinked - Antes de SPA

Rev

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

Rev 6011 Rev 6023
Línea 386... Línea 386...
386
 
386
 
387
        return $this->executeFetchAllObject($select, $prototype);
387
        return $this->executeFetchAllObject($select, $prototype);
Línea 388... Línea 388...
388
    }
388
    }
389
 
389
 
390
 
390
 
391
    
391
 
392
    /**
392
    /**
393
     *
393
     *
Línea 398... Línea 398...
398
     * @param string $status
398
     * @param string $status
399
     * @return User[]
399
     * @return User[]
400
     */
400
     */
401
    public function fetchAllByNetworkIdAndIdsAndSearch($network_id, $ids, $search, $current_user = 0, $status = User::STATUS_ACTIVE)
401
    public function fetchAllByNetworkIdAndIdsAndSearch($network_id, $ids, $search, $current_user = 0, $status = User::STATUS_ACTIVE)
402
    {
402
    {
403
        
403
 
404
        $prototype = new User();
404
        $prototype = new User();
405
        $select = $this->sql->select(self::_TABLE);
405
        $select = $this->sql->select(self::_TABLE);
406
        
406
 
407
        
407
 
408
        $select->where->equalTo('status', User::STATUS_ACTIVE);
408
        $select->where->equalTo('status', User::STATUS_ACTIVE);
409
        $select->where->equalTo('network_id', $network_id);
409
        $select->where->equalTo('network_id', $network_id);
410
        $select->where->and->in('id', $ids);
410
        $select->where->and->in('id', $ids);
411
        $select->where->nest()
411
        $select->where->nest()
412
        ->like('first_name', '%' . $search . '%')
412
            ->like('first_name', '%' . $search . '%')
413
        ->or->like('last_name', '%' . $search . '%')
413
            ->or->like('last_name', '%' . $search . '%')
414
        ->or->like('email', '%' . $search . '%')->unnest();
414
            ->or->like('email', '%' . $search . '%')->unnest();
415
        
415
 
416
        if ($current_user) {
416
        if ($current_user) {
417
            $select->where->and->notEqualTo('id ', $current_user);
417
            $select->where->and->notEqualTo('id ', $current_user);
418
        }
418
        }
419
        $select->order(['first_name ASC', 'last_name ASC', 'email ASC']);
419
        $select->order(['first_name ASC', 'last_name ASC', 'email ASC']);
420
        
420
 
421
        return $this->executeFetchAllObject($select, $prototype);
421
        return $this->executeFetchAllObject($select, $prototype);
422
    }
422
    }
Línea 1098... Línea 1098...
1098
 
1098
 
1099
        if ($search) {
1099
        if ($search) {
1100
            $select->where->nest()
1100
            $select->where->nest()
1101
                ->like('first_name', '%' . $search . '%')
1101
                ->like('first_name', '%' . $search . '%')
-
 
1102
                ->or->like('last_name', '%' . $search . '%')
-
 
1103
                ->or->like(new Expression("CONCAT(first_name,' ',last_name)"), '%' . $search . '%')
1102
                ->or->like('last_name', '%' . $search . '%')
1104
                ->or->like(new Expression("CONCAT(last_name,' ',first_name)"), '%' . $search . '%')
1103
                ->or->like('email', '%' . $search . '%')
1105
                ->or->like('email', '%' . $search . '%')
1104
                ->unnest();
1106
                ->unnest();
Línea 1105... Línea 1107...
1105
        }
1107
        }