/**
* Return site task completion counts
* Used with serverSide Datatables
*
* @return mixed
*/
public function indexDatatables()
{
//Get all Site objects
$sites = Site::select('id', 'name');
// Return the Datatables object from the query
return Datatables::of($sites)->addColumn('Completed Tasks', function ($site) {
return $site->completedTasks(true);
})->addColumn('Incomplete Tasks', function ($site) {
return $site->incompleteTasks(true);
})->editColumn('name', function ($site) {
return '<a class="sql-link" href="sites/' . $site->id . '">' . $site->name . '</a>';
})->make(true);
}
