/**
* Show a list of all the languages posts formatted for Datatables.
*
* @return Datatables JSON
*/
public function data()
{
$categories = Object::leftJoin('users as author', 'author.id', '=', 'objects.author_id')->leftJoin('objects as parent', 'parent.id', '=', 'objects.parent_id')->where('objects.type', 'category')->select('objects.id', 'objects.title', 'author.name AS author', 'parent.name AS parent', 'objects.created_at');
return Datatables::of($categories)->add_column('actions', '<a href="{{{ URL::to(\'admin/categories/\' . $id . \'/edit\' ) }}}" class="btn btn-success btn-sm" ><span class="glyphicon glyphicon-pencil"></span> {{ trans("admin/modal.edit") }}</a>
<a href="{{{ URL::to(\'admin/categories/\' . $id . \'/delete\' ) }}}" class="btn btn-sm btn-danger"><span class="glyphicon glyphicon-trash"></span> {{ trans("admin/modal.delete") }}</a>')->remove_column('id')->make();
}
/**
* Show a list of all the languages posts formatted for Datatables.
*
* @return Datatables JSON
*/
public function data(Request $request)
{
$categories = Object::leftJoin('users as author', 'author.id', '=', 'objects.author_id')->leftJoin('objects as parent', 'parent.id', '=', 'objects.parent_id')->where('objects.type', 'category')->select('objects.id', 'objects.title', 'author.name AS author', 'parent.name AS parent', 'objects.created_at');
return Datatables::of($categories)->filter(function ($query) use($request) {
$search = $request->get('search')['value'];
if ($search != '') {
$query->where(function ($query) use($search) {
$query->where('objects.title', 'like', "%{$search}%")->orWhere('parent.name', 'like', "%{$search}%");
});
}
})->add_column('actions', '<a href="{{{ URL::to(\'admin/categories/\' . $id . \'/edit\' ) }}}" class="btn btn-success btn-sm" ><span class="glyphicon glyphicon-pencil"></span> {{ trans("admin/modal.edit") }}</a>
<a href="{{{ URL::to(\'admin/categories/\' . $id . \'/delete\' ) }}}" class="btn btn-sm btn-danger"><span class="glyphicon glyphicon-trash"></span> {{ trans("admin/modal.delete") }}</a>')->remove_column('id')->make();
}
