@extends('layouts.master')
@section('style')
    <style>
        @media print {
            #kt_header {
                display: none;
            }

            #kt_footer {
                display: none;
            }

            #printBtn,
            #saveReportBtn,
            #downloadPDF {
                display: none;
            }
        }
    </style>
@endsection
@section('content')
    <div class="content d-flex flex-column flex-column-fluid" id="kt_content">
        <div id="kt_content_container" class="container-xxl">
                <div class="mb-20">
                    @if ($showButtons)
                        <button type="button" id="printBtn" class="float-end btn btn-primary btn-sm"
                            onclick="window.print()">Print
                            Report</button>
                        <a href="{{ route('ifta.generateIFTA.downloadPDF', [$data['year'], $data['quarter'], $data['carrier'], $data['unitValues']]) }}"
                            id="downloadPDF" class="btn btn-primary float-end btn-sm me-2">Download PDF</a>
                        {{-- <a href="{{ route('ifta.generateIFTA.downloadCsv', [$data['year'], $data['quarter'], $data['carrier'], $data['unitValues']]) }}"
                            id="downloadPDF" class="btn btn-primary float-end btn-sm me-2">Download Excel</a> --}}
                        <form class="float-end me-2" action="{{ route('ifta.generateIFTA.saveReport') }}" method="GET">
                            <input type="hidden" name="carrier" value="{{ request()->route('carrier') }}">
                            <input type="hidden" name="QUARTER" value="{{ $data['quarter'] }}">
                            <input type="hidden" name="YEAR" value="{{ $data['year'] }}">
                            <input type="hidden" name="UNIT" value="{{ $data['unitValues'] }}">
                            <button type="submit" class="btn btn-primary btn-sm" style="margin-bottom: 10px;"
                                id="saveReportBtn">Save
                                Report</button>
                        </form>
                    @endif
                </div>
            <div class="flex-lg-row-fluid">
                <div class="contentToPrint">
                    <div align="center">
                        <h2 style="margin-bottom: 20px;">International Fuel Tax Agreement (IFTA) - Q{{ $data['quarter'] }} {{ $data['year'] }} <br><br> {{ getAuthCompanyName() }}
                        </h2>
                        <table width="990" border="0" cellspacing="0" cellpadding="6">
                            <tbody>
                                <tr>
                                    <td>
                                        <div
                                            style="border: solid 1px #A3A0A0; padding:5px; text-align:center; font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif;">
                                            <h2>Total Miles: {{ number_format($data['total_miles_start'], 2) }}</h2>
                                        </div>
                                    </td>
                                    <td>
                                        <div
                                            style="border: solid 1px #A3A0A0; padding:5px; text-align:center; font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif;">
                                            <h2>Total Gallons: {{ number_format($data['total_gal_start'], 2) }}</h2>
                                        </div>
                                    </td>
                                    <td>
                                        <div
                                            style="border: solid 1px #A3A0A0; padding:5px; text-align:center; font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif;">
                                            <h2>Average MPG: {{ number_format($data['mpg'], 2) }}</h2>
                                        </div>
                                    </td>
                                </tr>
                            </tbody>
                        </table>
                    </div>

                    <table width="990" border="1" cellspacing="0" cellpadding="6" align="center"
                        style="font-size:14px">
                        <thead>
                            <tr style="font-weight:bold; background-color:#7FB8B2">
                                <th>JURISDICTION</th>
                                <th>TOTAL MILES</th>
                                <th>TAX MILES</th>
                                <th>TAX PAID <br>GALLONS</th>
                                <th>TAXABLE<br>GALLONS</th>
                                <th>NET TAXABLE<br>GALLONS</th>
                                <th>FUEL TAX<br>RATE</th>
                                <th>TAX DUE /<br>(REFUND)</th>
                                <th>INTEREST<br>DUE</th>
                                <th>TOTAL DUE</th>
                            </tr>
                        </thead>
                        <tbody>
                            @php
                                $AMT_DUE = 0;
                                $interest_total = 0;
                                $TAX_DUE = 0;
                                $totalMiles = 0;
                                $totalGallon = 0;
                            @endphp
                            @foreach ($rowData as $row2)
                                @php
                                    $TAX_GAL =
                                        $row2->totalMiles != 0 && $data['mpg'] != 0
                                            ? round($row2->totalMiles / $data['mpg'])
                                            : 0;
                                    $NET_TAX_GAL = round($TAX_GAL - $row2->totalGallons);
                                    $NET_TAX_GALpr = $NET_TAX_GAL < 0 ? '(' . abs($NET_TAX_GAL) . ')' : $NET_TAX_GAL;
                                    $TAX_AMT = round($row2->RATE_US * $NET_TAX_GAL, 2);
                                    $AMT_DUE += $TAX_AMT;
                                @endphp

                                <tr
                                    style="font-family: Segoe, 'Segoe UI', 'DejaVu Sans', 'Trebuchet MS', Verdana, sans-serif;">
                                    <td>{{ $row2->STATE }}</td>
                                    <td>{{ number_format($row2->totalMiles) }}</td>
                                    <td>{{ number_format($row2->totalMiles) }}</td>
                                    <td>{{ number_format($row2->totalGallons) }}</td>
                                    <td>{{ $TAX_GAL }}</td>
                                    <td>{{ $NET_TAX_GALpr }}</td>
                                    <td>
                                        <center>{{ $row2->RATE_US }}</center>
                                    </td>
                                    <td>{{ $TAX_AMT < 0 ? '(' . abs($TAX_AMT) . ')' : $TAX_AMT }}</td>
                                    <td>
                                        @php
                                            $interest = !empty($data['ifta_tax_rate_interest'])
                                                ? $data['ifta_tax_rate_interest']->A2
                                                : 0.0;
                                            $interest_months = $data['interest_months'];
                                            $interest = str_replace('%', '', $interest);
                                            $interest_due = ($interest / 100 / 12) * $interest_months * $TAX_AMT;
                                            $total_due = $TAX_AMT + $interest_due;
                                            $interest_total += $interest_due;
                                            $TAX_DUE += $TAX_AMT;
                                            $abs = abs($interest_due);
                                            echo $interest_due < 0
                                                ? '(' . number_format($abs, 2) . ')'
                                                : number_format($interest_due, 2);
                                        @endphp
                                    </td>
                                    <td>{{ $total_due < 0 ? '(' . number_format(abs($total_due), 2) . ')' : number_format($total_due, 2) }}
                                    </td>

                                </tr>

                                @if (in_array($row2->STATE, ['KY', 'VA', 'IN']))
                                    @php
                                        $stateSurcharge = '';
                                        $quarter = $data['quarter'];
                                        $year = $data['year'];
                                        switch ($row2->STATE) {
                                            case 'KY':
                                                $stateSurcharge = 'KENTUCKY SurChg';
                                                break;
                                            case 'IN':
                                                $stateSurcharge = 'INDIANA SurChg';
                                                break;
                                            case 'VA':
                                                $stateSurcharge = 'VIRGINIA SurChg';
                                                break;
                                        }

                                        $fsc = DB::table('ifta_rates_new')
                                            ->where('Quarter', $quarter)
                                            ->where('Year', $year)
                                            ->where('State', $row2->STATE)
                                            ->first();
                                        $TAX_AMT_SRC = !empty($fsc->Surcharge_Rate)
                                            ? round($fsc->Surcharge_Rate * $TAX_GAL, 2)
                                            : 0;
                                    @endphp
                                    @php
                                        $interest = !empty($data['ifta_tax_rate_interest'])
                                            ? $data['ifta_tax_rate_interest']->A2
                                            : 0.0;
                                        $interest_months = $data['interest_months'];
                                        $interest = str_replace('%', '', $interest);
                                        $interest_due = ($interest / 100 / 12) * $interest_months * $TAX_AMT_SRC;
                                        $total_due = $TAX_AMT_SRC + $interest_due;
                                        $interest_total += $interest_due;
                                        $TAX_DUE += $TAX_AMT_SRC;
                                    @endphp

                                    <tr
                                        style="font-family: Segoe, 'Segoe UI', 'DejaVu Sans', 'Trebuchet MS', Verdana, sans-serif;">
                                        <td>{{ $row2->STATE }} <i>surcharge</i></td>
                                        <td>{{ number_format($row2->totalMiles) }} mi</td>
                                        <td>&nbsp;</td>
                                        <td>0</td>
                                        <td>{{ $TAX_GAL }}</td>
                                        <td>{{ $NET_TAX_GALpr }} gal</td>
                                        <td>
                                            <center>{{ !empty($fsc->Surcharge_Rate) ? $fsc->Surcharge_Rate : '' }}</center>
                                        </td>
                                        <td>{{ $TAX_AMT_SRC < 0 ? '(' . abs($TAX_AMT_SRC) . ')' : $TAX_AMT_SRC }}</td>
                                        <td>{{ number_format($interest_due, 2) }}</td>
                                        <td>{{ $total_due < 0 ? '(' . number_format(abs($total_due), 2) . ')' : number_format($total_due, 2) }}
                                        </td>

                                    </tr>

                                    @php
                                        $AMT_DUE += $total_due;
                                    @endphp
                                @endif
                            @endforeach
                            <tr
                                style="background-color:#E1DDB6; font-family:Segoe, 'Segoe UI', 'DejaVu Sans', 'Trebuchet MS', Verdana, sans-serif; font-weight:bold">
                                <td>TOTALS</td>
                                <td>{{ number_format($data['total_miles_start'], 2) }}</td>
                                <td>&nbsp;</td>
                                <td>{{ number_format($data['total_gal_start'], 2) }}</td>
                                <td>&nbsp;</td>
                                <td>&nbsp;</td>
                                <td>&nbsp;</td>
                                <td>{{ number_format($TAX_DUE, 2) }}</td>
                                <td>{{ number_format($interest_total, 2) }}</td>
                                <td>&nbsp;</td>
                            </tr>
                        </tbody>
                    </table>
                    <table width="990" border="0" cellspacing="0" cellpadding="6" align="center"
                        style="font-weight: bold">
                        <tbody>
                            <tr>
                                <td width="409">
                                    <br>Return Information
                                    <div
                                        style="border: solid 1px #A3A0A0; padding:6px; font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif;">
                                        @php
                                            if(date('Y-m-d') < $data['date1']){
                                                $penalty_amt = 0;
                                            }else{
                                                $penalty_amt = ($TAX_DUE + $interest_total) * 0.1;
                                                $penalty_amt = $penalty_amt < 50 ? 50 : $penalty_amt;
                                            }

                                            $GRAND_TOTAL = $TAX_DUE + $penalty_amt + $interest_total;
                                        @endphp

                                        <table width="100%" border="0" cellspacing="0" cellpadding="5">
                                            <tbody>
                                                <tr>
                                                    <td>Total Tax</td>
                                                    <td align="right">$ {{ number_format($TAX_DUE, 2) }}</td>
                                                </tr>
                                                <tr>
                                                    <td>Total Interest</td>
                                                    <td align="right">$ {{ number_format($interest_total, 2) }}</td>
                                                </tr>
                                                <tr>
                                                    <td>Total Penalties</td>
                                                    <td align="right">$ {{ number_format($penalty_amt, 2) }}</td>
                                                </tr>
                                                <tr>
                                                    <td>Total Adjustments</td>
                                                    <td align="right">&nbsp;</td>
                                                </tr>
                                                <tr>
                                                    <td>Total Other</td>
                                                    <td align="right"></td>
                                                </tr>
                                                <tr>
                                                    <td colspan="2">
                                                    <hr>
                                                    </td>
                                                </tr>
                                                <tr>
                                                    <td>Total Due</td>
                                                    <td align="right"><b>$ {{ number_format($GRAND_TOTAL, 2) }}</b></td>
                                                </tr>
                                            </tbody>
                                        </table>
                                    </div>
                                </td>
                                <td width="236"></td>
                                <td width="279">
                                    <div
                                        style="width: 400px; text-align:center; border: solid 1px #A3A0A0; padding:6px; font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif;">
                                        <h2>Total Tax Due: $ {{ number_format($GRAND_TOTAL, 2) }}</h2>
                                    </div>
                                </td>
                            </tr>
                            <tr>
                                <td>&nbsp;</td>
                                <td>&nbsp;</td>
                                <td>&nbsp;</td>
                            </tr>
                            <tr>
                                <td colspan="3">
                                    <p style="font-size: 11px">*Interest Charges: For periods on or after
                                        {{ $data['due_date'] }},
                                        interest shall
                                        be
                                        set
                                        at an annual rate of
                                        {{ !empty($data['ifta_tax_rate_interest']) ? $data['ifta_tax_rate_interest']->A2 : '0.00' }}
                                        above the underpayment rate established under <a
                                            href="https://www.dol.gov/agencies/ebsa/employers-and-advisers/plan-administration-and-compliance/correction-programs/vfcp/table-of-underpayment-rates"
                                            target="_blank">Section
                                            6621(a)(2)</a> of the Internal Revenue Code. Unlike penalty charges, interest is
                                        computed on
                                        the
                                        tax due to each member jurisdiction, rather than the net total due with your report.
                                    </p>
                                    <p style="font-size: 11px">*IFTA Penalties: IFTA legislation states that a penalty of
                                        $50.00 or 10%
                                        of
                                        the taxes owed (whichever is greater) will be calculated on late-filed reports,
                                        failure to file
                                        or
                                        for underpayment of tax due. If the net tax liability is zero or a credit, you will
                                        owe the late
                                        filing penalty.</p>
                                </td>
                            </tr>
                        </tbody>
                    </table>
                    <div
                        style="margin-top:195px; padding:9px; font-family:Gotham, 'Helvetica Neue', Helvetica, Arial, sans-serif; width:980px; align-content:center; margin:auto;">

                        Signature: _______________________________<br><br>

                        Name:__________________________________<br>

                        Title:<br>

                        Date: {{ date('m/d/Y') }}<br>
                    </div>
                    <div id="loom-companion-mv3" ext-id="liecbddmkiiihnedobmlmillhodjkdmb">
                        <section id="shadow-host-companion"></section>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection()