@extends('templates.main')
@section('content')
    @php

        use Carbon\Carbon;
        function name_days($ke)
        {
            $tgl = date('Y-m-d', time() - 60 * 60 * 24 * $ke);
            $create = Carbon::create($tgl, 'Asia/Jakarta');
            $grafik = $create->format('l');
            if ($grafik == 'Monday') {
                $g = 'Senin';
            } elseif ($grafik == 'Tuesday') {
                $g = 'Selasa';
            } elseif ($grafik == 'Wednesday') {
                $g = 'Rabu';
            } elseif ($grafik == 'Thursday') {
                $g = 'Kamis';
            } elseif ($grafik == 'Friday') {
                $g = 'Jumat';
            } elseif ($grafik == 'Saturday') {
                $g = 'Sabtu';
            } elseif ($grafik == 'Sunday') {
                $g = 'Minggu';
            }
            return $g;
        }

    @endphp
    <div class="row">
        <div class="col-lg-4 col-md-6">
            <div class="card">
                <div class="card-body">
                    <div class="d-flex align-items-center">
                        <div class="flex-shrink-0">
                            <div class="avtar bg-light-primary"><i class="fa-solid fa-chart-column"></i>
                            </div>
                        </div>
                        <div class="flex-grow-1 ms-3">
                            <p class="mb-1">Saldo Anda</p>
                            <div class="d-flex align-items-center justify-content-between">
                                @if (auth()->user()->saldo > 500000)
                                    <h5 class="mb-1">Unlimited</h5>
                                @else
                                    <h5 class="mb-1">Rp {{ number_format(auth()->user()->saldo, 0, ',', '.') }}</h5>
                                @endif
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        @php
            $historyCount = App\Models\History::where('reseller', Auth::user()->name)->count();
        @endphp
        <div class="col-lg-4 col-md-6">
            <div class="card">
                <div class="card-body">
                    <div class="d-flex align-items-center">
                        <div class="flex-shrink-0">
                            <div class="avtar bg-light-primary">
                                <i class="fas fa-shopping-cart f-18"></i>
                            </div>
                        </div>
                        <div class="flex-grow-1 ms-3">
                            <p class="mb-1">Total Transaksi</p>
                            <div class="d-flex align-items-center justify-content-between">
                                <h4 class="mb-0">{{ $historyCount }}</h4>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        @php
            $incode = App\Models\History::where('reseller', Auth::user()->name)
                ->selectRaw('SUM(REPLACE(REPLACE(harga, "Rp.", ""), ".", "")) as total_pendapatan')
                ->value('total_pendapatan');
        @endphp
        <div class="col-lg-4 col-md-6">
            <div class="card">
                <div class="card-body">
                    <div class="d-flex align-items-center">
                        <div class="flex-shrink-0">
                            <div class="avtar bg-light-primary">
                                <i class="fa-solid fa-user-tie f-18"></i>
                            </div>
                        </div>
                        <div class="flex-grow-1 ms-3">
                            <p class="mb-1">Role</p>
                            <div class="d-flex align-items-center justify-content-between">
                                <h4 class="mb-0">{{ Auth::user()->level }}</h4>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <div class="card">
        <div class="card-body">
            <div class="d-flex align-items-start justify-content-between mb-3">
                <h5 class="mb-0">Sales analysis</h5>
            </div>
            <div class="row">
                <div class="col-lg-7 col-xl-8">
                    <div class="tab-content" id="myTabContent">
                        <div class="tab-pane fade show active" id="analytics-tab-1-pane" role="tabpanel"
                            aria-labelledby="analytics-tab-1" tabindex="0">
                            <div id="overview-chart-1"></div>
                        </div>
                    </div>
                </div>
                <div class="col-lg-5 col-xl-4">
                    @php
                        $pendapatan = App\Models\History::where('reseller', Auth::user()->name)
                            ->selectRaw('SUM(REPLACE(REPLACE(harga, "Rp.", ""), ".", "")) as total_pendapatan')
                            ->value('total_pendapatan');
                        $bulanini = App\Models\History::where('reseller', Auth::user()->name)
                            ->whereMonth('created_at', now()->month)
                            ->selectRaw('SUM(REPLACE(REPLACE(harga, "Rp.", ""), ".", "")) as total_pendapatan')
                            ->value('total_pendapatan');
                    @endphp
                    <ul class="list-group list-group-flush">
                        <li class="list-group-item">
                            <div class="d-flex align-items-center">
                                <div class="flex-shrink-0">
                                    <div class="avtar avtar-s bg-light-secondary"><i class="ti ti-chart-bar f-20"></i>
                                    </div>
                                </div>
                                <div class="flex-grow-1 ms-3">
                                    <div class="row g-1">
                                        <div class="col">
                                            <p class="text-muted mb-1">Total Pendapatan</p>
                                            <h6 class="mb-0">
                                                Rp {{ number_format($pendapatan, 0, ',', '.') }}
                                            </h6>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </li>
                        <li class="list-group-item">
                            <div class="d-flex align-items-center">
                                <div class="flex-shrink-0">
                                    <div class="avtar avtar-s bg-light-secondary"><i
                                            class="ti ti-chart-arrows-vertical f-20"></i></div>
                                </div>
                                <div class="flex-grow-1 ms-3">
                                    <div class="row g-1">
                                        <div class="col">
                                            <p class="text-muted mb-1">Pendapatan Bulan Ini</p>
                                            <h6 class="mb-0">

                                                Rp {{ number_format($bulanini, 0, ',', '.') }}
                                            </h6>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </li>
                    </ul>
                </div>
            </div>
        </div>
    </div>
