@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>

         <!-- Search Section -->
         {{-- <form action="{{ route('admin.accounting.calculateTransactions') }}" method="post">
            @csrf
            <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-3">
                                        <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->sessions->sname .' '.$session->year}}</option>
                                            @endforeach
                                        </select>
                                    </div>

                                    <div class="col-md-3">
                                        <label class=" mt-3 mb-sm-1"> Course: </label>
                                        <select class="form-control select2-show-search" id="course" name="course" required>
                                        </select>
                                    </div>
                                    <div class="col-md-3">
                                        <div class="">
                                            <label class="mt-3 mb-sm-1"> from: </label>
                                            <div>
                                            <input type="date" class="form-control" name="from" id="from" required>
                                            </div>
                                        </div>
                                        <div class="">
                                            <label class="mt-3 mb-sm-1"> to: </label>
                                            <div>
                                            <input type="date" class="form-control" name="to" id="to" required>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-md-2 mt-6">
                                        <input type="submit" id="submit" class="btn btn-primary br-te-7 br-be-7 "
                                            value="Calculate">
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </form> --}}
        <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.index') }}" class="ms-0 me-2 w-100 {{$unposted_transactions ? 'active':''}}">Un-Posted</a></li>
                                        <li><a href="{{ route('admin.accounting.postedTransactions') }}" class="w-100 {{$posted_transactions ? 'active':''}}" id="posted_transactions">Posted</a></li>
                                    </ul>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                    {{-- Un Posted Transactions --}}
                    @if ($unposted_transactions)
                    <!-- Search Section -->
                    <form action="{{ route('admin.accounting.index.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-5">
                                                    <label class=" mt-3 mb-sm-1"> Course: </label>
                                                    <select class="form-control select2-show-search" id="course" name="course">
                                                    </select>
                                                </div>
                                                <div class="col-md-3">
                                                    <div class="">
                                                        <label class="mt-3 mb-sm-1"> from: </label>
                                                        <div>
                                                        <input type="date" class="form-control" name="from" id="from" >
                                                        </div>
                                                    </div>
                                                    <div class="">
                                                        <label class="mt-3 mb-sm-1"> to: </label>
                                                        <div>
                                                        <input type="date" class="form-control" name="to" id="to">
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                            <div class="mt-6">
                                                <input type="submit" id="submit" class="btn btn-primary br-te-7 br-be-7 mx-auto d-block "
                                                    value="View">
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </form>
                    <div class="tab-pane show fade" id="tab-unposted">
                        <div class="card">
                            <div class="card-header">
                                <h3 class="card-title">Un Posted Transactions List</h3>
                            </div>
                            <div class="card-body">
                                {{-- Export btn --}}
                                @if (count($unposted_transactions) > 0)
                                <div class="row">
                                    <div class="col-md-6">
                                        <form action="{{route('admin.accounting.exportUnPostedTransactions')}}" method="get">
                                            <input type="hidden" value="{{request()->get('course')}}" name="course">
                                            <input type="hidden" value="{{request()->get('from')}}" name="from">
                                            <input type="hidden" value="{{request()->get('to')}}" name="to">
                                            <button type="submit" class="btn btn-primary mx-auto d-block w-25" >Export</button>
                                        </form>
                                    </div>
                                    {{-- Post all--}}
                                    <div class="col-md-6">
                                       <a href="javascript:void(0)" onClick="confirmPostAll(event)" class="btn btn-outline-success mb-6 waves-effect waves-light"
                                           data-bs-toggle="tooltip" data-bs-original-title="Post all">
                                           Post All
                                           <i class="fa fa-plus fs-10"></i>
                                           <form method="POST" action="{{route('admin.accounting.postAllTransactions')}}" id="post-all-form">
                                               @csrf
                                               <input name="_method" type="hidden" value="POST">
                                           </form>
                                       </a>
                                   </div>
                                </div>
                                @endif
                                <div class="table-responsive" id="unposted">
                                    <table
                                        class="data-table-example table table-striped table-bordered table-vcenter text-nowrap">
                                        <thead>
                                            <tr>

                                                <th style="text-align: center;">Id</th>
                                                <th></th>
                                                <th></th>
                                                <th>details</th>
                                                <th style="text-align: center;">Course</th>
                                                <th style="text-align: center;">Group</th>
                                                <th style="text-align: center;">Total amount EGP</th>
                                                <th style="text-align: center;">Discount amount EGP</th>
                                                <th style="text-align: center;">Total amount due EGP</th>
                                                <th style="text-align: center;">Teacher amount EGP</th>
                                                <th style="text-align: center;">Eshra7ly amount EGP</th>
                                                <th style="text-align: center;">Total amount AED</th>
                                                <th style="text-align: center;">Discount amount AED</th>
                                                <th style="text-align: center;">Total amount due AED</th>
                                                <th style="text-align: center;">Teacher amount AED</th>
                                                <th style="text-align: center;">Eshra7ly amount AED</th>
                                                <th style="text-align: center;">Tax</th>
                                                <th style="text-align: center;">old refund EGP</th>
                                                <th style="text-align: center;">old refund AED</th>
                                                <th style="text-align: center;">net salary EGP</th>
                                                <th style="text-align: center;">net salary AED</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 ($unposted_transactions as $transaction)
                                            <tr class="text-center">
                                            <td>{{++$count}}</td>
                                            <td>
                                                {{-- Post --}}
                                                <div>
                                                    <a href="javascript:void(0)" onClick="confirmPost(event,{{$transaction->totalid}})" class="btn btn-outline-success  btn-sm waves-effect waves-light"
                                                        data-bs-toggle="tooltip" data-bs-original-title="Post">
                                                        Post
                                                        <i class="fa fa-plus fs-10"></i>
                                                        <form method="POST" action="{{ route('admin.accounting.postTransactions',$transaction->totalid) }}" id="post-form-{{$transaction->totalid}}">
                                                            @csrf
                                                            <input name="_method" type="hidden" value="POST">
                                                        </form>
                                                    </a>
                                                </div>

                                            </td>
                                            <td>
                                                <div>
                                                    {{-- Cancel calculation --}}
                                                    <a href="javascript:void(0)" onClick="cancelCalculation(event,{{$transaction->totalid}})" class="btn btn-outline-danger  btn-sm waves-effect waves-light"
                                                        data-bs-toggle="tooltip" data-bs-original-title="Cancel">
                                                        Cancel
                                                        <i class="fa fa-times-rectangle-o fs-10"></i>

                                                        <form method="POST" action="{{ route('admin.accounting.cancelCalculation',$transaction->totalid) }}" id="cancel-form-{{$transaction->totalid}}">
                                                            @csrf
                                                            <input name="_method" type="hidden" value="DELETE">

                                                        </form>
                                                    </a>
                                                </div>
                                            </td>
                                            <td>
                                                <a target="_blank" class="btn btn-outline-primary btn-sm" href='{{route('admin.accounting.transactionsDetails',[$transaction->totalid,$transaction->coffid,$transaction->gid])}}'>View Details</a>
                                                @if ($transaction->old_refund)
                                                <br>
                                                <span class="badge badge-danger mt-2">Has old Refund</span>
                                                  {{-- <a target="_blank" href='{{route('admin.accounting.viewOldRefund',[$transaction->coffid,$transaction->tblid])}}'>View Old Refund</a> --}}
                                                @endif
                                            </td>
                                            <td>
                                                {{$transaction->has_label ? ' ( '.$transaction->label.' ) ':''}} {{$transaction->cname . ' (' .$transaction->lshort_name .' )'}}
                                                _{{$transaction->ttname}}
                                            </td>
                                            <td>{{$transaction->gname}}</td>
                                            <td>{{$transaction->total_amount}} EGP</td>
                                            <td>{{$transaction->total_discount_value}} EGP</td>
                                            <td>{{$transaction->total_amount_due}} EGP</td>
                                            <td>{{$transaction->total_teacher_amount}} EGP</td>
                                            <td>{{$transaction->total_eshra7ly_amount}} EGP</td>
                                            <td>{{$transaction->total_amount_aed}} AED</td>
                                            <td>{{$transaction->total_discount_value_aed}} AED</td>
                                            <td>{{$transaction->total_amount_due_aed}} AED</td>
                                            <td>{{$transaction->total_teacher_amount_aed}} AED</td>
                                            <td>{{$transaction->total_eshra7ly_amount_aed}} AED</td>
                                            <td>{{$transaction->tax_value}} %</td>
                                            <td>{{$transaction->old_refund}} EGP</td>
                                            <td>{{$transaction->old_refund_aed}} AED</td>
                                            <td>{{$transaction->net_salary}} EGP</td>
                                            <td>{{$transaction->net_salary_aed}} AED</td>
                                            <td>
                                                {{round(($transaction->total_teacher_amount
                                                    + $transaction->total_eshra7ly_amount
                                                    + $transaction->old_refund)
                                                    - $transaction->total_amount_due,2)}}
                                            </td>
                                            <td>
                                                {{round(($transaction->total_teacher_amount_aed
                                                    + $transaction->total_eshra7ly_amount_aed
                                                    + $transaction->old_refund_aed)
                                                    - $transaction->total_amount_due_aed,2)}}
                                            </td>
                                            <td>{{$transaction->from}}</td>
                                            <td>{{$transaction->to}}</td>
                                            </tr>
                                            @endforeach
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                    @endif
                    {{--  Posted Transactions --}}
                    @if ($posted_transactions)
                    <!-- Search Section -->
                    <form action="{{ route('admin.accounting.postedTransactions.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_posted" 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-5">
                                                    <label class=" mt-3 mb-sm-1"> Course: </label>
                                                    <select class="form-control select2-show-search" id="course" name="course">
                                                    </select>
                                                </div>
                                                <div class="col-md-3">
                                                    <div class="">
                                                        <label class="mt-3 mb-sm-1"> from: </label>
                                                        <div>
                                                        <input type="date" class="form-control" name="from" id="from" >
                                                        </div>
                                                    </div>
                                                    <div class="">
                                                        <label class="mt-3 mb-sm-1"> to: </label>
                                                        <div>
                                                        <input type="date" class="form-control" name="to" id="to">
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                            <div class=" mt-6">
                                                <input type="submit" id="submit" class="btn btn-primary br-te-7 br-be-7 mx-auto d-block"
                                                    value="View">
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </form>
                    <div class="tab-pane show fade" id="tab-posted">
                        <div class="card">
                            <div class="card-header">
                                <h3 class="card-title">Posted Transactions List</h3>
                            </div>
                            <div class="card-body">
                                @if (count($posted_transactions) > 0)
                                <div class="row mb-6">
                                    <div class="col-md-6">
                                        <form action="{{route('admin.accounting.exportPostedTransactions')}}" method="get">
                                            <input type="hidden" value="{{request()->get('course')}}" name="course">
                                            <input type="hidden" value="{{request()->get('from')}}" name="from">
                                            <input type="hidden" value="{{request()->get('to')}}" name="to">
                                            <button type="submit" class="btn btn-outline-success mx-auto d-block w-25" >Export</button>
                                        </form>
                                    </div>
                                    <div class="col-md-6">
                                        <a href="{{route('admin.accounting.unCommittedPayroll')}}" class="btn btn-outline-primary mx-auto d-block w-25" data-bs-toggle="tooltip" title="Go to next step" data-bs-original-title="Go to next step">
                                            Next Step
                                            <i class="fa fa-arrow-right"  aria-label="fa fa-arrow-right"></i>
                                        </a>
                                    </div>
                                </div>
                                @endif
                                <div class="table-responsive">
                                    <table
                                        class="data-table-example table table-striped table-bordered table-vcenter text-nowrap" id="posted">
                                        <thead>
                                            <tr>
                                                <th style="text-align: center;">Id</th>
                                                <th></th>
                                                <th>details</th>
                                                <th>Posted by</th>
                                                <th style="text-align: center;">Course</th>
                                                <th style="text-align: center;">Group</th>

                                                <th style="text-align: center;">Total amount EGP</th>
                                                <th style="text-align: center;">Discount amount EGP</th>
                                                <th style="text-align: center;">Total amount due EGP</th>
                                                <th style="text-align: center;">Teacher amount EGP</th>
                                                <th style="text-align: center;">Eshra7ly amount EGP</th>
                                                <th style="text-align: center;">Total amount AED</th>
                                                <th style="text-align: center;">Discount amount AED</th>
                                                <th style="text-align: center;">Total amount due AED</th>
                                                <th style="text-align: center;">Teacher amount AED</th>
                                                <th style="text-align: center;">Eshra7ly amount AED</th>
                                                <th style="text-align: center;">Tax</th>
                                                <th style="text-align: center;">old refund EGP</th>
                                                <th style="text-align: center;">old refund AED</th>
                                                <th style="text-align: center;">net salary EGP</th>
                                                <th style="text-align: center;">net salary AED</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 ($posted_transactions as $transaction)
                                            <tr class="text-center">
                                            <td>{{++$count}}</td>
                                            <td>
                                                <div>
                                                    <a href="javascript:void(0)" onClick="cancelPost(event,{{$transaction->totalid}})" class="btn btn-outline-danger  btn-sm waves-effect waves-light"
                                                        data-bs-toggle="tooltip" data-bs-original-title="Cancel">
                                                        Cancel
                                                        <i class="fa fa-times-rectangle-o fs-10"></i>
                                                        <form method="POST" action="{{ route('admin.accounting.cancelPost',$transaction->totalid) }}" id="cancel-post-form-{{$transaction->totalid}}">
                                                            @csrf
                                                            <input name="Cancel Post" type="hidden" value="">
                                                        </form>
                                                    </a>
                                                </div>
                                            </td>
                                            <td>
                                                <a target="_blank" class="btn btn-outline-primary btn-sm" href='{{route('admin.accounting.transactionsDetails',[$transaction->totalid,$transaction->coffid,$transaction->gid])}}'>View Details</a>
                                                @if ($transaction->old_refund)
                                                  <br>
                                                  <span class="badge badge-danger mt-2">Has old Refund</span>
                                                  {{-- <a target="_blank" href='{{route('admin.accounting.viewOldRefund',[$transaction->coffid,$transaction->tblid])}}'>View Old Refund</a> --}}
                                                @endif
                                            </td>
                                            <td>
                                                {{$transaction->posted_by_fname.' '.$transaction->posted_by_lname}}
                                            </td>
                                            <td>
                                                {{$transaction->has_label ? ' ( '.$transaction->label.' ) ':''}}  {{$transaction->acyname.'_'.$transaction->cname . ' (' .$transaction->lshort_name .' )'}}
                                                _{{$transaction->ttname}}
                                            </td>
                                            <td>{{$transaction->gname}}</td>
                                            <td>{{$transaction->total_amount}} EGP</td>
                                            <td>{{$transaction->total_discount_value}} EGP</td>
                                            <td>{{$transaction->total_amount_due}} EGP</td>
                                            <td>{{$transaction->total_teacher_amount}} EGP</td>
                                            <td>{{$transaction->total_eshra7ly_amount}} EGP</td>
                                            <td>{{$transaction->total_amount_aed}} AED</td>
                                            <td>{{$transaction->total_discount_value_aed}} AED</td>
                                            <td>{{$transaction->total_amount_due_aed}} AED</td>
                                            <td>{{$transaction->total_teacher_amount_aed}} AED</td>
                                            <td>{{$transaction->total_eshra7ly_amount_aed}} AED</td>
                                            <td>{{$transaction->tax_value}} %</td>
                                            <td>{{$transaction->old_refund}} EGP</td>
                                            <td>{{$transaction->old_refund_aed}} AED</td>
                                            <td>{{$transaction->net_salary}} EGP</td>
                                            <td>{{$transaction->net_salary_aed}} AED</td>
                                            <td>
                                                {{round(($transaction->total_teacher_amount
                                                    + $transaction->total_eshra7ly_amount
                                                    + $transaction->old_refund)
                                                    - $transaction->total_amount_due,2)}}
                                            </td>
                                            <td>
                                                {{round(($transaction->total_teacher_amount_aed
                                                    + $transaction->total_eshra7ly_amount_aed
                                                    + $transaction->old_refund_aed)
                                                    - $transaction->total_amount_due_aed,2)}}
                                            </td>
                                            <td>{{$transaction->from}}</td>
                                            <td>{{$transaction->to}}</td>
                                            </tr>
                                            @endforeach
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                    @endif

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

