@extends('layouts.admin')

@section('content')
<!--App-Content-->
<div class="app-content my-3 my-md-5">
    <div class="side-app">
        <x-page.header>Total Transactions</x-page.header>

        <div class="row">
            <div class="col-md-12">

                <div class="card">
                    <div class="card-header">
                        <h3 class="card-title">Transactions List</h3>
                    </div>
                    <div class="card-body">
                        <tr class="text-center">
                            <p class="text-primary fw-bold">
                                Total amount= <span class="text-dark fw-semibold">{{$transactions->where('currency',2)->sum('amount')}} EGP / {{$transactions->where('currency',1)->sum('amount_aed')}} AED </span>
                            </p>
                            <p class="text-primary fw-bold">
                                Total discount= <span class="text-dark fw-semibold">{{$transactions->where('currency',2)->sum('discount_amount')}} EGP / {{$transactions->where('currency',1)->sum('discount_amount_aed')}} AED </span>
                            </p>
                            <p class="text-primary fw-bold">
                                Total amount due= <span class="text-dark fw-semibold">{{$transactions->where('currency',2)->sum('amount_due')}} EGP / {{$transactions->where('currency',1)->sum('amount_due_aed')}} AED </span>
                            </p>
                            <p class="text-primary fw-bold">
                                Teacher amount= <span class="text-dark fw-semibold">{{$transactions->where('currency',2)->sum('teacher_amount')}} EGP / {{$transactions->where('currency',1)->sum('teacher_amount_aed')}} AED </span>
                            </p>
                            <p class="text-primary fw-bold">
                                Eshra7ly amount= <span class="text-dark fw-semibold">{{$transactions->where('currency',2)->sum('eshra7ly_amount')}} EGP / {{$transactions->where('currency',1)->sum('eshra7ly_amount_aed')}} AED </span>
                            </p>
                        </tr>
                        <div class="table-responsive">
                            <table
                                class="table table-striped table-bordered 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;">Teacher</th>
                                        <th>date</th>
                                        <th style="text-align: center;">amount EGP</th>
                                        <th style="text-align: center;">amount AED</th>
                                        <th style="text-align: center;">currency</th>
                                        <th style="text-align: center;">rate</th>
                                        <th style="text-align: center;">status</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @php
                                    $count=0;
                                   @endphp
                                    @foreach ($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->ttname }}
                                                </td>
                                                <td>{{ $transaction->created_at->format('d-m-Y') }}</td>
                                                <td>
                                                    {{ $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>
                                                    {{ $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 ?? 0 }}</td>
                                                <td class="">
                                                    @if ($transaction->is_refunded == 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 }} at {{$transaction->updated_at->format('Y-m-d')}} <br>
                                                         Refunded by : {{$transaction->refunded_by_fname . ' ' .$transaction->refunded_by_lname}}"
                                                        data-bs-original-title=""></i>
                                                      @else
                                                      <span class="badge badge-success">
                                                        Paid
                                                       </span>
                                                    @endif
                                                    @if ($transaction->is_posted == 1)
                                                      <span class="badge badge-success">
                                                        Posted
                                                       </span>

                                                      @else
                                                      <span class="badge badge-danger">
                                                        Un-Posted
                                                       </span>
                                                    @endif
                                                    @if ($transaction->is_extra == 1)
                                                      <span class="badge badge-primary">
                                                        Extra Meeting
                                                       </span>
                                                    @endif
                                                </td>

                                            </tr>
                                    @endforeach
                                </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>
@endsection
@section('admin-js')
<script>
    $(document).ready(function(){
        $('#transactions').dataTable( {
            "drawCallback": function( settings ) {
            },
            "bPaginate": true,
            "searching": true,
            "ordering": true,
            "info": true,
        })
    })
</script>
    @endsection