/**
*
*/
public static function getLiquidados($telefono = '', $codcliatis = '', $codsercms = '', $codclicms = '')
{
$numeroSql = '';
$tipo_averia = '';
//buscar en liquidados si no se encontraron registros
/*****************/
if ($telefono != '' || $codcliatis != '') {
//7
$sql = " SELECT peticion\n FROM schedulle_sistemas.prov_liq_bas_pais\n WHERE telefono=? OR cod_cliente=? AND cod_cliente<>''\n AND cod_cliente<>'0' AND peticion<>0 ";
$query = DB::select($sql, array($telefono, $codcliatis));
if (count($query) > 0 && $query != '') {
$numeroSql = '7';
$peticion = $query[0]->peticion;
} else {
//8
$sql = " SELECT codigo_req as peticion\n FROM schedulle_sistemas.prov_liq_catv_pais\n WHERE codigo_del_cliente=? AND codigo_req<>0 ";
$query = DB::select($sql, array($codcliatis));
if (count($query) > 0 && $query != '') {
$tipo_averia = 'CATV';
$numeroSql = '8';
$peticion = $query[0]->peticion;
} else {
//9 AVERIAS
$sql = " SELECT numero_osiptel as peticion\n FROM schedulle_sistemas.aver_liq_adsl_pais\n WHERE telefono=? ";
$query = DB::select($sql, array($telefono));
if (count($query) > 0 && $query != '' && trim($telefono) != '') {
$tipo_averia = 'ADSL';
$numeroSql = '9';
$peticion = $query[0]->peticion;
} else {
//10
$sql = " SELECT numero_osiptel as peticion\n FROM schedulle_sistemas.aver_liq_bas_lima\n WHERE telefono=? ";
$query = DB::select($sql, array($telefono));
if (count($query) > 0 && $query != '' && trim($telefono) != '') {
$numeroSql = '10';
$peticion = $query[0]->peticion;
} else {
//11
$sql = " SELECT inscripcion as peticion\n FROM schedulle_sistemas.aver_liq_bas_prov_pedidos\n WHERE telefono=? ";
$query = DB::select($sql, array($telefono));
if (count($query) > 0 && $query != '' && trim($telefono) != '') {
$numeroSql = '11';
$peticion = $query[0]->peticion;
} else {
//12
$sql = " SELECT codigoreq as peticion\n FROM schedulle_sistemas.aver_liq_catv_pais\n WHERE codigodelcliente=? ";
$query = DB::select($sql, array($codcliatis));
if (count($query) > 0 && $query != '' && trim($codcliatis) != '') {
$tipo_averia = 'CATV';
$numeroSql = '12';
$peticion = $query[0]->peticion;
}
}
}
}
}
}
} elseif ($codsercms != '') {
//12
$tipo_averia = 'CATV';
$sql = " SELECT codigoreq as peticion\n FROM schedulle_sistemas.aver_liq_catv_pais\n WHERE codigodelservicio=? ";
$query = DB::select($sql, array($codsercms));
if (count($query) > 0 && $query != '') {
$numeroSql = '12';
$peticion = $query[0]->peticion;
}
}
//verificar si existe una consulta
if ($numeroSql != '') {
$queryLiq = Historico::findDatos($peticion, $numeroSql);
//verificar si hay registro
if (count($queryLiq) > 0 && $queryLiq != '') {
$query = $queryLiq;
//se debe enviar X Y de geolocalizacion
$query = Historico::findGeolocalizacion($query, $tipo_averia);
return $query;
}
return array();
}
return array();
}
