@extends('layout.master')

@section('css')
    <link rel="stylesheet" type="text/css" href="{{ asset('assets/css/vendors/datatables.css') }}">
    <link rel="stylesheet" type="text/css" href="{{ asset('assets/css/vendors/datatable-extension.css') }}">
@endsection

@section('main_content')
    <div class="container-fluid">
        <div class="page-title">
            <div class="row">
                <div class="col-sm-6">
                    <h3>Reports</h3>
                </div>
                <div class="col-sm-6">
                    <ol class="breadcrumb">
                        <li class="breadcrumb-item"><a href="#"><i data-feather="home"></i></a></li>
                        <li class="breadcrumb-item">Loan History Report</li>
                    </ol>
                </div>
            </div>
        </div>
    </div>
    <!-- Container-fluid starts-->
    <div class="container-fluid">
        <div class="row">

            <div class="col-sm-12">
                <div class="card">
                    <div class="card-header pb-0">
                        <h5 class="card-title">Loan History Reports</h5>
                        <form action="{{ route('get_loanhistory_report') }}" method="GET">
                            @csrf

                            <div class="container-fluid">
                                <div class="form-group row">
                                    <label for="loandate" class="col-form-label col-sm-2">Loan Date</label>
                                    <div class="col-sm-3">
                                        <input type="date" class="form-control input-sm" id="loandate" name="loandate">
                                    </div>
                                </div>
                                <br>
                                <div class="form-group row">
                                    <label for="rdate" class="col-form-label col-sm-2">Return Date</label>
                                    <div class="col-sm-3">
                                        <input type="date" class="form-control input-sm" id="rdate" name="rdate">
                                    </div>
                                </div>
                                <br>
                                <div class="form-group row">
                                    <label for="clientname" class="col-form-label col-sm-2">Client Name</label>
                                    <div class="col-sm-3">
                                        <input type="text" class="form-control input-sm" id="clientname"
                                            name="clientname">
                                    </div>
                                </div>
                                <br>
                                <div class="form-group row">
                                    <label for="clientemail" class="col-form-label col-sm-2">Client Email</label>
                                    <div class="col-sm-3">
                                        <input type="text" class="form-control input-sm" id="clientemail"
                                            name="clientemail">
                                    </div>
                                </div>
                                <br>
                                <div class="form-group row">
                                    <label for="ename" class="col-form-label col-sm-2">Employee Name</label>
                                    <div class="col-sm-3">
                                        <input type="text" class="form-control input-sm" id="ename" name="ename">
                                    </div>
                                </div>
                                <br>
                                <div class="form-group row">
                                    <label for="item" class="col-form-label col-sm-2">Choose an Item Please:</label>
                                    <div class="col-sm-3">
                                        <select name="item" id="item" class="form-select" aria-label="Default select example">
                                            @foreach ($items as $item)
                                                <option value="{{$item->iid}}">{{$item->inumber}} {{$item->iserialnumber}} {{$item->idescription}}</option>
                                            @endforeach
                                        </select>
                                    </div>
                                </div>
                                <br>
                                <div class="form-group row">
                                    <div class="col-sm-2">
                                        <button type="submit" class="btn btn-primary">Search</button>
                                    </div>

                                    <div class="col-sm-2">
                                        <a href="{{ route('loanhistory_report') }}" class="link-primary">Clear</a>
                                    </div>

                                </div>

                            </div>

                        </form>
                    </div>
                    <div class="card-body">
                        <div class="dt-ext table-responsive theme-scrollbar">
                            <table class="display" id="export-button">
                                <thead>
                                    <tr>
                                        <th>Loan Date</th>
                                        <th>Return Date</th>
                                        <th>Client Name</th>
                                        <th>Client Phone</th>
                                        <th>Client Email</th>
                                        <th>Employee Name</th>
                                        <th>Employee Phone</th>
                                        <th>Employee Email</th>
                                            </tr>
                                </thead>
                                <tbody>
                                    @foreach ($loans as $loan)
                                    <tr>
                                        <td>{{ $loan->ILoanDate }}</td>
                                        <td>{{ $loan->IReturnDate }}</td>
                                        <td>{{ $loan->customerName }}</td>
                                        <td>{{ $loan->customerPhone }}</td>
                                        <td>{{ $loan->customerEmail }}</td>
                                        <td>{{ $loan->userName }}</td>
                                        <td>{{ $loan->userPhone }}</td>
                                        <td>{{ $loan->userEmail }}</td>
                                    </tr>
                                @endforeach

                                </tbody>
                                <tfoot>
                                    <tr>
                                        <th>Loan Date</th>
                                        <th>Return Date</th>
                                        <th>Client Name</th>
                                        <th>Client Phone</th>
                                        <th>Client Email</th>
                                        <th>Employee Name</th>
                                        <th>Employee Phone</th>
                                        <th>Employee Email</th>
                                    </tr>
                                </tfoot>
                            </table>
                        </div>
                    </div>
                </div>
            </div>

        </div>
    </div>
@endsection

@section('scripts')
    <script src="{{ asset('assets/js/datatable/datatables/jquery.dataTables.min.js') }}"></script>
    <script src="{{ asset('assets/js/datatable/datatable-extension/dataTables.buttons.min.js') }}"></script>
    <script src="{{ asset('assets/js/datatable/datatable-extension/jszip.min.js') }}"></script>
    <script src="{{ asset('assets/js/datatable/datatable-extension/buttons.colVis.min.js') }}"></script>
    <script src="{{ asset('assets/js/datatable/datatable-extension/pdfmake.min.js') }}"></script>
    <script src="{{ asset('assets/js/datatable/datatable-extension/vfs_fonts.js') }}"></script>
    <script src="{{ asset('assets/js/datatable/datatable-extension/dataTables.autoFill.min.js') }}"></script>
    <script src="{{ asset('assets/js/datatable/datatable-extension/dataTables.select.min.js') }}"></script>
    <script src="{{ asset('assets/js/datatable/datatable-extension/buttons.bootstrap4.min.js') }}"></script>
    <script src="{{ asset('assets/js/datatable/datatable-extension/buttons.html5.min.js') }}"></script>
    <script src="{{ asset('assets/js/datatable/datatable-extension/buttons.print.min.js') }}"></script>
    <script src="{{ asset('assets/js/datatable/datatable-extension/dataTables.bootstrap4.min.js') }}"></script>
    <script src="{{ asset('assets/js/datatable/datatable-extension/dataTables.responsive.min.js') }}"></script>
    <script src="{{ asset('assets/js/datatable/datatable-extension/responsive.bootstrap4.min.js') }}"></script>
    <script src="{{ asset('assets/js/datatable/datatable-extension/dataTables.keyTable.min.js') }}"></script>
    <script src="{{ asset('assets/js/datatable/datatable-extension/dataTables.colReorder.min.js') }}"></script>
    <script src="{{ asset('assets/js/datatable/datatable-extension/dataTables.fixedHeader.min.js') }}"></script>
    <script src="{{ asset('assets/js/datatable/datatable-extension/dataTables.rowReorder.min.js') }}"></script>
    <script src="{{ asset('assets/js/datatable/datatable-extension/dataTables.scroller.min.js') }}"></script>
    <script src="{{ asset('assets/js/datatable/datatable-extension/custom.js') }}"></script>
    <script src="{{ asset('assets/js/tooltip-init.js') }}"></script>
@endsection