public function showIndex() { // Prepare some summarized totals for the home view to display in the // widgets // EVE Online Server Information $server = EveServerServerStatus::find(1); // Key Information // If the user has 0 keys, we can 0 all of the values // If the user has keys, determine values only applicable to // this users keys if (!\Auth::isSuperUser()) { if (count(Session::get('valid_keys')) > 0) { $total_keys = SeatKey::whereIn('keyID', Session::get('valid_keys'))->count(); $total_characters = EveCharacterCharacterSheet::join('account_apikeyinfo_characters', 'account_apikeyinfo_characters.characterID', '=', 'character_charactersheet.characterID')->join('account_apikeyinfo', 'account_apikeyinfo.keyID', '=', 'account_apikeyinfo_characters.keyID')->whereIn('account_apikeyinfo_characters.keyID', Session::get('valid_keys'))->where('account_apikeyinfo.type', '!=', 'Corporation')->count(); $total_corporations = EveCorporationCorporationSheet::join('account_apikeyinfo_characters', 'account_apikeyinfo_characters.corporationID', '=', 'corporation_corporationsheet.corporationID')->join('account_apikeyinfo', 'account_apikeyinfo.keyID', '=', 'account_apikeyinfo_characters.keyID')->whereIn('account_apikeyinfo_characters.keyID', Session::get('valid_keys'))->where('account_apikeyinfo.type', '=', 'Corporation')->count(); $total_char_isk = EveCharacterCharacterSheet::join('account_apikeyinfo_characters', 'account_apikeyinfo_characters.characterID', '=', 'character_charactersheet.characterID')->join('account_apikeyinfo', 'account_apikeyinfo.keyID', '=', 'account_apikeyinfo_characters.keyID')->whereIn('account_apikeyinfo_characters.keyID', Session::get('valid_keys'))->where('account_apikeyinfo.type', '!=', 'Corporation')->sum('balance'); $total_corp_isk = EveCorporationAccountBalance::join('account_apikeyinfo_characters', 'account_apikeyinfo_characters.corporationID', '=', 'corporation_accountbalance.corporationID')->join('account_apikeyinfo', 'account_apikeyinfo.keyID', '=', 'account_apikeyinfo_characters.keyID')->whereIn('account_apikeyinfo_characters.keyID', Session::get('valid_keys'))->where('account_apikeyinfo.type', '=', 'Corporation')->where('accountKey', '!=', EveCorporationAccountBalance::Dust_Account_Key)->sum('balance'); $total_skillpoints = EveCharacterCharacterSheetSkills::join('account_apikeyinfo_characters', 'account_apikeyinfo_characters.characterID', '=', 'character_charactersheet_skills.characterID')->join('account_apikeyinfo', 'account_apikeyinfo.keyID', '=', 'account_apikeyinfo_characters.keyID')->whereIn('account_apikeyinfo_characters.keyID', Session::get('valid_keys'))->where('account_apikeyinfo.type', '!=', 'Corporation')->sum('skillpoints'); } else { $total_keys = $total_characters = $total_corporations = $total_char_isk = $total_corp_isk = $total_skillpoints = 0; } } else { // Super user gets all of the data! $total_keys = SeatKey::count(); $total_characters = EveCharacterCharacterSheet::count(); $total_corporations = EveCorporationCorporationSheet::count(); $total_char_isk = EveCharacterCharacterSheet::sum('balance'); $total_corp_isk = EveCorporationAccountBalance::where('accountKey', '!=', EveCorporationAccountBalance::Dust_Account_Key)->sum('balance'); $total_skillpoints = EveCharacterCharacterSheetSkills::sum('skillpoints'); } return View::make('home')->with('server', $server)->with('total_keys', $total_keys)->with('total_characters', $total_characters)->with('total_corporations', $total_corporations)->with('total_char_isk', $total_char_isk)->with('total_corp_isk', $total_corp_isk)->with('total_skillpoints', $total_skillpoints); }
public static function Update($keyID, $vCode) { $row_count = 500; // 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 = 'WalletTransactions'; 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); // Prepare blank wallet_transactions to start $wallet_transactions = null; // Next, start our loop over the wallet divisions for this corporation foreach (\EveCorporationAccountBalance::where('corporationID', '=', $corporationID)->get() as $walletdivision) { // Start a infinite loop for the Journal Walking. We will break out of this once // we have reached the end of the records that we can get // TODO: This needs a lot more brain thingies applied in order to figure out how // we are going to go about the database cached_untill timer. For now, we will just // ignore the DB level one and rely entirely on pheal-ng to cache the XML's $first_request = true; $from_id = PHP_INT_MAX; // Use the maximum size for this PHP arch while (true) { // Do the actual API call. pheal-ng actually handles some internal // caching too. try { if ($first_request) { $wallet_transactions = $pheal->corpScope->WalletTransactions(array('characterID' => $characters[0], 'rowCount' => $row_count, 'accountKey' => $walletdivision->accountKey)); // flip the first_request as those that get processed from here need to be from the `fromID` $first_request = false; } else { $wallet_transactions = $pheal->corpScope->WalletTransactions(array('characterID' => $characters[0], 'rowCount' => $row_count, 'accountKey' => $walletdivision->accountKey, 'fromID' => $from_id)); } } 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; } // Process the transactions foreach ($wallet_transactions->transactions as $transaction) { // Ensure that $from_id is at its lowest $from_id = min($transaction->transactionID, $from_id); // Generate a transaction hash. It would seem that refID's could possibly be cycled. $transaction_hash = md5(implode(',', array($corporationID, $walletdivision->accountKey, $transaction->transactionDateTime, $transaction->clientID, $transaction->transactionID))); // In order try try and relieve some strain on the database, we will // cache the hashes that we find we have knowledge of. The main // goal of this is to make the lookups faster, and leave // MySQL to do stuff it should rather be doing // First, find thee entry in the cache. The cache key is determined // as: <transaction hash + corporationID + apitype> if (!\Cache::has($transaction_hash . $corporationID . $api)) { // If the $transaction_hash is not in the Cache, ask the database // if it knows about it. Again, if it exists, we will continue, // but we will also add a new Cache entry to make the next // lookip faster $transaction_data = \EveCorporationWalletTransactions::where('corporationID', '=', $corporationID)->where('hash', '=', $transaction_hash)->first(); // Check if the database found the entry. if (!$transaction_data) { $transaction_data = new \EveCorporationWalletTransactions(); } else { // This entry exists in the database. Put a new Cache entry // so that the next lookup may be faster. This cache // entry will live for 1 week. \Cache::put($transaction_hash . $corporationID . $api, true, 60 * 24 * 7); // Continue to the next transaction continue; } $transaction_data->corporationID = $corporationID; $transaction_data->hash = $transaction_hash; $transaction_data->accountKey = $walletdivision->accountKey; $transaction_data->transactionID = $transaction->transactionID; $transaction_data->transactionDateTime = $transaction->transactionDateTime; $transaction_data->quantity = $transaction->quantity; $transaction_data->typeName = $transaction->typeName; $transaction_data->typeID = $transaction->typeID; $transaction_data->price = $transaction->price; $transaction_data->clientID = $transaction->clientID; $transaction_data->clientName = $transaction->clientName; $transaction_data->stationID = $transaction->stationID; $transaction_data->stationName = $transaction->stationName; $transaction_data->transactionType = $transaction->transactionType; $transaction_data->transactionFor = $transaction->transactionFor; $transaction_data->journalTransactionID = $transaction->journalTransactionID; $transaction_data->clientTypeID = $transaction->clientTypeID; $transaction_data->save(); } else { // This entry already exists as the hash is cached. continue; } } // Check how many entries we got back. If it us less that $row_count, we know we have // walked back the entire journal if (count($wallet_transactions->transactions) < $row_count) { break; } // Break the while loop } } // Unlock the call BaseApi::unlockCall($lockhash); return $wallet_transactions; }
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 = 'AccountBalance'; 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 { $account_balance = $pheal->corpScope->AccountBalance(array('characterID' => $characters[0])); } 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, $account_balance->cached_until, $corporationID)) { // Update the accounts foreach ($account_balance->accounts as $account) { $account_data = \EveCorporationAccountBalance::where('corporationID', '=', $corporationID)->where('accountID', '=', $account->accountID)->first(); if (!$account_data) { $account_data = new \EveCorporationAccountBalance(); } $account_data->corporationID = $corporationID; $account_data->accountID = $account->accountID; $account_data->accountKey = $account->accountKey; $account_data->balance = $account->balance; $account_data->save(); } // Update the cached_until time in the database for this api call BaseApi::setDbCache($scope, $api, $account_balance->cached_until, $corporationID); } // Unlock the call BaseApi::unlockCall($lockhash); return $account_balance; }