public function search(Request $request) { $keyword = $request->keyword; if (!$keyword) { return redirect('/'); } $entries = FileEntry::where("name", "LIKE", "%{$keyword}%")->paginate(15); return view('fileentries.search', compact('entries')); }
/** * Display the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function show($path) { $entry = FileEntry::where('filename', '=', $path)->first(); if ($entry == null || !Storage::exists($path)) { return response('NotFound', 404); } else { $file = Storage::get($entry->filename); return response($file)->header('Content-Type', $entry->mime); } }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function delete(Request $request, $id) { $file = FileEntry::where('id', $id)->where('owner_id', $request->user()->id)->first(); if (!$file) { $sys_notifications[] = array('type' => 'danger', 'message' => 'O arquivo não existe!'); $request->session()->flash('sys_notifications', $sys_notifications); return back()->withInput($request->all()); } if ($file->destroy($id)) { // Delete the file if (Storage::exists($request->user()->id . '/' . $file->original_filename)) { Storage::delete($request->user()->id . '/' . $file->original_filename); } $this->sys_notifications[] = array('type' => 'success', 'message' => '<strong><i class="fa fa-check"></i></strong> Arquivo excluído com sucesso!'); $request->session()->flash('sys_notifications', $this->sys_notifications); return back()->withInput($request->all()); } else { $this->sys_notifications[] = array('type' => 'danger', 'message' => '<strong><i class="fa fa-warning"></i></strong> Não foi possível excluir o arquivo!'); $request->session()->flash('sys_notifications', $this->sys_notifications); return back()->withInput($request->all()); } }
public function year() { $year_2009 = FileEntry::where('year', '=', 2009)->get(); $year_2010 = FileEntry::where('year', '=', 2010)->get(); $year_2011 = FileEntry::where('year', '=', 2011)->get(); $year_2012 = FileEntry::where('year', '=', 2012)->get(); $year_2013 = FileEntry::where('year', '=', 2013)->get(); $year_2014 = FileEntry::where('year', '=', 2014)->get(); $year_2015 = FileEntry::where('year', '=', 2015)->get(); $year_2016 = FileEntry::where('year', '=', 2016)->get(); $count_year_2009 = FileEntry::where('year', '=', 2009)->count(); $count_year_2010 = FileEntry::where('year', '=', 2010)->count(); $count_year_2011 = FileEntry::where('year', '=', 2011)->count(); $count_year_2012 = FileEntry::where('year', '=', 2012)->count(); $count_year_2013 = FileEntry::where('year', '=', 2013)->count(); $count_year_2014 = FileEntry::where('year', '=', 2014)->count(); $count_year_2015 = FileEntry::where('year', '=', 2015)->count(); $count_year_2016 = FileEntry::where('year', '=', 2016)->count(); $join_get_full_name = DB::table('file_entries')->join('users', 'users.email', '=', 'file_entries.submitting_user_email')->select('users.user_first_name', 'users.user_last_name')->take(1)->get(); return view('browse.year', compact('year_2009', 'year_2010', 'year_2011', 'year_2012', 'year_2013', 'year_2014', 'year_2015', 'year_2016', 'count_year_2009', 'count_year_2010', 'count_year_2011', 'count_year_2012', 'count_year_2013', 'count_year_2014', 'count_year_2015', 'count_year_2016', 'join_get_full_name')); }