@extends('layouts.admin')
@section('content')
    <div class="app-content my-3 my-md-5 profile-1">
        <div class="side-app">
            <x-page.header>Transactions Error</x-page.header>
             <!-- Search Section -->
             <form action="{{ route($transactions ? 'admin.uncalculatedTransactionsLessThanMonth.search' : 'admin.uncalculatedExtraTransactionsLessThanMonth.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-12">
                                            <label class=" mt-3 mb-sm-1"> Course Name: <span class="badge badge-primary">{{$offered_courses->count()}} Courses</span></label>
                                            <select class="form-control select2-show-search" id="course" name="course">
                                                <option value="0" selected disabled>select course</option>
                                                @foreach ($offered_courses as $course)
                                                    <option value="{{$course->coffid}}">
                                                        {{$course->acyname.'_'.$course->cname.'('.$course->lshort_name.')_'.$course->ttname}}
                                                        @if ($course->has_label)
                                                        {{$course->label}}
                                                        @endif
                                                    </option>
                                                @endforeach
                                            </select>
                                        </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">
                                    </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.uncalculatedTransactionsLessThanMonth') }}" class="w-100 {{$transactions ? 'active':''}}">Transactions</a></li>
                                    <li class="ms-0"><a href="{{ route('admin.uncalculatedExtraTransactionsLessThanMonth') }}" class="ms-3 me-2 w-100  {{$extra_transactions ? 'active':''}}" >Extra Transactions</a></li>
                                </ul>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            @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.exportUncalculatedTransactionsLessThanMonth')}}" method="get">
                                        <input type="hidden" value="{{request()->get('course')}}" name="course">
                                        <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">
                                        <thead>
                                            <tr>
                                                <th style="text-align: center;">id</th>
                                                <th style="text-align: center;">Student</th>
                                                <th style="text-align: center;">course name</th>
                                                <th style="text-align: center;">Course status</th>
                                                <th style="text-align: center;">Teaching Team</th>
                                                <th style="text-align: center;">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>Rate</th>
                                                <th style="text-align: center;">status</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @php
                                                $count=0;
                                            @endphp
                                            @forelse ($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>{{ $transaction->is_active ? 'Active':'inActive' }}</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>{{ $transaction->rate ? $transaction->rate : 0 }}</td>
                                                    <td class="">
                                                        <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">
                                        {{ $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
            @if ($extra_transactions)
            <div class="row">
                <div class="col-md-12 col-lg-12">
                    <div class="card">
                        <div class="card-header">
                            <h3 class="card-title">Extra Transactions List</h3>
                        </div>
                        <div class="card-body">
                            @if (count($extra_transactions) > 0)
                                @if ($extra_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.exportUncalculatedExtraTransactionsLessThanMonth')}}" method="get">
                                    <input type="hidden" value="{{request()->get('course')}}" name="course">
                                    <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">
                                    <thead>
                                        <tr>
                                            <th style="text-align: center;">id</th>
                                            <th style="text-align: center;">Student</th>
                                            <th style="text-align: center;">course name</th>
                                            <th style="text-align: center;">Course status</th>
                                            <th style="text-align: center;">Teacher</th>
                                            <th style="text-align: center;">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>Rate</th>
                                            <th style="text-align: center;">status</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @php
                                            $count=0;
                                        @endphp
                                        @forelse ($extra_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>{{ $transaction->is_active ? 'Active':'inActive' }}</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>{{ $transaction->rate ? $transaction->rate : 0 }}</td>
                                                <td class="">
                                                    <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">
                                    {{ $extra_transactions->appends(Request::except('page'))->render('inc.paginate') }}
                                </div>
                                <p class="mt-3">
                                    Displaying {{$extra_transactions->count()}} of {{ $extra_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').dataTable( {
		"drawCallback": function( settings ) {
		},
        "bPaginate": false,
        "searching": true,
        "ordering": true,
        "info": false,
	})
})

</script>

@endsection