Example #1
0
 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();
 }