@extends('layouts.app')


@push('title')
    דוח סדראנים
@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_disabled {
            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="organizerForm">
                            <div class="row">
                                <div class="col-6">
                                    <div class="form-group">
                                        <label for="project_id" class="form-control-label"> סדראן </label>
                                        {{ Form::select('organizer', $organizers,old('organizer',request('organizer')), [ 'id' => 'organizer' , 'class'=> 'selectpicker form-control','required' => 'required', 'placeholder' => 'בחר  ...']) }}
                                    </div>
                                </div>
                                <div class="col-6">
                                    <div class="form-group">
                                        <label for="month" class="form-control-label"> תאריך </label>
                                        <input type="month" class="form-control" id="month" name="month"
                                               value="{{request('month',session('mainDate')) }}" required>
                                    </div>
                                </div>
                            </div>
                        </form>

                        @if( isset($organizer) && isset($month))
                            <form action="{{route('organizer.report.store')}}" method="POST">
                                @method('POST')
                                @csrf
                                <input type="hidden" name="organizer_id" value="{{$organizer->id}}">
                                <input type="hidden" name="date" value="{{$month}}">
                                <input type="hidden" name="extra_operation" id="extra_operation" value="+">

                                <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> סה״כ לסדראן</th>
                                                {{--  <th> שעה לפרויקט</th>
                                                  <th> סה״כ</th>
                                                  <th>הפרש</th> --}}
                                            </tr>
                                            </thead>
                                            <tbody>
                                            @php($total = 0)
                                            @foreach($organizer->projects  as $project)
                                                @php($totalHours = $project->attendancesDetails()->where('attendances.date', '=', $month)->sum('hour_work_count'))
                                                @php($saveTotalHours = isset($reportProjects[$project->id]) ? $reportProjects[$project->id]->total_hours  : $totalHours)
                                                @php($subTotal = $project->hour_cost*$saveTotalHours)
                                                @php($subTotalOrgnizer = $organizer->hour_cost*$saveTotalHours)
                                                @php($total += $subTotalOrgnizer)
                                                <tr>
                                                    <td>{{$loop->index}}</td>
                                                    <td>{{$project->client->name}}</td>
                                                    <td>{{$project->name}}</td>
                                                    <td>
                                                        <input type="text"
                                                               class="form-control form-control-sm totalHours"
                                                               data-id="{{$project->id}}" name="project_hour[{{$project->id}}]"
                                                               id="totalHours_{{$project->id}}" value="{{ isset($reportProjects[$project->id]) ? $reportProjects[$project->id]->total_hours  : $totalHours}}">
                                                        @if(  isset($reportProjects[$project->id]) && $reportProjects[$project->id]->total_hours != $totalHours)
                                                            <p class="small mb-0 mt-1 text-success text-center font-weight-bold">{{$totalHours}}</p>
                                                        @endif
                                                    </td>
                                                    <td id="orgnizerHourCost_{{$project->id}}"
                                                        data-value="{{$organizer->hour_cost}}">
                                                        @money($organizer->hour_cost)
                                                    </td>
                                                    <td id="subTotalOrgnizer_{{$project->id}}"
                                                        data-value="{{$subTotalOrgnizer}}" class="total-orgnizer">
                                                        @money($subTotalOrgnizer)
                                                    </td>
                                                    {{--
                                                    <td>@money($project->hour_cost)</td>
                                                    <td>@money($subTotal)</td>
                                                    <td>@money($subTotal-$subTotalOrgnizer)</td>--}}
                                                </tr>


                                                @if($loop->last)

                                                    <tr>
                                                        {{--
                                                      <td></td>
                                                      <td></td>
                                                      <td></td>
                                                      --}}
                                                        <td></td>
                                                        <td></td>
                                                        <td></td>
                                                        <td></td>
                                                        <td class="bg-blue font-weight-bolder text-darker">סכ הכול</td>
                                                        <td class="bg-blue font-weight-bolder text-darker">
                                                            <input type="text" class="form-control form-control-sm"
                                                                   id="subTotal" value="@money($total)" readonly>
                                                            <p class="d-none d-print-block">{{$total}}</p>
                                                        </td>
                                                    </tr>
                                                    <tr>
                                                        {{--
                                                      <td></td>
                                                      <td></td>
                                                      <td></td>
                                                      --}}
                                                        <td></td>
                                                        <td></td>
                                                        <td></td>
                                                        <td></td>
                                                        <td class="bg-blue font-weight-bolder text-darker">משכורות</td>
                                                        <td class="bg-blue font-weight-bolder text-darker">
                                                            <input type="text" class="form-control form-control-sm"
                                                                   value="{{$report->salaries ?? 0}}" id="salaries"
                                                                   name="salaries">
                                                            <p class="d-none d-print-block" id="salaries_text">0</p>
                                                        </td>
                                                    </tr>
                                                    <tr>
                                                        {{--
                                                      <td></td>
                                                      <td></td>
                                                      <td></td>
                                                      --}}
                                                        <td></td>
                                                        <td></td>
                                                        <td></td>
                                                        <td></td>
                                                        <td class="bg-blue font-weight-bolder text-darker">מ.ע</td>
                                                        <td class="bg-blue font-weight-bolder text-darker">
                                                            <input type="text" class="form-control form-control-sm"
                                                                   name="taxes" id="sals"
                                                                   value="{{$report->taxes ?? 0}}">
                                                            <p class="d-none d-print-block" id="sals_text">0</p>
                                                        </td>
                                                    </tr>
                                                    <tr>
                                                        {{--
                                                      <td></td>
                                                      <td></td>
                                                      <td></td>
                                                      --}}
                                                        <td></td>
                                                        <td></td>
                                                        <td></td>
                                                        <td></td>
                                                        <td class="bg-blue font-weight-bolder text-darker">מקדמות</td>
                                                        <td class="bg-blue font-weight-bolder text-darker">
                                                            <input type="text" class="form-control form-control-sm"
                                                                   name="advances" id="advanced"
                                                                   value="{{$report->advances ?? 0}}">
                                                            <p class="d-none d-print-block"
                                                               id="advanced_text">{{$report->advances ?? 0}}</p>
                                                        </td>
                                                    </tr>
                                                    <tr>
                                                        {{--
                                                      <td></td>
                                                      <td></td>
                                                      <td></td>
                                                      --}}
                                                        <td></td>
                                                        <td></td>
                                                        <td></td>
                                                        <td></td>
                                                        <td class="bg-blue font-weight-bolder text-darker d-flex">
                                                            <input type="text" class="form-control form-control-sm"
                                                                   name="extra_key" id="extra_label"
                                                                   value="{{$report->extra_key ?? ''}}">
                                                            <button class="btn btn-sm ml-1 btn-secondary"
                                                                    id="operation" type="button"
                                                                    onclick="changeOperation()">{{$report->extra_operation ?? '+'}}</button>
                                                        </td>
                                                        <td class="bg-blue font-weight-bolder text-darker">
                                                            <input type="text" class="form-control form-control-sm"
                                                                   name="extra_value" id="extra"
                                                                   value="{{$report->extra_value ?? 0}}">
                                                        </td>
                                                    </tr>

                                                    <tr>
                                                        {{--
                                                      <td></td>
                                                      <td></td>
                                                      <td></td>
                                                      --}}
                                                        <td></td>
                                                        <td></td>
                                                        <td></td>
                                                        <td></td>
                                                        <td class="bg-blue font-weight-bolder text-darker">סכ הכול</td>
                                                        <td class="bg-blue font-weight-bolder text-darker">
                                                            <input type="text" class="form-control form-control-sm"
                                                                   id="total"
                                                                   value="@money($total)" readonly>
                                                            <p class="d-none d-print-block" id="total_text">0</p>
                                                        </td>
                                                    </tr>

                                                @endif
                                            @endforeach


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

                                </div>


                                <div class="mt-3  text-right">
                                    <button type="submit" class="btn btn-primary">
                                        Save
                                    </button>
                                </div>
                            </form>
                        @endif
                    </div>

                </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>

        function formatMoney(amount) {
            return '₪' + amount.toLocaleString(undefined, {maximumFractionDigits: 4, minimumFractionDicits: 4});
        }

        function changeOperation() {
            var operation = $('#operation').html();
            if (operation === "+") {
                $('#operation').html('-');
                $('#extra_operation').val('-');

            } else {
                $('#operation').html('+');
                $('#extra_operation').val('+');
            }
            calculateTotal();
        }


        function calculateTotal() {
            /*var subTotal = parseFloat($('#subTotal').val());*/
            var subTotal = 0;

            $('.total-orgnizer').each(function () {
                subTotal += parseFloat($(this).attr('data-value'));
            });

            $('#subTotal').val(formatMoney(subTotal));
            var salaries = parseFloat($('#salaries').val()) ? parseFloat($('#salaries').val()) : 0;
            var advanced = parseFloat($('#advanced').val()) ? parseFloat($('#advanced').val()) : 0;
            var sals = parseFloat($('#sals').val()) ? parseFloat($('#sals').val()) : 0;
            var extra = parseFloat($('#extra').val()) ? parseFloat($('#extra').val()) : 0;
            var extraOperation = $('#operation').html();
            $('#total').val(subTotal - salaries - advanced - sals);
            if (extraOperation === "+") {
                $('#total').val(formatMoney(parseFloat($('#total').val()) + extra));
            } else {
                $('#total').val(formatMoney(parseFloat($('#total').val()) - extra));
            }

            $('#total_text').html($('#total').val());
            $('#advanced_text').html(advanced);
            $('#salaries_text').html(salaries);
            $('#sals_text').html(sals);
        }

        $('#AttendanceTable').DataTable({
            dom: 'Bfrtp',
            paginate: false,
            ordering: false,
            buttons: [],
            language: {
                url: "https://cdn.datatables.net/plug-ins/9dcbecd42ad/i18n/Hebrew.json",
                search: "",
            }
        });

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

        $('#subTotal,#salaries,#advanced,#sals,#extra').on('input', function () {
            calculateTotal();
        });


        $('.totalHours').on('input', function () {
            var id = $(this).data("id");
            var totalHours = parseFloat($(this).val()) ? parseFloat($(this).val()) : 0;
            var hourCost = parseFloat($("#orgnizerHourCost_" + id).attr("data-value")) ? parseFloat($("#orgnizerHourCost_" + id).attr("data-value")) : 0;
            var total = parseFloat(totalHours * hourCost);
            $("#subTotalOrgnizer_" + id).html(formatMoney(total));
            $("#subTotalOrgnizer_" + id).attr("data-value", total);
            calculateTotal();
        });

        $(document).ready(function () {
            calculateTotal();
        });
    </script>

@endpush