44 lines
1.2 KiB
PHP
44 lines
1.2 KiB
PHP
<?php
|
|
|
|
namespace Database\Seeders;
|
|
|
|
use App\Models\RekeningCoa;
|
|
use Illuminate\Database\Console\Seeds\WithoutModelEvents;
|
|
use Illuminate\Database\Seeder;
|
|
use Illuminate\Support\Facades\DB;
|
|
|
|
class RekeningCoaSeeder extends Seeder
|
|
{
|
|
/**
|
|
* Run the database seeds.
|
|
*/
|
|
public function run(): void
|
|
{
|
|
// Disable foreign key checks
|
|
DB::statement('SET FOREIGN_KEY_CHECKS=0;');
|
|
|
|
RekeningCoa::truncate();
|
|
|
|
// Enable foreign key checks
|
|
DB::statement('SET FOREIGN_KEY_CHECKS=1;');
|
|
|
|
$csvFile = fopen(base_path("database/seeders/data_csv/rekening_coa.csv"), "r");
|
|
$firstline = true;
|
|
|
|
while (($data = fgetcsv($csvFile, 1000, ",")) !== FALSE) {
|
|
if (!$firstline) {
|
|
RekeningCoa::create([
|
|
'kode_coa' => $data['0'],
|
|
'sub_kode_coa' => $data['1'],
|
|
'detail_coa' => $data['2'] == '' ? null : $data['2'],
|
|
'coa' => $data['3'],
|
|
'keterangan_coa' => $data['4'],
|
|
'status' => $data['5'],
|
|
]);
|
|
}
|
|
$firstline = false;
|
|
}
|
|
fclose($csvFile);
|
|
}
|
|
}
|