public function listHotspots($idUser, $name)
{
$HotsPotsGroups = DB::select("select DISTINCT H.id from hotspots as H " . "inner join hotspots_groups as HG ON H.id=HG.hotspots_id " . "where H.geocode={$idUser}");
if ($HotsPotsGroups) {
foreach ($HotsPotsGroups as $value) {
$idHotspots[] = $value->id;
}
$Hostpots = Hostpots::whereNotIn('id', $idHotspots)->whereGeocode($idUser)->lists($name, 'id', 'geocode');
} else {
$Hostpots = Hostpots::whereGeocode($idUser)->lists($name, 'id', 'geocode');
}
return $Hostpots;
}
public function postConfiguracion2(Request $request)
{
$data = $request->all();
GroupsCampania::whereGroupsId($data['groups_id'])->forceDelete();
GroupsCampania::create($data);
$dataEquipos = Hostpots::whereGeocode($data['groups_id'])->get();
$datosCampania = Campania::whereId($data['campania_id'])->get();
$datosCampaniaFinal = $datosCampania->toArray();
$datosGrupo = Groups::find($data['groups_id'])->lists('name');
Radgroupreply::whereGroupname($datosGrupo[0])->forceDelete();
foreach ($dataEquipos->toArray() as $v) {
$valor1 = array('groupname' => $datosGrupo[0], 'MikroTik-Advertise-URL', 'op' => '==', 'value' => $datosCampaniaFinal[0]['url']);
Radgroupreply::create($valor1);
$valor2 = array('groupname' => $datosGrupo[0], 'MikroTik-Advertise-Interval', 'op' => '==', 'value' => $datosCampaniaFinal[0]['expiracion']);
Radgroupreply::create($valor2);
$valor3 = array('groupname' => $datosGrupo[0], 'MikroTik-Rate-Limit', 'op' => '==', 'value' => $datosCampaniaFinal[0]['megas']);
Radgroupreply::create($valor3);
}
echo nl2br("\r\n\r\n\r\n\r\nCONFIGURACION GUARDADA CORRECTAMENTE", false);
exit;
}
public function getEquipmentsFree(Request $request)
{
$groups_id = $request->input('groups_id');
if (isset($groups_id) && !empty($groups_id)) {
$dataGroup = \App\Models\Groups::find($groups_id);
if ($dataGroup->customer_id != 0) {
$newHostPots = new Hostpots();
$data = $newHostPots->listHotspots($dataGroup->customer_id, 'name');
foreach ($data as $value => $e) {
$dataInt[] = $value;
}
}
}
$HotsPotsGroups = DB::select("select DISTINCT H.id from hotspots as H " . "inner join hotspots_groups as HG ON H.id=HG.hotspots_id ");
if (isset($dataInt) && count($dataInt) > 0) {
if ($HotsPotsGroups) {
foreach ($HotsPotsGroups as $value) {
$idHotspots[] = $value->id;
}
$Hostpots = Hostpots::whereNotIn('id', $idHotspots)->whereIn('id', $dataInt)->orWhere('geocode', 0)->lists('mac', 'id');
} else {
$Hostpots = Hostpots::whereIn('id', $dataInt)->whereIn('id', $dataInt)->orWhere('geocode', 0)->lists('mac', 'id');
}
} else {
if ($HotsPotsGroups) {
foreach ($HotsPotsGroups as $value) {
$idHotspots[] = $value->id;
}
$Hostpots = Hostpots::whereNotIn('id', $idHotspots)->whereGeocode(0)->lists('mac', 'id');
} else {
$Hostpots = Hostpots::whereGeocode(0)->lists('mac', 'id');
}
}
return response()->json(array('state' => 1, 'msg' => 'ok', 'data' => $Hostpots));
}
