<?php 
require('conexion2.php');
$detalle = $_GET['det'];
$exportar = $_GET['exp'];

switch($detalle){
	case "ra":
		$consulta = mysql_query("Select * From Requisiciones where status = 'Aprobada'");
		$titulo = "Aprobada";
		break;
		
	case "re":
		$consulta = mysql_query("Select * From Requisiciones where status = 'En Proceso'");
		$titulo = "En Proceso";
		break;
	
	case "rp":	
		$consulta = mysql_query("Select * From Requisiciones where status = 'Pedido'");
		$titulo = "Pedido";
		break;
	
	case "rc":
		$consulta = mysql_query("Select * From Requisiciones where status = 'Cerrada'");
		$titulo = "Cerrada";
		break;
		
	case "ar":
		$consulta = mysql_query("Select * From Requisiciones where status = 'En Proceso' and date_Add(fecha, interval 3 day) < NOW()");
		$titulo = "Requisiciones sin OC";
		break;
	
	case "oclsr":
		$consulta = mysql_query("select * FROM Orden_Compra WHERE cant_solicitada != cant_recibida and status = 'Liberada'");
		$titulo = "Liberada - Sin Recepcion";
		break;
		
	case "oclrp":
		$consulta = mysql_query("select * FROM Orden_Compra WHERE cant_recibida > 0 and status = 'Liberada'");
		$titulo = "Liberada - Recepcion parcial";
		break;
		
	case "occe":	
		$consulta = mysql_query("Select * From Orden_Compra where status = 'Cerrada'");
		$titulo = "Cerrada";
		break;
		
	case "occa":	
		$consulta = mysql_query("Select * From Orden_Compra where status = 'Cancelada'");
		$titulo = "Cancelada";
		break;
		
	case "aoc":
		$consulta = mysql_query("select * FROM Orden_Compra WHERE date_Add(fecha_oc, interval 5 day) < NOW() and status = 'Liberada'");
		$titulo = "Ordenes de compra atrasadas";
		break;	
}

if($exportar){	
	$asdasd = header("Pragma: public");
	$asdasd .= header("Expires: 0");
	$filename = "DetalleAbastecimiento.xls";
	$asdasd .= header("Content-type: application/x-msdownload");
	$asdasd .= header("Content-Disposition: attachment; filename=$filename");
	$asdasd .= header("Pragma: no-cache");
	$asdasd .= header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
	$exportar =false;
}

echo $asdasd;


if($detalle == "ra" || $detalle == "re" || $detalle == "rp" || $detalle == "rc" || $detalle == "ar"){
?>	

<table>	
	<tr>
		<th>N rep</th>
		<th>Codigo Proveedor</th>
		<th>Nombre</th>
		<th>Fecha</th>
		<th>Linea</th>
		<th>Codigo</th>
		<th>Descripcion</th>
		<th>UM</th>
		<th>Cant Conv</th>
		<th>Cant Inv</th>
		<th>Total Linea</th>
		<th>Status</th>
	</tr>
	<?php 						
		while($array = mysql_fetch_array($consulta)){
			echo "<tr>";
			echo "<td>".$array[1]."</td><td>".$array[2]."</td><td>".$array[3]."</td><td>".$array[4]."</td><td>".$array[5]."</td><td>".$array[6]."</td><td>".$array[7]."</td><td>".$array[8]."</td><td>".$array[9]."</td><td>".$array[10]."</td><td>".$array[11]."</td><td>".$array[12]."</td>";
			echo "</tr>";
		}
	?>
</table>

<?php
	}
	
	if($detalle == "oclrp" || $detalle == "oclsr" || $detalle == "occe" || $detalle == "occa" || $detalle == "aoc"){
		
?>

<table>	
	<tr>
		<th>OC</th>
		<th>Nota de venta</th>
		<th>Codigo provee</th>
		<th>Nombre provee</th>
		<th>Fecha OC</th>
		<th>In</th>
		<th>Codigo</th>
		<th>Descripcion</th>
		<th>UM</th>
		<th>Cant Solicitada</th>
		<th>Cant Recibida</th>
		<th>Precio unitario</th>
		<th>Total linea</th>
		<th>Status</th>
		<th>OT</th>
		<th>Lote</th>
	</tr>
	<?php 						
		while($array = mysql_fetch_array($consulta)){
			echo "<tr>";
			echo "<td>".$array[1]."</td><td>".$array[2]."</td><td>".$array[3]."</td><td>".$array[4]."</td><td>".$array[5]."</td><td>".$array[6]."</td><td>".$array[7]."</td><td>".$array[8]."</td><td>".$array[9]."</td><td>".$array[10]."</td><td>".$array[11]."</td><td>".$array[12]."</td>"."<td>".$array[13]."</td>"."<td>".$array[14]."</td>"."<td>".$array[15]."</td>"."<td>".$array[16]."</td>";
			echo "</tr>";
		}
	?>
</table>
<?php
}
?>