34 lines
845 B
PHP
Executable File
34 lines
845 B
PHP
Executable File
<?php
|
|
|
|
namespace Database\Seeders;
|
|
|
|
use Illuminate\Database\Seeder;
|
|
use Illuminate\Support\Facades\DB;
|
|
|
|
class KabupatenSeeder extends Seeder
|
|
{
|
|
/**
|
|
* Run the database seeds.
|
|
*
|
|
* @return void
|
|
*/
|
|
public function run()
|
|
{
|
|
$Csv = new CsvtoArray();
|
|
$file = __DIR__ . '/csv/cities.csv';
|
|
$header = ['id', 'provinsi_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);
|
|
|
|
$collection = collect($data);
|
|
foreach ($collection->chunk(50) as $chunk) {
|
|
DB::table('kabupaten')->insert($chunk->toArray());
|
|
}
|
|
}
|
|
}
|