<?php

namespace App\Database\Seeds;

use CodeIgniter\Database\Seeder;

class DefaultCategoriesSeeder extends Seeder
{
    public function run(): void
    {
        $now = date('Y-m-d H:i:s');

        $rows = [
            // Przychody
            ['name' => 'Wynagrodzenie',   'type' => 'income',  'parent_id' => null],
            ['name' => 'Premia',          'type' => 'income',  'parent_id' => null],
            ['name' => 'Inne przychody',  'type' => 'income',  'parent_id' => null],
            // Wydatki
            ['name' => 'Mieszkanie',      'type' => 'expense', 'parent_id' => null],
            ['name' => 'Jedzenie',        'type' => 'expense', 'parent_id' => null],
            ['name' => 'Transport',       'type' => 'expense', 'parent_id' => null],
            ['name' => 'Rozrywka',        'type' => 'expense', 'parent_id' => null],
            ['name' => 'Zdrowie',         'type' => 'expense', 'parent_id' => null],
            ['name' => 'Inne wydatki',    'type' => 'expense', 'parent_id' => null],
        ];

        foreach ($rows as &$r) {
            $r['created_at'] = $now;
            $r['updated_at'] = $now;
        }

        // Nie duplikuj, jesli seeder juz raz przeszedl
        if ((int) $this->db->table('categories')->countAllResults() === 0) {
            $this->db->table('categories')->insertBatch($rows);
        }
    }
}