@extends('app') @section('page-title')
<div class="row bg-title">

    <!-- .page title -->
    <div class="col-lg-8 col-md-5 col-sm-6 col-xs-12">
        <h4 class="page-title"><i class="icon-people"></i> Attendance
            <!-- <span class="text-info b-l p-l-10 m-l-5"></span> <span class="font-12 text-muted m-l-5"> @lang('modules.dashboard.totalClients')</span> -->
        </h4>
    </div>
    <!-- /.page title -->
    <!-- .breadcrumb -->
    <div class="col-lg-4 col-sm-6 col-md-7 col-xs-12 text-right">

    </div>
    <!-- /.breadcrumb -->
</div>
@endsection @push('head-script')
<link rel="stylesheet" href="https://cdn.datatables.net/1.10.13/css/dataTables.bootstrap.min.css">
<link rel="stylesheet" href="https://cdn.datatables.net/responsive/2.1.1/css/responsive.bootstrap.min.css">
<link rel="stylesheet" href="//cdn.datatables.net/buttons/1.2.2/css/buttons.dataTables.min.css">
<link rel="stylesheet" href="//cdn.datatables.net/buttons/1.2.2/css/buttons.dataTables.min.css">
<link rel="stylesheet" href="/assets/plugins/bower_components/bootstrap-select/bootstrap-select.min.css">
<link rel="stylesheet" href="/assets/plugins/bower_components/custom-select/custom-select.css">
<link rel="stylesheet" href="/assets/plugins/bower_components/bootstrap-datepicker/bootstrap-datepicker.min.css"> @endpush @section('content')
<link rel="stylesheet" href="/assets/css/daterangepicker.css">

