Proyectos de Subversion LeadersLinked - Services

Rev

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

Rev 269 Rev 270
Línea 1220... Línea 1220...
1220
     *
1220
     *
1221
     * @param int $network_id
1221
     * @param int $network_id
1222
     * @param string $search
1222
     * @param string $search
1223
     * @param int $records_per_page
1223
     * @param int $records_per_page
1224
     * @param int $page
1224
     * @param int $page
1225
     * @param int[] $abuseReportIds
1225
     * @param int[] $userBlockedIds
1226
     * 
1226
     * 
1227
     * @return User[]
1227
     * @return User[]
1228
     */
1228
     */
1229
    public function fetchAllSuggestPaginateByNetworkIdAndSearchAndNotAbuseReport($network_id, $search, $records_per_page, $page,  $abuseReportIds = [])
1229
    public function fetchAllSuggestPaginateByNetworkIdAndSearchAndNotBlocked($network_id, $search, $records_per_page, $page,  $userBlockedIds = [])
1230
    {
1230
    {
Línea 1231... Línea 1231...
1231
        
1231
        
1232
        $select = $this->sql->select();
1232
        $select = $this->sql->select();
1233
        $select->from(self::_TABLE);
1233
        $select->from(self::_TABLE);
1234
        $select->where->equalTo('network_id', $network_id);
1234
        $select->where->equalTo('network_id', $network_id);
1235
        $select->where->equalTo('status', User::STATUS_ACTIVE);
1235
        $select->where->equalTo('status', User::STATUS_ACTIVE);
-
 
1236
        $select->where->equalTo('email_verified', User::EMAIL_VERIFIED_YES);
-
 
1237
        
1236
        $select->where->equalTo('email_verified', User::EMAIL_VERIFIED_YES);
1238
        if($userBlockedIds) {
-
 
1239
            $select->where->notIn('id', $userBlockedIds);
Línea 1237... Línea 1240...
1237
        $select->where->notIn('id', $abuseReportIds);
1240
        }
1238
        
1241
        
1239
        if ($search) {
1242
        if ($search) {
1240
            $select->where->nest()
1243
            $select->where->nest()