<?php

namespace App\Repository\Document;

use App\Models\Document;
use App\Repository\BaseRepository;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Support\Facades\DB;

class DocumentRepository extends BaseRepository
{

    public static function getQuery(): Builder
    {
        return Document::query();
    }

    public static function getDocumentsForReport(int $serviceId, string $startDate, string $endDate): Builder
    {
        return self::getQuery()->where('service_id', $serviceId)->whereBetween(DB::raw('DATE(date)'), [$startDate, $endDate]);
    }

}