public function showDocument()
{
$user = Auth::user();
$query = Input::get('search');
if ($user->is_boss == 0) {
$documents = Document::where('users.id', $user->id);
$documents = $documents->join('users', 'users.id', '=', 'officer_id');
} else {
$documents = Document::join('users', 'users.id', '=', 'officer_id');
}
if (isset($query)) {
$documents = $documents->where('documents.name', 'LIKE', '%' . $query . '%');
}
$documents = $documents->select('documents.*', 'users.name as username');
$documents = $documents->orderBy('updated_at', 'desc');
$documents = $documents->paginate(10);
return view('index', ['documents' => $documents, 'user' => $user]);
}
