One Hat Cyber Team

Your IP: 216.73.216.53
Server IP: 217.76.53.76
Server: Linux vmi1397931.contaboserver.net 5.4.0-105-generic #119-Ubuntu SMP Mon Mar 7 18:49:24 UTC 2022 x86_64
Server Software: Apache
PHP Version: 8.2.27
Buat File | Buat Folder

Dir : ~/www/wwwroot/test2.webi.com.ng/app/Models/

View File Name : ProjectStage.php

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class ProjectStage extends Model
{
    protected $fillable = [
        'name',
        'order',
        'created_by',
    ];

    public function tasks($project_id)
    {
        $project = Project::find($project_id);
 
        if(\Auth::user() != null){
            $objUser = \Auth::user();
        }
        else{
            $objUser = User::where('id', $project->created_by)->first();
        }

        if($objUser->type == 'client' || $objUser->type == 'company')
        {
            return ProjectTask::where('stage', '=', $this->id)->where('project_id', '=', $project_id)->orderBy('order')->get();
        }
        else
        {
            return ProjectTask::where('stage', '=', $this->id)->where('assign_to', '=', $objUser->id)->where('project_id', '=', $project_id)->orderBy('order')->get();
        }
    }

    public function allTask()
    {
        return $this->hasMany('App\Models\ProjectTask', 'stage', 'id')->with('taskUser');
    }

    public function allTaskFilter($project, $priority, $dueDate)
    {
        $tasks = ProjectTask::where('stage', $this->id);

        if(!empty($project))
        {
            $tasks->where('project_id', $project);
        }
        if(!empty($priority))
        {
            $tasks->where('priority', $priority);
        }
        if(!empty($dueDate))
        {
            $tasks->where('due_date', $dueDate);
        }
        $tasks = $tasks->get();

        return $tasks;

    }


}