<?php

namespace App\Repository;

use App\Section;

class SectionRepository
{
    public function showFilterParams($parameters)
    {
        $query = Section::query();
        $query->leftJoin('residential_complexes as rc', 'sections.residental_complex_id', '=', 'rc.id')
            ->leftJoin('plannings as pl', 'sections.id', '=', 'pl.section_id')
            ->when(isset($parameters['rc_slug']), function ($query) use ($parameters) {
                $query->where('rc.code', $parameters['rc_slug']);
            });

        $query
            ->where('sections.is_planning', 1)
            ->where('pl.is_sold', 0)
            ->select('sections.*')
            ->groupBy('sections.id');

        return $query->get();
    }
}