Server : ApacheSystem : Linux host.digitalbabaji.in 4.18.0-513.11.1.el8_9.x86_64 #1 SMP Wed Jan 17 02:00:40 EST 2024 x86_64 User : addictionfreeind ( 1003) PHP Version : 7.2.34 Disable Function : exec,passthru,shell_exec,system Directory : /home/addictionfreeind/www/admin1/app/Models/ |
Upload File : |
<?php
namespace App\Models;
use Illuminate\Database\Eloquent\Relations\BelongsTo;
/**
* App\Models\ProjectActivity
*
* @property int $id
* @property int $project_id
* @property string $activity
* @property \Illuminate\Support\Carbon|null $created_at
* @property \Illuminate\Support\Carbon|null $updated_at
* @property-read mixed $icon
* @property-read \App\Models\Project $project
* @method static \Illuminate\Database\Eloquent\Builder|ProjectActivity newModelQuery()
* @method static \Illuminate\Database\Eloquent\Builder|ProjectActivity newQuery()
* @method static \Illuminate\Database\Eloquent\Builder|ProjectActivity query()
* @method static \Illuminate\Database\Eloquent\Builder|ProjectActivity whereActivity($value)
* @method static \Illuminate\Database\Eloquent\Builder|ProjectActivity whereCreatedAt($value)
* @method static \Illuminate\Database\Eloquent\Builder|ProjectActivity whereId($value)
* @method static \Illuminate\Database\Eloquent\Builder|ProjectActivity whereProjectId($value)
* @method static \Illuminate\Database\Eloquent\Builder|ProjectActivity whereUpdatedAt($value)
* @mixin \Eloquent
*/
class ProjectActivity extends BaseModel
{
protected $table = 'project_activity';
public function project(): BelongsTo
{
return $this->belongsTo(Project::class, 'project_id');
}
public static function getProjectActivities($projectId, $limit, $userID = null)
{
$projectActivity = ProjectActivity::select('project_activity.id', 'project_activity.project_id', 'project_activity.activity', 'project_activity.created_at', 'project_activity.updated_at');
if ($userID) {
$projectActivity = $projectActivity->join('projects', 'projects.id', '=', 'project_activity.project_id')
->join('project_members', 'project_members.project_id', '=', 'projects.id')
->where('project_members.user_id', '=', $userID);
}
$projectActivity = $projectActivity->where('project_activity.project_id', $projectId)
->orderBy('project_activity.id', 'desc')
->limit($limit)
->get();
return $projectActivity;
}
}