/** * Run the database seeds. * * @return void */ public function run() { AirPollution::truncate(); $PM25 = "PM2.5"; $file = fopen(database_path() . '/datas/201603xx.csv', 'r'); while (!feof($file)) { $data = fgetcsv($file); if ($data[0] == 'County') { continue; } AirPollution::create(['county' => $data[0], 'sitename' => $data[1], 'pm25' => $data[2], 'wind_speed' => $data[3], 'wind_direc' => $data[4], 'publish_time' => $data[5]]); } /* $files = File::files('database/datas'); foreach ($files as $key => $value) { $json = File::get($value); $data = json_decode($json); foreach ($data as $key) { AirPollution::create([ 'county' => $key->County, 'sitename' => $key->SiteName, 'pm25' => $key->$PM25, 'wind_direc' => $key->WindDirec, 'wind_speed' => $key->WindSpeed, 'publish_time' => $key->PublishTime, ]); } } */ }
public function map() { $airPollutionDatas = AirPollution::all(); $stations = json_decode(File::get('json/stations.json')); $data = compact('stations'); // dd($data); return view('welcome', $data); }