@extends('pages.admin.layout')

@section('content')
    <!-- Main content -->
    <section class="content">


        @php
            $orderArea = Request::query('orderArea') ?? FALSE;

        @endphp
        <div class="row">
            <div class="col-9">
                <h2 class="content-heading d-print-none mt-0 pt-0">
                    Week: {{$availability->title}}
                </h2>
            </div>
            <div class="col-3">
                <form role="form" enctype="multipart/form-data" method="get" id="formDetails"
                      action="{{ route('admin.delivery.viewOrderSlots', $availability->id) }}" autocomplete="nope">
                    {{ method_field('get') }}
                    @csrf
                    <div class="input-group">
                        <select name="orderArea" id="orderArea" class="form-control form-control-lg">
                            <option value="Edible16" @if($orderArea==
                        'Edible16') selected="selected" @endif>Area: Edible16
                            </option>
                            <option value="Waterloo" @if($orderArea==
                        'Waterloo') selected="selected" @endif>Area: Waterloo Cottage
                            </option>
                            <option value="Pearmans" @if($orderArea==
                        'Pearmans') selected="selected" @endif>Area: Pearmans
                            </option>
                        </select>
                        <div class="input-group-append">
                            <button type="submit"
                                    class="btn btn-primary btn-lg loadDeliveryCost">Filter
                            </button>
                        </div>
                    </div>
                </form>
            </div>
        </div>
        <div class="block py-3 px-3">
            <div class="box-header">

            </div>
            <!-- /.box-header -->
            <div class="box-body">
                <div class="row">
                    <div class="col-4">
                        <div class="card">
                            <div class="card-header bg-primary text-white">Status Report</div>
                            <div class="card-body">

                                <div class="table-report">
                                    <table class="table table-striped table-vcenter">
                                        <thead class="thead-light">
                                        <tr>
                                            <th>Status</th>
                                            <th class="text-center">Order Count</th>
                                            <th class="text-center">Value</th>
                                        </tr>
                                        </thead>
                                        <tbody>
                                        @foreach((clone $orders)->groupby('status')->get() as $order)
                                            <tr class="@if($order->status != '0' && $order->status != 'LostSlot' && $order->status != 'HIGHDEMAND'&& $order->status != 'cancelled') bg-success text-white @endif">
                                                <TD>
                                                    @if($order->status == '0')
                                                        Unpaid / Failed Payment
                                                    @elseif($order->status == 'cancelled')
                                                        Declined Order
                                                    @elseif($order->status == 'LostSlot')
                                                        Lost Slot (Requires new order)
                                                    @elseif($order->status == 'HIGHDEMAND')
                                                        Backup Orders (High Demand)
                                                    @else
                                                        {{ucfirst($order->status)}}
                                                    @endif
                                                </TD>
                                                <td class="text-center">
                                                    {{$order->count}}
                                                </td>
                                                <td class="text-center font-weight-bold">&pound;{{$order->totalC}}</td>
                                            </tr>

                                        @endforeach
                                        </tbody>

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

                        <div class="card mt-2">
                            <form role="form" enctype="multipart/form-data" method="POST"
                                  action="{{ route('admin.delivery.inviteLastWeek', $availability->id ) }}"
                                  autocomplete="nope">
                                {{ method_field('POST') }}
                                @csrf

                                <div class="card-header bg-info text-white">Send SMS/Email to All Users (Not yet
                                    Ordered)
                                </div>
                                <div class="card-body">
                                    <div class="row">
                                        <div class="col-12">
                                            <p class="mb-0">Be sure to use the following:
                                            <ul>
                                                <li><strong>NAME</strong> - Their First Name</li>
                                                <li><strong>SHIRE</strong> - Leicestershire/Northamptonshire based on their account</li>
                                                <li><strong>BUSINESS</strong> - Either Edible16 or MadeInNorthamptonshire</li>
                                                <li><strong>SITE</strong> - Changes to their relevant site</li>
                                            </ul>
                                            </p>
                                            <div class="input-group mb-3">
                                                <div class="input-group-prepend">
                                        <span class="input-group-text">
                                            Message
                                        </span>
                                                </div>
                                                <textarea type="text" name="messageBody" value=""
                                                          class="form-control"></textarea>
                                            </div>
                                            <div class="input-group">
                                                <button type="submit" name="sendSMS" class="btn btn-success btn-lg btn-block">Send SMS</button>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </form>
                        </div>
                    </div>
                    <div class="col-4">
                        <div class="card">
                            <div class="card-header bg-info text-white">Delivery Report</div>
                            <div class="card-body">

                                <div class="table-report">
                                    <table class="table table-striped table-vcenter">
                                        <thead class="thead-light">
                                        <tr>
                                            <th>Type</th>
                                            <th>Order Count</th>
                                            <th>Value</th>
                                        </tr>
                                        </thead>
                                        <tbody>
                                        @foreach((clone
                                        $orders)->whereNotIn('status',['unpaid','0','HIGHDEMAND','highdemand','cancelled',
                                        'LostSlot'])->groupby('LocationID')->get()
                                        as $order)
                                            <tr>
                                                <TD>
                                                    @if($order->LocationID == 5)
                                                        Collect: Waterloo
                                                    @elseif($order->LocationID == 6)
                                                        Collect: EcoVillage
                                                    @else
                                                        Delivery
                                                    @endif
                                                </TD>
                                                <td>{{$order->count}}</td>
                                                <td>&pound;{{$order->totalC}}</td>
                                            </tr>

                                        @endforeach
                                        </tbody>

                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-4">

                        <form role="form" enctype="multipart/form-data" method="POST"
                              action="{{ route('admin.delivery.updateWeek', $availability->id) }}" autocomplete="nope">
                            {{ method_field('POST') }}
                            @csrf

                            <div class="card">
                                <div class="card-header bg-success text-white">Delivery Breakdown</div>
                                <div class="card-body">

                                    <div class="row">
                                        <div class="col-12">
                                            <div class="input-group mb-3">
                                                <div class="input-group-prepend">
                                        <span class="input-group-text">
                                            Delivery Slots
                                        </span>
                                                </div>
                                                <input type="text" name="delivery"
                                                       value="{{$availability->DeliverySlots}}"
                                                       class="form-control">
                                            </div>
                                        </div>

                                        <div class="col-12">

                                            <div class="input-group mb-3">
                                                <div class="input-group-prepend">
                                        <span class="input-group-text">
                                            Eco Village Slots
                                        </span>
                                                </div>
                                                <input type="text" name="eco" value="{{$availability->EcoSlots}}"
                                                       class="form-control">

                                            </div>
                                        </div>

                                        <div class="col-12">

                                            <div class="input-group mb-4">
                                                <div class="input-group-prepend">
                                        <span class="input-group-text">
                                            Waterloo Cottage Slots
                                        </span>
                                                </div>
                                                <input type="text" name="waterloo"
                                                       value="{{$availability->WaterlooSlots}}"
                                                       class="form-control">
                                            </div>
                                        </div>

                                        <div class="col-12">

                                            <div class="custom-control custom-checkbox mb-5">
                                                <input type="checkbox" class="custom-control-input" id="week-status"
                                                       name="status" value="1" @if($availability->status !=
                                            0)checked="checked"@endif >
                                                <label class="custom-control-label" for="week-status">Orders
                                                    Allowed</label>
                                            </div>
                                        </div>
                                        <div class="col-12">
                                            <button class="btn btn-lg btn-block btn-success">Save Changes</button>
                                        </div>
                                    </div>

                                </div>
                                <div class="card-footer">
                                    <a href="/admin/missingItems?weekID={{$availability->id}}"
                                       class="btn btn-lg btn-info">Fix Missing Items</a>
                                </div>
                            </div>
                        </form>
                    </div>
                </div>
                <div class="row mt-4">
                    <div class="col-4">
                        <div class="card">
                            <div class="card-header bg-info text-white">Delivery Drivers</div>
                            <div class="card-header">

                                <div class="table-report">
                                    @php
                                        $driversAvailable = collect(DB::select(DB::raw("SELECT count(orders.id) as count, sum(DeliveryPrice) as price, drivers.id, drivers.name FROM `orders`
                                        left join drivers on DriveryID = drivers.id where DriveryID IS NOT NULL AND WeekID = ".$availability->id." group by DriveryID")));
                                    @endphp
                                    @if($driversAvailable->count())
                                        <table class="table table-striped table-vcenter">
                                            <thead class="thead-light">
                                            <tr>
                                                <th>Driver</th>
                                                <th class="text-center" width="10">Orders</th>
                                                <th class="text-center" width="10">Cost</th>
                                                <th class="text-right">Actions</th>
                                            </tr>
                                            </thead>
                                            <tbody>
                                            @foreach($driversAvailable as $driver)
                                                <tr>
                                                    <td>{{$driver->name}}</td>
                                                    <td class="text-center">
                                                        {{$driver->count}}
                                                    </td>
                                                    <td class="text-center">&pound;{{$driver->price}}</td>
                                                    <td><a href="/admin/delivery/routing/{{$driver->id}}"
                                                           target="_blank">View Route</a></td>
                                                </tr>

                                            @endforeach
                                            </tbody>

                                        </table>
                                    @else
                                        <div class="alert alert-info">You need to add a driver below to be able to use
                                            them for
                                            Deliveries
                                        </div>
                                    @endif
                                </div>

                            </div>
                        </div>
                        @if(Request::get("refundError"))
                            <div class="alert alert-danger mt-3 mb-3">
                                <strong>An error occurred during the Refund</strong>
                                <p class="m-0">{{Request::get("refundError")}}</p>
                            </div>
                        @endif
                        <div class="card mt-2">
                            <div class="card-header bg-info text-white">Due Refunds</div>
                            <div class="card-body">
                                <div class="table-report">
                                    @php
                                        $refunds = collect(DB::select(DB::raw("select sum((missed_from * order_items.price)) as total, sum(missed_from) as qty, order_id, DeliveryFirstName, DeliveryLastName, DeliveryMobileNumber, DeliveryEmail
                                      from order_items
      left join orders on order_id = orders.id where refund_id IS NULL and missed_from != 0 and order_items.order_id in (select id from orders where  WeekID = ".$availability->id." )
                                      group by order_items.order_id")));
                                    @endphp

                                    @if($refunds->count())
                                        <table class="table table-striped table-vcenter">
                                            <thead class="thead-light">
                                            <tr>
                                                <th>Order</th>
                                                <th class="text-center" width="20">Total Qty</th>
                                                <th class="text-class" width="20">Total Due</th>
                                                <th class="text-right">Actions</th>
                                            </tr>
                                            </thead>
                                            <tbody>
                                            @foreach($refunds as $refund)
                                                <tr>
                                                    <td>{{$refund->DeliveryFirstName}} {{$refund->DeliveryLastName}}</td>
                                                    <td class="text-center">
                                                        {{$refund->qty}}
                                                    </td>
                                                    <td class="text-center">&pound;{{$refund->total}}</td>
                                                    <td class="text-right"><a
                                                                href="/admin/orders/{{$refund->order_id}}/processRefund">Process
                                                            Refund</a></td>
                                                </tr>

                                            @endforeach
                                            </tbody>

                                        </table>
                                    @else
                                        <div class="alert alert-info">No refunds to process
                                        </div>
                                    @endif
                                </div>
                            </div>
                        </div>
                        @php
                            $refunds = collect(DB::select(DB::raw("SELECT order_id, DeliveryFirstName, DeliveryLastName, amount FROM payments
LEFT JOIN orders on  order_id = orders.id
where Type = 1 and orders.WeekID = ".$availability->id)));
                        @endphp

                        @if($refunds->count())
                            <div class="card mt-2">
                                <div class="card-header bg-info text-white">Processed Refunds</div>
                                <div class="card-body">
                                    <div class="table-report">
                                        <table class="table table-striped table-vcenter">
                                            <thead class="thead-light">
                                            <tr>
                                                <th>Order</th>
                                                <th class="text-right" width="20">Total Refunded</th>
                                            </tr>
                                            </thead>
                                            <tbody>
                                            @foreach($refunds as $refund)
                                                <tr>
                                                    <td>{{$refund->DeliveryFirstName}} {{$refund->DeliveryLastName}}</td>
                                                    <td class="text-right">&pound;{{$refund->amount}}</td>
                                                </tr>

                                            @endforeach
                                            </tbody>

                                        </table>
                                    </div>
                                </div>
                            </div>
                        @endif
                    </div>
                    <div class="col-8">
                        <div class="card">
                            <div class="card-header bg-info text-white">Orders <small
                                        class="text-white font-weight-bold">(Paid,
                                    Collection, Picking, Out for Delivery, Completed)</small>
                                <button onclick="exportTableToExcel('orderReport')" class="btn btn-success pull-right">
                                    Export to Excel
                                </button>
                            </div>
                            <div class="card-header">

                                <div class="table-report">
                                    @php
                                        $orderReport = (clone
                                        $orders)->select("*")->whereNotIn('status',['unpaid','0','HIGHDEMAND','highdemand','cancelled',
                                        'LostSlot'])->orderBy("LocationID", "desc")->orderBy("status")->get();
                                    @endphp
                                    @if($orderReport->count())
                                        <table class="table table-striped table-vcenter" id="orderReport">
                                            <thead class="thead-light">
                                            <tr>
                                                <th>Order ID</th>
                                                <th>Name</th>
                                                <th>Type</th>
                                                <th>Status</th>
                                                <th>Value</th>
                                            </tr>
                                            </thead>
                                            <tbody>
                                            @foreach($orderReport as $order)
                                                <tr class="@if($order->LocationID == null) bg-success-light
                                            @elseif($order->LocationID == 5) bg-info-light
                                            @elseif($order->LocationID == 6) bg-warning-light
                                            @endif">
                                                    <td><a href="/admin/orders/{{$order->id}}/edit"
                                                           target="_blank">{{$order->id}}</a></td>
                                                    <td><a href="/admin/customers/{{$order->user_id}}/edit"
                                                           target="_blank">{{$order->DeliveryFirstName}}
                                                            {{$order->DeliveryLastName}}</a></td>
                                                    <td>@if($order->LocationID == null)
                                                            Delivery: {{$order->DeliveryPostcode}}
                                                        @elseif($order->LocationID == 5) Collection: Waterloo
                                                        @elseif($order->LocationID == 6) Collection: EcoVillage
                                                        @endif
                                                    </td>
                                                    <td>
                                                        @if($order->status == '0')
                                                            Unpaid / Failed Payment
                                                        @elseif($order->status == 'cancelled')
                                                            Declined Order
                                                        @elseif($order->status == 'LostSlot')
                                                            Lost Slot (Requires new order)
                                                        @elseif($order->status == 'HIGHDEMAND')
                                                            Backup Orders (High Demand)
                                                        @else
                                                            {{ucfirst($order->status)}}
                                                        @endif
                                                    </td>
                                                    <td>&pound;{{number_format($order->total, 2)}}</td>
                                                </tr>
                                            @endforeach
                                            </tbody>

                                        </table>
                                    @else
                                        <div class="alert alert-info">You need to add a driver below to be able to use
                                            them for
                                            Deliveries
                                        </div>
                                    @endif
                                </div>

                            </div>
                            <div class="card-footer">
                            </div>
                        </div>
                    </div>
                </div>

            </div>
            <!-- /.box-footer-->
        </div>
        <!-- /.box -->

    </section>
@endsection
@section('scripts')
    <script>
        function exportTableToExcel(tableID, filename = '') {
            var downloadLink;
            var dataType = 'application/vnd.ms-excel';
            var tableSelect = document.getElementById(tableID);
            var tableHTML = tableSelect.outerHTML.replace(/ /g, '%20').replace(/£/g, '');

            // Specify file name
            filename = filename ? filename + '.xls' : 'excel_data.xls';

            // Create download link element
            downloadLink = document.createElement("a");

            document.body.appendChild(downloadLink);

            if (navigator.msSaveOrOpenBlob) {
                var blob = new Blob(['\ufeff', tableHTML], {
                    type: dataType
                });
                navigator.msSaveOrOpenBlob(blob, filename);
            } else {
                // Create a link to the file
                downloadLink.href = 'data:' + dataType + ', ' + tableHTML;

                // Setting the file name
                downloadLink.download = filename;

                //triggering the function
                downloadLink.click();
            }
        }
    </script>
@append