126 lines
3.7 KiB
PHP
Executable File
126 lines
3.7 KiB
PHP
Executable File
<?php
|
|
|
|
include_once('../init.php');
|
|
include_once('../config.php');
|
|
include_once(DOC_ROOT.'/libraries.php');
|
|
|
|
$name = "reporte_faltantes";
|
|
|
|
extract($_POST);
|
|
|
|
$proveedorId = $_POST['proveedorId'];
|
|
|
|
$reportes->setProveedorId($proveedorId);
|
|
$resProvs = $reportes->EnumAllProv();
|
|
|
|
if($proveedorId)
|
|
$sqlAdd = ' AND proveedorId = "'.$proveedorId.'"';
|
|
|
|
$sql = 'SELECT proveedorId, noProv, nombre FROM proveedor
|
|
WHERE baja = "0" '.$sqlAdd.'
|
|
ORDER BY nombre ASC';
|
|
$util->DBSelect($_SESSION['empresaId'])->setQuery($sql);
|
|
$resProvs = $util->DBSelect($_SESSION['empresaId'])->GetResult();
|
|
|
|
$total = 0;
|
|
foreach($resProvs as $val){
|
|
|
|
$reportes->setProveedorId($val['proveedorId']);
|
|
|
|
$sql = "SELECT e.sucursalId, s.nombre AS sucursal
|
|
FROM envioRecibir er, envio e, producto p, sucursal s
|
|
WHERE e.envioId = er.envioId
|
|
AND e.sucursalId = s.sucursalId
|
|
AND er.productoId = p.productoId
|
|
AND p.proveedorId = '".$val['proveedorId']."'
|
|
AND er.faltantes > 0
|
|
GROUP BY e.sucursalId";
|
|
$util->DBSelect($_SESSION['empresaId'])->setQuery($sql);
|
|
$resSucursales = $util->DBSelect($_SESSION['empresaId'])->GetResult();
|
|
|
|
$sucursales = array();
|
|
foreach($resSucursales as $res){
|
|
|
|
$sql = "SELECT SUM(er.faltantes) AS faltantes, p.codigoBarra, p.modelo AS producto
|
|
FROM envioRecibir er, envio e, producto p
|
|
WHERE e.envioId = er.envioId
|
|
AND er.productoId = p.productoId
|
|
AND p.proveedorId = '".$val['proveedorId']."'
|
|
AND e.sucursalId = '".$res['sucursalId']."'
|
|
AND er.faltantes > 0
|
|
GROUP BY er.productoId";
|
|
$util->DBSelect($_SESSION['empresaId'])->setQuery($sql);
|
|
$res['productos'] = $util->DBSelect($_SESSION['empresaId'])->GetResult();
|
|
|
|
$sql = "SELECT SUM(er.faltantes)
|
|
FROM envioRecibir er, envio e, producto p
|
|
WHERE e.envioId = er.envioId
|
|
AND er.productoId = p.productoId
|
|
AND p.proveedorId = '".$val['proveedorId']."'
|
|
AND e.sucursalId = '".$res['sucursalId']."'
|
|
AND er.faltantes > 0";
|
|
$util->DBSelect($_SESSION['empresaId'])->setQuery($sql);
|
|
$total += $util->DBSelect($_SESSION['empresaId'])->GetSingle();
|
|
|
|
$sucursales[] = $res;
|
|
}
|
|
$val['sucursales'] = $sucursales;
|
|
|
|
$proveedores[] = $val;
|
|
}
|
|
|
|
$x.="<table border=\"1\">
|
|
<thead>
|
|
<tr>
|
|
<th style=\"background:#E0E5E7;text-align:center\"><b>No. Prov.</b></th>
|
|
<th style=\"background:#E0E5E7;text-align:center\"><b>Proveedor</b></th>
|
|
<th style=\"background:#E0E5E7;text-align:center\"><b>Codigo Barra</b></th>
|
|
<th style=\"background:#E0E5E7;text-align:center\"><b>Producto</b></th>
|
|
<th style=\"background:#E0E5E7;text-align:center\"><b>Sucursal</b></th>
|
|
<th style=\"background:#E0E5E7;text-align:center\"><b>Faltantes</b></th>
|
|
</tr>
|
|
</thead>
|
|
<tbody>";
|
|
|
|
foreach($proveedores as $prov){
|
|
|
|
foreach($prov['sucursales'] as $suc){
|
|
|
|
foreach($suc['productos'] as $prod){
|
|
|
|
$x .= "<tr>
|
|
<td>".$prov['noProv']."</td>
|
|
<td>".$prov['proveedor']."</td>
|
|
<td>".$prod['codigoBarra']."</td>
|
|
<td>".$prod['producto']."</td>
|
|
<td>".$suc['sucursal']."</td>
|
|
<td style=\"text-align:right;\">".$prod['faltantes']."</td>
|
|
</tr>";
|
|
|
|
}//foreach
|
|
|
|
}//foreach
|
|
|
|
}//foreach
|
|
|
|
$x .= '<tr>
|
|
<td></td>
|
|
<td></td>
|
|
<td></td>
|
|
<td></td>
|
|
<td><b>TOTAL</b></td>
|
|
<td align="right"><b>'.$total.'</b></td>
|
|
</tr>';
|
|
|
|
$x .= "</tbody>";
|
|
$x .= "</table>";
|
|
|
|
header("Content-Type: application/vnd.ms-excel; charset=utf-8");
|
|
header("Content-type: application/x-msexcel; charset=utf-8");
|
|
header("Content-Disposition: attachment; filename=".$name.".xls");
|
|
header("Pragma: no-cache");
|
|
header("Expires: 0");
|
|
|
|
echo $x;
|
|
|
|
?>
|