eleves_hors_etab.sql

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 'dynamic' AS component, sqlpage.read_file_as_text('menu.json') AS properties;

-- Message si droits insuffisants sur une page
SELECT 'alert' as component,
    'Attention !' as title,
    'Vous ne possédez pas les droits suffisants pour accéder à cette page.' as description_md,
    'alert-circle' as icon,
    'red' as color
WHERE $restriction IS NOT NULL;    


select 
    'button' as component,
    'sm'     as size,
    'pill'   as shape;
select 
    'Élèves' as title,
    'briefcase' as icon,
    'green' as color;
select 
    'Ajouter un élève' as title,
    'eleve.sql' as link,
    'square-rounded-plus' as icon,
        $group_id<3 as disabled,
    'green' as outline;
      
-- Liste des élèves
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('%d/%m/%Y',eleve.naissance) AS Naissance,
  coalesce(eleve.niveau,'-') as Niveau,
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 WHERE CAST(coalesce(etab_id,0) as integer)<1 GROUP BY eleve.id ORDER BY eleve.nom ASC;