/**
* 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);
}
