<?php

namespace App\Http\Controllers;

use App\Models\data_kpmd;
use App\Models\data_deswita;
use App\Models\data_bumdes;
use App\Models\data_clatrans;
use Illuminate\Http\Request;
use Carbon\Carbon;

class landingController extends Controller
{
    public function index()
    {
        $dataChartKPMD = [];
        $dataChartDesWita = [];
        $dataChartCalTrans = [];
        $dataChartBumDes = [];
        $namaBulan = [
            'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun',
            'Jul', 'Agu', 'Sept', 'Okt', 'Nov', 'Des'
        ];
        $kategori = [];
        $currentYear = Carbon::now()->year;
        for ($bulan = 1; $bulan <= 12; $bulan++) {
            $totalPelayananKPMD = data_kpmd::whereRaw('EXTRACT(YEAR FROM created_at) = ?', [$currentYear])
                ->whereRaw('EXTRACT(MONTH FROM created_at) = ?', [$bulan])->count();
            $totalPelayananDesWita = data_deswita::whereRaw('EXTRACT(YEAR FROM created_at) = ?', [$currentYear])
                ->whereRaw('EXTRACT(MONTH FROM created_at) = ?', [$bulan])->count();
            $totalPelayananCalTrans = data_clatrans::whereRaw('EXTRACT(YEAR FROM created_at) = ?', [$currentYear])
                ->whereRaw('EXTRACT(MONTH FROM created_at) = ?', [$bulan])->count();
            $totalPelayananBumDes = data_bumdes::whereRaw('EXTRACT(YEAR FROM created_at) = ?', [$currentYear])
                ->whereRaw('EXTRACT(MONTH FROM created_at) = ?', [$bulan])->count();

            $dataChartKPMD[] = intval($totalPelayananKPMD);
            $dataChartDesWita[] = intval($totalPelayananDesWita);
            $dataChartCalTrans[] = intval($totalPelayananCalTrans);
            $dataChartBumDes[] = intval($totalPelayananBumDes);
            $kategori[] = strval($namaBulan[$bulan - 1]);
        }

        $tahunSaatIni = date("Y");

        $dataChartKPMDtahun = [];
        $dataChartDesWitatahun = [];
        $dataChartCalTranstahun = [];
        $dataChartBumDestahun = [];
        // Inisialisasi array tahun
        $tahunCharts = array();

        // Mengisi array dengan 12 tahun, dimulai dari 12 tahun yang lalu
        for ($i = ($tahunSaatIni + 1) - 12; $i < $tahunSaatIni + 1; $i++) {
            $tahunCharts[] = $i;
        }
        for ($bulan = 1; $bulan <= 12; $bulan++) {
            // var_dump($tahunCharts[$bulan]);
            $totalPelayananKPMD = data_kpmd::whereRaw('EXTRACT(YEAR FROM created_at) = ?', [$tahunCharts[$bulan - 1]])->count();
            $totalPelayananDesWita = data_deswita::whereRaw('EXTRACT(YEAR FROM created_at) = ?', [$tahunCharts[$bulan - 1]])->count();
            $totalPelayananCalTrans = data_clatrans::whereRaw('EXTRACT(YEAR FROM created_at) = ?', [$tahunCharts[$bulan - 1]])->count();
            $totalPelayananBumDes = data_bumdes::whereRaw('EXTRACT(YEAR FROM created_at) = ?', [$tahunCharts[$bulan - 1]])->count();

            $dataChartKPMDtahun[] = intval($totalPelayananKPMD);
            $dataChartDesWitatahun[] = intval($totalPelayananDesWita);
            $dataChartCalTranstahun[] = intval($totalPelayananCalTrans);
            $dataChartBumDestahun[] = intval($totalPelayananBumDes);
        }
        return view('layout.index', compact('dataChartKPMD', 'dataChartDesWita', 'dataChartCalTrans', 'dataChartBumDes', 'kategori', 'dataChartKPMDtahun', 'dataChartDesWitatahun', 'dataChartCalTranstahun', 'dataChartBumDestahun', 'tahunCharts'));
        // dd($dataChartBumDes);
    }
    public function indexdashboard()
    {
        $dataChartKPMD = [];
        $dataChartDesWita = [];
        $dataChartCalTrans = [];
        $dataChartBumDes = [];
        $namaBulan = [
            'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun',
            'Jul', 'Agu', 'Sept', 'Okt', 'Nov', 'Des'
        ];
        $kategori = [];
        $currentYear = Carbon::now()->year;
        for ($bulan = 1; $bulan <= 12; $bulan++) {
            $totalPelayananKPMD = data_kpmd::whereRaw('EXTRACT(YEAR FROM created_at) = ?', [$currentYear])
                ->whereRaw('EXTRACT(MONTH FROM created_at) = ?', [$bulan])->count();
            $totalPelayananDesWita = data_deswita::whereRaw('EXTRACT(YEAR FROM created_at) = ?', [$currentYear])
                ->whereRaw('EXTRACT(MONTH FROM created_at) = ?', [$bulan])->count();
            $totalPelayananCalTrans = data_clatrans::whereRaw('EXTRACT(YEAR FROM created_at) = ?', [$currentYear])
                ->whereRaw('EXTRACT(MONTH FROM created_at) = ?', [$bulan])->count();
            $totalPelayananBumDes = data_bumdes::whereRaw('EXTRACT(YEAR FROM created_at) = ?', [$currentYear])
                ->whereRaw('EXTRACT(MONTH FROM created_at) = ?', [$bulan])->count();

            $dataChartKPMD[] = intval($totalPelayananKPMD);
            $dataChartDesWita[] = intval($totalPelayananDesWita);
            $dataChartCalTrans[] = intval($totalPelayananCalTrans);
            $dataChartBumDes[] = intval($totalPelayananBumDes);
            $kategori[] = strval($namaBulan[$bulan - 1]);
        }

        $tahunSaatIni = date("Y");

        $dataChartKPMDtahun = [];
        $dataChartDesWitatahun = [];
        $dataChartCalTranstahun = [];
        $dataChartBumDestahun = [];
        // Inisialisasi array tahun
        $tahunCharts = array();

        // Mengisi array dengan 12 tahun, dimulai dari 12 tahun yang lalu
        for ($i = ($tahunSaatIni + 1) - 12; $i < $tahunSaatIni + 1; $i++) {
            $tahunCharts[] = $i;
        }
        for ($bulan = 1; $bulan <= 12; $bulan++) {
            // var_dump($tahunCharts[$bulan]);
            $totalPelayananKPMD = data_kpmd::whereRaw('EXTRACT(YEAR FROM created_at) = ?', [$tahunCharts[$bulan - 1]])->count();
            $totalPelayananDesWita = data_deswita::whereRaw('EXTRACT(YEAR FROM created_at) = ?', [$tahunCharts[$bulan - 1]])->count();
            $totalPelayananCalTrans = data_clatrans::whereRaw('EXTRACT(YEAR FROM created_at) = ?', [$tahunCharts[$bulan - 1]])->count();
            $totalPelayananBumDes = data_bumdes::whereRaw('EXTRACT(YEAR FROM created_at) = ?', [$tahunCharts[$bulan - 1]])->count();

            $dataChartKPMDtahun[] = intval($totalPelayananKPMD);
            $dataChartDesWitatahun[] = intval($totalPelayananDesWita);
            $dataChartCalTranstahun[] = intval($totalPelayananCalTrans);
            $dataChartBumDestahun[] = intval($totalPelayananBumDes);
        }
        // dd($tahunCharts);
        return view('Admin.layout.index', compact('dataChartKPMD', 'dataChartDesWita', 'dataChartCalTrans', 'dataChartBumDes', 'kategori', 'dataChartKPMDtahun', 'dataChartDesWitatahun', 'dataChartCalTranstahun', 'dataChartBumDestahun', 'tahunCharts'));
        dd($dataChartBumDes);
    }


    public function getDataByYear(Request $request)
    {
        return response()->json();
    }

    public function getDataByMonth()
    {
        return response()->json();
    }
}