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>'; } }