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
Upload Files
File: /home/asjudine/public_html/consulta_informacion_documentacion.php
<!--<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>
<head>
<title>Consulta Documentos Aportados</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: 14px; 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(ELEMENTOS/gri06.jpg );
}
.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">
<center> <img src="ELEMENTOS\CABEZOTE SERVIASJUDINET.jpg" WIDTH=60% > </center>
<br>
<table width="570" border="6" cellspacing="0" cellpadding="0" align="center"> 
  <tr>
    <td><fieldset><table width="568" border="5" align="center" cellpadding="2" cellspacing="2" bgcolor="#000000" >
  <tr bgcolor="#2E7068">
    <td colspan="2" bgcolor="#2E7068" class="titulos" style="color:#FFFFFF"><div align="center"> CONSULTA DOCUMENTOS APORTADOS</div></td>
  </tr>
  <tr bgcolor="#EFEFEF">
    <td height="22" colspan="2" bgcolor="#FFFFFF" class="fecha"><div align="center">
      <script languaje="JavaScript">Mostrar_Fecha()</script>
    </div></td>
  </tr>
 
   <tr bgcolor="#FFCC99">
    		<td align="center" bgcolor="#EFEFEF" >
	 		 <p><span class="fecha">C&eacute;dula o Codigo:</span></p>
		  </td>
	  <td bgcolor="#EFEFEF">
        <input name="cedula2" type="text" class="campo1" id="cedula2" value="" size="15" maxlength="15">
 </td>
 </tr>
 <tr bgcolor="#FFCC99">
    <td colspan="2" bgcolor="#EFEFEF"><div align="center"><span class="Estilo51">
      <input name="consultar" id="consultar" type="submit" class="Estilo51"  value="Consultar">
    </span></div></td>
  </tr>
  <tr bgcolor="#FFCC99">
    <td colspan="2" bgcolor="#EFEFEF"><div align="center" class="Estilo51">
      <input name="menu2" type="button" class="Estilo50" id="menu2" onClick="window.location.href='recepcion_documentos.php'" value="IR AL MENU">
    </div></td>
  </tr>
</table>
</fieldset></td>
  </tr>
</table>

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

