@extends('layouts.admin')
@section('content')
<!--App-Content-->
<div class="app-content my-3 my-md-5 profile-1">
    <div class="side-app">
        <x-page.header>Refunded To Wallet Details</x-page.header>
        {{-- tabs --}}
        <div class="mt-8">
            <div class="ps-0 pb-5">
                <div class="wideget-user-tab">
                    <div class="tab-menu-heading">
                        <div class="tabs-menu1">
                            <ul class="nav">
                                <li><a href="{{ route('admin.summary.totalRefundToWallet',['date='.request()->get("date"),'status=transactions']) }}" class="w-100 {{request()->status=='transactions' || !request()->status ? 'active':''}}">Transactions</a></li>
                                <li class="ms-0"><a href="{{ route('admin.summary.totalRefundToWallet',['date='.request()->get("date"),'status=installments']) }}" class="ms-3 me-2 w-100  {{request()->status=='installments' ? 'active':''}}" >Installments</a></li>
                            </ul>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="row">
            @if (request()->status=='transactions' || !request()->status)
            <div class="col-md-12">
                <div class="card">
                    <div class="card-header">
                        <h3 class="card-title">Refunded Transactions List</h3>
                    </div>
                    <div class="card-body">
                        @if (count($total_transactions_refunded_to_wallets) > 0)
                            @if ($total_transactions_refunded_to_wallets->total() >10000)
                                <button class="btn btn-primary mx-auto d-block w-25 my-6"  data-bs-html="true" data-bs-toggle="tooltip" data-bs-placement="top" title="Please Filter With month as there are huge amount of transactions">Export</button>
                            @else
                                <form action="{{route('admin.summary.exportTotalRefundToWallet')}}" method="get">
                                    <input type="hidden" value="{{request()->get('date')}}" name="date">
                                    <input type="hidden" value="{{request()->get('status')}}" name="status">
                                    <button type="submit" class=" mb-2 btn btn-sm btn-outline-success mx-auto d-block w-25 shadow-md">
                                        Export
                                        <i class="fa fa-file-excel-o  ms-2 fs-14"></i>
                                    </button>
                                </form>
                            @endif
                        {{-- <p class="font-weight-bold">Total Refund: <span class="text-danger">{{$total_transactions_refunded_to_wallets->total()->sum('amount_due')}}</span> <span class="text-success">EGP</span></p> --}}
                        @endif
                        <div class="table-responsive">
                            <div>
                                <b>
                                    amount:
                                    <span class="text-danger">{{ round($total_transactions_refunded_amount_to_wallets,2) }}</span>
                                </b>
                            </div>
                            <table
                                id="transactions_table" class="table table-striped table-bordered table-vcenter text-nowrap">
                                <thead>
                                    <tr>
                                        <th style="text-align: center;">Id</th>
                                        <th style="text-align: center;">Name</th>
                                        <th style="text-align: center;">Refunded By</th>
                                        <th style="text-align: center;">reason</th>
                                        <th style="text-align: center;">Course Name</th>
                                        <th style="text-align: center;">Amount</th>
                                        <th style="text-align: center;">Date/Time</th>

                                    </tr>
                                </thead>
                                <tbody>
                                    @php
                                    $count=0
                                    @endphp
                                    @foreach ($total_transactions_refunded_to_wallets as $item)
                                        <tr class="text-center">
                                            <td>{{++$count}}</td>
                                            <td>
                                                <a href="{{route('admin.students.show',$item->id)}}" target="_blank">
                                                    {{$item->first_name.' '.$item->middle_name.' '.$item->last_name}}
                                                    <i class="mdi mdi-information-outline leading-loose" data-bs-html="true" data-bs-toggle="tooltip" data-bs-placement="top" title="
                                                    Phone: {{ $item->phone}} <br> Email: {{ $item->email}} "
                                                    ></i>
                                                </a>
                                            </td>
                                            <td>{{$item->refunded_by_fname.' '.$item->refunded_by_lname}}</td>
                                            <td>{{$item->refund_reason}}</td>
                                            <td>
                                                @if ($item->has_label)
                                                    {{$item->label}}
                                                @endif
                                                {{$item->acyname.'_'.$item->cname.' ( '.$item->lshort_name.' )'.'_'.$item->ttname}}
                                            </td>
                                            <td>{{$item->amount_due}}</td>
                                            <td>
                                                <i class="fa fa-calendar"></i>
                                                {{ date('Y-m-d', strtotime($item->created_at)) . ' / '}}
                                                <i class="fa fa-clock-o"></i>
                                                {{date('h:i A', strtotime($item->created_at))}}
                                            </td>
                                        </tr>
                                    @endforeach
                                </tbody>
                            </table>
                            <div class="mt-3">
                            {{ $total_transactions_refunded_to_wallets->appends(Request::except('page'))->render('inc.paginate') }}
                            </div>
                            <p class="mt-3">
                                Displaying {{$total_transactions_refunded_to_wallets->count()}} of {{ $total_transactions_refunded_to_wallets->total() }} transaction(s).
                            </p>
                        </div>
                    </div>
                </div>
            </div>
            @elseif (request()->status=='installments')
            <div class="col-md-12">
                <div class="card">
                    <div class="card-header">
                        <h3 class="card-title">Refunded Installments List</h3>
                    </div>
                    <div class="card-body">
                        @if (count($total_installments_refunded_to_wallets) > 0)
                            @if ($total_installments_refunded_to_wallets->total() >10000)
                                <button class="btn btn-primary mx-auto d-block w-25 my-6"  data-bs-html="true" data-bs-toggle="tooltip" data-bs-placement="top" title="Please Filter With month as there are huge amount of transactions">Export</button>
                            @else
                                <form action="{{route('admin.summary.exportTotalRefundToWallet')}}" method="get">
                                    <input type="hidden" value="{{request()->get('date')}}" name="date">
                                    <input type="hidden" value="{{request()->get('status')}}" name="status">
                                    <button type="submit" class=" mb-2 btn btn-sm btn-outline-success mx-auto d-block w-25 shadow-md">
                                        Export
                                        <i class="fa fa-file-excel-o  ms-2 fs-14"></i>
                                    </button>
                                </form>
                            @endif
                        {{-- <p class="font-weight-bold">Total Refund: <span class="text-danger">{{$total_transactions_refunded_to_wallets->total()->sum('amount_due')}}</span> <span class="text-success">EGP</span></p> --}}
                        @endif
                        <div class="table-responsive">
                            <div>
                                <b>
                                    amount:
                                    <span class="text-danger">{{ round($total_installments_amount_refunded_to_wallets,2) }}</span>
                                </b>
                            </div>
                            <table
                                id="transactions_table" class="table table-striped table-bordered table-vcenter text-nowrap">
                                <thead>
                                    <tr>
                                        <th style="text-align: center;">Id</th>
                                        <th style="text-align: center;">Name</th>
                                        <th style="text-align: center;">Refunded By</th>
                                        <th style="text-align: center;">reason</th>
                                        <th style="text-align: center;">Course Name</th>
                                        <th style="text-align: center;">Amount</th>
                                        <th style="text-align: center;">Due Date</th>

                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach ($total_installments_refunded_to_wallets as $key=>$item)
                                        <tr class="text-center">
                                            <td>{{++$key}}</td>
                                            <td>
                                                <a href="{{route('admin.students.show',$item->id)}}" target="_blank">
                                                    {{$item->first_name.' '.$item->middle_name.' '.$item->last_name}}
                                                    <i class="mdi mdi-information-outline leading-loose" data-bs-html="true" data-bs-toggle="tooltip" data-bs-placement="top" title="
                                                    Phone: {{ $item->phone}} <br> Email: {{ $item->email}} "
                                                    ></i>
                                                </a>
                                            </td>
                                            <td>{{$item->refunded_by_fname.' '.$item->refunded_by_lname}}</td>
                                            <td>{{$item->refund_reason}}</td>
                                            <td>
                                                @if ($item->has_label)
                                                    {{$item->label}}
                                                @endif
                                                {{$item->acyname.'_'.$item->cname.' ( '.$item->lshort_name.' )'.'_'.$item->ttname}}
                                            </td>
                                            <td>{{$item->amount}}</td>
                                            <td>
                                                <i class="fa fa-calendar"></i>
                                                {{ date('Y-m-d', strtotime($item->due_date))}}

                                            </td>
                                        </tr>
                                    @endforeach
                                </tbody>
                            </table>
                            <div class="mt-3">
                            {{ $total_installments_refunded_to_wallets->appends(Request::except('page'))->render('inc.paginate') }}
                            </div>
                            <p class="mt-3">
                                Displaying {{$total_installments_refunded_to_wallets->count()}} of {{ $total_installments_refunded_to_wallets->total() }} installment(s).
                            </p>
                        </div>
                    </div>
                </div>
            </div>
            @endif
        </div>
    </div>
</div>
@endsection
@section('admin-js')
<script>
    $(document).ready(function(){
        $('#transactions_table').dataTable( {
            "drawCallback": function( settings ) {
            },
        "bPaginate": false,
        "searching": true,
        "ordering": true,
        "info": false,
        })
    })
</script>
@endsection