$uns = $objunidad->searchDB($_GET["tu"], "id_tipo_unidad"); } else { $uns = $objunidad->listDB(); } } else { $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>";
$uns = $objunidad->listDB(); } } else { $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>"; $unidades[] = $u["placa"]; $sqlkil = "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" . $sql_where . " AND cv.id_unidad = '" . $u["id"] . "'"; $peso1 = $objtu->consulta_arreglo($sqlkil); $col1 = $col1 + floatval($peso1["kil"]); $toneladas[] = floatval($peso1["kil"]); echo "<td>" . floatval($peso1["kil"]) . "</td>"; $reg = $objtu->consulta_arreglo("Select * from reporte_grafico where id_unidad = '" . $u["id"] . "' AND fecha_inicio = '" . $_GET["fi"] . "' AND fecha_fin = '" . $_GET["ff"] . "' "); if (is_array($reg)) { echo "<td><input type='hidden' id='rg_" . $u["id"] . "' value='" . $reg["id"] . "'/><span id='" . $u["id"] . "_kil_lbl' onclick='muestra_inp_kil_" . $u["id"] . "()'>" . $reg["kilometros"] . "</span><input type='number' id='" . $u["id"] . "_kil' onchange='actualiza_" . $u["id"] . "()' style='display:none;' onblur='fin_ed_kil_" . $u["id"] . "()' value='" . $reg["kilometros"] . "'/></td>"; echo "<td><span id='" . $u["id"] . "_gal_lbl' onclick='muestra_inp_gal_" . $u["id"] . "()'>" . $reg["galones"] . "</span><input type='number' id='" . $u["id"] . "_gal' onchange='actualiza_" . $u["id"] . "()' style='display:none;' onblur='fin_ed_gal_" . $u["id"] . "()' value='" . $reg["galones"] . "'/></td>"; echo "<td id='" . $u["id"] . "_kg'>" . round(floatval($reg["kilometros"]) / floatval($reg["galones"]), 2) . "</td>"; echo "<td id='" . $u["id"] . "_gk'>" . round(floatval($reg["galones"]) / floatval($reg["kilometros"]), 2) . "</td>"; $col2 = $col2 + round(floatval($reg["kilometros"]) / floatval($reg["galones"]), 2); $kgs[] = round(floatval($reg["kilometros"]) / floatval($reg["galones"]), 2); $col3 = $col3 + round(floatval($reg["galones"]) / floatval($reg["kilometros"]), 2); $gks[] = round(floatval($reg["galones"]) / floatval($reg["kilometros"]), 2); } else { echo "<td><input type='hidden' id='rg_" . $u["id"] . "' value='0'/><span id='" . $u["id"] . "_kil_lbl' onclick='muestra_inp_kil_" . $u["id"] . "()'>0</span><input type='number' id='" . $u["id"] . "_kil' onchange='actualiza_" . $u["id"] . "()' style='display:none;' onblur='fin_ed_kil_" . $u["id"] . "()' value=''/></td>";
} else { $uns = $objunidad->listDB(); } if (is_array($uns)) { foreach ($uns as $u) { echo "<tr>"; echo "<td>" . $u["placa"] . "</td>"; $unidades[] = $u["placa"]; $objtu = new tipo_unidad(); $objtu->setId($u["id_tipo_unidad"]); $objtu->getDB(); echo "<td>" . $objtu->getNombre() . "</td>"; $peso_minimo = $objtu->getCargaMinima(); $peso_maximo = $objtu->getCargaMaxima(); $sql = "Select count(*) as cnt from registro r, configuracion_vehiculo cv, unidad u where r.id_configuracion_vehiculo = cv.id AND cv.id_unidad = u.id" . $sql_where . " AND cv.id_unidad = '" . $u["id"] . "' AND r.peso_neto < '" . $peso_minimo . "'"; $c_sub = $objtu->consulta_arreglo($sql); $c_nor = $objtu->consulta_arreglo("Select count(*) as cnt from registro r, configuracion_vehiculo cv, unidad u where r.id_configuracion_vehiculo = cv.id AND cv.id_unidad = u.id" . $sql_where . " AND cv.id_unidad = '" . $u["id"] . "' AND r.peso_neto BETWEEN '" . $peso_minimo . "' AND '" . $peso_maximo . "'"); $c_sob = $objtu->consulta_arreglo("Select count(*) as cnt from registro r, configuracion_vehiculo cv, unidad u where r.id_configuracion_vehiculo = cv.id AND cv.id_unidad = u.id" . $sql_where . " AND cv.id_unidad = '" . $u["id"] . "' AND r.peso_neto > '" . $peso_maximo . "'"); $col1 = $col1 + intval($c_sub["cnt"]); $col2 = $col2 + intval($c_nor["cnt"]); $col3 = $col3 + intval($c_sob["cnt"]); $subcargas[] = intval($c_sub["cnt"]); $normales[] = intval($c_nor["cnt"]); $sobrecargas[] = intval($c_sob["cnt"]); echo "<td>" . intval($c_sub["cnt"]) . "</td>"; echo "<td>" . intval($c_nor["cnt"]) . "</td>"; echo "<td>" . intval($c_sob["cnt"]) . "</td>"; echo "</tr>"; } echo "<tr>"; echo "<td>Totales</td>";