/**
* Show a list of all the languages posts formatted for Datatables.
*
* @return Datatables JSON
*/
public function data()
{
$questions = Question::whereNull('questions.deleted_at')->where('questions.user_id', '=', Auth::id())->join('question_categories', 'question_categories.id', '=', 'questions.question_category_id')->join('answers', 'answers.question_id', '=', 'questions.id')->select(array('questions.id', 'question_categories.name as category', 'questions.content', 'answers.content AS answer_content', 'questions.created_at', 'questions.updated_at'))->orderBy('questions.updated_at', 'DESC');
return Datatables::of($questions)->add_column('actions', '
<a href="{{{ URL::to(\'question/\' . $id . \'/delete\' ) }}}" class="btn btn-sm btn-danger iframe"><span class="glyphicon glyphicon-trash"></span> {{ trans("admin/modal.delete") }}</a>
<input type="hidden" name="row" value="{{$id}}" id="row">')->remove_column('id')->make();
}
/**
* Show a list of all the languages posts formatted for Datatables.
*
* @return Datatables JSON
*/
public function data()
{
$questions = Question::whereNull('questions.deleted_at')->join('users', 'users.id', '=', 'questions.user_id')->join('question_categories', 'question_categories.id', '=', 'questions.question_category_id')->select(array('questions.id', 'question_categories.name as category', 'questions.content', 'users.name', DB::raw('IF(questions.is_displayed = 1, "Yes", "No") as is_displayed'), 'questions.created_at'))->orderBy('questions.updated_at', 'DESC');
return Datatables::of($questions)->add_column('actions', '
<a href="{{{ URL::to(\'admin/question/\' . $id . \'/edit\' ) }}}" class="btn btn-success btn-sm iframe" ><span class="glyphicon glyphicon-pencil"></span> {{ trans("admin/modal.edit") }}</a>
<a href="{{{ URL::to(\'admin/question/\' . $id . \'/reply\' ) }}}" class="btn btn-success btn-sm iframe" ><span class="glyphicon glyphicon-alt"></span> {{ trans("admin/modal.reply") }}</a>
<a href="{{{ URL::to(\'admin/question/\' . $id . \'/delete\' ) }}}" class="btn btn-sm btn-danger iframe"><span class="glyphicon glyphicon-trash"></span> {{ trans("admin/modal.delete") }}</a>
<input type="hidden" name="row" value="{{$id}}" id="row">')->remove_column('id')->make();
}
