RootZanli & NinjaCr3

: / home / o5t6x7pgljbm / public_html / app / Models /
Filename : TaskAssigned.php
back
<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\HasMany;
use Illuminate\Database\Eloquent\Relations\HasOne;

class TaskAssigned extends Model
{
    protected $table = 'task_assigned';

    protected $primaryKey = 'task_assigned_id';

    /**
     * The attributes that are mass assignable.
     *
     * @var array
    */
    protected $fillable = [
        'user_id', 'task_id', 'status', 'task_details_for_approval', 'created_at', 'updated_at'
    ];

    public static function isTaskAssignmentPresent($user_id, $task_id){
        $taskAssignment = TaskAssigned::select("*")
                    ->where("user_id", $user_id)
                    ->where("task_id", $task_id)
                    ->first();

        if(isset($taskAssignment) &&
                isset($taskAssignment->task_assigned_id)
                && $taskAssignment->task_assigned_id > 0)
            return true;
        else
            return false;
    }

    public function approval_files(): HasMany
    {
        return $this->hasMany('App\Models\TaskAssignedApprovalFile', 'task_assigned_id', 'task_assigned_id');
    }

    public function task(): HasOne
    {
        return $this->hasOne('App\Models\Task', 'task_id','task_id');
    }

    public function assigned_to_user(): HasOne
    {
        return $this->hasOne('App\Models\User', 'user_id','user_id');
    }
}