@extends('layouts.admin')

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

        @include('admin.errors.form-errors')

        <form action="{{ route('admin.summary.reports.daily.general.aed') }}" 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-6">
                                        <label class="mt-3 mb-sm-1"> from: </label>
                                        <div>
                                        <input type="date" class="form-control" name="date" id="from" required>
                                        </div>
                                    </div>
                                    <div class="col-md-6">
                                        <label class="mt-3 mb-sm-1"> Days Count: </label>
                                        <div>
                                            <select id="days_count" name="days_count" class="form-control select2-show-search"
                                            required>
                                          
                                            <option value="1" selected>1</option>
                                            <option value="2" >2</option>
                                            <option value="3" >3</option>
                                            <option value="4" >4</option>
                                            <option value="5" >5</option>
                                            <option value="6" >6</option>
                                            <option value="7" >7</option>
                                        </select>
                                        </div>
                                    </div>
                                </div>

                            </div>
                            <div class="mt-4">
                                <input type="submit" id="submit" class="btn btn-primary br-te-7 br-be-7 d-block mx-auto"
                                    value="Apply Filter">
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </form>

        <div class="card">
            <div class="card-header">
                <h3 class="card-title"></h3>
            </div>
            <div class="card-body">
                <div class="table-responsive">
                    <table
                        class="data-table-example table table-striped table-bordered table-vcenter text-nowrap" id ='report-table'>
                        <thead>
                            <tr>

                                <th style="text-align: center;">Date</th>
                                @foreach ($current_wallets as $wallet )
                                <th style="text-align: center;">{{$wallet->created_at->format('d-m-Y')}}</th>

                                @endforeach
                                
                              
                            </tr>
                        
                        </thead>
                        <tbody>
                        <tr>
                            <th style="text-align: center;" >Starting Balance</th>
                            @foreach ($current_wallets as $wallet )
                            <td style="text-align: center;">{{$wallet->amount_aed}} AED</td>

                            @endforeach
                        </tr>
                        <tr>
                            <th colspan="{{$current_wallets->count()+1}}" style="text-align: center;">Income</th>
                            
                        </tr>
                        <tr>
                            <th style="text-align: center;" >1-Recharge Transactions</th>
                            @foreach ($current_opay_transaction as $total )
                            <td style="text-align: center;">{{$total}} AED</td>

                            @endforeach
                        </tr>
                        <tr>
                            <th style="text-align: center;" >2-Refund Installment & Class</th>
                            @foreach ($current_refunded_installments_and_classes as $total )
                            <td style="text-align: center;">{{$total}} AED</td>

                            @endforeach
                        </tr>
                        <tr>
                            <th style="text-align: center;">3-Salfney</th>
                            @foreach ($current_salefny_recharge as $total )
                            <td style="text-align: center;">{{$total}} AED</td>

                            @endforeach
                        </tr>
                        <tr>
                            <th style="text-align: center;" >4-Manual Recharge</th>
                            @foreach ($current_manual_recharge as $total )
                            <td style="text-align: center;">{{$total}} AED</td>

                            @endforeach
                        </tr>
                        <tr>
                            <th style="text-align: center;" >5-Wallet Transfer To AED</th>
                            @foreach ($current_wallet_transfer_to_AED as $total )
                            <td style="text-align: center;">{{$total}} AED</td>

                            @endforeach
                        </tr>
                       
                        <tr>
                            <th colspan="{{$current_wallets->count()+1}}" style="text-align: center;">Outcome</th>
                            
                        </tr>
                        <tr>
                            <th style="text-align: center;" >1-Attendance Transaction</th>
                            @foreach ($current_attendance_transactions as $key=> $total )
                            <td style="text-align: center;"><label>{{$total}} AED</label>
                                @if ($current_attendance_transactions_deleted_or_refunded[$key] > 0)
                                <label class="text-danger">({{$total -$current_attendance_transactions_deleted_or_refunded[$key]}}) AED</label>
                                <a href = "{{route('admin.summary.reports.daily.attendance.details',['date'=> $current_wallets[$key]->created_at->format('Y-m-d')])}}" target="_blank">
                                <i class="mdi mdi-information-outline leading-loose"
                                                data-bs-toggle="tooltip" data-bs-placement="bottom" title=""
                                                data-bs-original-title="This amount has been updated due to refund or deleted transactions"></i>
                                </a>
                                @endif
                            </td>

                            @endforeach
                        </tr>
                        <tr>
                            <th style="text-align: center;" >2-Intsallment Transaction</th>
                            @foreach ($current_installment_transactions as $key =>$total )
                            <td style="text-align: center;">
                                <label> {{$total}} AED</label>
                               @if ($current_installment_transactions_deleted_or_refunded[$key] > 0)
                            <label class="text-danger">({{$total - $current_installment_transactions_deleted_or_refunded[$key]}}) AED</label>
                          
                          <a href = "{{route('admin.summary.reports.daily.installments.details',['date'=> $current_wallets[$key]->created_at->format('Y-m-d')])}}"  target="_blank"> <i class="mdi mdi-information-outline leading-loose"
                           data-bs-toggle="tooltip" data-bs-placement="bottom" title=""
                           data-bs-original-title="This amount has been updated due to refund or deleted transactions"></i>
                          </a>
                           @endif

                            @endforeach
                        </tr>
                        
                        <tr>
                            <th style="text-align: center;" >3-Refund Visa</th>
                            @foreach ($current_refund_visa as $total )
                            <td style="text-align: center;">{{$total}} AED</td>

                            @endforeach
                        </tr>
                       
                                    
                        <tr>
                            <th style="text-align: center;" >4-Withdraw Salfney</th>
                            @foreach ($current_withdrawn_salefny_recharge as $total )
                            <td style="text-align: center;">{{$total}} AED</td>

                            @endforeach
                        </tr>
                        <tr>
                            <th style="text-align: center;" >5-Wallet Transfer to EGP</th>
                            @foreach ($current_wallet_transfer_to_EGP as $total )
                            <td style="text-align: center;">{{$total}} AED</td>

                            @endforeach
                        </tr>
                        <tr>
                            <th style="text-align: center;" >Ending Balance</th>
                            @foreach ($ending_balance as $total )
                            <td style="text-align: center;">{{$total,2}} AED</td>

                            @endforeach
                        </tr>

                        <tr>
                            <th style="text-align: center;" >Website Calculated Amount</th>
                            @foreach ($current_wallets as $key => $total )
                            <td style="text-align: center;">
                                @if($key == $current_wallets->count()-1)
                                     @if ($current_wallets_for_progress->count() == $current_wallets->count())
                                        @if ($next_day_website_calculated != null)
                                            {{$next_day_website_calculated->amount_aed}} AED
                                        @else
                                        In Progress...
                                        @endif   
                              
                                         @else
                                         {{($current_wallets_for_progress[$key+1])->amount_aed}} AED
                                     
                                     @endif
                                @else
                                {{($current_wallets[$key+1])->amount_aed}} AED
                                @endif
                            </td>

                            @endforeach
                        </tr>
                        <tr>
                            <th style="text-align: center;" >Result</th>
                            @foreach ($current_wallets as $key => $total )
                            <td style="text-align: center;">
                                @if($key == $current_wallets->count()-1)
                                    @if ($current_wallets_for_progress->count() == $current_wallets->count())
                                            @if ($next_day_website_calculated != null)

                                            @if(  (($ending_balance[$key]) -  $next_day_website_calculated->amount_aed) > -1 && (($ending_balance[$key]) -  $next_day_website_calculated->amount_aed) < 1 && (($ending_balance[$key]) -  $next_day_website_calculated->amount_aed) != 0 )
                                            {{'0 AED (R)'}}
                                           @else
                                           {{($ending_balance[$key]) -  $next_day_website_calculated->amount_aed}} AED
                                           @endif
                                           
                                            @else
                                                In Progress...
                                            @endif 
                                        @else

                                        @if ((($ending_balance[$key]) -  ($current_wallets_for_progress[$key+1])->amount_aed) > -1 && (($ending_balance[$key]) -  ($current_wallets_for_progress[$key+1])->amount_aed) < 1 && (($ending_balance[$key]) -  ($current_wallets_for_progress[$key+1])->amount_aed) != 0)
                                        {{'0 AED (R)'}}
                                        @else
                                        {{($ending_balance[$key]) -  ($current_wallets_for_progress[$key+1])->amount_aed}}
                                        @endif
                                        
                                     
                                    @endif
                                @else
                                    @if(  (($ending_balance[$key]) -  ($current_wallets[$key+1])->amount_aed) > -1 && (($ending_balance[$key]) -  ($current_wallets[$key+1])->amount_aed) < 1 && (($ending_balance[$key]) -  ($current_wallets[$key+1])->amount_aed) != 0 )
                                     {{'0 AED (R)'}}
                                    @else
                                    {{($ending_balance[$key]) -  ($current_wallets[$key+1])->amount_aed}} AED
                                    @endif
                                @endif
                            </td>

                            @endforeach
                        </tr>

                        </tbody>
                    </table>
                </div>

            </div>
        </div>

    
    </div>
</div>
@endsection
@section('admin-js')
<script>

</script>
@endsection