12345678910111213141516171819 |
- SET ":link" = COALESCE(:link, 'https://shandan.one/'||:tool);
- SELECT 'text' AS component
- , '<div class="pure-g" sty>
- <div class="pure-u-1">
- <div class="pure-button" style="margin: 1em 0 0; background: '||:color||';">
- <a href="'||:link||'" style="color: floralwhite;">'||:link||'</a>
- </div>
- </div>
- </div>' AS html
- ;
- SELECT 'dynamic' AS component, sqlpage.run_sql('sqlpage/QR.sql') AS properties
- WHERE COALESCE (:hash, '') = '';
- SET ":inner" = CASE COALESCE(:hash, '')
- WHEN '' THEN :tool||'/form.sql'
- ELSE 'sqlpage/validate.sql'
- END;
- SELECT 'dynamic' AS component, sqlpage.run_sql(:inner) AS properties;
|