@extends('layouts.mainlayout')
@section('fullwidth', true)

@section('content')
@php
    $taxYears = collect(DB::select("SELECT SUBSTRING_INDEX(table_name, '_', -1) AS year FROM information_schema.tables WHERE table_schema = DATABASE() AND table_name REGEXP '^konyvel_ado_[0-9]{4}$' ORDER BY table_name DESC"));
@endphp

<div class="smarthr-worker-module smarthr-csv-lists-module smarthr-accountancy-csv-lists">
    <header class="smarthr-demo-page-breadcrumb smarthr-module-page-header">
        <div>
            <h2>Accountancy CSV Lists</h2>
            <ol><li><a href="/home"><i class="fas fa-home"></i></a></li><li>Accountancy</li><li class="active">CSV Lists</li></ol>
        </div>
    </header>

    <div class="smarthr-csv-lists-body">
        <div class="smarthr-csv-grid">
            <section class="smarthr-csv-card">
                <header><i class="fas fa-calendar-alt"></i><span>Time spent in Sweden</span></header>
                <form action="{{ route('gen_time_in_sw', ['id' => 1]) }}" method="POST">
                    @csrf
                    <div class="smarthr-csv-fields cols-2">
                        <label>Start date<input class="form-control smarthr-datepicker" type="text" name="s_date" required></label>
                        <label>End date<input class="form-control smarthr-datepicker" type="text" name="e_date" value="{{ date('Y-m-d') }}" required></label>
                    </div>
                    <div class="smarthr-csv-actions"><button class="btn btn-primary" type="submit"><i class="fas fa-file-export"></i> Generate CSV</button></div>
                </form>
            </section>

            <section class="smarthr-csv-card">
                <header><i class="fas fa-file-invoice-dollar"></i><span>Skatteverket CSV list</span></header>
                <form action="{{ route('skatt_csv_list_gen', ['id' => 1]) }}" method="POST">
                    @csrf
                    <p class="smarthr-csv-help">Select the tax year to download.</p>
                    <div class="smarthr-csv-year-grid">
                        @forelse ($taxYears as $item)
                            <button class="btn btn-outline-primary" type="submit" name="table_name" value="{{ $item->year }}"><i class="far fa-calendar"></i> {{ $item->year }}</button>
                        @empty
                            <span class="smarthr-csv-empty">No tax years available.</span>
                        @endforelse
                    </div>
                </form>
            </section>

            <section class="smarthr-csv-card">
                <header><i class="fas fa-coins"></i><span>Salary sum</span></header>
                <form action="{{ route('salary_sum', ['id' => 5]) }}" method="POST">
                    @csrf
                    <p class="smarthr-csv-help">Select the accounting year to export.</p>
                    <div class="smarthr-csv-year-grid">
                        @forelse ($taxYears as $item)
                            <button class="btn btn-outline-primary" type="submit" name="year" value="{{ $item->year }}"><i class="far fa-calendar"></i> {{ $item->year }}</button>
                        @empty
                            <span class="smarthr-csv-empty">No accounting years available.</span>
                        @endforelse
                    </div>
                </form>
            </section>
        </div>
    </div>
</div>

<link href="/css/gijgo.min.css" rel="stylesheet" type="text/css">
<script src="/vendor/jquery/jquery.min.js"></script>
<script src="/vendor/js/gijgo.min.js"></script>
<script>
    $(function () {
        $('.smarthr-datepicker').each(function () {
            $(this).datepicker({ uiLibrary: 'bootstrap4', format: 'yyyy-mm-dd' });
        });
    });
</script>
@endsection