@extends('layouts.teacher')
@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($unposted_transactions ? 'teacher.unpostedPayment-transactions.search' : 'teacher.postedPayment-transactions.search') }}" 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"> Sessions: </label>
                                            <select class="form-control select2-show-search" id="session" name="acysid">
                                               <option value="0" selected disabled>Select session</option>
                                               @foreach ($academicYearSessions 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>
                                                @foreach ($students as $student)
														<option value="{{ $student->id }}">
															{{ $student->first_name . ' ' . $student->middle_name . ' ' . $student->last_name}}
                                                            ({{$student->email}})
														</option>
												@endforeach
                                            </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>

                                </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 ? 'teacher.unpostedPayment-transactions' : 'teacher.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('teacher.unpostedPayment-transactions') }}" class="w-100 {{$unposted_transactions ? 'active':''}}">Un-Posted</a></li>
                                    <li class="ms-0"><a href="{{ route('teacher.postedPayment-transactions') }}" class="ms-3 me-2 w-100  {{$posted_transactions ? 'active':''}}" >Posted</a></li>
                                </ul>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            @if ($unposted_transactions)
                <div class="row">
                    <div class="col-md-12 col-lg-12">
                        <div class="card">
                            <div class="card-header">
                                <h3 class="card-title">Payment Un-Posted Transactions List</h3>
                            </div>
                            <div class="card-body">
                                @if (count($unposted_transactions) > 0)
                                    @if ($unposted_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('teacher.payment-transactions-export')}}" method="get">
                                            <input type="hidden" value="0" name="accounting_status">
                                            <input type="hidden" value="{{request()->get('course')}}" name="course">
                                            <input type="hidden" value="{{request()->get('enrollment_method')}}" name="enrollment_method">
                                            <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">
                                            <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>
                                            <tr class="text-center">
                                                <th>id</th>
                                                <th>Student</th>
                                                <th>course name</th>
                                                <th>Enrollment Method</th>
                                                <th>Teaching Team</th>
                                                <th>date</th>
                                                <th class="bg-danger text-white">amount (EGP)</th>
                                                <th class="bg-primary text-white">amount (AED)</th>
                                                <th>Transaction Currency</th>
                                                <th>Student Currency</th>
                                                <th>Rate</th>
                                                <th>status</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @php
                                                $count=0;
                                            @endphp
                                            @forelse ($unposted_transactions as $transaction)
                                                <tr class="text-center">
                                                    <td>{{ ++$count }}</td>
                                                    <td>
                                                        {{ $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>
                                                    </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->teacher_amount }} EGP
                                                        <i class="mdi mdi-information-outline leading-loose" data-bs-html="true" data-bs-toggle="tooltip" data-bs-placement="top" title="
                                                        Discount percentage : {{$transaction->discount_value}} % <br>
                                                        @if($transaction->discount_added_by)
                                                        Discount reason : {{$transaction->discount_reason}}  <br>
                                                        @endif
                                                        "
                                                        data-bs-original-title=""></i>
                                                    </td>
                                                    <td class="bg-primary text-white">
                                                        {{ $transaction->teacher_amount_aed }} AED
                                                        <i class="mdi mdi-information-outline leading-loose" data-bs-html="true" data-bs-toggle="tooltip" data-bs-placement="top" title="
                                                        Discount percentage : {{$transaction->discount_value}} % <br>
                                                        @if($transaction->discount_added_by)
                                                        Discount reason : {{$transaction->discount_reason}}  <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

                                                        <span class="badge badge-danger">
                                                            Un-Posted
                                                        </span>

                                                        <span class="badge badge-primary">
                                                            {{$transaction->is_live == 1 ? 'Live':'Recording'}}
                                                        </span>
                                                    </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">
                                        {{ $unposted_transactions->appends(Request::except('page'))->render('inc.paginate') }}
                                    </div>
                                    <p class="mt-3">
                                        Displaying {{$unposted_transactions->count()}} of {{ $unposted_transactions->total() }} transaction(s).
                                    </p>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            @endif
            @if ($posted_transactions)
            <div class="row">
                <div class="col-md-12 col-lg-12">
                    <div class="card">
                        <div class="card-header">
                            <h3 class="card-title">Payment Un-Posted Transactions List</h3>
                        </div>
                        <div class="card-body">
                            @if (count($posted_transactions) > 0)
                                @if ($posted_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('teacher.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">
                                        <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-striped table-bordered border-top table-vcenter text-nowrap" id="transactions_table">
                                    <thead>
                                        <tr>
                                            <th>id</th>
                                            <th>Student</th>
                                            <th>course name</th>
                                            <th>Enrollment Method</th>
                                            <th>Teacher</th>
                                            <th>date</th>
                                            <th>amount</th>
                                            <th>status</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @php
                                            $count=0;
                                        @endphp
                                        @forelse ($posted_transactions as $transaction)
                                            <tr class="text-center">
                                                <td>{{ ++$count }}</td>
                                                <td>
                                                    {{ $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>
                                                </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>
                                                    {{ $transaction->teacher_amount }} EGP
                                                </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

                                                    <span class="badge badge-success">
                                                        Posted
                                                    </span>

                                                    <span class="badge badge-primary">
                                                        {{$transaction->is_live == 1 ? 'Live':'Recording'}}
                                                    </span>
                                                </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">
                                    {{ $posted_transactions->appends(Request::except('page'))->render('inc.paginate') }}
                                </div>
                                <p class="mt-3">
                                    Displaying {{$posted_transactions->count()}} of {{ $posted_transactions->total() }} transaction(s).
                                </p>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            @endif
        </div>
    </div>
@endsection

@section('teacher-js')
<script>
    $('#transactions_table').dataTable( {
		"drawCallback": function( settings ) {
		},
        "bPaginate": false,
        "searching": true,
        "ordering": true,
        "info": false,
	})

    $('#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) {
                    $('#course').empty();
                    $.each(data, function(id, value) {
                        value.teaching_team.coaching_teachers.map(teacher => {
                            $course.append('<option value="' + value.coffid + '">' +
                                value.course.cname + ' ( '+ value.course.level.lname +' )'+' ( '+ teacher.first_name +' '+teacher.middle_name+' '+teacher.last_name+' )'+'</option>');
                        })
                    });
                }
            });
        });
</script>
@endsection