File: /home/austral3d/fourdplan.com/php/abastecimiento.php
<?php
//INICIO VARIABLE SESION0
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'];
}
require("conexion2.php");
//Requisiciones-------------------------------------------------------------------------------------------
$consulta_requisicion = mysql_query("Select id From Requisiciones");
$consulta_requisicion_Aprobadas = mysql_query("Select id From Requisiciones where status = 'Aprobada'");
$consulta_requisicion_en_proceso = mysql_query("Select id From Requisiciones where status = 'En Proceso'");
$consulta_requisicion_pedido = mysql_query("Select id From Requisiciones where status = 'Pedido'");
$consulta_requisicion_cerrada = mysql_query("Select id From Requisiciones where status = 'Cerrada'");
while($array = mysql_fetch_array($consulta_requisicion)){
$requisicion[] = $array['id'];
}
while($array1 = mysql_fetch_array($consulta_requisicion_Aprobadas)){
$requisicion_Aprobadas[] = $array1['id'];
}
while($array2 = mysql_fetch_array($consulta_requisicion_en_proceso)){
$requisicion_en_proceso[] = $array2['id'];
}
while($array3 = mysql_fetch_array($consulta_requisicion_pedido)){
$requisicion_pedido[] = $array3['id'];
}
while($array4 = mysql_fetch_array($consulta_requisicion_cerrada)){
$requisicion_cerrada[] = $array4['id'];
}
@$total_requisicion = count($requisicion);
@$total_requisicion_Aprobadas = count($requisicion_Aprobadas);
@$total_requisicion_en_proceso = count($requisicion_en_proceso);
@$total_requisicion_pedido = count($requisicion_pedido);
@$total_requisicion_cerrada = count($requisicion_cerrada);
//--------------------------------------------------------------------------------------------------------
$per_Aprobadas = ($total_requisicion_Aprobadas*100)/$total_requisicion;
$per_en_proceso = ($total_requisicion_en_proceso*100)/$total_requisicion;
$per_pedido = ($total_requisicion_pedido*100)/$total_requisicion;
$per_cerrada = ($total_requisicion_cerrada*100)/$total_requisicion;
//--------------------------------------------------------------------------------------------------------
$Aprobadas = round(number_format($per_Aprobadas,0,",","."),2);
$en_proceso = round(number_format($per_en_proceso,0,",","."),2);
$pedido = round(number_format($per_pedido,0,",","."),2);
$cerrada = round(number_format($per_cerrada,0,",","."),2);
//--------------------------------------------------------------------------------------------------------
$consulta_oc = mysql_query("Select id From Orden_Compra");
$consulta_oc_liberada = mysql_query("Select id From Orden_Compra where status = 'Liberada'");
$consulta_oc_cerrada = mysql_query("Select id From Orden_Compra where status = 'Cerrada'");
$consulta_oc_cancelada = mysql_query("Select id From Orden_Compra where status = 'Cancelada'");
//--------------------------------------------------------------------------------------------------------
while($arrayoc = mysql_fetch_array($consulta_oc)){
$oc[] = $arrayoc['id'];
}
//--------------------------------------------------------------------------------------------------------
while($arrayoc1 = mysql_fetch_array($consulta_oc_liberada)){
$oc_liberada[] = $arrayoc1['id'];
}
//--------------------------------------------------------------------------------------------------------
while($arrayoc2 = mysql_fetch_array($consulta_oc_cerrada)){
$oc_cerrada[] = $arrayoc2['id'];
}
//--------------------------------------------------------------------------------------------------------
while($arrayoc3 = mysql_fetch_array($consulta_oc_cancelada)){
$oc_cancelda[] = $arrayoc3['id'];
}
//--------------------------------------------------------------------------------------------------------
$total_oc = count($oc);
$total_oc_liberada = count($oc_liberada);
$total_oc_cerrada = count($oc_cerrada);
$total_oc_cancelada = count($oc_cancelda);
//--------------------------------------------------------------------------------------------------------
$per_oc_liberada = ($total_oc_liberada*100)/$total_oc;
$per_oc_cerrada = ($total_oc_cerrada*100)/$total_oc;
$per_oc_cancelada = ($total_oc_cancelada*100)/$total_oc;
//--------------------------------------------------------------------------------------------------------
$liberada_oc = round(number_format($per_oc_liberada,0,",","."),2);
$cerrada_oc = round(number_format($per_oc_cerrada,0,",","."),2);
$cancelada_oc = round(number_format($per_oc_cancelada,0,",","."),2);
//--------------------------------------------------------------------------------------------------------
$consulta_liberada_s_parcial = mysql_query("select cant_solicitada, cant_recibida from Orden_Compra where status = 'Liberada'");
//--------------------------------------------------------------------------------------------------------
$lbsinr = 0;
while($arraylb = mysql_fetch_array($consulta_liberada_s_parcial)){
$nu_lb[] = $arraylb[0];
$resta = $arraylb[0] - $arraylb[1];
if($resta > 0){
$lbsinr +=1;
}
}
//--------------------------------------------------------------------------------------------------------
$consulta_liberada_parcial = mysql_query("select cant_recibida from Orden_Compra where cant_recibida > 0 and status = 'Liberada'");
while($arraylbrp = mysql_fetch_array($consulta_liberada_parcial)){
$nu_lbrp[] = $arraylbrp[0];
}
//--------------------------------------------------------------------------------------------------------
$lbrep = count($nu_lbrp);
$total_nu_lb = count($nu_lb);
$per_nu_lbsr = ($lbsinr*100)/$total_oc;
$per_nu_lbrp = ($lbrep*100)/$total_oc;
$lbsr_per = round(number_format($per_nu_lbsr,0,",","."),2);
$lbrp_per = round(number_format($per_nu_lbrp,0,",","."),2);
//nota de venta------------------------------------------------------------------
$notasdeventa = mysql_query("select nota_de_venta from Orden_Compra group by nota_de_venta");
while($arraynt = mysql_fetch_array($notasdeventa)){
$nota_venta[] = $arraynt['nota_de_venta'];
}
$totalnt = count($nota_venta);
//alarmas requisicion------------------------------------------------------------------
$consultara = mysql_query("Select * From Requisiciones where status = 'En Proceso' and date_Add(fecha, interval 3 day) < NOW()");
while($ara = mysql_fetch_array($consultara)){
$bra[] = $ara[0];
}
$alarmas = count($bra);
$alarma_requisiciones = mysql_query("SELECT fecha FROM Requisiciones WHERE status = 'En proceso'");
while($arrayfechas = mysql_fetch_array($alarma_requisiciones)){
$fechas[] = $arrayfechas[0];
}
$totalfoc = count($fechas);
if(!empty($alarmas)){
$per_ar = ($alarmas*100)/$totalfoc;
}else{
$per_ar = 0;
}
$alarma_oc = mysql_query("SELECT fecha_oc FROM Orden_Compra WHERE status = 'Liberada'");
while($arrayfechasoc = mysql_fetch_array($alarma_oc)){
$fechasoc[] = $arrayfechasoc[0];
}
$consulta1 = mysql_query("select * FROM Orden_Compra WHERE date_Add(fecha_oc, interval 5 day) < NOW() and status = 'Liberada'");
while($a = mysql_fetch_array($consulta1)){
$b[] = $a[0];
}
$alarmasoc = count($b);
$totalfoc1 = count($fechasoc);
if(!empty($alarmasoc)){
$per_aroc = ($alarmasoc*100)/$totalfoc1;
}else{
$per_aroc = 0;
}
?>
<!DOCTYPE html>
<html>
<head>
<title>Fourdplan</title>
<link href="../css/bootstrap.min.css" rel="stylesheet">
<meta charset="UTF-8">
<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">
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.2/jquery.min.js"></script>
</head>
<body>
<div class="content">
<!-- menu barra negra superior -->
<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){
?>
<div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
<ul class="nav navbar-nav">
<li><a href="../index.php?lenguaje=true"><span class="glyphicon glyphicon-home" aria-hidden="true"></span> Inicio</a></li>
</ul>
<!--Derecha barra-->
<ul class="nav navbar-nav navbar-right">
<?php //require("../php/barrasuperior.php");?>
<!--li role="presentation"><a href="#"> <span class="label label-primary">(0) <img src="../img/correo.png" /></span></a></li-->
<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.php">Cerrar sesion</a></li>
<li><a href="proyecto.php">Ingles</a></li>
</ul>
</li>
</ul>
</div><!-- /.navbar-collapse -->
<?php
}else{
?>
<div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
<ul class="nav navbar-nav">
<li><a href="../index.php"><span class="glyphicon glyphicon-home" aria-hidden="true"></span> Home</a></li>
</ul>
<!--Derecha barra-->
<ul class="nav navbar-nav navbar-right">
<?php //require("../php/barrasuperior.php");?>
<!--li role="presentation"><a href="#"> <span class="label label-primary">(0) <img src="../img/correo.png" /></span></a></li-->
<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.php">Log Out</a></li>
<li><a href="proyecto.php?lenguaje=true">Spanish</a></li>
</ul>
</li>
</ul>
</div>
<?php
}
?>
</div><!-- /.container-fluid -->
</nav>
<br><br><br><br>
<div class="container-fluid">
<div class="container">
<div class="panel panel-primary">
<div class="panel-heading">
<center><h4> ABASTECIMIENTO</h4></center>
</div>
</div>
</div>
<div class="container">
<div style="width:101.5%;">
<div class="list-group col-xs-12 col-md-4">
<div class="panel panel-primary">
<div class="panel-heading"><center><h4 class="panel-title">Nota de Venta</h4></center></div>
<div class="panel-body">
<center><h1><?php echo $totalnt;?></h1></center>
Emitidos
</div>
</div>
</div>
<div class="list-group col-xs-12 col-md-4">
<div class="panel panel-primary">
<div class="panel-heading"><center><h4 class="panel-title">Requisiciones</h4></center></div>
<div class="panel-body">
<center><h1><?php echo $total_requisicion;?></h1></center>
Emitidos
</div>
<ul class="list-group">
<li class="list-group-item">
<div style="text-align:center;margin:0 auto;width:100%;">
<div style="width: 45%; float: left;margin:0px 0px 0px 0px;text-align:left;">
<a href="detalle.php?det=ra">Aprobadas</a>
</div>
<div style="width: 35%; float: left;margin:0px 0px 0px 0px;text-align:center;">
<?php echo $total_requisicion_Aprobadas;?>
</div>
<div style="width: 20%; float: left;margin:0px 0px 0px 0px;text-align:right;">
<?php echo $Aprobadas;?>%
</div>
<div style="clear: both;"/>
</div>
</li>
<li class="list-group-item">
<div style="text-align:center;margin:0 auto;width:100%;">
<div style="width: 45%; float: left;margin:0px 0px 0px 0px;text-align:left;">
<a href="detalle.php?det=re">En proceso</a>
</div>
<div style="width: 35%; float: left;margin:0px 0px 0px 0px;text-align:center;">
<?php echo $total_requisicion_en_proceso;?>
</div>
<div style="width: 20%; float: left;margin:0px 0px 0px 0px;text-align:right;">
<?php echo $en_proceso;?>%
</div>
<div style="clear: both;"/>
</div>
</li>
<li class="list-group-item">
<div style="text-align:center;margin:0 auto;width:100%;">
<div style="width: 45%; float: left;margin:0px 0px 0px 0px;text-align:left;">
<a href="detalle.php?det=rp">Pedido</a>
</div>
<div style="width: 35%; float: left;margin:0px 0px 0px 0px;text-align:center;">
<?php echo $total_requisicion_pedido;?>
</div>
<div style="width: 20%; float: left;margin:0px 0px 0px 0px;text-align:right;">
<?php echo $pedido;?>%
</div>
<div style="clear: both;"/>
</div>
</li>
<li class="list-group-item">
<div style="text-align:center;margin:0 auto;width:100%;">
<div style="width: 45%; float: left;margin:0px 0px 0px 0px;text-align:left;">
<a href="detalle.php?det=rc">Cerrada</a>
</div>
<div style="width: 35%; float: left;margin:0px 0px 0px 0px;text-align:center;">
<?php echo $total_requisicion_cerrada;?>
</div>
<div style="width: 20%; float: left;margin:0px 0px 0px 0px;text-align:right;">
<?php echo $cerrada;?>%
</div>
<div style="clear: both;"/>
</div>
</li>
<li <?php if($alarmas > 0){echo 'class="list-group-item list-group-item-danger"';}else{echo 'class="list-group-item"';}?>>
<div style="text-align:center;margin:0 auto;width:100%;">
<div style="width: 45%; float: left;margin:0px 0px 0px 0px;text-align:left;">
<a href="detalle.php?det=ar"> AR (1) </a> <?php if($alarmas > 0){echo '<img src="../img/alarma.png" style="float: right;"/>';}?>
</div>
<div style="width: 35%; float: left;margin:0px 0px 0px 0px;text-align:center;">
<?php echo $alarmas;?>
</div>
<div style="width: 20%; float: left;margin:0px 0px 0px 0px;text-align:right;">
<?php echo round($per_ar,1);?>%
</div>
<div style="clear: both;"/>
</div>
</li>
</ul>
</div>
</div>
<div class="list-group col-xs-12 col-md-4">
<div class="panel panel-primary">
<div class="panel-heading"><center><h4 class="panel-title">Ordenes de Compra</h4></center></div>
<div class="panel-body">
<center><h1><?php echo $total_oc;?></h1></center>
Emitidos
</div>
<ul class="list-group">
<!--li class="list-group-item">
<div style="text-align:center;margin:0 auto;width:100%;">
<div style="width: 45%; float: left;margin:0px 0px 0px 0px;text-align:left;">
Liberada
</div>
<div style="width: 35%; float: left;margin:0px 0px 0px 0px;text-align:center;">
<?php //echo $total_oc_liberada;?>
</div>
<div style="width: 20%; float: left;margin:0px 0px 0px 0px;text-align:right;">
<?php //echo $liberada_oc;?>%
</div>
<div style="clear: both;"/>
</div>
</li-->
<li class="list-group-item">
<div style="text-align:center;margin:0 auto;width:100%;">
<div style="width: 45%; float: left;margin:0px 0px 0px 0px;text-align:left;">
<a <a href="detalle.php?det=oclsr">Liberada - sin recepcion</a>
</div>
<div style="width: 35%; float: left;margin:0px 0px 0px 0px;text-align:center;">
<?php echo $lbsinr;?>
</div>
<div style="width: 20%; float: left;margin:0px 0px 0px 0px;text-align:right;">
<?php echo $lbsr_per;?>%
</div>
<div style="clear: both;"/>
</div>
</li>
<li class="list-group-item">
<div style="text-align:center;margin:0 auto;width:100%;">
<div style="width: 45%; float: left;margin:0px 0px 0px 0px;text-align:left;">
<a href="detalle.php?det=oclrp">Liberada - recepcion parcial</a>
</div>
<div style="width: 35%; float: left;margin:0px 0px 0px 0px;text-align:center;">
<?php echo $lbrep;?>
</div>
<div style="width: 20%; float: left;margin:0px 0px 0px 0px;text-align:right;">
<?php echo $lbrp_per;?>%
</div>
<div style="clear: both;"/>
</div>
</li>
<li class="list-group-item">
<div style="text-align:center;margin:0 auto;width:100%;">
<div style="width: 45%; float: left;margin:0px 0px 0px 0px;text-align:left;">
<a href="detalle.php?det=occe">Cerrada</a>
</div>
<div style="width: 35%; float: left;margin:0px 0px 0px 0px;text-align:center;">
<?php echo $total_oc_cerrada;?>
</div>
<div style="width: 20%; float: left;margin:0px 0px 0px 0px;text-align:right;">
<?php echo $cerrada_oc;?>%
</div>
<div style="clear: both;"/>
</div>
</li>
<li class="list-group-item">
<div style="text-align:center;margin:0 auto;width:100%;">
<div style="width: 45%; float: left;margin:0px 0px 0px 0px;text-align:left;">
<a href="detalle.php?det=occa">Cancelada</a>
</div>
<div style="width: 35%; float: left;margin:0px 0px 0px 0px;text-align:center;">
<?php echo $total_oc_cancelada;?>
</div>
<div style="width: 20%; float: left;margin:0px 0px 0px 0px;text-align:right;">
<?php echo $cancelada_oc;?>%
</div>
<div style="clear: both;"/>
</div>
</li>
<li <?php if($alarmasoc > 0){echo 'class="list-group-item list-group-item-danger"';}else{echo 'class="list-group-item"';}?>>
<div style="text-align:center;margin:0 auto;width:100%;">
<div style="width: 45%; float: left;margin:0px 0px 0px 0px;text-align:left;">
<a href="detalle.php?det=aoc"> AOC (2)</a><?php if($alarmasoc > 0){echo '<img src="../img/alarma.png" style="float: right;"/>';}?>
</div>
<div style="width: 35%; float: left;margin:0px 0px 0px 0px;text-align:center;">
<?php echo $alarmasoc;?>
</div>
<div style="width: 20%; float: left;margin:0px 0px 0px 0px;text-align:right;">
<?php echo round($per_aroc,1);?>%
</div>
<div style="clear: both;"/>
</div>
</li>
</ul>
</div>
</div>
</div>
</div>
<div class="container">
<br>
<div>
<div class="list-group col-xs-12 col-md-4">
</div>
<div class="list-group col-xs-12 col-md-4">
<p>(1) Alarma de Requisiciones sin ordenes de compra mayores a 3 días.</p>
</div>
<div class="list-group col-xs-12 col-md-4">
<p>(2) Alarma de ordenes de compra atrasadas de recepción de mercadería mayor a 5 días sobre la emisión.</p>
</div>
</div>
</div>
</div>
</div>
<!-- pie de pagina-->
<div><?php require("../php/pie.php");?><div>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>
<script src="../js/bootstrap.min.js"></script>
<script src="../js/highcharts.js"></script>
<script src="../js/modules/exporting.js"></script>
<script src="../js/modules/data.js"></script>
</body>
</html>