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'));
}
