@extends('admin.layouts.app')

@section('content')
    @include('admin.layouts.partial.toolbar', ['breadcrumb' => 'Performance Reports'])

    <div id="kt_app_content" class="app-content flex-column-fluid">
        <!--begin::Content container-->
        <div id="kt_app_content_container" class="app-container container-xxl">
            <!--begin::Card-->
            <div class="card">
                <!--begin::Card header-->
                <div class="card-header border-0 pt-6">
                    <!--begin::Card title-->
                    <div class="card-title">
                        <!--begin::Search-->
                        <h2>Performance Report</h2>
                        <!--end::Search-->
                    </div>
                    <!--begin::Card title-->
                    <!--begin::Card toolbar-->
                    <div class="card-toolbar">
                        <!--begin::Toolbar-->
                        <div class="d-flex justify-content-end" data-kt-table-toolbar="base">
                            <!--begin::Filter-->
                            <div class="w-150px me-3">
                                <!--begin::Select2-->
                                <select class="form-select form-select-solid" data-control="select2" data-hide-search="true"
                                    data-placeholder="Status" data-kt-filter="year" onchange="changeYear(this)">
                                    @foreach ($years as $key => $year)
                                        <option value="{{ $year }}"
                                            @if ($current == $year) selected @endif>{{ $year }}</option>
                                    @endforeach
                                </select>
                                <!--end::Select2-->
                            </div>
                        </div>
                        <!--end::Toolbar-->
                    </div>
                    <!--end::Card toolbar-->
                </div>
                <!--end::Card header-->
                <!--begin::Card body-->
                <div class="p-10">
                    <canvas id="myChart"></canvas>
                </div>
                <div class="card-body pt-0 overflow-auto table-responsive">

                    <table class="table tatable-hover table-bordered fs-6 gy-5" id="kt_report_table">
                        <thead class="table-light">
                            <tr class="text-gray-800 fs-7 text-uppercase gs-0">
                                <th>Category</th>
                                <th>Sub Category</th>
                                @foreach (months('F') as $month)
                                    <th>{{ $month }}</th>
                                @endforeach
                                <th>Total Fiscal Year</th>
                                <th>Average</th>
                            </tr>
                        </thead>
                        @php
                            $s_total = $m_total = $f_total = $r_total = $v_cost_change = 0;
                        @endphp
                        <tbody class="fw-semibold text-gray-600">
                            <tr>
                                <td>Revenues, net</td>
                                <td>Storage</td>
                                @foreach (months('n') as $month)
                                    @php($s_total += $storage[$month])
                                    <td>{{ $storage[$month] }}</td>
                                @endforeach
                                <td>{{ number_format($s_total, 2) }}</td>
                                <td>{{ number_format($s_total / 12, 2) }}</td>
                            </tr>
                            <tr>
                                <td>Revenues, net</td>
                                <td>Fulfillment</td>
                                @foreach (months('n') as $month)
                                    @php($f_total += $fulfill[$month])
                                    <td>{{ $fulfill[$month] }}</td>
                                @endforeach
                                <td>{{ $f_total }}</td>
                                <td></td>
                            </tr>
                            <tr>
                                <td>Revenues, net, total</td>
                                <td>Revenues, net, total</td>
                                @foreach (months('n') as $month)
                                    @php($m_total += $total[$month])
                                    <td>{{ $total[$month] }}</td>
                                @endforeach
                                <td>{{ number_format($m_total, 2) }}</td>
                                <td>{{ number_format($m_total / 12, 2) }}</td>
                            </tr>
                            <tr>
                                <td>Revenues, change</td>
                                <td>revenue development compared to previous month in %</td>
                                @foreach (months('n') as $month)
                                    @php($value = $total[$month - 1] ?? 0)
                                    <td>{{ $value != 0 ? number_format(($total[$month] - $value) / $value, 2) : 0 }}
                                        %</td>
                                @endforeach
                                <td></td>
                                <td></td>
                            </tr>
                            <tr>
                                <td>Revenues, change</td>
                                <td>revenue development compared to previous month</td>
                                @foreach (months('n') as $month)
                                                                        <td>{{ number_format($revenue, 2) }}</td>
                                @endforeach
                                <td>{{ number_format($r_total, 2) }}</td>
                                <td>{{ number_format($r_total / 12, 2) }}</td>
                            </tr>
                            @foreach ($vars as $name => $var)
                                <tr>
                                    <td>Variable costs, net</td>
                                    <td>{{ $name }}</td>
                                    @foreach (months('n') as $month)
                                        <td>{{ number_format($var[$month], 2) }}</td>
                                    @endforeach
                                    <td></td>
                                    <td></td>
                                </tr>
                            @endforeach

                            <tr>
                                <td>Total variable cost´s</td>
                                <td>Total variable cost´s</td>
                                @foreach (months('n') as $month)
                                    <td>{{ number_format($var_total[$month], 2) }}</td>
                                @endforeach
                                <td></td>
                                <td></td>
                            </tr>
                            <tr>
                                <td>variable cost change</td>
                                <td>cost development compared to previous month in %</td>
                                @foreach (months('n') as $month)
                                    @php($value = $total[$month - 1] ?? 0)
                                    <td>{{ $value != 0 ? number_format(($var_total[$month] - $value) / $value, 2) : 0 }}
                                        %</td>
                                @endforeach
                                <td></td>
                                <td></td>
                            </tr>
                            <tr>
                                <td>variable cost change</td>
                                <td>cost development compared to previous month</td>
                                @foreach (months('n') as $month)
                                                                        <td>{{ number_format($vc_change, 2) }}</td>
                                @endforeach
                                <td>{{ number_format($v_cost_change, 2) }}</td>
                                <td>{{ number_format($v_cost_change / 12, 2) }}</td>
                            </tr>
                            <tr>
                                <td>Contribution margin 1</td>
                                <td>surplus/underfunding</td>
                                @php($cm_total = 0)
                                @foreach (months('n') as $month)
                                                                        <td>{{ number_format($cm, 2) }}</td>
                                @endforeach
                                <td>{{ number_format($cm_total, 2) }}</td>
                                <td>{{ number_format($cm_total / 12, 2) }}</td>
                            </tr>
                            @foreach ($fixed as $name => $fix)
                                <tr>
                                    <td>fix costs, net</td>
                                    <td>{{ $name }}</td>
                                    @foreach (months('n') as $month)
                                        <td>{{ number_format($fix[$month], 2) }}</td>
                                    @endforeach
                                    <td></td>
                                    <td></td>
                                </tr>
                            @endforeach
                            <tr>
                                <td>fix cost´s total</td>
                                <td>fix cost´s total</td>
                                @foreach (months('n') as $month)
                                    <td>{{ number_format($fix_total[$month], 2) }}</td>
                                @endforeach
                                <td></td>
                                <td></td>
                            </tr>
                            <tr>
                                <td>Break-Even Margin (variable+fix cost´s)</td>
                                <td>B/E</td>
                                @php($be_total = 0)
                                @foreach (months('n') as $month)
                                                                        <td>{{ number_format($be, 2) }}</td>
                                @endforeach
                                <td>{{ number_format($be_total, 2) }}</td>
                                <td>{{ number_format($be_total / 12, 2) }}</td>
                            </tr>
                            <tr>
                                <td>Contribution margin 2</td>
                                <td>Operating result (EBIT)</td>
                                @php($cm_total_2 = 0)
                                @foreach (months('n') as $month)
                                                                        <td>{{ number_format($cm_2, 2) }}</td>
                                @endforeach
                                <td>{{ number_format($cm_total_2, 2) }}</td>
                                <td>{{ number_format($cm_total_2 / 2, 2) }}</td>
                            </tr>
                            <tr>
                                <td>Contribution margin 2</td>
                                <td>EBIT in %</td>
                                @foreach (months('n') as $month)
                                    <td>{{ $total[$month] != 0 ? number_format(($total[$month] - $var_total[$month] - $fix_total[$month]) / $total[$month], 2) : 0 }}%
                                    </td>
                                @endforeach
                                <td>{{ $m_total != 0 ? number_format($cm_total_2 / $m_total, 2) : 0 }}%</td>
                                <td></td>
                            </tr>
                        </tbody>
                    </table>
                </div>
                <!--end::Card body-->
            </div>
            <!--end::Card-->
        </div>
        <!--end::Content container-->
    </div>
    <!--end::Content-->
