<?php

namespace App\Http\Controllers;

use App\Models\CMSPage;
use App\Models\EnvironmentCompliance;
use Illuminate\Support\Facades\DB;

class EnvironmentComplianceController extends Controller
{
    public function index()
    {
        $seo = [];

        $cm = EnvironmentCompliance::select('id', 'ComplianceName', 'ComplianceType', DB::raw('YEAR(ComplianceDate) as year, MONTH(ComplianceDate) as month'))
            ->where('ComplianceType', 'Monthly')
            ->orderBy('ComplianceType', 'ASC')
            ->get();

        $cy = EnvironmentCompliance::select('id', 'ComplianceName', 'ComplianceType', DB::raw('YEAR(ComplianceDate) as year, MONTH(ComplianceDate) as month'))
            ->where('ComplianceType', 'Annually')
            ->orderBy('ComplianceDate', 'DESC')
            ->get();

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

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

        return view('pages.environment-compliances', compact('cy', 'cm', 'seo'));
    }
}