public function closeActionItem($id) { if (Auth::User()->hasRole(['administrator', 'approver'])) { $json['status'] = 1; $json['text'] = "Action item closed"; $json['title'] = 'Complete!'; $json['id'] = $id; $json['closed'] = Carbon::now()->toFormattedDateString(); Actions::where('id', $id)->update(['action_status' => 'Closed', 'closed_on' => Carbon::now()->toDateString()]); } else { $json['status'] = 0; $json['text'] = "You do not have the correct privileges"; $json['title'] = 'Error!'; } return $json; }
public function getOpenActions() { return Actions::where('action_status', 'Open')->get()->count(); }
public function buildActions($start, $end) { return Actions::select(['actions.request_id AS r_id', 'actions.id AS a_id', 'actions.action AS action_item', 'actions.action_status AS status', 'u.name AS submitter', 'actions.due_on', 'actions.created_at'])->join('users AS u', 'u.id', '=', 'actions.submitted_by')->where('action_status', 'Open')->get(); }