/
extra_historial.php
63 lines (62 loc) · 2.48 KB
/
extra_historial.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
<?php
require './vista/menu.php';
$conexion = abrir_conexion();
session_start();
$usuID = usuario_a_usuID($_SESSION["user"]);;
?>
<?php for ($ano = 2014; $ano > 2000; $ano--) :; ?>
<?php if ( num_extras($ano, $usuID, $conexion) > 0) : ; ?>
<table border="1" id="tabla_historico">
<tr>
<th id="tabla_historico_ano"><?php echo $ano ?></th>
</tr>
<tr>
<td>Numero de Extras:</td>
<td><?php
echo num_extras($ano, $usuID, $conexion);
?></td>
</tr>
<tr>
<td>Cobro total:</td>
<td><?php
$sql = "SELECT SUM(precio) as dato FROM extras WHERE usuario = '$usuID' and YEAR(fecha)='$ano'";
echo devolver_consulta($ano, $usuID, $conexion, $sql) .' €';
?></td>
</tr>
<tr>
<td>Propinas ganadas</td>
<td><?php
$sql = "SELECT SUM(propina) as dato FROM extras WHERE usuario = '$usuID' and YEAR(fecha)='$ano'";
echo devolver_consulta($ano, $usuID, $conexion, $sql) .' €';
?></td>
</tr>
<tr>
<td>Total ganado (prop. inc.):</td>
<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 endif; ?>
<?php endfor;?>
<?php require'./vista/pie.php'; ?>