<?php

namespace App\Repository;

use App\Banner;
use App\Document;
use Illuminate\Database\Eloquent\Builder;

class DocumentRepository
{
    const BANNER_PAGE = 1;

    public function index($parameters)
    {
        $query = Document::query();
        $query->leftJoin('document_types as dt', 'documents.document_type_id', '=', 'dt.id');

        $query->orderBy('documents.document_type_id', "desc");
        $query->groupBy('dt.name');

        return $query->get()->toArray();
    }
}