<?php

use Illuminate\Database\Capsule\Manager as Capsule;
use App\Models\Module;
use Modules\Company\Models\Company;

class InsertUsersModule
{
    public function up()
    {
        $moduleData = [
            'modules_name' => 'users',
            'modules_display_name' => 'Users',
            'modules_description' => 'User management module',
            'modules_version' => '1.0.0',
            'modules_author' => 'SysCMS Team',
            'modules_ative' => true,
            'modules_public' => false,
            'modules_blocked' => false,
            'modules_dependencies' => ["auth"],
            'modules_permissions' => [
                "users.view",
                "users.create",
                "users.edit",
                "users.delete"
            ],
            'modules_settings' => [],
            'modules_path' => 'modules/users',
            'modules_namespace' => 'Modules\\Users',
            'modules_icon' => 'bi bi-people',
            'menu_side_bar' => true,
            'menu_nav_bar' => false,
            'modules_order' => 20,
            'modules_install_date' => date('Y-m-d H:i:s'),
            'modules_update_date' => date('Y-m-d H:i:s')
        ];

        $existingModule = Module::where('modules_name', 'users')->first();

        if (!$existingModule) {
            $module = Module::create($moduleData);
            
            if (Capsule::schema()->hasTable('bus')) {
                $companies = Company::all();
                foreach ($companies as $company) {
                    $exists = Capsule::table('bus_modules')
                        ->where('bus_modules_bus_id', $company->bus_id)
                        ->where('bus_modules_module_id', $module->modules_id)
                        ->exists();
                    
                    if (!$exists) {
                        Capsule::table('bus_modules')->insert([
                            'bus_modules_bus_id' => $company->bus_id,
                            'bus_modules_module_id' => $module->modules_id,
                            'bus_modules_is_enabled' => true,
                            'bus_modules_settings' => json_encode([]),
                            'bus_modules_enabled_by' => 1,
                            'bus_modules_enabled_at' => date('Y-m-d H:i:s'),
                            'bus_modules_show_public_nav' => true,
                            'bus_modules_show_dashboard_nav' => true,
                            'created_at' => date('Y-m-d H:i:s'),
                            'updated_at' => date('Y-m-d H:i:s')
                        ]);
                    }
                }
            }
        }
    }

    public function down()
    {
        $module = Module::where('modules_name', 'users')->first();
        if ($module) {
            Capsule::table('bus_modules')->where('bus_modules_module_id', $module->modules_id)->delete();
            $module->delete();
        }
    }
}