<script>
    // Post
	function confirmPost(e, id){ //on add input button click
        e.preventDefault();
        Swal.fire({
                title: "Are you sure?",
                icon: "warning",
                showCancelButton: true,
                confirmButtonText: "Yes, Confirm The Post Operation!"
            }).then(function(result) {
                if (result.value) {
                    document.getElementById(`post-form-${id}`).submit();
                }
            });
    }

    // Post all
	function confirmPostAll(e){ //on add input button click
        e.preventDefault();
        Swal.fire({
                title: "Are you sure?",
                icon: "warning",
                showCancelButton: true,
                confirmButtonText: "Yes, Confirm The Post Operation!"
            }).then(function(result) {
                if (result.value) {
                    document.getElementById(`post-all-form`).submit();
                }
            });
    }

    // Cancel calc
    function cancelCalculation(e, id){ //on add input button click
        e.preventDefault();
        Swal.fire({
                title: "Are you sure?",
                icon: "warning",
                showCancelButton: true,
                confirmButtonText: "Yes, Confirm!"
            }).then(function(result) {
                if (result.value) {
                    document.getElementById(`cancel-form-${id}`).submit();
                }
            });
    }

    // Cancel Post
    function cancelPost(e, id){ //on add input button click
        e.preventDefault();
        Swal.fire({
                title: "Are you sure?",
                icon: "warning",
                showCancelButton: true,
                confirmButtonText: "Yes, Confirm!"
            }).then(function(result) {
                if (result.value) {
                    document.getElementById(`cancel-post-form-${id}`).submit();
                }
            });
    }
