File: /home/asjudine/public_html/cartera/consulta_ced_info_servi.php
<!DOCTYPE html>
<html lang="en">
<head>
<title>Consulta Cartera</title>
<!-- Required meta tags -->
<meta charset="utf-8">
<meta charset="iso-8859-1">
<meta http-equiv="X-UA-Compatible" content="IE=8; IE=9; IE=edge" />
<meta http-equiv=Content-Type content="text/html; charset=utf-8">
<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">
<style>
*{padding: 0;margin: 0;}
main{width: 1100px;margin: 0 auto;}
body{background-image:url(../ELEMENTOS/fondo.jpg);}
header {
background-color: #E8E8E8;
padding: 0 50px 0 50px;
width: 100%;
margin: 0 auto;
display: flex;
display: -webkit-flex;
flex-direction: row;
flex-wrap: wrap;
align-items: center;
align-content: center;
justify-content: space-between;
}
.titulo{margin: 0 auto;text-align: center;background-color: #0b6d0f;color: #fff;padding: 4px; font-size: 18px;}
.boton1{width:30%;background-color: #ffffff;color: #000;padding: 2px;border:2px solid #580000;border-radius:10px;}
.boton1:hover{background-color: #6f0000;color: #fff;cursor: pointer;}
table{margin: 0 auto; border: 10px solid #bebebe;margin-bottom: 5px;}
td{padding: 1px; border-bottom: 1px solid #000; font-size: 15px;}
.colorV{background-color: #e5e5e5; padding: 1px 30px;color: #1d8918;font-size: 15px;font-weight: 600; text-align: center;}
.colorA{background-color: #d6e08b; padding: 2px;color: #000;font-size: 15px;}
.colorB{background-color: #ffffff; padding: 2px;color: #bf0000;font-size: 15px;}
input[type=text]{border-radius: 5px; padding: 3px;background-color: #fffde8;}
.divirmenu{text-align: center;}
.irmenu{width: 200px; background-color: #005f1d; color: #fff; padding: 4px; border-radius: 6px;margin-top: 5px; margin-bottom: 5px;}
.irmenu:hover{background-color: #a4ceb1; color: #000;}
.tdform{background-color: #FFCC66; color: #000; padding: 2px; text-align: center;}
.tdfull{background-color: #fff; color: #000; padding: 1px; text-align: center; font-size: 14px;}
.botoncedula{width: 100%; background-color: #d6e08b;color: #000;padding: 1px;border-radius:5px;}
</style>
<script languaje="JavaScript">
function Mostrar_Fecha()
{
var mydate=new Date()
var year=mydate.getYear()
if (year < 1000)
year+=1900
var day=mydate.getDay()
var month=mydate.getMonth()
var daym=mydate.getDate()
if (daym<10)
daym="0"+daym
var dayarray=new Array("Domingo","Lunes","Martes","Miercoles","Jueves","Viernes","Sabado")
var montharray=new Array("Enero","Febrero","Marzo","Abril","Mayo","Junio","Julio","Agosto","Septiembre","Octubre","Noviembre","Diciembre")
document.write("<b><font face='Arial, Helvetica, sans-serif'>"+dayarray[day]+" "+daym+" de "+montharray[month]+" de "+year+"</font></b>")
}
</script>
<script language="javascript">
function AbreGral()
{
var menu;
menu=window.open("mostrar_ingreso.php","","toolbar=no,scrollbars=no,width=800,height=500,status=yes");
menu.focus();
var ventana = window.self;
ventana.opener = window.self;
ventana.close();
}
</script>
</head>
<body>
<header>
<h1><a href="http://www.asjudinet.com"><img src="../ELEMENTOS/bannerInterasjudinet.png" alt="" width="380" height="60"></a></h1>
</header>
<h3 class="titulo">Solicitud Cartera Juridica</h3>
<main>
<form name="formulario" action="" method="post">
<table>
<!--<tr>
<td colspan="2" class="colorB"><h2>CONSULTA CARTERA</h2></td>
</tr>-->
<tr>
<td colspan="2" class="colorA" align="center">
<script languaje="JavaScript">Mostrar_Fecha()</script>
</td>
</tr>
<tr>
<td class="colorV">Nombre :</td>
<td class="colorV"><input type="text" name="nom" id="nom" size="50" maxlength="50" placeholder="Nombre Del Afiliado" autocomplete="off"></td>
</tr>
<tr>
<td colspan="2" class="colorV">
<input type="submit" name="busqueda" id="busqueda" class="boton1" value="Titular">
<input type="submit" name="busquedar" id="busquedar" class="boton1" value="Beneficiario">
</td>
</tr>
<tr>
<td class="colorV">
<p>Cédula o Codigo:</p>
</td>
<td class="colorV"><input type="text" name="cedula2" id="cedula2" value="" size="50" maxlength="50" placeholder="Cedula Del Afiliado" autocomplete="off"></td>
</tr>
<tr>
<td colspan="2" class="colorV">
<input type="submit" name="consultar" id="consultar" class="boton1" value="Consultar">
</td>
</tr>
</table>
</form>
<div class="divirmenu">
<input type="button" name="menu2" id="menu2" class="irmenu" onClick="window.location.href='consulta_cartera.php'" value="IR AL MENU">
</div>
</main>
</body>
</html>
<!--****************************************************************************-->
<?php
if(isset($_POST["busqueda"]))
{
require_once("Conectarse.php");
echo "<form name='form' action='' method='post'>";
global $dbi;
$mssql = mysql_query('SELECT * FROM cartera_serviasjudinet ');
if (!$mssql) {
die('Invalid query 1: ' . mysql_error());
}
if($mssql)
{
$filas = mysql_num_rows($mssql);
if ($filas > 0)
{
$nom = $_POST["nom"];
$control = mysql_query('SELECT cedula, nombre, numerocontrato, tipocontrato, tipo_afiliado, estado FROM cartera_serviasjudinet WHERE nombre LIKE "'."%$nom%".'" order by nombre ');
if (!$control) {
die('Invalid query 2: ' . mysql_error());
}
if ((mysql_num_rows($control)!=0))
{
echo "<TABLE width='900' border='0' align='center' cellpadding='0' cellspacing='1'>
<TR>
<TD class='tdform'>CEDULA</TD>
<TD class='tdform'>NOMBRE</TD>
<TD class='tdform'>N° CONTRATO</TD>
<TD class='tdform'>TIPO </TD>
<TD class='tdform'>TIPO AFILIADO</TD>
<TD class='tdform'>VIGENTE/HISTORICO</TD>";
while(list($cedula,$nombres,$numcon,$tipo,$afili,$estado) = mysql_fetch_row($control))
{
if ($tipo > 0)
{
$cont10 = mysql_query('SELECT codigo_contrato FROM planes_contratos WHERE codigo = "' . "$tipo". '" ');
if (!$cont10) {
die('Invalid query 42: ' . mysql_error());
}
list($tipo) = mysql_fetch_row($cont10);
}
if ($afili != 'TITULAR')
{
$afili = 'BENEFICIARIO';
}
if ($estado == 0)
{
$esta = "HISTORICO";
}
else
{
$esta = "VIGENTE";
}
if ($afili == 'BENEFICIARIO')
{
printf("<tr>
<TD ><input type='button' value=$cedula name='cedu' class='botoncedula' onClick =window.location.href='cartera_consul_bene_usuario.php?ced2=$cedula&numcon=$numcon'></a></TD>
<td class='tdfull'>".$nombres."</td>
<td class='tdfull'>".$numcon."</td>
<td class='tdfull'>".$tipo."</td>
<td class='tdfull'>".$afili."</td>
<td class='tdfull'>".$esta."</td>");
}
else
{
printf("<tr>
<TD ><input type='button' value=$cedula name='cedu' class='botoncedula' onClick =window.location.href='cartera_consulta_titu_usuario.php?ced2=$cedula&numcon=$numcon'></a></TD>
<td class='tdfull'>".$nombres."</td>
<td class='tdfull'>".$numcon."</td>
<td class='tdfull'>".$tipo."</td>
<td class='tdfull'>".$afili."</td>
<td class='tdfull'>".$esta."</td>");
}
}
echo "</table>";
}
}
}
echo "</form>";
}
/*11111111111*/
if(isset($_POST["busquedar"]))
{
require_once("Conectarse.php");
echo "<form name='form' action='' method='post'>";
global $dbi;
$mssql = mysql_query('SELECT * FROM cartera_serviasjudinet ');
if (!$mssql) {
die('Invalid query 1: ' . mysql_error());
}
if($mssql)
{
$filas = mysql_num_rows($mssql);
if ($filas > 0)
{
$nom = $_POST["nom"];
$control = mysql_query('SELECT cedula, nombre, cedula_titular, numero_contrato_titular, tipo_contrato_titular, parentesco FROM beneficiarios WHERE nombre LIKE "' . "%$nom%" . '" order by nombre ');
if (!$control) {
die('Invalid query 2: ' . mysql_error());
}
if ((mysql_num_rows($control)!=0))
{
echo "<TABLE width='900' border='0' align='center' cellpadding='0' cellspacing='1'>
<TR>
<TD class='tdform'>CEDULA</TD>
<TD class='tdform'>NOMBRE</TD>
<TD class='tdform'>N° CONTRATO></TD>
<TD class='tdform'>TIPO</TD>
<TD class='tdform'>TIPO AFILIADO</TD>
<TD class='tdform'>VIGENTE/HISTORICO</TD>";
while(list($cedula,$nombres,$cedtitu,$numcon,$tipo,$afili) = mysql_fetch_row($control))
{
if ($tipo > 0)
{
$cont10 = mysql_query('SELECT codigo_contrato FROM planes_contratos WHERE codigo = "' . "$tipo". '" ');
if (!$cont10) {
die('Invalid query 42: ' . mysql_error());
}
list($tipo) = mysql_fetch_row($cont10);
}
if ($afili != 'TITULAR')
{
$afili = 'BENEFICIARIO';
}
$esta = mysql_query('SELECT estado FROM cartera_serviasjudinet WHERE numerocontrato = "' . "$numcon". '" AND tipocontrato = "' . "$tipo". '" AND cedula = "' . "$cedtitu". '" ');
if (!$esta) {
die('Invalid query 42: ' . mysql_error());
}
list($estado) = mysql_fetch_row($esta);
if ($estado == 0)
{
$esta = "HISTORICO";
}
else
{
$esta = "VIGENTE";
}
if ($afili == 'BENEFICIARIO')
{
printf("<tr>
<TD ><input type='button' value=$cedula name='cedu' class='botoncedula' onClick =window.location.href='cartera_consul_bene_usuario.php?ced2=$cedula&numcon=$numcon'></a></TD>
<td class='tdfull'>".$nombres."</td>
<td class='tdfull'>".$numcon."</td>
<td class='tdfull'>".$tipo."</td>
<td class='tdfull'>".$afili."</td>
<td class='tdfull'>".$esta."</td>");
}
else
{
printf("<tr>
<TD ><input type='button' value=$cedula name='cedu' class='botoncedula' onClick =window.location.href='cartera_consulta_titu_usuario.php?ced2=$cedula&numcon=$numcon'></a></TD>
<td td class='tdfull'>".$nombres."</td>
<td td class='tdfull'>".$numcon."</td>
<td td class='tdfull'>".$tipo."</td>
<td td class='tdfull'>".$afili."</td>
<td td class='tdfull'>".$esta."</td>");
}
}
echo "</table>";
}
}
}
echo "</form>";
}
/******************************************************************************************/
if(isset($_POST["consultar"]))
{
require_once("../Conectarse.php");
echo "<form name='form' action='' method='post'>";
global $dbi;
$control = mysql_query('SELECT cedula, nombre, numerocontrato, tipocontrato, tipo_afiliado, estado FROM cartera_serviasjudinet WHERE cedula = "' . $_POST["cedula2"] . '" || codigo_militar = "' . $_POST["cedula2"] . '" order by nombre ');
if (!$control) {
die('Invalid query 2: ' . mysql_error());
}
if ((mysql_num_rows($control)!=0))
{
echo "<TABLE width='900' border='0' align='center' cellpadding='0' cellspacing='1'>
<tr>
<td class='tdform'>CEDULA</td>
<td class='tdform'>NOMBRE</td>
<td class='tdform'>N° CONTRATO</td>
<td class='tdform'>TIPO </td>
<td class='tdform'>TIPO AFILIADO</td>
<td class='tdform'>VIGENTE/HISTORICO</td>";
while(list($cedula,$nombres,$numcon,$tipo,$afili,$estado) = mysql_fetch_row($control))
{
if ($tipo > 0)
{
$cont10 = mysql_query('SELECT codigo_contrato FROM planes_contratos WHERE codigo = "' . "$tipo". '" ');
if (!$cont10) {
die('Invalid query 42: ' . mysql_error());
}
list($tipo) = mysql_fetch_row($cont10);
}
if ($afili != 'TITULAR')
{
$afili = 'BENEFICIARIO';
}
if ($estado == 0)
{
$esta = "HISTORICO";
}
else
{
$esta = "VIGENTE";
}
if ($afili == 'BENEFICIARIO')
{
$estass = mysql_query('SELECT estado FROM cartera_serviasjudinet WHERE numerocontrato = "' . "$numcon". '" AND tipocontrato = "' . "$tipo". '" ');
if (!$estass) {
die('Invalid query 42: ' . mysql_error());
}
list($estado) = mysql_fetch_row($estass);
if ($estado == 0)
{
$esta = "HISTORICO";
}
else
{
$esta = "VIGENTE";
}
printf("<tr>
<TD class='tdfull'><input type='button' value=$cedula name='cedu' class='botoncedula' onClick =window.location.href='cartera_consul_bene_usuario.php?ced2=$cedula&numcon=$numcon'></a></TD>
<td class='tdfull'>".$nombres."</td>
<td class='tdfull'>".$numcon."</td>
<td class='tdfull'>".$tipo."</td>
<td class='tdfull'>".$afili."</td>
<td class='tdfull'>".$esta."</td>");
}
else
{
printf("<tr>
<TD class='tdfull'><input type='button' value=$cedula name='cedu' class='botoncedula' onClick =window.location.href='cartera_consulta_titu_usuario.php?ced2=$cedula&numcon=$numcon'></a></TD>
<td class='tdfull'>".$nombres."</td>
<td class='tdfull'>".$numcon."</td>
<td class='tdfull'>".$tipo."</td>
<td class='tdfull'>".$afili."</td>
<td class='tdfull'>".$esta."</td>");
}
}
echo "</table>";
}
$bene = mysql_query('SELECT cedula, nombre, numero_contrato_titular, tipo_contrato_titular, parentesco, estado FROM beneficiarios WHERE cedula = "' . $_POST["cedula2"] . '" order by nombre ');
if (!$bene) {
die('Invalid query 2: ' . mysql_error());
}
if ((mysql_num_rows($bene)!=0))
{
$control = mysql_query('SELECT cedula, nombre, numero_contrato_titular, tipo_contrato_titular, parentesco, estado FROM beneficiarios WHERE cedula = "' . $_POST["cedula2"] . '" order by nombre ');
if (!$control) {
die('Invalid query 2: ' . mysql_error());
}
if ((mysql_num_rows($control)!=0))
{
echo "<TABLE width='900' border='0' align='center' cellpadding='0' cellspacing='1'>
<TR>
<TD class='tdform'>CEDULA</TD>
<TD class='tdform'>NOMBRE</TD>
<TD class='tdform'>N° CONTRATO</TD>
<TD class='tdform'>TIPO </TD>
<TD class='tdform'>TIPO AFILIADO</TD>
<TD class='tdform'>VIGENTE/HISTORICO </TD>";
while(list($cedula, $nombres , $numcon, $tipo, $afili, $estado) = mysql_fetch_row($control))
{
if ($tipo > 0)
{
$cont10 = mysql_query('SELECT codigo_contrato FROM planes_contratos WHERE codigo = "' . "$tipo". '" ');
if (!$cont10)
{
die('Invalid query 42: ' . mysql_error());
}
list($tipo) = mysql_fetch_row($cont10);
}
if ($afili != 'TITULAR')
{
$afili = 'BENEFICIARIO';
}
if ($estado == 0)
{
$esta = "HISTORICO";
}
else
{
$esta = "VIGENTE";
}
if ($afili == 'BENEFICIARIO')
{
$estass = mysql_query('SELECT estado FROM cartera_serviasjudinet WHERE numerocontrato = "' . "$numcon". '" AND tipocontrato = "' . "$tipo". '" ');
if (!$estass) {
die('Invalid query 42: ' . mysql_error());
}
list($estado) = mysql_fetch_row($estass);
if ($estado == 0)
{
$esta = "HISTORICO";
}
else
{
$esta = "VIGENTE";
}
printf("<tr>
<TD ><input type='button' value=$cedula name='cedu' class='botoncedula' onClick =window.location.href='cartera_consul_bene_usuario.php?ced2=$cedula&numcon=$numcon'></a></TD>
<td class='tdfull'>".$nombres."</td>
<td class='tdfull'>".$numcon."</td>
<td class='tdfull'>".$tipo."</td>
<td class='tdfull'>".$afili."</td>
<td class='tdfull'>".$esta."</td>");
}
else
{
printf("<tr>
<TD ><input type='button' value=$cedula name='cedu' class='botoncedula' onClick =window.location.href='cartera_consulta_titu_usuario.php?ced2=$cedula&numcon=$numcon'></a></TD>
<td class='tdfull'>".$nombres."</td>
<td class='tdfull'>".$numcon."</td>
<td class='tdfull'>".$tipo."</td>
<td class='tdfull'>".$afili."</td>
<td class='tdfull'>".$esta."</td>");
}
}
echo "</table>";
}
}
$control = mysql_query('SELECT cedula,apellidos, nombres, numero_contrato, tipo_contrato, empresa_laboral,direccion_empresa, estado FROM consultorio_juridico WHERE cedula = "' . $_POST["cedula2"] . '" ');
if (!$control) {
die('Invalid query 2: ' . mysql_error());
}
if ((mysql_num_rows($control)!=0))
{
echo "<TABLE width='900' border='0' align='center' cellpadding='0' cellspacing='1'>
<TR>
<td class='tdform'>CEDULA</td>
<td class='tdform'>NOMBRE</td>
<td class='tdform'>APELLIDOS</td>
<td class='tdform'>N° CONTRATO</td>
<td class='tdform'>TIPO CONTRATO</td>
<td class='tdform'>EMPRESA</td>
<td class='tdform'>TIPO AFILIADO</td>
<td class='tdform'>VIGENTE/HISTORICO </td>";
while(list($cedula,$apellidos, $nombres , $numcon, $tipo,$tipocontra, $afili, $estados) = mysql_fetch_row($control))
{
if ($tipo > 0)
{
$cont10 = mysql_query('SELECT codigo_contrato FROM planes_contratos WHERE codigo = "' . "$tipo". '" ');
if (!$cont10)
{
die('Invalid query 42: ' . mysql_error());
}
list($tipo) = mysql_fetch_row($cont10);
}
if ($afili != 'TITULAR')
{
$afili = 'TITULAR';
}
if ($estado == 0)
{
$esta = "CONFERENCIA REALIZADA";
}
else
{
$esta = "VIGENTE";
}
if ($afili == 'BENEFICIARIO')
{
$estass = mysql_query('SELECT estado FROM cartera_serviasjudinet WHERE numerocontrato = "' . "$numcon". '" AND tipocontrato = "' . "$tipo". '" ');
if (!$estass)
{
die('Invalid query 42: ' . mysql_error());
}
list($estado) = mysql_fetch_row($estass);
if ($estado == 0)
{
$esta = "BENEFICIARIO CORPORATIVO";
}
else
{
$esta = "VIGENTE";
}
$nombre_completo= $apellidos.''.$nombres;
printf("<tr>
<td class='tdfull'>".$cedula."</td>
<td class='tdfull'>".$cedula."</td>
<td class='tdfull'>".$nombres."</td>
<td class='tdfull'>".$apellidos."</td>
<td class='tdfull'>".$numcon."</td>
<td class='tdfull'>".$tipocontra."</td>
<td class='tdfull'>".$tipo."</td>
<td class='tdfull'>".$afili."</td>
<td class='tdfull'>".$esta."</td>");
}
else
{
printf("<tr>
<td class='tdfull'>".$cedula."</td>
<td class='tdfull'>".$nombres."</td>
<td class='tdfull'>".$apellidos."</td>
<td class='tdfull'>".$numcon."</td>
<td class='tdfull'>".$tipo."</td>
<td class='tdfull'>".$tipocontra."</td>
<td class='tdfull'>".$afili."</td>
<td class='tdfull'>".$esta."</td>");
}
}
echo "</table>";
}
echo "</form>";
}
?>