@extends('layouts.admin')

@section('content')
<!--App-Content-->
<div class="app-content my-3 my-md-5">
    <div class="side-app">
        <div class="page-header">
            <h4 class="page-title">Employees Payroll</h4>
        </div>
        @include('admin.errors.form-errors')
        <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.employees.unCommittedPayroll') }}" class="ms-0 me-2 w-100 {{$uncommited_payroll ? 'active':''}}">Un-commited</a></li>
                                        <li><a href="{{ route('admin.accounting.employees.committedPayroll') }}" class="w-100 {{$commited_payroll ? 'active':''}}">Commited</a></li>
                                    </ul>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                    {{-- Un Posted Transactions --}}
                    @if ($uncommited_payroll)   
                        <!-- Search Section -->
                        <form action="{{ route('admin.accounting.employees.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-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-6">
                                                        <label class=" mt-3 mb-sm-1"> Employee: </label>
                                                        <select class="form-control select2-show-search" id="employee" name="employee">
                                                            <option value="0" disabled selected>Select</option>
                                                            @foreach ($employees as $item)
                                                            <option value="{{$item->emid}}">{{$item->name}}</option>
                                                            @endforeach
                                                        </select>
                                                    </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> 
                        @if (Request::has('date') || Request::has('employee'))
                            <div class="tab-pane show fade">
                                <div class="card">
                                    <div class="card-header">
                                        <h3 class="card-title">
                                            @if ($uncommited_payroll->first())
                                            Un Committed List (<span class="text-success">{{$uncommited_payroll->first()->from}}</span> To <span class="text-success">{{$uncommited_payroll->first()->to}}</span> )
                                            @endif
                                        </h3>
                                    </div>
                                    <div class="card-body">
                                        {{-- Export btn --}}
                                        @if (count($uncommited_payroll) > 0)    
                                        <div class="d-flex justify-content-center">
                                            <form action="{{route('admin.accounting.employees.exportUnCommittedpayroll')}}" method="get"> 
                                                <input type="hidden" value="{{request()->get('date')}}" name="date">
                                                <input type="hidden" value="{{request()->get('employee')}}" name="employee">
                                                <button type="submit" class="btn  btn-outline-primary" >Export <i class="fa fa-file-excel-o fs-14"></i></button>
                                            </form> 
                                            <a href="javascript:void(0)" onClick="confirmCommitAll()" class="btn btn-outline-success ms-3">
                                                Commit all 
                                                <i class="fa fa-check fs-13"></i>
                                                <form method="POST" action="{{ route('admin.accounting.employees.commitAll') }}" id="commit-form-all">
                                                    @csrf
                                                    <input name="_method" type="hidden" value="POST">
                                                    <input name="from" type="hidden" value="{{$uncommited_payroll->first()->from}}">
                                                    <input name="to" type="hidden" value="{{$uncommited_payroll->first()->to}}">
                                                </form>
                                            </a>
                                        </div> 
                                        @endif
                                        <div class="table-responsive" id="uncommitted">
                                            <table
                                                class="data-table-example table table-hover table-vcenter text-nowrap">
                                                <thead>
                                                    <tr>
                                                        <th style="text-align: center;">Id</th>
                                                        <th style="text-align: center;">employee name</th>
                                                        <th style="text-align: center;">salary</th>
                                                        <th style="text-align: center;">deduction</th>
                                                        <th style="text-align: center;">bonus</th>
                                                        <th style="text-align: center;">net salary</th>
                                                        <th style="text-align: center;">bank account</th>
                                                        <th></th>
                                                    </tr>
                                                </thead>
                                                    <tbody>
                                                        @php
                                                            $count=0
                                                        @endphp
                                                        @foreach ($uncommited_payroll as $item)
                                                       
                                                        <tr class="text-center">
                                                        <td>{{++$count}}</td>
                                                        <td>
                                                            {{$item->employee->name}}
                                                            <i class="mdi mdi-information-outline leading-loose" data-bs-html="true" data-bs-toggle="tooltip" data-bs-placement="top" title="" 
                                                            data-bs-original-title="
                                                            Phone: {{$item->employee->phone}} <br>
                                                            Email: {{$item->employee->email}} <br>
                                                            Job Title: {{$item->employee->job_title->name}} <br>
                                                            ">
                                                        </i>
                                                        </td>
                                                        <td>{{$item->salary}} EGP</td>
                                                        <td>{{$item->deduction}} EGP</td>
                                                        <td>{{$item->bonus}} EGP</td>
                                                        <td>{{$item->net_salary}} EGP</td> 
                                                        <td>{{$item->employee->bank_account}}</td>

                                                        <td>
                                                            <button type="button"
                                                                value="{{$item->eaid}}"
                                                                data-salary="{{$item->salary}}"
                                                                class="modal-effect btn btn-outline-danger btn-sm waves-effect waves-light deduction"
                                                                data-bs-effect="effect-sign" data-bs-toggle="modal" data-bs-original-title="Deduction" data-bs-target="#deduction_modal">
                                                                add deduction <i class="fa fa-minus fs-10"></i>
                                                            </button>
                                                            <button type="button"
                                                                value="{{$item->eaid}}"
                                                                data-salary="{{$item->salary}}"
                                                                class="modal-effect btn btn-outline-primary btn-sm waves-effect waves-light bonus"
                                                                data-bs-effect="effect-sign" data-bs-toggle="modal" data-bs-original-title="Bonus" data-bs-target="#bonus_modal">
                                                                add bonus <i class="fa fa-plus fs-10"></i>
                                                            </button>
                                                            <a href="javascript:void(0)" onClick="confirmCommit(event,{{$item->eaid}})" class="btn btn-outline-success  btn-sm waves-effect waves-light"
                                                                data-bs-toggle="tooltip" data-bs-original-title="Commit">
                                                                Commit
                                                                <i class="fa fa-plus fs-10"></i>
                                                                <form method="POST" action="{{ route('admin.accounting.employees.commit',$item->eaid) }}" id="commit-form-{{$item->eaid}}">
                                                                    @csrf
                                                                    <input name="_method" type="hidden" value="POST">
                                                                </form>
                                                            </a>
                                                        </td>                                      
                                                        </tr>
                                                        @endforeach
                                                    </tbody>
                                            </table>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        @endif
                    @endif
                    {{--  commited Transactions --}}
                    @if ($commited_payroll)    
                        <form action="{{ route('admin.accounting.employees.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-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-6">
                                                        <label class=" mt-3 mb-sm-1"> Employee: </label>
                                                        <select class="form-control select2-show-search" id="employee" name="employee">
                                                            <option value="0" disabled selected>Select</option>
                                                            @foreach ($employees as $item)
                                                            <option value="{{$item->emid}}">{{$item->name}}</option>
                                                            @endforeach
                                                        </select>
                                                    </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>
                        @if (Request::has('date') || Request::has('employee'))
                        <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)
                                    <form action="{{route('admin.accounting.employees.exportCommittedPayroll')}}" method="get"> 
                                        <input type="hidden" value="{{request()->get('date')}}" name="date">
                                        <input type="hidden" value="{{request()->get('employee')}}" name="employee">
                                        <button type="submit" class="btn btn-primary mx-auto d-block w-25 mb-4" >Export</button>
                                    </form>     
                                    @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;">employee name</th>
                                                    <th style="text-align: center;">salary</th>
                                                    <th style="text-align: center;">deduction</th>
                                                    <th style="text-align: center;">bonus</th>
                                                    <th style="text-align: center;">net salary</th>
                                                    <th style="text-align: center;">bank account</th>
                                                    
                                                </tr>
                                            </thead>
                                            <tbody>
                                                @php
                                                    $count=0;
                                                    $amount=0;
                                                @endphp
                                                @foreach ($commited_payroll as $item)
                                                <tr class="text-center">
                                                <td>{{++$count}}</td>
                                                <td>
                                                    {{$item->employee->name}}
                                                    <i class="mdi mdi-information-outline leading-loose" data-bs-html="true" data-bs-toggle="tooltip" data-bs-placement="top" title="" 
                                                    data-bs-original-title="
                                                    Phone: {{$item->employee->phone}} <br>
                                                    Email: {{$item->employee->email}} <br>
                                                    Job Title: {{$item->employee->job_title->name}} <br>
                                                    ">
                                                </i>
                                                </td>
                                                <td>{{$item->salary}} EGP</td>
                                                <td>{{$item->deduction}} EGP</td>
                                                <td>{{$item->bonus}} EGP</td>
                                                <td>{{$item->net_salary}} EGP</td>  
                                                <td>{{$item->employee->bank_account}}</td>

                                                </tr>
                                                @php
                                                    $amount=$amount+$item->net_salary;
                                                @endphp
                                                @endforeach
                                                <tr>
                                                <td colspan="7" class="text-center font-weight-bold">Total Committed Salaries: <span class="text-danger">{{$amount}}</span> <span class="text-success">EGP</span></td>
                                                </tr>
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        </div>
                        @endif 
                    @endif 
            </div>
        </div>
    </div>
