@extends('layouts.admin')
@section('content')
<!--App-Content-->
<div class="app-content my-3 my-md-5">
    <div class="side-app">
        <x-page.header>Total Salfny</x-page.header>
        <div class="row">
            <div class="col-md-12">
                <div class="card">
                    <div class="card-header">
                        <h3 class="card-title">Salfny List</h3>
                    </div>
                    <div class="card-body">
                        @if (count($total_salfny) > 0)
                        <form action="{{route('admin.summary.exportTotalSalfny')}}" method="get">
                            <input type="hidden" value="{{request()->get('date')}}" name="date">
                            <button type="submit" class=" mb-2 btn btn-sm btn-outline-success mx-auto d-block w-25 shadow-md">
                                Export
                                <i class="fa fa-file-excel-o  ms-2 fs-14"></i>
                            </button>
                        </form>
                        <p class="font-weight-bold">Total Salfny (EGP): <span class="text-danger">{{$total_salfny->sum('total')}}</span> <span class="text-success">EGP</span></p>
                        <p class="font-weight-bold">Total Salfny (AED): <span class="text-primary">{{$total_salfny->sum('total_aed')}}</span> <span class="text-success">AED</span></p>
                        @endif
                        <div class="table-responsive">
                            <table
                                class="data-table-example table table-striped table-bordered table-vcenter text-nowrap">
                                <thead>
                                    <tr>
                                        <th style="text-align: center;">Id</th>
                                        <th style="text-align: center;">Student Name</th>
                                        <th style="text-align: center;">Amount EGP</th>
                                        <th style="text-align: center;">Amount AED</th>
                                        <th style="text-align: center;">Created at</th>
                                        <th style="text-align: center;">Updated at</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @php
                                    $count=0
                                    @endphp
                                    @foreach ($total_salfny as $item)
                                        <tr class="text-center">
                                            <td>{{++$count}}</td>
                                            <td>
                                                <a href="{{route('admin.students.show',$item->user->id)}}" target="_blank">
                                                    {{$item->user->first_name.' '.$item->user->middle_name.' '.$item->user->last_name}}
                                                    <i class="mdi mdi-information-outline leading-loose" data-bs-html="true" data-bs-toggle="tooltip" data-bs-placement="top" title="
                                                    Phone: {{ $item->user->phone}} <br> Email: {{ $item->user->email}} "
                                                    ></i>
                                                </a>
                                            </td>
                                            <td>{{$item->total}}</td>
                                            <td>{{$item->total_aed}}</td>
                                            <td>
                                                <i class="fa fa-calendar"></i>
                                                {{ date('Y-m-d', strtotime($item->created_at)) . ' / '}}
                                                <i class="fa fa-clock-o"></i>
                                                {{date('h:i A', strtotime($item->created_at))}}
                                            </td>
                                            <td>
                                                <i class="fa fa-calendar"></i>
                                                {{ date('Y-m-d', strtotime($item->updated_at)) . ' / '}}
                                                <i class="fa fa-clock-o"></i>
                                                {{date('h:i A', strtotime($item->updated_at))}}
                                            </td>
                                        </tr>
                                    @endforeach
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection