· 8 years ago · Aug 02, 2018, 06:08 PM
1<html lang="en">
2
3 <head>
4 <meta charset="UTF-8">
5 <title>TI-Trash | Gestão de ResÃduos</title>
6 <link rel="stylesheet" href="/css/main.css">
7 </head>
8
9 <body>
10 <h1 style="text-align: center">---------------------------------------------------------TI-Trash----------------------------------------------------------</h1>
11 <img src="img/logo/White%20with%20Colorful%20Icon%20Computer%20Logo%20(1).png" style="width:200px;height:200px;" align="right"><br>
12
13 <h1 style="text-align:left">Introduza o seu ID</h1>
14
15 <form action="results.php" method="post">
16 <label for="user_id">ID:</label><br>
17 <input type="text" id="user_id" name="user_id"><br>
18 <input type="submit">
19 </form>
20 <br><br><br><br><br><br><br><br><br><br><br><br><br><br>
21 <p style="text-align: center">Aplicação WEB produzida por<br style="text-align:center">Tiago Gonçalves</p>
22 <p style="text-align:center">com ajuda de<br><br>Tiago Cardoso</p>
23 </body>
24</html>
25
26<?php
27 if( $user_info ){
28 if( $user_info['nome'] = 'Tiago Gonçalves'){
29 echo '<img src="img/users/Tiago.jpg">';
30 }
31 if( $user_info['nome'] = 'Alexandre Salgado'){
32 echo '<img src="img/users/Alexandre.jpg">';
33 }
34 if( $user_info['nome'] = 'Ricardo Cardoso'){
35 echo '<img src="img/users/Ricardo.jpg">';
36 }
37
38 echo '<h1> ' . $user_info['nome'] . '</h1>' ;
39 echo '<p> ' . $user_info['email'] . '</p>';
40 echo '<table style="border: 1px solid black;">';
41 echo '<tr>';
42 echo '<th>Quantidade </th>';
43 echo '<th>Localização de Depósito </th>';
44 echo '<th>Data/Hora de Depósito</th>';
45 echo '</tr>';
46
47 $total = 0.0 ;
48 foreach( $user_dumps as $dump ){
49 $total += $dump['quantity'];
50 echo '<tr>';
51 echo '<td align="center">' . $dump['quantity'] . '</td>';
52 echo '<td align="center">' . $containers[$dump['container_id']] . '</td>';
53 echo '<td align="center">' . $dump['timestamp'] . '</td>';
54 echo '</tr>';
55 }
56 echo '</table><br>';
57
58
59 echo '<h3 style="color: red;"> Total de ResÃduos Registados: ' . $total . 'kg</h3>';
60
61 //O valor a pagar é 10% do peso dos resÃduos registados
62 echo '<h3 style="color: red;"> A pagar: ' .$total*0.10 . '€</h3>';
63 }
64 else{
65 echo '<h1>Nenhum utilizador com o ID introduzido atribuido!</h1>';
66 }
67
68 echo '<form action="index.php"><input type="submit" value="IDs" /></form>';
69 ?>
70
71BEGIN TRANSACTION;
72CREATE TABLE IF NOT EXISTS `users` (
73 `id` INTEGER,
74 `nome` TEXT NOT NULL,
75 `telemovel` INTEGER,
76 `nif` INTEGER NOT NULL,
77 `email` TEXT
78);
79INSERT INTO `users` VALUES (1,'Tiago Gonçalves
80',968074232,263071030,'tiagog@gmail.com');
81INSERT INTO `users` VALUES (2,'Alexandre Salgado',393564525,152635968,'alexs@gmail.com');
82INSERT INTO `users` VALUES (3,'Ricardo Cardoso',895475454,265365365,'rkz@gmail.com');
83CREATE TABLE IF NOT EXISTS `garbage` (
84 `user_id` INTEGER,
85 `container_id` INTEGER,
86 `quantity` REAL,
87 `timestamp` NUMERIC,
88 PRIMARY KEY(`user_id`,`container_id`,`quantity`,`timestamp`)
89);
90INSERT INTO `garbage` VALUES (1,1,1.23,20180801192202);
91INSERT INTO `garbage` VALUES (1,1,56.9,20180801103555);
92INSERT INTO `garbage` VALUES (1,1,12.0,20180730135533);
93INSERT INTO `garbage` VALUES (3,2,152.0,20180801192202);
94CREATE TABLE IF NOT EXISTS `containers` (
95 `id` INTEGER PRIMARY KEY AUTOINCREMENT,
96 `location` TEXT
97);
98INSERT INTO `containers` VALUES (1,'R. Dr. Lino Cardoso 66, 3060-209 Cantanhede');
99INSERT INTO `containers` VALUES (2,'Rua Camarao
100');
101INSERT INTO `containers` VALUES (3,NULL);
102COMMIT;