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