/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index(Request $request) { $search = \Request::get('search'); //<-- we use global request to get the param of URI $companies = \DB::table('companies')->lists('store_name', 'id'); $status = \DB::table('fiscal_document_statuses')->lists('status_name', 'id'); if ($search) { $allFiscalDocuments = FiscalDocument::whereRaw('date(created_at) = ?', [$search])->orderBy('id', 'desc')->paginate(5); } else { $allFiscalDocuments = FiscalDocument::orderBy('id', 'desc')->paginate(5); } return view('fiscalDocument.index', ['fiscalDocuments' => $allFiscalDocuments, 'companies' => $companies]); }