<?php

namespace Database\Seeders;

use App\Enums\AccountTypeEnum;
use App\Enums\ApprovalStatusEnum;
use App\Enums\BankAccountTypeEnum;
use App\Enums\UserTypeEnum;
use App\Enums\WorkingPeriodEnum;
use App\Models\Address;
use App\Models\City;
use App\Models\Provider;
use App\Models\ProviderPaymentMethod;
use App\Models\ProviderServicesType;
use App\Models\ProviderSpeciality;
use App\Models\ProviderWorkingDay;
use App\Models\Speciality;
use App\Models\ServiceType;
use App\Models\State;
use App\Models\User;
use Illuminate\Database\Seeder;
use Illuminate\Support\Facades\DB;

class ProviderSeeder extends Seeder
{
    public function run(): void
    {
        $providers = [
            [
                'user' => [
                    'name' => 'Prestador Teste',
                    'email' => 'prestador.teste@softpar.inf.br',
                    'phone' => '11990000001',
                    'code' => '100001',
                    'password' => 'S@ft2080.',
                    'type' => UserTypeEnum::PROVIDER,
                    'email_verified_at' => now(),
                    'validated_code' => true,
                    'registration_complete' => true,
                ],
                'provider' => [
                    'document' => '52998224725',
                    'rg' => '12.345.678-9',
                    'birth_date' => '1988-03-12',
                    'average_rating' => 4.9,
                    'total_services' => 128,
                    'selfie_verified' => true,
                    'document_verified' => true,
                    'approval_status' => ApprovalStatusEnum::ACCEPTED,
                    'daily_price_8h' => 180.00,
                    'daily_price_6h' => 140.00,
                    'daily_price_4h' => 110.00,
                    'daily_price_2h' => 80.00,
                ],
                'address' => [
                    'zip_code' => '01001000',
                    'address' => 'Praça da Sé',
                    'number' => '100',
                    'district' => 'Sé',
                    'complement' => 'Sala 12',
                    'nickname' => 'Base Centro',
                    'instructions' => 'Atendimento pela portaria principal.',
                    'state_code' => 'SP',
                    'city_name' => 'São Paulo',
                    'address_type' => 'home',
                    'is_primary' => true,
                    'latitude' => -23.550520,
                    'longitude' => -46.633308,
                ],
                'payment_method' => [
                    'account_type' => AccountTypeEnum::PIX,
                    'pix_key' => 'prestador.teste@softpar.inf.br',
                ],
                'service_types' => [
                    'Limpeza residencial',
                    'Passadoria',
                    'Organização de ambientes',
                ],
                'specialities' => [
                    'Casa',
                    'Apartamento',
                    'Banheiro',
                ],
                'working_days' => [
                    ['day' => 1, 'period' => WorkingPeriodEnum::MORNING->value],
                    ['day' => 2, 'period' => WorkingPeriodEnum::MORNING->value],
                    ['day' => 3, 'period' => WorkingPeriodEnum::MORNING->value],
                    ['day' => 4, 'period' => WorkingPeriodEnum::MORNING->value],
                    ['day' => 5, 'period' => WorkingPeriodEnum::MORNING->value],
                ],
            ],
            [
                'user' => [
                    'name' => 'Mariana Souza',
                    'email' => 'mariana.souza@softpar.inf.br',
                    'phone' => '11990000002',
                    'code' => '100002',
                    'password' => 'S@ft2080.',
                    'type' => UserTypeEnum::PROVIDER,
                    'email_verified_at' => now(),
                    'validated_code' => true,
                    'registration_complete' => true,
                ],
                'provider' => [
                    'document' => '11144477735',
                    'rg' => '21.456.789-0',
                    'birth_date' => '1991-07-24',
                    'average_rating' => 4.7,
                    'total_services' => 96,
                    'selfie_verified' => true,
                    'document_verified' => true,
                    'approval_status' => ApprovalStatusEnum::ACCEPTED,
                    'daily_price_8h' => 210.00,
                    'daily_price_6h' => 160.00,
                    'daily_price_4h' => 120.00,
                    'daily_price_2h' => 90.00,
                ],
                'address' => [
                    'zip_code' => '20040002',
                    'address' => 'Avenida Rio Branco',
                    'number' => '120',
                    'district' => 'Centro',
                    'complement' => '8 andar',
                    'nickname' => 'Base Centro RJ',
                    'instructions' => 'Recepção no térreo.',
                    'state_code' => 'RJ',
                    'city_name' => 'Rio de Janeiro',
                    'address_type' => 'home',
                    'is_primary' => true,
                    'latitude' => -22.906847,
                    'longitude' => -43.172896,
                ],
                'payment_method' => [
                    'account_type' => AccountTypeEnum::BANK_ACCOUNT,
                    'bank_account_type' => BankAccountTypeEnum::CHECKING,
                    'agency' => '1234',
                    'account' => '998877',
                    'digit' => '0',
                ],
                'service_types' => [
                    'Limpeza comercial',
                    'Limpeza pós-obra',
                ],
                'specialities' => [
                    'Escritório',
                    'Vidros',
                    'Faxina pesada',
                ],
                'working_days' => [
                    ['day' => 1, 'period' => WorkingPeriodEnum::MORNING->value],
                    ['day' => 2, 'period' => WorkingPeriodEnum::MORNING->value],
                    ['day' => 3, 'period' => WorkingPeriodEnum::MORNING->value],
                    ['day' => 4, 'period' => WorkingPeriodEnum::MORNING->value],
                    ['day' => 5, 'period' => WorkingPeriodEnum::MORNING->value],
                    ['day' => 6, 'period' => WorkingPeriodEnum::MORNING->value],
                ],
            ],
            [
                'user' => [
                    'name' => 'Ana Costa',
                    'email' => 'ana.costa@softpar.inf.br',
                    'phone' => '11990000003',
                    'code' => '100003',
                    'password' => 'S@ft2080.',
                    'type' => UserTypeEnum::PROVIDER,
                    'email_verified_at' => now(),
                    'validated_code' => true,
                    'registration_complete' => true,
                ],
                'provider' => [
                    'document' => '16899535009',
                    'rg' => '32.987.654-1',
                    'birth_date' => '1987-11-03',
                    'average_rating' => 4.8,
                    'total_services' => 142,
                    'selfie_verified' => true,
                    'document_verified' => true,
                    'approval_status' => ApprovalStatusEnum::ACCEPTED,
                    'daily_price_8h' => 170.00,
                    'daily_price_6h' => 130.00,
                    'daily_price_4h' => 100.00,
                    'daily_price_2h' => 70.00,
                ],
                'address' => [
                    'zip_code' => '30140071',
                    'address' => 'Avenida Afonso Pena',
                    'number' => '500',
                    'district' => 'Centro',
                    'complement' => 'Conjunto 1205',
                    'nickname' => 'Base BH',
                    'instructions' => 'Entrada pela lateral do edifício.',
                    'state_code' => 'MG',
                    'city_name' => 'Belo Horizonte',
                    'address_type' => 'home',
                    'is_primary' => true,
                    'latitude' => -19.916681,
                    'longitude' => -43.934493,
                ],
                'payment_method' => [
                    'account_type' => AccountTypeEnum::PIX,
                    'pix_key' => 'ana.costa@softpar.inf.br',
                ],
                'service_types' => [
                    'Lavanderia',
                    'Passadoria',
                    'Organização de ambientes',
                ],
                'specialities' => [
                    'Closet',
                    'Cozinha',
                    'Lavanderia',
                ],
                'working_days' => [
                    ['day' => 2, 'period' => WorkingPeriodEnum::AFTERNOON->value],
                    ['day' => 3, 'period' => WorkingPeriodEnum::AFTERNOON->value],
                    ['day' => 4, 'period' => WorkingPeriodEnum::AFTERNOON->value],
                    ['day' => 5, 'period' => WorkingPeriodEnum::AFTERNOON->value],
                    ['day' => 6, 'period' => WorkingPeriodEnum::MORNING->value],
                ],
            ],
            [
                'user' => [
                    'name' => 'Juliana Lima',
                    'email' => 'juliana.lima@softpar.inf.br',
                    'phone' => '11990000004',
                    'code' => '100004',
                    'password' => 'S@ft2080.',
                    'type' => UserTypeEnum::PROVIDER,
                    'email_verified_at' => now(),
                    'validated_code' => true,
                    'registration_complete' => true,
                ],
                'provider' => [
                    'document' => '12345678909',
                    'rg' => '45.321.987-6',
                    'birth_date' => '1993-02-15',
                    'average_rating' => 4.6,
                    'total_services' => 87,
                    'selfie_verified' => true,
                    'document_verified' => true,
                    'approval_status' => ApprovalStatusEnum::ACCEPTED,
                    'daily_price_8h' => 190.00,
                    'daily_price_6h' => 150.00,
                    'daily_price_4h' => 115.00,
                    'daily_price_2h' => 75.00,
                ],
                'address' => [
                    'zip_code' => '80010020',
                    'address' => 'Rua XV de Novembro',
                    'number' => '250',
                    'district' => 'Centro',
                    'complement' => 'Sala 3',
                    'nickname' => 'Base Curitiba',
                    'instructions' => 'Subir até o segundo andar.',
                    'state_code' => 'PR',
                    'city_name' => 'Curitiba',
                    'address_type' => 'home',
                    'is_primary' => true,
                    'latitude' => -25.428356,
                    'longitude' => -49.273251,
                ],
                'payment_method' => [
                    'account_type' => AccountTypeEnum::BANK_ACCOUNT,
                    'bank_account_type' => BankAccountTypeEnum::SAVINGS,
                    'agency' => '4321',
                    'account' => '112233',
                    'digit' => '5',
                ],
                'service_types' => [
                    'Limpeza residencial',
                    'Limpeza pós-obra',
                    'Lavanderia',
                ],
                'specialities' => [
                    'Casa',
                    'Apartamento',
                    'Organização de ambientes',
                ],
                'working_days' => [
                    ['day' => 1, 'period' => WorkingPeriodEnum::MORNING->value],
                    ['day' => 2, 'period' => WorkingPeriodEnum::MORNING->value],
                    ['day' => 3, 'period' => WorkingPeriodEnum::MORNING->value],
                    ['day' => 4, 'period' => WorkingPeriodEnum::MORNING->value],
                    ['day' => 5, 'period' => WorkingPeriodEnum::AFTERNOON->value],
                ],
            ],
            [
                'user' => [
                    'name' => 'Renata Alves',
                    'email' => 'renata.alves@softpar.inf.br',
                    'phone' => '11990000005',
                    'code' => '100005',
                    'password' => 'S@ft2080.',
                    'type' => UserTypeEnum::PROVIDER,
                    'email_verified_at' => now(),
                    'validated_code' => true,
                    'registration_complete' => true,
                ],
                'provider' => [
                    'document' => '93541134780',
                    'rg' => '58.741.236-4',
                    'birth_date' => '1990-09-08',
                    'average_rating' => 4.5,
                    'total_services' => 75,
                    'selfie_verified' => true,
                    'document_verified' => true,
                    'approval_status' => ApprovalStatusEnum::ACCEPTED,
                    'daily_price_8h' => 175.00,
                    'daily_price_6h' => 135.00,
                    'daily_price_4h' => 105.00,
                    'daily_price_2h' => 65.00,
                ],
                'address' => [
                    'zip_code' => '90010010',
                    'address' => 'Avenida Borges de Medeiros',
                    'number' => '700',
                    'district' => 'Centro Histórico',
                    'complement' => 'Andar 6',
                    'nickname' => 'Base POA',
                    'instructions' => 'Interfone para o bloco B.',
                    'state_code' => 'RS',
                    'city_name' => 'Porto Alegre',
                    'address_type' => 'home',
                    'is_primary' => true,
                    'latitude' => -30.034647,
                    'longitude' => -51.217659,
                ],
                'payment_method' => [
                    'account_type' => AccountTypeEnum::PIX,
                    'pix_key' => 'renata.alves@softpar.inf.br',
                ],
                'service_types' => [
                    'Limpeza residencial',
                    'Limpeza comercial',
                ],
                'specialities' => [
                    'Escritório',
                    'Cozinha',
                    'Banheiro',
                ],
                'working_days' => [
                    ['day' => 1, 'period' => WorkingPeriodEnum::AFTERNOON->value],
                    ['day' => 2, 'period' => WorkingPeriodEnum::AFTERNOON->value],
                    ['day' => 3, 'period' => WorkingPeriodEnum::AFTERNOON->value],
                    ['day' => 4, 'period' => WorkingPeriodEnum::AFTERNOON->value],
                    ['day' => 5, 'period' => WorkingPeriodEnum::AFTERNOON->value],
                ],
            ],
        ];

        DB::transaction(function () use ($providers): void {
            foreach ($providers as $data) {
                $user = User::updateOrCreate(
                    ['email' => $data['user']['email']],
                    $data['user']
                );

                $provider = Provider::updateOrCreate(
                    ['user_id' => $user->id],
                    $data['provider'] + [
                        'user_id' => $user->id,
                    ]
                );

                $this->seedAddress($provider->id, $data['address']);
                $this->seedPaymentMethod($provider->id, $data['payment_method']);
                $this->seedProviderServicesTypes($provider->id, $data['service_types']);
                $this->seedProviderSpecialities($provider->id, $data['specialities']);
                $this->seedProviderWorkingDays($provider->id, $data['working_days']);
            }
        });
    }

