@php use App\Models\Staff; @endphp
@php @endphp
@extends('admin.layouts.app')
@section('title',get_setting('site_name').' Salary Certificate')
@section('content')
    <style>


        .select2-selection__rendered {
            line-height: 31px !important;

        }

        .select2-container .select2-selection--single {
            height: 35px !important;

        }

        .select2-selection__arrow {
            height: 34px !important;

        }


    </style>

    <div class="row no-print">
        <div class="col-md-8 mx-auto">
            <form action="{{route('salary.certificate')}}" method="GET">
                <div class="row">
                    <div class="col-md-5">
                        <select class=" select2 custom-select form-control" name="employee_id" id="" required>
                            <option value="">{{__('Select Employee')}}</option>
                            @foreach(Staff::all() as $user)
                                <option value="{{$user->id}}"
                                        @if(request()->employee_id==$user->id) selected @endif>{{$user->user->name}}
                                    ({{$user->user->id}})
                                </option>
                            @endforeach

                        </select>
                    </div>
                    <div class="col-md-2">
                        <select class=" select2 custom-select form-control" name="month" id="" required>
                            @for ($i = 1; $i <= 12; $i++)

                                <option value="{{ $i }}"
                                        @if(request()->month==$i) selected @endif>{{ date('F', mktime(0, 0, 0, $i, 1)) }}</option>
                            @endfor

                        </select>
                    </div>
                    <div class="col-md-2">
                        <select class=" select2 custom-select form-control" name="year" id="" required>
                            <option value="">{{__('Select Year')}}</option>
                            @for($i=2023;$i<=date('Y');$i++)
                                <option value="{{$i}}" @if(request()->year==$i) selected @endif>{{$i}}</option>
                            @endfor

                        </select>
                    </div>
                    <div class="col-md-3">
                        <button class="btn btn-primary" type="submit"><i
                                    class="fas fa-certificate"></i>&nbsp;{{__('Generate')}}</button>
                    </div>

                </div>

            </form>
            <hr class="mx-auto">
        </div>
    </div>


    @if($certificate_show==1)
        <div style="width: 100%; background-color: #fff;padding: 8px" class="certificate_margin_top">
            <h1 align="center">Salary Certificate</h1>

            <p> This is to certify that <strong>{{$employee->user->name}}</strong> has been working
                in {{get_setting('site_name')}}
                since
                <strong>{{date('d-m-y',strtotime($employee->joing_date))}}</strong>. He is Active & permanent employee
                of this
                company under <strong>{{$employee->user->id}}</strong>. As per our service rule / term of employment,
                there is no fixed
                timing of retirement.
                At present
                he is serving our company as a {{!empty($employee->designation)?$employee->designation->name:''}},
                department of {{!empty($employee->department)?$employee->department->name:''}}. His gross
                salary is
                below for the month <strong>{{date('F', mktime(0, 0, 0, request()->month, 1)) }}
                    ,{{request()->year}}</strong>.
            </p><br/>

            <div class="salary_table">
                <table class="table table-bordered">
                    <thead>
                    <tr>
                        <th>Salary Breakup</th>
                        <th>Salary Amount</th>
                        <th>Deduction Head</th>
                        <th>Amount</th>
                    </tr>
                    </thead>

                    <tbody>
                    <tr>
                        <td>Basic</td>
                        <td>{{$salary->basic_salary}}</td>
                        <td></td>
                        <td></td>
                    </tr>

                    <tr>
                        <td>Housing</td>
                        <td>{{$salary->house_rent}}</td>
                        <td></td>
                        <td></td>
                    </tr>


                    <tr>
                        <td>Conveyance Allowance</td>
                        <td>{{$salary->conveyance}}</td>
                        <td></td>
                        <td></td>
                    </tr>


                    <tr>
                        <td>Medical Allowance</td>
                        <td>{{$salary->medical}}</td>
                        <td></td>
                        <td></td>
                    </tr>


                    <tr>
                        <td>Others</td>
                        <td>{{$salary->Others}}</td>
                        <td></td>
                        <td></td>
                    </tr>


                    </tbody>

                </table>
                <p><strong>In words:</strong>&nbsp;{{Inwords($salary->gross_salary)}}</p>
            </div>

            <div align="right">

                <table>
                    <tr>
                        <td>Earnings:</td>
                        <td>{{$salary->gross_salary}} </td>
                    </tr>

                    <tr>
                        <td>Deductions:</td>
                        <td>{{$salary->provident_fund}} </td>
                    </tr>

                    <tr>
                        <td>Net Remuneration :</td>
                        <td>{{$salary->gross_salary}} </td>
                    </tr>
                </table>


            </div>

            <p>We are issuing this letter on the specific request of our employee without accepting any liability on
                behalf of this letter
                or part of this letter on our company.</p>

            <div align="left">
                <!-- this can be changed to "left" if preferred-->

                Thanks and Regards, <br/><br/>
                <br/>
                <br/>
                <br/>
                <br>
                <div style="border-bottom: 2px solid #d9d7d7;border-bottom-style: dashed; width: 180px"></div>
                <p>Signature & Stamp</p>
                Name:<br/> Designation: <br>Date:{{date('d-m-y')}}


            </div>

            <div class="row">
                <div class="col-12">
                    <button class="btn btn-primary float-right no-print m-2" onclick="window.print()"><i
                                class="fas fa-print"></i>
                    </button>
                </div>
            </div>

        </div>
    @endif
@endsection