</div>

<div class="modal  fade effect-sign show" id="deduction_modal" tabdocumentation="-1" role="dialog" aria-hidden="true">
        <div class="modal-dialog" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title" id="example-Modal3">Deduction amount</h5>
                    <button type="button" class="close" data-bs-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                </div>
                <div class="modal-body">
                <form method="POST" action="" id="deduction_form">
                    @csrf
                    <input name="_method" type="hidden" value="POST">
                    <input type="hidden" name="salary" id="salary" value=""> 
                    <div class="form-group ">
                        <div class="row">
                            <div class="col-md-3">
                                <label class="form-label mt-2" for="reason">Amount* <span class="text-danger">(Required)</span></label>
                            </div>
                            <div class="col-md-9">

                               <input type="number" min="0"  class="form-control" name="deduction" id="deduction_amount" placeholder="EGP">
                            </div>
                        </div>
                    </div>
                    <div class="modal-footer">
                        <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
                        <button type="submit" id="submit" class="btn btn-primary" value="">Add</button>   
                    </div>
                </form>
            </div>
        </div>
    </div>
</div>
</div> 

{{-- Bonus Modal --}}
<div class="modal  fade effect-sign show" id="bonus_modal" tabdocumentation="-1" role="dialog" aria-hidden="true">
    <div class="modal-dialog" role="document">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title" id="example-Modal3">Bonus amount</h5>
                <button type="button" class="close" data-bs-dismiss="modal" aria-label="Close">
                    <span aria-hidden="true">&times;</span>
                </button>
            </div>
            <div class="modal-body">
                <form method="POST" action="" id="bonus_form">
                    @csrf
                    <input name="_method" type="hidden" value="POST">
                    <input type="hidden" name="salary" id="salary_bonus" value=""> 
                    <div class="form-group ">
                        <div class="row">
                            <div class="col-md-3">
                                <label class="form-label mt-2" for="reason">Amount* <span class="text-danger">(Required)</span></label>
                            </div>
                            <div class="col-md-9">
    
                               <input type="number" min="0" class="form-control" name="bonus" id="bonus_amount" placeholder="EGP">
                            </div>
                        </div>
                    </div>
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
                <button type="submit" id="submit" class="btn btn-primary" value="">Add</button>
            </div>
            </form>
        </div>
    </div>
</div>

@endsection
@section('admin-js')

<script>
     // confirm commit 
     function confirmCommit(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(`commit-form-${id}`).submit();
                }
            });
    }

 // confirm commit  all
 function confirmCommitAll(e){ //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(`commit-form-all`).submit();
                }
        });
}


    // Add Deduction 
    jQuery('body').on('click', '.deduction', function () {
        var eaid = $(this).val();
        var url = "{{ route('admin.accounting.employees.addDeduction',":eaid") }}";
        url = url.replace(':eaid', eaid);
            jQuery('#salary').val($(this).attr('data-salary'));
            jQuery('#deduction_form').attr('action',url)       
            jQuery('#deduction_amount').attr('max',$(this).attr('data-salary')) 
    });

    // Add Bonus 
    jQuery('body').on('click', '.bonus', function () {
        var eaid = $(this).val();
        var url = "{{ route('admin.accounting.employees.addBonus',":eaid") }}";
        url = url.replace(':eaid', eaid);
            jQuery('#salary_bonus').val($(this).attr('data-salary'));
            jQuery('#bonus_form').attr('action',url)  
            console.log(jQuery('#salary_bonus').val());     
    });
</script>

@endsection