Link.sql 625 B

12345678910111213141516171819
  1. SET ":link" = COALESCE(:link, 'https://shandan.one/'||:tool);
  2. SELECT 'text' AS component
  3. , '<div class="pure-g" sty>
  4. <div class="pure-u-1">
  5. <div class="pure-button" style="margin: 1em 0 0; background: '||:color||';">
  6. <a href="'||:link||'" style="color: floralwhite;">'||:link||'</a>
  7. </div>
  8. </div>
  9. </div>' AS html
  10. ;
  11. SELECT 'dynamic' AS component, sqlpage.run_sql('sqlpage/QR.sql') AS properties
  12. WHERE COALESCE (:hash, '') = '';
  13. SET ":inner" = CASE COALESCE(:hash, '')
  14. WHEN '' THEN :tool||'/form.sql'
  15. ELSE 'sqlpage/validate.sql'
  16. END;
  17. SELECT 'dynamic' AS component, sqlpage.run_sql(:inner) AS properties;