@extends('layouts.admin')

@section('content')
<!--App-Content-->
<div class="app-content my-3 my-md-5">
    <div class="side-app">
        <x-page.header>Calculate Transactions</x-page.header>
        {{-- <a class="btn btn-primary" href="{{ route('admin.callCalculateJob') }}">callCalculateJob</a> --}}
        @include('admin.errors.form-errors')
        <div class="card">
            <div class="card-status card-status-left bg-red br-bs-7 br-ts-7"></div>
            <div class="card-header">
                <h3 class="card-title">Last Calculation date</h3>
            </div>
            <div class="card-body">
                <div class="row">
                    <div class="col-sm-6 col-md-6 col-lg-6 col-xl-6 ">
                        <div class="card">
                            <div class="card-body text-center">
                                <div class="counter-status dash3-counter d-flex">
                                    <div class="counter-icon bg-primary-dark my-auto br-100">
                                        <i class="mdi mdi-calendar leading-loose"></i>
                                    </div>
                                    <div class="ms-auto thumbnail px-5 mt-3">
                                        <h3 class="mb-5 badge badge-success">From</h3>
                                        <h3 class="mb-0">{{$last_calc_date->from}}</h3>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-sm-6 col-md-6 col-lg-6 col-xl-6 ">
                        <div class="card">
                            <div class="card-body text-center">
                                <div class="counter-status dash3-counter d-flex">
                                    <div class="counter-icon bg-primary-dark my-auto br-100">
                                        <i class="mdi mdi-calendar leading-loose"></i>
                                    </div>
                                    <div class="ms-auto thumbnail px-5 mt-3">
                                        <h3 class="mb-5 badge badge-danger">To</h3>
                                        <h3 class="mb-0">{{$last_calc_date->to}}</h3>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
         <!-- 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-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-4">
                                        <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-2">
                                        <label class=" mt-3 mb-sm-1"> Group: </label>
                                        <select class="form-control select2-show-search" id="group" name="group" required>
                                        </select>
                                    </div>
                                    <div class="col-md-2">
                                        <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>
                                <div class=" mt-6">
                                    <input type="submit" id="submit" class="btn btn-primary mx-auto d-block br-te-7 br-be-7 "
                                        value="Calculate">
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </form>

        @if ($transaction=Session::get('transaction'))
        <div class="card">
            <div class="card-header">
                <h3 class="card-title">total transactions for ( {{$transaction->group->groupName->gname}} )</h3>
            </div>
            <div class="card-body">
                <a href="{{route('admin.accounting.index')}}" 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 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;">Course</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>
                                <th>details</th>
                                <th></th>
                            </tr>
                        </thead>
                        <tbody>


                            <tr class="text-center">
                            <td>1</td>
                            <td>{{$transaction->courseOffering->has_label ? ' ( '.$transaction->courseOffering->label.' ) ':''}} {{$transaction->courseOffering->course->cname . ' (' .$transaction->courseOffering->course->level->lshort_name .' )'}}</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>
                                {{($transaction->total_teacher_amount
                                    + $transaction->total_eshra7ly_amount
                                    + $transaction->old_refund)
                                    - $transaction->total_amount_due}}
                            </td>
                            <td>
                                {{($transaction->total_teacher_amount_aed
                                    + $transaction->total_eshra7ly_amount_aed
                                    + $transaction->old_refund_aed)
                                    - $transaction->total_amount_due_aed}}
                            </td>
                            <td>{{$transaction->from}}</td>
                            <td>{{$transaction->to}}</td>
                            <td>
                                <a target="_blank" href='{{route('admin.accounting.transactionsDetails',[$transaction->totalid,$transaction->coffid,$transaction->gid])}}'>View Details</a>
                                {{-- @if ($transaction->old_refund)
                                  <br>
                                  <a target="_blank" href='{{route('admin.accounting.viewOldRefund',[$transaction->coffid])}}'>View Old Refund</a>
                                @endif --}}
                                @if ($transaction->old_refund)
                                <br>
                                <span class="badge badge-danger mt-2">Has old Refund</span>
                                @endif
                            </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>
                            </tr>
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
        @endif
    </div>
</div>
@endsection
@section('admin-js')
<script>
    $('#session').on('change', function() {
            var $course = $('#course');
            $('#course').empty();
            $('#course').append(`<option value="0" disabled selected>Processing...</option>`);
            $.ajax({
                url: "{{ route('sessionFilterForUnCalculatedTransactions') }}",
                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>');
                        })
                    });
                }
            });
        });

        $('#course').on('change', function() {
            var $group = $('#group');
            $('#group').empty();
            $('#group').append(`<option value="0" disabled selected>Processing...</option>`);
            $.ajax({
                url: "{{ route('courseFilterToGetUnCalculatedTransactionsGroups') }}",
                type: 'GET',
                data: {
                    coffid: $(this).val()
                },
                success: function(data) {
                    console.log(data)
                    $('#group').empty();
                    $('#group').append(
                        `<option value="0" disabled selected>Select Group*</option>`);
                    $.each(data, function(id, value) {
                        $group.append('<option value="' + value.gid + '">' +
                            value.group_name.gname + '</option>');
                    });
                }
            });
        });
</script>
<script>
	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();
                }
            });
    }
</script>

    @if ($message_egp = Session::get('refund_after_post_egp') || $message_aed = Session::get('refund_after_post_aed'))
        @if($message_egp || $message_aed)
        <script type="text/javascript">
                            notif({
                            type: "error",
                            msg: "Pay Attention!, This transaction has an old refund and you can view the details below",
                            position: "center",
                            opacity: 0.8,
                            autohide: true,
                            multiline:true,
                            });
        </script>
        @endif
    @endif

<script>
     // 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();
                }
            });
    }
</script>

@endsection