$sql = "select count(*) AS dato from fresa where usuario = '{$usuID}' and YEAR(fecha)='{$ano}'"; if (devolver_consulta($ano, $usuID, $conexion, $sql) > 0) { ?> <table border="1" id="tabla_historico"> <tr> <th id="tabla_historico_ano"><?php echo $ano; ?> </th> </tr> <tr> <td>Total de caixas:</td> <td><?php $sql = "SELECT SUM(caixas) as dato FROM fresa WHERE usuario = '{$usuID}' and YEAR(fecha)='{$ano}'"; echo devolver_consulta($ano, $usuID, $conexion, $sql); ?> </td> </tr> <tr> <td>Media diaria:</td> <td><?php $sql = "SELECT SUM(caixas)/count(*) as dato FROM fresa WHERE usuario = '{$usuID}' and YEAR(fecha)='{$ano}'"; echo round(devolver_consulta($ano, $usuID, $conexion, $sql), 2); ?> </td> </tr> </table> <?php } } require './vista/pie.php';
</td> <td><?php echo round($porcentaje) . " %"; ?> (<i><?php echo $value["ingresos"] . ' €'; ?> </i>)</td> </tr> <?php } echo "</table>"; } } $ingresos_local = total_ingresos_local($usuID, $conexion); $total = devolver_consulta($ano, $usuID, $conexion, "SELECT SUM(precio) as dato FROM extras WHERE usuario = '{$usuID}'"); ?> <br> <table border="0" id="grafica1"> <tr><th id="tabla_historico_ano">TOTAL</th> <td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td> <td>Ingresos</td> </tr> <?php foreach ($ingresos_local as $value) { $porcentaje = 100 * $value["ingresos"] / $total; ?> <tr> <td><b><?php echo $value["local"]; ?>
<td><?php $sql = "SELECT SUM(propina)+SUM(precio) as dato FROM extras WHERE usuario = '{$usuID}' and YEAR(fecha)='{$ano}'"; echo devolver_consulta($ano, $usuID, $conexion, $sql) . ' €'; ?> </td> </tr> <tr> <td>Pago asociado:</td> <td><?php $sql = "select count(*)*5 AS dato from extras where usuario = '{$usuID}' and YEAR(fecha)='{$ano}' and pago_asoc='s'"; echo devolver_consulta($ano, $usuID, $conexion, $sql) . ' €'; ?> </td> </tr> <tr> <td>Pago realizado</td> <td><?php $sql = "SELECT SUM(cantidad) as dato FROM pagos WHERE usuario = '{$usuID}' and YEAR(fecha)='{$ano}'"; if (devolver_consulta($ano, $usuID, $conexion, $sql)) { echo devolver_consulta($ano, $usuID, $conexion, $sql) . ' €'; } else { echo "0 €"; } ?> </td> </tr> </table> <?php } } require './vista/pie.php';