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";
}
}
