public function jsonadd(Request $request) { $data = json_decode($request->getContent(), true); foreach ($data as $d) { $apt = new AirportsAPI(); $depicao = Airport::where('icao', $d['depicao'])->get(); $arricao = Airport::where('icao', $d['arricao'])->get(); if ($depicao->isEmpty()) { $apt->addFromDB($d['depicao']); } if ($arricao->isEmpty()) { $apt->addFromDB($d['arricao']); } $entry = new Schedule(); $entry->code = $d['code']; $entry->flightnum = $d['flightnum']; $entry->depicao = $d['depicao']; $entry->arricao = $d['arricao']; $entry->route = $d['route']; $entry->aircraft = $d['aircraft']; $entry->type = $d['type']; $entry->daysofweek = $d['daysofweek']; $entry->enabled = $d['enabled']; $entry->save(); } }
/** * Gets an airport by code * * @param string $code The airport code * @return Illuminate\Database\Query\Buildert */ public function getByCode($code) { return \App\Models\Airport::where('code', '=', $code); }