<div class="row">

    <div class="col-xs-12">

        <section class="col-lg-12 connectedSortable">
                <div class="row">
                    <div class="col-lg-2">
                        <div class="form-label-group">
                            <label for="date_range">Date range</label>
                            <input type="text" id="date_range" name="date_range" class="form-control daterangebg" value="{{$dateRange}}"> {!! $errors->first('date_range', '<label class="control-label" for="date_range">:message</label>')!!}
                        </div>
                    </div>
					
					<div class="col-lg-2">
                        <div class="form-label-group">
                            <label for="date_range">Holiday</label>
                            <select class="form-control select2" id="holiday_date" name="holiday_date" class="form-control">
								<option value="">Select Holiday</option>
								@foreach($holidays as $holiday)
									<option value="{{$holiday->date}}">
										{{$holiday->name}} ({{$holiday->date}})
									</option>
								@endforeach
							</select>
                        </div>
                    </div>
					
                    <div class="col-lg-2">
                        <div class="form-label-group">
                            <label for="date_range">Select Shifts</label>
                            <select class="form-control select2" id="type" name="shift_id" class="form-control">
								<option value="">Select shift name</option>
								@foreach($shifts as $shift)
									<option value="{{$shift->id}}" @if(isset($shiftId) && ($shiftId == $shift->id) || (old('shift_id') == $shift->id)) selected @endif>
										{{$shift->name}}({{$shift->start_time}} - {{$shift->end_time}})
									</option>
								@endforeach
							</select>
                        </div>
                    </div>

                    <div class="col-lg-2">
                        <div class="form-label-group">
                            <label for="date_range">Department</label>
                            <select class="form-control select2" id="department_id" class="form-control">
                                <option value="">Select Department</option>
                                @foreach($departments as $department)
                                    <option value="{{$department->id}}">
                                        {{$department->name}}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                    </div>

                    <div class="col-lg-2">
                        <div class="form-label-group">
                            <label for="date_range">Designation</label>
                            <select class="form-control select2" id="designation_id" class="form-control">
                                <option value="">Select Designation</option>
                                @foreach($designations as $designation)
                                    <option value="{{$designation->id}}">
                                        {{$designation->name}}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                    </div>
              
                    <div class="col-lg-2">
                        <div class="form-label-group">
                            <label for="date_range">Manager</label>
                            <select class="form-control select2" id="manager_id" class="form-control">
                                <option value="">Select Manager</option>
                                @foreach($managers as $manager)
                                    <option value="{{$manager['id']}}">
                                        {{$manager['name']}}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                    </div>
                </div>

                <div class="row" style="margin-top: 10px;margin-bottom: 10px;">
                    <div class="col-lg-2">
                        <div class="form-label-group">
                            <label for="date_range">Location</label>
                            <select class="form-control select2" id="location_id" class="form-control" onchange="getSubLocation(this.value)">
                                <option value="">Select Location</option>
                                @foreach($locations as $location)
                                    <option value="{{$location->id}}">
                                        {{$location->name}}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                    </div>

                    <div class="col-lg-2">
                        <div class="form-label-group">
                            <label for="date_range">Sub Location</label>
                            <select class="form-control select2" id="sublocation_id" class="form-control">
                                <option value="">Select Sub Location</option>
                                @foreach($subLocations as $subLocation)
                                    <option value="{{$subLocation->id}}">
                                        {{$subLocation->name}}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                    </div>
                    @if(Auth::user()->is_contractor==0)
                    <div class="col-lg-2">
                        <div class="form-label-group">
                            <label for="date_range">Contractor</label>
                            <select class="form-control select2" id="contractor_id" class="form-control">
                                <option value="">Select Contractor</option>
                                @foreach($contractors as $contractor)
                                    <option value="{{$contractor->id}}">
                                        {{$contractor->name}}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                    </div>
                    @endif

                    <div class="col-lg-2">
                        <div class="form-label-group">
                            <label for="date_range">Employee Type</label>
                            <select class="form-control select2" id="employee_type" class="form-control" onchange="getEmployeeByType(this.value)">
                                <option value="">Select Type</option>
                                @foreach($employeeTypes as $empType)
                                    <option value="{{$empType}}">
                                        {{$empType}}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                    </div>

                    <div class="col-lg-2">
                        <div class="form-label-group">
                            <label for="date_range">Employees</label>
                            <select class="form-control select2" id="employee_id" class="form-control">
                                <option value="">Select Employees</option>
                                @foreach($employees as $employee)
                                    <option value="{{$employee->id}}">
                                        {{$employee->name}}({{$employee->employee_code}})
                                    </option>
                                @endforeach
                            </select>
                        </div>
                    </div>
					
					<div class="col-lg-2">
                        <div class="form-label-group">
                            <label for="date_range">Early/Late</label>
                            <select class="form-control select2" id="earlylateOpt" class="form-control">
                                <option value="">Select Option</option>
                                <option value="early_comer">Early Comer</option>
                                <option value="late_comer">Late Comer</option>
                                <option value="early_depart">Early Depart</option>
                                <option value="late_depart">Late Depart</option>
                                
                            </select>
                        </div>
                    </div>

                    <div class="col-lg-2 mt-18">
                        <div class="form-label-group">
                            <label></label>
                            <button class="btn btn-secondary btn-radius mt-4" type="submit" onclick="attendanceFilter()">
							Search    
						</button>
                        </div>
                    </div>
                </div>
        </section>

        <div class="white-box">

            <div class="table-responsive">

                <div class="row">
                    <div class="col-md-12">
                        <table class="table table-bordered" id="organization">
                            <thead>
                                <th>ID</th>
                                <th>Employee Code</th>
                                <th>Employee Name</th>
                                <th>Employee Type</th>
                                <th>Attendance Date</th>
                                <th>Working Hours</th>
                                
                            </thead>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
<!-- .row -->

@endsection @push('footer-script')
<script src="/assets/plugins/bower_components/datatables/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/1.10.13/js/dataTables.bootstrap.min.js"></script>
<script src="https://cdn.datatables.net/responsive/2.1.1/js/dataTables.responsive.min.js"></script>
<script src="https://cdn.datatables.net/responsive/2.1.1/js/responsive.bootstrap.min.js"></script>
<script src="/assets/plugins/bower_components/custom-select/custom-select.min.js"></script>
<script src="/assets/plugins/bower_components/bootstrap-select/bootstrap-select.min.js"></script>
<script src="/assets/plugins/bower_components/bootstrap-datepicker/bootstrap-datepicker.min.js"></script>
<script src="/assets/plugins/bower_components/bootstrap-daterangepicker/daterangepicker.js"></script>
<script src="https://cdn.datatables.net/buttons/1.7.0/js/dataTables.buttons.min.js"></script>
<!-- <script src="/assets/js/datatables/buttons.server-side.js"></script> -->
<script src="/assets/js/moment.min.js"></script>
<script src="/assets/js/daterangepicker.js"></script>

