@extends('AdminLte.template')

<!--Title-->
@section('title')
Employee List
@endsection
<!--Title Close-->

<!--External CSS-->
@section('ExternalCss')
@parent
<style>
    table.dataTable thead .sorting_asc {
        background-image: url(../images/sort_asc.png) !important;
    }
    
    table.dataTable thead .sorting_desc {
        background-image: url(../images/sort_desc.png) !important;
    }
    
    table.dataTable thead .sorting {
        background-image: url(../images/sort_both.png);
    }
</style>
@endsection
<!--External CSS Close--> 

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

<!--View Content of database-->
<div class="table-responsive">
    <div class="col-md-12">
        <h3 style="margin-top:3px !important; margin-bottom:2px !important;" class="txtCenter">Employee List</h3>
        <br/>
        <!--Search functionality-->
        {{ Form::open(['action' => 'EmployeeListController@index','method' => 'POST','role' => 'search','autocomplete' => 'off']) }}
        <div class="col-md-10 padding3 borderSearchBox" >
            <div class="input-group" style="float:left;">
                <select data-placement="bottom" data-toggle="tooltip" title="Employee Status" name="status" class="form-control inputType">
                    <option value=""  selected="selected">ALL</option>
                    <option value="A" >Active</option>
                    <option value="R" >Resigned</option>
                    <option value="Ab" >Absconded</option>
                    <option value="S" >Separated</option>
                </select>
            </div>
            <div class="input-group" style="float:left;">
                <select name="searchColumn" class="form-control inputType">
                    <option value="all" >ALL</option>
                    <option value="em.employee_id" >Emp Id</option>
                    <option value="employee_name" >Name</option>
                    <option value="job_category_name" >Category</option>
                    <option value="department_name" >Department</option>
                    <option value="employee_master.employee_hire_date" >Hire Date</option>
                    <option value="employee_master.salary_type" >Salary Type</option>
                    <option value="employee_master.confirmation_date" >Confirmation Date</option>
                    <option value="employee_master.last_working_date" >Last Working Date</option>
                    <option value="uem.user_id" >User Id</option>
                    {{-- <option value="job_title_name" >Designation</option> --}}
                </select>
            </div>
            <div class="input-group" style="float:left;">
                <select name="searchType" class="form-control inputType">
                    <option value="contains" >Contains</option>
                    <option value="begins" >Begins with</option>
                    <option value=">" >Greater Than</option>
                    <option value="<" >Less Than</option>
                </select>
            </div>
            <div class="input-group col-md-6" style="float:left;">
                <input type="text" class="form-control textBox txtUpperCase" value="{{ $search}}" name="search" placeholder="Search"> 
                <span class="input-group-btn">
                    <button type="submit" class="btn btn-sm btn-primary inputType "> <span class="glyphicon glyphicon-search"></span></button></span>
            </div>
            {{ Form::close() }}
            <!--End Search functionality-->
        </div>
        <br><br>
        <table id="employee_table" class="table commonFontSize">
            <thead>
                <tr>
                    <th class="th info txtRight borderTopBottom">Emp Id</th>
                    <th class="th info borderTopBottom">Name</th>
                    <th class="th info txtLeft borderTopBottom">Category</th>
                    <th class="th info textRight borderTopBottom">Department</th>
                    <th class="th info txtLeft borderTopBottom">Hire Date</th>
                    <th class="th info txtLeft borderTopBottom">Salary Type</th>
                    <th class="th info txtLeft borderTopBottom">Confirmation Date</th>
                    <th class="th info txtLeft borderTopBottom">Last Working Date</th>
                    <th class="th info txtLeft borderTopBottom">User Id</th>
                    <th class="th info txtLeft borderTopBottom">Supervisour Setup</th>
                    <th class="th info txtLeft borderTopBottom">Status</th>
                    <th class="th info txtLeft borderTopBottom">Final Status</th>
                </tr>
            </thead>
            <tbody>
                                @foreach($emplistData as $key=>$emplist)
                    @php
                        $employeeStatus = '';
                        $employeeFinalStatus = '';
                        if($emplist->employee_status === 'A')
                            $employeeStatus = 'Active';
                        elseif($emplist->employee_status === 'R')
                            $employeeStatus = 'Resigned';
                        elseif($emplist->employee_status === 'Ab')
                            $employeeStatus = 'Absconded';
                        else
                            $employeeStatus = 'Separated';

                        if($emplist->absconded_date != null){
                            $employeeFinalStatus = 'Absconded';
                        }
                        else if($emplist->resigned_date != null){
                            $employeeFinalStatus = 'Resigned';
                        }else{
                            $employeeFinalStatus = $employeeStatus;
                        }
                        
                        $error_msg="";
                        $error=0;
                        $comf=0;
                        $last=0;
                        if($emplist->probation_completion_date==NULL)
                        {
                            $error=1;
                            $error_msg.="Probation completion date not available. ";
                        }
                        else if($emplist->probation_completion_date<date('Y-m-d') && $emplist->is_confirmed=="N")
                        {
                            $error=1;
                            $comf=1;
                            $error_msg.="\nProbation completion date has passed but confirmation is not done. ";
                        }

                        if($emplist->user_id=="")
                        {
                            $error=1;
                            $error_msg.="\nUser Id Setup not done. ";
                        }

                        if($emplist->reporting==0)
                        {
                            $error=1;
                            $error_msg.="\nSupervisour Setup not done. ";
                        }

                        if($emplist->employee_hire_date=='')
                        {
                            $error=1;
                            $error_msg.="\nHire date not available. ";
                        }

                        if(($emplist->employee_status === 'R' || $emplist->employee_status === 'Ab') && $emplist->last_working_date=='')
                        {
                            $error=1;
                            $last=1;
                            $error_msg.="\nLast Working date not available. ";
                        }

                        if($emplist->salary_type=='')
                        {
                            $error=1;
                            $error_msg.="\nSalary details not available. ";
                        }

                        $class="";
                        if($error==1)
                        {
                            $class="danger";
                        }
                    @endphp
                <input type="hidden" name="emp_id" value="{{$emplist->employee_id}}">   
                <tr class="{{ $class }}" title="{{ $error_msg }}"> 
                    <td class="td txtRight borderTopBottom vMiddle"><a name="emp_id" href="tab/{{$emplist->employee_id }}">{{$emplist->employee_id }}</a></td>                    
                    <td class="td borderTopBottom vMiddle">&nbsp;{{ $emplist->employee_name }}</td>
                    <td class="td borderTopBottom vMiddle">&nbsp;{{ $emplist->job_category_name }}</td>
                    <td class="td borderTopBottom vMiddle">&nbsp;{{ $emplist->department_name }}</td>                    
                    @if ($emplist->employee_hire_date!='')    
                        <td class="td borderTopBottom vMiddle">&nbsp;{{ date("d-m-Y",strtotime($emplist->employee_hire_date)) }}</td>
                    @else
                        <td class="td borderTopBottom vMiddle">&nbsp;<font color="red">---</font></td>
                    @endif
                    @if ($emplist->salary_type!='')    
                        <td class="td borderTopBottom vMiddle">&nbsp;{{ $emplist->salary_type }}</td>
                    @else
                        <td class="td borderTopBottom vMiddle">&nbsp;<font color="red">Not Defined</font></td>
                    @endif
                    @if ($comf==0)
                        <td class="td borderTopBottom vMiddle">&nbsp;{{ $emplist->confirmation_date!=''?date("d-m-Y",strtotime($emplist->confirmation_date)):'---' }}</td>
                    @else
                    <td class="td borderTopBottom vMiddle">&nbsp;<font color="red">---</font></td>
                    @endif
                    @if ($last==0)
                        <td class="td borderTopBottom vMiddle">&nbsp;{{ $emplist->last_working_date!=''?date("d-m-Y",strtotime($emplist->last_working_date)):'---' }}</td>
                    @else
                    <td class="td borderTopBottom vMiddle">&nbsp;<font color="red">---</font></td>
                    @endif
                    @if($emplist->user_id!='')
                        <td class="td borderTopBottom vMiddle">&nbsp;{{ $emplist->user_id }}</td>
                    @else
                        <td class="td borderTopBottom vMiddle">&nbsp;<font color="red">No</font></td>
                    @endif
                    @if($emplist->reporting==0)
                        <td class="td borderTopBottom vMiddle">&nbsp;<font color="red">No</font></td>
                    @else
                        <td class="td borderTopBottom vMiddle">&nbsp;{{ 'Yes -'.$emplist->reporting }}</td>
                    @endif
                    <td class="td borderTopBottom vMiddle">&nbsp;{{$employeeStatus}}</td>
                    <td class="td borderTopBottom vMiddle">&nbsp;{{$employeeFinalStatus}}</td>
                </tr>
            @endforeach
            {{-- <tr>
                <td class="txtCenter" colspan="7">{{ $emplistData->appends(['search' => $search,'searchColumn' => $searchColumn,'searchType' => $searchType,'status' => $status])->links() }}</td>
            </tr> --}}
            </tbody>
        </table>

        <div class="col-md-4 col-md-offset-3">
            @if(session()->has('successMessage'))
            <div class="alert alert-success alert-dismissible fade in col-sm-12">
                <a href="#" class="close" data-dismiss="alert" aria-label="close">&times;</a>
                {{ session()->get('successMessage') }}
            </div>
            @endif
            @if(session()->has('errorMessage'))
            <div class="alert alert-danger alert-dismissible fade in col-sm-12">
                <a href="#" class="close" data-dismiss="alert" aria-label="close">&times;</a>
                {{ session()->get('errorMessage') }}
            </div>
            @endif
        </div>

    </div>
</div>
@endsection

<!--External JS-->
@section('ExternalJs')
<script>
    $(document).ready(function() {
        $('#employee_table').DataTable({
            lengthMenu: [
                [ 20, 25, 50, -1 ],
                [ '20 rows', '25 rows', '50 rows', 'Show all' ]
            ],
            "pageLength": 20,
        });
    });
</script>
@endsection
<!--External JS Close-->