<?php

namespace App\Models;

use App\Models\traits\SetConnection;
use Illuminate\Support\Facades\Auth;
use Illuminate\Database\Eloquent\Model;

class RelationPortalPublic extends Model
{
    use SetConnection;

    protected $fillable = [
        'article_id', 'portal_id', 'type', 'status'
    ];

    const CREATED_AT = null;
    const UPDATED_AT = null;

    public static function getArticleTotal($type, $status)
    {
        $user = Auth::user();

        $article = RelationPortalPublic::query();

        $article->select('article_id');

        $article->where('type', '=', $type);
        if($status != ''){
            $article->where('status', '=', $status);
        }

        $result = $article->count();

        return $result;
    }
    public static function getCountPublic($type, $status)
    {
        $query = RelationPortalPublic::query();

        $query->where('type', '=', $type)->where('status', '=', $status);

        return $query->count();
    }
}