/**
* Show the form for editing the specified resource.
*
* @param Quote $quote
*
* @return Response
* @internal param int $id
*/
public function edit(Quote $quote)
{
$authors = Author::lists('name', 'id')->all();
$categories = Category::lists('name', 'id')->all();
$categoriesOfImages = ImageCategory::lists('name', 'id')->all();
return view('admin.quote.edit', compact('quote'))->withTitle('Edit: ' . $quote->title)->withAuthors($authors)->withCategories($categories)->with('categoriesOfImages', $categoriesOfImages);
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($dbID, $id)
{
//
$cat = \App\ImageCategory::find($id);
return view('app.category', ['title' => $dbID, 'db' => \App\ImageDataSet::find($dbID), 'cat' => $cat, 'images' => $cat->ImageItems]);
}
/**
* Return categories's data in a way that can be read by Datatables
*
* @return Response
*/
public function getDatatable()
{
$categories = ImageCategory::select();
$datatables = \Datatables::of($categories)->addColumn('deleted_at', function ($category) {
return $category->deleted_at == null ? '<span class="label label-sm label-success">Active</span>' : '<span class="label label-sm label-danger">Deleted</span>';
})->addColumn('created_at', function ($category) {
return date('F j, Y, g:i a', strtotime($category->created_at));
})->addColumn('updated_at', function ($category) {
return date('F j, Y, g:i a', strtotime($category->created_at));
})->addColumn('actions', function ($category) {
return '<a href="' . url('admin/categories-of-images/' . $category->id . '/edit') . '" class="btn btn-success btn-sm" ><span class="glyphicon glyphicon-pencil"></span> Edit</a>';
});
$filters = \Input::get('filters');
if (!empty($filters)) {
$datatables->filter(function ($query) use($filters) {
foreach ($filters as $fName => $fValue) {
if (!$fValue) {
continue;
}
switch ($fName) {
case 'id':
$query->where('id', '=', $fValue);
break;
case 'name':
case 'created_at_from':
$query->where('created_at', '>=', $fValue);
break;
case 'created_at_to':
$query->where('created_at', '<=', $fValue);
break;
case 'updated_at_from':
$query->where('updated_at', '>=', $fValue);
break;
case 'updated_at_to':
$query->where('updated_at', '<=', $fValue);
break;
case 'deleted':
if ($fValue) {
if ($fValue == 1) {
$query->whereNull('deleted_at');
}
if ($fValue == -1) {
$query->where('deleted_at', '!=', 'null');
}
}
break;
}
}
});
}
return $datatables->make(true);
}
