/**
* Store a newly created resource in storage.
* POST /lista/amplificador
*
* @return Response
*/
public function postAmplificador()
{
//si la peticion es ajax
if (Request::ajax()) {
$troba = Input::get('troba');
$nodo = Input::get('nodo');
$amp = DigTroba::getAmp($troba, $nodo);
return Response::json(array('rst' => 1, 'datos' => $amp));
}
}
/**
* tmb mostrar las coordenadas segun
* si existe cable o armario, mostrar xy de cable
* si existe terminal
*/
public static function findGeolocalizacion($query = 0, $tipo_averia = '')
{
if (count($query) > 0 && $query != '') {
$cable = $terminal = '';
$coordX = $coordY = '';
$mdf = $query[0]->mdf;
if ($tipo_averia == 'STB' || $tipo_averia == 'ADSL' || $tipo_averia == '') {
$cable = $query[0]->armario;
$terminal = $query[0]->terminal;
if (trim($cable) != '' && trim($mdf) != '' && trim($terminal) != '') {
$fftt = DB::table('geo_terminald')->select('id', 'terminald as nombre', DB::raw("IFNULL(coord_x,'') as coord_x"), DB::raw("IFNULL(coord_y,'') as coord_y"), DB::raw("IFNULL(direccion,'') as direccion"))->where('cable', $cable)->where('mdf', $mdf)->where('terminald', $terminal)->get();
if (count($fftt) > 0 && $fftt != '') {
$coordX = $fftt[0]->coord_x;
$coordY = $fftt[0]->coord_y;
}
} elseif (trim($cable) != '' && trim($mdf) != '') {
$fftt = DB::table('geo_terminald')->select('id', 'terminald as nombre', DB::raw("IFNULL(coord_x,'') as coord_x"), DB::raw("IFNULL(coord_y,'') as coord_y"), DB::raw("IFNULL(direccion,'') as direccion"))->where('cable', $cable)->where('mdf', $mdf)->get();
if (count($fftt) > 0 && $fftt != '') {
$coordX = $fftt[0]->coord_x;
$coordY = $fftt[0]->coord_y;
}
} elseif (trim($mdf) != '') {
$fftt = DB::table('geo_terminald')->select('cable as id', 'cable as nombre', DB::raw("IFNULL(coord_x,'') as coord_x"), DB::raw("IFNULL(coord_y,'') as coord_y"), DB::raw("IFNULL(direccion,'') as direccion"))->where('mdf', $mdf)->groupby('cable')->get();
if (count($fftt) > 0 && $fftt != '') {
$coordX = $fftt[0]->coord_x;
$coordY = $fftt[0]->coord_y;
}
}
} elseif ($tipo_averia == 'CATV') {
$troba = $query[0]->troba;
$amp = $query[0]->amplificador;
$tap = $query[0]->tap;
//buscar por troba amplificador y tap
if (trim($troba) != '' && trim($amp) && trim($tap) != '') {
$fftt = DigTroba::getTap($amp, $troba, $mdf);
if (count($fftt) > 0 && $fftt != '') {
$coordX = $fftt[0]->coord_x;
$coordY = $fftt[0]->coord_y;
}
} elseif (trim($troba) != '' && trim($amp != '')) {
$fftt = DigTroba::getAmp($troba, $mdf);
if (count($fftt) > 0 && $fftt != '') {
$coordX = $fftt[0]->coord_x;
$coordY = $fftt[0]->coord_y;
}
} elseif (trim($troba) != '') {
$fftt = DigTroba::getTroba($mdf);
if (count($fftt) > 0 && $fftt != '') {
$coordX = $fftt[0]->coord_x;
$coordY = $fftt[0]->coord_y;
}
}
}
//añadiendo al query las coordenadas
if ($coordX != '' && $coordY != '') {
$query[0]->coordx = $coordX;
$query[0]->coordy = $coordY;
}
//retornas los valores
return $query;
}
return $query;
}
