/**
* Execute the console command.
*
* @return mixed
*/
public function fire()
{
// Parse the CSV file and insert rows
$this->info('Loading CSV...');
$airportsFile = new File($this->argument('file'));
$airportsFile = $airportsFile->openFile();
$airportsFile->setFlags(SplFileObject::READ_CSV);
$this->info('Beginning Import...');
$i = 0;
foreach ($airportsFile as $airport) {
$i++;
if ($i % 10 == 0) {
$this->comment('Imported ' . $i . '...');
}
if (isset($airport[1]) && $i > 1) {
$insertAirport = new Airport();
$insertAirport->icao = $airport[1];
$insertAirport->iata = $airport[13];
$insertAirport->name = $airport[3];
$insertAirport->latitude = $airport[4];
$insertAirport->longitude = $airport[5];
$insertAirport->region_id = Region::where('code', '=', $airport[9])->first()->id;
$insertAirport->save();
}
}
$this->info('Import Complete! ' . $i . ' Airports Imported.');
}
public function postAdd(Request $request)
{
$airport = $request->input('icao');
$airportId = Airport::where('icao', $airport)->first();
$airline = Airline::find(Session::get('airlineId'));
$airline->airports()->save($airportId);
return view('staff.airports.dashboard');
}
/**
* Handle the event.
*
* @param PirepWasFiled $event
* @return void
*/
public function handle(PirepWasFiled $event)
{
if ($event->reProcess === false) {
// Move the Pilot to their destination field
$pilot = Pilot::find($event->pirep->booking->pilot->id);
$newLocation = Airport::find($event->pirep->booking->route->arrivalAirport->id);
$pilot->location()->associate($newLocation);
$pilot->save();
echo "Moved Pilot ID " . $pilot->id . " to Airport " . $newLocation->icao . PHP_EOL;
}
}
public function postAdd(Request $request)
{
$from = Airport::where('icao', $request->input('from'))->first();
$to = Airport::where('icao', $request->input('to'))->first();
$route = new \vAMSYS\Route();
$route->departure_id = $from->id;
$route->arrival_id = $to->id;
$route->route = $request->input('route');
$route->airline_id = Session::get('airlineId');
$route->save();
return view('staff.routes.dashboard');
}
