<?php
require_once("connecion.php");
?>
<!DOCTYPE HTML>
<html lang="es">
<head>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
<meta http-equiv="refresh" content="120" /> <!-- Tiempo que tarda la pagina en recargarse -->
<!--<link rel="stylesheet" href="css/base.css">-->
<link rel="stylesheet" href="css/estilos.css">
<title>Atrasos de proveedores</title>
<link rel="shortcut icon" type="image/x-icon" href="img/favicon.ico">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<style type="text/css"></style>
</head>
<body>
<?php include('inc/header.php') ?>
<!-- llama al menu desde la carpeta inc -->
<?php include('inc/menu.php') ?>
<div class="contenedor fondo-blanco relleno-8 borde-gris" style="min-height: 700px">
<!--Cada fila contiene 12 columnas, 12 es igual a 100% -->
<div class="fila">
 
<div class="columna columna-m-12 columna-g-12" align="center">
<marquee direction="down" width="1200" height="822" behavior="alternate" style="border:solid" scrollamount="10">
<table border="1px" align="center" colspan="1">
<tr colspan="1">
<td align="center"><b>Proveedor</td>
<td align="center"><b>  OC  </td>
<td align="center"><b>Atraso  </td>
<td align="center"><b>Descripcion</td>
<td align="center"><b>Pend.</td>
<td align="center"><b>Cant.</td>
<td align="center"><b>Contacto</td>
<!-- <td>Contacto</td> -->
</tr>
<?php
$sql="SELECT TOP (100) PERCENT T0.DocNum AS OC, T0.CardName AS Proveedor, T1.ItemCode, T1.Dscription AS Descripcion, T1.Quantity AS Cantidad, T1.OpenQty AS Pendiente,
CASE WHEN T1.[LineStatus] = 'C'
THEN 0 ELSE CAST(getdate()
- T1.[ShipDate] AS int) END AS Atraso, T2.Name + ' tel:' + ISNULL(T2.Tel1, '') + ' cel:' + ISNULL(T2.Cellolar, '') + ' mail:' + ISNULL(T2.E_MailL, '') AS Contacto
FROM dbo.OPOR AS T0 INNER JOIN
dbo.POR1 AS T1 ON T0.DocEntry = T1.DocEntry
LEFT OUTER JOIN
dbo.OCPR AS T2 ON T0.CardCode = T2.CardCode
AND T0.CntctCode = T2.CntctCode
WHERE (T0.CANCELED = 'n')
AND (T0.DocType = 'i') AND (T0.DocStatus = 'o')
AND (LEFT(T1.ItemCode, 4) <> 'SUMO')
AND (LEFT(T1.ItemCode, 2) <> 'AD')
AND (LEFT(T1.ItemCode, 4) <> 'SUSE')
AND (T1.LineStatus = 'o') AND
(CAST(GETDATE() - T1.ShipDate AS int) >= '0')
ORDER BY Proveedor, OC, T1.LineNum";
$result=sqlsrv_query($conn,$sql);
while($mostrar=sqlsrv_fetch_array($result)){
?>
<tr>
<td><?php echo $mostrar['Proveedor']?></td>
<td align="center"><?php echo $mostrar['OC']?></td>
<td align="center"><?php echo $mostrar['Atraso']?></td>
<td><?php echo $mostrar['Descripcion']?></td>
<td align="center"><?php echo $mostrar['Pendiente']-.0000?></td>
<td align="center"><?php echo $mostrar['Cantidad']-.0000?></td>
<td><?php echo $mostrar['Contacto']?></td>
<td align="center">
<?php if ($mostrar['atraso']<2 )
{
echo '<img src="verde.png" alt="">';
} else {
echo '<img src="rojo.png" alt="">';
}
?>
</td>
</tr>
<?php
}
?>
</table>
</marquee>
</div>
</div>
</div>
</div>
<!-- llama al menu desde la carpeta inc -->
<?php include('inc/footer.php') ?>
</body>
</html>