@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> Employee IN/OUT
            <!-- <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')

<div class="row">

    <div class="col-xs-12">
        <div class="white-box content">

            <form method="get">
                <div class="row mb-15">
                    <div class="col-sm-4 col-md-4 col-lg-4">
                        <div class="form-label-group {{{ $errors->has('date') ? 'has-error' : '' }}}">
                            <input type="date" name="date" value="{{$date}}" class="form-control">
                        </div>
                    </div>
                    <div class="col-sm-1 col-md-1 col-lg-1">
                        <button class="btn-success btn-sm" type="submit">Submit</button>
                    </div>
                    <!-- <div class="col-sm-1 col-md-1 col-lg-1">
						<button class="btn-danger btn-sm">Search</button>
					</div> -->
                </div>
            </form>
            <div class="row">
                <div class="col-sm-6 col-md-6 col-lg-6">
                    <div class="row">
                        <div class="card">
                            <div class="card-body pl-0 pr-0">
                                <div class="table-responsive">
                                    <table class="table table-bordered table newtabstriped border-0" cellspacing="0" width="100%" id="dataGrid">
                                        <thead>
                                            <tr>
                                                <th>TIME SPAN</th>
                                                <th>IN</th>
                                                <th>OUT</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <tr>
                                                <td>BETWEEN 12AM-08AM</td>
                                                <td>{{$am12Toam8AttendanceInData}}</td>
                                                <td>{{$am12Toam8AttendanceOutData}}</td>
                                            </tr>
                                            <tr>
                                                <td>BETWEEN 08AM-10AM</td>
                                                <td>{{$am8Toam10AttendanceInData}}</td>
                                                <td>{{$am8Toam10AttendanceOutData}}</td>
                                            </tr>
                                            <tr>
                                                <td>BETWEEN 10AM-12PM</td>
                                                <td>{{$am10Toam12AttendanceInData}}</td>
                                                <td>{{$am10Toam12AttendanceOutData}}</td>
                                            </tr>
                                            <tr>
                                                <td>BETWEEN 12PM-02PM</td>
                                                <td>{{$am12Toam14AttendanceInData}}</td>
                                                <td>{{$am12Toam14AttendanceOutData}}</td>
                                            </tr>
                                            <tr>
                                                <td>BETWEEN 02PM-04PM</td>
                                                <td>{{$am14Toam16AttendanceInData}}</td>
                                                <td>{{$am14Toam16AttendanceOutData}}</td>
                                            </tr>
                                            <tr>
                                                <td>BETWEEN 04PM-08PM</td>
                                                <td>{{$am16Toam20AttendanceInData}}</td>
                                                <td>{{$am16Toam20AttendanceOutData}}</td>
                                            </tr>
                                            <tr>
                                                <td>BETWEEN 08PM-12AM</td>
                                                <td>{{$am20Toam24AttendanceInData}}</td>
                                                <td>{{$am20Toam24AttendanceOutData}}</td>
                                            </tr>
                                            <tr>
                                                <td>
                                                    <strong>TOTAL</strong>
                                                </td>
                                                <td>
                                                    <strong>{{$totalIn}}</strong>
                                                </td>
                                                <td>
                                                    <strong>{{$totalOut}}</strong>
                                                </td>
                                            </tr>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

                <div class="col-sm-6 col-md-6 col-lg-6">
                    <div class="card">
                        <div class="card-body pl-0 pr-0">
                            <div class="table-responsive">
                                <table class="table table-striped table-bordered admintable table newtabstriped border-0" cellspacing="0" width="100%" id="dataGrid1">
                                    <thead>
                                    </thead>
                                    <tbody>
                                        <tr>
                                            <td>
                                                <strong>TOTAL IN</strong>
                                            </td>
                                            <td>
                                                <strong>{{$totalIn}}</strong>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td>
                                                <strong>TOTAL OUT</strong>
                                            </td>
                                            <td>
                                                <strong>{{$totalOut}}</strong>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td>
                                                <strong>FINAL OUT(WITH IN & OUT)</strong>
                                            </td>
                                            <td>
                                                <strong>{{$finalInOutData}}</strong>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td>
                                                <strong>ONLY OUT</strong>
                                            </td>
                                            <td>
                                                <strong>{{$totalOut - $finalInOutData}}</strong>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td>
                                                <strong>BALANCE IN</strong>
                                            </td>
                                            <td>
                                                <strong>{{$totalIn - $finalInOutData}}</strong>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td>
                                                <strong>BALANCE IN(12AM - 08AM)</strong>
                                            </td>
                                            <td>
                                                <strong>{{$balanceIn12To08Data}}</strong>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td>
                                                <strong>BALANCE IN(08AM - 12M)</strong>
                                            </td>
                                            <td>
                                                <strong>{{$balanceIn8To12Data}}</strong>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td>
                                                <strong>BALANCE IN(12PM - 04PM)</strong>
                                            </td>
                                            <td>
                                                <strong>{{$balanceIn12To16Data}}</strong>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td>
                                                <strong>BALANCE IN(04PM - 12AM)</strong>
                                            </td>
                                            <td>
                                                <strong>{{$balanceIn16To24Data}}</strong>
                                            </td>
                                        </tr>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </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="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() {
       $('#organization').DataTable({
            language:{
                "infoFiltered":""
            },
            "processing": true,
            "serverSide": true,
            dom: 'Bfrtip',
            buttons: [
                {
                extend: 'copy',
                exportOptions: {
                    columns: Array.from(Array($("#organization th").length-1).keys())
                },
            },
            {
                extend: 'csv',
                exportOptions: {
                    columns: Array.from(Array($("#organization th").length-1).keys())
                },
            },
            {
                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": "{{ route('notification.all',['slug'=>$alias]) }}",
                "dataType": "json",
                "type": "POST",
                "data": {
                    _token: "{{csrf_token()}}"
                }
            },
            "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)+(meta.row + 1);
                }
            }, {
                "data": "title",
            }, {
                "data": "description",
            }, {
                "data": "created_at",
                "orderable": false,
            }],

        });
    });
</script>

@endpush