<?php
 /*
if(isset($_POST["consultar"]))
{

require_once("Conectarse.php");
echo "<form name='form' action='' method='post'>";
require_once("mainfile.php");
include ("config.php");
global $dbi;


$control = mysql_query('SELECT cedula,nombre,tipo_proceso FROM informacion_documentos_subsidio WHERE cedula = "'.$_POST["cedula2"].'" order by nombre ');
		  if (!$control) {
				die('Invalid query 2: ' . mysql_error());
			} 
		
                     
                   echo "<TABLE width='900' border='3' align='center' cellpadding='1' cellspacing='1' color:#00000'>
           <TR>
           <TD bgcolor='#2E7068'><div align='center' style='color:#FFFFFF'><span>CEDULA</span></div></TD>
		   <TD bgcolor='#2E7068'><div align='center' style='color:#FFFFFF'>NOMBRE</span></div></TD>
		   <TD bgcolor='#2E7068'><div align='center' style='color:#FFFFFF'>SUBSIDIO FAMILIAR</span></div></TD>
		   <TD bgcolor='#2E7068'><div align='center' style='color:#FFFFFF'>I.P.C.</span></div></TD>
		   <TD bgcolor='#2E7068'><div align='center' style='color:#FFFFFF'>VEINTE POR CIENTO</span></div></TD>	           <TD bgcolor='#2E7068'><div align='center' style='color:#FFFFFF'>BONIFICACION JUDICIAL</span></div></TD>
		   <TD bgcolor='#2E7068'><div align='center' style='color:#FFFFFF'>BONO PENSIONAL</span></div></TD>
		   <TD bgcolor='#2E7068'><div align='center' style='color:#FFFFFF'>TRADICIONAL</span></div></TD>";		  
                           							  
                        
  while(list($cedula,$nombres,$tipo_proceso) = mysql_fetch_row($control)) 
                              {  
                 
if ($tipo_proceso=='SUBSIDIO FAMILIAR' )
{
	$numproceso='1';
	
	}		
	
///////////////////////////////////////////////////////////////


$controla = mysql_query('SELECT numerocontrato,tipocontrato,tipo_proceso FROM cartera_serviasjudinet WHERE cedula = "'.$cedula.'" AND tipo_proceso = "'.$tipo_proceso.'"  order by nombre ');
		  if (!$controla) {
				die('Invalid query 2: ' . mysql_error());
			} 
		 
                        
 while( list($numcon,$tipo,$tipo_proceso) = mysql_fetch_row($controla))
                            
///////////////////////////////////////////////////////////////	
	


   printf("<tr>
                                 
   			 			<td bgcolor='#EFEFEF'><div align='center' class='lista'>".$cedula."</span></div></td>
			            <td bgcolor='#EFEFEF'><div align='center' class='lista'>".$nombres."</span></div></td>
							  
							  <td bgcolor='#EFEFEF'><div align='center' class='Estilo21'><input type='button' value=SUBSIDIO_FAMILIAR name='id' class=Estilo21 onClick =	window.open('consulta_documentos_aportados_subsidio.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></span></div></td>
							  
							  <td bgcolor='#EFEFEF'><div align='center' class='Estilo21'><input type='button' value=I.P.C. name='id' class=Estilo21 onClick =	window.open('consulta_documentos_aportados_ipc.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></span></div></td>
							  
							  
							  <td bgcolor='#EFEFEF'><div align='center' class='Estilo21'><input type='button' value='VEINTE POR CIENTO' name='id' class=Estilo21 onClick =	window.open('consulta_documentos_aportados_veinte.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></span></div></td>
							  
							  <td bgcolor='#EFEFEF'><div align='center' class='Estilo21'><input type='button' value='BONIFICACION JUDICIAL' name='id' class=Estilo21 onClick =	window.open('consulta_documentos_aportados_bonificacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></span></div></td>
							  
							   <td bgcolor='#EFEFEF'><div align='center' class='Estilo21'><input type='button' value='BONO PENSIONAL' name='id' class=Estilo21 onClick =	window.open('consulta_documentos_aportados_bono.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></span></div></td>
							   
							   <td bgcolor='#EFEFEF'><div align='center' class='Estilo21'><input type='button' value='TRADICIONAL' name='id' class=Estilo21 onClick =	window.open('consulta_documentos_aportados_tradicional.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></span></div></td>");                   					
							  		} 
					
				
				
		//////////////////////////
		
		$control2 = mysql_query('SELECT cedula,nombre,tipo_proceso FROM informacion_documentos_ipc WHERE cedula = "'.$_POST["cedula2"].'" order by nombre ');
		  if (!$control2) {
				die('Invalid query 2: ' . mysql_error());
			} 
		
                                              							  
                        
  while(list($cedula,$nombres,$tipo_proceso2) = mysql_fetch_row($control2)) 
                              {  
                 
if ($tipo_proceso2=='I.P.C.' )
{
	$numproceso='2';
	
	}		


	
///////////////////////////////////////////////////////////////


$controla2 = mysql_query('SELECT numerocontrato,tipocontrato,tipo_proceso FROM cartera_serviasjudinet WHERE cedula = "'.$cedula.'" AND tipo_proceso = "I.P.C."  order by nombre ');
		  if (!$controla2) {
				die('Invalid query 2: ' . mysql_error());
			} 
		 
                        
  list($numcon,$tipo,$tipo_proceso2) = mysql_fetch_row($controla2); 
                            
///////////////////////////////////////////////////////////////	


   printf("<tr>
                                 
   			 
			                  <td bgcolor='#EFEFEF'><div align='center' class='lista'>".$cedula."</span></div></td>
			  				  <td bgcolor='#EFEFEF'><div align='center' class='lista'>".$nombres."</span></div></td>
					
				 <td bgcolor='#EFEFEF'><div align='center' class='Estilo21'><input type='button' value=SUBSIDIO_FAMILIAR name='id' class=Estilo21 onClick =	window.open('consulta_documentos_aportados_subsidio.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></span></div></td>			 
							 
							  <td bgcolor='#EFEFEF'><div align='center' class='Estilo21'><input type='button' value=I.P.C. name='id' class=Estilo21 onClick =	window.open('consulta_documentos_aportados_ipc.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></span></div></td>
						
						 <td bgcolor='#EFEFEF'><div align='center' class='Estilo21'><input type='button' value='VEINTE POR CIENTO' name='id' class=Estilo21 onClick =	window.open('consulta_documentos_aportados_veinte.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></span></div></td>
						 
						 <td bgcolor='#EFEFEF'><div align='center' class='Estilo21'><input type='button' value='BONIFICACION JUDICIAL' name='id' class=Estilo21 onClick =	window.open('consulta_documentos_aportados_bonificacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></span></div></td>
						 
						  <td bgcolor='#EFEFEF'><div align='center' class='Estilo21'><input type='button' value='BONO PENSIONAL' name='id' class=Estilo21 onClick =	window.open('consulta_documentos_aportados_bono.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></span></div></td>
						  
						  <td bgcolor='#EFEFEF'><div align='center' class='Estilo21'><input type='button' value='TRADICIONAL' name='id' class=Estilo21 onClick =	window.open('consulta_documentos_aportados_tradicional.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></span></div></td>");             					
							  		} 
					
				
		//////////////////////////		
				
				
			//////////////////////////
		
$control3 = mysql_query('SELECT cedula,nombre,tipo_proceso FROM informacion_documentos_veinte WHERE cedula = "'.$_POST["cedula2"].'" order by nombre ');
		  if (!$control3) {
				die('Invalid query 2: ' . mysql_error());
			} 
		
                                              							  
                        
  while(list($cedula,$nombres,$tipo_proceso3) = mysql_fetch_row($control3)) 
                              {  
                 
if ($tipo_proceso3=='VEINTE POR CIENTO' )
{
	$numproceso='3';
	
	}		


	
///////////////////////////////////////////////////////////////


$controla3 = mysql_query('SELECT numerocontrato,tipocontrato,tipo_proceso FROM cartera_serviasjudinet WHERE cedula = "'.$cedula.'" AND tipo_proceso = "VEINTE POR CIENTO" order by nombre ');
		  if (!$controla3) {
				die('Invalid query 2: ' . mysql_error());
			} 
		 
                        
  list($numcon,$tipo,$tipo_proceso3) = mysql_fetch_row($controla3); 
                            
///////////////////////////////////////////////////////////////	


   printf("<tr>
                                 
   			 
			  				<td bgcolor='#EFEFEF'><div align='center' class='lista'>".$cedula."</span></div></td>
			                <td bgcolor='#EFEFEF'><div align='center' class='lista'>".$nombres."</span></div></td>
							<td bgcolor='#EFEFEF'><div align='center' class='Estilo21'><input type='button' value=SUBSIDIO_FAMILIAR name='id' class=Estilo21 onClick =	window.open('consulta_documentos_aportados_subsidio.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></span></div></td>			 
							 
							  <td bgcolor='#EFEFEF'><div align='center' class='Estilo21'><input type='button' value=I.P.C. name='id' class=Estilo21 onClick =	window.open('consulta_documentos_aportados_ipc.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></span></div></td>
						
						 <td bgcolor='#EFEFEF'><div align='center' class='Estilo21'><input type='button' value='VEINTE POR CIENTO' name='id' class=Estilo21 onClick =	window.open('consulta_documentos_aportados_veinte.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></span></div></td>
						 
						 <td bgcolor='#EFEFEF'><div align='center' class='Estilo21'><input type='button' value='BONIFICACION JUDICIAL' name='id' class=Estilo21 onClick =	window.open('consulta_documentos_aportados_bonificacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></span></div></td>
						  
						  <td bgcolor='#EFEFEF'><div align='center' class='Estilo21'><input type='button' value='BONO PENSIONAL' name='id' class=Estilo21 onClick =	window.open('consulta_documentos_aportados_bono.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></span></div></td>
						  
						  <td bgcolor='#EFEFEF'><div align='center' class='Estilo21'><input type='button' value='TRADICIONAL' name='id' class=Estilo21 onClick =	window.open('consulta_documentos_aportados_tradicional.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></span></div></td>");               					
							  		} 
				
		//////////////////////////		BONIFICACION JUDICIAL
		
		//////////////////////////
		
$control4 = mysql_query('SELECT cedula,nombre,tipo_proceso FROM informacion_documentos_bonificacion WHERE cedula = "'.$_POST["cedula2"].'" order by nombre ');
		  if (!$control4) {
				die('Invalid query 4: ' . mysql_error());
			} 
		
                                              							  
                        
  while(list($cedula,$nombres,$tipo_proceso4) = mysql_fetch_row($control4)) 
                              {  
                 
if ($tipo_proceso4=='BONIFICACION JUDICIAL' )
{
	$numproceso='4';
	
	}		


	
///////////////////////////////////////////////////////////////


$controla4 = mysql_query('SELECT numerocontrato,tipocontrato,tipo_proceso FROM cartera_serviasjudinet WHERE cedula = "'.$cedula.'" AND tipo_proceso = "BONIFICACION JUDICIAL" order by nombre ');
		  if (!$controla4) {
				die('Invalid query 2: ' . mysql_error());
			} 
		 
                        
  list($numcon,$tipo,$tipo_proceso4) = mysql_fetch_row($controla4); 
                            
///////////////////////////////////////////////////////////////	


   printf("<tr>
                                 
   			 
			 <td bgcolor='#EFEFEF'><div align='center' class='lista'>".$cedula."</span></div></td>
			 <td bgcolor='#EFEFEF'><div align='center' class='lista'>".$nombres."</span></div></td>
							<td bgcolor='#EFEFEF'><div align='center' class='Estilo21'><input type='button' value=SUBSIDIO_FAMILIAR name='id' class=Estilo21 onClick =	window.open('consulta_documentos_aportados_subsidio.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></span></div></td>			 
							 
							  <td bgcolor='#EFEFEF'><div align='center' class='Estilo21'><input type='button' value=I.P.C. name='id' class=Estilo21 onClick =	window.open('consulta_documentos_aportados_ipc.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></span></div></td>
						
						 <td bgcolor='#EFEFEF'><div align='center' class='Estilo21'><input type='button' value='VEINTE POR CIENTO' name='id' class=Estilo21 onClick =	window.open('consulta_documentos_aportados_veinte.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></span></div></td>
						 
						  <td bgcolor='#EFEFEF'><div align='center' class='Estilo21'><input type='button' value='BONIFICACION JUDICIAL' name='id' class=Estilo21 onClick =	window.open('consulta_documentos_aportados_bonificacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></span></div></td>
						   <td bgcolor='#EFEFEF'><div align='center' class='Estilo21'><input type='button' value='BONO PENSIONAL' name='id' class=Estilo21 onClick =	window.open('consulta_documentos_aportados_bono.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></span></div></td>
						   
						   <td bgcolor='#EFEFEF'><div align='center' class='Estilo21'><input type='button' value='TRADICIONAL' name='id' class=Estilo21 onClick =	window.open('consulta_documentos_aportados_tradicional.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></span></div></td>");              					
							  		} 
					
				
		//////////////////////////		

				//////////////////////////		BONO PENCIONAL
		
		//////////////////////////
		
$control4 = mysql_query('SELECT cedula,nombre,tipo_proceso FROM informacion_documentos_bono WHERE cedula = "'.$_POST["cedula2"].'" order by nombre ');
		  if (!$control4) {
				die('Invalid query 4: ' . mysql_error());
			} 
		
                                              							  
                        
  while(list($cedula,$nombres,$tipo_proceso4) = mysql_fetch_row($control4)) 
                              {  
                 
if ($tipo_proceso5=='BONO PENSIONAL' )
{
	$numproceso='5';
	
	}		


	
///////////////////////////////////////////////////////////////


$controla4 = mysql_query('SELECT numerocontrato,tipocontrato,tipo_proceso FROM cartera_serviasjudinet WHERE cedula = "'.$cedula.'" AND tipo_proceso = "BONO PENSIONAL" order by nombre ');
		  if (!$controla4) {
				die('Invalid query 2: ' . mysql_error());
			} 
		 
                        
  list($numcon,$tipo,$tipo_proceso4) = mysql_fetch_row($controla4); 
                            
///////////////////////////////////////////////////////////////	


   printf("<tr>
                                 
   			 
			                 <td bgcolor='#EFEFEF'><div align='center' class='lista'>".$cedula."</span></div></td>
			  				 <td bgcolor='#EFEFEF'><div align='center' class='lista'>".$nombres."</span></div></td>
							<td bgcolor='#EFEFEF'><div align='center' class='Estilo21'><input type='button' value=SUBSIDIO_FAMILIAR name='id' class=Estilo21 onClick =	window.open('consulta_documentos_aportados_subsidio.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></span></div></td>			 
							 
							  <td bgcolor='#EFEFEF'><div align='center' class='Estilo21'><input type='button' value=I.P.C. name='id' class=Estilo21 onClick =	window.open('consulta_documentos_aportados_ipc.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></span></div></td>
						
						 <td bgcolor='#EFEFEF'><div align='center' class='Estilo21'><input type='button' value='VEINTE POR CIENTO' name='id' class=Estilo21 onClick =	window.open('consulta_documentos_aportados_veinte.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></span></div></td>
						 
						 <td bgcolor='#EFEFEF'><div align='center' class='Estilo21'><input type='button' value='BONIFICACION JUDICIAL' name='id' class=Estilo21 onClick =	window.open('consulta_documentos_aportados_bonificacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></span></div></td>
						 
						 <td bgcolor='#EFEFEF'><div align='center' class='Estilo21'><input type='button' value='BONO PENSIONAL' name='id' class=Estilo21 onClick =	window.open('consulta_documentos_aportados_bono.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></span></div></td>
						 
						 <td bgcolor='#EFEFEF'><div align='center' class='Estilo21'><input type='button' value='TRADICIONAL' name='id' class=Estilo21 onClick =	window.open('consulta_documentos_aportados_tradicional.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></span></div></td>");                 					 
							  		} 
					
				
		//////////////////////////	
		
		
							//////////////////////////		TRADICIONAL
		
		//////////////////////////
		
$control4 = mysql_query('SELECT cedula,nombre,tipo_proceso FROM informacion_documentos_tradicional WHERE cedula = "'.$_POST["cedula2"].'" order by nombre ');
		  if (!$control4) {
				die('Invalid query 4: ' . mysql_error());
			} 
		
                                              							  
                        
  while(list($cedula,$nombres,$tipo_proceso4) = mysql_fetch_row($control4)) 
                              {  
                 
if ($tipo_proceso5=='TRADICIONAL' )
{
	$numproceso='5';
	
	}		


	
///////////////////////////////////////////////////////////////


$controla4 = mysql_query('SELECT numerocontrato,tipocontrato,tipo_proceso FROM cartera_serviasjudinet WHERE cedula = "'.$cedula.'" AND tipo_proceso = "TRADICIONAL" order by nombre ');
		  if (!$controla4) {
				die('Invalid query 2: ' . mysql_error());
			} 
		 
                        
  list($numcon,$tipo,$tipo_proceso4) = mysql_fetch_row($controla4); 
                            
///////////////////////////////////////////////////////////////	


   printf("<tr>
                                 
   			 
			                <td bgcolor='#EFEFEF'><div align='center' class='lista'>".$cedula."</span></div></td>
			  				<td bgcolor='#EFEFEF'><div align='center' class='lista'>".$nombres."</span></div></td>
							<td bgcolor='#EFEFEF'><div align='center' class='Estilo21'><input type='button' value=SUBSIDIO_FAMILIAR name='id' class=Estilo21 onClick =	window.open('consulta_documentos_aportados_subsidio.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></span></div></td>			 
							 
							  <td bgcolor='#EFEFEF'><div align='center' class='Estilo21'><input type='button' value=I.P.C. name='id' class=Estilo21 onClick =	window.open('consulta_documentos_aportados_ipc.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></span></div></td>
						
						 <td bgcolor='#EFEFEF'><div align='center' class='Estilo21'><input type='button' value='VEINTE POR CIENTO' name='id' class=Estilo21 onClick =	window.open('consulta_documentos_aportados_veinte.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></span></div></td>
						 
						 <td bgcolor='#EFEFEF'><div align='center' class='Estilo21'><input type='button' value='BONIFICACION JUDICIAL' name='id' class=Estilo21 onClick =	window.open('consulta_documentos_aportados_bonificacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></span></div></td>
						 
						 <td bgcolor='#EFEFEF'><div align='center' class='Estilo21'><input type='button' value='BONO PENSIONAL' name='id' class=Estilo21 onClick =	window.open('consulta_documentos_aportados_bono.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></span></div></td>
						 
						 <td bgcolor='#EFEFEF'><div align='center' class='Estilo21'><input type='button' value='TRADICIONAL' name='id' class=Estilo21 onClick =	window.open('consulta_documentos_aportados_tradicional.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></span></div></td> ");                 					 
							  		} 
					
				
		//////////////////////////	

				
				echo "</table>";		  


echo "</form>";

}*/




