<?php

namespace App\Repositories;

use Illuminate\Support\Facades\DB;

class JobsRepository
{

    private function getMailCount(string $table): int
    {
        return DB::table($table)
            ->where('payload', 'LIKE', '%SendEmailJob%')
            ->orWhere('payload', 'LIKE', '%SendDpoEmailJob%')
            ->count();
    }

    public function getMailQueueCount(): int
    {
        return $this->getMailCount('jobs');
    }

    public function getFailedMailQueueCount(): int
    {
        return $this->getMailCount('failed_jobs');
    }

}