/** * @param $result */ public function _update_character_info($result) { $character_info = CharacterInfoModel::firstOrNew(['characterID' => $result->characterID]); $character_info->fill(['characterName' => $result->characterName, 'race' => $result->race, 'bloodline' => $result->bloodline, 'bloodlineID' => $result->bloodlineID, 'ancestry' => $result->ancestry, 'ancestryID' => $result->ancestryID, 'corporationID' => $result->corporationID, 'corporation' => $result->corporation, 'corporationDate' => $result->corporationDate, 'securityStatus' => $result->securityStatus, 'accountBalance' => $result->accountBalance, 'skillPoints' => $result->skillPoints, 'nextTrainingEnds' => $result->nextTrainingEnds, 'shipName' => $result->shipName, 'shipTypeID' => $result->shipTypeID, 'shipTypeName' => $result->shipTypeName, 'allianceID' => $result->allianceID, 'alliance' => $result->alliance, 'allianceDate' => $result->allianceDate, 'lastKnownLocation' => $result->lastKnownLocation]); $character_info->save(); foreach ($result->employmentHistory as $employment) { CharacterInfoEmploymentHistory::firstOrCreate(['characterID' => $result->characterID, 'recordID' => $employment->recordID, 'corporationID' => $employment->corporationID, 'corporationName' => $employment->corporationName, 'startDate' => $employment->startDate]); } return; }
/** * Return the employment history for a character * * @param int $character_id * * @return \Illuminate\Support\Collection|mixed */ public function getCharacterEmploymentHistory(int $character_id) : Collection { return CharacterInfoEmploymentHistory::where('characterID', $character_id)->orderBy('startDate', 'desc')->get(); }