@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')
    Salary Sheet
@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>Year</label>
                                    <select class="form-control select2" name="year" id="year" required>
                                        <option value="">Select Year</option>
                                        @for($i=2023; $i <= date('Y'); $i++)
                                            <option value="{{ $i }}" {{ request()->get('year') == $i ? 'selected' : '' }}>{{ $i }}</option>
                                        @endfor
                                    </select>
                                </div>
                            </div>
                            <div class="col-md-4">
                                <div class="form-group">
                                    <label>Month</label>

                                    <select class="form-control select2" name="month" id="month" required>
                                        <option value="" >Select Month</option>
                                        @for($i=1; $i <= 12; $i++)
                                            @php
                                            $monthName = date("F", mktime(0, 0, 0, $i, 1));
                                            @endphp
                                            <option value="{{ $i }}" {{ request()->get('month') == $i ? 'selected' : '' }}>{{ $monthName }}</option>
                                        @endfor
                                    </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('payroll.salary.sheet') }}" >
                                </div>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>
    @if(count($salaries) > 0)
        <div class="row">
            <div class="col-sm-12">
                <hr>
                <section class="panel">
                    <div class="panel-body">
                        <button class="text-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>
                                <h4>

                                </h4>
                                <h4>For the month of
                                    @if (count($employees) > 0)
                                        @if ($month == 1)
                                            {{ 'January' }}
                                        @endif
                                        @if ($month == 2)
                                            {{ 'February' }}
                                        @endif
                                        @if ($month == 3)
                                            {{ 'March' }}
                                        @endif
                                        @if ($month == 4)
                                            {{ 'April' }}
                                        @endif
                                        @if ($month == 5)
                                            {{ 'May' }}
                                        @endif
                                        @if ($month == 6)
                                            {{ 'June' }}
                                        @endif
                                        @if ($month == 7)
                                            {{ 'July' }}
                                        @endif
                                        @if ($month == 8)
                                            {{ 'August' }}
                                        @endif
                                        @if ($month == 9)
                                            {{ 'September' }}
                                        @endif
                                        @if ($month == 10)
                                            {{ 'October' }}
                                        @endif
                                        @if ($month == 11)
                                            {{ 'November' }}
                                        @endif
                                        @if ($month == 12)
                                            {{ 'December' }}
                                        @endif
                                    @endif
                                    {{request()->get('year')}}
                                </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">Process Date</th>
                                            <th class="text-center">Employee Name</th>
                                            <th class="text-center">Basic Salary</th>
                                            <th class="text-center">Advance</th>
                                            <th class="text-center">Absent</th>
                                            <th class="text-center">Absent Deduct</th>
                                            <th class="text-center">Late Hours</th>
                                            <th class="text-center">Late Deduct</th>
                                            <th class="text-center">Total Deduct</th>
                                            <th class="text-center">Gross Salary</th>
                                            <th class="text-center">Net Salary</th>
                                            <th class="text-center">Remarks</th>
                                            <th class="text-center extra_column">Action</th>
                                        </tr>
                                        </thead>
                                        <tbody>
                                        @php
                                            $advanceAmountTotal = 0;
                                        @endphp
                                        @foreach($salaries as $salary)
                                            @php
                                                $advanceAmount = \App\Models\EmployeeSalaryAdvance::where('employee_id',$salary->employee_id)
                                                ->where('year',$year)
                                                ->where('month',$month)
                                                ->sum('advance');
                                            @endphp
                                            <tr>
                                                <td class="text-center">{{$loop->iteration}}</td>
                                                <td class="text-center">{{ \Carbon\Carbon::parse($salary->date)->format('d-m-Y') }}</td>
                                                <td class="text-center">{{$salary->employee->name ?? ''}}</td>
                                                <td class="text-center">{{number_format($salary->gross_salary,2)}}</td>
                                                <td class="text-center">{{number_format($advanceAmount,2)}}</td>
                                                <td class="text-center">{{ $salary->absent_day }}</td>
                                                <td class="text-center">{{ number_format($salary->absent_deduct,2) }}</td>
                                                <td class="text-center">{{ $salary->late_hours }}</td>
                                                <td class="text-center">{{ number_format($salary->late_deduct,2) }}</td>
                                                <td class="text-center">{{ number_format($salary->absent_deduct,2) }}</td>
                                                <td class="text-center">{{number_format($salary->gross_salary,2)}}</td>
                                                <td class="text-center">{{number_format($salary->total_salary,2)}}</td>
                                                <td class="text-center">
                                                    @if (count($salaries) > 0)
                                                        @if ($month == 1)
                                                            {{ 'Month Of January' }}
                                                        @endif
                                                        @if ($month == 2)
                                                            {{ 'Month Of February' }}
                                                        @endif
                                                        @if ($month == 3)
                                                            {{ 'Month Of March' }}
                                                        @endif
                                                        @if ($month == 4)
                                                            {{ 'Month Of April' }}
                                                        @endif
                                                        @if ($month == 5)
                                                            {{ 'Month Of May' }}
                                                        @endif
                                                        @if ($month == 6)
                                                            {{ 'Month Of June' }}
                                                        @endif
                                                        @if ($month == 7)
                                                            {{ 'Month Of July' }}
                                                        @endif
                                                        @if ($month == 8)
                                                            {{ 'Month Of August' }}
                                                        @endif
                                                        @if ($month == 9)
                                                            {{ 'Month Of September' }}
                                                        @endif
                                                        @if ($month == 10)
                                                            {{ 'Month Of October' }}
                                                        @endif
                                                        @if ($month == 11)
                                                            {{ 'Month Of November' }}
                                                        @endif
                                                        @if ($month == 12)
                                                            {{ 'Month Of December' }}
                                                        @endif
                                                    @endif
                                                </td>
                                                <td class="text-center extra_column"><a href="{{ route('payroll.individual_salary_process.edit',['salary'=>$salary->id]) }}" class="btn btn-info btn-sm"><i class="fa fa-edit"></i></a></td>
                                            </tr>
                                            @php
                                                $advanceAmountTotal += $advanceAmount;
                                            @endphp
                                        @endforeach

                                        </tbody>

                                        <tfoot>
                                        <tr>
                                            <th class="text-end" colspan="3">Total</th>
                                            <th class="text-center">{{number_format($salaries->sum('gross_salary'),2)}}</th>
                                            <th class="text-center">{{number_format($advanceAmountTotal,2)}}</th>
                                            <th class="text-center">{{number_format($salaries->sum('absent_day'))}}</th>
                                            <th class="text-center">{{number_format($salaries->sum('absent_deduct'),2)}}</th>
                                            <th class="text-center"></th>
                                            <th class="text-center">{{number_format($salaries->sum('late_deduct'),2)}}</th>
                                            <th class="text-center">{{number_format($salaries->sum('absent_deduct')+$salaries->sum('late_deduct'),2)}}</th>
                                            <th class="text-center">{{number_format($salaries->sum('gross_salary'),2)}}</th>
                                            <th class="text-center">{{number_format($salaries->sum('total_salary'),2)}}</th>
                                            <th class="text-center"></th>
                                            <th class="text-center extra_column"></th>

                                        </tr>
                                        </tfoot>
                                    </table>
                                </div>
                                <div>
                                    <p><strong>Amount in words (Tk):   </strong> {{ DecimalToWords::convert($salaries->sum('total_salary'),'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 () {

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

        });
    </script>
    <script>


        var APP_URL = '{!! url()->full()  !!}';
        function getprint(prinarea) {
            $('.extra_column').remove();
            $('body').html($('#'+prinarea).html());
            window.print();
            window.location.replace(APP_URL)
        }
    </script>
@endpush