function reporteStockValorizado()
{
$idLinea = $_REQUEST['linea'];
$idSubLinea = $_REQUEST['sublinea'];
$reporte = new Reporte();
$data = $reporte->reporteStockValorizado($idLinea, $idSubLinea);
$total = 0;
for ($i = 0; $i < count($data); $i++) {
echo '<tr>';
echo "<td>" . $data[$i]['codigo'] . "</td>";
echo "<td>" . $data[$i]['nompro'] . "</td>";
echo "<td>" . $data[$i]['idalmacen'] . "</td>";
echo "<td>" . $data[$i]['idlineapadre'] . "</td>";
echo "<td>" . $data[$i]['nomum'] . "</td>";
echo "<td>" . $data[$i]['stockactual'] . "</td>";
echo '<td class="right">' . number_format($data[$i]['preciolista'], 2) . '</td>';
echo '<td class="right">' . number_format($data[$i]['stockactual'] * $data[$i]['preciolista'], 2) . '</td>';
echo '<tr>';
$total += $data[$i]['stockactual'] * $data[$i]['preciolista'];
}
echo '<tr style="font-weight:bold"><td colspan="6"></td><td class="right">Total:</td><td class="right">' . number_format($total, 2) . '</td></tr>';
}
function reporteStockValorizado()
{
if (count($_REQUEST) == 6) {
$linea = new Linea();
$data['Linea'] = $linea->listadoLineas("idpadre=0");
$this->view->show("/reporte/stockvalorizado.phtml", $data);
} else {
$idLinea = $_REQUEST['linea'];
$idSubLinea = $_REQUEST['sublinea'];
$reporte = new Reporte();
$data = $reporte->reporteStockValorizado($idLinea, $idSubLinea);
$total = 0;
$data2 = array();
for ($i = 0; $i < count($data); $i++) {
$data2[$i]['codigo'] = $data[$i]['codigop'];
$data2[$i]['nompro'] = $data[$i]['nompro'];
$data2[$i]['nomalm'] = $data[$i]['nomalm'];
$data2[$i]['nomlin'] = $data[$i]['nomlin'];
$data2[$i]['unidadmedida'] = $data[$i]['unidadmedida'];
$data2[$i]['stock'] = $data[$i]['stockactual'];
$data2[$i]['precio'] = number_format($data[$i]['preciolista'], 2);
$data2[$i]['preciototal'] = number_format($data[$i]['stockactual'] * $data[$i]['preciolista'], 2);
$total += $data[$i]['stockactual'] * $data[$i]['preciolista'];
}
$objeto = $this->formatearparakui($data2);
header("Content-type: application/json");
echo json_encode($objeto);
//echo '<tr style="font-weight:bold"><td colspan="6"></td><td class="right">Total:</td><td class="right">'.number_format($total,2).'</td></tr>';
}
}
