/**
* Execute the job.
*
* @return void
*/
public function handle()
{
//if( ($user->notifyDueTasks) || ($user->notifyDueActions) || ($user->notifyDueRisks) )
$totalcount = 0;
//$messages = array();
$actions = null;
$risks = null;
//check if user wants action emails
if ($this->user->notifyDueActions) {
//compile list of action that are overdue
$actions = Action::where('actionee', $this->user->id)->DueActions()->get();
$totalcount += $actions->count();
//$messages['actions'] = $actions->toArray();
}
//check if user wants risk emails
if ($this->user->notifyDueRisks) {
//compile list of risks that are overdue
$risks = Risk::where('owner', $this->user->id)->DueReview()->get();
$totalcount += $risks->count();
//$messages['risks'] = $risks->toArray();
}
//if there is something due review send it
if ($totalcount > 0) {
appMailer::emailUserDueNotfications($this->user, $actions, $risks);
}
}
public function dashboard($userid)
{
$user = User::findOrFail($userid);
//get programs, workstreams and projects that the user is a member of
$programs = Program::whereHas('Members', function ($q) use($userid) {
$q->where('user_id', $userid);
})->get();
$workstreams = WorkStream::whereHas('Members', function ($q) use($userid) {
$q->where('user_id', $userid);
})->get();
$projects = Project::whereHas('Members', function ($q) use($userid) {
$q->where('user_id', $userid);
})->get();
//get tasks for the user
$tasks = Task::where('action_owner', $userid)->get();
//Get the users actions
$actions = Action::where('actionee', $userid)->get();
//Get risks and issues assigned to the user
$risks = Risk::where('owner', $userid)->orWhere('action_owner', $userid)->get();
//return $risks;
return view('Users.dashboard', compact('user', 'programs', 'workstreams', 'projects', 'tasks', 'risks', 'actions'));
}
public function OverdueIssueCount()
{
return Risk::where('owner', $this->id)->where('is_an_issue', 1)->where('status', 'Open')->where('NextReviewDate', '<', date("Y-m-d H:i:s"))->count();
/* $action_owner_count = Risk::where('action_owner', $this->id)->where('is_an_issue', 1)->where('status','Open')->where('NextReviewDate', '<', date("Y-m-d H:i:s") )->count();
return $ownercount + $action_owner_count;*/
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id, Request $request)
{
//$risk = Risk::findOrFail($id);
$subject = Risk::where('id', $id)->with('AuditTrail')->first();
$risksubjectid = $subject->subject_id;
$risksubjecttype = $subject->subject_type;
$title = "Risk {$subject->title} for {$subject->subject_type} " . Breadcrumbs::getSubjectName($risksubjecttype, $risksubjectid);
$breadcrumbs = Breadcrumbs::getBreadCrumb($risksubjecttype, $risksubjectid);
$breadcrumbs[] = ['Risks', '', false];
$breadcrumbs[] = [$subject->title, '', true];
$subjecttype = 'Risk';
//return $risk;
return view('RisksAndIssues.show', compact('subject', 'title', 'breadcrumbs', 'risksubjectid', 'risksubjecttype', 'subjecttype'));
}
