@extends('layouts.master')
@section('meta')
<meta name="csrf-token" content="{{ csrf_token() }}">
@stop
@section('content')
<div class="col-lg-12 grid-margin stretch-card" style="min-height: 80vh;">
    <div class="card">
        <div class="card-body">
            <div class="page-header">
                <h3 class="page-title">Order Report: Overdue Customers</h3>
                <nav aria-label="breadcrumb">
                    <ol class="breadcrumb">
                    <li class="breadcrumb-item"><a href="{{route('home')}}">Dashboard</a></li>
                    <li class="breadcrumb-item active" aria-current="page">Overdue Customers Report</li>
                    </ol>
                </nav>
            </div>
            <div>
                <h6 class="pull-right"><p class="text-danger text-lg">Total Amount Due: £{{ number_format($totalDue, 2) }}</p></h6>
            </div>
            <div class="col-lg-12 d-flex flex-row justify-content-between p-2">
                <div>
                    <form class="d-flex" method="GET" action="{{ route('reports.overduecustomer') }}">
                        <input class="me-2" name="query" type="search" placeholder="Search" aria-label="Search" value="{{ request('query') }}">
                        <!-- <button class="btn btn-outline-primary" type="submit">Search</button> -->

                        <!-- from and to date selection -->
                        <input type="hidden" name="filter" value="custom">
                        <label class="me-2">From:</label>
                        <input type="date" name="start" value="{{ request('start') ?? '' }}" class="me-2">
                        <label class="me-2">To:</label>
                        <input type="date" name="end" value="{{ request('end') ?? '' }}" class="me-2">
                        <button class="btn btn-outline-primary" type="submit">Submit</button>
                        <a href="{{ route('reports.overduecustomer') }}" class="btn btn-outline-danger ms-2">Reset</a>
                        <a href="{{ route('reports.overduecustomer', ['start' => request('start'), 'end' => request('end'), 'query' => request('query'), 'filter' => 'custom', 'format' => 'pdf']) }}" class="btn btn-outline-warning ms-2">Download Pdf</a>
                    </form>
                </div>
                <!-- <div><button type="button" class="btn btn-primary manage-blog"  data-url="{{ route('blogs.store') }}" data-mode="add">Add New Blog</button></div> -->
            </div>
            <table class="table table-striped">
                <thead>
                    <tr>
                        <th> Customer Name </th>
                        <th> Phone Number </th>
                        <th> Email </th>
                        <th align="right"> Total Amount </th>
                        <th align="right"> Paid Amount </th>
                        <th align="right"> Due Amount </th>
                        <th> Created Date </th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($orders as $row)
                    <tr>
                        <td> <a href="{{ route('customers.edit', $row->customer_id) }}">{{ $row->customer->name }}</a> </td>
                        <td> {{ $row->customer->phone_number }} </td>
                        <td> {{ $row->customer->email }} </td>
                        <td align="right"> £{{ number_format($row->total, 2) }} </td>
                        <td align="right"> £{{ number_format($row->total - $row->amount_due, 2) }} </td>
                        <td align="right"> <span style="color: red;"><strong>£{{ number_format($row->amount_due, 2) }}</strong></span> </td>
                        <td> {{date("d M, Y h:i a", strtotime($row->created_at))}} </td>
                    </tr>
                    @endforeach
                </tbody>
            </table>
            <div class="pagination justify-content-end pt-2">
                {{ $orders->links('pagination::bootstrap-4') }}
            </div>
        </div>
    </div>
</div>
@stop


@section('scripts')

@stop