public function groupsDataTable(Request $request) { $idCustomer = $request->input('idCustomer', Auth::customer()->user()->id); if ($idCustomer == Auth::customer()->user()->id) { $name = 'email_owner'; } else { $name = 'mac'; } $Groups = new Groups(); $groups = $Groups->getGroupsDataTable($idCustomer); foreach ($groups as $value) { $dd = DB::select("select group_concat(H.{$name}, concat('*',H.id)) as hotspots from hotspots_groups as HG " . "inner join hotspots as H ON H.id=HG.hotspots_id inner join groups as G ON G.id=HG.groups_id " . "where HG.flagactive=1 and G.flagactive=1 and HG.groups_id=G.id and HG.groups_id={$value->id} " . "group by G.id "); if (isset($dd[0]->hotspots)) { $value->hotspots = $dd[0]->hotspots; } else { $value->hotspots = null; } } return Datatables::of($groups)->editColumn('hotspots', function ($groups) { $str = ""; if ($groups->hotspots == null) { $cad = "No asignado"; } else { $data = explode(",", $groups->hotspots); $cad = ""; foreach ($data as $row) { $row = explode('*', $row); $cad = $cad . '<span class="tag-exercise" data-id=' . $row[1] . '>' . $row[0] . '<i class="icon icon-remove"></i></span>'; $str = $str . $row[1] . ","; } $str = substr($str, 0, strlen($str) - 1); } return $cad . "<span class='more-exercise' data-id='" . $groups->id . "' data-exercises ='" . $str . ",0'> + </span>"; })->make(true); }