<?php

namespace App\Livewire\Admin;

use Livewire\Component;
use Livewire\WithFileUploads;
use App\Models\CryptoNews;
use Maatwebsite\Excel\Facades\Excel;
use Illuminate\Support\Facades\Auth;
use App\Services\PermissionService;

class NewsSeoImport extends Component
{
    use WithFileUploads;

    public $file;
    public array $previewData = [];
    public $role_id;
    public $permissions = [];

    public function mount(PermissionService $permissionService)
    {
        $data = $permissionService->getUserPermissions();

        $this->permissions = $data['permissions'];
        $this->role_id = $data['role_id'];

        $this->previewData = session('seo_import_preview', []);

        if (!in_array(138, $this->permissions) && $this->role_id != 1) {
            session()->flash('error', 'You do not have permission to access Launchpads List.');
            return redirect()->route('admin.dashboard');
        }
    }

    public function preview()
    {
        $this->validate([
            'file' => 'required|mimes:xlsx,xls,csv|max:10240',
        ]);

        $rows = Excel::toArray([], $this->file)[0] ?? [];

        if (count($rows) < 2) {
            session()->flash('error', 'Sheet is empty.');
            return;
        }

        $headers = array_map(fn ($h) => trim($h), $rows[0]);

        if (!in_array('slug', $headers)) {
            session()->flash('error', 'slug column is required.');
            return;
        }

        $allowedFields = [
            'title',
            'alias',
            'h2_title',
            'img_alt_title',
            'focus_keyword',
            'seo_title',
            'meta_keywords',
            'meta_description',
            'breadcrumbs',
            'faqs',
        ];

        $slugIndex = array_search('slug', $headers);
        $previewData = [];

        unset($rows[0]);

        foreach ($rows as $row) {
            $slug = trim($row[$slugIndex] ?? '');

            if ($slug === '') {
                continue;
            }

            $news = CryptoNews::where('alias', $slug)->first();

            if (!$news) {
                $previewData[] = [
                    'news_id' => null,
                    'slug' => $slug,
                    'field_name' => '-',
                    'old_value' => '-',
                    'new_value' => '-',
                    'status' => 'Slug not found',
                ];
                continue;
            }

            foreach ($allowedFields as $field) {
                if (!in_array($field, $headers)) {
                    continue;
                }

                $fieldIndex = array_search($field, $headers);
                $newValue = trim($row[$fieldIndex] ?? '');
                $oldValue = $news->{$field};

                if ($field === 'faqs' && $newValue !== '') {
                    $decodedFaqs = json_decode($newValue, true);

                    if (json_last_error() !== JSON_ERROR_NONE || !is_array($decodedFaqs)) {
                        $previewData[] = [
                            'news_id' => $news->id,
                            'slug' => $slug,
                            'field_name' => $field,
                            'old_value' => $oldValue,
                            'new_value' => $newValue,
                            'status' => 'Invalid FAQ JSON format',
                        ];
                        continue;
                    }

                    foreach ($decodedFaqs as $faq) {
                        if (
                            !isset($faq['question']) ||
                            !isset($faq['answer']) ||
                            trim($faq['question']) === '' ||
                            trim($faq['answer']) === ''
                        ) {
                            $previewData[] = [
                                'news_id' => $news->id,
                                'slug' => $slug,
                                'field_name' => $field,
                                'old_value' => $oldValue,
                                'new_value' => $newValue,
                                'status' => 'FAQ must contain question and answer',
                            ];
                            continue 2;
                        }
                    }
                }

                if ((string) $oldValue !== (string) $newValue) {
                    $previewData[] = [
                        'news_id' => $news->id,
                        'slug' => $slug,
                        'field_name' => $field,
                        'old_value' => $oldValue,
                        'new_value' => $newValue,
                        'status' => 'Ready to update',
                    ];
                }
            }
        }

        $this->previewData = $previewData;

        session(['seo_import_preview' => $previewData]);
        session()->flash('success', 'Preview generated. Please confirm before saving.');
    }

    public function save()
    {
        if (empty($this->previewData)) {
            session()->flash('error', 'No preview data found.');
            return;
        }

        $hasError = collect($this->previewData)->contains(fn ($item) => $item['status'] !== 'Ready to update');

        if ($hasError) {
            session()->flash('error', 'Some rows have errors. Please fix FAQ format or slug issue before saving.');
            return;
        }

        $updated = 0;

        foreach ($this->previewData as $item) {
            CryptoNews::where('id', $item['news_id'])->update([
                $item['field_name'] => $item['new_value'],
            ]);

            $updated++;
        }

        $this->previewData = [];
        session()->forget('seo_import_preview');

        session()->flash('success', $updated . ' fields updated successfully.');
    }

    public function cancel()
    {
        $this->previewData = [];
        session()->forget('seo_import_preview');

        session()->flash('success', 'Preview changes cancelled.');
    }

    public function render()
    {
        return view('livewire.admin.news-seo-import')
            ->layout('admin.layouts.base');
    }
}
