-
Notifications
You must be signed in to change notification settings - Fork 1
/
passageiros.php
executable file
·107 lines (95 loc) · 6.14 KB
/
passageiros.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
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
104
105
106
107
<!DOCTYPE html>
<html lang="pt">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>AwayPlanner - Lista de inscrições</title>
<link rel="stylesheet" href="css/bootstrap.min.css">
<link rel="stylesheet" href="css/styles.css">
<link rel="preconnect" href="https://fonts.googleapis.com">
<link rel="preconnect" href="https://fonts.gstatic.com" crossorigin>
<link href="https://fonts.googleapis.com/css2?family=Montserrat:wght@500&display=swap" rel="stylesheet">
</head>
<body>
<?php require('includes/menu.html'); ?>
<?php require('includes/database.php'); ?>
<?php
$id_viagem = $_GET['id_v'];
$sql_pagamento = 'SELECT * FROM pagamento p INNER JOIN passageiro g ON g.id = p.id_passageiro WHERE p.id_viagem = :id AND p.visibilidade = 1';
$stmt = $dbh->prepare($sql_pagamento);
$stmt->bindValue(':id', $id_viagem);
$stmt->execute();
?>
<div class="container mt-4">
<a style="color:#0f0a0a; text-decoration:none; font-weight:300" href="viagens.php"><svg class="me-1" xmlns="http://www.w3.org/2000/svg" width="25" height="25" fill="currentColor" class="bi bi-arrow-bar-left" viewBox="0 0 16 16"><path fill-rule="evenodd" d="M12.5 15a.5.5 0 0 1-.5-.5v-13a.5.5 0 0 1 1 0v13a.5.5 0 0 1-.5.5M10 8a.5.5 0 0 1-.5.5H3.707l2.147 2.146a.5.5 0 0 1-.708.708l-3-3a.5.5 0 0 1 0-.708l3-3a.5.5 0 1 1 .708.708L3.707 7.5H9.5a.5.5 0 0 1 .5.5"/></svg><span style="display:inline-block; vertical-align: middle; font-size:larger;">Voltar</span></a>
<h1 style="font-weight: 600;">Inscrições</h1>
<h3 style="color: #56445D"><?= $_GET['destino']?></h3>
<table class="table table-hover">
<thead>
<tr>
<th scope="col">Nome</th>
<th style="width: 15%" scope="col">Contacto</th>
<th style="width: 10%" scope="col">Pago</th>
<th style="width: 10%" scope="col">Opções</th>
</tr>
</thead>
<?php
while($passageiro = $stmt->fetchObject()){
$nome = $passageiro->nome;
$contacto = $passageiro->contacto;
$pago = $passageiro->pago;
?>
<tbody>
<tr>
<td><?= $nome ?></td>
<td><?= $contacto ?></td>
<td><input <?php if($pago == 1) echo 'checked';?> class="form-check-input" type="checkbox" disabled id="<?= $passageiro->id?>"></td>
<td>
<div class="btn-group">
<a href="modificacoesBD/editPassageiro.php?id_p=<?= $passageiro->id; ?>&id_v=<?=$_GET['id_v'];?>&destino=<?= $_GET['destino']; ?>" class="btn btn-primary" style="background-color:#37392E; border-width:0px;"><svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" class="bi bi-pencil" viewBox="0 0 16 16"><path d="M12.146.146a.5.5 0 0 1 .708 0l3 3a.5.5 0 0 1 0 .708l-10 10a.5.5 0 0 1-.168.11l-5 2a.5.5 0 0 1-.65-.65l2-5a.5.5 0 0 1 .11-.168zM11.207 2.5 13.5 4.793 14.793 3.5 12.5 1.207zm1.586 3L10.5 3.207 4 9.707V10h.5a.5.5 0 0 1 .5.5v.5h.5a.5.5 0 0 1 .5.5v.5h.293zm-9.761 5.175-.106.106-1.528 3.821 3.821-1.528.106-.106A.5.5 0 0 1 5 12.5V12h-.5a.5.5 0 0 1-.5-.5V11h-.5a.5.5 0 0 1-.468-.325"/></svg></a>
<a href="modificacoesBD/deletePassageiro.php?id_p=<?= $passageiro->id; ?>&id_v=<?= $_GET['id_v']; ?>" class="btn btn-danger delete-confirm" style="background-color: #D02536; border-width:0px;" data-bs-toggle="modal" data-bs-target="#DangerModalalert"><svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" class="bi bi-trash" viewBox="0 0 16 16"><path d="M5.5 5.5A.5.5 0 0 1 6 6v6a.5.5 0 0 1-1 0V6a.5.5 0 0 1 .5-.5m2.5 0a.5.5 0 0 1 .5.5v6a.5.5 0 0 1-1 0V6a.5.5 0 0 1 .5-.5m3 .5a.5.5 0 0 0-1 0v6a.5.5 0 0 0 1 0z"/><path d="M14.5 3a1 1 0 0 1-1 1H13v9a2 2 0 0 1-2 2H5a2 2 0 0 1-2-2V4h-.5a1 1 0 0 1-1-1V2a1 1 0 0 1 1-1H6a1 1 0 0 1 1-1h2a1 1 0 0 1 1 1h3.5a1 1 0 0 1 1 1zM4.118 4 4 4.059V13a1 1 0 0 0 1 1h6a1 1 0 0 0 1-1V4.059L11.882 4zM2.5 3h11V2h-11z"/></svg></a>
</div>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
<a href="modificacoesBD/addPassageiro.php?id_v=<?= $_GET['id_v'];?>&destino=<?=$_GET['destino'];?>" class="btn btn-ap-primary btn-lg position-relative start-50" style="border-radius:100%" role="button">+</a>
</div>
<!-- Modal -->
<div class="modal fade" id="DangerModalalert" data-bs-backdrop="static" data-bs-keyboard="false" tabindex="-1" aria-labelledby="staticBackdropLabel" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<h1 class="modal-title fs-5" id="staticBackdropLabel">Confirmação</h1>
<button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
</div>
<div class="modal-body">Tem a certeza que deseja apagar o registo?
</div>
<div class="modal-footer danger-md">
<a class="btn btn-dark" data-bs-dismiss="modal">Não</a>
<a class="btn btn-danger delete-yes" href="#">Sim</a>
</div>
</div>
</div>
</div>
<script src="js/bootstrap.bundle.min.js"></script>
<script>
document.addEventListener("DOMContentLoaded", function() {
var deleteLinks = document.querySelectorAll(".delete-confirm");
deleteLinks.forEach(function(link) {
link.addEventListener("click", function(event) {
event.preventDefault();
var deleteYesLink = document.querySelector(".modal-footer .delete-yes");
if (deleteYesLink) {
deleteYesLink.href = this.href;
}
return false;
});
});
});
</script>
</body>
</html>