<?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);
    }
}