/**
* 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.');
}
/**
* Execute the console command.
*
* @return mixed
*/
public function fire()
{
// Parse the CSV file and insert rows
$this->info('Loading CSV...');
$regionsFile = new File($this->argument('file'));
$regionsFile = $regionsFile->openFile();
$regionsFile->setFlags(SplFileObject::READ_CSV);
$this->info('Beginning Import...');
$i = 0;
foreach ($regionsFile as $region) {
$i++;
if ($i % 10 == 0) {
$this->comment('Imported ' . $i . '...');
}
if (isset($region[1]) && $i > 1) {
$insertRegion = new Region();
$insertRegion->code = $region[1];
$insertRegion->name = $region[3];
$insertRegion->country_id = Country::where('code', '=', $region[5])->first()->id;
$insertRegion->save();
}
}
$this->info('Import Complete! ' . $i . ' Regions Imported.');
}