@endsection

@push('scripts')
    <script src="{{ asset('user/js/chart.js') }}"></script>

    <script>
        const labels = [];
        const fulfilment = [];
        const storage = [];
        const variable = [];
        const fixed = [];
        @foreach (months('M') as $month)
            labels.push("{{ $month }}");
        @endforeach
        @foreach (months('n') as $month)
            fulfilment.push("{{ $fulfill[$month] }}");
            storage.push("{{ $storage[$month] }}");
            variable.push("{{ $var_total[$month] }}");
            fixed.push("{{ $fix_total[$month] }}");
        @endforeach
        const data = {
            labels: labels,
            datasets: [{
                    label: 'Fulfilment',
                    data: fulfilment,
                    stack: 'Stack 0',
                },
                {
                    label: 'Storage',
                    data: storage,
                    stack: 'Stack 0',
                },
                {
                    label: 'Variable',
                    data: variable,
                    stack: 'Stack 1',
                },
                {
                    label: 'Fixed',
                    data: fixed,
                    stack: 'Stack 1',
                },
            ]
        };
        const config = {
            type: 'bar',
            data: data,
            options: {
                plugins: {
                    title: {
                        display: true,
                        text: 'Performance Chart'
                    },
                },
                responsive: true,
                interaction: {
                    intersect: false,
                },
                scales: {
                    x: {
                        stacked: true,
                    },
                    y: {
                        stacked: true,
                        ticks: {
                            callback: function(value, index, values) {
                                return value +' €' ;
                            }
                        }
                    },
                }
            }
        };
        var ctx = document.getElementById('myChart').getContext('2d');
        var myChart = new Chart(ctx, config);

        function changeYear(ele) {
            let val = $(ele).val();
            location.href = `{{ route('admin.report.list') }}?year=${val}`
        }
    </script>
@endpush