public function closedTaskData($id)
{
$tasks = Tasks::select(['id', 'title', 'created_at', 'deadline', 'fk_user_id_assign'])->where('fk_user_id_assign', $id)->where('status', 2);
return Datatables::of($tasks)->addColumn('titlelink', function ($tasks) {
return '<a href="' . route('tasks.show', $tasks->id) . '">' . $tasks->title . '</a>';
})->editColumn('created_at', function ($tasks) {
return $tasks->created_at ? with(new Carbon($tasks->created_at))->format('d/m/Y') : '';
})->editColumn('deadline', function ($tasks) {
return $tasks->created_at ? with(new Carbon($tasks->created_at))->format('d/m/Y') : '';
})->make(true);
}
public function anyData()
{
$tasks = Tasks::select(['id', 'title', 'created_at', 'deadline', 'fk_user_id_assign'])->where('status', 1)->get();
return Datatables::of($tasks)->addColumn('titlelink', function ($tasks) {
return '<a href="tasks/' . $tasks->id . '" ">' . $tasks->title . '</a>';
})->editColumn('created_at', function ($tasks) {
return $tasks->created_at ? with(new Carbon($tasks->created_at))->format('d/m/Y') : '';
})->editColumn('deadline', function ($tasks) {
return $tasks->created_at ? with(new Carbon($tasks->created_at))->format('d/m/Y') : '';
})->editColumn('fk_user_id_assign', function ($tasks) {
return $tasks->assignee->name;
})->make(true);
}
