79 lines
2.3 KiB
PHP
Executable File
79 lines
2.3 KiB
PHP
Executable File
<?php
|
|
|
|
include_once('../init.php');
|
|
include_once('../config.php');
|
|
include_once(DOC_ROOT.'/libraries.php');
|
|
|
|
$Usr = $user->Info();
|
|
|
|
extract($_POST);
|
|
|
|
$proveedor->setProveedorId($_POST['proveedorId2']);
|
|
$proveedores = $proveedor->SearchSaldos($_POST['saldoIni2']);
|
|
|
|
$x .= "<table border=\"1\">
|
|
<thead>
|
|
<tr>
|
|
<th style=\"background:#CCC;text-align:center\" colspan=\"5\">
|
|
<b>SALDOS INICIALES PROVEEDORES</b>
|
|
</th>
|
|
</tr>
|
|
<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>Saldo Inicial</b></th>
|
|
<th style=\"background:#E0E5E7;text-align:center\"><b>Abonos</b></th>
|
|
<th style=\"background:#E0E5E7;text-align:center\"><b>Saldo Actual</b></th>
|
|
</tr>
|
|
</thead>
|
|
<tbody>";
|
|
|
|
$total = 0;
|
|
foreach($proveedores as $res){
|
|
|
|
//Obtenemos los abonos realizados
|
|
$cuentaPagar->setProveedorId($res['proveedorId']);
|
|
$res['abonos'] = $cuentaPagar->GetTotalPagosProv();
|
|
|
|
$res['saldoActual'] = $res['saldoCtaPagar'] - $res['abonos'];
|
|
|
|
|
|
$x .= "
|
|
<tr>
|
|
<td style=\"text-align:center;\">".$res['noProv']."</td>
|
|
<td style=\"text-align:left;\">".$res['nombre']."</td>
|
|
<td style=\"text-align:right;\">$".number_format($res['saldoCtaPagar'],2)."</td>
|
|
<td style=\"text-align:right;\">$".number_format($res['abonos'],2)."</td>
|
|
<td style=\"text-align:right;\">$".number_format($res['saldoActual'],2)."</td>
|
|
</tr>";
|
|
|
|
$total += $res['saldoCtaPagar'];
|
|
$totalAbonos += $res['abonos'];
|
|
$totalSaldoActual += $res['saldoActual'];
|
|
|
|
}//foreach
|
|
|
|
$x .= "
|
|
<tr>
|
|
<td style=\"text-align:center;\"></td>
|
|
<td style=\"text-align:center;\"><b>TOTAL</b></td>
|
|
<td style=\"text-align:right;\"><b>$".number_format($total,2)."</b></td>
|
|
<td style=\"text-align:right;\"><b>$".number_format($totalAbonos,2)."</b></td>
|
|
<td style=\"text-align:right;\"><b>$".number_format($totalSaldoActual,2)."</b></td>
|
|
</tr>";
|
|
|
|
$x .= "
|
|
</tbody>
|
|
</table>";
|
|
|
|
$name = 'Saldos_Iniciales_Prov';
|
|
|
|
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;
|
|
|
|
?>
|