<?php

namespace App\Database\Seeds;

use CodeIgniter\Database\Seeder;

class InitialSeeder extends Seeder
{
    public function run()
    {
        $db = \Config\Database::connect();

        $adminEmail = 'admin@chartboard.local';
        $existing   = $db->table('users')->where('email', $adminEmail)->get()->getRowArray();

        if (! $existing) {
            $db->table('users')->insert([
                'name'           => 'Super Admin',
                'email'          => $adminEmail,
                'password'       => password_hash('Admin@1234', PASSWORD_DEFAULT),
                'role'           => 'superadmin',
                'email_verified' => 1,
                'is_active'      => 1,
                'created_at'     => date('Y-m-d H:i:s'),
                'updated_at'     => date('Y-m-d H:i:s'),
            ]);
        }

        $admin = $db->table('users')->where('email', $adminEmail)->get()->getRowArray();
        if (! $admin) {
            return;
        }

        $workspaceName = 'Default Workspace';
        $workspaceSlug = 'default-workspace';

        $workspace = $db->table('workspaces')->where('slug', $workspaceSlug)->get()->getRowArray();
        if (! $workspace) {
            $db->table('workspaces')->insert([
                'name'            => $workspaceName,
                'slug'            => $workspaceSlug,
                'description'     => 'Default workspace created by seeder',
                'timezone'        => 'Asia/Kolkata',
                'default_refresh' => 300,
                'owner_id'        => (int) $admin['id'],
                'is_active'       => 1,
                'created_at'      => date('Y-m-d H:i:s'),
                'updated_at'      => date('Y-m-d H:i:s'),
            ]);
            $workspace = $db->table('workspaces')->where('slug', $workspaceSlug)->get()->getRowArray();
        }

        if (! $workspace) {
            return;
        }

        $membership = $db->table('workspace_members')
            ->where('workspace_id', (int) $workspace['id'])
            ->where('user_id', (int) $admin['id'])
            ->get()
            ->getRowArray();

        if (! $membership) {
            $db->table('workspace_members')->insert([
                'workspace_id' => (int) $workspace['id'],
                'user_id'      => (int) $admin['id'],
                'role'         => 'admin',
                'joined_at'    => date('Y-m-d H:i:s'),
                'created_at'   => date('Y-m-d H:i:s'),
                'updated_at'   => date('Y-m-d H:i:s'),
            ]);
        }
    }
}