dataTablesInstance = $dataTablesInstance;
}
/**
* @return JsonResponse
* @throws \Exception
*/
public function getDataTable()
{
$report_table = (new Report())->getTable();
$user_table = (new User())->getTable();
$query = \DB::table($report_table . ' as rep')
->select([
'rep.id',
'rep.report_type',
'rep.content',
'user.nickname',
'user.email',
'user.phone_number',
'rep.status',
'rep.created_at'
])
->leftJoin($user_table . ' as user', 'user.id', '=', 'rep.user_id');
return $this->dataTablesInstance
->queryBuilder($query)
->editColumn('report_type', function ($report) {
if ($report->report_type == Report::TYPE_PROBLEM) {
return "" . trans('admin.support.type_name.problem') . "";
}
if ($report->report_type == Report::TYPE_FEEDBACK) {
return "" . trans('admin.support.type_name.feedback') . "";
}
})
->editColumn('status', function ($report) {
if ($report->status == Report::STATUS_CLOSED) {
return "" . trans('admin.support.status_name.closed') . "";
}
if ($report->status == Report::STATUS_OPEN) {
return "" . trans('admin.support.status_name.open') . "";
}
})
/*->filterColumn('status', function ($query, $keyword) {
if ($keyword == Report::STATUS_OPEN) {
$query->whereRaw('rep.status isnull');
}
if ($keyword == Report::STATUS_CLOSED) {
$query->whereRaw('rep.status notnull');
}
})*/
->editColumn('content', function ($report) {
return (mb_strlen($report->content) > 200) ? mb_substr($report->content, 0, 200) . '...' : $report->content;
})
->rawColumns(['report_type', 'status'])
->addColumn('showLink', function ($report) {
return route('admin.support.show', ['id' => $report->id]);
})
->addColumn('statusLink', function ($report) {
return route('admin.support.toggle_status', ['id' => $report->id]);
})
->addColumn('deleteLink', function ($report) {
return route('admin.support.destroy', ['id' => $report->id]);
})
->make();
}
}