$uns = $objunidad->listDB(); } if (is_array($uns)) { foreach ($uns as $u) { echo "<tr>"; echo "<td>" . $u["placa"] . "</td>"; $objtu = new tipo_unidad(); $objtu->setId($u["id_tipo_unidad"]); $objtu->getDB(); echo "<td>" . $objtu->getNombre() . "</td>"; $peso1 = $objtu->consulta_arreglo("Select sum(r.peso_neto) as kil from registro r, configuracion_vehiculo cv, unidad u where r.id_configuracion_vehiculo = cv.id AND cv.id_unidad = '" . $u["id"] . "' AND u.id = cv.id_unidad " . $sql_where . " "); $col1 = $col1 + floatval($peso1["kil"]); echo "<td>" . floatval($peso1["kil"]) . "</td>"; $col2 = $col2 + round(floatval($peso1["kil"]) / $total_mes * 100, 2); echo "<td>" . round(floatval($peso1["kil"]) / $total_mes * 100, 2) . "</td>"; $col3 = $col3 + floatval($peso1["kil"]) * floatval($objtu->getPrecioVariable()); echo "<td>" . floatval($peso1["kil"]) * floatval($objtu->getPrecioVariable()) . "</td>"; $col4 = $col4 + (floatval($peso1["kil"]) * floatval($objtu->getPrecioVariable()) + floatval($objtu->getPrecioFijo())); echo "<td>" . (floatval($peso1["kil"]) * floatval($objtu->getPrecioVariable()) + floatval($objtu->getPrecioFijo())) . "</td>"; echo "</tr>"; } } echo "<tr>"; echo "<td>Totales</td>"; echo "<td></td>"; echo "<td>" . $col1 . "</td>"; echo "<td>" . $col2 . "</td>"; echo "<td>" . $col3 . "</td>"; echo "<td>" . $col4 . "</td>"; echo "</tr>"; }