<?php namespace App\Libs\Composers;

use App\Models\DefaultTemplateConfiguration;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Lang;

class PressReleaseComposer
{
    use SidebarComposerTrait;

    public function compose($view)
    {
        $year = date('Y');
        /*
        $pressReleases = PressRelease::full()
            ->with('media', 'document')
            ->orderBy('website_objects.position', 'asc')->get();
        */
        $this->composeSidebar($view, DefaultTemplateConfiguration::query());

        $years = array();
        $availYears = DB::table('press_releases')
            ->select(DB::raw('DISTINCT YEAR(date) as year'))
            ->whereNull('deleted_at')
            ->orderBy('year', 'desc')
            ->get();
        array_push($years, array("id" => "all", "label" => Lang::get('frontend.all')));
        foreach ($availYears as $year) {
            array_push($years, array("id" => $year->year, "label" => $year->year));
        }

        $view->with(array(
            // 'pressReleases' => $pressReleases,
            'filters' => array(
                array("id" => "year", "name" => Lang::get('frontend.year'), "values" => $years)
            )
        ));
    }
}
