function urls_amigables($url) { // Tranformamos todo a minusculas //Rememplazamos caracteres especiales latinos /*$find = array('á', 'é', 'í', 'ó', 'ú', 'ñ'); $repl = array('a', 'e', 'i', 'o', 'u', 'n'); $url = str_replace ($find, $repl, $url); // Añaadimos los guiones $find = array(' ', '&', '\r\n', '\n', '+'); $url = str_replace ($find, '-', $url); // Eliminamos y Reemplazamos demás caracteres especiales $find = array('/[^a-z0-9\-<>]/', '/[\-]+/', '/<[^>]*>/'); $repl = array('', '-', ''); $url = preg_replace ($find, $repl, $url); return $url;*/ $str_noamigable = trim($url); $str_noamigable = quitarAcentos($str_noamigable); $str_noamigable = mb_strtolower($str_noamigable, 'UTF-8'); $str_noamigable = str_replace("+", " ", $str_noamigable); $str_noamigable = str_replace(":", " ", $str_noamigable); $str_noamigable = str_replace("/", " ", $str_noamigable); $str_noamigable = str_replace("-", " ", $str_noamigable); $str_noamigable = str_replace(",", "", $str_noamigable); $str_noamigable = str_replace(".", "", $str_noamigable); $str_noamigable = str_replace(" de ", "-", $str_noamigable); $str_noamigable = str_replace(" la ", "-", $str_noamigable); $str_noamigable = str_replace(" el ", "-", $str_noamigable); $str_noamigable = str_replace(" y ", "-", $str_noamigable); $str_noamigable = str_replace(" ", " ", $str_noamigable); $str_noamigable = str_replace(" ", " ", $str_noamigable); $str_noamigable = str_replace(" ", "-", $str_noamigable); return $str_noamigable; }
$CBU = $rec["CBU"]; $LeyendaAd = $rec["LeyendaAdicional"]; $TotalRem = $rec["TotalRemuneraciones"]; $TotalRet = $rec["TotalRetenciones"]; $TotalNeto = $rec["TotalNeto"]; $TotalenLetras = $rec["TotalenLetras"]; } $sql = "SELECT * FROM recibosdetalle WHERE NumeroRecibo = {$nroRec} ORDER BY Tipo, Codigo"; $reciboDet = $baseRec->query($sql); $detalle = ""; foreach ($reciboDet as $row) { $detalle .= "<tr class='rowDist'>\r\n\t\t<td style='border-top:0px none;border-bottom:0px none;text-align: center;'>" . formatCodigoI($row["Codigo"]) . "</td>\r\n\t\t<td colspan='4' style='text-align:left;border-top:0px none;border-bottom:0px none;'>" . $row["Descripcion"] . "</td>"; if (_toUp(quitarAcentos($row["Tipo"])) == "REMUNERACION") { $detalle .= "<td style='text-align:right;padding-right:5px;border-top:0px none;border-bottom:0px none;'> \$ " . formatNumber($row["Importe"]) . "</td><td align='right' \r\n\t\t\tstyle='border-top:0px none;border-bottom:0px none;'> </td>"; } else { if (_toUp(quitarAcentos($row["Tipo"])) == "RETENCION") { $detalle .= "<td align='right' style='border-top:0px none;border-bottom:0px none;'> </td><td style='border-top:0px none;border-bottom:0px none;text-align:right;padding-right:5px;'> \$ " . formatNumber($row["Importe"]) . "</td>"; } } $detalle .= "</tr>"; } $content = ' <div style="background-color: #fff;font-family: Arial, Geneva, sans-serif;font-size: 9pt;"> <div id="container"> <table aling="center" cellpadding="0" cellspacing="0"> <tr> <td rowspan="4"><img src="../images/ProvNeuq.png" align="middle" /></td> <td rowspan="4"> <b> ' . $RazonSocial . '</b><br /> ' . $Direccion . ' <br /> (' . $CodigoPostal . ') ' . $Localidad . '<br />
/** * Devuelve la cadena $it transformada como un identificador * * @param string $it * @return string */ function slug($it) { $it = quitarAcentos($it); $it = preg_replace(array('/\\s/', '/([A-Z])/e', '/\\W/'), array('_', "strtolower( '\$1' )", ''), $it); return $it; }
function res_NubeTextoPeriodo($idPregunta, $idPeriodo) { $base = new PDOConfig(); $idPregunta = $base->filtrar($idPregunta); $palabras = array(); $lista = array(); $texto = ""; $sqlResp = "SELECT RespuestaTexto from respuestaspreguntas R INNER JOIN respuestas E ON R.idRespuesta = E.idRespuesta\r\n WHERE E.idPeriodo = {$idPeriodo} AND R.idPregunta = {$idPregunta}"; $resOps = $base->query($sqlResp); if ($resOps) { $resultado = $resOps->fetchAll(PDO::FETCH_ASSOC); foreach ($resultado as $row) { $texto .= " " . $row["RespuestaTexto"]; } //echo $texto;exit(); $palabras = tags(quitarAcentos($texto)); $lista = repeatedElements($palabras, true); //print_r($lista);exit(); return json_encode($lista); } else { return "0"; } }