@endsection
@php
    // buatkan array dari januari sampai bulan ini, dan jika bulan ini adalah januari maka arraynya adalah januari saja
    function get_months_until_now($format = 'F')
    {
        $months = [];
        for ($i = 1; $i <= now()->month; $i++) {
            $months[] = now()
                ->startOfMonth()
                ->subMonths($i - 1)
                ->format($format);
        }
        return array_reverse($months);
    }
    $bulan = get_months_until_now();
    $count = count($bulan);
    $register = [];
    $extended = [];
    foreach ($bulan as $key => $value) {
        $plus = $key + 1;
        $register[] = App\Models\History::where('barang', 'like', '%Order%')
            ->where('reseller', Auth::user()->name)
            ->whereMonth('created_at', $plus)
            ->count();
        $extended[] = App\Models\History::where('barang', 'like', '%Perpanjang%')
            ->where('reseller', Auth::user()->name)
            ->whereMonth('created_at', $plus)
            ->count();
    }
@endphp
@section('scripts')
    <script>
        var e = {
            chart: {
                height: 250,
                type: "bar",
                toolbar: {
                    show: !1
                }
            },
            plotOptions: {
                bar: {
                    horizontal: !1,
                    columnWidth: "55%",
                    borderRadius: 4,
                    borderRadiusApplication: "end",
                },
            },
            legend: {
                show: !0,
                position: "top",
                horizontalAlign: "left"
            },
            dataLabels: {
                enabled: !1
            },
            colors: ["#4680FF", "#092e7d"],
            stroke: {
                show: !0,
                width: 3,
                colors: ["transparent"]
            },
            fill: {
                colors: ["#4680FF", "#092e7d"],
                opacity: [1, 0.5]
            },
            grid: {
                strokeDashArray: 4
            },
            series: [{
                    name: "Register",
                    data: @json($register)
                },
                {
                    name: "Extended",
                    data: @json($extended)
                },
            ],
            xaxis: {
                categories: [
                    @foreach ($bulan as $key => $value)
                        '{{ $value }}',
                    @endforeach
                ],
            },
            tooltip: {
                y: {
                    formatter: function(e) {
                        return "" + e + " Transaksi";
                    },
                },
            },
        };
        new ApexCharts(document.querySelector("#overview-chart-1"), e).render();
    </script>
@endsection