/** * 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); }