Chriscreate\Blog\Traits\Post\PostScopes

Complexity

Total Complexity

7

Size/Duplication

Total Lines	61
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	4

Importance

Changes

0

7 Methods

Rating	Name	Duplication	Size	Complexity
A	scopePublished()	0	10	1
A	scopeScheduled()	0	7	1
A	scopeDraft()	0	7	1
A	scopeNotPublished()	0	8	1
A	scopeOrderByLatest()	0	4	1
A	scopePublishedLastMonth()	0	7	1
A	scopePublishedLastWeek()	0	6	1

<?php

namespace Chriscreate\Blog\Traits\Post;

use Carbon\Carbon;
use Illuminate\Database\Eloquent\Builder;

trait PostScopes
{
    use PostCategoryScopes,
    PostTagScopes;

    public function scopePublished(Builder $query)
    {
        return $query->where(function (Builder $query) {
            return $query->where('status', self::PUBLISHED)
            ->whereNotNull('published_at');
        })->orWhere(function (Builder $query) {
            return $query->where('status', self::SCHEDULED)
            ->where('published_at', '<=', Carbon::now());
        });
    }

    public function scopeScheduled(Builder $query)
    {
        return $query->where(function (Builder $query) {
            return $query->where('status', self::SCHEDULED)
            ->where('published_at', '>', Carbon::now());
        });
    }

    public function scopeDraft(Builder $query)
    {
        return $query->where(function (Builder $query) {
            return $query->where('status', self::DRAFT)
            ->whereNull('published_at');
        });
    }

    public function scopeNotPublished(Builder $query)
    {
        return $query->where(function (Builder $query) {
            return $query->draft();
        })->orWhere(function (Builder $query) {
            return $query->scheduled();
        });
    }

    public function scopeOrderByLatest(Builder $query)
    {
        return $query->orderBy('published_at', 'DESC');

The method orderBy() does not exist on Illuminate\Database\Eloquent\Builder. Did you maybe mean enforceOrderBy()?

    }

    public function scopePublishedLastMonth(Builder $query, int $limit = 5)
    {
        return $query->whereBetween('published_at', [
            Carbon::now()->subMonth(), Carbon::now(),
        ])->orderByLatest()
        ->limit($limit);
    }

    public function scopePublishedLastWeek(Builder $query)
    {
        return $query->whereBetween('published_at', [
            Carbon::now()->subWeek(), Carbon::now(),
        ])->orderByLatest();
    }
}