<?php
$valor = $_GET["valor"];
echo desencriptar($valor);
function encriptar($cadena)
{
$key = 'ilumovil';
// Una clave de codificacion, debe usarse la misma para encriptar y desencriptar
$encrypted = base64_encode(mcrypt_encrypt(MCRYPT_RIJNDAEL_256, md5($key), $cadena, MCRYPT_MODE_CBC, md5(md5($key))));
return $encrypted;
//Devuelve el string encriptado
}
function desencriptar($cadena)
{
$key = 'ilumovil';
// Una clave de codificacion, debe usarse la misma para encriptar y desencriptar
$decrypted = rtrim(mcrypt_decrypt(MCRYPT_RIJNDAEL_256, md5($key), base64_decode($cadena), MCRYPT_MODE_CBC, md5(md5($key))), "");
return $decrypted;
//Devuelve el string desencriptado
}
function getResultadoEvaluacionNoSPAC($idEvaluacion, $idCompetencia) {
global $conn;
$params = array(":idcompetencia" => $idCompetencia, ":idusuario" => $idEvaluacion);
$sql =
"SELECT rc_id, rc_valor
FROM rrhh.rrc_relacomptencia, rrhh.rre_resultadoevaluacion
WHERE rc_id = re_idrelacompetencia
AND rc_fechabaja IS NULL
AND re_fechabaja IS NULL
AND rc_idcompetencia = :idcompetencia
AND re_idusuario = :idusuario";
$stmt = DBExecSql($conn, $sql, $params);
$minValor = 9999;
while ($row = DBGetQuery($stmt)) {
$valor = substr(desencriptar($row["RC_VALOR"]), strlen($row["RC_ID"]));
if ($valor < $minValor)
$minValor = $valor;
}
switch ($minValor) {
case 1:
$result = "Estadio Inicial";
break;
case 2:
$result = "En Desarrollo";
break;
case 3:
$result = "Consolidado";
break;
case 4:
$result = "Referencia e Influencia";
break;
default:
$result = "";
}
return $result;
}
":idcompetencia" => $row["EC_ID"],
":idusuario" => $idEvaluacion);
$sql =
"SELECT rc_descripcion, rc_id, re_idrelacompetencia
FROM rrhh.rrc_relacomptencia, rrhh.rre_resultadoevaluacion
WHERE rc_id = re_idrelacompetencia(+)
AND rc_fechabaja IS NULL
AND re_fechabaja IS NULL
AND rc_idcompetencia = :idcompetencia
AND rc_combo = :combo
AND re_idusuario(+) = :idusuario
ORDER BY rc_orden";
$stmt3 = DBExecSql($conn, $sql, $params);
while ($rowOpciones = DBGetQuery($stmt3)) {
$selected = (($rowOpciones["RC_ID"] == $rowOpciones["RE_IDRELACOMPETENCIA"])?"selected":"");
$html.= "<option ".$selected." value=\"".$rowOpciones["RC_ID"]."\">".substr(desencriptar($rowOpciones["RC_DESCRIPCION"]), strlen($rowOpciones["RC_ID"]))."</option>";
}
$html.= "</select></div>";
}
$html.= "</div>";
}
?>
window.parent.document.getElementById('divNoSPAC').innerHTML = '<?php
echo $html;
?>
';
setTimeout('ajustarAnchoCombos()', 500);
<?
}
<?
require_once($_SERVER["DOCUMENT_ROOT"]."/constants.php");
require_once($_SERVER["DOCUMENT_ROOT"]."/../Common/database/db_funcs.php");
require_once($_SERVER["DOCUMENT_ROOT"]."/../Common/miscellaneous/general.php");
require_once("crypt.php");
echo strlen(encriptar("1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 123456789 abc def ghi jkl22"))."<br>";
echo strlen(encriptar("________________1____________________________________1______________________________2__________________________3____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________dsfsdfsdfsdfsdfdsfsdfsdf_____"))."<br>";
exit;
$sql =
"SELECT rc_descripcion, rc_id, rc_valor
FROM rrhh.rrc_relacomptencia";
$stmt = DBExecSql($conn, $sql);
while ($row = DBGetQuery($stmt)) {
$params = array(":descripcion" => encriptar($row["RC_ID"].$row["RC_DESCRIPCION"]), ":id" => $row["RC_ID"], ":valor" => encriptar($row["RC_ID"].$row["RC_VALOR"]));
$sql =
"UPDATE rrhh.rrc_relacomptencia
SET rc_descripcion = :descripcion, rc_valor = :valor
WHERE rc_id = :id";
// DBExecSql($conn, $sql, $params);
echo substr(desencriptar($row["RC_VALOR"]), strlen($row["RC_ID"]))." - ".substr(desencriptar($row["RC_DESCRIPCION"]), strlen($row["RC_ID"]))."<br/>";
}
echo "OK<br />";
echo "*** CORRERLO SOLO UNA VEZ ***<br />";
?>
/**
* Realiza la Decodificacion de un valor encriptado
* @param string $valor <p>El valor a desencriptar</p>
* @return string <p>La cadena desencriptada</p>
*/
function desencriptarValor($valor)
{
return desencriptar($valor, CLAVE_AES);
}
