QFQ Extension

Classification:qfq Version:0.5.0 Language:en Description:The extension offers support to: a) create HTML Forms by clicking them together, b) create reports based an SQL queries. The SQL can be nested and offers support for any kind of tags. Keywords:Quick Form Query, Form, Report, SQL, Query, Generator. Copyright:2016 Author:Carsten Rose, Rafael Ostertag Email:carsten.rose@math.uzh.ch, rafael.ostertag@math.uzh.ch License:This document is published under the Open Publication License available from http://www.opencontent.org/openpub/ Rendered:2016-10-17 10:06

The content of this document is related to TYPO3, a GNU/GPL CMS/Framework available from www.typo3.org.

Table of Contents

• What does it do?
• Administrator Manual
  • Preparation
  • Setup
  • FormEditor
  • <ext_dir>/config.ini
• Users manual
  • Features not implemented yet
  • QFQ content element
    • QFQ Keywords (Bodytext)
    • Debug
  • Form
  • Variable (incl. mixed SQL Statement)
  • URL Parameter
  • Escape
  • Sanitize class
  • Store / prio
  • Predefined variable names
    • Store: FORM - F
    • Store: SIP - S
    • Store: RECORD - R
    • Store: CLIENT - C
    • Store: TYPO3 (Bodytext) - T
    • Store: VARS - V
    • Store: SYSTEM - S
  • SQL Statement
  • Form: basic setup
    • Field: Form.showButton
    • Field: Form.parameter
  • FormElements
  • Class: Container
    • Type: fieldset
    • Type: pill
  • Class: Native
    • Type: checkbox
    • Type: date
    • Type: datetime
    • Type: extra
    • Type: text
    • Type: editor
    • Type: note
    • Type: radio
    • Type: select
    • Type: subrecord
    • Type: string
    • Type: submit
    • Type: time
    • Type: upload
      • Deleting a record and the referenced file
  • Class: Action
    • Type: before... | after...
    • Type: sendmail
  • Dynamic Update
• Report
  • General
    • A simple example
  • Syntax
  • Debug the bodytext
  • Structure
    • Text across several lines
    • Nesting of levels
    • Access to upper column values
  • Wrapping rows and columns: Level keys
  • Processing of columns in the SQL result
  • Special column names
    • Column: _link
    • Render mode
    • Link Examples
    • Question
    • Delete
    • Columns: _page[X]
    • Column: _paged
    • Columns: _Page[X]
    • Column: _vertical
    • Column: _mailto
    • Column: _sendmail
    • Column: _advancedmail
    • Column: _img
    • Column: _exec
    • Column: _F
      • Challenge 1
      • Challenge 2
      • Solution
    • Include a form via link/url
  • QFQ CSS Classes
  • Examples
    • Basic Queries
    • Accessing the database
    • Formatting Examples
• Best practice: Form
  • Debug Report
  • More detailed error messages
  • Person search form
  • Form: compute next free ‘ord’ automatically
    • Version 1
    • Version 2
  • Form: Person Wizard - firstname, city
  • Form: Person Wizard - firstname, single note
• Best Practise: Chart
• Links