/** * */ public static function getMaestro($telefono = '', $codcliatis = '', $codsercms = '', $codclicms = '') { //temporal, maestro cliente $qryTelefono = $qryCodcliatis = $qryCodsercms = $qryCodclicms = ''; if ($telefono != '') { $where = " l.telefono='" . $telefono . "' AND "; } if ($codcliatis != '') { $where = " l.codclie='" . $codcliatis . "' AND "; } if ($codsercms != '') { $where = " l.codservcms='" . $codsercms . "' AND "; } if ($codclicms != '') { $where = " l.codclicms='" . $codclicms . "' AND "; } $sql = "SELECT l.tiposerv, l.telefono, l.tipocalle, l.nomcalle,l.numcalle,\n l.codclie, l.codservcms, l.nombre, l.appater, l.apmater, l.zonal,\n l.mdf, l.armario, l.cabprim AS cable, l.cajater AS terminal,\n l.xtroba, l.ytroba, l.xtap, l.ytap, l.xterminal, l.yterminal,\n IFNULL(\n (SELECT direccion\n FROM geo_tap gt\n WHERE gt.coord_x=l.xtroba\n AND gt.coord_y=l.ytroba), 'sin dirección') as dir_troba,\n IFNULL(\n (SELECT direccion\n FROM geo_tap gt\n WHERE gt.coord_x=l.xterminal\n AND gt.coord_y=l.yterminal), 'sin dirección') as dir_term,\n IFNULL(\n (SELECT direccion\n FROM geo_tap gt\n WHERE gt.coord_x=l.xtap\n AND gt.coord_y=l.ytap), 'sin dirección') as dir_tab,\n IFNULL(m.eecc,'') as eecc,\n IFNULL(m.lejano,'') as lejano,\n IFNULL(m.zona_critico,'') as microzona,\n (select id from empresas where nombre like m.eecc) as empresa_id\n FROM webpsi_coc.tb_lineas_servicio_total l\n LEFT JOIN webpsi_fftt.mdfs_eecc_regiones m\n ON l.mdf=m.mdf\n WHERE {$where}\n TRIM(REPLACE(l.telefono,' ','')) REGEXP '^[0-9]+\$' AND\n TRIM(REPLACE(l.telefono,' ','')) >2\n AND LENGTH(REPLACE(l.telefono,'1',''))!=0\n GROUP BY l.telefono,l.codclie,l.codservcms,l.codclicms"; $query = DB::select($sql); //verificar si hay registros if (count($query) > 0 && $query !== '') { //se debe enviar X Y de geolocalizacion $query = Historico::findGeolocalizacion($query, ''); return $query; } return array(); }