<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js"></script>
<script src="https://cdn.datatables.net/buttons/1.7.0/js/buttons.html5.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.7.0/js/buttons.print.min.js"></script>

<script>
    $(document).ready(function() {

        $('#date_range').daterangepicker()
        callDt();
    });

    function callDt() {
	//alert($("#holiday_date").val())
       $('#organization').DataTable({
            language:{
                "infoFiltered":""
            },
            "processing": true,
            "serverSide": true,
            searching: true,
            dom: 'Bfrtip',
            buttons: [{
                extend: 'copy',
                exportOptions: {
                    columns: Array.from(Array($("#organization th").length - 1).keys())
                },
            }, {
                extend: 'csv',orientation:"landscape",
                exportOptions: {
                    columns: Array.from(Array($("#organization th").length - 1).keys())
                },
                action: serverSideButtonAction
            }, {
                extend: 'excel',orientation:"landscape",
                exportOptions: {
                    columns: Array.from(Array($("#organization th").length - 1).keys())
                },
                action: serverSideButtonAction
            }, {
                extend: 'pdf',orientation:"landscape",
                exportOptions: {
                    columns: Array.from(Array($("#organization th").length - 1).keys())
                },
                action: serverSideButtonAction
            }, {
                extend: 'print',
                exportOptions: {
                    columns: Array.from(Array($("#organization th").length - 1).keys())
                }
            }],
            "ajax": {
                "url": getUrl(),
                "dataType": "json",
                "type": "POST",
                "data": {
                    _token: "{{csrf_token()}}",
                    date_range: $("#date_range").val(),
                    shift_id: $("#type").val(),
                    department_id: $("#department_id").val(),
                    designation_id: $("#designation_id").val(),
                    manager_id: $("#manager_id").val(),
                    location_id: $("#location_id").val(),
                    contractor_id: $("#contractor_id").val(),
                    employee_type: $("#employee_type").val(),
                    employee_id: $("#employee_id").val(),
                    sublocation_id: $("#sublocation_id").val(),
                    earlylateOpt:$("#earlylateOpt").val(),
                    holiday_date:$("#holiday_date").val()

                },
                "fnServerParams": function(aoData) {
                    aoData.push({
                        date: new Date()
                    });
                },
            },
            "columns": [{
                "data": "id",
                render: function(data, type, row, meta) {
                    // console.log(row);
                    // console.log(meta);
                    return ($('#organization').DataTable().page.info().page*$('#organization').DataTable().page.info().length);
                }
            }, {
                "data": "employee.employee_code",
                "orderable": false,
            }, {
                "data": "employee.name",
                "orderable": false,
            }, {
                "data": "employee.employee_type",
                "orderable": false,
            }, {
                "data": "attendance_date",
                "orderable": false,
            }, {
                "data": "timeSum",
                "orderable": false,
            }]

        });
    }

    function getUrl() {
        return "{{ route('attendance.alldetails',['slug'=>$alias]) }}"
    }

    function attendanceFilter() {
        $("#organization").DataTable().destroy();
        callDt();
    }
    function getSubLocation (location_id) {
        var url = "{{route('getSublocation',['alias'=>$alias])}}?location_id=" + location_id;
        $.easyAjax({
            url: url,
            type: "GET",
            success: function (data) {
                op = '<option value="">Select Sub Location</option>';
                for (var i = 0; i < data.length; i++){
                    op += '<option value="'+data[i].id+'">'+data[i].name+'</option>';
                    
                }
                $('#sublocation_id').html(op);
            }
        });
    }

    function getEmployeeByType (employee_type) {
        var url = "{{route('employees-by-type',['alias'=>$alias])}}?employee_type=" + employee_type;
        $.easyAjax({
            url: url,
            type: "GET",
            success: function (data) {
                op = '<option value="">Select Employees</option>';
                for (var i = 0; i < data.length; i++){
                    op += '<option value="'+data[i].id+'">'+data[i].name+'('+data[i].employee_code+')</option>';
                    
                }
                $('#employee_id').html(op);
            }
        });

    }
</script>

@endpush