@extends('layouts.teacher')

@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">
                    <!-- Search Section -->
                    <form action="{{ route('teacher.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-5">
                                                    <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->educationSystem->esname.'_'.$session->sessions->board->bname.'_'.$session->sessions->sname .' '.$session->year}}</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">
                                                    </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-4">
                                                <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="transactions">
                        <div class="card">
                            <div class="card-header">
                                <h3 class="card-title">Total Transactions List</h3>
                            </div>
                            <div class="card-body">
                                <div class="text-center py-5">
                                    <span class="text-success font-weight-bold ">Total Net Salary EGP: </span> {{$total_transactions->sum('net_salary')}} EGP
                                </div>
                                <div class="text-center">
                                    <span class="text-success font-weight-bold ">Total Net Salary AED: </span> {{$total_transactions->sum('net_salary_aed')}} AED
                                </div>
                                <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;">session</th>
                                                <th style="text-align: center;">Group</th>
                                                {{-- <th style="text-align: center;">Total amount</th> --}}
                                                <th style="text-align: center;">Discount amount egp</th>
                                                <th style="text-align: center;">Discount amount aed</th>
                                                {{-- <th style="text-align: center;">Total amount due</th> --}}
                                                <th style="text-align: center;">Teacher amount egp</th>
                                                <th style="text-align: center;">Teacher amount aed</th>
                                                <th style="text-align: center;">Tax</th>
                                                <th style="text-align: center;">net salary egp</th>
                                                <th style="text-align: center;">net salary aed</th>
                                                <th style="text-align: center;">from</th>
                                                <th style="text-align: center;">to</th>
                                                <th>details</th>
                                            </tr>

                                        </thead>
                                        <tbody>
                                            @php
                                                $count=0;
                                            @endphp
                                            @foreach ($total_transactions as $transaction)
                                            <tr class="text-center">
                                            <td>{{++$count}}</td>
                                            <td>
                                                {{$transaction->courseOffering->has_label ? ' ( '.$transaction->courseOffering->label.' ) ':''}} {{$transaction->courseOffering->course->cname . ' (' .$transaction->courseOffering->course->level->lshort_name .' )'}}</td>
                                            <td>{{$transaction->courseOffering->academicYearSession->acyname}}</td>
                                            <td>
                                                @if($transaction->gid)
                                                {{$transaction->group->groupName->gname}}
                                                @else
                                                 No Group, course installment or extra meeting
                                                @endif
                                            </td>
                                            {{-- <td>{{$transaction->total_amount}} EGP</td> --}}
                                            <td>{{$transaction->total_discount_value}}</td>
                                            <td>{{$transaction->total_discount_value_aed}}</td>
                                            {{-- <td>{{$transaction->total_amount_due}} EGP</td> --}}
                                            <td>{{$transaction->total_teacher_amount}}</td>
                                            <td>{{$transaction->total_teacher_amount_aed}}</td>
                                            <td>{{$transaction->tax_value}} %</td>
                                            <td>{{$transaction->net_salary}}</td>
                                            <td>{{$transaction->net_salary_aed}}</td>
                                            <td>{{$transaction->from}}</td>
                                            <td>{{$transaction->to}}</td>
                                            <td>
                                                <form target="_blank" action="{{route('teacher.accounting.transactionsDetails',[$transaction->courseOffering->coffid,$transaction->totalid])}}">
                                                    <input type="hidden" name="gid" value="{{$transaction->gid}}">
                                                    <button type='submit' class="form-control">View Details</button>
                                                </form>
                                            </td>
                                            </tr>
                                            @endforeach

                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
            </div>
        </div>
    </div>
</div>
@endsection
@section('teacher-js')
<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('sessionFilterForTeacherPayrollPostedCourses') }}",
                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) {
                        $course.append('<option value="' + value.coffid + '">' +
                            (value.has_label ? '( '+value.label+' ) ' : '') + value.course.cname + ' ( '+ value.course.level.lshort_name+' ) ' + '</option>');
                    });
                }
            });
        });
</script>
@endsection