File: /home/austral3d/fourdplan.com/php/detalle.php
<?php
require('conexion2.php');
session_start();
if ($_SESSION == NULL ){
session_destroy();
echo'<script>
alert("Acceso denegado.")
self.location = "../index.php"
</script>';
}
if(empty($_GET['lenguaje'])){
$lenguaje = false;
}else{
$lenguaje = $_GET['lenguaje'];
}
$detalle = $_GET['det'];
switch($detalle){
case "ra":
$consulta = mysql_query("Select * From Requisiciones where status = 'Aprobada'");
$consulta1 = mysql_query("Select * From Requisiciones where status = 'Aprobada'");
$titulo = "Aprobada";
break;
case "re":
$consulta = mysql_query("Select * From Requisiciones where status = 'En Proceso'");
$consulta1 = mysql_query("Select * From Requisiciones where status = 'En Proceso'");
$titulo = "En Proceso";
break;
case "rp":
$consulta = mysql_query("Select * From Requisiciones where status = 'Pedido'");
$consulta1 = mysql_query("Select * From Requisiciones where status = 'Pedido'");
$titulo = "Pedido";
break;
case "rc":
$consulta = mysql_query("Select * From Requisiciones where status = 'Cerrada'");
$consulta1 = 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()");
$consulta1 = 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'");
$consulta1 = 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'");
$consulta1 = 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'");
$consulta1 = mysql_query("Select * From Orden_Compra where status = 'Cerrada'");
$titulo = "Cerrada";
break;
case "occa":
$consulta = mysql_query("Select * From Orden_Compra where status = 'Cancelada'");
$consulta1 = 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'");
$consulta1 = mysql_query("select * FROM Orden_Compra WHERE date_Add(fecha_oc, interval 5 day) < NOW() and status = 'Liberada'");
$titulo = "Ordenes de compra atrasadas";
break;
}
$asd = mysql_fetch_array($consulta1);
?>
<!DOCTYPE html>
<html>
<head>
<title>Fourdplan</title>
<meta charset="UTF-8">
<link href="../css/bootstrap.min.css" rel="stylesheet">
<link href="../css/sti.css" rel="stylesheet">
<link rel="icon" href="../img/fdp.ico">
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no">
<style type="text/css">
.scrollable-menu {
height: auto;
max-height: 200px;
overflow-x: hidden;
}
</style>
</head>
<body>
<div class="content">
<nav class="navbar navbar-inverse navbar-fixed-top">
<div class="container-fluid">
<!-- Brand and toggle get grouped for better mobile display -->
<div class="navbar-header">
<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1" aria-expanded="false">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand" ><img src="../img/logo90x19.png" class="img"/></a>
</div>
<?php
if($lenguaje){
?>
<!-- Collect the nav links, forms, and other content for toggling -->
<div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
<ul class="nav navbar-nav">
<!-- menu Proyecto -->
<li><a href="../index.php?lenguaje=true"><span class="glyphicon glyphicon-home" aria-hidden="true"></span> Inicio<span class="sr-only">(current)</span></a></li>
</ul>
<!--Derecha barra-->
<ul class="nav navbar-nav navbar-right">
<?php require("barrasuperior.php");?>
<li role="presentation"><a><span class="glyphicon glyphicon-user" aria-hidden="true"></span> <?php if($_SESSION){echo $_SESSION['nombre'];}?></a></li>
<li class="dropdown">
<a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false"><span class="glyphicon glyphicon-list" aria-hidden="true"></span><span class="caret"></span></a>
<ul class="dropdown-menu">
<li><a href="cerrar_session.php">Cerrar sesion</a></li>
<li><a href="datos.php?proy=<?php echo $proy;?>&asse=<?php echo $asse;?>&des=<?php echo $des;?>&ele=<?php echo $ele;?>&int=<?php echo $inst;?>">Ingles</a></li>
</ul>
</li>
</ul>
</div>
<?php
}else{
?>
<div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
<ul class="nav navbar-nav">
<!-- menu Proyecto -->
<li><a href="abastecimiento.php">Back<span class="sr-only">(current)</span></a></li>
</ul>
<!--Derecha barra-->
<ul class="nav navbar-nav navbar-right">
<?php require("barrasuperior.php");?>
<li role="presentation"><a><span class="glyphicon glyphicon-user" aria-hidden="true"></span> <?php if($_SESSION){echo $_SESSION['nombre'];}?></a></li>
<li class="dropdown">
<a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false"><span class="glyphicon glyphicon-list" aria-hidden="true"></span><span class="caret"></span></a>
<ul class="dropdown-menu">
<li><a href="cerrar_session.php">Log Out</a></li>
<li><a href="datos.php?proy=<?php echo $proy;?>&asse=<?php echo $asse;?>&des=<?php echo $des;?>&ele=<?php echo $ele;?>&int=<?php echo $inst;?>&lenguaje=true">Spanish</a></li>
</ul>
</li>
</ul>
</div>
<?php
}
?>
<!-- /.navbar-collapse -->
</div><!-- /.container-fluid -->
</nav>
<br><br><br><br>
<?php
if(!empty($asd)){
if($detalle == "ra" || $detalle == "re" || $detalle == "rp" || $detalle == "rc" || $detalle == "ar"){
?>
<div class="container">
<div class="panel panel-primary">
<div class="panel-heading">
<center><h4> <?php echo "Detalle de la busqueda: ".$titulo;?></h4></center>
</div>
</div>
</div>
<div class="container">
<center><a class="btn btn-success" href="detallexcel.php?det=<?php echo $detalle;?>&exp=true" role="button">Descargar Excel</a></center>
<br>
</div>
<div class="container">
<table class="table">
<tr bgcolor="#337ab7">
<th><font color="#fff">N rep</font></th>
<th><font color="#fff">Codigo Proveedor</font></th>
<th><font color="#fff">Nombre</font></th>
<th><font color="#fff">Fecha</font></th>
<th><font color="#fff">Linea</font></th>
<th><font color="#fff">Código</font></th>
<th><font color="#fff">Descripción</font></th>
<th><font color="#fff">UM</font></th>
<th><font color="#fff">Cant Conv</font></th>
<th><font color="#fff">Cant Inv</font></th>
<th><font color="#fff">Total Linea</font></th>
<th><font color="#fff">Status</font></th>
</tr>
<?php
while($array = mysql_fetch_array($consulta)){
echo '<tr bgcolor="#ffffff">';
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>
</div>
<?php
}
if($detalle == "oclrp" || $detalle == "oclsr" || $detalle == "occe" || $detalle == "occa" || $detalle == "aoc"){
?>
<div class="container">
<div class="panel panel-primary">
<div class="panel-heading">
<center><h4> <?php echo "Detalle de la busqueda: ".$titulo;?></h4></center>
</div>
</div>
</div>
<div class="container">
<center><a class="btn btn-success" href="detallexcel.php?det=<?php echo $detalle;?>&exp=true" role="button">Descargar Excel</a></center>
<br>
</div>
<div class="container-fluid">
<table class="table">
<tr bgcolor="#337ab7">
<th><font color="#fff">OC</font></th>
<th><font color="#fff">Nota de venta</font></th>
<th><font color="#fff">Codigo provee</font></th>
<th><font color="#fff">Nombre provee</font></th>
<th><font color="#fff">Fecha OC</font></th>
<th><font color="#fff">In</font></th>
<th><font color="#fff">Codigo</font></th>
<th><font color="#fff">Descripcion</font></th>
<th><font color="#fff">UM</font></th>
<th><font color="#fff">Cant Solicitada</font></th>
<th><font color="#fff">Cant Recibida</font></th>
<th><font color="#fff">Precio unitario</font></th>
<th><font color="#fff">Total linea</font></th>
<th><font color="#fff">Status</font></th>
<th><font color="#fff">OT</font></th>
<th><font color="#fff">Lote</font></th>
</tr>
<?php
while($array = mysql_fetch_array($consulta)){
echo '<tr bgcolor="#ffffff">';
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>
</div>
<?php
}
}else{
echo '<div class="container">
<div class="panel panel-primary">
<div class="panel-heading">
<center><h4>No se encontaron datos.</h4></center>
</div>
</div>
</div>';
}
?>
<br>
<br>
<br>
</div>
<!-- pie de pagina-->
<?php require("pie.php");?>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>
<script src="../js/bootstrap.min.js"></script>
<!--<script type="text/javascript" src="../js/functions.js"></script>-->
<!--<script type="text/javascript" src="../js/jquery.js"></script>-->
</body>
</html>