?>
<!DOCTYPE HTML>

<html>
<head>
<title>Consulta Documentos Aportados</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">
    
<style type="text/css">
	*{margin: 0;padding: 0;}
    body{background-color:#EAEAEA;font-family:Geneva, Arial, Helvetica, sans-serif;}
    .header {background-color: #B7271F; text-align: center;}
    .cerrarsesion{width: auto;background-color: #DBD8C9;color: #000;font-size: 13px;position:absolute;top: 15px;right:10px;z-index:0;padding: 10px;border-radius: 10px;cursor: pointer;}
    .cerrarsesion:hover{background-color: #ffffff;color: #000;}
    .titulo{width: 100%;text-align: center;background-color: #dbd8c9;color: #b20606;padding: 6px 0;font-size: 18px;}
    table{margin: 0 auto;border: 2px solid #bebebe; text-align: center;}
    .divirmenu{text-align: center;}
    .irmenu{width: 150px;background-color: #1c4fa0;color: #fff; padding: 4px;border-radius: 6px;}
    .irmenu:hover{background-color: #67a0d9; color: #000;}
    
    .fecha{background-color: #d6e08b; padding: 2px;color: #000;font-size: 15px; text-align: center;}
    td{border: #969696 solid 1px;}
    .tdizq{background-color: #EEE; padding: 1px 4px;color: #00135F;font-size: 14px;font-weight: 600; text-align: left;}
    .tdcen{background-color: #EEE; padding: 1px 4px;color: #00135F;font-size: 14px;font-weight: 600; text-align: center;}
    .tdder{background-color: #EEE; padding: 1px 4px;color: #00135F;font-size: 14px;font-weight: 600; text-align: right;}
	.exp{color:#8A0000; font-size:12px;}
    .boton1{width:150px;background-color: #ffffff;color: #000;padding: 2px;border:2px solid #580000;border-radius:4px;}
    .boton1:hover{background-color: #6f0000;color: #fff;cursor: pointer;}
    input[type=text]{border-radius: 5px; padding: 3px;background-color: #FFFEF4;}
	
	.tdtitulo{background-color: #e3dec0; color: #b20606; padding: 1px; text-align: center; font-size: 12px; font-weight: 800}
    .tdfull, tdproceso{background-color: #fff; color: #000000; padding: 0.5px; text-align: center; font-size: 12px;}
	
	.tdprocesos{padding:5px; font-weight:bold; font-size:14px;}
	
	.botonnew{background-color: #E5E5E5;color: #000; font-size:12px; height:28px; border: solid 1px #D91C20; padding:2px;}
    .botonnew:hover{background-color: #B14346;color: #FFF;}
    
</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">
<div class="header">
    <img src="ELEMENTS/bannerInterasjudinet.png" alt="" width=" 700" height="70">
</div>
<h3 class="titulo">CONSULTA DOCUMENTOS APORTADOS</h3>

<form name="formulario" action="" method="post">

<table width="570" border="6" cellspacing="0" cellpadding="0" align="center"> 
  <tr>
    <td><fieldset><table width="568" border="5" align="center" cellpadding="2" cellspacing="2">
  <!--<tr bgcolor="#2E7068">
    <td colspan="2" bgcolor="#2E7068" class="titulos" style="color:#FFFFFF"><div align="center"> CONSULTA DOCUMENTOS APORTADOS</div></td>
  </tr>-->
  <tr bgcolor="#EFEFEF">
    <td height="22" colspan="2" bgcolor="#FFFFFF" class="fecha"><div align="center">
      <script languaje="JavaScript">Mostrar_Fecha()</script>
    </div></td>
</tr>
 
<tr>
	<td class="tdcen">C&eacute;dula o Codigo:</td>
	<td class="tdcen"><input name="cedula2" type="text" class="campo1" id="cedula2" value="" size="15" maxlength="15"></td>
</tr>


<tr>
	<td class="tdcen" colspan="2"><input name="consultar" id="consultar" type="submit" class="boton1"  value="Consultar"></td>
</tr>

<tr>
	<td class="tdcen" colspan="2"><input name="menu2" type="button" class="irmenu" id="menu2" onClick="window.location.href='recepcion_documentos.php'" value="IR AL MENU"></td>
  </tr>
</table>
</fieldset></td>
  </tr>
</table>

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

<?php
 
if(isset($_POST["consultar"]))
{
	require_once("Conectarse.php");
	echo "<form name='form' action='' method='post'>";
	global $dbi;
	
	$consulta_cartera = mysql_query('SELECT tipo_proceso, tipo_proceso2, tipo_proceso3 FROM cartera_serviasjudinet WHERE cedula = "'.$_POST["cedula2"].'" ' );
	list($tipopro1, $tipopro2, $tipopro3) = mysql_fetch_row($consulta_cartera);
	
	echo "<TABLE width='1100' border='3' align='center' cellpadding='1' cellspacing='1' color:#00000'>
	<tr>
	<td colspan='3' class='tdtitulo'>PROCESOS QUE SE ADELANTAN</td>
	</tr>
	<tr>
	<td class='tdfull tdprocesos'>".$tipopro1."</td>
	<td class='tdfull tdprocesos'>".$tipopro2."</td>
	<td class='tdfull tdprocesos'>".$tipopro3."</td>
	</tr>
	";


	$control = mysql_query('SELECT cedula,nombre,tipo_proceso FROM informacion_documentos_subsidio WHERE cedula = "'.$_POST["cedula2"].'" order by nombre ');
	if (!$control) {
		die('Invalid query 2: ' . mysql_error());
	} 
		
                     
    echo "<TABLE width='1100' border='3' align='center' cellpadding='1' cellspacing='1' color:#00000'>
    <TR>
    <TD class='tdtitulo'><span>CEDULA</TD>
	<TD class='tdtitulo' width='280'>NOMBRE</TD>
	<TD class='tdtitulo'>SUBSIDIO FAMILIAR</TD>
	<TD class='tdtitulo'>I.P.C.</TD>
	<TD class='tdtitulo'>VEINTE POR CIENTO</TD>
	<TD class='tdtitulo'>BONIFICACION JUDICIAL</TD>
	<TD class='tdtitulo'>BONO PENSIONAL</TD>
	<TD class='tdtitulo'>TRADICIONAL</TD>
	<TD class='tdtitulo'>SUBSIDIO FAMILIAR SOLDADOS</TD>
	<TD class='tdtitulo'>RELIQUIDACION PENSION</TD>
	<TD class='tdtitulo'>CESANTIAS RETROACTIVAS</TD>
	<TD class='tdtitulo'>SIN PENSION 15-20</TD>
	<TD class='tdtitulo'>GENERICO</TD>
	<TD class='tdtitulo'>RELIQUIDACION RETIRO</TD>
	";		  
                           							  
                        
  	while(list($cedula,$nombres,$tipo_proceso) = mysql_fetch_row($control)) 
   	{  
                 
		if ($tipo_proceso=='SUBSIDIO FAMILIAR' )
		{
			$numproceso='1';
	
		}		
	
		///////////////////////////////////////////////////////////////
		//SUBSIDIO FAMILIAR


		$controla = mysql_query('SELECT numerocontrato,tipocontrato,tipo_proceso, tipo_proceso2, tipo_proceso3 FROM cartera_serviasjudinet WHERE cedula = "'.$cedula.'" AND (tipo_proceso = "'.$tipo_proceso.'" || tipo_proceso2 = "'.$tipo_proceso.'" || tipo_proceso3 = "'.$tipo_proceso.'")  order by nombre ');
		if (!$controla) {
			die('Invalid query 2: ' . mysql_error());
		} 
		 
                        
  		list($numcon,$tipo,$tipopro1, $tipopro2, $tipopro3) = mysql_fetch_row($controla);	
	


   		printf("<tr>
        <td class='tdfull'>".$cedula."</td>
		<td class='tdfull'>".$nombres."</td>
		<td class='tdfull'><input type='button' value=SUBSIDIO_FAMILIAR name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_subsidio.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
							  
		<td class='tdfull'><input type='button' value=I.P.C. name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_ipc.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
							  
							  
		<td class='tdfull'><input type='button' value='VEINTE POR CIENTO' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_veinte.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
							  
		<td class='tdfull'><input type='button' value='BONIFICACION JUDICIAL' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_bonificacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
							  
		<td class='tdfull'><input type='button' value='BONO PENSIONAL' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_bono.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
							   
		<td class='tdfull'><input type='button' value='TRADICIONAL' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_tradicional.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='SUBSIDIO FAMILIAR SOLDADOS' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_soldados.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		
		<td class='tdfull'><input type='button' value='RELIQUIDACION PENSION' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_reliquidacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='CESANTIAS RETROACTIVAS' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_cesantias.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='SIN PENSION 15-20' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_sinpension.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='GENERICO' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_generico.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='RELIQUIDACION RETIRO' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_soldados_reliquidacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		");                   					
	} 
					
				
				
	
	
	////////////////////////////////////////////
	//I.P.C
	
	$control2 = mysql_query('SELECT cedula,nombre,tipo_proceso FROM informacion_documentos_ipc WHERE cedula = "'.$_POST["cedula2"].'" order by nombre ');
	if (!$control2) {
		die('Invalid query 2: ' . mysql_error());
	} 
		
                                              							                      
	while(list($cedula,$nombres,$tipo_proceso2) = mysql_fetch_row($control2)) 
    {  
                 
		if ($tipo_proceso2=='I.P.C.' )
		{
			$numproceso='2';
		}		


	
		///////////////////////////////////////////////////////////////


		$controla2 = mysql_query('SELECT numerocontrato,tipocontrato,tipo_proceso, tipo_proceso2, tipo_proceso3 FROM cartera_serviasjudinet WHERE cedula = "'.$cedula.'" AND (tipo_proceso = "'.$tipo_proceso2.'" || tipo_proceso2 = "'.$tipo_proceso2.'" || tipo_proceso3 = "'.$tipo_proceso2.'")  order by nombre ');
			if (!$controla2) {
				die('Invalid query 2: ' . mysql_error());
			} 
		 
                        
  		list($numcon,$tipo,$tipopro1,$tipopro2, $tipopro3) = mysql_fetch_row($controla2); 
                            
		///////////////////////////////////////////////////////////////	


   		printf("<tr>
                                 
   		<td class='tdfull'>".$cedula."</td>
		<td class='tdfull'>".$nombres."</td>
					
		<td class='tdfull'><input type='button' value=SUBSIDIO_FAMILIAR name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_subsidio.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>			 
							 
		<td class='tdfull'><input type='button' value=I.P.C. name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_ipc.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						
		<td class='tdfull'><input type='button' value='VEINTE POR CIENTO' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_veinte.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						 
		<td class='tdfull'><input type='button' value='BONIFICACION JUDICIAL' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_bonificacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						 
		<td class='tdfull'><input type='button' value='BONO PENSIONAL' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_bono.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						  
		<td class='tdfull'><input type='button' value='TRADICIONAL' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_tradicional.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='SUBSIDIO FAMILIAR SOLDADOS' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_soldados.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='RELIQUIDACION PENSION' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_reliquidacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='CESANTIAS RETROACTIVAS' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_cesantias.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='SIN PENSION 15-20' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_sinpension.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='GENERICO' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_generico.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='RELIQUIDACION RETIRO' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_soldados_reliquidacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		
		");             					
	} 
					
				
		
		//////////////////////////		
				
				
		//////////////////////////
		//VEINTE POR CIENTO
		
$control3 = mysql_query('SELECT cedula,nombre,tipo_proceso FROM informacion_documentos_veinte WHERE cedula = "'.$_POST["cedula2"].'" order by nombre ');
		if (!$control3) {
			die('Invalid query 2: ' . mysql_error());
		} 
		
                                              							  
	while(list($cedula,$nombres,$tipo_proceso3) = mysql_fetch_row($control3)) 
    {  
                 
		if ($tipo_proceso3=='VEINTE POR CIENTO' )
		{
			$numproceso='3';
	
		}		


	
		///////////////////////////////////////////////////////////////


$controla3 = mysql_query('SELECT numerocontrato,tipocontrato,tipo_proceso, tipo_proceso2, tipo_proceso3 FROM cartera_serviasjudinet WHERE cedula = "'.$cedula.'" AND (tipo_proceso = "'.$tipo_proceso3.'" || tipo_proceso2 = "'.$tipo_proceso3.'" || tipo_proceso3 = "'.$tipo_proceso3.'") order by nombre ');
		if (!$controla3) {
			die('Invalid query 2: ' . mysql_error());
		} 
		 
                        
  		list($numcon,$tipo,$tipopro1,$tipopro2, $tipopro3) = mysql_fetch_row($controla3); 
                            
		///////////////////////////////////////////////////////////////	


  		printf("<tr>
                                 
   		<td class='tdfull'>".$cedula."</td>
		<td class='tdfull'>".$nombres."</td>
		<td class='tdfull'><input type='button' value=SUBSIDIO_FAMILIAR name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_subsidio.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>			 
							 
		<td class='tdfull'><input type='button' value=I.P.C. name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_ipc.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						
		<td class='tdfull'><input type='button' value='VEINTE POR CIENTO' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_veinte.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						 
		<td class='tdfull'><input type='button' value='BONIFICACION JUDICIAL' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_bonificacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						  
		<td class='tdfull'><input type='button' value='BONO PENSIONAL' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_bono.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						  
		<td class='tdfull'><input type='button' value='TRADICIONAL' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_tradicional.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='SUBSIDIO FAMILIAR SOLDADOS' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_soldados.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='RELIQUIDACION PENSION' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_reliquidacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='CESANTIAS RETROACTIVAS' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_cesantias.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='SIN PENSION 15-20' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_sinpension.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='GENERICO' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_generico.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='RELIQUIDACION RETIRO' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_soldados_reliquidacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		");               					
		
	} 
	
	
	
	
				
		/////////////////// BONIFICACION JUDICIAL ////////////////////
		
$control4 = mysql_query('SELECT cedula,nombre,tipo_proceso FROM informacion_documentos_bonificacion WHERE cedula = "'.$_POST["cedula2"].'" order by nombre ');
	if (!$control4) {
		die('Invalid query 4: ' . mysql_error());
	} 
		
                                              							  
                        
  	while(list($cedula,$nombres,$tipo_proceso4) = mysql_fetch_row($control4)) 
    {  
                 
		if ($tipo_proceso4=='BONIFICACION JUDICIAL' )
		{
			$numproceso='4';
	
		}		


	
		///////////////////////////////////////////////////////////////


		$controla4 = mysql_query('SELECT numerocontrato,tipocontrato,tipo_proceso, tipo_proceso2, tipo_proceso3 FROM cartera_serviasjudinet WHERE cedula = "'.$cedula.'" AND (tipo_proceso = "'.$tipo_proceso4.'" || tipo_proceso2 = "'.$tipo_proceso4.'" || tipo_proceso3 = "'.$tipo_proceso4.'") order by nombre ');
		  if (!$controla4) {
				die('Invalid query 2: ' . mysql_error());
			} 
		 
                        
  		list($numcon,$tipo,$tipopro1, $tipopro2, $tipopro3) = mysql_fetch_row($controla4); 
                            
		///////////////////////////////////////////////////////////////	


   		printf("<tr>
                                 
   		<td class='tdfull'>".$cedula."</td>
		<td class='tdfull'>".$nombres."</td>
		
		<td class='tdfull'><input type='button' value=SUBSIDIO_FAMILIAR name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_subsidio.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>			 
							 
		<td class='tdfull'><input type='button' value=I.P.C. name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_ipc.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						
		<td class='tdfull'><input type='button' value='VEINTE POR CIENTO' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_veinte.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						 
		<td class='tdfull'><input type='button' value='BONIFICACION JUDICIAL' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_bonificacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						 
		<td class='tdfull'><input type='button' value='BONO PENSIONAL' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_bono.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						   
		<td class='tdfull'><input type='button' value='TRADICIONAL' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_tradicional.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='SUBSIDIO FAMILIAR SOLDADOS' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_soldados.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='RELIQUIDACION PENSION' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_reliquidacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='CESANTIAS RETROACTIVAS' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_cesantias.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='SIN PENSION 15-20' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_sinpension.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='GENERICO' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_generico.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='RELIQUIDACION RETIRO' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_soldados_reliquidacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		");              					
	} 
					
				
		

				//////////////////////////		BONO PENCIONAL
		
		
$control5 = mysql_query('SELECT cedula,nombre,tipo_proceso FROM informacion_documentos_bono WHERE cedula = "'.$_POST["cedula2"].'" order by nombre ');
	if (!$control5) {
		die('Invalid query 5: ' . mysql_error());
	} 
		
                                              							  
  	while(list($cedula,$nombres,$tipo_proceso5) = mysql_fetch_row($control5)) 
   	{  
                 
		if ($tipo_proceso5=='BONO PENSIONAL' )
		{
			$numproceso='5';
	
		}		


	
///////////////////////////////////////////////////////////////


		$controla5 = mysql_query('SELECT numerocontrato,tipocontrato,tipo_proceso, tipo_proceso2, tipo_proceso3 FROM cartera_serviasjudinet WHERE cedula = "'.$cedula.'" AND (tipo_proceso = "'.$tipo_proceso5.'" || tipo_proceso2 = "'.$tipo_proceso5.'" || tipo_proceso3 = "'.$tipo_proceso5.'") order by nombre ');
		  if (!$controla5) {
				die('Invalid query 2: ' . mysql_error());
			} 
		 
                        
  		list($numcon,$tipo,$tipopro1, $tipopro2, $tipopro3) = mysql_fetch_row($controla5); 
                            
		///////////////////////////////////////////////////////////////	


   		printf("<tr>
                                 
   		<td class='tdfull'>".$cedula."</td>
		<td class='tdfull'>".$nombres."</td>
		<td class='tdfull'><input type='button' value=SUBSIDIO_FAMILIAR name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_subsidio.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>			 
							 
		<td class='tdfull'><input type='button' value=I.P.C. name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_ipc.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						
		<td class='tdfull'><input type='button' value='VEINTE POR CIENTO' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_veinte.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						 
		<td class='tdfull'><input type='button' value='BONIFICACION JUDICIAL' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_bonificacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						 
		<td class='tdfull'><input type='button' value='BONO PENSIONAL' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_bono.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						 
		<td class='tdfull'><input type='button' value='TRADICIONAL' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_tradicional.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='SUBSIDIO FAMILIAR SOLDADOS' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_soldados.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='RELIQUIDACION PENSION' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_reliquidacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='CESANTIAS RETROACTIVAS' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_cesantias.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='SIN PENSION 15-20' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_sinpension.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='GENERICO' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_generico.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='RELIQUIDACION RETIRO' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_soldados_reliquidacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		");                 					 
	} 
					
				
		//////////////////////////	
		
		
							//////////////////////////		TRADICIONAL
		
		//////////////////////////
		
$control6 = mysql_query('SELECT cedula,nombre,tipo_proceso FROM informacion_documentos_tradicional WHERE cedula = "'.$_POST["cedula2"].'" order by nombre ');
	if (!$control6) {
		die('Invalid query 6: ' . mysql_error());
	} 
		
                                              							  
                        
  	while(list($cedula,$nombres,$tipo_proceso6) = mysql_fetch_row($control6)) 
  	{  
                 
		if ($tipo_proceso6=='TRADICIONAL' )
		{
			$numproceso='6';
	
		}		


	
		///////////////////////////////////////////////////////////////


		$controla6 = mysql_query('SELECT numerocontrato,tipocontrato,tipo_proceso, tipo_proceso2, tipo_proceso3 FROM cartera_serviasjudinet WHERE cedula = "'.$cedula.'" AND (tipo_proceso = "'.$tipo_proceso6.'" || tipo_proceso2 = "'.$tipo_proceso6.'" || tipo_proceso3 = "'.$tipo_proceso6.'") order by nombre ');
		if (!$controla6) {
			die('Invalid query 6: ' . mysql_error());
		} 
		 
                        
  		list($numcon,$tipo,$tipopro1, $tipopro2, $tipopro3) = mysql_fetch_row($controla6); 
                            
		///////////////////////////////////////////////////////////////	


   		printf("<tr>
                                 
   		<td class='tdfull'>".$cedula."</td>
		<td class='tdfull'>".$nombres."</td>
		<td class='tdfull'><input type='button' value=SUBSIDIO_FAMILIAR name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_subsidio.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>			 
							 
		<td class='tdfull'><input type='button' value=I.P.C. name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_ipc.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						
		<td class='tdfull'><input type='button' value='VEINTE POR CIENTO' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_veinte.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						 
		<td class='tdfull'><input type='button' value='BONIFICACION JUDICIAL' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_bonificacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						 
		<td class='tdfull'><input type='button' value='BONO PENSIONAL' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_bono.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						 
		<td class='tdfull'><input type='button' value='TRADICIONAL' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_tradicional.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td> 
		
		
		<td class='tdfull'><input type='button' value='SUBSIDIO FAMILIAR SOLDADOS' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_soldados.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='RELIQUIDACION PENSION' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_reliquidacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='CESANTIAS RETROACTIVAS' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_cesantias.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='SIN PENSION 15-20' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_sinpension.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='GENERICO' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_generico.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='RELIQUIDACION RETIRO' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_soldados_reliquidacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		");                 					 
	
	} 
	
	//////////////////////////////////////////////
	//SUBSIDIO FAMILIAR SOLDADO
		$control7 = mysql_query('SELECT cedula,nombre,tipo_proceso FROM informacion_documentos_subsidio_soldados WHERE cedula = "'.$_POST["cedula2"].'" order by nombre ');
	if (!$control7) {
		die('Invalid query 2: ' . mysql_error());
	} 
		
                                              							                      
	while(list($cedula,$nombres,$tipo_proceso7) = mysql_fetch_row($control7)) 
    {  
                 
		if ($tipo_proceso7=='SUBSIDIO FAMILIAR SOLDADO' )
		{
			$numproceso='7';
		}		


	
		///////////////////////////////////////////////////////////////


		$controla7 = mysql_query('SELECT numerocontrato,tipocontrato,tipo_proceso, tipo_proceso2, tipo_proceso3 FROM cartera_serviasjudinet WHERE cedula = "'.$cedula.'" AND (tipo_proceso = "'.$tipo_proceso7.'" || tipo_proceso2 = "'.$tipo_proceso7.'" || tipo_proceso3 = "'.$tipo_proceso7.'")  order by nombre ');
			if (!$controla7) {
				die('Invalid query 2: ' . mysql_error());
			} 
		 
                        
  		list($numcon,$tipo,$tipopro1, $tipopro2, $tipopro3) = mysql_fetch_row($controla7); 
                            
		///////////////////////////////////////////////////////////////	


   		printf("<tr>
                                 
   		<td class='tdfull'>".$cedula."</td>
		<td class='tdfull'>".$nombres."</td>
					
		<td class='tdfull'><input type='button' value=SUBSIDIO_FAMILIAR name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_subsidio.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>			 
							 
		<td class='tdfull'><input type='button' value=I.P.C. name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_ipc.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						
		<td class='tdfull'><input type='button' value='VEINTE POR CIENTO' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_veinte.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						 
		<td class='tdfull'><input type='button' value='BONIFICACION JUDICIAL' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_bonificacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						 
		<td class='tdfull'><input type='button' value='BONO PENSIONAL' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_bono.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						  
		<td class='tdfull'><input type='button' value='TRADICIONAL' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_tradicional.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='SUBSIDIO FAMILIAR SOLDADOS' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_soldados.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		
		<td class='tdfull'><input type='button' value='RELIQUIDACION PENSION' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_reliquidacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='CESANTIAS RETROACTIVAS' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_cesantias.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='SIN PENSION 15-20' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_sinpension.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='GENERICO' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_generico.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='RELIQUIDACION RETIRO' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_soldados_reliquidacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		");             					
	}
	
	
	
					
				
		//////////////////////////	RELIQUIDACION PENSION
		$control8 = mysql_query('SELECT cedula,nombre,tipo_proceso FROM informacion_documentos_reliquidacion WHERE cedula = "'.$_POST["cedula2"].'" order by nombre ');
	if (!$control8) {
		die('Invalid query 2: ' . mysql_error());
	} 
		
                                              							                      
	while(list($cedula,$nombres,$tipo_proceso8) = mysql_fetch_row($control8)) 
    {  
                 
		if ($tipo_proceso8=='RELIQUIDACION PENSION' )
		{
			$numproceso='8';
		}		


	
		///////////////////////////////////////////////////////////////


		$controla8 = mysql_query('SELECT numerocontrato,tipocontrato,tipo_proceso, tipo_proceso2, tipo_proceso3 FROM cartera_serviasjudinet WHERE cedula = "'.$cedula.'" AND (tipo_proceso = "'.$tipo_proceso8.'" || tipo_proceso2 = "'.$tipo_proceso8.'" || tipo_proceso3 = "'.$tipo_proceso8.'")  order by nombre ');
			if (!$controla8) {
				die('Invalid query 2: ' . mysql_error());
			} 
		 
                        
  		list($numcon,$tipo,$tipopro1, $tipopro2, $tipopro3) = mysql_fetch_row($controla8); 
                            
		///////////////////////////////////////////////////////////////	


   		printf("<tr>
                                 
   		<td class='tdfull'>".$cedula."</td>
		<td class='tdfull'>".$nombres."</td>
					
		<td class='tdfull'><input type='button' value=SUBSIDIO_FAMILIAR name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_subsidio.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>			 
							 
		<td class='tdfull'><input type='button' value=I.P.C. name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_ipc.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						
		<td class='tdfull'><input type='button' value='VEINTE POR CIENTO' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_veinte.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						 
		<td class='tdfull'><input type='button' value='BONIFICACION JUDICIAL' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_bonificacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						 
		<td class='tdfull'><input type='button' value='BONO PENSIONAL' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_bono.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						  
		<td class='tdfull'><input type='button' value='TRADICIONAL' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_tradicional.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='SUBSIDIO FAMILIAR SOLDADOS' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_soldados.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		
		<td class='tdfull'><input type='button' value='RELIQUIDACION PENSION' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_reliquidacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='CESANTIAS RETROACTIVAS' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_cesantias.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='SIN PENSION 15-20' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_sinpension.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='GENERICO' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_generico.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='RELIQUIDACION RETIRO' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_soldados_reliquidacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		");             					
	}
	
	
	
	
	
		
		
		
		
		///////////////////PRIMA ACTIVIDAD
	
		$control9 = mysql_query('SELECT cedula,nombre,tipo_proceso FROM informacion_documentos_prima WHERE cedula = "'.$_POST["cedula2"].'" order by nombre ');
	if (!$control9) {
		die('Invalid query 2: ' . mysql_error());
	} 
		
                                              							                      
	while(list($cedula,$nombres,$tipo_proceso9) = mysql_fetch_row($control9)) 
    {  
                 
		if ($tipo_proceso9=='PRIMA ACTIVIDAD' )
		{
			$numproceso='9';
		}		


	
		///////////////////////////////////////////////////////////////


		$controla9 = mysql_query('SELECT numerocontrato,tipocontrato,tipo_proceso FROM cartera_serviasjudinet WHERE cedula = "'.$cedula.'" AND tipo_proceso = "SUBSIDIO FAMILIAR SOLDADO"  order by nombre ');
			if (!$controla9) {
				die('Invalid query 2: ' . mysql_error());
			} 
		 
                        
  		list($numcon,$tipo,$tipo_proceso9) = mysql_fetch_row($controla9); 
                            
		///////////////////////////////////////////////////////////////	


   		printf("<tr>
                                 
   		<td class='tdfull'>".$cedula."</td>
		<td class='tdfull'>".$nombres."</td>
					
		<td class='tdfull'><input type='button' value=SUBSIDIO_FAMILIAR name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_subsidio.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>			 
							 
		<td class='tdfull'><input type='button' value=I.P.C. name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_ipc.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						
		<td class='tdfull'><input type='button' value='VEINTE POR CIENTO' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_veinte.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						 
		<td class='tdfull'><input type='button' value='BONIFICACION JUDICIAL' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_bonificacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						 
		<td class='tdfull'><input type='button' value='BONO PENSIONAL' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_bono.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						  
		<td class='tdfull'><input type='button' value='TRADICIONAL' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_tradicional.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='SUBSIDIO FAMILIAR SOLDADOS' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_soldados.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		
		<td class='tdfull'><input type='button' value='RELIQUIDACION PENSION' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_reliquidacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='CESANTIAS RETROACTIVAS' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_cesantias.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='SIN PENSION 15-20' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_sinpension.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='GENERICO' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_generico.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='RELIQUIDACION RETIRO' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_soldados_reliquidacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		");             					
	}
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	///////////////////CESANTIAS RETROACTIVAS
	
		$control10 = mysql_query('SELECT cedula,nombre,tipo_proceso FROM informacion_documentos_cesantias WHERE cedula = "'.$_POST["cedula2"].'" order by nombre ');
	if (!$control10) {
		die('Invalid query 2: ' . mysql_error());
	} 
		
                                              							                      
	while(list($cedula,$nombres,$tipo_proceso10) = mysql_fetch_row($control10)) 
    {  
                 
		if ($tipo_proceso10=='CESANTIAS RETROACTIVAS' )
		{
			$numproceso='10';
		}		


	
		///////////////////////////////////////////////////////////////


		$controla10 = mysql_query('SELECT numerocontrato,tipocontrato,tipo_proceso, tipo_proceso2, tipo_proceso3 FROM cartera_serviasjudinet WHERE cedula = "'.$cedula.'" AND (tipo_proceso = "'.$tipo_proceso10.'" || tipo_proceso2 = "'.$tipo_proceso10.'" || tipo_proceso3 = "'.$tipo_proceso10.'")  order by nombre ');
			if (!$controla10) {
				die('Invalid query 2: ' . mysql_error());
			} 
		 
                        
  		list($numcon,$tipo,$tipopro1, $tipopro2, $tipopro3) = mysql_fetch_row($controla10); 
                            
		///////////////////////////////////////////////////////////////	


   		printf("<tr>
                                 
   		<td class='tdfull'>".$cedula."</td>
		<td class='tdfull'>".$nombres."</td>
					
		<td class='tdfull'><input type='button' value=SUBSIDIO_FAMILIAR name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_subsidio.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>			 
							 
		<td class='tdfull'><input type='button' value=I.P.C. name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_ipc.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						
		<td class='tdfull'><input type='button' value='VEINTE POR CIENTO' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_veinte.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						 
		<td class='tdfull'><input type='button' value='BONIFICACION JUDICIAL' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_bonificacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						 
		<td class='tdfull'><input type='button' value='BONO PENSIONAL' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_bono.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						  
		<td class='tdfull'><input type='button' value='TRADICIONAL' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_tradicional.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='SUBSIDIO FAMILIAR SOLDADOS' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_soldados.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		
		<td class='tdfull'><input type='button' value='RELIQUIDACION PENSION' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_reliquidacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='CESANTIAS RETROACTIVAS' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_cesantias.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='SIN PENSION 15-20' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_sinpension.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='GENERICO' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_generico.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='RELIQUIDACION RETIRO' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_soldados_reliquidacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		");             					
	}
	
	
	
	
	
	
	///////////////////SIN PENSION 15-20
	
		$control11 = mysql_query('SELECT cedula,nombre,tipo_proceso FROM informacion_documentos_sinpension WHERE cedula = "'.$_POST["cedula2"].'" order by nombre ');
	if (!$control11) {
		die('Invalid query 2: ' . mysql_error());
	} 
		
                                              							                      
	while(list($cedula,$nombres,$tipo_proceso11) = mysql_fetch_row($control11)) 
    {  
                 
		if ($tipo_proceso11=='SIN PENSION 15-20' )
		{
			$numproceso='11';
		}		


	
		///////////////////////////////////////////////////////////////


		$controla11 = mysql_query('SELECT numerocontrato,tipocontrato,tipo_proceso, tipo_proceso2, tipo_proceso3 FROM cartera_serviasjudinet WHERE cedula = "'.$cedula.'" AND (tipo_proceso = "'.$tipo_proceso11.'" || tipo_proceso2 = "'.$tipo_proceso11.'" || tipo_proceso3 = "'.$tipo_proceso11.'")  order by nombre ');
			if (!$controla11) {
				die('Invalid query 2: ' . mysql_error());
			} 
		 
                        
  		list($numcon,$tipo,$tipopro1, $tipopro2, $tipopro3) = mysql_fetch_row($controla11); 
                            
		///////////////////////////////////////////////////////////////	


   		printf("<tr>
                                 
   		<td class='tdfull'>".$cedula."</td>
		<td class='tdfull'>".$nombres."</td>
					
		<td class='tdfull'><input type='button' value=SUBSIDIO_FAMILIAR name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_subsidio.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>			 
							 
		<td class='tdfull'><input type='button' value=I.P.C. name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_ipc.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						
		<td class='tdfull'><input type='button' value='VEINTE POR CIENTO' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_veinte.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						 
		<td class='tdfull'><input type='button' value='BONIFICACION JUDICIAL' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_bonificacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						 
		<td class='tdfull'><input type='button' value='BONO PENSIONAL' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_bono.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						  
		<td class='tdfull'><input type='button' value='TRADICIONAL' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_tradicional.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='SUBSIDIO FAMILIAR SOLDADOS' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_soldados.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		
		<td class='tdfull'><input type='button' value='RELIQUIDACION PENSION' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_reliquidacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='CESANTIAS RETROACTIVAS' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_cesantias.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='SIN PENSION 15-20' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_sinpension.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='GENERICO' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_generico.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='RELIQUIDACION RETIRO' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_soldados_reliquidacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		");             					
	}
		
		
		
		
	///////////////////GENERICO
	
		$control12 = mysql_query('SELECT cedula,nombre,tipo_proceso FROM informacion_documentos_generico WHERE cedula = "'.$_POST["cedula2"].'" order by nombre ');
	if (!$control12) {
		die('Invalid query 2: ' . mysql_error());
	} 
		
                                              							                      
	while(list($cedula,$nombres,$tipo_proceso12) = mysql_fetch_row($control12)) 
    {  
                 
		if ($tipo_proceso12=='GENERICO' )
		{
			$numproceso='12';
		}		


	
		///////////////////////////////////////////////////////////////


		$controla12 = mysql_query('SELECT numerocontrato,tipocontrato,tipo_proceso, tipo_proceso2, tipo_proceso3 FROM cartera_serviasjudinet WHERE cedula = "'.$cedula.'" AND (tipo_proceso = "'.$tipo_proceso12.'" || tipo_proceso2 = "'.$tipo_proceso12.'" || tipo_proceso3 = "'.$tipo_proceso12.'")  order by nombre ');
			if (!$controla12) {
				die('Invalid query 2: ' . mysql_error());
			} 
		 
                        
  		list($numcon,$tipo,$tipopro1, $tipopro2, $tipopro3) = mysql_fetch_row($controla12); 
                            
		///////////////////////////////////////////////////////////////	


   		printf("<tr>
                                 
   		<td class='tdfull'>".$cedula."</td>
		<td class='tdfull'>".$nombres."</td>
					
		<td class='tdfull'><input type='button' value=SUBSIDIO_FAMILIAR name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_subsidio.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>			 
							 
		<td class='tdfull'><input type='button' value=I.P.C. name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_ipc.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						
		<td class='tdfull'><input type='button' value='VEINTE POR CIENTO' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_veinte.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						 
		<td class='tdfull'><input type='button' value='BONIFICACION JUDICIAL' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_bonificacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						 
		<td class='tdfull'><input type='button' value='BONO PENSIONAL' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_bono.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						  
		<td class='tdfull'><input type='button' value='TRADICIONAL' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_tradicional.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='SUBSIDIO FAMILIAR SOLDADOS' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_soldados.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		
		<td class='tdfull'><input type='button' value='RELIQUIDACION PENSION' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_reliquidacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='CESANTIAS RETROACTIVAS' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_cesantias.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='SIN PENSION 15-20' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_sinpension.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='GENERICO' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_generico.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='RELIQUIDACION RETIRO' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_soldados_reliquidacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		");             					
	}
		
		
		
		
		
		
		
		
		
		//////
		
		///////////////////RELIQUIDACION RETIRO
	
		$control13 = mysql_query('SELECT cedula,nombre,tipo_proceso FROM informacion_documentos_generico WHERE cedula = "'.$_POST["cedula2"].'" order by nombre ');
	if (!$control13) {
		die('Invalid query 2: ' . mysql_error());
	} 
		
                                              							                      
	while(list($cedula,$nombres,$tipo_proceso13) = mysql_fetch_row($control13)) 
    {  
                 
		if ($tipo_proceso13=='RELIQUIDACION RETIRO' )
		{
			$numproceso='13';
		}		


	
		///////////////////////////////////////////////////////////////


		$controla13 = mysql_query('SELECT numerocontrato,tipocontrato,tipo_proceso, tipo_proceso2, tipo_proceso3 FROM cartera_serviasjudinet WHERE cedula = "'.$cedula.'" AND (tipo_proceso = "'.$tipo_proceso13.'" || tipo_proceso2 = "'.$tipo_proceso13.'" || tipo_proceso3 = "'.$tipo_proceso13.'")  order by nombre ');
			if (!$controla13) {
				die('Invalid query 2: ' . mysql_error());
			} 
		 
                        
  		list($numcon,$tipo,$tipopro1, $tipopro2, $tipopro3) = mysql_fetch_row($controla13); 
                            
		///////////////////////////////////////////////////////////////	


   		printf("<tr>
                                 
   		<td class='tdfull'>".$cedula."</td>
		<td class='tdfull'>".$nombres."</td>
					
		<td class='tdfull'><input type='button' value=SUBSIDIO_FAMILIAR name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_subsidio.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>			 
							 
		<td class='tdfull'><input type='button' value=I.P.C. name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_ipc.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						
		<td class='tdfull'><input type='button' value='VEINTE POR CIENTO' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_veinte.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						 
		<td class='tdfull'><input type='button' value='BONIFICACION JUDICIAL' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_bonificacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						 
		<td class='tdfull'><input type='button' value='BONO PENSIONAL' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_bono.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
						  
		<td class='tdfull'><input type='button' value='TRADICIONAL' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_tradicional.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='SUBSIDIO FAMILIAR SOLDADOS' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_soldados.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		
		<td class='tdfull'><input type='button' value='RELIQUIDACION PENSION' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_reliquidacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='CESANTIAS RETROACTIVAS' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_cesantias.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='SIN PENSION 15-20' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_sinpension.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='GENERICO' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_generico.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		<td class='tdfull'><input type='button' value='RELIQUIDACION RETIRO' name='id' class=botonnew onClick =	window.open('apostventas/consulta_documentos_aportados_soldados_reliquidacion.php?cedula=$cedula&contrato=$numcon','','top=30,left=50,toolbar=yes,scrollbars=yes,width=1000,height=800,status=yes')></a></td>
		
		");             					
	}
		
		
		
		
		

				
				echo "</table>";		  


echo "</form>";

}
?>