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