    private function seedAddress(int $providerId, array $data): void
    {
        $state = State::query()
            ->whereRaw('LOWER(code) = ?', [mb_strtolower($data['state_code'])])
            ->first();

        $city = null;
        if ($state) {
            $city = City::query()
                ->where('state_id', $state->id)
                ->whereRaw('LOWER(name) = ?', [mb_strtolower($data['city_name'])])
                ->first();
        }

        Address::updateOrCreate(
            [
                'source' => 'provider',
                'source_id' => $providerId,
            ],
            [
                'zip_code' => $data['zip_code'],
                'address' => $data['address'],
                'number' => $data['number'] ?? null,
                'district' => $data['district'] ?? null,
                'has_complement' => !empty($data['complement']),
                'complement' => $data['complement'] ?? null,
                'nickname' => $data['nickname'] ?? null,
                'instructions' => $data['instructions'] ?? null,
                'city_id' => $city?->id,
                'state_id' => $state?->id,
                'address_type' => $data['address_type'] ?? 'home',
                'is_primary' => $data['is_primary'] ?? true,
                'latitude' => $data['latitude'] ?? null,
                'longitude' => $data['longitude'] ?? null,
            ]
        );
    }

    private function seedPaymentMethod(int $providerId, array $data): void
    {
        ProviderPaymentMethod::updateOrCreate(
            [
                'provider_id' => $providerId,
                'account_type' => $data['account_type']->value,
            ],
            [
                'provider_id' => $providerId,
                'account_type' => $data['account_type']->value,
                'pix_key' => $data['pix_key'] ?? null,
                'bank_account_type' => isset($data['bank_account_type'])
                    ? $data['bank_account_type']->value
                    : null,
                'agency' => $data['agency'] ?? null,
                'account' => $data['account'] ?? null,
                'digit' => $data['digit'] ?? null,
            ]
        );
    }

