31 lines
714 B
PHP
Executable File
31 lines
714 B
PHP
Executable File
<?php
|
|
|
|
namespace Database\Seeders;
|
|
|
|
use Illuminate\Database\Seeder;
|
|
use Illuminate\Support\Facades\DB;
|
|
|
|
class ProvinsiSeeder extends Seeder
|
|
{
|
|
/**
|
|
* Run the database seeds.
|
|
*
|
|
* @return void
|
|
*/
|
|
public function run()
|
|
{
|
|
$csv = new CsvtoArray();
|
|
$file = __DIR__ . '/csv/provinces.csv';
|
|
$header = ['id', 'nama', 'lat', 'long'];
|
|
$data = $csv->csv_to_array($file, $header);
|
|
$data = array_map(function ($arr) {
|
|
$arr['coordinate'] = json_encode(['lat' => $arr['lat'], 'long' => $arr['long']]);
|
|
unset($arr['lat'], $arr['long']);
|
|
|
|
return $arr;
|
|
}, $data);
|
|
|
|
DB::table('provinsi')->insert($data);
|
|
}
|
|
}
|