-
Notifications
You must be signed in to change notification settings - Fork 1
/
eleves_historique.sql
76 lines (73 loc) · 2.29 KB
/
eleves_historique.sql
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
SELECT 'redirect' AS component,
'signin.sql?error' AS link
WHERE NOT EXISTS (SELECT 1 FROM login_session WHERE id=sqlpage.cookie('session'));
SET group_id = (SELECT user_info.groupe FROM login_session join user_info on user_info.username=login_session.username WHERE id = sqlpage.cookie('session'));
--Menu
/*select 'shell' as component,
'P.A.S.' as title,
'Source : Webmestre / Collège Henri Bourrillon / Mende -2023' as footer,
'fr-FR' as language,
'home' as icon,
'/' as link,
TRUE as norobot,
'["eleves", "aesh", "etablissement", "referent", "parametres", "logout"]' as menu_item;
*/
--Menu
SELECT 'dynamic' AS component, sqlpage.read_file_as_text('menu.json') AS properties;
-- Liste des derniers changements
select
'button' as component,
'sm' as size,
'center' as justify,
'pill' as shape;
select
'Liste des derniers changements' as title,
'user-plus' as icon,
'azure' as outline;
SELECT 'table' as component,
'Suivis' AS markdown,
'admin' AS markdown,
1 as sort,
1 as search;
SELECT
eleve.nom as Nom,
eleve.prenom as Prénom,
strftime('le %d/%m/%Y à %Hh%M:%S', eleve.modification) as Modifié,
eleve.editeur AS Par,
CASE
WHEN EXISTS (SELECT eleve.id FROM suivi WHERE suivi.eleve_id=eleve.id)
THEN '[
![](./icons/user-plus.svg)
](aesh_suivi.sql?id='||suivi.aesh_id||'&tab=Profils) [
![](./icons/briefcase.svg)
](notification.sql?id='||eleve.id||'&tab=Profil)'
WHEN EXISTS (SELECT eleve.id FROM affectation WHERE affectation.eleve_id=eleve.id)
THEN '[
![](./icons/briefcase.svg)
](notification.sql?id='||eleve.id||'&tab=Profil)'
ELSE
'[
![](./icons/alert-triangle-filled.svg)
](notification.sql?id='||eleve.id||'&tab=Profil)'
END as Suivis,
CASE
WHEN $group_id=3 THEN
'[
![](./icons/trash-off.svg)
]()[
![](./icons/pencil.svg)
](eleve_edit.sql?id='||eleve.id||')'
WHEN $group_id=4 THEN
'[
![](./icons/trash.svg)
](eleve_delete.sql?id='||eleve.id||')[
![](./icons/pencil.svg)
](eleve_edit.sql?id='||eleve.id||')'
ELSE
'[
![](./icons/trash-off.svg)
]()[
![](./icons/pencil-off.svg)
]()'
END as admin
FROM eleve LEFT JOIN suivi on eleve.id=suivi.eleve_id GROUP BY eleve.id ORDER BY eleve.modification DESC LIMIT 20;