    private function seedProviderServicesTypes(int $providerId, array $descriptions): void
    {
        $serviceTypeIds = ServiceType::query()
            ->whereIn('description', $descriptions)
            ->pluck('id')
            ->all();

        foreach ($serviceTypeIds as $serviceTypeId) {
            ProviderServicesType::updateOrCreate(
                [
                    'provider_id' => $providerId,
                    'service_type_id' => $serviceTypeId,
                ],
                [
                    'provider_id' => $providerId,
                    'service_type_id' => $serviceTypeId,
                ]
            );
        }
    }

    private function seedProviderSpecialities(int $providerId, array $descriptions): void
    {
        $specialityIds = Speciality::query()
            ->whereIn('description', $descriptions)
            ->pluck('id')
            ->all();

        foreach ($specialityIds as $specialityId) {
            ProviderSpeciality::updateOrCreate(
                [
                    'provider_id' => $providerId,
                    'speciality_id' => $specialityId,
                ],
                [
                    'provider_id' => $providerId,
                    'speciality_id' => $specialityId,
                ]
            );
        }
    }

    private function seedProviderWorkingDays(int $providerId, array $workingDays): void
    {
        foreach ($workingDays as $workingDay) {
            ProviderWorkingDay::updateOrCreate(
                [
                    'provider_id' => $providerId,
                    'day' => $workingDay['day'],
                    'period' => $workingDay['period'],
                ],
                [
                    'provider_id' => $providerId,
                    'day' => $workingDay['day'],
                    'period' => $workingDay['period'],
                ]
            );
        }
    }
}