@extends('layouts.app')


@push('title')
    דוח ריכוז
@endpush

@push('pg_btn')
    <a href="{{route('client.index')}}" class="btn btn-sm btn-neutral">חזרה </a>
@endpush

@push('styles')
    <link href="https://cdn.datatables.net/1.13.1/css/jquery.dataTables.css" rel="stylesheet">
    <link href="https://cdn.datatables.net/buttons/1.5.1/css/buttons.dataTables.min.css" rel="stylesheet"/>
    <link href="https://cdn.datatables.net/1.13.1/css/dataTables.bootstrap4.min.css" rel="stylesheet"/>
    <link href="https://cdn.datatables.net/buttons/2.3.2/css/buttons.bootstrap4.min.css" rel="stylesheet"/>
    <style>
        .dataTable .sorting {
            text-align: right;
        }
    </style>
@endpush


@section('content')
    <div class="row">
        <div class="col-md-12">
            <div class="card mb-5">
                <div class="card-body">

                    <h6 class="heading-small text-muted mb-4">דוח ריכוז</h6>
                    <div class="pl-lg-4">
                        <form id="monthFom">
                            <div class="row">
                                <div class="col-6">
                                    <div class="form-group">
                                        <label for="date" class="form-control-label"> תאריך </label>
                                        <input type="month" class="form-control" id="month" name="month"
                                               value="{{request('month',session('mainDate')) }}" required>
                                    </div>
                                </div>
                                <div class="col-6">
                                    <div class="form-group">
                                        <label for="organizer_id" class="form-control-label"> סדראן </label>
                                        {{ Form::select('organizer_id', $organizers,request('organizer_id',old('organizer_id')), [ 'id'=>'organizer', 'class'=> 'selectpicker form-control', 'placeholder' => 'בחר ...']) }}
                                    </div>
                                </div>
                            </div>
                        </form>

                        @if( request('month',session('mainDate')) )
                            <div class="table-responsive">
                                <div>
                                    <table class="table align-items-center table-sm table-striped"
                                           id="AttendanceTable">
                                        <thead class="thead-light">
                                        <tr>
                                            <th>#</th>
                                            <th>עובד</th>
                                            <th>ימי עבודה</th>
                                            <th>סך הכל שעות</th>
                                            <th>שעות רגילות</th>
                                            <th>שעות 125%</th>
                                            <th>שעות 150%</th>
                                            <th>שעות בונוס</th>
{{--                                            <th>מקדימה</th>--}}
                                            <th>מידע</th>
                                        </tr>
                                        </thead>
                                        <tbody>

                                        @foreach( $all_data as $d)
                                            <tr>
                                                <td>{{$d->id}}</td>
                                                <td>{{$d->name}}</td>
                                                <td>{{$d->attendances['count']}}</td>
                                                <td>{{$d->attendances['sum']}}</td>
                                                <td>{{$d->attendances['hours']['hours_normal']}}</td>
                                                <td>{{$d->attendances['hours']['hours_125']}}</td>
                                                <td>{{$d->attendances['hours']['hours_150']}}</td>
                                                <td>{{$d->attendances['hours']['hours_bonus']}}</td>
{{--                                                <td>{{$d['advance']}}</td>--}}
                                                <td>
                                                    <a  class="btn btn-warning btn-sm"
                                                        href="{{route('attendance.worker.report.print',['worker'=>$d->id,'month'=>request('month',session('mainDate'))])}}" target="_blank">
                                                        <i class="fas fa-print"></i>
                                                    </a>
                                                    <a class="btn btn-sm btn-primary"
                                                       href="{{route('attendance.worker.report',['worker'=>$d->id,'month'=>request('month',session('mainDate'))])}}" target="_blank">
                                                        <i class="fas fa-info"></i>
                                                    </a>
                                                </td>
                                            </tr>

                                        @endforeach


                                        </tbody>
                                    </table>

                                </div>
                            </div>
                        @endif

                    </div>

                </div>
            </div>
        </div>
    </div>

    <div class="modal fade" id="monthAttModel">
        <div class="modal-dialog modal-dialog-centered modal-xl" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title" id="exampleModalLabel">מידע על עבודה</h5>
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                </div>

                <div class="modal-body">
                    <div class="text-right mb-1">
                    <a id="print_btn" class="btn btn-secondary buttons-excel buttons-html5"
                       href="{{route('attendance.worker.report.print',['worker'=>-1,'month'=>request('month',session('mainDate'))])}}" target="_blank">Print</a>
                    </div>
                    <div class="table-responsive">
                        <table class="table align-items-center table-sm" id="tableMonthlyReport">
                            <thead class="thead-light">
                            <tr>
{{--                                <th>שם העובד</th>--}}
                                <th>תאריך</th>
                                <th>לקוח</th>
                                <th>מנוף</th>
                                <th>הפרויקט</th>
                                <th>מספר השעות</th>
                                <th> שעה התחילה</th>
                                <th> שעה סיום</th>
                            </tr>
                            </thead>
                            <tbody>

                            </tbody>
                        </table>
                    </div>
                </div>

                <div class="modal-footer">
                    <button type="button" class="btn btn-danger" data-dismiss="modal">סגור</button>
                </div>

            </div>
        </div>
    </div>

