controller

    public function index(Request $request)
    {
        $pdf = Investor::select('id', 'document')->where('type', '=', 'investor')->get();

        return view('admin.investors.index', compact('data', 'pdf'));
    }

    public function getTable(Request $request)
    {
        $limit = $request->input('length');
		$start = $request->input('start');
        $columns = array(
			0 => 'id',
			1 => 'title',
			2 => 'name',
            3 => 'coverage',
            4 => 'document',
            5 => 'image',
            6 => 'date',
            7 => 'action'
        );

        $totalData = Investor::count();
		$limit = $request->input('length');
		$start = $request->input('start');
		$order = $columns[$request->input('order.0.column')];
		$dir = $request->input('order.0.dir');

        if(empty($request->input('search.value'))){
			$posts = Investor::offset($start)
					->limit($limit)
                    ->orderBy($order,$dir)
                    ->where('type','=','investor')
					->get();
			$totalFiltered = Investor::where('type','=','investor')->count();
		}else{
			$search = $request->input('search.value');
			$posts = Investor::where('title', 'like', "%{$search}%")
							->orWhere('name','like',"%{$search}%")
                            ->orWhere('coverage','like',"%{$search}%")
                            ->orWhere('date','like',"%{$search}%")
                            ->where('type','=','investor')
							->offset($start)
							->limit($limit)
							->orderBy($order, $dir)
							->get();
			$totalFiltered = Investor::where('title', 'like', "%{$search}%")
                            ->orWhere('name','like',"%{$search}%")
                            ->where('type','=','investor')
							->count();
		}


		$data = array();

		if($posts){
			foreach($posts as $r){

				$nestedData['id'] = $r->id;
				$nestedData['title'] = $r->title;
                $nestedData['name'] = $r->name;
                $nestedData['coverage'] = $r->coverage;
                $nestedData['document'] = '

                <a href="#" data-toggle="tooltip" data-id="'.$r->id.'" data-original-title="Show" class="btn btn-info btn-sm show" ">Show PDF</a>
                ';
                $nestedData['image'] = $r->image;
				$nestedData['date'] = date('d-F-y',strtotime($r->date));
				$nestedData['action'] = '
                <a href="' . route('investors.edit', $r->id) . '" class="btn btn-primary btn-sm">Edit</a><br>
				<a href="#" data-toggle="tooltip"  data-id="'.$r->id.'" data-original-title="Delete" class="btn btn-danger btn-sm deleteServices">Delete</a>
				';
				$data[] = $nestedData;
			}
		}

		$json_data = array(
			"draw"			=> intval($request->input('draw')),
			"recordsTotal"	=> intval($totalData),
			"recordsFiltered" => intval($totalFiltered),
			"data"			=> $data
		);

		echo json_encode($json_data);

    }