public function directors() { $d_id = Executive::where('position', '=', 'Directors')->first()->id; $d_joins = DB::table('executive_user')->where('year_id', '=', $this->id)->where('executive_id', '=', $d_id)->where('non_executive', '=', false)->get(); $directors = array(); foreach ($d_joins as $d) { $directors[] = User::find($d->user_id); } return $directors; }
function exe_more() { $executives = new Executive(); lang_filter($executives->where("start_date <= date(sysdate()) and (end_date >= date(sysdate()) or end_date = date('0000-00-00')) and status = 'approve'")); $data['executives'] = $executives->order_by('id', 'desc')->get(); $this->template->build('exe_more', $data); }