Conti/riepilogoConti.php at main · AlphaByte02/Conti · GitHub

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
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
<!DOCTYPE html>
<html lang="it">

<head>
	<meta charset="UTF-8">
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<meta http-equiv="X-UA-Compatible" content="ie=edge">

	<title>Riepilogo Conti</title>

	<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.6/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-4Q6Gf2aSP4eDXB8Miphtr37CMZZQ5oXLH2yaXMJ2w8e2ZtHTl7GptT4jmndRuHDT" crossorigin="anonymous">
	<link href="style.css" rel="stylesheet">
</head>

<body>
	<h1>Riepilogo Conti</h1>
	<a href="index.php">
		<h4>Inserisci altri dati</h4>
	</a>
	<a href="riepilogoTransazioni.php">
		<h4>Guarda il Riepilogo delle Transazioni</h4>
	</a>
	<br />
	<a href="riepilogoContiFinali.php">
		<h4>Guarda il Riepilogo dei conti finali</h4>
	</a>
	<div class="container w-50">
	<?php
	include_once("db.php");

	$query = "SELECT
				P.NOME AS debitore,
				S.NOME AS creditore,
				T.CAUSALE AS causale,
				SUM(T.IMPORTO / PARTECIPANTI.TOTALE_PARTECIPANTI) AS spesa
			FROM
				TRANSAZIONI T
				JOIN SOGGETTI TS ON T.ID = TS.ID_TRANSAZIONE
				JOIN NOMI S ON T.ID_PAGANTE = S.ID
				JOIN NOMI P ON TS.ID_SOGGETTO = P.ID
				JOIN (
					SELECT
						ID_TRANSAZIONE,
						COUNT(*) AS TOTALE_PARTECIPANTI
					FROM
						SOGGETTI
					GROUP BY
						ID_TRANSAZIONE
				) PARTECIPANTI ON T.ID = PARTECIPANTI.ID_TRANSAZIONE
			WHERE
				S.ID <> P.ID
			GROUP BY
				DEBITORE,
				CREDITORE,
				CAUSALE
			ORDER BY
				DEBITORE,
				CREDITORE,
				CAUSALE";

	$lastname = "";
	$res = $db->query($query);
	if ($res !== null && $res->rowCount() > 0) {
		while ($row = $res->fetch()) {
			if ($lastname != $row["debitore"]) {
				if ($lastname != "") {
					echo "<tr><th>-</th><td>-</td><td>-</td></tr>";
					foreach ($somme as $pagante => $somma) {
						echo "<tr><th>TOT $pagante</th><td colspan='2'>" . sprintf('%0.2f', $somma["spesa"]) . "</td></tr>";
					}
					echo "</tbody>";
					echo "</table>";
					echo "<br/><br/>";
				}

				$somme = [];
				$lastname = $row["debitore"];

				echo "<table class='table caption-top table-bordered'>";
				echo "<caption><b>$row[debitore]</b></caption>";
				echo "<thead><tr><th>Pagante</th><th>Quanto (€)</th><th>Causale</th></tr></thead>";
				echo "<tbody>";
			}

			echo "<tr>";
			echo "<td>$row[creditore]</td><td>" . sprintf('%0.2f', $row["spesa"]) . "</td><td>" . (empty($row["causale"]) ? "-" : $row["causale"]) . "</td>";
			echo "</tr>";
			$somme[$row["creditore"]]["spesa"] = (isset($somme[$row["creditore"]]) ? $somme[$row["creditore"]]["spesa"] : 0) + $row["spesa"];
		}
		echo "<tr><th>-</th><td>-</td><td>-</td></tr>";
		foreach ($somme as $pagante => $somma) {
			echo "<tr><th>TOT $pagante</th><td colspan='2'>" . sprintf('%0.2f', $somma["spesa"]) . "</td></tr>";
		}
		echo "</tbody>";
		echo "</table>";
	} else {
		echo "<h3>Nessuna transazione effettuta! Falla ora <a href='index.php'>qui</a></h3>";
	}
	?>
	</div>
</body>

</html>