MOON
Server: Apache/2.2.34 (Unix) mod_ssl/2.2.34 OpenSSL/0.9.8e-fips-rhel5 mod_bwlimited/1.4 FrontPage/5.0.2.2635
System: Linux server.asjudinet.com 2.6.32-042stab141.3 #1 SMP Fri Nov 15 22:45:34 MSK 2019 i686
User: asjudine (504)
PHP: 5.2.17
Disabled: NONE
$ pwd: /home/asjudine/www/
Upload Files
File: /home/asjudine/www/credito_consulta_cartera.php
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>
<head>
<title>Consulta Cartera por cedula y Nombre</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<style type="text/css">
<!--
.titulos {font: 16px; color: red; font-family:Arial; font-weight:bold}
.boton {background-color: #FFCCCC; color:#FFFFFF; width:90px; height:25; border: 3px solid #0000CC; font-family:Arial; color:#990000;}
.texto {background-color: #CCFFCC; font-size: 11px; font-family: Arial; color:#0000CC; display: block;}
.fecha {font-size: 12px; font-family: Arial; color:#990000; display: block; }
.campo {background-color:#FFFFAA; width: 100px; border:2px solid #990000;}
.lista {font-family: Arial; font-size: 11px;	color: #990000;}
.lista2 {font-family: Arial; font-size: 16px;	color: #FF6600;}
.boton2 {
	font-family: Verdana;
	font-size: 8 pt;
	color: #000080;
	background-color: #C0C0C0;
	border-style: solid;
	width:90px;
	height:22px;
}
body {
	background-image: url();
}
.Estilo50 {color: #CC3333;
	font-family: "Arial Narrow";
	font-weight: bold;
}
.Estilo51 {
	color: #3366FF;
	font-weight: bold;
}
.boton1 {background-color: #FFCCCC; color:#FFFFFF; width:90px; height:25; border: 3px solid #0000CC; font-family:Arial; color:#990000;}
.boton11 {background-color: #FFCCCC; color:#FFFFFF; width:90px; height:25; border: 3px solid #0000CC; font-family:Arial; color:#990000;}
-->
</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 onLoad="document.formulario.cedula.focus()" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<form name="formulario" action="" method="post">
<table width="671" border="0" cellspacing="0" cellpadding="0" align="center">
  <tr>
    <td><fieldset><table width="669" border="0" align="center" cellpadding="2" cellspacing="2">
  <tr bgcolor="#FFFFCC">
    <td colspan="2" class="titulos"><div align="center"> INGRESAR BONOS CREDITO ROTATIVO</div></td>
  </tr>
  <tr bgcolor="#ECE9D8">
    <td height="22" colspan="2" class="fecha"><div align="center">
      <script languaje="JavaScript">Mostrar_Fecha()</script>
    </div></td>
  </tr>
  

  <!--<tr bgcolor="#FFCC99">
    <td width="355"><div align="center"><span class="Estilo51">Nombre : </span></div></td>
    <td width="300"><input name="nom" type="text" id="nom" size="50" maxlength="50"></td>
  </tr>-->
  <!--<tr bgcolor="#FFCC99">
    <td colspan="2"><div align="center"><span class="Estilo51">-->
      <!--<input name="busqueda" id="busqueda" type="submit" class="boton11" value="Titular">-->
	  <!--<input name="busquedar" id="busquedar" type="submit" class="boton11" value="Beneficiario">-->
    <!--</span></div></td>
  </tr>-->
   <tr bgcolor="#FFCC99">
    		<td align="center" >
	 		 <p><span class="Estilo51">C&eacute;dula o Codigo:</span></p>
		  </td>
	  <td>
        <input name="cedula2" type="text" class="campo1" id="cedula2" value="" size="15" maxlength="15">
 </td>
 </tr>
 <tr bgcolor="#FFCC99">
    <td colspan="2"><div align="center"><span class="Estilo51">
      <input name="consultar" id="consultar" type="submit" class="boton11" value="Consultar">
    </span></div></td>
  </tr>
  <tr bgcolor="#FFCC99">
    <td colspan="2"><div align="center" class="Estilo51">
      <input name="menu2" type="button" class="Estilo50" id="menu2" onClick="window.location.href='menu_creditos_serviasjudinet.php'" value="IR AL MENU">
    </div></td>
  </tr>
</table>
</fieldset></td>
  </tr>
</table>

</form>
</body>
</html>

<?php

   
if(isset($_POST["busqueda"]))
{
	require_once("Conectarse.php");
	echo "<form name='form' action='' method='post'>";
    require_once("mainfile.php");
    include ("config.php");
    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 bgcolor='#FFFFCC'><div align='center'><span class='texto'>CEDULA</span></div></TD>
				<TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>NOMBRE</span></div></TD>	
				<TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>N° CONTRATO</span></div></TD>
                <TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>TIPO </span></div></TD>
				<TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>TIPO AFILIADO</span></div></TD>
				<TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>VIGENTE/HISTORICO </span></div></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 bgcolor='#ECE9D8'><div align='center' class='lista'><input type='button' value=$cedula name='cedu' class=est_cont1 onClick =window.location.href='cartera_consul_bene_usuario.php?ced2=$cedula&numcon=$numcon'></a></span></div></TD>
                <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$nombres."</span></div></td>
				<td bgcolor='#C5D6FC'><div align='center' class='lista'>".$numcon."</span></div></td>
				<td bgcolor='#C5D6FC'><div align='center' class='lista'>".$tipo."</span></div></td>
				<td bgcolor='#C5D6FC'><div align='center' class='lista'>".$afili."</span></div></td>
				<td bgcolor='#C5D6FC'><div align='center' class='lista'>".$esta."</span></div></td>");              								   				}
				else
				{
					printf("<tr>
                               
					<TD bgcolor='#ECE9D8'><div align='center' class='lista'><input type='button' value=$cedula name='cedu' class=est_cont1 onClick =window.location.href='credito_formulario_registro.php?ced2=$cedula&numcon=$numcon'></a></span></div></TD>
                    <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$nombres."</span></div></td>
					<td bgcolor='#C5D6FC'><div align='center' class='lista'>".$numcon."</span></div></td>
					<td bgcolor='#C5D6FC'><div align='center' class='lista'>".$tipo."</span></div></td>
					<td bgcolor='#C5D6FC'><div align='center' class='lista'>".$afili."</span></div></td>
					<td bgcolor='#C5D6FC'><div align='center' class='lista'>".$esta."</span></div></td>");  
				}             								   
         	}
			echo "</table>";		  
      	}
		}
  	}
    echo "</form>";
}


   /*
if(isset($_POST["busquedar"]))
{
	require_once("Conectarse.php");	
	echo "<form name='form' action='' method='post'>";
    require_once("mainfile.php");
    include ("config.php");
    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 bgcolor='#FFFFCC'><div align='center'><span class='texto'>CEDULA</span></div></TD>
			<TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>NOMBRE</span></div></TD>	
			<TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>N° CONTRATO</span></div></TD>
            <TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>TIPO </span></div></TD>
			<TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>TIPO AFILIADO</span></div></TD>
			<TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>VIGENTE/HISTORICO </span></div></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 bgcolor='#ECE9D8'><div align='center' class='lista'><input type='button' value=$cedula name='cedu' class=est_cont1 onClick =window.location.href='cartera_consul_bene_usuario.php?ced2=$cedula&numcon=$numcon'></a></span></div></TD>
                <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$nombres."</span></div></td>
				<td bgcolor='#C5D6FC'><div align='center' class='lista'>".$numcon."</span></div></td>
				<td bgcolor='#C5D6FC'><div align='center' class='lista'>".$tipo."</span></div></td>
				<td bgcolor='#C5D6FC'><div align='center' class='lista'>".$afili."</span></div></td>
				<td bgcolor='#C5D6FC'><div align='center' class='lista'>".$esta."</span></div></td>");              								   				}
				else
				{
					printf("<tr>
                               
				   	<TD bgcolor='#ECE9D8'><div align='center' class='lista'><input type='button' value=$cedula name='cedu' class=est_cont1 onClick =window.location.href='cartera_consulta_titu_usuario.php?ced2=$cedula&numcon=$numcon'></a></span></div></TD>
                	<td bgcolor='#C5D6FC'><div align='center' class='lista'>".$nombres."</span></div></td>
					<td bgcolor='#C5D6FC'><div align='center' class='lista'>".$numcon."</span></div></td>
					<td bgcolor='#C5D6FC'><div align='center' class='lista'>".$tipo."</span></div></td>
					<td bgcolor='#C5D6FC'><div align='center' class='lista'>".$afili."</span></div></td>
					<td bgcolor='#C5D6FC'><div align='center' class='lista'>".$esta."</span></div></td>");  
				}             								   
          	}
			                       
			echo "</table>";		  
           }
	 	}
  	}
    echo "</form>";
}
*/

 
if(isset($_POST["consultar"]))
{
	require_once("Conectarse.php");
	echo "<form name='form' action='' method='post'>";
    require_once("mainfile.php");
    include ("config.php");
    global $dbi;
	
	
	$consultaredimirbonos = mysql_query('SELECT cedula FROM redimir_bonos where cedula = "'.$_POST["cedula2"].'" ');
	if (!$consultaredimirbonos) {
		die('Invalid query 2: ' . mysql_error());
	}
	list($cedula_redimir_bonos) = mysql_fetch_row($consultaredimirbonos);
	
	
	if ((mysql_num_rows($consultaredimirbonos)==0)) 
	{	 
    	/*echo "<TABLE width='900' border='0' align='center' cellpadding='0' cellspacing='1'>
        <TR>
        <TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>CEDULA</span></div></TD>
		<TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>NOMBRE</span></div></TD>	
		<TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>N° CONTRATO</span></div></TD>
        <TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>TIPO </span></div></TD>
		<TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>TIPO AFILIADO</span></div></TD>
		<TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>VIGENTE/HISTORICO </span></div></TD>";*/		  
                           							                  
  		/*while(list($cedula_redimir_bonos) = mysql_fetch_row($consultaredimirbonos)) 
        {*/
		
		if($cedula_redimir_bonos == 0)
		{
			$control = mysql_query('SELECT cedula, nombre, numerocontrato, tipocontrato, tipo_afiliado, estado FROM cartera_serviasjudinet  WHERE cedula =  "' . $_POST["cedula2"]  . '" || codigo_militar = "' . $_POST["cedula2"]  . '" and estado = 1  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 bgcolor='#FFFFCC'><div align='center'><span class='texto'>CEDULA</span></div></TD>
				<TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>NOMBRE</span></div></TD>	
				<TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>N° CONTRATO</span></div></TD>
        		<TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>TIPO </span></div></TD>
				<TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>TIPO AFILIADO</span></div></TD>
				<TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>VIGENTE/HISTORICO </span></div></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";
							}
								//<TD bgcolor='#ECE9D8'><div align='center' class='lista'><input type='button' value=$cedula name='cedu' class=est_cont1 onClick =window.location.href='cartera_consul_bene_usuario.php?ced2=$cedula&numcon=$numcon'></a></span></div></TD>			  
							printf("<tr>
											 
							
							<td bgcolor='#C5D6FC'><div align='center' class='lista'>".$cedula."</span></div></td>
							<td bgcolor='#C5D6FC'><div align='center' class='lista'>".$nombres."</span></div></td>
							<td bgcolor='#C5D6FC'><div align='center' class='lista'>".$numcon."</span></div></td>
							<td bgcolor='#C5D6FC'><div align='center' class='lista'>".$tipo."</span></div></td>
							<td bgcolor='#C5D6FC'><div align='center' class='lista'>".$afili."</span></div></td>
							<td bgcolor='#C5D6FC'><div align='center' class='lista'>".$esta."</span></div></td>");              								   			}*/
					if ($afili == 'TITULAR')
					{
			 			printf("<tr>
                                 
						<TD bgcolor='#ECE9D8'><div align='center' class='lista'><input type='button' value=$cedula name='cedu' class=est_cont1 onClick =window.location.href='credito_formulario_registro_ingreso.php?ced2=$cedula&numcon=$numcon'></a></span></div></TD>
						<td bgcolor='#C5D6FC'><div align='center' class='lista'>".$nombres."</span></div></td>
						<td bgcolor='#C5D6FC'><div align='center' class='lista'>".$numcon."</span></div></td>
						<td bgcolor='#C5D6FC'><div align='center' class='lista'>".$tipo."</span></div></td>
						<td bgcolor='#C5D6FC'><div align='center' class='lista'>".$afili."</span></div></td>
						<td bgcolor='#C5D6FC'><div align='center' class='lista'>".$esta."</span></div></td>");  
					}            								   
    			}
			}
		}
		//}
		echo "</table>";		  
   	}
	else{echo "<script>alert('YA TIENE BONOS INSCRITOS');</script>";}
	/*					
$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 bgcolor='#FFFFCC'><div align='center'><span class='texto'>CEDULA</span></div></TD>
				<TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>NOMBRE</span></div></TD>	
				<TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>N° CONTRATO</span></div></TD>
                <TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>TIPO </span></div></TD>
				<TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>TIPO AFILIADO</span></div></TD>
				<TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>VIGENTE/HISTORICO </span></div></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 bgcolor='#ECE9D8'><div align='center' class='lista'><input type='button' value=$cedula name='cedu' class=est_cont1 onClick =window.location.href='cartera_consul_bene_usuario.php?ced2=$cedula&numcon=$numcon'></a></span></div></TD>
                                   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$nombres."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$numcon."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$tipo."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$afili."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$esta."</span></div></td>");              								   								}
								else
								{
								  printf("<tr>
                                 
								   	<TD bgcolor='#ECE9D8'><div align='center' class='lista'><input type='button' value=$cedula name='cedu' class=est_cont1 onClick =window.location.href='cartera_consulta_titu_usuario.php?ced2=$cedula&numcon=$numcon'></a></span></div></TD>
                                   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$nombres."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$numcon."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$tipo."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$afili."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$esta."</span></div></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 bgcolor='#FFFFCC'><div align='center'><span class='texto'>CEDULA</span></div></TD>
							  <TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>NOMBRE</span></div></TD>
							  <TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>APELLIDOS</span></div></TD>	
							   <TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>N° CONTRATO</span></div></TD>
							  <TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>TIPO CONTRATO</span></div></TD>
							   <TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>EMPRESA</span></div></TD>
                               <TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>TIPO AFILIADO</span></div></TD>
							  <TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>VIGENTE/HISTORICO </span></div></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 bgcolor='#C5D6FC'><div align='center' class='lista'>".$cedula."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$cedula."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$nombres."</span></div></td>
                                   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$apellidos."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$numcon."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$tipocontra."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$tipo."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$afili."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$esta."</span></div></td>");              								   								}
								else
								{
								  printf("<tr>
                                 
								   	
                                   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$cedula."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$nombres."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$apellidos."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$numcon."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$tipo."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$tipocontra."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$afili."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$esta."</span></div></td>");  
								}            								   
                               }
								   echo "</table>";		  
                        }
						
		       
	*/
	
	
	

echo "</form>";

	

}

 
   
?>
@ Telegram