protected function getValidCorps($users)
{
$validCorps = [];
$invalid = [];
foreach ($users as $u) {
$valid_keys = \SeatKey::where('user_id', $u->id)->lists('keyID');
if (!empty($valid_keys)) {
$corporation_affiliation = \EveAccountAPIKeyInfoCharacters::whereIn('keyID', $valid_keys)->groupBy('corporationID')->lists('corporationID');
if (!empty($corporation_affiliation)) {
$viable = \EveCorporationCorporationSheet::whereIn('corporationID', $corporation_affiliation)->lists('corporationName');
if (!empty($viable)) {
$validCorps[] = ['corps' => $viable, 'user' => $u, 'user_groups' => \Auth::getUserGroups($u)];
}
}
} else {
$invalid[] = $u;
}
}
return [$validCorps, $invalid];
}
