@extends('Reports.template')

<!--Title-->
@section('title')
Leave Entitlement Report
@endsection
<!--Title Close-->

<!--External CSS-->
@section('ExternalCss')
@parent
@endsection
<!--External CSS Close--> 

@section('Content')
<!-- Your Page Content Here -->

<!--View Content of database-->
<div class="col-md-12 table-responsive">
    <table class="table table-responsive" style="border-top:none; border-bottom:1px solid #000; font-size:12px;">
        <thead>
            <tr>
                <th colspan="2" class="borderNone borderBottom" style="vertical-align:center;">
                    @if($businessEntityMasterData[0]->logo != null)
                    <!--Image--> 
                    <img class="img-responsive" alt="Pharmacy Logo" src="{{"data:image/jpeg;base64,".base64_encode( $businessEntityMasterData[0]->logo )}}"/>
                    @endif
                </th>
                <th colspan="14" class="borderNone borderBottom txtLeft">
                    <div style="line-height:1.0;" class="heading">{{ $businessEntityMasterData[0]->name }}</div>
                    <div style="line-height:1.0;">{{$businessEntityMasterData[0]->add1. " " .$businessEntityMasterData[0]->add2 ." ".$businessEntityMasterData[0]->city." : " .$businessEntityMasterData[0]->pincode }}</div>
                    <div style="line-height:1.0;">{{"Phone : ".$businessEntityMasterData[0]->tel1}}</div>
                </th>
            </tr>
            @php 
            $currentTime  = \Carbon\Carbon::now(); 

            @endphp

            <tr>

                <th colspan="2" class="th borderNone borderBottom reportTitle " >Leave Entitlement Report</th>
                <th class="th borderNone borderBottom txtRight " >Leave Period :        </th>
                <th colspan="2" class="th borderNone borderBottom txtRight" >Leave Type :  </th>
                <th colspan="2" class="th borderNone borderBottom txtRight" > Carry Fowrad Limit: {{ $leaveRules->carry_limit }}     </th>
                <th  colspan="8" class="txtRight th borderNone borderBottom">As on: {{$currentTime->format('d/m/Y H:i:s ')}}</th>
            </tr>

            <tr>
                <th  width="5%" class=" alignTop borderTopBottom " >Sr No.</th>
                <th  width="10%" class=" alignTop borderTopBottom " >Employee Id</th>
                <th  width="30%" class=" alignTop borderTopBottom " >Employee Name</th>
                <th  width="5%" class=" alignTop borderTopBottom " >Status</th>
                <th  width="10%" class=" alignTop borderTopBottom " >Hire Date</th>
                <th  width="10%" class=" alignTop borderTopBottom " >Conform Date</th>
                <th  width="10%" class=" alignTop borderTopBottom " >Last Working Date</th>
                <th  width="10%" class=" alignTop borderTopBottom " ></th>
                <th  width="10%" class=" alignTop borderTopBottom " >Month Upto</th>                    
                <th  width="10%" class=" alignTop borderTopBottom " ></th>                    
                <th  width="7%" class=" alignTop borderTopBottom txtLeft">Leave Entitlements  </th>
                <th  width="8%" class=" alignTop borderTopBottom txtLeft">Leave Taken Till Now  </th>
                <th  width="8%" class="alignTop borderTopBottom txtLeft">Leave Balance</th>
                <th  width="8%" class="alignTop borderTopBottom txtLeft">Projected Leave Balance</th>
                <th  width="8%" class="alignTop borderTopBottom txtLeft">Deduction Leave</th>
                <th  width="8%" class="alignTop borderTopBottom txtLeft">Carry Forward Leave</th>       
                <th  width="2%" class="alignTop borderTopBottom txtLeft"></th>

            </tr>
            @if($type=="D")
            <tr>
                <td  class=" alignTop borderTopBottom " ></td>
                <td  class=" alignTop borderTopBottom " ></td>
                <td  class=" alignTop borderTopBottom " ></td>                    
                <td  class=" alignTop borderTopBottom " ></td>                    
                <td  class=" alignTop borderTopBottom " ></td>                    
                <td  class=" alignTop borderTopBottom " ></td>
                <td  class=" alignTop borderTopBottom " ></td>
                <td  class=" alignTop borderTopBottom " >Type</td>
                <td  class=" alignTop borderTopBottom " >Leave Month</td> 
                <td  class=" alignTop borderTopBottom " >Opening Balance</td>                    
                <td  class=" alignTop borderTopBottom txtLeft"  >New Leave</td>
                <td  class=" alignTop borderTopBottom txtLeft"  >Leave Taken</td>
                <td  class="alignTop borderTopBottom txtLeft">closing Balance</td>
                <td  class="alignTop borderTopBottom txtLeft"></td>
                <td  class="alignTop borderTopBottom txtLeft">Laps</td>
                <td  class="alignTop borderTopBottom txtLeft">Modify Date</td>
            </tr>
            @endif
        </thead>
        <tbody>
                
            @foreach($leaveEnt as $key=>$leaveEnt)
                @php
                    $result = ($leaveEnt->entitlement - $leaveEnt->leave_taken);
                    
                    $get_period=$date;
                    $get_period=explode(' - ',$get_period);
                    $year=date('Y',strtotime($get_period[0]));
                    
                    $end_date=$year.'-'.$leavePeriod->start_month.'-'.$leavePeriod->start_day;
                    $end_date = date('Y-m',strtotime("+1 Year",strtotime($end_date)));
                    $end_date = date('Y-m',strtotime("-1 Month",strtotime($end_date)));
                    
                    $start_date = date('Y-m',strtotime($leaveEnt->month_up_to));
                    
                    $ts1 = strtotime($start_date);
                    $ts2 = strtotime($end_date);

                    $year1 = date('Y', $ts1);
                    $year2 = date('Y', $ts2);
                    
                    $month1 = date('m', $ts1);
                    $month2 = date('m', $ts2);
                    
                    $diff = (($year2 - $year1) * 12) + ($month2 - $month1);
                    
                    
                    if($leaveRules->accrue_frequency_year1=="Y")
                    {
                        if($leaveRules->accrre_when=="S")
                        {
                            $Projected_leave=$result;
                        }
                        else {
                            $Projected_leave=$leaveRules->accrue_days+$result;
                        }
                    }
                    else {
                        $Projected_leave=($diff*($leaveRules->accrue_days/12))+$result;
                    }
                    if($Projected_leave>$leaveRules->carry_limit)
                    {
                        $deduction_leave=$Projected_leave-$leaveRules->carry_limit;
                    }
                    else {
                        $deduction_leave=0;
                    }
                @endphp
                <tr>  
                    <th class="alignTop borderTopBottom">{{$count}}</th>
                    <th class="alignTop borderTopBottom">{{$leaveEnt->employee_id}}</th>
                    <th class="alignTop borderTopBottom">{{$leaveEnt->employee_name }}</th>
                    <th class="alignTop borderTopBottom">{{$leaveEnt->employee_status }}</th>
                    <th class="alignTop borderTopBottom">{{date("d/m/Y",strtotime($leaveEnt->employee_hire_date))}}</th>
                    <th class="alignTop borderTopBottom">{{date("d/m/Y",strtotime($leaveEnt->confirmation_date))}}</th>
                    <th class="alignTop borderTopBottom">{{$leaveEnt->last_working_date!=null?date("d/m/Y",strtotime($leaveEnt->last_working_date)):'' }}</th>
                    <th class="alignTop borderTopBottom"></th>
                    <th class="alignTop borderTopBottom">{{date("d/m/Y",strtotime($leaveEnt->month_up_to)) }}</th>
                    <th class="alignTop borderTopBottom"></th>                    
                    <th class="alignTop borderTopBottom">&nbsp;{{$leaveEnt->entitlement}}</th>
                    <th class="alignTop borderTopBottom">&nbsp;{{$leaveEnt->leave_taken}}</th>
                    <th class=" alignTop borderTopBottom">&nbsp; </th>
                    <th class=" alignTop borderTopBottom">&nbsp; </th>
                    <th class=" alignTop borderTopBottom">&nbsp; </th>
                    <th class=" alignTop borderTopBottom">&nbsp;0 </th>
                    <th class=" alignTop borderTopBottom">&nbsp;</th>
                                        {{-- <td class=" alignTop borderTopBottom">&nbsp;{{ $empdir->department_name }}</td>                    
                    <td class=" alignTop borderTopBottom">&nbsp;{{ $empdir->employee_gender }}</td>
                    <td class="alignTop borderTopBottom">&nbsp;{{ $empdir->contract_start_date }}</td>
                    <td class="alignTop borderTopBottom">&nbsp;{{ $empdir->employee_dob }}</td> --}}
                </tr>
                @if($type=="D")
                    @if(isset($leave_entitlement_report))
                        @foreach($leave_entitlement_report[$leaveEnt->leave_period_from][$leaveEnt->employee_id] as $key=>$item)
                                <tr>
                                    <td class="alignTop borderTopBottom"></td>
                                    <td class="alignTop borderTopBottom"></td>
                                    <td class="alignTop borderTopBottom"></td>
                                    <td class="alignTop borderTopBottom"></td>
                                    <td class="alignTop borderTopBottom"></td>
                                    <td class="alignTop borderTopBottom"></td>
                                    <td class="alignTop borderTopBottom"></td>
                                    <td class="alignTop borderTopBottom">{{$item->data_type=='C'?'Calculated':'Added'}}</td>
                                    <td class="alignTop borderTopBottom">{{date("d/m/Y",strtotime($item->leave_month))}}</td>
                                    <td class="alignTop borderTopBottom">{{$item->op_balance}}</td>                    
                                    <td class="alignTop borderTopBottom">&nbsp;{{$item->new_leaves}}</td>
                                    <td class="alignTop borderTopBottom">&nbsp;{{$item->leave_taken}}</td>
                                    <td class=" alignTop borderTopBottom">&nbsp;{{$item->cl_balance}}</td>
                                    <td class=" alignTop borderTopBottom">&nbsp; </td>
                                    <td class=" alignTop borderTopBottom">&nbsp;{{$item->entitlement_laps}}</td>
                                    <td class=" alignTop borderTopBottom">&nbsp;{{ ($item->lastmodified_date!=null)? date("d/m/Y",strtotime($item->lastmodified_date)) : '' }}</td>
                                </tr>
                        @endforeach
                    @endif 
                @endif       
            @endforeach    
        
            {{-- <tr>--}}
                        {{-- <td class="txtCenter" colspan="7">{{ $empData->appends(['search' => $search,'searchColumn' => $searchColumn,'searchType' => $searchType])->links() }}</td> --}}
            {{-- </tr> --}} 
        </tbody>
        <tfoot>
        <td colspan="16" class="th smallFont noPadding alignTop borderTopBottom txtRight">{{ strtoupper(Session::get('userId'))." # ".$currentTime->format('d/m/Y H:i:s ')}}</td>
        </tfoot>
    </table>

    <!--Print--> 
    <div class="col-xs-12" style="margin-bottom:15px;">
        <div class="col-xs-5 col-lg-offset-5 no-print">
            <button class="btn btn-sm btn-info" id="btnexport" data-myval="Employee Leave Entitlement Report">
                <span class="glyphicon glyphicon-download-alt"></span> Excel
            </button>
            <button onclick="print()" class="btn btn-sm btn-success no-print">
                <span class="glyphicon glyphicon-print"></span> Print
            </button>
            <a href="{{ url('leaveentitlementsrep') }}" class="no-print btn btn-danger btn-sm">
                <span class="glyphicon glyphicon-arrow-left"></span> Back
            </a>
        </div>
    </div>

</div>
@endsection

<!--Bootstrap Modals-->      
@section('BootstrapModals')
@endsection
<!--Bootstrap Modals Close-->

<!--External JS-->
@section('ExternalJs')
@endsection
<!--External JS Close-->