Proyectos de Subversion LeadersLinked - Antes de SPA

Rev

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

Rev 4776 Rev 4842
Línea 240... Línea 240...
240
       
240
       
Línea 241... Línea 241...
241
        $record = $this->executeFetchOneArray($select);
241
        $record = $this->executeFetchOneArray($select);
242
        
242
        
-
 
243
        return $record['total'];
-
 
244
    }
-
 
245
    
-
 
246
    /**
-
 
247
     *
-
 
248
     * @param int $network_id
-
 
249
     * @return int
-
 
250
     */
-
 
251
    public function fetchCountActiveByDefaultNetworkId($network_id)
-
 
252
    {
-
 
253
        
-
 
254
        $select = $this->sql->select(self::_TABLE);
-
 
255
        $select->columns(['total' => new Expression('COUNT(*)')]);
-
 
256
        $select->where->equalTo('network_id', $network_id);
-
 
257
        $select->where->in('usertype_id', [UserType::USER, UserType::ADMIN]);
-
 
258
        $select->where->equalTo('status', User::STATUS_ACTIVE);
-
 
259
        
-
 
260
        $record = $this->executeFetchOneArray($select);
-
 
261
        
Línea -... Línea 262...
-
 
262
        return $record['total'];
-
 
263
    }
-
 
264
   
-
 
265
    /**
-
 
266
     *
-
 
267
     * @param int $network_id
-
 
268
     * @return int
-
 
269
     */
-
 
270
    public function fetchCountActiveByOtherNetworkId($network_id)
-
 
271
    {
-
 
272
        
-
 
273
        $select = $this->sql->select(self::_TABLE);
-
 
274
        $select->columns(['total' => new Expression('COUNT(*)')]);
-
 
275
        $select->where->equalTo('network_id', $network_id);
-
 
276
        $select->where->in('usertype_id', [UserType::USER, UserType::ADMIN]);
-
 
277
        $select->where->equalTo('status', User::STATUS_ACTIVE);
-
 
278
        $select->where->equalTo('request_access', User::REQUEST_ACCESS_APPROVED);
-
 
279
        
-
 
280
 
-
 
281
        $record = $this->executeFetchOneArray($select);
-
 
282
        
Línea 243... Línea 283...
243
        return $record['total'];
283
        return $record['total'];
244
    }
284
    }
245
   
285