public static function Update() { // Before we even bother getting to the point of // determining which members are inactive // check if there are any users // configured that have // the required roles $recruiters = \Auth::findAllUsersWithAccess('recruiter'); // If there are none with the role, just stop if (count($recruiters) <= 0) { return; } // Now we will loop over the recruiters and send // a notification about the member inactivity. // We should actually batch the members so // that we dont spam a 100 entries per // recruiter for inactivities. But // that can come later :D foreach ($recruiters as $recruiter) { // Do a lookup to see how many months without a login should // be considered as a inactive member (int) ($inactive_months = SettingHelper::getSetting('seatnotify_member_inactivity_months')); // Now, get a list of members that have not // logged in for 1 month. $members = \EveCorporationMemberTracking::where('logoffDateTime', '<', \DB::raw('date_sub(NOW(), INTERVAL ' . $inactive_months . ' MONTH)'))->get(); // If there are no members, continue if (!$members) { continue; } // For every member that we have found, we want // to send a notification for. foreach ($members as $member) { // Determine if this recruiter that we have // has access to the corporation that the // member is a part of. // // Is this step really needed? if (BaseNotify::canAccessCorp($recruiter->id, $member->corporationID)) { // Get the corporation name for the notification $corporation_name = \DB::table('account_apikeyinfo_characters')->where('corporationID', $member->corporationID)->pluck('corporationName'); // Prepare the total notification $notification_type = 'Corporation'; $notification_title = 'Member Inactivity'; $notification_text = $member->name . ' in ' . $corporation_name . ' has been inactive ' . 'for ' . $inactive_months . ' month(s). The last logon time was ' . \Carbon\Carbon::parse($member->logonDateTime)->diffFOrHumans() . ' with the last ' . 'known location being ' . $member->location . '.'; // Send the notification BaseNotify::sendNotification($recruiter->id, $notification_type, $notification_title, $notification_text); } } } }
public function getDeleteKey($keyID, $delete_all_info = false) { // Ensure that this user may access the data for $keyID if (!\Auth::isSuperUser()) { if (!in_array($keyID, Session::get('valid_keys'))) { App::abort(404); } } // Ensure the user is allowed to delete this key if (!\Auth::hasAccess('key_manager')) { App::abort(404); } // Get the full key and vCode $key = SeatKey::where('keyID', $keyID)->first(); if (!$key) { App::abort(404); } // Based on delete_all_info, we will either just delete the key, // or all of the information associated with it switch ((bool) $delete_all_info) { case true: // Check if we can determine if this is a corporation or account/char key. $type = \EveAccountAPIKeyInfo::where('keyID', $keyID)->pluck('type'); // Check if the type is set if ($type) { // For corporation keys, we will delete corporation stuff, duhr if ($type == "Corporation") { // Most of the data for corporations is stored with the corporationID // as key. To get this ID, we need to find the character attached to // this key, and then the corporation for that character $characters = BaseApi::findKeyCharacters($keyID); $corporationID = BaseApi::findCharacterCorporation($characters[0]); // With the corporationID now known, go ahead and cleanup the database \EveCorporationAccountBalance::where('corporationID', $corporationID)->delete(); \EveCorporationAssetList::where('corporationID', $corporationID)->delete(); \EveCorporationAssetListContents::where('corporationID', $corporationID)->delete(); \EveCorporationAssetListLocations::where('corporationID', $corporationID)->delete(); \EveCorporationContactListAlliance::where('corporationID', $corporationID)->delete(); \EveCorporationContactListCorporate::where('corporationID', $corporationID)->delete(); \EveCorporationContracts::where('corporationID', $corporationID)->delete(); \EveCorporationContractsItems::where('corporationID', $corporationID)->delete(); \EveCorporationCorporationSheet::where('corporationID', $corporationID)->delete(); \EveCorporationCorporationSheetDivisions::where('corporationID', $corporationID)->delete(); \EveCorporationCorporationSheetWalletDivisions::where('corporationID', $corporationID)->delete(); \EveCorporationIndustryJobs::where('corporationID', $corporationID)->delete(); \EveCorporationMarketOrders::where('corporationID', $corporationID)->delete(); \EveCorporationMedals::where('corporationID', $corporationID)->delete(); \EveCorporationMemberMedals::where('corporationID', $corporationID)->delete(); \EveCorporationMemberSecurityGrantableRoles::where('corporationID', $corporationID)->delete(); \EveCorporationMemberSecurityGrantableRolesAtBase::where('corporationID', $corporationID)->delete(); \EveCorporationMemberSecurityGrantableRolesAtHQ::where('corporationID', $corporationID)->delete(); \EveCorporationMemberSecurityGrantableRolesAtOther::where('corporationID', $corporationID)->delete(); \EveCorporationMemberSecurityLog::where('corporationID', $corporationID)->delete(); \EveCorporationMemberSecurityRoles::where('corporationID', $corporationID)->delete(); \EveCorporationMemberSecurityRolesAtBase::where('corporationID', $corporationID)->delete(); \EveCorporationMemberSecurityRolesAtHQ::where('corporationID', $corporationID)->delete(); \EveCorporationMemberSecurityRolesAtOther::where('corporationID', $corporationID)->delete(); \EveCorporationMemberSecurityTitles::where('corporationID', $corporationID)->delete(); \EveCorporationMemberTracking::where('corporationID', $corporationID)->delete(); \EveCorporationShareholderCharacters::where('corporationID', $corporationID)->delete(); \EveCorporationShareholderCorporations::where('corporationID', $corporationID)->delete(); \EveCorporationStandingsAgents::where('corporationID', $corporationID)->delete(); \EveCorporationStandingsFactions::where('corporationID', $corporationID)->delete(); \EveCorporationStandingsNPCCorporations::where('corporationID', $corporationID)->delete(); \EveCorporationStarbaseDetail::where('corporationID', $corporationID)->delete(); \EveCorporationStarbaseList::where('corporationID', $corporationID)->delete(); \EveCorporationWalletJournal::where('corporationID', $corporationID)->delete(); \EveCorporationWalletTransactions::where('corporationID', $corporationID)->delete(); } else { // And for character stuff, we delete character stuff // Here we need to be careful now. It may happen that we have more than 1 key // for a character, so we have to be aware of this. It adds a factor of // complexity to the whole thing. $characters = BaseApi::findKeyCharacters($keyID); // Now that we know about all of the characters, we will loop over them and check // that we only have 1 key for them. If more than one keys have this character, we will // simply ignore the cleanup and add a message about it foreach ($characters as $id => $character) { // Check how many keys know about this character if (\EveAccountAPIKeyInfoCharacters::where('characterID', $character)->count() > 1) { // Write a log entry about this \Log::warning('Character ' . $character . ' is recorded on another key and will not been cleaned up'); // Remove this character from $characters unset($characters[$id]); } } // So we now have an array of characterID's that can be cleaned up. Lets do that if (count($characters) > 0) { \EveCharacterAccountBalance::whereIn('characterID', $characters)->delete(); \EveCharacterAssetList::whereIn('characterID', $characters)->delete(); \EveCharacterAssetListContents::whereIn('characterID', $characters)->delete(); \EveCharacterCharacterSheet::whereIn('characterID', $characters)->delete(); \EveCharacterCharacterSheetSkills::whereIn('characterID', $characters)->delete(); \EveCharacterContactList::whereIn('characterID', $characters)->delete(); \EveCharacterContactListAlliance::whereIn('characterID', $characters)->delete(); \EveCharacterContactListCorporate::whereIn('characterID', $characters)->delete(); \EveCharacterContactNotifications::whereIn('characterID', $characters)->delete(); \EveCharacterContracts::whereIn('characterID', $characters)->delete(); \EveCharacterContractsItems::whereIn('characterID', $characters)->delete(); \EveCharacterIndustryJobs::whereIn('characterID', $characters)->delete(); // Intentionally ignoring the mail related information as this has a lot of overlap // and is almost always usefull \EveCharacterMarketOrders::whereIn('characterID', $characters)->delete(); \EveCharacterPlanetaryColonies::whereIn('characterID', $characters)->delete(); \EveCharacterPlanetaryLinks::whereIn('characterID', $characters)->delete(); \EveCharacterPlanetaryPins::whereIn('characterID', $characters)->delete(); \EveCharacterPlanetaryRoutes::whereIn('characterID', $characters)->delete(); \EveCharacterResearch::whereIn('characterID', $characters)->delete(); \EveCharacterSkillInTraining::whereIn('characterID', $characters)->delete(); \EveCharacterSkillQueue::whereIn('characterID', $characters)->delete(); \EveCharacterStandingsAgents::whereIn('characterID', $characters)->delete(); \EveCharacterStandingsFactions::whereIn('characterID', $characters)->delete(); \EveCharacterStandingsNPCCorporations::whereIn('characterID', $characters)->delete(); \EveCharacterUpcomingCalendarEvents::whereIn('characterID', $characters)->delete(); \EveCharacterWalletJournal::whereIn('characterID', $characters)->delete(); \EveCharacterWalletTransactions::whereIn('characterID', $characters)->delete(); } } // Finally, delete the key and redirect $key->delete(); // Delete the information that we have for this key too \EveAccountAPIKeyInfo::where('keyID', $keyID)->delete(); \EveAccountAPIKeyInfoCharacters::where('keyID', $keyID)->delete(); return Redirect::action('ApiKeyController@getAll')->with('success', 'Key has been deleted'); } else { // So, we are unable to determine the key type, so maybe this is // a invalid one or whatever. Just get rid of it. // Delete the API Key $key->delete(); // Delete the information that we have for this key too \EveAccountAPIKeyInfo::where('keyID', $keyID)->delete(); \EveAccountAPIKeyInfoCharacters::where('keyID', $keyID)->delete(); return Redirect::action('ApiKeyController@getAll')->with('success', 'Key has been deleted'); } break; case false: // Delete the API Key $key->delete(); // Delete the information that we have for this key too \EveAccountAPIKeyInfo::where('keyID', $keyID)->delete(); \EveAccountAPIKeyInfoCharacters::where('keyID', $keyID)->delete(); return Redirect::action('ApiKeyController@getAll')->with('success', 'Key has been deleted'); break; } }
public static function Update($keyID, $vCode) { // Start and validate they key pair BaseApi::bootstrap(); BaseApi::validateKeyPair($keyID, $vCode); // Set key scopes and check if the call is banned $scope = 'Corp'; $api = 'MemberTracking'; if (BaseApi::isBannedCall($api, $scope, $keyID)) { return; } // Get the characters for this key $characters = BaseApi::findKeyCharacters($keyID); // Check if this key has any characters associated with it if (!$characters) { return; } // Lock the call so that we are the only instance of this running now() // If it is already locked, just return without doing anything if (!BaseApi::isLockedCall($api, $scope, $keyID)) { $lockhash = BaseApi::lockCall($api, $scope, $keyID); } else { return; } // So I think a corporation key will only ever have one character // attached to it. So we will just use that characterID for auth // things, but the corporationID for locking etc. $corporationID = BaseApi::findCharacterCorporation($characters[0]); // Prepare the Pheal instance $pheal = new Pheal($keyID, $vCode); // Do the actual API call. pheal-ng actually handles some internal // caching too. try { $member_tracking = $pheal->corpScope->MemberTracking(array('characterID' => $characters[0], 'extended' => 1)); } catch (\Pheal\Exceptions\APIException $e) { // If we cant get account status information, prevent us from calling // this API again BaseApi::banCall($api, $scope, $keyID, 0, $e->getCode() . ': ' . $e->getMessage()); return; } catch (\Pheal\Exceptions\PhealException $e) { throw $e; } // Check if the data in the database is still considered up to date. // checkDbCache will return true if this is the case if (!BaseApi::checkDbCache($scope, $api, $member_tracking->cached_until, $corporationID)) { // Get a list of the current corporation members. Once we are done with the member // updates, we will just go and delete the members that are left in this array, assuming // that they are no longer in this corporation. $existing_members = array(); foreach (\EveCorporationMemberTracking::where('corporationID', $corporationID)->get() as $member) { $existing_members[] = $member->characterID; } // Flip the array so that the keys are the characterID's $existing_members = array_flip($existing_members); // Process the results from the API call foreach ($member_tracking->members as $member) { $member_data = \EveCorporationMemberTracking::where('characterID', '=', $member->characterID)->where('corporationID', '=', $corporationID)->first(); if (!$member_data) { $member_data = new \EveCorporationMemberTracking(); } $member_data->characterID = $member->characterID; $member_data->corporationID = $corporationID; $member_data->name = $member->name; $member_data->startDateTime = $member->startDateTime; $member_data->baseID = $member->baseID; $member_data->base = $member->base; $member_data->title = $member->title; $member_data->logonDateTime = $member->logonDateTime; $member_data->logoffDateTime = $member->logoffDateTime; $member_data->locationID = $member->locationID; $member_data->location = $member->location; $member_data->shipTypeID = $member->shipTypeID; $member_data->shipType = $member->shipType; $member_data->roles = $member->roles; $member_data->grantableRoles = $member->grantableRoles; $member_data->save(); // Remove this member from the existing members unset($existing_members[$member->characterID]); } // Next, remove the members that were not in the API call. if (count($existing_members) > 0) { \EveCorporationMemberTracking::whereIn('characterID', array_keys($existing_members))->delete(); } // Update the cached_until time in the database for this api call BaseApi::setDbCache($scope, $api, $member_tracking->cached_until, $corporationID); } // Unlock the call BaseApi::unlockCall($lockhash); return $member_tracking; }