PublishedTrait::applyPublisedConditions() - Code Metrics - jidaikobo-shibata/kontiki-framework - Measure and Improve Code Quality continuously with Scrutinizer

PublishedTrait::applyPublisedConditions() A
last analyzed 2025-08-17 07:33 UTC

↳ Parent: PublishedTrait

Complexity

Conditions	1
Paths	1

Size

Total Lines	6
Code Lines	4

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	1
eloc	4
nc	1
nop	1
dl	0
loc	6
rs	10
c	1
b	0
f	0

<?php

namespace Jidaikobo\Kontiki\Models\Traits;

use Carbon\Carbon;
use Illuminate\Database\Query\Builder;

trait PublishedTrait
{
    protected string $publishedField = 'published_at';

    /**
     * Apply conditions to retrieve published posts.
     *
     * Conditions:
     * - Includes posts where `published_at` is `NULL` (considered as already published).
     * - Includes posts where `published_at` is in the past or equal to the current time.
     *
     * @param Builder $query The query builder instance.
     * @return Builder The modified query with applied conditions.
     */
    public function applyPublisedConditions(Builder $query): Builder
    {
        $currentTime = Carbon::now('UTC')->format('Y-m-d H:i:s');
        return $query->where(function ($q) use ($currentTime) {
            $q->whereNull($this->publishedField) // Consider NULL as published
              ->orWhere($this->publishedField, '<=', $currentTime);
        });
    }

    /**
     * Apply conditions to retrieve scheduled (future) posts.
     *
     * Conditions:
     * - Excludes posts where `published_at` is `NULL` (not scheduled).
     * - Includes posts where `published_at` is in the future.
     *
     * @param Builder $query The query builder instance.
     * @return Builder The modified query with applied conditions.
     */
    public function applyNotPublisedConditions(Builder $query): Builder
    {
        $currentTime = Carbon::now('UTC')->format('Y-m-d H:i:s');
        return $query->whereNotNull($this->publishedField) // Exclude NULL (not scheduled)
                     ->where($this->publishedField, '>', $currentTime);
    }
}


1			<?php
2
3			namespace Jidaikobo\Kontiki\Models\Traits;
4
5			use Carbon\Carbon;
6			use Illuminate\Database\Query\Builder;
7
8			trait PublishedTrait
9			{
10			protected string $publishedField = 'published_at';
11
12			/**
13			* Apply conditions to retrieve published posts.
14			*
15			* Conditions:
16			* - Includes posts where `published_at` is `NULL` (considered as already published).
17			* - Includes posts where `published_at` is in the past or equal to the current time.
18			*
19			* @param Builder $query The query builder instance.
20			* @return Builder The modified query with applied conditions.
21			*/
22			public function applyPublisedConditions(Builder $query): Builder
23			{
24			$currentTime = Carbon::now('UTC')->format('Y-m-d H:i:s');
25			return $query->where(function ($q) use ($currentTime) {
26			$q->whereNull($this->publishedField) // Consider NULL as published
27			->orWhere($this->publishedField, '<=', $currentTime);
28			});
29			}
30
31			/**
32			* Apply conditions to retrieve scheduled (future) posts.
33			*
34			* Conditions:
35			* - Excludes posts where `published_at` is `NULL` (not scheduled).
36			* - Includes posts where `published_at` is in the future.
37			*
38			* @param Builder $query The query builder instance.
39			* @return Builder The modified query with applied conditions.
40			*/
41			public function applyNotPublisedConditions(Builder $query): Builder
42			{
43			$currentTime = Carbon::now('UTC')->format('Y-m-d H:i:s');
44			return $query->whereNotNull($this->publishedField) // Exclude NULL (not scheduled)
45			->where($this->publishedField, '>', $currentTime);
46			}
47			}
48

jidaikobo-shibata / kontiki-framework

PublishedTrait::applyPublisedConditions() A last analyzed 2025-08-17 07:33 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

PublishedTrait::applyPublisedConditions() A
last analyzed 2025-08-17 07:33 UTC