eleve_delete.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'));
SELECT 'redirect' AS component,
        'notification.sql?restriction&id='||$id AS link
        WHERE $group_id<'3';

--Menu
SELECT 'dynamic' AS component, sqlpage.read_file_as_text('menu.json') AS properties;

--Bouton retour sans valider
select 
    'button' as component,
    'sm'     as size,
    'pill'   as shape;
select 
    'Retour à la liste' as title,
    'eleves.sql' as link,
    'arrow-back-up' as icon,
    'green' as outline;  
select 
    'Retour à la fiche élève' as title,
    'notification.sql?id='|| $id||'&tab=Profil' as link,
    'briefcase' as icon,
    'green' as outline;     

SELECT 
    'alert' as component,
    'Alerte' as title,
    'Toute suppression est définitive !' as description,
    'alert-triangle' as icon,
    'red' as color;
-- Set a variable 
SET var_suivi = (SELECT count(suivi.id) FROM suivi where suivi.eleve_id=$id); 
SET var_amenag = (SELECT count(amenag.id) FROM amenag where amenag.eleve_id=$id); 
SET var_notif = (SELECT count(notification.id) FROM notification where notification.eleve_id=$id); 
      
-- Isolement de l'élève dans une liste
SELECT 'table' as component,
    'actions' 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,
  eleve.classe as Classe,
  etab.nom_etab as Établissement,
  CASE WHEN $var_suivi>=1 OR $var_amenag>=1 OR $var_notif>=1 
THEN
'[
    ![](./icons/trash-off.svg)
]() ' 
ELSE
      '[
    ![](./icons/trash.svg)
](eleve_delete_confirm.sql?id='||eleve.id||')' 
END 
as actions
FROM eleve LEFT JOIN etab on eleve.etab_id=etab.id Where eleve.id=$id;

-- Gestion de la photo

SELECT 'list' as component,
    'Photo : ' as title,
    'Photo : ' as empty_title,
    'Aucune donnée correspondante pour cet élève' as empty_description;
SELECT 
      image_url as image_url,
     'photo_delete_confirm.sql?id='||image.id||'&eleve_id='||$id as delete_link
      FROM image join eleve on image.eleve_id=eleve.id Where image.eleve_id=$id;

SELECT 'list' as component,
    'Parcours : ' as title,
    'Parcours : ' as empty_title,
    'Aucune donnée correspondante pour cet élève' as empty_description;
SELECT 
      parcours.annee_id as title,
      parcours.niveau as description,
     'parcours_delete_confirm.sql?id='||parcours.id||'&eleve_id='||$id as delete_link
      FROM parcours join eleve on parcours.eleve_id=eleve.id Where parcours.eleve_id=$id;

-- Isolement de ses notifications dans une liste
SELECT 
    'alert' as component,
    TRUE as important,
    'NOTIFICATION(S)' as title,
    CASE WHEN $var_notif>=1
    THEN 'alert-triangle' 
    ELSE 'thumb-up'
    END as icon,
    CASE WHEN $var_notif>=1
    THEN 'Il est nécessaire de supprimer les notifications avant de pouvoir supprimer l''élève.' 
    ELSE 'Pas de notification trouvée'
    END as description,
    CASE WHEN $var_notif>=1
    THEN 'orange'
    ELSE 'green'
    END as color;
    --
SELECT 'table' as component,
    'Aucune donnée correspondante pour cet élève' as empty_description,
    'actions' AS markdown;
SELECT 
      eleve.nom as Nom,
      eleve.prenom as Prénom,
      strftime('%d/%m/%Y',datefin) AS Fin,
     group_concat(DISTINCT modalite.type) as Droits,
        '[
    ![](./icons/trash.svg)
](notif_delete_confirm.sql?id='||notification.id||'&eleve_id='||$id||') ' as actions
/*FROM notification INNER JOIN eleve on notification.eleve_id=eleve.id LEFT join notif on notif.eleve_id=eleve.id LEFT join modalite on modalite.id=notif.modalite_id  Where notification.eleve_id=$id GROUP BY notification.id ; */
FROM notif INNER JOIN notification on notif.notification_id=notification.id join eleve on notif.eleve_id=eleve.id LEFT join modalite on modalite.id=notif.modalite_id  Where notification.eleve_id=$id GROUP BY notification.id ;
-- Isolement de ses aménagements dans une liste
SELECT 
    'alert' as component,
    TRUE as important,
    'AMÉNAGEMENT(S)' as title,
    CASE WHEN $var_amenag>=1
    THEN 'alert-triangle' 
    ELSE 'thumb-up'
    END as icon,
    CASE WHEN $var_amenag>=1
    THEN 'Il est nécessaire de supprimer les aménagements avant de pouvoir supprimer l''élève.' 
    ELSE 'Pas d''aménagement trouvé'
    END as description,
    CASE WHEN $var_amenag>=1
    THEN 'orange'
    ELSE 'green'
    END as color;
    --
SELECT 'table' as component,
    'Aucune donnée correspondante pour cet élève' as empty_description,
    'actions' AS markdown;
SELECT 
      eleve.nom as Nom,
      eleve.prenom as Prénom,
      amenag.amenagements AS Aménagements,
      amenag.objectifs AS Objectifs,
            '[
    ![](./icons/trash.svg)
](amenag_delete_confirm.sql?id='||amenag.id||'&eleve_id='||$id||') ' as actions
FROM amenag INNER JOIN eleve on amenag.eleve_id=eleve.id Where amenag.eleve_id=$id GROUP BY amenag.id ;

-- Isolement de ses suivis dans une liste
SELECT 
    'alert' as component,
    TRUE as important,
    'SUIVI(S)' AS title,
    CASE WHEN $var_suivi>=1
    THEN 'alert-triangle' 
    ELSE 'thumb-up'
    END as icon,
    CASE WHEN $var_suivi>=1
    THEN 'Il est nécessaire de supprimer les suivis avant de pouvoir supprimer l''élève.' 
    ELSE 'Pas de suivi trouvé'
    END as description,
    CASE WHEN $var_suivi>=1
    THEN 'orange'
    ELSE 'green'
    END as color;
    --
SELECT 'table' as component,
    'Aucune donnée correspondante pour cet élève' as empty_description,
    'actions' AS markdown;
SELECT 
      eleve.nom as Nom,
      eleve.prenom as Prénom,
      suivi.temps as Temps,
    SUBSTR(aesh.aesh_firstname, 1, 1) ||'. '||aesh.aesh_name as AESH,
            '[
    ![](./icons/trash.svg)
](suivi_delete_confirm.sql?id='||suivi.id||'&eleve_id='||$id||') ' as actions
FROM suivi INNER JOIN eleve on suivi.eleve_id=eleve.id JOIn aesh on aesh.id=suivi.aesh_id Where suivi.eleve_id=$id GROUP BY suivi.id ;