@extends('layouts.admin')
@section('content')
    <div class="app-content my-3 my-md-5 profile-1">
        <div class="side-app">
            <x-page.header>Attendance Transactions</x-page.header>
             <!-- Search Section -->
             <form action="{{ route('admin.payment-transactions') }}" 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">
                                        <input type="hidden" value="{{request()->get('transaction_tab')}}" name="transaction_tab">
                                        <div class="col-md-6">
                                            <label class=" mt-3 mb-sm-1"> Sessions: </label>
                                            <select class="form-control select2-show-search" id="session" name="acysid">
                                               <option value="0" selected disabled>Select session</option>
                                               @foreach ($sessions as $session)
                                                   <option value="{{$session->acysid}}">{{$session->acyname}}</option>
                                               @endforeach
                                            </select>
                                        </div>
                                        <div class="col-md-6">
                                            <label class=" mt-3 mb-sm-1"> Course Name: </label>
                                            <select class="form-control select2-show-search" id="course" name="course">

                                            </select>
                                        </div>
                                        <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">
                                                <option value="0" disabled selected>Select</option>
                                            </select>
                                        </div>
                                        <div class="col-md-6">
                                            <label class=" mt-3 mb-sm-1"> Enrollment Method: </label>
                                            <select class="form-control select2-show-search" id="enrollment_method" name="enrollment_method">
                                                <option value="" disabled selected>Select</option>
													<option value="1">By Lesson</option>
													<option value="0">By Course</option>
                                            </select>
                                        </div>
                                        <div class="col-md-6">
                                            <div class="">
                                                <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>
                                            </div>
                                            <div class="">
                                                <label class="mt-3 mb-sm-1"> to: </label>
                                                <div>
                                                <input type="date" class="form-control" name="end_date" id="to"  value="{{request()->end_date ? request()->end_date :''}}">
                                                </div>
                                            </div>
                                        </div>
                                        <div class="col-md-6">
                                            <div>
                                                <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="0">Not Refunded</option>
                                                    <option value="1">Refunded</option>
                                                </select>
                                            </div>
                                            <div>
                                                <label class=" mt-3 mb-sm-1"> Currency: </label>
                                                <select class="form-control select2-show-search" id="currency" name="currency">
                                                    <option value="" disabled selected>Select</option>
                                                    <option value="1">AED</option>
                                                    <option value="2">EGP</option>
                                                </select>
                                            </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($unposted_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 -->

            {{-- 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.payment-transactions',['transaction_tab=unposted','#transactions']) }}" class="w-100 {{request()->transaction_tab == 'unposted' || !request()->transaction_tab ? 'active':''}}">Un-Posted</a></li>
                                    <li class="ms-0"><a href="{{ route('admin.payment-transactions',['transaction_tab=posted','#transactions']) }}" class="ms-3 me-2 w-100  {{request()->transaction_tab == 'posted' ? 'active':''}}" >Posted</a></li>
                                    <li class="ms-2"><a href="{{ route('admin.payment-transactions',['transaction_tab=deleted','#transactions']) }}" class="ms-3 me-2 w-100  {{request()->transaction_tab == 'deleted' ? 'active':''}}" >Deleted / Refunded</a></li>
                                </ul>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <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() >5000)
                                    <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.payment-transactions-export')}}" method="get">
                                        <input type="hidden" value="1" name="accounting_status">
                                        <input type="hidden" value="{{request()->get('enrollment_method')}}" name="enrollment_method">
                                        <input type="hidden" value="{{request()->get('course')}}" name="course">
                                        <input type="hidden" value="{{request()->get('start_date')}}" name="start_date">
                                        <input type="hidden" value="{{request()->get('end_date')}}" name="end_date">
                                        <input type="hidden" value="{{request()->get('student')}}" name="student">
                                        <input type="hidden" value="{{request()->get('status')}}" name="status">
                                        <input type="hidden" value="{{request()->get('currency')}}" name="currency">
                                        <input type="hidden" value="{{request()->get('transaction_tab')}}" name="transaction_tab">
                                        <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">
                                <table
                                    class="table card-table table-bordered border-top table-vcenter text-nowrap" id="transactions_table">
                                    <thead class="text-center">
                                        <tr>
                                            <th>id</th>
                                            <th>Student</th>
                                            <th>course name</th>
                                            <th>Enrollment Method</th>
                                            <th>Teacher</th>
                                            <th>date</th>
                                            <th class="bg-danger text-white">amount due (EGP)</th>
                                            <th class="bg-primary text-white">amount due (AED)</th>
                                            <th>Transaction Currency</th>
                                            <th>Student Currency</th>
                                            <th>Rate</th>
                                            <th>status</th>
                                            @if (request()->transaction_tab != 'deleted')
                                            <th>Refund</th>
                                            @endif
                                        </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=tab4'])}}" 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>
                                                {{$transaction->has_label ? ' ( '.$transaction->label.' ) ':''}} {{ $transaction->cname }}
                                                    ( {{ $transaction->lshort_name }} )
                                                    (
                                                    {{ $transaction->acyname }})

                                                </td>
                                                <td>
                                                    <span class="badge badge-success">{{$transaction->fees_by_lesson ? 'By Lesson':'By Course'}}</span>
                                                </td>
                                                <td>
                                                    {{ $transaction->ttname }}
                                                </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 class="bg-danger text-white">
                                                    {{ $transaction->amount_due }} EGP
                                                    <i class="mdi mdi-information-outline leading-loose" data-bs-html="true" data-bs-toggle="tooltip" data-bs-placement="top" title="
                                                        Total amount : {{$transaction->amount}}  EGP<br>
                                                        Teacher amount : {{$transaction->teacher_amount}}  EGP<br>
                                                        Eshra7ly amount : {{$transaction->eshra7ly_amount}}  EGP<br>
                                                        Discount percentage : {{$transaction->discount_value}} % <br>
                                                        Discount amount : {{$transaction->discount_amount}}  EGP<br>
                                                        @if($transaction->discount_added_by)
                                                        Discount reason : {{$transaction->discount_reason}}  <br>
                                                        @endif
                                                        @if($transaction->discount_added_by)
                                                        Discount added by : {{$transaction->discount_added_by_fname.' '.$transaction->discount_added_by_lname}}  <br>
                                                        @endif
                                                        "
                                                        data-bs-original-title=""></i>
                                                </td>
                                                <td class="bg-primary text-white">
                                                    {{ $transaction->amount_due_aed }} AED
                                                    <i class="mdi mdi-information-outline leading-loose" data-bs-html="true" data-bs-toggle="tooltip" data-bs-placement="top" title="
                                                        Total amount : {{$transaction->amount_aed}}  AED<br>
                                                        Teacher amount : {{$transaction->teacher_amount_aed}}  AED<br>
                                                        Eshra7ly amount : {{$transaction->eshra7ly_amount_aed}}  AED<br>
                                                        Discount percentage : {{$transaction->discount_value}} % <br>
                                                        Discount amount : {{$transaction->discount_amount_aed}}  AED<br>
                                                        @if($transaction->discount_added_by)
                                                        Discount reason : {{$transaction->discount_reason}}  <br>
                                                        @endif
                                                        @if($transaction->discount_added_by)
                                                        Discount added by : {{$transaction->discount_added_by_fname.' '.$transaction->discount_added_by_lname}}  <br>
                                                        @endif
                                                        "
                                                        data-bs-original-title=""></i>
                                                </td>
                                                <td><span class="badge badge-{{ $transaction->currency == 2 ? 'danger':'primary' }}">{{ $transaction->currency == 2 ? 'EGP':'AED' }}</span></td>
                                                <td><span class="badge badge-{{ $transaction->payment_gateway == 2 ? 'danger':'primary' }}">{{ $transaction->payment_gateway == 2 ? 'EGP':'AED' }}</span></td>
                                                <td>{{ $transaction->rate ? $transaction->rate : 0 }}</td>
                                                <td class="">
                                                    @if($transaction->is_extra)
                                                        <span class="badge" style="background: #8c2828;color:aliceblue">Extra</span>
                                                    @endif
                                                    @if ($transaction->is_refunded == 1 || $transaction->is_refunded_after_post == 1)
                                                    <span class="badge badge-danger">
                                                        Refunded
                                                    </span>
                                                    <i class="mdi mdi-information-outline leading-loose" data-bs-html="true" data-bs-toggle="tooltip" data-bs-placement="top" title="
                                                        {{ $transaction->refund_reason }} <br>
                                                        Refunded by : {{$transaction->refunded_by_fname.' '. $transaction->refunded_by_lname}}
                                                        at {{$transaction->updated_at->format('Y-m-d')}}
                                                        "

                                                        data-bs-original-title=""></i>
                                                    @else
                                                    <span class="badge badge-success">
                                                        Paid
                                                    </span>
                                                    @endif

                                                    @if ($transaction->is_posted)
                                                        <span class="badge badge-success">
                                                            Posted
                                                        </span>
                                                    @else
                                                        <span class="badge badge-danger">
                                                            Un-Posted
                                                        </span>
                                                    @endif

                                                    <span class="badge badge-primary">
                                                        {{$transaction->is_live == 1 ? 'Live':'Recording'}}
                                                    </span>
                                                    @if ($transaction->deleted_at)
                                                    <span class="badge badge-danger">
                                                      Deleted
                                                      <i class="fa fa-trash"></i>
                                                     </span>
                                                    @endif

                                                </td>
                                                @if (request()->transaction_tab != 'deleted')
                                                <td style="text-align: center;">
                                                    @if ($transaction->is_refunded == 1 || $transaction->is_refunded_after_post == 1)
                                                        <span class="text-danger">Already Refunded</span>
                                                    @else
                                                    <div data-bs-toggle="tooltip"data-bs-original-title="Refund">
                                                    <button type="button"
                                                        value="{{$transaction->tblid}}"
                                                        data-student="{{$transaction->user_id}}"
                                                        data-amount="{{$transaction->amount}}"
                                                        data-amount_due="{{$transaction->amount_due}}"
                                                        data-discount_amount="{{$transaction->discount_amount}}"
                                                        data-eshra7ly_amount="{{$transaction->eshra7ly_amount}}"
                                                        data-teacher_amount="{{$transaction->teacher_amount}}"
                                                        data-course="{{ $transaction->cname }}"
                                                        data-courseOffering="{{ $transaction->coffid }}"
                                                        class="modal-effect btn btn-outline-light btn-sm waves-effect waves-light refund"
                                                        data-bs-effect="effect-sign" data-bs-toggle="modal" data-bs-original-title="Refund" data-bs-target="#refund_reason">
                                                        <i class="fa fa-window-close fs-16"></i>
                                                    </button>
                                                    </div>

                                                    @endif
                                                </td>
                                                @endif
                                            </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>
        </div>
    </div>
    {{-- refund reason modeal --}}
    <div class="modal  fade effect-sign show" id="refund_reason" tabdocumentation="-1" role="dialog" aria-hidden="true">
        <div class="modal-dialog" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title" id="example-Modal3">Refund Reason</h5>
                    <button type="button" class="close" data-bs-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                </div>
                <div class="modal-body">
                    {{-- <form method="POST" action="" id="board_form_update" name="boardform"  enctype="multipart/form-data">
                        @csrf
                    <div class="form-group ">
                                    <div class="row">
                                        <div class="col-md-3">
                                            <label class="form-label mt-2" for="education_system_name_update">Education System <i
                                                    class="text-danger">(required)</i></label>
                                        </div>
                                        <div class="col-md-9">

                                            <select id="education_system_name_update" name="esid" class="form-control select2-show-search" required>
                                                @foreach ($educationSystems as $item)

                                                <option value="{{$item->esid}}">{{$item->esname}}</option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                </div>

                                <div class="form-group ">
                                    <div class="row">
                                        <div class="col-md-3">
                                            <label class="form-label mt-2" for="board_name_update">Name <i
                                                    class="text-danger">(required)</i></label>
                                        </div>
                                        <div class="col-md-9">
                                            <input type="text" name="bname" class="form-control" id="board_name_update" placeholder=""
                                                required>
                                        </div>
                                    </div>
                                </div>

                                <div class="form-group ">
                                    <div class="row">
                                        <div class="col-md-3">
                                            <label class="form-label mt-2" for="board_description_update">Description</label>
                                        </div>
                                        <div class="col-md-9">

                                            <textarea class="form-control" name="bdescription" id="board_description_update"
                                                rows="3"></textarea>
                                        </div>
                                    </div>
                                </div>

                                <div class="form-group ">
                                    <div class="row">
                                        <div class="col-md-3">
                                            <label class="form-label mt-2" for="board_url_update">Website</label>
                                        </div>
                                        <div class="col-md-9">
                                            <input type="url" name="burl" onchange="return validURL('board_url_create')" id="board_url_update" class="form-control" placeholder="">
                                        </div>
                                    </div>
                                </div>


                                <div class="form-group ">
                                    <div class="row">
                                        <div class="col-md-3">
                                            <label class="form-label mt-2" for="board_image_update">Image</label>
                                        </div>
                                        <div class="col-md-9">
                                            <div class="control-group form-group">
                                                <div class="input-group file-browser">
                                                    <input type="text"
                                                        class="form-control border-end-0 browse-file bg-transparent"
                                                        placeholder="Upload Image" readonly="">
                                                    <label class="input-group-btn">
                                                        <span class="btn btn-primary br-bs-0 br-ts-0">
                                                            Browse <input type="file" id="board_image_update" name="bimage" style="display: none;" accept="image/*" onchange="return fileValidation('board_image_update')">
                                                        </span>
                                                    </label>
                                                </div>
                                            </div>

                                        </div>
                                    </div>
                                </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
                    <button type="submit" id="submit" class="btn btn-primary" value="">Submit</button>
                    <input type="hidden" id="board_id" name="bid" value="0">
                </div>
                </form> --}}

                <form method="POST" action="" id="refund_form">
                    @csrf
                    <input name="_method" type="hidden" value="POST">
                    <input type="hidden" name="student" id="student_id" value="">
                    <input type="hidden" name="amount" id="amount" value="">
                    <input type="hidden" name="amount_due" id="amount_due" value="">
                    <input type="hidden" name="discount_amount" id="discount_amount" value="">
                    <input type="hidden" name="eshra7ly_amount" id="eshra7ly_amount" value="">
                    <input type="hidden" name="teacher_amount" id="teacher_amount" value="">
                    <input type="hidden" name="course" id="course" value="">
                    <input type="hidden" name="coffid" id="courseOffering" value="">
                    <div class="form-group ">
                        <div class="row">
                            <div class="col-md-3">
                                <label class="form-label mt-2" for="reason">Reason* <span class="text-danger">(Required)</span></label>
                            </div>
                            <div class="col-md-9">

                                <textarea class="form-control" name="reason" id="reason"
                                    rows="3" required></textarea>
                            </div>
                        </div>
                    </div>
                    <div class="modal-footer">
                        <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
                        <button type="submit" id="submit" class="btn btn-primary" value="">Refund</button>
                    </div>
                </form>
            </div>
        </div>
    </div>
@endsection
@section('admin-js')
<script>

  jQuery('body').on('click', '.refund', function () {
            var tblid = $(this).val();
            var url = "{{ route('admin.payment-transactions.refundPayment', ":tblid") }}";
            url = url.replace(':tblid', tblid);
                jQuery('#student_id').val($(this).attr('data-student'));
                jQuery('#amount').val($(this).attr('data-amount'));
                jQuery('#amount_due').val($(this).attr('data-amount_due'));
                jQuery('#discount_amount').val($(this).attr('data-discount_amount'));
                jQuery('#eshra7ly_amount').val($(this).attr('data-eshra7ly_amount'));
                jQuery('#teacher_amount').val($(this).attr('data-teacher_amount'));
                jQuery('#course').val($(this).attr('data-course'));
                jQuery('#courseOffering').val($(this).attr('data-courseOffering'));
                jQuery('#refund_form').attr('action',url)
        });

        // course session filter
        $('#session').on('change', function() {
            var $course = $('#course');
            $('#course').empty();
            $('#course').append(`<option value="0" disabled selected>Processing...</option>`);
            $.ajax({
                url: "{{ route('sessionFilter') }}",
                type: 'GET',
                data: {
                    acysid: $(this).val()
                },
                success: function(data) {
                    console.log(data)
                    $('#course').empty();
                    $('#course').append(
                        `<option value="0" disabled selected>Select Course*</option>`);
                    // offered course
                    $.each(data, function(id, value) {

                        value.teaching_team.coaching_teachers.map((teacher)=>{
                            $course.append('<option value="' + value.coffid + '">' +
                            (value.has_label ? '( '+value.label+' ) ' : '') + value.course.cname + ' ( '+ value.course.level.lshort_name+' ) '
                            +'_ '+ teacher.first_name+' '+ teacher.middle_name+' '+ teacher.last_name
                            +'_ '+value.academic_year_session.acyname
                            +'</option>');
                        })

                    });
                }
            });
        });

</script>

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