@extends('admin.layouts.adminpanel')

@section('page_header')
    @php
        $page_title = 'Revenue Report';
    @endphp

    @include('admin.partials.page_header')
@endsection

@section('content')
    <div class="container-fluid">
        <div class="card">
            <div class="card-body table-responsive no-padding">
                <div class="alert alert-success fade show" role="alert" style="display:none">
                </div>
                <div class="alert alert-danger fade show" role="alert" style="display:none">
                </div>

                <div class="row">
                    <div class="col-lg-12">
                        <div class="float-right d-inline-flex">
                            <div style="width:100%; text-align:right; padding-bottom:10px">
                                <button id="btn-export-excel" class="btn btn-secondary">Excel</button>
                            </div>
                        </div>
                    </div>
                </div>

                <div class="row">
                    {{-- comisionista does not see list of clients --}}
                    @if (currentUserRoleId() != 4)
                        <div class="col-md-6 col-lg-3">
                            <div class="form-group">
                                <label for="client_id">{{ __('Client') }}</label>
                                <select class="form-control" name="client_id" id="client_id" onChange="drawTable()">
                                    <option value="">
                                        {{ __('-- All clients --') }}
                                    </option>
                                    @foreach ($clients as $client)
                                        <option value="{{ $client->id }}">
                                            {{ $client->name }}
                                        </option>
                                    @endforeach
                                </select>
                            </div>
                        </div>
                    @endif

                    <div class="col-md-6 col-lg-3" @if (currentUserRoleId() < 3) style="display:none" @endif>
                        <div class="form-group">
                            <label for="status">{{ __('Status') }}</label>
                            <select class="form-control" name="status" id="status" onChange="drawTable()">
                                <option value="">
                                    {{ __('-- All statuses --') }}
                                </option>
                                <option value="Nuevo">
                                    Nuevo
                                </option>
                                <option value="Solicitado">
                                    Solicitado
                                </option>
                                <option value="Pagado">
                                    Pagado
                                </option>
                            </select>
                        </div>
                    </div>

                    <div class="col-md-6 col-lg-3">
                        <div class="form-group">
                            <label><strong>{{ __('Date Range') }}</strong></label>
                            <div class="form-group input-group">
                                <div class="input-group-prepend">
                                    <span class="input-group-text"><i class="far fa-calendar"></i></span>
                                </div>
                                <input type="text" id="date_range_revenue" class="form-control" autocomplete="off">
                            </div>
                        </div>
                    </div>

                    <div class="col-md-3 d-flex align-items-end">
                        <div style="margin-bottom: 1rem;">
                            <button type="button" class="btn btn-light" id="clear-settings-button"
                                onclick="clearFilters()">
                                {{ __('Clear filters') }}
                            </button>
                        </div>
                    </div>
                </div>

                <br>
                {{-- comisionista update to 4 --}}
                @if (currentUserRoleId() == 3 || currentUserRoleId() == 4)
                    {{-- Summary --}}
                    <div class="row">
                        <div class="col-md-12 col-lg-6">
                            <div class="card" style="height: 260px;">
                                <div class="card-body">
                                    <div class="col-md-12 text-center font-weight-bold"
                                        style="font-size: 1.1rem; padding-bottom: 1rem;">
                                        Resumen General
                                    </div>
                                    <table class="table table-sm">
                                        <tr>
                                            <td style="font-weight:bold">Total Cobrado</td>
                                            <td class="text-right" id="total_received"></td>
                                        </tr>
                                        <tr>
                                            <td style="font-weight:bold">Total por Cobrar</td>
                                            <td class="text-right" id="total_receivable"></td>
                                        </tr>
                                        <tr>
                                            <td style="font-weight:bold">Total Nuevas Licencias
                                            </td>
                                            <td class="text-right" id="total_new_subscriptions">
                                            </td>
                                        </tr>
                                    </table>
                                    <br>
                                    {{-- comisionista update to 4 --}}
                                    @if (currentUserRoleId() == 3 || currentUserRoleId() == 4)
                                        <div>
                                            <button class="btn btn-info custom-btn-lg" id="request_button"
                                                onclick="confirmPayoutRequest()"
                                                disabled>{{ __('Generate Payout Request') }}</button>
                                        </div>
                                    @endif
                                </div>
                            </div>
                        </div>
                    </div>
                    <br>
                @endif
                <table id="tbl_revenue_report" class="table table-bordered table-striped">
                    <thead>
                        <tr>
                            <th>{{ __('ID') }}</th>
                            <th>{{ __('Date') }}</th>
                            <th>{{ __('Client') }}</th>
                            <th>{{ __('Package') }}</th>
                            <th class="text-right">{{ __('Amount') }}</th>
                            <th class="text-right">{{ __('Tax') }}</th>
                            <th class="text-right">{{ __('Total') }}</th>
                            <th class="text-right">{{ __('Fee') }}</th>

                            @if (isset($investors))
                                @foreach ($investors as $investor)
                                    @php
                                        $share_pct = null;

                                        if (currentUserRoleId() == 3 && isset($investor->investment)) {
                                            $share_pct = $investor->investment->share_pct;
                                        } elseif (currentUserRoleId() == 4 && isset($investor->commission)) {
                                            // comisionista
                                            $share_pct = $investor->commission->share_pct;
                                        }
                                    @endphp
                                    <th class="text-right">
                                        {{ $investor->name }}
                                        @if (!is_null($share_pct))
                                            {{ number_format($share_pct, 0) }}%
                                        @endif
                                    </th>
                                @endforeach
                            @endif
                            {{-- comisionista update to 4 --}}
                            @if (currentUserRoleId() == 3 || currentUserRoleId() == 4)
                                <th>{{ __('Status') }}</th>
                            @else
                                <th>{{ __('Invoice') }}</th>
                                <th>{{ __('Files') }}</th>
                            @endif
                        </tr>
                    </thead>
                    <tbody>
                    </tbody>
                    <tfoot>
                        <tr>
                            <th></th>
                            <th></th>
                            <th></th>
                            <th>{{ __('Totals') }}</th>
                            <th class="text-right"></th>
                            <th class="text-right"></th>
                            <th class="text-right"></th>
                            <th class="text-right"></th>
                            @if (isset($investors))
                                @foreach ($investors as $investor)
                                    <th class="text-right"></th>
                                @endforeach
                            @endif
                            {{-- comisionista update to 4 --}}
                            @if (currentUserRoleId() == 3 || currentUserRoleId() == 4)
                                <th></th>
                            @else
                                <th></th>
                                <th></th>
                            @endif
                        </tr>
                    </tfoot>
                </table>

            </div>
        </div>
    </div>
    <!-- Modal -->
    <div class="modal fade" id="errorModal" tabindex="-1" role="dialog" aria-labelledby="errorModalLabel"
        aria-hidden="true">
        <div class="modal-dialog">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title" id="errorModalLabel">Error</h5>
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                </div>
                <div class="modal-body" id="errorModalText">
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-dismiss="modal">
                        Cerrar</button>
                </div>
            </div>
        </div>
    </div>
    <script>
        $("#btn-export-excel").on("click", function() {
            exportReport();
        });

        var payoutTotal = 0;

        function confirmPayoutRequest() {

            if (payoutTotal > 0) {
                var confirmation = confirm("Estas a punto de generar una orden de pago con el siguiente monto: " +
                    currencyFormat(payoutTotal) +
                    "\n\nUna vez recibida la factura se efectuará el traspaso a tu cuenta en un máximo de 5 días hábiles." +
                    "\n\nEsta operación no puede revertirse.");

                if (confirmation) {
                    generatePayoutRequest();
                }
            }
        }

        function generatePayoutRequest() {

            $(".overlay").show();
            $("#request_button").prop("disabled", true);

            if (payoutTotal > 0) {
                $.ajaxSetup({
                    headers: {
                        'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
                    }
                });

                $.ajax({
                    type: 'POST',
                    url: '{{ route('payouts.store') }}',
                    dataType: 'json',
                }).done(function(response) {

                    $("#tbl_revenue_report").DataTable().draw(false);

                }).fail(function(xhr) {
                    if (xhr.status === 401 || xhr.status === 419) {
                        window.location.href = '/login';
                    } else {
                        console.log(xhr.statusText);
                    }
                }).always(function() {
                    $(".overlay").hide();
                });
            }
        }

        function getPayoutsTotal() {
            var totalSum = 0;

            var table = $("#tbl_revenue_report").DataTable();
            $('input[name="payment_ids[]"]:checked').each(function() {
                var rowIndex = $(this).closest('tr').index();

                var totalValue = table.cell(rowIndex, 8).data();

                if (typeof totalValue === 'string') {
                    totalValue = totalValue.replace(/\$/g, '');
                }

                totalValue = parseFloat(totalValue);

                if (!isNaN(totalValue)) {
                    totalSum += totalValue;
                }
            });

            return totalSum;
        }

        function drawTable() {

            initializeDataTable(
                "#tbl_revenue_report",
                "admin/reports/revenue/datatables",
                revenueTableColumns,
                null,
                [
                    [0, "desc"]
                ]
            );
        }

        // function toggleRequestButton() {
        //     $("#request_button").prop("disabled", checked.length == 0);
        // }

        async function showErrorMessage(id, ind) {

            // get the error message

            const url = `{{ route('sales-documents.error', ['type' => 'invoices', 'id' => '__id__']) }}`
                .replace('__id__', id);

            const response = await fetch(url, {
                method: 'GET',
                headers: {
                    'Content-Type': 'application/json',
                    'X-CSRF-TOKEN': '{{ csrf_token() }}',
                    'X-Requested-With': 'XMLHttpRequest'
                },
            });

            if (response.ok) {
                const data = await response.json();

                $('#errorModalText').text(data.errorMsg);
                $('#errorModal').modal('show');
            } else {
                console.log(response);
            }
        }

        function exportReport() {

            $(".overlay").show();

            $.ajaxSetup({
                headers: {
                    'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
                }
            });

            $.ajax({
                type: 'POST',
                url: '{{ route('reports.revenue.export') }}',
                data: {
                    'startDate': startDate != undefined ? startDate.format("YYYY/MM/DD") : '',
                    'endDate': endDate != undefined ? endDate.format("YYYY/MM/DD") : '',
                    'client_id': $('#client_id').val(),
                    'status': $('#status').val(),
                    'search_term': $("#tbl_revenue_report").DataTable().search()
                },
                dataType: 'json',
            }).done(function(response) {
                var filename = response.filename;
                var link = document.createElement('a');

                link.download = response.filename;
                link.href = 'admin/exports/download/' + response.filename;

                document.body.appendChild(link);
                link.click();

                document.body.removeChild(link);

                $(".overlay").hide();

            }).fail(function(xhr) {
                if (xhr.status === 401 || xhr.status === 419) {
                    window.location.href = '/login';
                } else {
                    console.log(xhr.statusText);
                }
            });
        }

        $('#date_range_revenue').daterangepicker({
            locale: {
                autoUpdateInput: false,
                format: 'YYYY/MM/DD',
                applyLabel: "Aplicar",
                cancelLabel: "Cancelar",
                fromLabel: "De",
                toLabel: "A",
                customRangeLabel: "Personalizado",
                daysOfWeek: [
                    "Do",
                    "Lu",
                    "Ma",
                    "Mi",
                    "Ju",
                    "Vi",
                    "Sa"
                ],
                monthNames: [
                    "Enero",
                    "Febrero",
                    "Marzo",
                    "Abril",
                    "Mayo",
                    "Junio",
                    "Julio",
                    "Agosto",
                    "Septiembre",
                    "Octubre",
                    "Noviembre",
                    "Diciembre"
                ],
                firstDay: 1
            }
        }, function(start, end, label) {});

        $(".input-group-text i.far.fa-calendar").on("click", function() {
            $("#date_range_revenue").focus();
        });

        $('#date_range_revenue').on('cancel.daterangepicker', function(ev, picker) {
            if (!startDate && !endDate) {
                $('#date_range_revenue').val('');
            }
        });

        $('#date_range_revenue').on('hide.daterangepicker', function() {
            if (!startDate && !endDate) {
                $('#date_range_revenue').val('');
            }
        });

        $('#date_range_revenue').on('apply.daterangepicker', function(ev, picker) {

            if (picker.startDate && picker.endDate) {
                startDate = moment(picker.startDate, 'YYYY/MM/DD');
                endDate = moment(picker.endDate, 'YYYY/MM/DD');

                $('#date_range_revenue').val(startDate.format('YYYY/MM/DD') + ' - ' + endDate.format(
                    'YYYY/MM/DD'));

                drawTable();
            }
        });

        function clearFilters() {

            startDate = undefined;
            endDate = undefined;

            var today = new Date();

            $('#date_range_revenue').data('daterangepicker').setStartDate(today);
            $('#date_range_revenue').data('daterangepicker').setEndDate(today);

            $('#client_id').val('');
            $('#status').val('');
            $('#date_range_revenue').val('');

            drawTable();
        }

        startDate = undefined;
        endDate = undefined;

        $('#date_range_revenue').val('');
    </script>
@endsection