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

@section('content')
@php
    $farms = DB::table('farm')->select('id', 'farm_name')->where('status', 1)->orderBy('farm_name')->get();
    $salaryYears = 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"));
    $exchangeRates = DB::table('a_sek_price')->orderByDesc('p_date')->limit(4)->get()->reverse();
    $exchangeExists = DB::table('a_sek_price')->whereYear('p_date', date('Y'))->whereMonth('p_date', date('m'))->exists();
    $canSeeAccounting = Auth::user()->hasRoleOrSuperAdmin('accountancy') || Auth::user()->hasRoleOrSuperAdmin('contactperson');
@endphp

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

    <div class="smarthr-csv-lists-body">
        @if (session('success'))<div class="alert alert-success">{{ session('success') }}</div>@endif
        @if (session('error'))<div class="alert alert-danger">{{ session('error') }}</div>@endif

        <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') }}" 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-venus-mars"></i><span>Staff gender on specific date</span></header>
                <form action="{{ route('gender_interval') }}" method="POST">
                    @csrf
                    <div class="smarthr-csv-fields">
                        <label>Date<input class="form-control smarthr-datepicker" type="text" name="s_gdate" value="@isset($datum){{ $datum }}@endisset" required></label>
                    </div>
                    <div class="smarthr-csv-actions is-split">
                        <button class="btn btn-primary" type="submit" name="download" value="0"><i class="fas fa-calculator"></i> Generate</button>
                        <button class="btn btn-outline-primary" type="submit" name="download" value="1"><i class="fas fa-download"></i> Download</button>
                    </div>
                    @isset($hideform2)<div class="smarthr-csv-result"><span>Male <strong>{{ $f }}</strong></span><span>Female <strong>{{ $n }}</strong></span></div>@endisset
                </form>
            </section>

            <section class="smarthr-csv-card">
                <header><i class="fas fa-tractor"></i><span>Time spent in Sweden by farm</span></header>
                <form action="{{ route('bf_gen_time_in_sw') }}" method="POST">
                    @csrf
                    <div class="smarthr-csv-fields cols-3">
                        <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>
                        <label>Farm<select class="form-control" name="farm" required>@foreach($farms as $farm)<option value="{{ $farm->id }}">{{ $farm->farm_name }}</option>@endforeach</select></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-users"></i><span>Trelleborg Old / New</span></header>
                <form action="{{ route('trell_new_old') }}" method="POST">
                    @csrf
                    <input type="hidden" name="farm" value="9">
                    <div class="smarthr-csv-fields">
                        <label>Month<select class="form-control" name="trell_s_date" required>@for($month = 1; $month <= max(1, date('n') - 1); $month++)<option value="{{ str_pad($month, 2, '0', STR_PAD_LEFT) }}">{{ date('F', mktime(0, 0, 0, $month, 1)) }}</option>@endfor</select></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-route"></i><span>Transit expenses</span></header>
                <form action="{{ route('t_expenses') }}" method="POST">
                    @csrf
                    <div class="smarthr-csv-fields cols-2">
                        <label>Start date<input class="form-control smarthr-datepicker" type="text" name="t_cost_s_date" required></label>
                        <label>End date<input class="form-control smarthr-datepicker" type="text" name="t_cost_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>

            @if ($canSeeAccounting)
            <section class="smarthr-csv-card">
                <header><i class="fas fa-coins"></i><span>Salary sum</span></header>
                <form action="{{ route('salary_sum') }}" method="POST">
                    @csrf
                    <p class="smarthr-csv-help">Select the accounting year to export.</p>
                    <div class="smarthr-csv-year-grid">
                        @forelse($salaryYears 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>
            @endif

            <section class="smarthr-csv-card">
                <header><i class="fas fa-exchange-alt"></i><span>EUR to SEK price</span></header>
                <form class="smarthr-csv-rate-form" action="{{ route('valt_update') }}" method="POST">
                    @csrf
                    <div class="smarthr-csv-rate-history">
                        @forelse($exchangeRates as $rate)
                            <label><small>{{ $rate->p_date }}</small><span><input class="form-control" type="number" name="rates[{{ $rate->id }}]" value="{{ $rate->price }}" min="0.01" step="0.01" required><em>SEK</em></span></label>
                        @empty
                            <span class="smarthr-csv-empty">No exchange rates saved.</span>
                        @endforelse
                    </div>
                    @if($exchangeRates->isNotEmpty())<div class="smarthr-csv-actions"><button class="btn btn-outline-primary" type="submit"><i class="fas fa-sync-alt"></i> Update saved prices</button></div>@endif
                </form>
                <form class="smarthr-csv-new-rate-form" action="{{ route('valt_insert') }}" method="POST">
                    @csrf
                    <div class="smarthr-csv-fields">
                        <label>EUR price in SEK<input class="form-control" type="number" name="price" step="0.01" required {{ $exchangeExists ? 'disabled' : '' }}></label>
                    </div>
                    <div class="smarthr-csv-actions"><button class="btn btn-primary" type="submit" {{ $exchangeExists ? 'disabled' : '' }}><i class="fas fa-save"></i> Save monthly price</button></div>
                    @if($exchangeExists)<p class="smarthr-csv-note"><i class="fas fa-info-circle"></i> The exchange rate for this month is already saved.</p>@endif
                </form>
            </section>

            @if ($canSeeAccounting)
            <section class="smarthr-csv-card">
                <header><i class="fas fa-layer-group"></i><span>Time spent on farms in Sweden V2</span></header>
                <form action="{{ route('bf_gen_time_in_sw') }}" method="POST">
                    @csrf
                    <input type="hidden" name="v2" value="1">
                    <div class="smarthr-csv-fields cols-3">
                        <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>
                        <label>Farm<select class="form-control" name="farm" required>@foreach($farms as $farm)<option value="{{ $farm->id }}">{{ $farm->farm_name }}</option>@endforeach</select></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>
            @endif
        </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