</script>
<script>
    // offered courses and level dependent select
    $('#session').on('change', function() {
            var $course = $('#course');
            $('#course').empty();
            $('#course').append(`<option value="0" disabled selected>Processing...</option>`);
            $.ajax({
                url: "{{ route('sessionFilterForUnPostedCourses') }}",
                type: 'GET',
                data: {
                    acysid: $(this).val()
                },
                success: function(data) {
                    $('#course').empty();
                    $('#course').append(
                        `<option value="0" disabled selected>Select Course*</option>`);
                    $.each(data, function(id, value) {
                        value.teaching_team.coaching_teachers.map((teacher)=>{
                            $course.append('<option value="' + value.coffid + '">' +
                            (value.has_label ? '( '+value.label+' ) ' : '') +  value.course.cname + ' ( '+ value.course.level.lshort_name+' ) '
                            +'_ '+ teacher.first_name+' '+ teacher.middle_name+' '+ teacher.last_name
                            +'</option>');
                        })
                    });
                }
            });
        });

         // offered courses and level dependent select  for posted transactions
    $('#session_posted').on('change', function() {
            var $course = $('#course');
            $('#course').empty();
            $('#course').append(`<option value="0" disabled selected>Processing...</option>`);
            $.ajax({
                url: "{{ route('sessionFilterForPostedCourses') }}",
                type: 'GET',
                data: {
                    acysid: $(this).val()
                },
                success: function(data) {
                    $('#course').empty();
                    $('#course').append(
                        `<option value="0" disabled selected>Select Course*</option>`);
                    $.each(data, function(id, value) {
                        value.teaching_team.coaching_teachers.map((teacher)=>{
                            $course.append('<option value="' + value.coffid + '">' +
                            value.course.cname + ' ( '+ value.course.level.lshort_name+' ) '
                            +'_ '+ teacher.first_name+' '+ teacher.middle_name+' '+ teacher.last_name
                            +'</option>');
                        })
                    });
                }
            });
        });
</script>
@endsection