@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 {
            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="d-flex align-items-center justify-content-between">
                        <h4 class="heading-section text-muted mb-4">דוח מקדמות</h4>
                        <button type="button" class="btn btn-primary"
                                data-toggle="modal" data-target="#advanceNewWorkerAddModal">הוסף מקדמה
                        </button>
                    </div>

                    <div class="pl-lg-4">

                        <div class="table-responsive">
                            <table class="table align-items-center table-sm table-striped"
                                   id="ReportTable">
                                <thead class="thead-light">
                                <tr>
                                    <th>#</th>
                                    <th>שם העובד</th>
                                    <th>תאריך</th>
                                    <th>סה״כ</th>
                                    <th>אפשרויות</th>
                                </tr>
                                </thead>
                                <tbody>

                                @php($total = 0)
                                @foreach($data as $item)
                                    <tr>
                                        <td>{{$loop->index +1}}</td>
                                        <td>{{$item->worker->name}}</td>
                                        <td>{{$item->date}}</td>
                                        <td>@money($item->amount)</td>
                                        <td>
                                            <a class="btn btn-sm btn-primary"
                                               onclick="openAdvanceModel({{$item->worker_id}})">
                                                <i class="fas fa-info text-white"></i>
                                            </a>

                                            <a class="btn btn-sm btn-success"
                                               onclick="openAdvanceAddModal({{$item->worker_id}},'plus')">
                                                <i class="fas fa-plus text-white"></i>
                                            </a>

                                            <a class="btn btn-sm btn-danger"
                                               onclick="openAdvanceAddModal({{$item->worker_id}},'minus')">
                                                <i class="fas fa-minus text-white"></i>
                                            </a>
                                        </td>

                                    </tr>
                                    @php($total += $item->amount)
                                @endforeach


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

                        <div class="row text-success">
                            <div class="col">
                                סך הכל
                            </div>
                            <div class="col">
                                @money($total)
                            </div>
                        </div>


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



    <div class="modal fade" id="advanceNewWorkerAddModal">
        <div class="modal-dialog" role="document">
            <div class="modal-content">
                <form action="{{route('advance.store')}}" method="POST">
                    @csrf

                    <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="row">
                            <div class="col-12">

                                <div class="form-group">
                                    <label for="worker_id" class="form-control-label"> עובד </label>
                                    {{ Form::select('worker_id', $workers, null, [ 'class'=> 'selectpicker form-control', 'required'=>'required' ,'placeholder' => 'בחר  ...']) }}
                                </div>

                            </div>
                            <div class="col-12">
                                <div class="form-group">
                                    <label for="total" class="form-control-label"> סך הכל</label>
                                    <input type="text" class="form-control  only-number" id="total" name="total"
                                           value="0" required>
                                </div>
                            </div>
                            <div class="col-12">
                                <div class="form-group">
                                    <label for="date" class="form-control-label">תאריך </label>
                                    <input type="date" class="form-control" id="date" name="date" required>
                                </div>
                            </div>
                        </div>

                        <div class="modal-footer">
                            <button type="button" class="btn btn-secondary" data-dismiss="modal">סגור</button>
                            <button type="submit" class="btn btn-primary">שמור</button>
                        </div>
                    </div>
                </form>
            </div>
        </div>
    </div>


    <div class="modal fade" id="advanceAddModal">
        <div class="modal-dialog" role="document">
            <div class="modal-content">
                <form action="{{route('advance.store')}}" method="POST">
                    @csrf
                    <input type="hidden" name="worker_id" id="worker_id_1" required>
                    <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="row">
                            <div class="col-12">
                                <div class="form-group">
                                    <label for="total" class="form-control-label"> סך הכל</label>
                                    <input type="text" class="form-control  only-number" id="total" name="total"
                                           value="0" required>
                                </div>
                            </div>
                            <div class="col-12">
                                <div class="form-group">
                                    <label for="date" class="form-control-label">תאריך </label>
                                    <input type="date" class="form-control" id="date" name="date" required>
                                </div>
                            </div>

                            <div class="col-12">
                                <div class="form-group">
                                    <label for="notes" class="form-control-label">הערות </label>
                                    <input type="text" class="form-control" id="notes" name="notes">
                                </div>
                            </div>
                        </div>

                        <div class="modal-footer">
                            <button type="button" class="btn btn-secondary" data-dismiss="modal">סגור</button>
                            <button type="submit" class="btn btn-primary">שמור</button>
                        </div>
                    </div>
                </form>
            </div>
        </div>
    </div>
    <div class="modal fade" id="advanceRemoveModal">
        <div class="modal-dialog" role="document">
            <div class="modal-content">
                <form action="{{route('advance.details.update')}}" method="POST">
                    @csrf
                    <input type="hidden" name="worker_id" id="worker_id_2" required>
                    <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="row">
                            <div class="col-12">
                                <div class="form-group">
                                    <label for="total" class="form-control-label"> סך הכל</label>
                                    <input type="text" class="form-control  only-number" id="total" name="total"
                                           value="0" required>
                                </div>
                            </div>
                            <div class="col-12">
                                <div class="form-group">
                                    <label for="date" class="form-control-label">תאריך </label>
                                    <input type="date" class="form-control" id="date" name="date" required>
                                </div>
                            </div>
                        </div>

                        <div class="col-12">
                            <div class="form-group">
                                <label for="notes" class="form-control-label">הערות </label>
                                <input type="text" class="form-control" id="notes" name="notes">
                            </div>
                        </div>

                        <div class="modal-footer">
                            <button type="button" class="btn btn-secondary" data-dismiss="modal">סגור</button>
                            <button type="submit" class="btn btn-primary">שמור</button>
                        </div>
                    </div>
                </form>
            </div>
        </div>
    </div>

    <div class="modal fade" id="AdvanceModel">
        <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="row">
                        <div class="col-12 col-md-6">
                            <div class="table-responsive">
                                <table class="table align-items-center table-sm" id="tableCreditReport">
                                    <thead class="thead-light">
                                    <tr>
                                        <th>תאריך</th>
                                        <th>הערות</th>
                                        <th>סכום</th>
                                        <th>הערות</th>
                                        <th></th>
                                    </tr>
                                    </thead>
                                    <tbody>

                                    </tbody>
                                </table>
                            </div>
                        </div>
                        <div class="col-12 col-md-6">
                            <table class="table align-items-center table-sm" id="tableDebitReport">
                                <thead class="thead-light">
                                <tr>
                                    <th>תאריך</th>
                                    <th>הערות</th>
                                    <th>סכום</th>
                                    <th>הערות</th>
                                    <th></th>
                                </tr>
                                </thead>
                                <tbody>

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

                    <div id="editNote" style="display: none">
                        <hr>
                        <p>עדכון הערות</p>
                        <div class="row">
                            <div class="col-9">
                                <div class="form-group">
                                    <input type="hidden" id="edit_note_id" name="edit_note_id">
                                    <label for="edit_note" class="form-control-label">הערה </label>
                                    <input type="text" class="form-control" id="edit_note" name="edit_note"
                                           required>
                                </div>
                            </div>
                            <div class="align-self-center col-3 d-flex">
                                <button type="button" onclick="closeEditNote();" class="btn btn-block btn-danger mt-0">
                                    סגור
                                </button>
                                <button type="submit" onclick="saveEditNote();" class="btn btn-block btn-primary mt-0">
                                    שמור
                                </button>
                            </div>
                        </div>
                    </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>

        function openAdvanceAddModal(worker, type) {
            $("#worker_id_1").val(worker);
            $("#worker_id_2").val(worker);
            if (type == "plus") {
                $('#advanceAddModal').modal('show');
            } else {
                $('#advanceRemoveModal').modal('show');
            }
        }

        function openAdvanceModel(worker) {

            $.ajax({
                type: 'POST',
                url: '{{route('project.ajax.five')}}',
                dataType: 'json',
                data: {
                    _token: "{{ csrf_token() }}",
                    worker: worker,
                },
                success: function (data) {
                    if ($.fn.DataTable.isDataTable('#tableCreditReport')) {
                        $('#tableCreditReport').DataTable().destroy();
                    }

                    if ($.fn.DataTable.isDataTable('#tableDebitReport')) {
                        $('#tableDebitReport').DataTable().destroy();
                    }

                    var creditReportTable = $('#tableCreditReport').DataTable({
                        dom: '',
                        paginate: false,
                        sorting: false,
                    });
                    var debitReportTable = $('#tableDebitReport').DataTable({
                        dom: '',
                        paginate: false,
                        sorting: false,
                    });

                    var total_credit_hours = 0
                    var total_debit_hours = 0
                    creditReportTable.clear().draw();
                    debitReportTable.clear().draw();
                    for (var i = 0; i < data.data.length; i++) {
                        var data_info = data.data[i];
                        var editText = "<button class='btn m-0 p-1 edit-note' data-id='" + data_info.id + "' data-note='" + data_info.notes + "'><i class='fa-edit fas'></i></button>";
                        if (data_info.type == "credit") {
                            creditReportTable.row.add([data_info.date, data_info.message, data_info.amount, data_info.notes, editText]).draw(false);
                            total_credit_hours += data_info.amount;
                        } else {
                            debitReportTable.row.add([data_info.date, data_info.message, data_info.amount, data_info.notes, editText]).draw(false);
                            total_debit_hours += data_info.amount;
                        }

                    }


                    $('#AdvanceModel').modal('show');

                }
            });
        }


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


        $(document).on("click", ".edit-note", function () {
            var id = $(this).attr('data-id');
            var note = $(this).attr('data-note');

            $("#edit_note_id").val(id);
            if (note != "" && note != "null") {
                $("#edit_note").val(note);
            } else {
                $("#edit_note").val('');
            }
            $("#editNote").hide(500).show(500);
        });

        function closeEditNote() {
            $("#edit_note_id").val('');
            $("#edit_note").val('');
            $("#editNote").hide(500);
        }

        function saveEditNote() {
            var id = $("#edit_note_id").val();
            var note = $("#edit_note").val();

            if (id && id != null) {
                $.ajax({
                    type: 'POST',
                    url: '{{route('advance.update')}}' ,
                    dataType: 'json',
                    data: {
                        _token: "{{ csrf_token() }}",
                        id: id,
                        note: note,
                    },
                    success: function (data) {
                        $("#editNote").hide(500);
                        $('#AdvanceModel').modal('hide');
                        Swal.fire('עודכן בהצלחה', '', 'success');
                    }
                });
            }else{
                Swal.fire('שגיאה!!', '', 'error');
            }
        }

    </script>

@endpush