admin.sql

select 'dynamic' as component, sqlpage.read_file_as_text('website_header.json') as properties;

select 'alert' as component, 'Saved' as title, 'success' as color where $saved is not null;
select 'alert' as component, 'Deleted' as title, 'danger' as color where $deleted is not null;
select 'alert' as component, 'This option cannot be deleted' as title, 'danger' as color, 'If an option has already been chosen by at least one respondant, then it cannot be deleted' as description where $cannot_delete is not null;

select 'dynamic' as component,
    json_array(
        json_object(
            'component', 'form',
            'title', CONCAT('Option ', id),
            'action', CONCAT('edit_option.sql?id=', id),
            'validate', '',
            'id', CONCAT('option', id)
        ),
        json_object(
            'type', 'text',
            'name', 'profile_description',
            'label', 'Profile description',
            'value', profile_description
        ),
        json_object(
            'type', 'number',
            'name', 'score',
            'min', 0,
            'label', 'Score',
            'value', score
        ),
        json_object('component', 'button', 'size', 'sm'),
        json_object('title', 'Delete', 'outline', 'danger', 'icon', 'trash', 'link', CONCAT('delete_option.sql?id=', id)),
        json_object('title', 'Save', 'outline', 'success', 'icon', 'device-floppy', 'form', CONCAT('option', id))
    ) as properties
from dog_lover_profiles;

select 'button' as component, 'center' as justify;
select 'Create new question' as title, 'create_question.sql' as link;