@extends('layouts.organization.app')
@section('content')

<div class="main-panel">
    <div class="content-wrapper">
        <div class="row">
            <div class="card-body">
                <div class="row">
                <div class="col-12 stretch-card overall_report">
                    <div class="card">
                        <div class="card-header card-height">
                            <div class="row">
                                <div class="col-md-12 col-12">
                                    <h5 class="">Sort Attendence Report</h5>
                                </div>
                            </div>
                        </div>
                        <div class="card-body">
                            <form action="" method="POST" class="mb-4">
                                @csrf
                                <div class="form-row align-items-center">
                                    <div class="col-md-2">
                                        <select name="months" class="form-control">
                                            <option value="">--Select Month--</option>
                                            <option value="01-02">Jan-Feb</option>
                                            <option value="03-04">March-April</option>
                                            <option value="05-06">May-June</option>
                                            <option value="07-08">July-Aug</option>
                                            <option value="09-10">Sept-Oct</option>
                                            <option value="11-12">Nov-Dec</option>
                                        </select>
                                    </div>
                                    <div class="col-md-2">
                                        <select name="years" class="form-control">
                                            <option value="">--Select Year--</option>
                                            @for($y=date("Y")-5; $y<=date("Y"); $y++)
                                                <option value="{{$y}}">{{$y}}</option>
                                            @endfor
                                        </select>
                                    </div>
                                    <div class="col-md-2 ">
                                        <select name="department_id" onchange="get_department_id(this.value)" class="form-control">
                                            <option value="">--Select Department--</option>
                                            @if(!empty($department))
                                                @foreach($department as $depa)
                                                    <option value="{{$depa->id}}">{{$depa->department_name}}</option>
                                                @endforeach
                                            @endif
                                        </select>
                                    </div>
                                    <div class="col-md-2 ">
                                        <select name="employee_id" class="form-control employee_id">
                                            
                                        </select>
                                    </div>
                                    <div class="col-md-2 simpl-btn">
                                        <button class="btn btn-info" style="padding: 10px;">Search</button>
                                    </div>
                                </div>
                            </form>
                            <form action="" method="POST" class="mb-4">
                                @csrf
                                <div class="form-row align-items-center mt-4">
                                    <div class="col-md-2 ">
                                        <select name="department_id" onchange="get_department_id(this.value)" class="form-control">
                                            <option value="">--Select Department--</option>
                                            @if(!empty($department))
                                                @foreach($department as $depa)
                                                    <option value="{{$depa->id}}">{{$depa->department_name}}</option>
                                                @endforeach
                                            @endif
                                        </select>
                                    </div>
                                    <div class="col-md-2 ">
                                        <select name="employee_id" class="form-control employee_id">
                                        
                                        </select>
                                    </div>
                                    <div class="col-md-2 ">
                                        <input type="date" class="form-control" id="from_datex" name="from_date">
                                    </div>
                                    <div class="col-md-2 ">
                                        <input type="date" class="form-control" id="to_datex" name="to_date">
                                    </div>
                                    <div class="col-md-2">
                                        <select name="shift" class="form-control">
                                            <option value="">--Select Shift--</option>
                                            @if(!empty($shift)) @foreach($shift as $shift)
                                                <option value="{{$shift->id}}">{{$shift->shift_name}}</option>
                                            @endforeach @endif
                                        </select>
                                    </div>
                                    <div class="col-md-2 simpl-btn">
                                        <button class="btn btn-info" style="padding: 10px;">Search</button>
                                    </div>
                                </div>
                            </form>
                            <table id="examples" class="display" style="width:100%">
                                <thead>
                                    <tr class="c">
                                        <th>Sr No.</th>
                                        <th>Employee Name</th>
                                        <th>Office Name</th>
                                        <th>Department Name</th>
                                        <th>Out Time</th>
                                        <th>Shift Time</th>
                                        <th>Sort By</th>
                                        <th>Out Image</th>
                                        <th>Date</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @if(!empty($overall_employees))
                                        @foreach($overall_employees as $row)
                                            <tr>
                                                <td>{{$loop->iteration}}</td>
                                                <td>{{$row->name}}</td>
                                                <td>{{$row->office_name}}</td>
                                                <td>{{$row->department_name}}</td>
                                                <td>{{$row->out_time}}</td>
                                                <td>{{$row->shift_time}}</td>
                                                <td>{{$row->latecome}}</td>
                                                <td>
                                                    @if(!empty($row->out_image))
                                                        <img src="{{asset('employee/attendance/')}}/{{$row->out_image}}" class="img-responsive" height="50px;" width="50px;"> 
                                                    @else
                                                        NA 
                                                    @endif
                                                </td>
                                                <td>{{date('d M, Y', strtotime($row->created_at))}}</td>
                                            </tr>
                                        @endforeach
                                    @endif
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
<script>
$(document).ready(function() {
    $('#examples').DataTable({
        dom: 'Bfrtip',
        buttons: ['excel', 'pdf', 'print', 'copy', 'csv', 'email'],
        "bPaginate": true
    });
});
function get_department_id(id) {
    var spinner = $('#loader');
    spinner.show();
    $('.employee_id').empty();
    $.ajax({
        type: "POST",
        headers: {'X-CSRF-TOKEN': $('meta[name="csrf_token"]').attr('content')},
        url: "{{url('ajax-department-emp')}}",
        data: { department_id: id},
        success: function(xhr) {
            var datas = xhr.data;
            $('.employee_id').append('<option value="">--Select Employee--</option>');
            for (var i = 0; i < datas.length; i++) {
                $('.employee_id').append('<option value="'+datas[i].id+'">'+datas[i].name+' ( '+datas[i].employee_code+' )</option>');
            }
            spinner.hide();
        },error:function(xhr){
            spinner.hide();
            alert(xhr.responseText);
        }
    });
}
</script>
@endsection('content')