complete

    public function Announcement()
    {
        $categorydate = Investor::selectRaw('YEAR(date) AS tahun')
                    ->where('coverage', '=', 'ANNOUNCEMENT')
                    ->whereRaw('YEAR(date)>0')
                    ->groupBy('tahun')
                    ->orderBy('tahun','DESC')
                    ->pluck('tahun')->all();

        $ann = Investor::select(DB::raw('name,title, title_en, subtitle, coverage'))
                ->where('coverage', '=', 'ANNOUNCEMENT')
                ->get();

        $inves= Investor::select(DB::raw('title, title_en'))
                ->where('type', '=', 'INVESTOR RELATIONS')
                ->orderBy('date','DESC')
                ->get();

        $extension = Investor::select('document')
                    ->where('type','=','investor')
                    ->where('coverage','=','ANNOUNCEMENT')
                    ->get();



        $announcement = Investor::select('id','date', 'document', 'excerpt')
                        ->where('type','=','investor')
                        ->where('coverage','=','ANNOUNCEMENT')
                        ->get();

        return view('investors.announcement')
                ->with('ann',$ann)
                ->with('inves',$inves)
                ->with('announcement', $announcement)
                ->with('categorydate',$categorydate);
    }