<?php class Controller_Reports extends Controller_Backend { public function before(){ parent::before(); } public function get_all(){ \Debug::dump('Report Method Reached'); $institution = $this->institution; $recipients = \DB::select('*')->from('recipients')->where('institution',$institution->id)->execute()->as_array(); $results = \DB::select('*')->from('messages')->where('institution',$institution->id)->order_by('created_at','desc')->execute()->as_array(); foreach ($results as $key => $value) { $array = array_filter($recipients,function($recipient) use ($value){ return $recipient['id'] == $value['recipient']; }); $results[$key]['recipient'] = current($array); } return $this->set_cached($results); } public function action_base(){ return \View::forge('reports/base'); } public function action_view(){ return \View::forge('reports/view'); } }