@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 profile-1">
            <div class="col-md-12">
                <div class="">
                    <div class="ps-0 pb-5">
                        <div class="wideget-user-tab">
                            <div class="tab-menu-heading">
                                <div class="tabs-menu1">
                                    <ul class="nav">
                                        <li class="ms-0"><a href="{{ route('admin.accounting.eshra7ly.unCommittedPayroll') }}" class="ms-0 me-2 w-100 {{$uncommited_payroll ? 'active':''}}">Un-commited</a></li>
                                        <li><a href="{{ route('admin.accounting.eshra7ly.committedPayroll') }}" class="w-100 {{$commited_payroll ? 'active':''}}" id="posted_transactions">Commited</a></li>
                                    </ul>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                    {{-- Un Posted Transactions --}}
                    @if ($uncommited_payroll)
                    <!-- Search Section -->
                    <form action="{{ route('admin.accounting.eshra7ly.unCommittedPayroll.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-4">
                                                    <label class=" mt-3 mb-sm-1"> Session: </label>
                                                    <select class="form-control select2-show-search" id="session" name="session" required>
                                                        <option value="0" disabled selected>Select</option>
                                                        @foreach ($sessions as $session)
                                                            <option value="{{ $session->acysid }}">{{ $session->acyname}}</option>
                                                        @endforeach
                                                    </select>
                                                </div>

                                                <div class="col-md-6">
                                                    <label class=" mt-3 mb-sm-1"> Period: </label>
                                                    <select class="form-control select2-show-search" id="from" name="date">
                                                        <option value="0" disabled selected>Select</option>
                                                        @foreach ($dates as $item)
                                                       <option value="{{$item->from}}">{{'From ( '.$item->from. ' ) To ( ' . $item->to.' )'}}</option>
                                                       @endforeach
                                                    </select>
                                                </div>

                                                <div class="col-md-2 mt-6">
                                                    <input type="submit" id="submit" class="btn btn-primary br-te-7 br-be-7 "
                                                        value="View">
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </form>
                    <div class="tab-pane show fade">
                        <div class="card">
                            <div class="card-header">
                                <h3 class="card-title">Un Committed List</h3>
                            </div>
                            <div class="card-body">
                                {{-- Export btn --}}
                                @if (count($uncommited_payroll) > 0)
                                    <div class="mx-auto d-block">
                                        <form action="{{route('admin.accounting.eshra7ly.exportUnCommittedPayroll')}}" method="get">
                                            <input type="hidden" value="{{request()->get('date')}}" name="date">
                                            <input type="hidden" value="{{request()->get('session')}}" name="session">
                                            <button type="submit" class="btn btn-primary mx-auto d-block w-25" >Export</button>
                                        </form>
                                    </div>
                                @endif
                                <div class="table-responsive" id="uncommitted">
                                    <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;"></th> --}}
                                                <th style="text-align: center;">Course</th>
                                                <th style="text-align: center;">session</th>
                                                <th style="text-align: center;">teacher team</th>
                                                <th style="text-align: center;">Total amount</th>
                                                <th style="text-align: center;">Total discount</th>
                                                <th style="text-align: center;">Total amount due</th>
                                                <th style="text-align: center;">eshra7ly percentage</th>
                                                <th style="text-align: center;">eshra7ly amount</th>
                                                <th style="text-align: center;">teacher percentage</th>
                                                <th style="text-align: center;">teacher amount</th>
                                                <th style="text-align: center;">old refund</th>
                                                <th style="text-align: center;">
                                                    <i class="mdi mdi-information-outline leading-loose"
                                                    data-bs-toggle="tooltip" data-bs-placement="bottom" title=""
                                                    data-bs-original-title="(eshra7ly egp + teacher egp + old refund egp ) - amount due egp"></i>
                                                </th>
                                                <th style="text-align: center;">
                                                    <i class="mdi mdi-information-outline leading-loose"
                                                    data-bs-toggle="tooltip" data-bs-placement="bottom" title=""
                                                    data-bs-original-title="(eshra7ly aed + teacher aed + old refund aed ) - amount due aed"></i>
                                                </th>
                                                <th style="text-align: center;">from</th>
                                                <th style="text-align: center;">to</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @php
                                                $count=0
                                            @endphp
                                            @foreach ($uncommited_payroll as $payroll)
                                            @php
                                                // Function to calculate percentage
                                                $calculatePercentage=function($amount, $totalAmountDue, $oldRefund) {

                                                    if ($totalAmountDue == 0 && $oldRefund > 0) {
                                                        return 0;
                                                    } elseif ($totalAmountDue == 0) {
                                                        return round(($amount / 1) * 100, 2);
                                                    } elseif ($oldRefund > 0) {
                                                        return round(
                                                            $amount > 0 && ($totalAmountDue - $oldRefund) > 0
                                                                ? ($amount / ($totalAmountDue - $oldRefund)) * 100
                                                                : 0,
                                                            2
                                                        );

                                                    } else {
                                                        return round(($amount / $totalAmountDue) * 100, 2);
                                                    }
                                                }

                                            @endphp
                                            <tr class="text-center">
                                                <td>{{++$count}}</td>
                                                {{-- <td style="text-align: center;">
                                                    <a class="btn btn-outline-primary btn-sm" href="{{route('admin.accounting.eshra7ly.transactionsDetails',$payroll->taid)}}" target="_blank" >view details</a>
                                                </td> --}}
                                                 <td> {{$payroll->has_label ? ' ( '.$payroll->label.' ) ':''}}{{$payroll->cname . ' (' .$payroll->lshort_name .' )'}}</td>
                                                 <td>{{$payroll->acyname}}</td>
                                                <td>
                                                    {{$payroll->ttname}}
                                                </td>

                                                <td>
                                                    <p>{{$payroll->sum_total_amount}} EGP</p>
                                                    <span>{{$payroll->sum_total_amount_aed ?? 0}} AED</span>
                                                </td>
                                                <td>
                                                    <p>{{$payroll->sum_total_discount_value}} EGP</p>
                                                    <span>{{$payroll->sum_total_discount_value_aed ?? 0}} AED</span>
                                                </td>
                                                <td>
                                                    <p>{{$payroll->sum_total_amount_due}} EGP</p>
                                                    <span>{{$payroll->sum_total_amount_due_aed ?? 0}} AED</span>
                                                </td>
                                                <td>

                                                    <p>
                                                        {{ $calculatePercentage($payroll->sum_total_eshra7ly_amount, $payroll->sum_total_amount_due, $payroll->sum_old_refund) }}
                                                        % (EGP)
                                                    </p>
                                                    <span>
                                                        {{ $calculatePercentage($payroll->sum_total_eshra7ly_amount_aed, $payroll->sum_total_amount_due_aed, $payroll->sum_old_refund_aed) }}
                                                        % (AED)
                                                    </span>
                                                </td>
                                                <td>
                                                    <p>{{$payroll->sum_total_eshra7ly_amount}} EGP</p>
                                                    <span>{{$payroll->sum_total_eshra7ly_amount_aed ?? 0}} AED</span>
                                                </td>
                                                <td>

                                                    <p>
                                                        {{ $calculatePercentage($payroll->sum_total_teacher_amount, $payroll->sum_total_amount_due, $payroll->sum_old_refund) }}
                                                         % (EGP)
                                                    </p>
                                                    <span>
                                                        {{ $calculatePercentage($payroll->sum_total_teacher_amount_aed, $payroll->sum_total_amount_due_aed, $payroll->sum_old_refund_aed) }}
                                                        % (AED)
                                                    </span>
                                                </td>
                                                <td>
                                                    <p>{{$payroll->sum_total_teacher_amount}} EGP</p>
                                                    <span>{{$payroll->sum_total_teacher_amount_aed ?? 0}} AED</span>
                                                </td>
                                                <td>
                                                    <p>{{$payroll->sum_old_refund}} EGP</p>
                                                    <span>{{$payroll->sum_old_refund_aed ?? 0}} AED</span>
                                                </td>
                                                <td>
                                                    {{round(($payroll->sum_total_teacher_amount
                                                    + $payroll->sum_total_eshra7ly_amount
                                                    + $payroll->sum_old_refund)
                                                    - $payroll->sum_total_amount_due,2)}}
                                                </td>
                                                <td>
                                                    {{round(($payroll->sum_total_teacher_amount_aed
                                                    + $payroll->sum_total_eshra7ly_amount_aed
                                                    + $payroll->sum_old_refund_aed)
                                                    - $payroll->sum_total_amount_due_aed,2)}}
                                                </td>
                                                <td>{{$payroll->from}}</td>
                                                <td>{{$payroll->to}}</td>

                                            </tr>
                                            @endforeach
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                    @endif
                    {{--  commited Transactions --}}
                    @if ($commited_payroll)
                    <form action="{{ route('admin.accounting.eshra7ly.committedPayroll.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-4">
                                                    <label class=" mt-3 mb-sm-1"> Session: </label>
                                                    <select class="form-control select2-show-search" id="session" name="session" required>
                                                        <option value="0" disabled selected>Select</option>
                                                        @foreach ($sessions as $session)
                                                            <option value="{{ $session->acysid }}">{{ $session->acyname}}</option>
                                                        @endforeach
                                                    </select>
                                                </div>

                                                <div class="col-md-6">
                                                    <label class=" mt-3 mb-sm-1"> Period: </label>
                                                    <select class="form-control select2-show-search" id="from" name="date">
                                                        <option value="0" disabled selected>Select</option>
                                                        @foreach ($dates as $item)
                                                       <option value="{{$item->from}}">{{'From ( '.$item->from. ' ) To ( ' . $item->to.' )'}}</option>
                                                       @endforeach
                                                    </select>
                                                </div>

                                                <div class="col-md-2 mt-6">
                                                    <input type="submit" id="submit" class="btn btn-primary br-te-7 br-be-7 "
                                                        value="View">
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </form>
                    <div class="tab-pane show fade">
                        <div class="card">
                            <div class="card-header">
                                <h3 class="card-title">Committed List</h3>
                            </div>
                            <div class="card-body">
                                @if (count($commited_payroll) > 0)
                                    <div class="mx-auto d-block">
                                        <form action="{{route('admin.accounting.eshra7ly.exportCommittedPayroll')}}" method="get">
                                            <input type="hidden" value="{{request()->get('date')}}" name="date">
                                            <input type="hidden" value="{{request()->get('session')}}" name="session">
                                            <button type="submit" class="btn btn-primary mx-auto d-block" >Export Table</button>
                                        </form>
                                    </div>
                                @endif
                                <div class="table-responsive" id="committed">
                                    <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;"></th> --}}
                                                <th style="text-align: center;">Course</th>
                                                <th style="text-align: center;">session</th>
                                                <th style="text-align: center;">teacher team</th>
                                                <th style="text-align: center;">Total amount</th>
                                                <th style="text-align: center;">Total discount</th>
                                                <th style="text-align: center;">Total amount due</th>
                                                <th style="text-align: center;">eshra7ly percentage</th>
                                                <th style="text-align: center;">eshra7ly amount</th>
                                                <th style="text-align: center;">teacher percentage</th>
                                                <th style="text-align: center;">teacher amount</th>
                                                <th style="text-align: center;">old refund</th>
                                                <th style="text-align: center;">
                                                    <i class="mdi mdi-information-outline leading-loose"
                                                    data-bs-toggle="tooltip" data-bs-placement="bottom" title=""
                                                    data-bs-original-title="(eshra7ly egp + teacher egp + old refund egp ) - amount due egp"></i>
                                                </th>
                                                <th style="text-align: center;">
                                                    <i class="mdi mdi-information-outline leading-loose"
                                                    data-bs-toggle="tooltip" data-bs-placement="bottom" title=""
                                                    data-bs-original-title="(eshra7ly aed + teacher aed + old refund aed ) - amount due aed"></i>
                                                </th>
                                                <th style="text-align: center;">from</th>
                                                <th style="text-align: center;">to</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @php
                                                $count=0
                                            @endphp
                                            @foreach ($commited_payroll as $payroll)
                                            @php
                                                // Function to calculate percentage
                                                $calculatePercentage=function($amount, $totalAmountDue, $oldRefund) {

                                                    if ($totalAmountDue == 0 && $oldRefund > 0) {
                                                        return 0;
                                                    } elseif ($totalAmountDue == 0) {
                                                        return round(($amount / 1) * 100, 2);
                                                    } elseif ($oldRefund > 0) {
                                                        return round(
                                                            $amount > 0 && ($totalAmountDue - $oldRefund) > 0
                                                                ? ($amount / ($totalAmountDue - $oldRefund)) * 100
                                                                : 0,
                                                            2
                                                        );

                                                    } else {
                                                        return round(($amount / $totalAmountDue) * 100, 2);
                                                    }
                                                }

                                            @endphp
                                            <tr class="text-center">
                                            <td>{{++$count}}</td>
                                            {{-- <td style="text-align: center;">
                                                <a class="btn btn-outline-primary btn-sm" href="{{route('admin.accounting.eshra7ly.transactionsDetails',$payroll->taid)}}" target="_blank" >view details</a>
                                            </td> --}}
                                             <td> {{$payroll->has_label ? ' ( '.$payroll->label.' ) ':''}}{{$payroll->cname . ' (' .$payroll->lshort_name .' )'}}</td>
                                             <td>{{$payroll->acyname}}</td>
                                            <td>
                                                {{$payroll->ttname}}
                                            </td>
                                            <td>
                                                <p>{{$payroll->sum_total_amount}} EGP</p>
                                                <span>{{$payroll->sum_total_amount_aed ?? 0}} AED</span>
                                            </td>
                                            <td>
                                                <p>{{$payroll->sum_total_discount_value}} EGP</p>
                                                <span>{{$payroll->sum_total_discount_value_aed ?? 0}} AED</span>
                                            </td>
                                            <td>
                                                <p>{{$payroll->sum_total_amount_due}} EGP</p>
                                                <span>{{$payroll->sum_total_amount_due_aed ?? 0}} AED</span>
                                            </td>
                                            <td>

                                                <p>
                                                    {{ $calculatePercentage($payroll->sum_total_eshra7ly_amount, $payroll->sum_total_amount_due, $payroll->sum_old_refund) }}
                                                    % (EGP)
                                                </p>
                                                <span>
                                                    {{ $calculatePercentage($payroll->sum_total_eshra7ly_amount_aed, $payroll->sum_total_amount_due_aed, $payroll->sum_old_refund_aed) }}
                                                    % (AED)
                                                </span>

                                            </td>
                                            <td>
                                                <p>{{$payroll->sum_total_eshra7ly_amount}} EGP</p>
                                                <span>{{$payroll->sum_total_eshra7ly_amount_aed ?? 0}} AED</span>
                                            </td>
                                            <td>

                                                <p>
                                                    {{ $calculatePercentage($payroll->sum_total_teacher_amount, $payroll->sum_total_amount_due, $payroll->sum_old_refund) }}
                                                     % (EGP)
                                                </p>
                                                <span>
                                                    {{ $calculatePercentage($payroll->sum_total_teacher_amount_aed, $payroll->sum_total_amount_due_aed, $payroll->sum_old_refund_aed) }}
                                                    % (AED)
                                                </span>
                                            </td>
                                            <td>
                                                <p>{{$payroll->sum_total_teacher_amount}} EGP</p>
                                                <span>{{$payroll->sum_total_teacher_amount_aed ?? 0}} AED</span>
                                            </td>
                                            <td>
                                                <p>{{$payroll->sum_old_refund}} EGP</p>
                                                <span>{{$payroll->sum_old_refund_aed ?? 0}} AED</span>
                                            </td>
                                            <td>
                                                {{round(($payroll->sum_total_teacher_amount
                                                + $payroll->sum_total_eshra7ly_amount
                                                + $payroll->sum_old_refund)
                                                - $payroll->sum_total_amount_due,2)}}
                                            </td>
                                            <td>
                                                {{round(($payroll->sum_total_teacher_amount_aed
                                                + $payroll->sum_total_eshra7ly_amount_aed
                                                + $payroll->sum_old_refund_aed)
                                                - $payroll->sum_total_amount_due_aed,2)}}
                                            </td>
                                            <td>{{$payroll->from}}</td>
                                            <td>{{$payroll->to}}</td>

                                            </tr>
                                            @endforeach
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                    @endif

            </div>
        </div>
    </div>
</div>
@endsection