@extends('layouts.app')

@section('title', 'Emisyon Faktörleri - CSV İçe Aktarma')

@section('content')
<div class="d-flex justify-content-between align-items-center pt-3 pb-2 mb-3 border-bottom">
    <h1 class="h2"><i class="bi bi-upload me-2 text-primary"></i> Emisyon Faktörleri - CSV İçe Aktarma</h1>
    <div class="btn-group">
        <a href="{{ route('admin.emission-factors.download.sample') }}" class="btn btn-outline-success"><i class="bi bi-filetype-csv me-1"></i> Örnek CSV İndir</a>
        <a href="{{ route('admin.emission-factors.download.export') }}" class="btn btn-outline-primary"><i class="bi bi-download me-1"></i> Tüm Faktörler (CSV)</a>
        <a href="{{ route('admin.emission-factors.index') }}" class="btn btn-outline-secondary"><i class="bi bi-arrow-left me-1"></i> Listeye Dön</a>
    </div>
</div>

<div class="row">
    <div class="col-12 col-lg-8">
        @if(session('import_queued'))
        <div class="alert alert-info d-flex justify-content-between align-items-center">
            <div>
                İçe aktarma kuyruğa alındı. İşlem tamamlandığında sonuçlar "import-results" klasörüne yazılacak.
            </div>
            <a href="{{ session('results_url') }}" class="btn btn-sm btn-outline-primary"><i class="bi bi-journal-arrow-down me-1"></i> Sonuçları Gör</a>
        </div>
        @endif
        <div class="card">
            <div class="card-header">CSV Yükleme</div>
            <div class="card-body">
                <form method="POST" action="{{ route('admin.emission-factors.import.store') }}" enctype="multipart/form-data" class="row g-3">
                    @csrf
                    <div class="col-12">
                        <label class="form-label">CSV Dosyası <span class="text-danger">*</span></label>
                        <input type="file" name="file" accept=".csv,.txt" class="form-control @error('file') is-invalid @enderror" required>
                        @error('file')<div class="invalid-feedback">{{ $message }}</div>@enderror
                    </div>
                    <div class="col-12">
                        <div class="form-check">
                            <input class="form-check-input" type="checkbox" name="update_if_exists" value="1" id="update_if_exists" checked>
                            <label class="form-check-label" for="update_if_exists">
                                Mevcut kaydı ada göre bulursam güncelle
                            </label>
                        </div>
                    </div>
                    <div class="col-12">
                        <div class="form-check">
                            <input class="form-check-input" type="checkbox" name="process_async" value="1" id="process_async">
                            <label class="form-check-label" for="process_async">
                                Kuyrukta işle (önerilir)
                            </label>
                        </div>
                        <div class="form-text">Dosya 2MB üzerindeyse otomatik olarak kuyrukta işlenecek. Hatalı satırlar için indirilebilir CSV üretilecektir.</div>
                    </div>
                    <div class="col-12 d-flex justify-content-end gap-2">
                        <button class="btn btn-primary" type="submit"><i class="bi bi-upload me-1"></i> İçe Aktar</button>
                    </div>
                </form>
            </div>
        </div>

        @if(session('import_result'))
        @php($r = session('import_result'))
        <div class="card mt-3">
            <div class="card-header">Sonuç</div>
            <div class="card-body">
                <ul class="list-unstyled mb-3">
                    <li><strong>Başarılı eklenen:</strong> {{ $r['success'] ?? 0 }}</li>
                    <li><strong>Güncellenen:</strong> {{ $r['updated'] ?? 0 }}</li>
                    <li><strong>Hatalı satır:</strong> {{ isset($r['errors']) ? count($r['errors']) : 0 }}</li>
                </ul>
                @if(session('import_error_csv'))
                    <div class="mb-3">
                        <a href="{{ session('import_error_csv') }}" class="btn btn-sm btn-outline-danger">
                            <i class="bi bi-filetype-csv me-1"></i> Hatalı Satırlar (CSV) İndir
                        </a>
                    </div>
                @endif
                @if(!empty($r['errors']))
                    <div class="table-responsive">
                        <table class="table table-sm table-striped">
                            <thead>
                                <tr>
                                    <th>Satır</th>
                                    <th>Hatalar</th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach($r['errors'] as $err)
                                    <tr>
                                        <td>{{ $err['row'] ?? '?' }}</td>
                                        <td>
                                            <ul class="mb-0">
                                                @foreach(($err['messages'] ?? []) as $msg)
                                                    <li>{{ $msg }}</li>
                                                @endforeach
                                            </ul>
                                        </td>
                                    </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>
                @endif
            </div>
        </div>
        @endif
    </div>

    <div class="col-lg-5">
        <div class="card h-100">
            <div class="card-header">CSV Şeması ve Örnek</div>
            <div class="card-body">
                <p class="text-muted">Zorunlu sütunlar: <code>name, category, subcategory, unit, co2_factor, ch4_factor, n2o_factor, scope</code></p>
                <p class="text-muted">Opsiyonel sütunlar: <code>source, reference, reference_year, is_active, description</code></p>
                <pre class="bg-light p-2 small" style="white-space: pre-wrap;">
name,category,subcategory,unit,co2_factor,ch4_factor,n2o_factor,scope,source,reference,reference_year,is_active,description
Electricity - TR Grid (IPCC rep.),energy,electricity_tr,kWh,0.468,0.00001,0.00001,scope2,IPCC/TR,IPCC defaults adapted for TR grid (rep.),2023,1,TR elektrik şebekesi
Natural Gas (TR) - Combustion,energy,natural_gas_tr,m³,1.96,0.0003,0.0001,scope1,IPCC/TR,IPCC 2006/2019,2019,1,TR doğalgaz
Diesel (TR) - Heavy Duty,transport,diesel_tr,liter,2.68,0.0001,0.0004,scope1,IPCC/TR,IPCC 2006/2019,2019,1,TR dizel
                </pre>
                <p class="text-muted mb-0">Not: <code>scope</code> alanı <code>scope1|scope2|scope3</code> şeklinde veya <code>Scope 1|2|3</code> ya da <code>1|2|3</code> olarak verilebilir; sistem otomatik dönüştürür.</p>
            </div>
        </div>
    </div>
</div>
@endsection