public static function search($query)
{
$DBresults = DB::select('SELECT file_id, name, file_name, folder_id, size, created_at FROM files WHERE user_id = ' . Auth::id() . ' AND name LIKE "%' . $query . '%"');
$results = [];
for ($i = 0, $c = count($DBresults); $i < $c; $i++) {
$results[$i] = ['file_id' => $DBresults[$i]->file_id, 'created_at' => $DBresults[$i]->created_at, 'folder_id' => $DBresults[$i]->folder_id, 'name' => $DBresults[$i]->name, 'file_name' => $DBresults[$i]->file_name, 'size' => $DBresults[$i]->size, 'path' => Folder::getSubLinks($DBresults[$i]->folder_id)];
}
return $results;
}
public function folder($id)
{
if (Auth::guest()) {
return Redirect::to('/');
}
if (!Folder::isFolder($id)) {
return abort(404);
}
$root = Folder::foldersStructure();
$this->ViewTemplate['title'] .= ' - ' . Auth::user()->username;
$this->ViewTemplate['root'] = $root;
$this->ViewTemplate['folder_id'] = $id;
$this->ViewTemplate['path'] = Folder::getSubLinks($id);
$folderView = ['folder_id' => $this->ViewTemplate['folder_id']];
return view('template', $this->ViewTemplate)->nest('content', 'content/folder', $folderView);
}