File: /home/asjudine/www/avigilajudicial/validar_vigi_judicial.php
<?php
/* establecer la caducidad de la caché a 30 minutos */
session_cache_expire(360);
$cache_expire = session_cache_expire();
ini_set("session.cookie_lifetime","20800");
ini_set("session.gc_maxlifetime","20800");
session_start();
error_reporting(0);
/*session_start();
//error_reporting(E_ALL ^ E_NOTICE);
$varsessionvigilancia = $_SESSION['cedula'];
$nom = $_GET["nom"];
$ced = $_GET["ced"];
$cargo = $_GET["cargo"];
//$cargo = base64_encode($cargo);
if($varsessionvigilancia != null){
echo "<SCRIPT LANGUAGE='javascript'>window.location.href='menu_vigilancia_judicial.php?ced=$Ced&nom=$Nom'</SCRIPT>";
}
*/
require_once("../Conectarse_.php");
if(isset($_POST["Submit"])){
$enviado=1;
$Logo = $_POST["Login"];
$Pass = $_POST["Password"];
/*$result = mysql_query('SELECT Login, Password, Cedula, Nombre_Completo, nivel, codigo, sucursal, Cargo FROM Usuarios WHERE Login = "' . $Logo . '" and Password = "'.$Pass.'" ');
if (!$result) {
die('Invalid query: ' . mysql_error());
}
if ($Logo != '' and $Pass != '')
{
$row = mysql_fetch_row($result);
$Ced = $row[2];
$Nom = $row[3];
$nivel = $row[4];
$Cargo = $row[7];*/
$result = mysql_query('SELECT Login, Password, Cedula, Nombre_Completo, Cargo, nivel, Cargo2, nivel2, codigo, sucursal FROM Usuarios WHERE Login = "' . $Logo . '" and Password = "'.$Pass.'" AND estado = "1" ');
if (!$result) {
die('Invalid query: ' . mysql_error());
}
if ($Logo != '' and $Pass != '')
{
$row = mysql_fetch_row($result);
$Ced = $row[2];
$Nom = $row[3];
$Cargo = $row[4];
$nivel = $row[5];
$Cargo2 = $row[6];
$nivel2 = $row[7];
$Codigo = $row[8];
$Sucursal = $row[9];
if($row[0] == $Logo )
{
if($row[1] == $Pass)
{
if($Codigo == "001" || $Codigo == "980" || $Codigo == "126" || $Cargo == "ADMINISTRADOR" || $Cargo == "JEFE SUPERVISOR" || $Cargo == "SUPERIOR SUPERVISOR" || $Cargo == "SUPERVISOR" || $Cargo == "ABOGADO" || $Cargo == "TECNICO" || $Cargo2 == "SUPERVISOR" || $Cargo2 == "ABOGADO")
{
//$captcha = $_POST["g-recaptcha-response"];
//$secret = '6LdTyd0UAAAAAGNopNxva2ftkCI8CD0bKFduTuwb';
//Validacion CAPTCHA
//if(!$captcha){
// echo "<script>alert('Verifica el Captcha')</script>";
//}
//$response = file_get_contents("https://www.google.com/recaptcha/api/siteverify?secret=$secret&response=$captcha");
//$arr = json_decode($response, TRUE);
//if($arr['success']){
//echo "Se valido la captcha";
$fecha_auto = date("Y-m-d");
$time =time();
$hora_auto=date("H:i:s",$time);
ini_set('date.timezone','America/Bogota');
$hora_auto = date('H:i:s');
$consulta = mysql_query('SELECT estado FROM Usuarios_eventos WHERE cedula = "'.$Ced.'" ');
if (!$consulta) {
die('Invalid query 14: ' . mysql_error());
}
list($estado) = mysql_fetch_row($consulta);
$row_filas_existe = mysql_num_rows($consulta);
if($row_filas_existe > 0)
{
$consulta_registro = mysql_query('SELECT estado FROM Usuarios_eventos WHERE cedula = "'.$Ced.'" ');
if (!$consulta_registro) {
die('Invalid query 15: ' . mysql_error());
}
list($estado) = mysql_fetch_row($consulta_registro);
if($estado == "no_existe"){
echo "<script>alert('Usted tiene una sesion iniciada')</script>";
echo "<SCRIPT LANGUAGE='javascript'>window.location.href='validar_vigi_judicial.php'</SCRIPT>";
}
else
{
//ini_set("session.cookie_lifetime","10800");
//ini_set("session.gc_maxlifetime","10800");
$consultar_registro = mysql_query('SELECT estado FROM Usuarios_eventos WHERE cedula = "'.$Ced.'" ');
if (!$consultar_registro) {
die('Invalid query 16: ' . mysql_error());
}
list($estado) = mysql_fetch_row($consultar_registro);
$filas = mysql_num_rows($consultar_registro);
$_SESSION['cedula'] = $Ced;
//$_SESSION['nombre'] = $nom;
//$_SESSION['tiempo'] = time();
//COOKIE
setcookie('cedcookie', $Ced, time()+9200);
setcookie('nomcookie', $Nom, time()+9200);
if($estado == 0){
$actualiza_estado = mysql_query('UPDATE Usuarios_eventos SET estado = 1, fecha_ingreso = "'.$fecha_auto.'", hora_ingreso = "'.$hora_auto.'" WHERE cedula = "'.$Ced.'" ');
}
if($nivel == 1 and ($nivel2 == "" || $nivel2 == 0) ){
echo "<SCRIPT LANGUAGE='javascript'>window.location.href='menu_vigilancia_judicial_abogados.php?ced=$Ced&nom=$Nom'</SCRIPT>";
}
if($nivel == 2 and ($nivel2 == "" || $nivel2 == 0) ){
echo "<SCRIPT LANGUAGE='javascript'>window.location.href='menu_vigilancia_judicial_supervisor.php?ced=$Ced&nom=$Nom'</SCRIPT>";
}
//SI ES SUPERVISOR Y APODRERADO
if($nivel == 1 and $nivel2 == 2){
echo "<SCRIPT LANGUAGE='javascript'>window.location.href='seleccion_rol_vigilancia_judicial.php?ced=$Ced&nom=$Nom'</SCRIPT>";
}
if($nivel == 2 and $nivel2 == 1){
echo "<SCRIPT LANGUAGE='javascript'>window.location.href='seleccion_rol_vigilancia_judicial.php?ced=$Ced&nom=$Nom'</SCRIPT>";
}
/////
if($nivel == 3){
echo "<SCRIPT LANGUAGE='javascript'>window.location.href='menu_vigilancia_judicial_superior.php?ced=$Ced&nom=$Nom'</SCRIPT>";
}
if($nivel == 4){
echo "<SCRIPT LANGUAGE='javascript'>window.location.href='menu_vigilancia_judicial_jefe.php?ced=$Ced&nom=$Nom'</SCRIPT>";
}
} //fin del else
}//fin si existen datos
else
{
$trae_info = mysql_query('SELECT Login, Password, Cedula, Nombre_Completo, nivel, nivel2 FROM Usuarios WHERE Cedula = "'.$Ced.'" ');
if (!$trae_info) {
die('Invalid query 17: ' . mysql_error());
}
list($login, $password, $cedula, $nombre, $nivel, $nivel2) = mysql_fetch_row($trae_info);
$inserta = mysql_query('INSERT INTO Usuarios_eventos (Login, Password, Cedula, Nombre_Completo, nivel, nivel2, fecha_ingreso, hora_ingreso, estado) VALUES ("'.$login.'", "'.$password.'", "'.$cedula.'", "'.$nombre.'", "'.$nivel.'", "'.$nivel2.'", "'.$fecha_auto.'", "'.$hora_auto.'", "1") ');
$_SESSION['cedula'] = $Ced;
//$_SESSION['nombre'] = $nom;
//$_SESSION['tiempo'] = time();
//COOKIE
//setcookie('cedcookie', $Ced, time()+9200);
//setcookie('nomcookie', $Nom, time()+9200);
if($nivel == 1 and ($nivel2 == "" || $nivel2 == 0) ){
echo "<SCRIPT LANGUAGE='javascript'>window.location.href='menu_vigilancia_judicial_abogados.php?ced=$Ced&nom=$Nom'</SCRIPT>";
}
if($nivel == 2 and ($nivel2 == "" || $nivel2 == 0) ){
echo "<SCRIPT LANGUAGE='javascript'>window.location.href='menu_vigilancia_judicial_supervisor.php?ced=$Ced&nom=$Nom'</SCRIPT>";
}
//SI ES SUPERVISOR Y APODRERADO
if($nivel == 1 and $nivel2 == 2){
echo "<SCRIPT LANGUAGE='javascript'>window.location.href='seleccion_rol_vigilancia_judicial.php?ced=$Ced&nom=$Nom'</SCRIPT>";
}
if($nivel == 2 and $nivel2 == 1){
echo "<SCRIPT LANGUAGE='javascript'>window.location.href='seleccion_rol_vigilancia_judicial.php?ced=$Ced&nom=$Nom'</SCRIPT>";
}
/////
if($nivel == 3){
echo "<SCRIPT LANGUAGE='javascript'>window.location.href='menu_vigilancia_judicial_superior.php?ced=$Ced&nom=$Nom'</SCRIPT>";
}
if($nivel == 4){
echo "<SCRIPT LANGUAGE='javascript'>window.location.href='menu_vigilancia_judicial_jefe.php?ced=$Ced&nom=$Nom'</SCRIPT>";
}
}
//}else{
// echo "<SCRIPT LANGUAGE='javascript'>window.location.href='validar_vigi_judicial.php'</SCRIPT>";
//}
//echo "<SCRIPT LANGUAGE='javascript'>window.location.href='menu_vigilancia_judicial.php?ced=$Ced&nom=$Nom'</SCRIPT>";
//$actualiza_estado = mysql_query('UPDATE Usuarios SET estado = 1 WHERE cedula = "'.$Ced.'" ');
}
else
{
echo "<script>alert('Usted no tiene autorización para revisar solicitudes')</script>";
echo "<SCRIPT LANGUAGE='javascript'>window.location.href='validar_vigi_judicial.php'</SCRIPT>";
}
}
else
{
echo "<script>alert('Password incorrecto, por favor verifique')</script>";
echo "<SCRIPT LANGUAGE='javascript'>window.location.href='validar_vigi_judicial.php'</SCRIPT>";
}
}
else
{
echo "<script>alert('El usuario no existe en la base de datos')</script>";
echo "<SCRIPT LANGUAGE='javascript'>window.location.href='validar_vigi_judicial.php'</SCRIPT>";
}
} // post login
else
{
echo "<script>alert('El usuario no existe en la base de datos')</script>";
echo "<SCRIPT LANGUAGE='javascript'>window.location.href='validar_vigi_judicial.php'</SCRIPT>";
}
} // post submit
?>
<?php if(!$enviado){?>
<!DOCTYPE html>
<html>
<head>
<title>Login</title>
<meta http-equiv="X-UA-Compatible" content="IE=8; IE=9; IE=edge" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<link rel="stylesheet" href="../css/bootstrap.min.css">
<link rel="stylesheet" href="css/estilos.css">
<style type="text/css">
table{margin: 0 auto;border: 8px solid #bebebe;}
.main{margin: 0 auto; }
.contain{width:100%; margin: 0 auto; opacity: 1; }
.form-container {
margin: 0 auto;
border: 0px solid #ff4a4a;
/*background: #5c0a0a;*/
background: #14330D;
background: -webkit-gradient(linear, left top, left bottom, from(#0C470C), to(#003A01));
background: -webkit-linear-gradient(top, #0C470C, #003A01);
background: -moz-linear-gradient(top, #0C470C, #003A01);
background: -ms-linear-gradient(top, #0C470C, #003A01);
background: -o-linear-gradient(top, #0C470C, #003A01);
background-image: -ms-linear-gradient(top, #0C470C 0%, #003A01 100%);
-webkit-border-radius: 8px;
-moz-border-radius: 8px;
border-radius: 8px;
-webkit-box-shadow: rgba(000,000,000,0.9) 0 1px 2px, inset rgba(255,255,255,0.4) 0 1px 0;
-moz-box-shadow: rgba(000,000,000,0.9) 0 1px 2px, inset rgba(255,255,255,0.4) 0 1px 0;
box-shadow: rgba(000,000,000,0.9) 0 1px 2px, inset rgba(255,255,255,0.4) 0 1px 0;
font-family: 'Helvetica Neue',Helvetica,sans-serif;
text-decoration: none;
vertical-align: middle;
min-width:300px;
padding:20px;
width:25%;
}
.form-field {
border: 1px solid #c9b7a2;
background: #e4d5c3;
-webkit-border-radius: 1px;
-moz-border-radius: 1px;
border-radius: 1px;
/*color: #c9b7a2;*/
color: #5C5C5C;
-webkit-box-shadow: rgba(255,255,255,0.4) 0 1px 0, inset rgba(000,000,000,0.7) 0 0px 0px;
-moz-box-shadow: rgba(255,255,255,0.4) 0 1px 0, inset rgba(000,000,000,0.7) 0 0px 0px;
box-shadow: rgba(255,255,255,0.4) 0 1px 0, inset rgba(000,000,000,0.7) 0 0px 0px;
padding:5px;
margin-bottom:5px;
width:100%;
}
.form-field:focus {
background: #ffffff;
color: #725129;
}
.form-container h2 {
text-shadow: #ffffff 0 1px 0;
font-size:16px;
margin: 0 0 20px 0;
font-weight:bold;
text-align:center;
}
.form-title {
text-align:left;
margin-bottom:5px;
color: #ffffff;
text-shadow: #ffffff 0 1px 0;
}
.submit-container {
margin: 4px 0;
text-align:right;
}
.submit-button {
width: 100%;
border: 1px solid #ffffff;
background: #4d0000;
background: -webkit-gradient(linear, left top, left bottom, from(#ff0000), to(#4d0000));
background: -webkit-linear-gradient(top, #ff0000, #4d0000);
background: -moz-linear-gradient(top, #ff0000, #4d0000);
background: -ms-linear-gradient(top, #ff0000, #4d0000);
background: -o-linear-gradient(top, #ff0000, #4d0000);
background-image: -ms-linear-gradient(top, #ff0000 0%, #4d0000 100%);
-webkit-border-radius: 4px;
-moz-border-radius: 4px;
border-radius: 4px;
-webkit-box-shadow: rgba(255,255,255,0.4) 0 1px 0, inset rgba(255,255,255,0.4) 0 1px 0;
-moz-box-shadow: rgba(255,255,255,0.4) 0 1px 0, inset rgba(255,255,255,0.4) 0 1px 0;
box-shadow: rgba(255,255,255,0.4) 0 1px 0, inset rgba(255,255,255,0.4) 0 1px 0;
text-shadow: #000000 0 1px 0;
color: #ffffff;
font-family: helvetica, serif;
padding: 8px 8px;
font-size: 12px;
text-decoration: none;
vertical-align: middle;
margin-bottom:10px;
}
.submit-button:hover {
border: 1px solid #000000;
text-shadow: #ff0000 0 1px 0;
background: #ff0000;
background: -webkit-gradient(linear, left top, left bottom, from(#880003), to(#BF0026));
background: -webkit-linear-gradient(top, #880003, #BF0026);
background: -moz-linear-gradient(top, #880003, #BF0026);
background: -ms-linear-gradient(top, #880003, #BF0026);
background: -o-linear-gradient(top, #880003, #BF0026);
background-image: -ms-linear-gradient(top, #880003 0%, #BF0026 100%);
color: #fff;
}
.submit-button:active {
text-shadow: #1735aa 0 1px 0;
border: 1px solid #000000;
background: #00135F;
background: -webkit-gradient(linear, left top, left bottom, from(#032c9a), to(#ff0000));
background: -webkit-linear-gradient(top, #032c9a, #52609F);
background: -moz-linear-gradient(top, #032c9a, #52609F);
background: -ms-linear-gradient(top, #032c9a, #52609F);
background: -o-linear-gradient(top, #032c9a, #52609F);
background-image: -ms-linear-gradient(top, #52609F 0%, #52609F 100%);
color: #fff;
}
.boton{
width: 100%;
border: 1px solid #ffffff;
background: #00135F;
background: -webkit-gradient(linear, left top, left bottom, from(#003D79), to(#00135F));
background: -webkit-linear-gradient(top, #003D79, #00135F);
background: -moz-linear-gradient(top, #003D79, #00135F);
background: -ms-linear-gradient(top, #003D79, #00135F);
background: -o-linear-gradient(top, #003D79, #00135F);
background-image: -ms-linear-gradient(top, #003D79 0%, #00135F 100%);
-webkit-border-radius: 4px;
-moz-border-radius: 4px;
border-radius: 4px;
text-shadow: #000000 0 1px 0;
color: #ffffff;
font-family: helvetica, serif;
padding: 8.5px 18px;
font-size: 14px;
text-decoration: none;
vertical-align: middle;
text-align: center;
}
.boton:hover {
border: 1px solid #000000;
text-shadow: #ff0000 0 1px 0;
background: #ff0000;
background: -webkit-gradient(linear, left top, left bottom, from(#011F63), to(#01335C));
background: -webkit-linear-gradient(top, #011F63, #01335C);
background: -moz-linear-gradient(top, #011F63, #01335C);
background: -ms-linear-gradient(top, #011F63, #01335C);
background: -o-linear-gradient(top, #011F63, #01335C);
background-image: -ms-linear-gradient(top, #011F63 0%, #01335C 100%);
color: #fff;
}
@media (max-width: 600px) {
header img {
width: 100%;
}
.form-container {
width: 100%;
}
.titulo{
font-size: 14px;
}
}
.submit-button1 { width: 100%;
border: 1px solid #ffffff;
background: #4d0000;
background: -webkit-gradient(linear, left top, left bottom, from(#ff0000), to(#4d0000));
background: -webkit-linear-gradient(top, #ff0000, #4d0000);
background: -moz-linear-gradient(top, #ff0000, #4d0000);
background: -ms-linear-gradient(top, #ff0000, #4d0000);
background: -o-linear-gradient(top, #ff0000, #4d0000);
background-image: -ms-linear-gradient(top, #ff0000 0%, #4d0000 100%);
-webkit-border-radius: 4px;
-moz-border-radius: 4px;
border-radius: 4px;
-webkit-box-shadow: rgba(255,255,255,0.4) 0 1px 0, inset rgba(255,255,255,0.4) 0 1px 0;
-moz-box-shadow: rgba(255,255,255,0.4) 0 1px 0, inset rgba(255,255,255,0.4) 0 1px 0;
box-shadow: rgba(255,255,255,0.4) 0 1px 0, inset rgba(255,255,255,0.4) 0 1px 0;
text-shadow: #000000 0 1px 0;
color: #ffffff;
font-family: helvetica, serif;
padding: 8px 8px;
font-size: 12px;
text-decoration: none;
vertical-align: middle;
margin-bottom:10px;
}
</style>
<script src="https://www.google.com/recaptcha/api.js" async defer></script>
</head>
<script Language="JavaScript"><!--
function validar()
{
if (formulario.login.value == "")
{
alert("Falta llenar el campo nombre del funcionario");
formulario.login.focus();
return (false);
}
if (formulario.clave.value == "")
{
alert("Falta llenar el campo contraseña");
formulario.clave.focus();
return (false);
}
return (true);
}
//--></script>
<body>
<?php require('header.php') ?>
<h3 class="titulo">VALIDAR VIGILANCIA JUDICIAL</h3>
<div class="main">
<div class="contain">
<form id="form1" class="form-container" name="form1" method="post" action="<?=$_SERVER['PHP_SELF']?>" onSubmit="return validar(this)">
<div class="form-title"><h2>OPERACION VALIDA UNICAMENTE PARA FUNCIONARIOS</h2></div>
<div class="form-title">Nombre Del Funcionario</div>
<input class="form-field" type="text" name="Login" id="Login" placeholder="Usuario" required autocomplete="off" autofocus/><br>
<div class="form-title">Password</div>
<input class="form-field" type="password" name="Password" id="Password" placeholder="Digite la clave" required/>
<br>
<!-- Captcha -->
<!--<div class="g-recaptcha" data-sitekey="6LdTyd0UAAAAAGl75f_QfuriDzrr3HmMzJHdebXv"></div>-->
<br>
<span class="submit-container">
<input class="submit-button1" type="Submit" name ="Submit" value="INICIAR" />
</span><br />
<div class="submit-container"><?php echo "<input type='button' class='boton' onclick='location.href=\"../index.php\"' value='REGRESAR'>"; ?>
</div>
</form>
</div>
</div>
<!--<script src="https://www.google.com/recaptcha/api.js?onload=onloadCallback&render=explicit"
async defer>
</script>-->
</body>
</html>
<?php }if($enviado){?>
<center>
<?php
CloseTable();
}
?>