<?php

require_once("../Conectarse.php");
global $dbi;


if ($_GET["libranza"]>="0" and  $_GET["libranza"]<="5000")
{
	$result = mysql_query('SELECT * FROM libranzas_5000 WHERE cedula= "'.$_GET["cedula"].'" and clase_contrato= "'.$_GET["tipo"].'" and numero_libranza="'.$_GET["libranza"].'" ');
	if (!$result) {
		die('Invalid query: ' . mysql_error());
	}
	
	
	if ((mysql_num_rows($result)!=0)) 
	{

			$row = mysql_fetch_row($result);
            $cedula = $row[0];
			$nombre = $row[6];
			$contenido = $row[7];
			$tipo = $row[8];
		header("Content-type: $tipo");
		header("Content-Disposition: attachment; filename=$nombre");
		print $contenido; 

	}  
}
  
  ///// PARTE 2
  
if ($_GET["libranza"]>"5000" and  $_GET["libranza"]<="10000")
{

	$result = mysql_query('SELECT * FROM libranzas_10000 WHERE cedula= "'.$_GET["cedula"].'" and clase_contrato= "'.$_GET["tipo"].'" and numero_libranza="'.$_GET["libranza"].'" ');
	if (!$result) {
		die('Invalid query: ' . mysql_error());
	}
	
	if ((mysql_num_rows($result)!=0)) 
	{
		$row = mysql_fetch_row($result);
        $cedula = $row[0];
		$nombre = $row[6];
		$contenido = $row[7];
		$tipo = $row[8];
		header("Content-type: $tipo");
		header("Content-Disposition: attachment; filename=$nombre");
		print $contenido; 

	}  
}

 ///// PARTE 3
  
if ($_GET["libranza"]>"10000" and  $_GET["libranza"]<="15000")
{
	$result = mysql_query('SELECT * FROM libranzas_15000 WHERE cedula= "'.$_GET["cedula"].'" and clase_contrato= "'.$_GET["tipo"].'" and numero_libranza="'.$_GET["libranza"].'" ');
	if (!$result) {
		die('Invalid query: ' . mysql_error());
	}
	if ((mysql_num_rows($result)!=0)) 
	{
		$row = mysql_fetch_row($result);
        $cedula = $row[0];
		$nombre = $row[6];
		$contenido = $row[7];
		$tipo = $row[8];
		header("Content-type: $tipo");
		header("Content-Disposition: attachment; filename=$nombre");
		print $contenido; 

	}  
}


 ///// PARTE 4
  
if ($_GET["libranza"]>"15000" and  $_GET["libranza"]<="20000")
{
	$result = mysql_query('SELECT * FROM libranzas_20000 WHERE cedula= "'.$_GET["cedula"].'" and clase_contrato= "'.$_GET["tipo"].'" and numero_libranza="'.$_GET["libranza"].'" ');
	if (!$result) {
		die('Invalid query: ' . mysql_error());
	}
	if ((mysql_num_rows($result)!=0)) 
	{
		$row = mysql_fetch_row($result);
        $cedula = $row[0];
		$nombre = $row[6];
		$contenido = $row[7];
		$tipo = $row[8];
	header("Content-type: $tipo");
	header("Content-Disposition: attachment; filename=$nombre");
	print $contenido; 

	}  
}
  
/// PARTE 5  
  
if ($_GET["libranza"]>="20000" and  $_GET["libranza"]<="30000")
{
	$result = mysql_query('SELECT * FROM libranzas_30000 WHERE cedula= "'.$_GET["cedula"].'" and clase_contrato= "'.$_GET["tipo"].'" and numero_libranza="'.$_GET["libranza"].'" ');
	if (!$result) {
		die('Invalid query: ' . mysql_error());
	}
	
	if ((mysql_num_rows($result)!=0)) 
	{
		$row = mysql_fetch_row($result);
        $cedula = $row[0];
		$nombre = $row[6];
		$contenido = $row[7];
		$tipo = $row[8];
		header("Content-type: $tipo");
		header("Content-Disposition: attachment; filename=$nombre");
		print $contenido; 

	}  
}
  

  
  

?>