@extends('layouts.teacher')
@section('content')
    <div class="app-content my-3 my-md-5 profile-1">
        <div class="side-app">
            <x-page.header>Installment Transactions</x-page.header>
             <!-- Search Section -->
             <form action="{{ route('teacher.installment-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">
                                        <input type="hidden" value="{{request()->get('installment_tab')}}" name="installment_tab">

                                        <div class="col-md-6">
                                            <label class=" mt-3 mb-sm-1"> Session: </label>
                                            <select class="form-control select2-show-search" id="session" name="acysid">
                                                <option value="" disabled selected>Select</option>
                                                @foreach ($academicYearSessions as $session)
                                                    <option value="{{ $session->acysid }}">
                                                        {{ $session->sessions->sname }}
                                                        {{ $session->year }}
                                                        ({{ $session->board->bname }})
                                                    </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">
                                            <div class="">
                                                <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 class="">
                                                <label class=" mt-3 mb-sm-1"> Accounting status: </label>
                                                <select class="form-control select2-show-search" id="accounting_status" name="accounting_status">
                                                    <option value="" disabled selected>Select</option>
                                                    <option value="0">Un-Posted</option>
                                                    <option value="1">Posted</option>
                                                </select>
                                            </div>
                                            <div class="">
                                                <label class=" mt-3 mb-sm-1"> Paymentt status: </label>
                                                <select class="form-control select2-show-search" id="payment_status" name="payment_status">
                                                    <option value="" disabled selected>Select</option>
                                                    <option value="0">Un-Paid</option>
                                                    <option value="1">Paid</option>
                                                </select>
                                            </div>
                                            <div>
                                                <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 ($users as $user)
                                                            <option value="{{ $user->id }}">
                                                                {{ $user->first_name . ' ' . $user->middle_name . ' ' . $user->last_name}}
                                                                ({{$user->email}})
                                                            </option>
                                                    @endforeach
                                                </select>
                                            </div>
                                        </div>
                                        <div class="col-md-6">
                                            <label class="mt-3 mb-sm-1"> from (due_date): </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 (due_date): </label>
                                            <div>
                                            <input type="date" class="form-control" name="end_date" id="to" value="{{request()->start_date ? request()->end_date :''}}">
                                            </div>
                                        </div>

                                        <div class="col-md-2 mt-6">
                                            <input type="submit" id="submit" class="btn btn-primary br-te-7 br-be-7 "
                                                value="@lang('student.apply filter')">
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </form>
            {{-- 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.installment-transactions',['installment_tab=unposted','#transactions']) }}" class="w-100 {{request()->installment_tab == 'unposted' || !request()->installment_tab ? 'active':''}}">Un-Posted</a></li>
                                    <li class="ms-0"><a href="{{ route('teacher.installment-transactions',['installment_tab=posted','#transactions']) }}" class="ms-3 me-2 w-100  {{request()->installment_tab == 'posted' ? 'active':''}}" >Posted</a></li>
                                    <li class="ms-2"><a href="{{ route('teacher.installment-transactions',['installment_tab=refunded','#transactions']) }}" class="ms-3 me-2 w-100  {{request()->installment_tab == 'refunded' ? 'active':''}}" >Refunded</a></li>
                                </ul>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <!--End Search Section -->
           {{-- @if (request()->course || request()->start_date || request()->end_date)     --}}
           <div class="row">
               <div class="col-md-12 col-lg-12">
                   <div class="card">
                       <div class="card-header">
                           <h3 class="card-title">Installment List</h3>
                       </div>
                       <div class="card-body">
                            @if (count($installments) > 0)
                                <form action="{{route('teacher.installment-transactions.export')}}" method="get">
                                    <input type="hidden" value="{{request()->get('student')}}" name="student">
                                    <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('status')}}" name="status">
                                    <input type="hidden" value="{{request()->get('accounting_status')}}" name="accounting_status">
                                    <input type="hidden" value="{{request()->get('payment_status')}}" name="payment_status">
                                    <input type="hidden" value="{{request()->get('installment_tab')}}" name="installment_tab">

                                    <button type="submit" class="btn btn-primary mx-auto d-block w-25 my-6" >Export</button>
                                </form>
                            @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>
                                           <th style="text-align: center;">@lang('student.table.id')</th>
                                           <th style="text-align: center;">student name</th>
                                           <th style="text-align: center;">@lang('student.table.course name')</th>
                                           <th style="text-align: center;">due date</th>
                                           <th style="text-align: center;">Percentage amount</th>
                                           <th class="bg-danger text-light" style="text-align: center;">amount EGP</th>
                                           <th class="bg-primary text-light" style="text-align: center;">amount AED</th>
                                           <th style="text-align: center;">course Currency</th>
                                           <th style="text-align: center;">payment currency</th>
                                           <th style="text-align: center;">Rate</th>
                                           <th style="text-align: center;">@lang('student.table.status')</th>
                                           <th style="text-align: center;">paid at</th>
                                       </tr>
                                   </thead>
                                   <tbody>
                                       @php
                                       $count=0
                                       @endphp
                                       @forelse ($installments as $installment)
                                           <tr class="text-center">
                                               <td>{{ ++$count }}</td>
                                               <td>{{ $installment->first_name.' '.$installment->middle_name.' '.$installment->last_name }}</td>
                                               <td>{{$installment->acyname.'_'.$installment->cname.' ( '.$installment->lshort_name.' )'}}</td>
                                               <td>{{ $installment->due_date }}</td>
                                               <td>
                                                {{$installment->installment_amount}} %
                                                </td>
                                                <td class="bg-danger text-light">
                                                    {{$installment->teacher_amount}}
                                                </td>
                                                <td class="bg-primary text-light">
                                                    {{$installment->teacher_amount_aed}}
                                                </td>
                                                <td> <span class="badge badge-{{$installment->course_currency == '1' ? 'info':'success'}} mt-2">{{ $installment->course_currency == '1' ? 'AED':'EGP' }}</span></td>

                                                <td>
                                                    @php
                                                        // if the installment is EGP it will show as EGP
                                                        if($installment->payment_currency == 2){
                                                            $currency = 'EGP';
                                                        }
                                                        else{
                                                            if($installment->is_paid){
                                                                $currency = ($installment->payment_currency == '1') ? 'AED' : 'EGP';
                                                            }else{
                                                                // else we chck the student profile and based on that we show the currency
                                                                $currency = ($installment->payment_gateway == '1') ? 'AED':'EGP';
                                                            }
                                                        }
                                                    @endphp
                                                    <span class="badge badge-{{$currency == 'AED' ? 'info':'success'}} mt-2">
                                                        {{ $currency }}
                                                    </span>
                                                </td>
                                                <td>{{ $installment->rate ? $installment->rate : '-' }}</td>
                                               <td>
                                                   @if ($installment->is_paid == 0)
                                                   <span class="badge badge-danger">
                                                     Un-Paid
                                                    </span>
                                                   @else
                                                   <span class="badge badge-success">
                                                     Paid
                                                    </span>
                                                   @endif
                                                    {{-- check is refunded --}}
                                                    @if ($installment->is_refunded == 1 || $installment->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="
                                                    Refunded reason : {{ $installment->refund_reason }} <br>
                                                    Refunded by : {{$installment->refundedBy->first_name . ' ' .$installment->refundedBy->last_name}} <br>

                                                   "></i>
                                                    @endif
                                                    @if ($installment->is_posted == 1)
                                                    <span class="badge badge-success">
                                                      Posted
                                                     </span>

                                                    @else
                                                    <span class="badge badge-danger">
                                                      Un-Posted
                                                     </span>
                                                    @endif
                                                    {{-- check if holded --}}
                                                    @if ($installment->holded_transaction_id)
                                                    <span class="badge badge-success">Holded <i class="fa fa-hand-stop-o"></i></span>
                                                    @endif
                                                    @if ($installment->is_exempted)
                                                    <span class="badge badge-warning">
                                                      Exempted
                                                     </span>
                                                     <i class="mdi mdi-information-outline leading-loose" data-bs-html="true" data-bs-toggle="tooltip" data-bs-placement="top" title="
                                                        Exemption reason : {{ $installment->exemption_reason }} <br>
                                                    "></i>
                                                    @endif

                                               </td>
                                               <td>
                                                @if ($installment->is_paid == 1)
                                                <i class="fa fa-calendar"></i>
                                                    {{ $installment->paid_date}}
                                                @else
                                                <i class="fa fa-question-circle-o text-danger fs-18" title="Not Paid Yet"></i>
                                                @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">
                                {{ $installments->appends(Request::except('page'))->render('inc.paginate') }}
                                </div>
                                <p class="mt-3">
                                    Displaying {{$installments->count()}} of {{ $installments->total() }} transaction(s).
                                </p>
                           </div>
                       </div>
                   </div>
               </div>
           </div>
           {{-- @endif --}}

        </div>
    </div>
@endsection
@section('teacher-js')
<script>
    $('#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>

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