<?php

namespace App\Repository\RepairAttachment;

use App\Models\RepairAttachment;

class RepairAttachmentRepository
{

    public static function getAll()
    {
        return RepairAttachment::query()->get();
    }

    public static function getDrafts(?string $beforeDate = null)
    {
        $query = RepairAttachment::query()->whereNull('repair_id');
        if (isset($beforeDate)) {
            $query->whereDate('created_at', '<=', $beforeDate);
        }

        return $query->get();
    }

    public static function getOld()
    {
        return RepairAttachment::query()
            ->whereNotNull('repair_id')
            ->whereDate('created_at', '<=', date('Y-m-d', strtotime('-1 year')))
            ->get();
    }

    public static function getBigJpg()
    {
        return RepairAttachment::query()
            ->where('size', '>=', 1 * 1024 * 1024)
            ->where('is_optimized', false)
            ->whereRaw('LOWER(path) LIKE ?', ['%.jpg'])
            ->get();
    }

}