@extends('layouts.admin')
@section('content')
    <div class="app-content my-3 my-md-5 profile-1">
        <div class="side-app">
            <x-page.header>Paymob UAE Transactions</x-page.header>
             <!-- Search Section -->
             <form action="{{ route('admin.paymobUAETransactions') }}" method="get">
                <div class="mb-5">
                    <div class="">
                        <div class="p-5 bg-white">
                            <div class="mt-3 item2-gl-nav">
                                <div class="d-block ">
                                    <h5 class="mb-2 mt-0">@lang('student.filter by')</h5>
                                    <div class="row">
                                        <div class="col-md-6">
                                            <label class=" mt-3 mb-sm-1"> Student: </label>
                                            <select class="form-control select2-show-search" id="student" name="student" required>
                                                <option value="0" disabled selected>Select</option>
                                            </select>
                                        </div>
                                        <div class="col-md-3">
                                            <label class=" mt-3 mb-sm-1">status: </label>
                                            <select class="form-control select2-show-search" id="status" name="status">
                                                <option value="" disabled selected>Select</option>
                                                <option value="INITIAL">initial</option>
                                                <option value="SUCCESS">success</option>
                                                <option value="FAIL">failed</option>
                                            </select>
                                        </div>
                                        <div class="col-md-3">
                                            <label class="mt-3 mb-sm-1"> from: </label>
                                            <div>
                                            <input type="date" class="form-control" name="start_date" id="from" value="{{request()->start_date ? request()->start_date :''}}">
                                            </div>

                                            <label class="mt-3 mb-sm-1"> to: </label>
                                            <div>
                                            <input type="date" class="form-control" name="end_date" id="to" value="{{request()->start_date ? request()->end_date :''}}">
                                            </div>
                                        </div>
                                    </div>
                                </div>
                                <div class="mt-5 d-flex">
                                    <div class="mx-auto">
                                        <input type="submit" id="submit" class="btn btn-primary"
                                            value="Apply Filter">
                                        {{-- <button href="{{route($transactions ? 'admin.unpostedPayment-transactions' : 'admin.postedPayment-transactions')}}" id="reset" class="btn btn-danger">Reset</button> --}}
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </form>
            <!--End Search Section -->
            @if ($transactions)
                <div class="row">
                    <div class="col-md-12 col-lg-12">
                        <div class="card">
                            <div class="card-header">
                                <h3 class="card-title">Transactions List</h3>
                            </div>
                            <div class="card-body">
                                @if (count($transactions) > 0)
                                    @if ($transactions->total() >4000)
                                        <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 the transactions so you can export data smoothly">Export</button>
                                        @else
                                        <form action="{{route('admin.paymobUAETransactions.export')}}" method="get">
                                            <input type="hidden" value="{{request()->get('student')}}" name="student">
                                            <input type="hidden" value="{{request()->get('status')}}" name="status">
                                            <input type="hidden" value="{{request()->get('start_date')}}" name="start_date">
                                            <input type="hidden" value="{{request()->get('end_date')}}" name="end_date">
                                            <button type="submit" class="btn btn-primary mx-auto d-block w-25 my-6" >Export</button>
                                        </form>
                                    @endif
                                @endif
                                <div class="table-responsive" id="transactions">
                                    <div>
                                        <b>
                                            Total amount (AED) (success):
                                            <span class="text-danger">{{ round($paymob_uae_amount,2) / 100 }} AED</span>
                                        </b>
                                        <br>
                                        <b>
                                            Total amount (EGP) (success):
                                            <span class="text-danger">{{ round($paymob_egp_amount,2) / 100 }} EGP</span>
                                        </b>
                                    </div>
                                    <table
                                        class="table card-table table-striped table-bordered border-top table-vcenter text-nowrap" id="transactions_table">
                                        <thead>
                                            <tr>
                                                <th style="text-align: center;">id</th>
                                                <th style="text-align: center;">Student</th>
                                                <th style="text-align: center;">Amount Due</th>
                                                <th style="text-align: center;">Base Amount</th>
                                                <th style="text-align: center;">Exchange Rate</th>
                                                <th style="text-align: center;">Amount UAE</th>
                                                <th style="text-align: center;">Bonus</th>
                                                <th style="text-align: center;">Bonus Rate</th>
                                                <th style="text-align: center;">Fees</th>
                                                <th style="text-align: center;">Vat</th>
                                                <th style="text-align: center;">Merchant OID</th>
                                                <th style="text-align: center;">Paymob OID</th>
                                                <th style="text-align: center;">Transaction Id</th>
                                                <th style="text-align: center;">Status</th>
                                                <th style="text-align: center;">Created_at EGP</th>
                                                <th style="text-align: center;">Updated_at</th>
                                                <th style="text-align: center;">Updated_at UAE</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @php
                                                $count=0
                                            @endphp
                                            @forelse ($transactions as $transaction)
                                                <tr class="text-center">
                                                    <td>{{ ++$count }}</td>
                                                    <td>
                                                    <a href="{{route('admin.students.show',[$transaction->user_id,'is_active_tab=tab2'])}}" target="_blank">
                                                        {{ $transaction->first_name . ' ' . $transaction->middle_name. ' ' . $transaction->last_name}}
                                                        <i class="mdi mdi-information-outline leading-loose" data-bs-html="true" data-bs-toggle="tooltip" data-bs-placement="top" title="
                                                        Phone: {{ $transaction->phone}} <br> Email: {{ $transaction->email}} <br>
                                                        "
                                                        data-bs-original-title=""></i>
                                                    </a>
                                                    </td>
                                                    <td>
                                                        {{ round(($transaction->request_amount / 100),2) }} EGP
                                                    </td>
                                                    <td>
                                                        {{ round((($transaction->request_amount - $transaction->request_bonus_amount) / 100), 2) }} EGP
                                                    </td>
                                                    <td>
                                                        {{ ($transaction->request_amount_aed_rate) }}
                                                    </td>
                                                    <td>
                                                        {{ round(($transaction->request_amount_aed / 100),2) }} AED
                                                    </td>
                                                    <td>
                                                        {{ round(($transaction->request_bonus_amount / 100),2) }} EGP
                                                    </td>
                                                    <td>
                                                        {{ $transaction->request_bonus_rate }}
                                                    </td>
                                                    <td>
                                                        {{ $transaction->request_fees }}
                                                    </td>
                                                    <td>
                                                        {{ $transaction->request_vat }}
                                                    </td>
                                                    <td>
                                                        {{ $transaction->request_orderNo }}
                                                    </td>
                                                    <td>
                                                        {{ $transaction->request_order_id }}
                                                    </td>
                                                    <td>
                                                        {{ $transaction->request_transaction_id }}
                                                    </td>
                                                    <td class="">
                                                        @if ($transaction->request_status == 'INITIAL')
                                                            <span class="badge badge-info">
                                                                {{$transaction->request_status}}
                                                            </span>
                                                           {{-- <div class="mt-2"> 
                                                            <a href="{{ route('admin.paymobUAETransactionsEdit',[$transaction->id]) }}" class="btn btn-success btn-sm waves-effect waves-light">Change to SUCCESS</a>
                                                           </div> --}}
                                                            @elseif ($transaction->request_status == 'SUCCESS')
                                                            <span class="badge badge-success">
                                                                {{$transaction->request_status}}
                                                            </span>
                                                            @elseif ($transaction->request_status == 'FAIL')
                                                            <span class="badge badge-danger">
                                                                {{$transaction->request_status}}
                                                            </span>
                                                        @endif
                                                    </td>
                                                    <td>
                                                        <i class="fa fa-calendar"></i>
                                                        {{ $transaction->created_at->format('d-m-Y') . ' / '}}
                                                        <i class="fa fa-clock-o"></i>
                                                        {{date('h:i A', strtotime($transaction->created_at))}}
                                                    </td>
                                                    <td>
                                                        @if ($transaction->updated_at)
                                                        <i class="fa fa-calendar"></i>
                                                        {{ $transaction->updated_at->format('d-m-Y') . ' / '}}
                                                        <i class="fa fa-clock-o"></i>
                                                        {{date('h:i A', strtotime($transaction->updated_at))}}
                                                        @else
                                                        Not Updated Yet
                                                        @endif
                                                    </td>
                                                    <td>
                                                        @if ($transaction->created_at_uae)
                                                        <i class="fa fa-calendar"></i>
                                                        {{ $transaction->created_at_uae}}
                                                        @endif
                                                    </td>
                                                </tr>
                                                @empty
                                                <tr>
                                                    <td colspan="11">
                                                        <img src="{{env('SECURE_ASSETS').'/images/media/empty_table.svg'}}" class="mx-auto d-block" width="100" alt="empty table">
                                                        <p class="text-primary font-weight-bold text-center mt-3">There is no data!</p>
                                                    </td>
                                                </tr>
                                            @endforelse
                                        </tbody>

                                    </table>
                                    <div class="mt-4">
                                        {{ $transactions->appends(Request::except('page'))->render('inc.paginate') }}
                                    </div>
                                    <p class="mt-3">
                                        Displaying {{$transactions->count()}} of {{ $transactions->total() }} transaction(s).
                                    </p>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            @endif

        </div>
    </div>
@endsection
@section('admin-js')

{{-- draw all data tables --}}
<script>
$(document).ready(function(){
	$('#transactions_table').dataTable( {
		"drawCallback": function( settings ) {
		},
        "bPaginate": false,
        "searching": true,
        "ordering": true,
        "info": false,
	})
})

</script>

@endsection