@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">
                        <p class="text-primary fw-bold">
                            Total amount= <span class="text-dark fw-semibold">{{$transactions->where('payment_currency',2)->sum('amount')}} EGP / {{$transactions->where('payment_currency',1)->sum('amount_aed')}} AED </span>
                        </p>
                        <p class="text-primary fw-bold">
                            Total discount= <span class="text-dark fw-semibold">{{$transactions->where('payment_currency',2)->sum('discount_amount')}} EGP / {{$transactions->where('payment_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('payment_currency',2)->sum('amount_due')}} EGP / {{$transactions->where('payment_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('payment_currency',2)->sum('teacher_amount')}} EGP / {{$transactions->where('payment_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('payment_currency',2)->sum('eshra7ly_amount')}} EGP / {{$transactions->where('payment_currency',1)->sum('eshra7ly_amount_aed')}} AED </span>
                        </p>
                        <div class="table-responsive">
                            <table
                                class="table table-striped table-bordered table-vcenter text-nowrap" id="transactions_table">
                                <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>paid_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->paid_date }}</td>
                                        <td>
                                            {{ $transaction->amount }} EGP
                                            <i class="mdi mdi-information-outline leading-loose" data-bs-html="true" data-bs-toggle="tooltip" data-bs-placement="top" title="
                                                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_aed }} AED
                                            <i class="mdi mdi-information-outline leading-loose" data-bs-html="true" data-bs-toggle="tooltip" data-bs-placement="top" title="
                                                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->payment_currency == 2 ? 'danger':'primary' }}">{{ $transaction->payment_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
                                        </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')
{{-- draw all data tables --}}
<script>
    $(document).ready(function(){
        $('#transactions_table').dataTable( {
            "drawCallback": function( settings ) {
            },
            "bPaginate": true,
            "searching": true,
            "ordering": true,
            "info": true,
        })
    })
</script>
@endsection