<?php

namespace App\Http\Controllers;

use App\Models\CMSPage;
use App\Models\CSR;
use Artesaos\SEOTools\Facades\OpenGraph;
use Artesaos\SEOTools\Facades\SEOMeta;
use Illuminate\Support\Facades\DB;
use Illuminate\Http\Request;

class CSRController extends Controller
{
    public function index(Request $request) {
        $by_year = $request->filled('year') ? (int) $request->get('year') : 0;
        $by_month = $request->filled('month') ? (int) $request->get('month') : 0;
        $seo = [];

        $query = CSR::query();

        $query->when(
            $by_year > 0, function ($q) use ($by_year) {
                return $q->whereYear('CSRDate', $by_year);
            }
        );

        $query->when(
            in_array($by_month, range(1, 12)), function ($q) use ($by_month) {
                return $q->whereMonth('CSRDate', $by_month);
            }
        );

        $csrInitiatives =  $query->orderBy('CSRDate', 'DESC')->paginate(12)->appends(request()->query());

        $years = CSR::query()
            ->select(DB::raw('YEAR(CSRDate) as publicationYear'))
            ->groupBy('publicationYear')
            ->orderBy('publicationYear', 'DESC')
            ->get();

        $cmsPage = CMSPage::query()
            ->where('Slug', request()->path())
            ->firstOrFail();

        if ($cmsPage) {
            $seo = $cmsPage->seoComponent()->first();
        }

        return view('pages.csr', compact('csrInitiatives', 'years', 'seo'));
    }
}