@extends('layouts.master')

@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="row g-5 g-xl-10">
            <div class="col-xl-3">
                <div class="card card-xl-stretch mb-xl-8 theme-dark-bg-body" style="background-color: #F7D9E3">
                    <div class="card-body d-flex flex-column">
                        <div class="d-flex flex-column flex-grow-1 mb-5">
                            <div class="text-gray-900 fw-bold fs-3">Available Credit</div>
                        </div>

                        <div class="pt-5">
                            <span
                                class="fw-bold fs-3x me-2 lh-0 text-gray-900" id="creditAvailable">
                                @if($rowc1['CONTRACT_ID'] == "")
                                    {{ number_format($rowc['Total'],2) }}
                                @endif
                                @if($rowc1['CONTRACT_ID'] != "" && $rowc1['C411'] != "0006332001871")
                                    {{ "..." }}
                                @php
                                $callEsfAjax= true;
                                @endphp
                                @endif
                                @if($rowc1['CONTRACT_ID'] != "" && $rowc1['C411'] == "0006332001871" )
                                    {{ "0.00" }}
                                @endif
                            </span><br>
                            <span class="text-gray-900 fw-bold fs-1x lh-0 pt-5"><a href="{{route('transactionsReport.index')}}" class="small-box-footer">EFS Customer #: {{ $rowc1['C411'] }} </a></span>
                        </div>
                    </div>
                </div>
            </div>

            <div class="col-xl-3">
                <div class="card card-xl-stretch mb-xl-8 theme-dark-bg-body" style="background-color: #CBF0F4">
                    <div class="card-body d-flex flex-column">
                        <div class="d-flex flex-column flex-grow-1 mb-5">
                            <div class="text-gray-900 fw-bold fs-3">Active Fuel Cards
                            </div>
                        </div>

                        <div class="pt-5">
                            <span
                                class="fw-bold fs-3x me-2 lh-0 text-gray-900">{{
                                    $rowf['Total'] }}</span><br>
                            <span class="text-gray-900 fw-bold fs-1x lh-0 mt-5"><a href="{{ route('fuelCards.index') }}" class="small-box-footer">Add Fuel Card <i
                                class="fa fa-arrow-circle-right"></i> </a></span>
                        </div>
                    </div>
                </div>
            </div>

            <div class="col-xl-3">
                <div class="card card-xl-stretch mb-5 mb-xl-8 theme-dark-bg-body" style="background-color: #CBD4F4">
                    <div class="card-body d-flex flex-column">
                        <div class="d-flex flex-column flex-grow-1 mb-5">
                            <div class="text-gray-900 fw-bold fs-3">Total Diesel Gallons {{
                                number_format($rowg['Total'],0) }}</div>
                        </div>

                        <div class="pt-5">
                            <span
                                class="fw-bold fs-3x me-2 lh-0 text-gray-900">
                            @if($rowga['Total'])
                                {{ number_format($rowga['Total'],0) }}
                            @else
                                {{ "0.00" }}
                            @endif
                            </span><br>
                            <span class="text-gray-900 fw-bold fs-1x lh-0 mt-5"><a href="{{ route('currentRebateReport.index') }}" class="small-box-footer">MTD Gallons <i
                                class="fa fa-arrow-circle-right"></i></a></span>
                        </div>
                    </div>
                </div>
            </div>

            <div class="col-xl-3">
                <div class="card card-xl-stretch mb-5 mb-xl-8 theme-dark-bg-body" style="background-color: #cef4cb">
                    <div class="card-body d-flex flex-column">
                        <div class="d-flex flex-column flex-grow-1 mb-5">
                            <div class="text-gray-900 fw-bold fs-3">Rebates this Month</div>
                        </div>

                        <div class="pt-5">
                            <span class="text-gray-900 fw-bold fs-2x lh-0">$</span>
                            <span
                                class="fw-bold fs-3x me-2 lh-0 text-gray-900">{{
                                    number_format($rowa['Total'],2) }}</span><br>
                            <span class="text-gray-900 fw-bold fs-1x lh-0 mt-5"><a href="{{ route('currentRebateReport.index') }}" class="small-box-footer">Previous Month: $ {{
                                number_format($rowaP['Total'],2) }}</a></span>
                        </div>
                    </div>
                </div>
            </div>

            <div class="col-xl-12">
                <div class="card card-flush h-md-100">
                    <div class="card-header pt-7">
                        <h3 class="card-title align-items-start flex-column">
                            <span class="card-label fw-bold text-gray-800">MTD Rebates By Unit #</span>
                        </h3>
                    </div>

                    <div class="card-body pt-6">
                        <div class="table-responsive">
                            <table class="table table-striped table-row-dashed align-middle gs-0 gy-3 my-0">
                                <thead class="thead-bg-color">
                                    <tr class="fs-7 fw-bold text-gray-500 border-bottom-0">
                                        <th>Unit #</th>
                                        <th>Driver</th>
                                        <th>Total Rebates</th>
                                        <th>Discount</th>
                                        <th>In Network</th>
                                        <th>Out of Network Gallons</th>
                                        <th>In Network</th>
                                    </tr>
                                </thead>

                                <tbody class="tbody-text">
                                    @if(!empty($data22))
                                    @foreach($data22 as $rowss)
                                    @php
                                    if($rowss->UNIT != "")
                                    {
                                    $sql223 = "SELECT sum(`QTY`) AS TotalGallons,`PRODUCT_CODE`
                                    FROM FUEL_PROCESS WHERE MONTH(TRANS_DATE) = MONTH(NOW()) and SUBFLEET
                                    ='".getAuthMemberId()."' AND `PRODUCT_CODE` = 'ULSD' AND `LocationID` NOT IN(1,3)
                                    AND
                                    `UNIT` = '".$rowss->UNIT."'";
                                    $rows2s = DB::select(DB::raw($sql223));
                                    $rows2s = $rows2s[0];
                                    }
                                    @endphp
                                    <tr>
                                        <td>
                                            {{ $rowss->UNIT }}
                                        </td>
                                        <td>
                                            {{ strtoupper($rowss->DRIVER) }}
                                        </td>
                                        <td>$
                                            {{ number_format($rowss->Total,2) }}
                                        </td>
                                        <td>$
                                            {{ number_format(($rowss->Total/($rowss->TotalGallons+$rows2s->TotalGallons)),2) }}
                                        </td>
                                        <td>
                                            {{ number_format($rowss->TotalGallons,2) }}
                                        </td>
                                        <td>
                                            {{ $rows2s->TotalGallons }}
                                        </td>
                                        <td>
                                            {{ number_format(100 *($rowss->TotalGallons /
                                            ($rows2s->TotalGallons+$rowss->TotalGallons)),0) }} %
                                        </td>
                                    </tr>
                                    @php
                                    $rows2s->TotalGallons = 0;
                                    @endphp
                                    @endforeach()
                                    @else
                                    <tr>
                                        <td colspan="7" align="center">
                                            No Data Found
                                        </td>
                                    </tr>
                                    @endif

                                </tbody>
                            </table>
                        </div>
                    </div>

                    <div class="card-header pt-7">
                        <h3 class="card-title align-items-start flex-column">
                            <span class="card-label fw-bold text-gray-800">{{ (isset($_GET['month']) &&
                                !empty($_GET['month']) ? date("F", mktime(null, null, null, $previousMonth)) :
                                'Previous') }} Month Rebates By Unit #</span>
                        </h3>
                        <div class="d-flex align-items-center p-7">
                            <form action="" method="GET" class="d-flex">
                                <select name="year" id="year" class="form-control me-2">
                                    <option value="{{ date('Y') }}" {{ request()->get('year') == date('Y') ? 'selected' : '' }}>{{ date('Y') }}</option>
                                    <option value="{{ date("Y",strtotime("-1 year")) }}" {{ request()->get('year') == date("Y",strtotime("-1 year")) ? 'selected' : '' }}>{{ date("Y",strtotime("-1 year")) }}</option>
                                    <option value="{{ date("Y",strtotime("-2 year")) }}" {{ request()->get('year') == date("Y",strtotime("-2 year")) ? 'selected' : '' }}>{{ date("Y",strtotime("-2 year")) }}</option>
                                    <option value="{{ date("Y",strtotime("-3 year")) }}" {{ request()->get('year') == date("Y",strtotime("-3 year")) ? 'selected' : '' }}>{{ date("Y",strtotime("-3 year")) }}</option>
                                    <option value="{{ date("Y",strtotime("-4 year")) }}" {{ request()->get('year') == date("Y",strtotime("-4 year")) ? 'selected' : '' }}>{{ date("Y",strtotime("-4 year")) }}</option>
                                </select>
                                <select name="month" id="month" class="form-control me-2">