@extends('Reports.template')

<!--Title-->
@section('title')
Employee 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 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="{{sizeOf($column_name)+3}}" 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="3" class="th borderNone borderBottom reportTitle " >Employee Report</th>
                <th colspan="{{ sizeOf($column_name)+2 }}" class="txtRight th borderNone borderBottom">As on: {{$currentTime->format('d/m/Y H:i:s ')}}</th>
            </tr>

            <tr>
                <th class=" alignTop borderTopBottom " >Emp ID</th>                    
                <th class=" alignTop borderTopBottom ">Name  </th>
                {{-- <th class="alignTop borderTopBottom">Designation</th>
                <th class="alignTop borderTopBottom">Department</th> --}}
                @if ($supervisors=="Yes")
                    <th class="alignTop borderTopBottom">Supervisors</th>
                @endif
                @if(isset($column_name))
                    @foreach ($column_name as $column)
                        <th class="alignTop borderTopBottom">{{ $column }}</th>
                    @endforeach
                @endif
                @if(isset($select_head))
                    @foreach ($select_head as $column)
                        <th class="alignTop borderTopBottom">{{ $column }}</th>
                    @endforeach
                @endif
            </tr>
        </thead>
        <tbody>

            @foreach($empData as $key=>$empdir)
                @php 
                    if ($supervisors=="Yes")    
                    {
                        $reporting_name='';
                        foreach($reporting_employee_name as $reporting_key=>$reporting_empdir)
                        {
                            if($reporting_key==$empdir->employee_id)
                            {
                                $reporting_name=implode(',<br>',$reporting_empdir);
                            }
                        }
                    }
                @endphp
            <tr>  
                <td class="alignTop borderTopBottom">{{$empdir->employee_id }}</td>
                <td class="alignTop borderTopBottom">&nbsp;{{ $empdir->employee_name }}</td>
                @if ($supervisors=="Yes")
                    <td class="alignTop borderTopBottom">{!! $reporting_name !!}</td>
                @endif
                @if(isset($column_name))
                    @foreach ($columnDisplayValue as $column)
                        @php
                            $display_value=$empdir->$column;
                            if($column=="employee_gender")
                            {
                                if($empdir->$column=='M')
                                {
                                    $display_value="Male";
                                }
                                else if($empdir->$column=='F') 
                                {
                                    $display_value="Female";
                                }
                            }

                            if($column=="employee_dob" || $column=="employee_hire_date" || $column=="probation_completion_date" || $column=="confirmation_date" || $column=="absconded_date" || $column=="resigned_date" || $column=="last_working_date")
                            {
                                if($empdir->$column!="" && $empdir->$column!="0000-00-00")
                                {
                                    $display_value=date('d/m/Y',strtotime($empdir->$column));
                                }
                                else
                                {
                                    $display_value='';
                                }
                            }

                            if($column=="employee_marital_status")
                            {
                                if($empdir->$column=='M')
                                {
                                    $display_value="Married";
                                }
                                else if($empdir->$column=='U') 
                                {
                                    $display_value="Un-Married";
                                }
                                else if($empdir->$column=='D') 
                                {
                                    $display_value="Divorced";
                                }
                                else if($empdir->$column=='W') 
                                {
                                    $display_value="Widowed";
                                }
                            }

                            if($column=="employee_department_id")
                            {
                                $display_value=$empdir->department_name;
                            }

                            if($column=="employee_job_title_id")
                            {
                                $display_value=$empdir->job_title_name;
                            }

                            if($column=="employee_job_category_id")
                            {
                                $display_value=$empdir->job_category_name;
                            }
                        @endphp
                        <td class=" alignTop borderTopBottom">{{ $display_value }}</td>
                    @endforeach
                @endif
                @foreach ($salary_employee_details as $key=>$value)
                    @if ($key==$empdir->employee_id)
                        @foreach ($value as $v)
                            <td class=" alignTop borderTopBottom">{{ $v }}</td>
                        @endforeach
                    @endif
                @endforeach
            </tr>
            @endforeach

        </tbody>
        <tfoot>
        <td colspan="{{ sizeOf($column_name)+5 }}" 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 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('employeereport') }}" 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-->