@extends('admin.layouts.app')

@push('style')

    <!-- daterange picker -->
    <link rel="stylesheet" href="{{ asset('themes/backend/bower_components/bootstrap-daterangepicker/daterangepicker.css') }}">
    <style>
        .table-bordered>thead>tr>th, .table-bordered>tbody>tr>th, .table-bordered>tfoot>tr>th, .table-bordered>thead>tr>td, .table-bordered>tbody>tr>td, .table-bordered>tfoot>tr>td {
            border: 1px solid #000 !important;
        }

        .subject_mar{
            margin-top: 15px;
        }
        .subject_mar1{
            margin-bottom: 15px;
        }
        .subject_mar2{
            margin-top: 60px;
        }
    </style>
@endpush
@section('title')
    Employee Wise Salary Report
@endsection

@section('container')
    <div class="row">
        <div class="col-md-12">
            <div class="box">
                <div class="box-body">
                    <form id="myForm" method="get">
                        <div class="row">
                            <div class="col-md-4">
                                <div class="form-group">
                                    <label>Employee</label>
                                    <select class="form-control select2" name="employee" id="employee" required>
                                            <option value="" >Select Employee</option>
                                        @foreach($employees as $employee)
                                            <option value="{{ $employee->id}}" {{ request()->get('employee') == $employee->id ? 'selected' : '' }}>{{ $employee->name}}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>
                            <div class="col-md-4">
                                <div class="form-group">
                                    <label>Year</label>

                                    <select class="form-control select2" name="year" id="year" required>
                                        <option value="">Select Year</option>
                                        @foreach($salaryDates as $item)
                                            <option value="{{ $item->year}}" {{ request()->get('year') == $item->year ? 'selected' : '' }}>{{ $item->year}}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>

                            <div class="col-md-3">
                                <div class="form-group">
                                    <label>	&nbsp;</label>
                                    <input type="submit" class="btn btn-primary form-control actionable" value="Search"
                                           data-action="{{ route('report.employee_wise_salary') }}" >
                                </div>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>
    @if(count($salaries) > 0)
        <div class="row">
            <div class="col-sm-12">
                <section class="panel">
                    <div class="panel-body">
                        <button class="pull-right btn btn-primary" onclick="getprint('prinarea')">Print</button>
                        <div id="prinarea">
                            <div style="padding:10px; width:100%; text-align:center;">
                                <h2>{{ config('app.name', 'Laravel') }}</h2>
                                <h5>Salary Statement Year of
                                    {{request()->get('year')}}
                                </h5>
                                <h4>
                                   Employee Name : <b>{{$employee->name ?? ''}}</b>
                                </h4>
                            </div>
                            @isset($salaries)
                                <div class="table-responsive">
                                    <table class="table table-bordered">
                                        <thead>
                                        <tr>
                                            <th class="text-center">Sl NO</th>
                                            <th class="text-center">Salary Month</th>
                                            <th class="text-center">Basic Salary</th>
                                            <th class="text-center">Bonus</th>
                                            <th class="text-center">Advance</th>
                                            <th class="text-center">Net Salary</th>
                                            <th class="text-center">Remarks</th>
                                        </tr>
                                        </thead>
                                        <tbody>

                                        @foreach($salaries as $salary)
                                            @php
                                                $date = Carbon\Carbon::create(null, $salary->month, 1);
                                                $monthName = $date->format('F');
                                                $salaryProcess = \App\Models\SalaryProcess::find($salary->salary_process_id);
                                            @endphp
                                            <tr>
                                                <td class="text-center">{{$loop->iteration}}</td>
                                                <td class="text-center">{{$monthName ?? ''}}</td>
                                                <td class="text-center">{{number_format($salary->gross_salary,2)}}</td>
                                                <td class="text-center">{{number_format($salary->bonus_amount,2)}}</td>
                                                <td class="text-center">{{number_format($salary->advance_deduct,2)}}</td>
                                                <td class="text-center">{{number_format($salary->gross_salary+$salary->bonus_amount-$salary->advance_deduct,2)}}</td>
                                                <td class="text-center">
                                                    @php
                                                        if($salaryProcess->bonus_status==2){
                                                            $bonus_status = 'with Eid-ul-fitr Bonus';
                                                        } elseif($salaryProcess->bonus_status==3){
                                                            $bonus_status = 'with Eid-ul-adha Bonus';
                                                        }
                                                    @endphp
                                                    {{ 'Salary Month '.$monthName ?? '' }}@if($salaryProcess->bonus_status!=1){{ $bonus_status }} @endif

                                                </td>
                                            </tr>
                                        @endforeach

                                        </tbody>

                                        <tfoot>
                                        <tr>
                                            <th class="text-right" colspan="2">Total</th>
                                            <th class="text-center">{{number_format($salaries->sum('gross_salary'),2)}}</th>
{{--                                            @if($salaryProcess->bonus_status != 1)--}}
                                                <th class="text-center">{{number_format($salaries->sum('bonus_amount'),2)}}</th>
{{--                                            @endif--}}
                                            <th class="text-center">{{number_format($salaries->sum('advance_deduct'),2)}}</th>
                                            <th class="text-center">{{number_format($salaries->sum('gross_salary')+$salaries->sum('bonus_amount')-$salaries->sum('advance_deduct'),2)}}</th>
                                            <th class="text-right" ></th>
                                        </tr>
                                        </tfoot>
                                    </table>
                                </div>
                                <div>
                                    <p><strong>Amount in words (Tk):   </strong> {{ DecimalToWords::convert($salaries->sum('gross_salary')+$salaries->sum('bonus_amount')-$salaries->sum('advance_deduct'),'Taka', 'Poisa')}}.</p>
                                </div>
                            @endisset
                        </div>

                    </div>
                </section>
            </div>
        </div>
    @endif
@endsection

@push('scripts')

    <!-- date-range-picker -->
    <script src="{{ asset('themes/backend/bower_components/moment/min/moment.min.js') }}"></script>
    <script src="{{ asset('themes/backend/bower_components/bootstrap-daterangepicker/daterangepicker.js') }}"></script>

    <script>
        $(function () {


            var monthSelected = '{{ request()->get('month') }}';

            $('#year').change(function () {
                var year = $(this).val();
                $('#month').html('<option value="">Select Month</option>');

                if (year != '') {
                    $.ajax({
                        method: "GET",
                        url: "{{ route('get_month_salary_sheet') }}",
                        data: { year: year }
                    }).done(function( response ) {
                        $.each(response, function( index, item ) {
                            if (monthSelected == item.id)
                                $('#month').append('<option value="'+item.id+'" selected>'+item.name+'</option>');
                            else
                                $('#month').append('<option value="'+item.id+'">'+item.name+'</option>');

                        });
                    });

                }
            });
            $('#year').trigger('change');

            $(function() {
                $( ".actionable" ).click( function() {
                    $('#myForm').attr('action', $(this).data("action"));
                    $('#myForm').submit();
                });
            });

        });
    </script>
    <script>


        var APP_URL = '{!! url()->full()  !!}';
        function getprint(prinarea) {

            $('body').html($('#'+prinarea).html());
            window.print();
            window.location.replace(APP_URL)
        }
    </script>
@endpush