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(); }