-
Notifications
You must be signed in to change notification settings - Fork 1
/
admin.php
130 lines (119 loc) · 7.77 KB
/
admin.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
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
<?php
include('./db/connection.php');
include('./auth/protect.php');
include('./components/head.php');
if ($_SESSION['permission'] != 'Administrador') {
header('Location: ./');
}
$counts = [];
$counts["items"] = "SELECT COUNT(itemID) AS amount FROM item";
$counts["readers"] = "SELECT COUNT(personID) AS amount FROM person WHERE permissionLevel='reader'";
$counts["evaluations"] = "SELECT COUNT(personID) AS amount FROM evaluation";
$counts["approved_comments"] = "SELECT COUNT(commentID) AS amount FROM comment WHERE approved=1";
$counts["pending_comments"] = "SELECT COUNT(commentID) AS amount FROM comment WHERE approved=0";
$counts["moderators"] = "SELECT COUNT(personID) AS amount FROM person WHERE permissionLevel='moderator'";
$counts["employees"] = "SELECT COUNT(personID) AS amount FROM person WHERE permissionLevel='employee'";
$counts["admins"] = "SELECT COUNT(personID) AS amount FROM person WHERE permissionLevel='admin'";
foreach ($counts as $key => $value) {
$sql_query = $mysqli->query($value) or die("Falha na execução do código SQL: " . $mysqli);
$data = $sql_query->fetch_assoc();
$counts[$key] = $data["amount"];
}
global $counts;
?>
<body>
<div class="bg-slate-50 flex flex-col min-h-screen">
<?php
include './components/header.php';
?>
<main class="w-full max-w-7xl mx-auto flex-grow my-8 md:my-16 px-2 flex flex-col gap-2">
<h1 class="font-semibold text-slate-900 text-2xl md:text-4xl mb-2">
Painel de Controle
</h1>
<p class="text-slate-500 text-sm md:text-base mb-8">
Gerencie a equipe e o acervo da sua biblioteca com poucos cliques,
tudo centralizado e acessível e um único lugar.
</p>
<div class="grid grid-cols-2 gap-4 md:grid-cols-3 lg:grid-cols-4 control-panel">
<a href="./item/create.php" class="border rounded-lg drop-shadow-sm p-6 bg-white flex flex-col">
<header class="flex justify-between items-center mb-4">
<img src="./static/assets/icons/book.svg" alt="Obras" class="w-6" />
<span class="opacity-0 flex gap-1 items-center leading-none text-xs text-emerald-600">Adicionar
<img src="./static/assets/icons/add.svg" alt="Adicionar" class="w-4" /></span>
</header>
<strong class="text-2xl text-slate-900"><?= $counts["items"] ?></strong>
<p class="text-slate-600">Obras</p>
</a>
<a href="./user/create.php" class="border rounded-lg drop-shadow-sm p-6 bg-white flex flex-col">
<header class="flex justify-between items-start mb-4">
<img src="./static/assets/icons/users.svg" alt="Leitores" class="w-6" />
<span class="opacity-0 flex gap-1 items-center leading-none text-xs text-emerald-600">Adicionar
<img src="./static/assets/icons/add.svg" alt="Adicionar" class="w-4" /></span>
</header>
<strong class="text-2xl text-slate-900"><?= $counts["readers"] ?></strong>
<p class="text-slate-600">Leitores</p>
</a>
<a href="/" class="border rounded-lg drop-shadow-sm p-6 bg-white flex flex-col">
<header class="flex justify-between items-start mb-4">
<img src="./static/assets/icons/quotes.svg" alt="Citações" class="w-6" />
<span class="opacity-0 flex gap-1 items-center leading-none text-xs text-emerald-600">Adicionar
<img src="./static/assets/icons/add.svg" alt="Adicionar" class="w-4" /></span>
</header>
<strong class="text-2xl text-slate-900">10</strong>
<p class="text-slate-600">Citações</p>
</a>
<div class="border rounded-lg drop-shadow-sm p-6 bg-white flex flex-col">
<img src="./static/assets/icons/gray-star.svg" alt="Avaliações" class="w-6 mb-4" />
<strong class="text-2xl text-slate-900"><?= $counts["evaluations"] ?></strong>
<p class="text-slate-600">Avaliações</p>
</div>
<div class="border rounded-lg drop-shadow-sm p-6 bg-white flex flex-col">
<img src="./static/assets/icons/approved-comments.svg" alt="Comentários Aprovados" class="w-6 mb-4" />
<strong class="text-2xl text-slate-900"><?= $counts["approved_comments"] ?></strong>
<p class="text-slate-600">Comentários Aprovados</p>
</div>
<a href="./pending-comments.php" class="border rounded-lg drop-shadow-sm p-6 bg-white flex flex-col">
<header class="flex justify-between items-start mb-4">
<img src="./static/assets/icons/pending-comments.svg" alt="Comentários Pendentes" class="w-6" />
<span class="opacity-0 flex gap-1 items-center leading-none text-xs text-emerald-600">Verificar
<img src="./static/assets/icons/add.svg" alt="Adicionar" class="w-4" /></span>
</header>
<strong class="text-2xl text-slate-900"><?= $counts["pending_comments"] ?></strong>
<p class="text-slate-600">Comentários Pendentes</p>
</a>
<a href="./user/search.php?search=&search-for=person" class="border rounded-lg drop-shadow-sm p-6 bg-white flex flex-col">
<header class="flex justify-between items-start mb-4">
<img src="./static/assets/icons/moderators.svg" alt="Moderadores" class="w-6" />
<span class="opacity-0 flex gap-1 items-center leading-none text-xs text-emerald-600">Adicionar
<img src="./static/assets/icons/add.svg" alt="Adicionar" class="w-4" /></span>
</header>
<strong class="text-2xl text-slate-900"><?= $counts["moderators"] ?></strong>
<p class="text-slate-600">Moderadores</p>
</a>
<a href="./user/search.php?search=&search-for=person" class="border rounded-lg drop-shadow-sm p-6 bg-white flex flex-col">
<header class="flex justify-between items-start mb-4">
<img src="./static/assets/icons/employees.svg" alt="Funcionários" class="w-6" />
<span class="opacity-0 flex gap-1 items-center leading-none text-xs text-emerald-600">Adicionar
<img src="./static/assets/icons/add.svg" alt="Adicionar" class="w-4" /></span>
</header>
<strong class="text-2xl text-slate-900">2</strong>
<p class="text-slate-600">Funcionários</p>
</a>
<a href="./user/search.php?search=&search-for=person" class="border rounded-lg drop-shadow-sm p-6 bg-white flex flex-col">
<header class="flex justify-between items-start mb-4">
<img src="./static/assets/icons/employees.svg" alt="Biblitecários" class="w-6" />
<span class="opacity-0 flex gap-1 items-center leading-none text-xs text-emerald-600">Adicionar
<img src="./static/assets/icons/add.svg" alt="Adicionar" class="w-4" /></span>
</header>
<strong class="text-2xl text-slate-900">1</strong>
<p class="text-slate-600">Biblitecários</p>
</a>
</div>
</main>
<?php
include('./components/footer.php');
?>
</div>
<script src="./static/scripts/inputEffect.js"></script>
</body>
</html>