@extends('layouts.app')

@push('title')
    עובד :{{$worker->name}} | ת.ז :{{$worker->identification}}
@endpush


@push('styles')
    <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"/>
@endpush


@section('content')
    <div class="row">
        <div class="col-md-12">
            <div class="card mb-5">
                <div class="card-header bg-transparent">
                    <div class="row">
                        <div class="col-lg-8">
                            <h3 class="mb-0">דוח הנחיות </h3>
                        </div>
                    </div>
                </div>
                <div class="card-body">
                    <table class="w-100 table-bordered table-sm" id="tableMonthlyReport">
                        <thead>
                        <tr>
                            {{--        <th>#</th>--}}
                            <th>תאריך</th>
                            <th>לקוח</th>
                            <th>הפרויקט</th>
                            <th>שעה התחילה</th>
                            <th> שעה סיום</th>
                            <th> שעות</th>
                            <th> רגילות</th>
                            <th> 125%</th>
                            <th> 150%</th>
                            <th> בונוס</th>
                        </tr>
                        </thead>
                        <tbody>
                        @foreach( $data as $d)
                            @if($d->project_deleted == null)
                                <tr>
                                    {{--            <td>{{$loop->index+1}}</td>--}}
                                    <td>{{$d->date}}</td>
                                    <td>{{$d['client']}}</td>
                                    <td>{{$d->project}}</td>
                                    <td>07:00</td>
                                    <td>{{Carbon\Carbon::parse('2023-01-01 07:00:00')->addHour($d->hour_work_count)->format('H:i')}}</td>
                                    <td>{{$d->hour_work_count}}</td>
                                    <td>{{$d['hours']['hours_normal']}}</td>
                                    <td>{{$d['hours']['hours_125']}}</td>
                                    <td>{{$d['hours']['hours_150']}}</td>
                                    <td>{{$d['hours']['hours_bonus']}}</td>
                                </tr>
                            @endif
                        @endforeach

                        <tr class="fw-bold text-center">
                            <td style="padding: 3px 0 !important;" > כמות ימים עבודה: {{ count($data) }}</td>
                            <td style="padding: 3px 0 !important;"> </td>
                            <td style="padding: 3px 0 !important;"> </td>
                            <td style="padding: 3px 0 !important;"> </td>
                            <td style="padding: 3px 0 !important;"> סך הכול</td>
                            <td style="padding: 3px 0 !important;">{{$extraHours['hours_total']}}</td>
                            <td style="padding: 3px 0 !important;">{{$extraHours['hours_normal']}}</td>
                            <td style="padding: 3px 0 !important;">{{$extraHours['hours_125']}}</td>
                            <td style="padding: 3px 0 !important;">{{$extraHours['hours_150']}}</td>
                            <td style="padding: 3px 0 !important;">{{$extraHours['hours_bonus']}}</td>
                        </tr>
                        </tbody>
                    </table>
                </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>


        $(document).ready(function () {

            $('#tableMonthlyReport').DataTable({
                dom: 'B',
                paginate: false,
                "ordering": false,
                buttons: [
                    {
                        extend: 'excelHtml5',
                        title: 'דוח שעות של ' + '{{$worker->name}}',
                    }
                ],
            });

        })
    </script>

@endpush