@endsection



@push('scripts')
    <script src="https://cdn.datatables.net/1.13.1/js/jquery.dataTables.js"></script>
    <script src="https://cdn.datatables.net/buttons/2.3.2/js/dataTables.buttons.min.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/2.3.2/js/buttons.html5.min.js"></script>
    <script src="https://cdn.datatables.net/buttons/2.3.2/js/buttons.print.min.js"></script>
    <script src="https://cdn.datatables.net/1.13.1/js/dataTables.bootstrap4.min.js"></script>
    <script src="https://cdn.datatables.net/buttons/2.3.2/js/buttons.bootstrap4.min.js"></script>
    <script src="https://momentjs.com/downloads/moment-with-locales.js"></script>

    <script>

        $('#AttendanceTable').DataTable({
            dom: 'Bfrtip',
            paginate: false,
            buttons: [
                {
                    extend: 'excelHtml5',
                    title: 'דוח ריכוז_{{request('month',session('mainDate')) }}'
                }, 'print',
            ],
            language: {
                url: "https://cdn.datatables.net/plug-ins/9dcbecd42ad/i18n/Hebrew.json",
                search: "",
            }
        });


        $('#month').on('change', function () {
            $('#monthFom').submit();
        });

        $('#organizer').on('change', function () {
            if ($('#month').val() != null) {
                $('#monthFom').submit();
            }
        });

        function openMonthAttModel(worker) {
            //  $("#totalHours").html('');

            var newHref = $("#print_btn").attr("href").replace(/-1/, worker);
            $("#print_btn").attr("href", newHref);

            $.ajax({
                type: 'POST',
                url: '{{route('project.ajax.there')}}',
                dataType: 'json',
                data: {
                    _token: "{{ csrf_token() }}",
                    month: "{{request('month',session('mainDate')) }}",
                    worker: worker,
                },
                success: function (data) {
                    if ($.fn.DataTable.isDataTable('#tableMonthlyReport')) {
                        $('#tableMonthlyReport').DataTable().destroy();
                    }
                    var reportTable = $('#tableMonthlyReport').DataTable({
                        dom: 'B',
                        "order": [[1, "desc"]],
                        paginate: false,
                        buttons: [
                            {
                                extend: 'excelHtml5',
                                title: 'דוח שעות של ' + data.worker,
                            }
                        ],
                    });
                    var total_hours = 0
                    reportTable.clear().draw();
                    for (var i = 0; i < data.data.length; i++) {
                        if(data.data[i].project_deleted == null){
                            reportTable.row.add([data.data[i].client, data.data[i].crane, data.data[i].date, data.data[i].project, data.data[i].hour_work_count, '07:00', moment.utc('07:00','hh:mm').add(data.data[i].hour_work_count,'hour').format('HH:mm')]).draw(false);
                            if (data.data[i].hour_work_count && !isNaN(data.data[i].hour_work_count)) {
                                total_hours = total_hours + parseFloat(data.data[i].hour_work_count);
                            }
                        }

                    }
                    reportTable.row.add(['','', 'סך הכל שעות', '','', total_hours,'']).draw(false);
                    $('#monthAttModel').modal('show');

                }
            });
        }
    </script>

@endpush