@extends('layouts.admin')
@section('content')
    <div class="container-fluid">
        <div class="row">
            <div class="col-md-12">
                <div class="card">
                    <div class="card-header">
                        <div class="row">
                            <div class="col-md-4">
                                <h5>Transfer Report</h5>
                            </div>
                        </div>

                    </div>
                    <div class="card-body">
                        <form method="GET" action="{{ route('admin.user_balance_transfer_report') }}">
                            <div class="row mb-3">

                                <div class="col-md-3">
                                    <div class="form-group ">
                                        <label for="packageType" class="col-form-label pt-0">Select Customer</label>
                                        <select class="select2 form-control mb-3 custom-select" name="user_id" >
                                            <option disabled="" selected="" value="">Select Customer</option>
                                            @foreach ($members as $member)
                                                <option value="{{ $member->id }}" {{ $member->id==old('user_id') ? 'selected' : '' }} >{{ $member->name }}-{{$member->user_id}}</option>
                                            @endforeach
                                        </select>
                                    </div>
                                </div>

                                <div class="col-md-3">
                                    <div class="form-group ">
                                        <label for="startDate" class="col-form-label pt-0"> From Date</label>
                                        <input class="form-control" readonly type="text" name="start_date" id="startDate" placeholder="From"  value="{{ old('start_date')}}" autocomplete="off">
                                    </div>
                                </div>
                                <div class="col-md-3">
                                    <div class="form-group ">
                                        <label for="endDate" class="col-form-label pt-0"> To Date</label>
                                        <input class="form-control" readonly type="text" name="end_date" id="endDate" placeholder="To"  value="{{ old('end_date')}}" autocomplete="off">
                                    </div>
                                </div>


                                <div class="col-md-3 mt-4">
                                    <button class="btn btn-primary">Search</button>
                                    <a href="{{ route('admin.user_balance_transfer_report') }}" class="btn btn-danger">Clear</a>
                                </div>
                            </div>
                        </form>
                        <div class="dropdown-divider"></div>
                        <div class="table-responsive">
                            <table id="datatable-buttons-alllist" class="table table-striped table-bordered w-100">
                                <thead>
                                <tr class="text-center">
                                    <th>SL.</th>
                                    <th>User Name</th>
                                    <th>Transfer Amount</th>
                                    <th>Comment</th>
                                    <th>Created Time</th>
                                </tr>
                                </thead>
                                <tbody>
                                @php
                                    $total = 0;
                                @endphp
                                @foreach($balance_transfer as $key => $transfer)
                                    <tr class="text-center">
                                        <td class="text-center">{{$key+1}}</td>
                                        <td>{{ cn($transfer, 'user.name', '') }} ({{ cn($transfer, 'user.user_id', '') }})</td>
                                        <td>{{ number_format($transfer->amount) }}</td>
                                        <td>{{ $transfer->comment }}</td>
                                        <td>{{ date('d-M-Y g:i A', strtotime($transfer->created_at)) }} </td>
                                    </tr>
                                    @php
                                        $total += $transfer->amount;
                                    @endphp
                                @endforeach

                                </tbody>
                                <tfoot>
                                <tr>
                                    <td></td>
                                    <td class="text-center">Grand Total</td>
                                    <td class="text-center">{{ number_format($total) }}</td>
                                    <td></td>
                                    <td></td>
                                </tr>
                                </tfoot>
                            </table>

                            <div class="float-right mt-2">
                                {{ $balance_transfer->appends(request()->query())->links() }}
                            </div>
                        </div>
                    </div>
                </div>
            </div> <!-- end col -->
        </div><!--end row-->

    </div> <!-- container-fluid -->

    @push('alljs')
        <script src="{{asset('assets/libs/bootstrap-datepicker/js/bootstrap-datepicker.min.js')}}"></script>

        <script type="text/javascript">
            $('#startDate').datepicker({
                format: 'dd-mm-yyyy',
                autoclose:!0,
                todayHighlight:!0
            });
            $('#endDate').datepicker({
                format: 'dd-mm-yyyy',
                autoclose:!0,
                todayHighlight:!0
            });
        </script>
    @endpush
@endsection