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

<html>
<head>
<title>Consulta Recuperaci&oacute;n Tesoreria</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;}
.texto1 {background-color: #FFFFCC; font-size: 11px; font-family: Arial; color:#0000CC; display: block;}
.fecha {font-size: 12px; font-family: Arial; color:#990000; display: block; }
.campo {background-color:#FFFFAA; width: 100px; border:2px solid #990000;}
.lista {font-family: Arial; font-size: 11px;	color: #990000;}
.lista2 {font-family: Arial; font-size: 16px;	color: #FF6600;}
.boton2 {
	font-family: Verdana;
	font-size: 8 pt;
	color: #000080;
	background-color: #C0C0C0;
	border-style: solid;
	width:90px;
	height:22px;
}
body {
	background-image: url();
}
.Estilo50 {color: #CC3333;
	font-family: "Arial Narrow";
	font-weight: bold;
}
.Estilo51 {
	color: #3366FF;
	font-weight: bold;
}
.boton1 {background-color: #FFCCCC; color:#FFFFFF; width:90px; height:25; border: 3px solid #0000CC; font-family:Arial; color:#990000;}
.boton11 {background-color: #FFCCCC; color:#FFFFFF; width:90px; height:25; border: 3px solid #0000CC; font-family:Arial; color:#990000;}
-->
</style>
<script languaje="JavaScript">
function Mostrar_Fecha()
{
         var mydate=new Date()
         var year=mydate.getYear()
         if (year < 1000)
                 year+=1900
                 var day=mydate.getDay()
                 var month=mydate.getMonth()
                 var daym=mydate.getDate()
                 if (daym<10)
                    daym="0"+daym
                    var dayarray=new Array("Domingo","Lunes","Martes","Miercoles","Jueves","Viernes","Sabado")
                    var montharray=new Array("Enero","Febrero","Marzo","Abril","Mayo","Junio","Julio","Agosto","Septiembre","Octubre","Noviembre","Diciembre")
                    document.write("<b><font face='Arial, Helvetica, sans-serif'>"+dayarray[day]+" "+daym+" de "+montharray[month]+" de "+year+"</font></b>")
}					
</script>
<script language="javascript">
function AbreGral()
{ 
    var menu;   
	menu=window.open("mostrar_ingreso.php","","toolbar=no,scrollbars=no,width=800,height=500,status=yes");  
	menu.focus();  
	var ventana = window.self;  
	ventana.opener = window.self;  
	ventana.close();
}
</script>
</head>

<body onLoad="document.formulario.cedula.focus()" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<form name="formulario" action="" method="post">
<table width="671" border="0" cellspacing="0" cellpadding="0" align="center">
  <tr>
    <td><fieldset><table width="669" border="0" align="center" cellpadding="2" cellspacing="2">
  <tr bgcolor="#FFFFCC">
    <td colspan="2" class="titulos"><div align="center"> CONSULTA RECUPERACION CARTERA TESORERIA</div></td>
  </tr>
  <tr bgcolor="#ECE9D8">
    <td height="22" colspan="2" class="fecha"><div align="center">
      <script languaje="JavaScript">Mostrar_Fecha()</script>
    </div></td>
  </tr>
  

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

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

<?php

   
if(isset($_POST["busqueda"]))
{


    function Conectarse()
	{
	   if (!($link=@mysql_connect("localhost","asjudine","as2006")))
	   {
		  echo "Error conectando con el servidor.";
		  exit();
	   }
	   $dbname = "asjudinet";
	   if (!@mysql_select_db($dbname,$link))
	   {
		  echo "Error seleccionando la base de datos.";
		  exit();
	   }
	   return $link;
	}
	Conectarse();
		
	echo "<form name='form' action='' method='post'>";
    require_once("mainfile.php");
    include ("config.php");
    global $dbi;

$mssql = mysql_query('SELECT *  FROM recuperacion_cartera2 ');
		  if (!$mssql) {
				die('Invalid query 1: ' . mysql_error());
			}
		
   if($mssql)
   {
         $filas = mysql_num_rows($mssql);
         if ($filas > 0)
         {

	$control = mysql_query('SELECT cedula, nombre, contrato, tipo, deudajur, deudacre, monto_conciliado_jur, monto_conciliado_cre FROM recuperacion_cartera2 WHERE nombre LIKE "' . "%$nom%" . '"  order by nombre ');
		  if (!$control) {
				die('Invalid query 2: ' . mysql_error());
			} 
	
		
					  if ((mysql_num_rows($control)!=0)) 
	                    {	 
					
                              echo "<TABLE width='900' border='0' align='center' cellpadding='0' cellspacing='1'>
                              <TR>
                              <TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>CONVENIO</span></div></TD>
							  <TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>NOMBRE</span></div></TD>	
							   <TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>N° CONTRATO</span></div></TD>
                              <TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>TIPO</span></div></TD>
							  <TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>DEUDA JUR</span></div></TD>
							  <TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>MONTO CONCILIADO JUR</span></div></TD>
                              <TD bgcolor='#FFFFCC'><div align='center'><span class='texto1'>DEUDA CRE</span></div></TD>
							    <TD bgcolor='#FFFFCC'><div align='center'><span class='texto1'>MONTO CONCILIADO CRE</span></div></TD>
								<TD bgcolor='#FFFFCC'><div align='center'><span class='texto1'>CARTERA</span></div></TD>";		  
                           							  
                        
   while(list($cedula, $nombres , $numcon , $tipo, $deudajur, $deudacre, $moncon, $moncre) = mysql_fetch_row($control)) 
                              {  
							  $cedut = $cedula;
                          if ($tipo > 0)
						  {
						   $cont10 = mysql_query('SELECT codigo_contrato FROM planes_contratos WHERE codigo = "' . "$tipo". '" ');
		  if (!$cont10) {
				die('Invalid query 42: ' . mysql_error());
			}
		list($tipo) = mysql_fetch_row($cont10); 
						  } 
						  
		$con = mysql_query('SELECT capital_periodo  FROM cobranzas  WHERE cedula  = "' . "$cedula" . '"  and numero  = "' . "$numcon" . '"  ');
		  if (!$con) {
				die('Invalid query 2con: ' . mysql_error());
			} 
					list($capital) = mysql_fetch_row($con);	
					
					$surer = mysql_query('SELECT cedula FROM cartera_serviasjudinet  WHERE cedula = "' . "$cedula" . '" and numerocontrato = "' . "$numcon" . '"  ');
		  if (!$surer) {
				die('Invalid query 2 surer: ' . mysql_error());
			} 
list($cedu2) = mysql_fetch_row($surer);
					
								 
								  printf("<tr>
                                 
							
									
									<td bgcolor='#ECE9D8'><div align='center' class='lista'><input type='button' value=$cedula name='cedu' class=Estilo50 onClick =window.open('cobranzas_consulta_recuperacion1.php?ced2=$cedula&numcon=$numcon','','top=50,left=100,toolbar=no,scrollbars=yes,width=1000,height=650,status=yes')></a></span></div></td>
									
                                   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$nombres."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$numcon."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$tipo."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$capital."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$moncon."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$deudacre."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$moncre."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$moncre."</span></div></td>
								  <td bgcolor='#ECE9D8'><div align='center' class='lista'><input type='button' value=$cedu2 name='cedu' class=Estilo51 onClick =window.open('credito_consulta_contrato.php?ced2=$cedula&numcon=$numcon','','top=50,left=100,toolbar=no,scrollbars=yes,width=1000,height=650,status=yes')></a></span></div></td>");  
								  
								   if ((mysql_num_rows($surer)!=0)) 
	                   			 {
									  
									 
									   echo "<TABLE width='750' border='0' align='center' cellpadding='0' cellspacing='1'>
                              <TR>
                              <TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>CONVENIO</span></div></TD>
							  <TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>NOMBRE</span></div></TD>	
							   <TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>N° CONTRATO</span></div></TD>
                              <TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>TIPO</span></div></TD>
							  <TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>DEUDA JUR</span></div></TD>
							  <TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>MONTO CONCILIADO JUR</span></div></TD>
                              <TD bgcolor='#FFFFCC'><div align='center'><span class='texto1'>DEUDA CRE</span></div></TD>
							    <TD bgcolor='#FFFFCC'><div align='center'><span class='texto1'>MONTO CONCILIADO CRE</span></div></TD>
								<TD bgcolor='#FFFFCC'><div align='center'><span class='texto1'>CARTERA</span></div></TD>";	
								
								printf("<tr>
								<td bgcolor='#ECE9D8'><div align='center' class='lista'><input type='button' value=$cedula name='cedu' class=Estilo50 onClick =window.open('cobranzas_consulta_recuperacion1.php?ced2=$cedula&numcon=$numcon','','top=50,left=100,toolbar=no,scrollbars=yes,width=1000,height=650,status=yes')></a></span></div></td>
									
                                   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$nombres."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$numcon."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$tipo."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$capital."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$moncon."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$deudacre."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$moncre."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$moncre."</span></div></td>
								  <td bgcolor='#ECE9D8'><div align='center' class='lista'><input type='button' value=$cedu2 name='cedu' class=Estilo51 onClick =window.open('credito_consulta_contrato.php?ced2=$cedula&numcon=$numcon','','top=50,left=100,toolbar=no,scrollbars=yes,width=1000,height=650,status=yes')></a></span></div></td>");  
									  
								  }
							            								   
                               }
			                       
								   echo "</table>";		  
                        }
	      }
     }
    

echo "</form>";



}


 
if(isset($_POST["consultar"]))
{



    function Conectarse()
	{
	   if (!($link=@mysql_connect("localhost","asjudine","as2006")))
	   {
		  echo "Error conectando con el servidor.";
		  exit();
	   }
	   $dbname = "asjudinet";
	   if (!@mysql_select_db($dbname,$link))
	   {
		  echo "Error seleccionando la base de datos.";
		  exit();
	   }
	   return $link;
	}
	Conectarse();
		
	echo "<form name='form' action='' method='post'>";
    require_once("mainfile.php");
    include ("config.php");
    global $dbi;

$mssql = mysql_query('SELECT *  FROM cobranzas ');
		  if (!$mssql) {
				die('Invalid query 1: ' . mysql_error());
			}
		
   if($mssql)
   {
         $filas = mysql_num_rows($mssql);
         if ($filas > 0)
         {
	$control = mysql_query('SELECT cedula, nombre, contrato, tipo, deudajur, deudacre,  monto_conciliado_jur, monto_conciliado_cre FROM recuperacion_cartera WHERE cedula =  "' . $_POST["cedula2"]  . '" order by nombre ');
		  if (!$control) {
				die('Invalid query 2: ' . mysql_error());
			} 

                    	 
                            	  
                           							  
                        
  while(list($cedula, $nombres , $numcon,  $tipo, $deudajur, $deudacre, $moncon, $moncre) = mysql_fetch_row($control)) 
                              {  
                 $cedut = $cedula;
				 if ($tipo > 0)
				 {                 		
	$cont10 = mysql_query('SELECT codigo_contrato FROM planes_contratos WHERE codigo = "' . "$tipo". '" ');
		  if (!$cont10) {
				die('Invalid query 42: ' . mysql_error());
			}
		list($tipo) = mysql_fetch_row($cont10);  
		}
					   
			  $con = mysql_query('SELECT capital_periodo  FROM cobranzas  WHERE cedula  = "' . "$cedula" . '"  and numero  = "' . "$numcon" . '"  ');
		  if (!$con) {
				die('Invalid query 2con: ' . mysql_error());
			} 
					list($capital) = mysql_fetch_row($con);				
					
					 if ((mysql_num_rows($control)!=0)) 
	                    {
					
								     echo "<TABLE width='900' border='0' align='center' cellpadding='0' cellspacing='1'>
							 
                              <TR>
                              <TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>RECUPERACION</span></div></TD>
							  <TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>NOMBRE</span></div></TD>	
							   <TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>N° CONTRATO</span></div></TD>
                              <TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>TIPO </span></div></TD>
							  <TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>DEUDA JUR</span></div></TD>
							  <TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>MONTO CONCILIADO JUR</span></div></TD>
                              <TD bgcolor='#FFFFCC'><div align='center'><span class='texto1'>DEUDA CRE</span></div></TD>
						<TD bgcolor='#FFFFCC'><div align='center'><span class='texto1'>MONTO CONCILIADO CRE</span></div></TD><tr>";	
						
								  printf("<tr>
                                 
								<td bgcolor='#ECE9D8'><div align='center' class='lista'><input type='button' value='RECUPERACION' name='cedu' class=Estilo50 onClick =window.open('cobranzas_consulta_recuperacion.php?ced2=$cedula&numcon=$numcon','','top=50,left=100,toolbar=no,scrollbars=yes,width=1000,height=650,status=yes')></a></span></div></td>
                                   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$nombres."</span></div></td>
								    <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$numcon."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$tipo."</span></div></td>
								    <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$capital."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$moncon."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$deudacre."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$moncre."</span></div></td><tr>");  
	
												echo "</table>";	
												
						}
												
						$surer = mysql_query('SELECT cedula, estado FROM cartera_serviasjudinet  WHERE cedula = "' . "$cedula" . '" and numerocontrato = "' . "$numcon" . '"  ');
		  if (!$surer) {
				die('Invalid query 2 surer: ' . mysql_error());
			} 
list($cedu2, $estado) = mysql_fetch_row($surer);
	
										
										if($estado = "0")
										{
											$este = "HISTORICO";
										}else
										{
											$este = "VIGENTE";
										}
												
							if ((mysql_num_rows($surer)!=0)) 
	                   			 {
									 
									 
									   echo "<TABLE width='900' border='0' align='center' cellpadding='0' cellspacing='1'>
							   
                              <TR>
                              <TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>CARTERA</span></div></TD>
							  <TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>NOMBRE</span></div></TD>	
							   <TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>N° CONTRATO</span></div></TD>
                              <TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>TIPO</span></div></TD>
							  <TD bgcolor='#FFFFCC'><div align='center'><span class='texto'>ESTADO</span></div></TD><tr>
							 ";	
								
								printf("<tr>
								 <td bgcolor='#ECE9D8'><div align='center' class='lista'><input type='button' value='CARTERA' name='cedu' class=Estilo51 onClick =window.open('credito_consulta_contrato.php?ced2=$cedula&numcon=$numcon','','top=50,left=100,toolbar=no,scrollbars=yes,width=1000,height=650,status=yes')></a></span></div></td>
									
                                   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$nombres."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$numcon."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$tipo."</span></div></td>
								   <td bgcolor='#C5D6FC'><div align='center' class='lista'>".$este."</span></div></td>");  
									  
								  }
												
																	   
                               }
								   echo "</table>";		  
                        }
						
		       
	      
     }
    

echo "</form>";

	

}

 
   
?>
@ Telegram