CHANGELOG.md

.. ================================================== .. ================================================== ..
================================================== .. Header hierarchy .. == .. -- .. ^^ ..    ""
.. ;; .. ,, .. .. --------------------------------------------used to the update the records specified ------ .. Best
Practice T3 reST: https://docs.typo3.org/m/typo3/docs-how-to-document/master/en-us/WritingReST/CheatSheet.html
.. Reference: https://docs.typo3.org/m/typo3/docs-how-to-document/master/en-us/WritingReST/Index.html
.. Italic *italic*
.. Bold **bold**
.. Code ``text``
.. External Links: `Bootstrap <http://getbootstrap.com/>`_
.. Internal Link: :ref:`downloadButton` (default url text) or :ref:`download Button<downloadButton>` (explicit url text)
.. Add Images:    .. image:: ../Images/a4.jpg .. .. .. Admonitions .. .. note::   .. important::     .. tip::     ..
warning::
.. Color:   (blue)       (orange)           (green)      (red)
.. .. Definition:
.. some text becomes strong (only one line)
.. description has to indented

.. -*- coding: utf-8 -*- with BOM.


.. include:: Includes.txt

.. _release:

Release
=======

Version 22.x.x
--------------

Date: <date>

Notes ^^^^^

Features ^^^^^^^^

Bug Fixes ^^^^^^^^^

Version 22.5.0
--------------

Date: 16.5.2022

Notes ^^^^^

Please update your CSS and JS (T3 Main Template > Setup) to include the new DateTime Picker. Forms cannot save if the JS
files are missing::

page.includeCSS.file08 = typo3conf/ext/qfq/Resources/Public/Css/bootstrap-datetimepicker.min.css page.includeJS.file14 =
typo3conf/ext/qfq/Resources/Public/JavaScript/moment.min.js page.includeJS.file15 =
typo3conf/ext/qfq/Resources/Public/JavaScript/bootstrap-datetimepicker.min.js

Features ^^^^^^^^

* # 9052 / Report frontend editing: CodeMirror with syntax highlight.
* # 10096 / Date time picker.
* # 10782 / TinyMCE: image upload via drag'n'drop. 'fileUploadPath=fileadmin/...'.
* # 13440 / Form: remember last used pill in localstore.
* # 13543 / System - base url: multiple base url can be configured.
* # 13562 / System - base url: if not set, set base url.
* # 13572 / Form Load: better error message on try to load non existent record.
* # 13581 / Copy to clipboard: small animation on icon.
* # 13657 / Added two new twig report files to system: FormEditorTwig and autoCronTwig.
* # 13679 / tablesorter/subrecord: view-saver added.
* # 13788 / Date time picker: selectable weekdays.
* Update / doc: datetimepicker requires moment.js - put it in example code before datetimepicker.
* Update / QFQ config note to baseUrl.
* Skip selenium to speed up.
* Move Marc Egger to further contributor.

Bug Fixes ^^^^^^^^^

* # 9520 / Button Save inside form.
* # 10646 / typeAhead: maxLength by default 512.
* # 11134 / Set samesite header for cookies.
* # 11325 / SQL CALL is handled seperate. All statements will execute. If only a SELECT statement is used in PROCEDURE then the output will shown, otherwise not.
* # 13658 / qfq.json: remove world readable.
* # 12483 / qfq.json - Doc: update all references of config.qfq.php to qfq.json
* # 12484 / config.render: old Both, new: Single.
* # 13084,9724 / Dropdown list on iOS not clickable.
* # 13527 / Form Multi: by default set r=0.
* # 13677 / FormEditor: Preview disabled if 'new.required' is given.
* # 13722 / Detect and fix pdfunite problems "Gen inside xref table too large (bigger than INT_MAX)" via pdf2ps, ps2pdf.
* # 13767 / Date time picker: up down button better design if required.
* # 13827 / Date time picker should not offer user credentials (like username / password).
* # 13751 / Date time picker dynamic update aware.
* # 13797 / Checkbox: dynamic update (single and multi) fixed.
* # 13818 / typeahead: fix for key/value problem: expects parameter 1 to be string, array given.
* # 13842 / Broken SIP: wkhtml and qfqpdf.
* # 13933 / Broken SIP: exception handling buggy.
* # 13860 / Safari: broken typeahead input.

Version 21.12.0
--------------

Date: 13.12.2021

Notes ^^^^^

* New HTML to PDF renderer: puppeteer. Wrapped and used by qfqpdf. Solves various JS and CSS problems of wkhtml.
  Install:

  mkdir /opt/qfqpdf; cd /opt/qfqpdf curl -L -o qfqpdf https://www.math.uzh.ch/repo/qfqpdf/current/qfqpdf-linux
  chmod a+x qfqpdf

* Module php-curl not needed anymore - has been replaced by php-stream.

Features ^^^^^^^^

* # 4812 / Subrecord - check for reserved Typo3 keywords (id, type, L) and throw exception.
* # 10145 / Typeahead Min Length = 0 is now possible.
* # 10715 / qfqpdf (puppeteer).
* # 13113 / Rewrite REST Client as php stream, add contentFile option.
* # 13242 / Apply given sanitize class to all defined stores.
* # 13330 / Multi Form: Upload.
* # 13333 / Option: Switch off attack detect.
* # 13496 / TinyMCEfontselect - Fontselect and fontsize are removed from the default configuration.
* # 12511 / Typo3 Store: new variables.
* # 13526 / QFQ tablesorter: Rename 'private view' to 'personal view' and 'public view' to 'group view'.
* # 12541 / Page and link without pageAlias.

Bug Fixes ^^^^^^^^^

* # 3446 / Unknown permission mode: 'logged_in'
* # 9268 / SELECT with outer brackets not recognized as SELECT
* # 13030 / Max length cuts - line endings \r\n has been counted as two chars. During input they are counted as 1 and
  therefore on data load the string has been cutted.
* # 13139 / Tablesorter: some elements are in front of a sticky title row
* # 13507 / QFQ function should work without 'sql='
* # 13525 / makefile adjusted for multiple users


Version 21.6.0
--------------

Date: 29.6.2021

Notes ^^^^^

* For full image HEIC/HEIF support, please install package ``libheif-examples``.

Features ^^^^^^^^

* # 8945 / Best practice `self-registration`_
* # 12551 / Add QFQ bootstrap diagram
* # 12615 / Implements silent HEIC/HEIF conversion to png. Write a note in realease notes, to install 'libheif-examples'.
* # 12636 / New FormElement.encoding = 'single tick'
* Form.rst: Update doc of Multi-Form

Bug Fixes ^^^^^^^^^

* # 12701 / Bug 'spaces in mails'. Replaces '<br>' by '<br>\r\n'
* # 9371 / MultiSQL now accepts `_id` too.
* # 12674 / QFQ Function subheader: skip deleted
* Remove keySemId and keySemIdUser - outdated / deprecated since 0.19.0 (pre 09.2017)
* Download.php: Fix broken variable $this->$downloadDebugLog.

Version 21.5.1
--------------

Date: 17.05.2021

Notes ^^^^^

* The `log` directory was moved into the `qfqProject` directory in version 21.2.0 for new installations. But if the
  directory `fileadmin/protected/log` already exists then QFQ keeps storing logs there. This was added to release notes
  of 21.2.0 in hindsight.

Features ^^^^^^^^

* # 12183 / Download table as csv
* # 12159 / Make url paths absolute (relative to baseUrl)

Bug Fixes ^^^^^^^^^

* # 12516 / Password Hashing Exception

Version 21.5.0
--------------

Date: 02.05.2021

Features ^^^^^^^^

* CodingGuideline.rst: add Form Best practice

Bug Fixes
^^^^^^^^^

* # 10505 / Drag'n'Drop broken on Multi DB Instance - all checks done
* # 10754 / Clean up stale requirements.txt
* # 11769 / Missing description table in Form.rst
* # 12352 / Form As Json: copy via JSON in FormEditor broken.
* # 12398 / Fix check required for uploads
* # 12475 / During QFQ update take care that all system tables exist.
* # 12479 / Remove unwrap('p-tag') for TinyMCE - currently, this breaks regular consecutive <p> tags


Version 21.4.0
--------------

Date: 11.04.2021

Notes
^^^^^

* The new introduced 'Form As File' Feature in QFQ Version  21.3.* has been disabled. Instead every form can be imported
  and exported as JSON. The automatic import/export was not stable and a manual process promises less problems.

Features
^^^^^^^^

* #12015 / useAdvancedFormEditor: disable form sync using feature flag
* #12346 / Add new formJson.json to system forms
* #12345 / Update documentation of special column formJson
* REST.rst: small reformat.
* Add Test copyToClipboard
* HTTP Header: Add 'X-Api-Key'. Fix problem for token without argument name. Update doc.
* Add margin to qfq-badge
* Fix undefined clearMe

Bug Fixes
^^^^^^^^^

* #12341 / FormSubmitLog also saves FormName (not only FormId)
* #11265 / Dropdown Menu: wrap with <p> breaks dropdown
* #12268 / Enhanced FormSubmitLog Page Sample Code
* gitlab-ci.yml: `mkdir -p ... ` suppresses warning if directory already exist. Add more descriptive message.
* docker/run_qfq_docker.sh: 'source' eines files, das nicht existiert, gibt immer einen Fehler auf stdout.
* Fix problem: /var/www/html/my/typo3conf/ext/qfq/Classes/Core/Form/FormAction.php / Line: 394 / Undefined index: saveFormJson
* extension/Classes/Core/Helper/SessionCookie.php: Index 'host' was empty


Version 21.3.2
--------------

Date: 22.03.2021

Features
^^^^^^^^

* #9528 / Implement option 'clearMe' to show a small X in input & textaera fields per FormElement, per Form or global.

Bug Fixes
^^^^^^^^^

* #12015 / use Advanced Form Editor - problem with uppercase f in Form for form name.

Version 21.3.1
--------------

Date: 21.03.2021

Notes
^^^^^

* Custom QFQ Function:

  * Call QFQ function from inside a report, at any place, as often as needed. The QFQ function code will be parsed only
    one time. Variables will be replaced in time.
  * Based on QFQ function: a new download source can be specified : source:<function name>

Features
^^^^^^^^

* #11998 / Custom QFQ-Function
* #12015 / Use Advanced FormEditor

Bug Fixes
^^^^^^^^^

* Bug with empty Fabric string fixed

Version 21.3.0
--------------

Date: 07.03.2021

Notes
^^^^^

* To enforce usage of the new form-list we throw an exception on QFQ update if the line "file=_formEditor" is not
  present in any tt-content bodytext. :ref:`form-editor`.
* Persistent download links, combined with SQL based access check. :ref:`download`.
* Check new file based definition of forms :ref:`form-as-file` - this makes it easier to work in team with GIT based files.

Features
^^^^^^^^

* #12085 / Persistent download links.
* #12022 / New Escape class HtmlSpecialChar 'h'
* #11957 / Get European Timezone {{start:R::t}}
* #11926 / Update Form As File Documentation
* #12015 / Add formEditor as a system QFQ report and enforce formEditor existence
* #11926 / Use alternate form and report directories for phpunit (form_phpunit)
* #11953 / Logger.php: replace makePathAbsolute with Path functions
* #11931 / Report minimal required PHP version and stop, if PHP version is too low.
* #9213 / Add note for tablesorter.
* Add EV tips for tablesorter as a table in doc

Bug Fixes
^^^^^^^^^

* #12016 / Run Typo3 autoloader before password hashing if API request
* #5444 / Typeahead FE value is now prefetched after save.

Version 21.2.0
--------------

Date: 01.02.2021

Notes
^^^^^

* The `log` directory was moved into the `qfqProject` directory in version 21.2.0 for new installations. But if the
  directory `fileadmin/protected/log` already exists then QFQ keeps storing logs there. This was added to release notes
  of 21.2.0 in hindsight.

Features
^^^^^^^^

* # 10286 / Download Links: Glyphicon selbst wählen/ausblenden
* # 11878 / Purge extension option config.documentation
* # 6793 / Source files for ZIP archives might now specified with a path/filename how they are called inside the ZIP.
* log directory was moved into qfqProject directory

Bug Fixes
^^^^^^^^^

* #11925 / downloadButton Parameter 'd:Filename'
* #9355 / Increase column width header & attach
* #11865 / Form Editor exception when edited after saved
* #11798 / Use T3 password hashing API instead of hack
* #11750 / Checkbox does not work together correctly with required fields
* #11666 / PHP 7.4: Trying to access array offset on value of type int
* #11245 / If forwardMode column is set to '', set forwardMode to 'auto'

Version 20.11.0
---------------

Date: 12.11.2020

Features
^^^^^^^^

* #7156 / Throw exception when a report level is defined twice.
* #11335 / Sanitize Alnumx: allow 'ß'
* #11325 / Allow SQL CALL(). Unsupported: Multiple (like query_multi()) - only the first one will be returned.
* #11269 / REST Post might return a customized answer.
* #11512 / Twig: add access to Var store
* #11118 / Uniqueness is now guaranteed in {{random:V}}
* #11513 / Add special column AS _script
* #11509 / PDF split fails for broken PDF
* #10979 / Ajax Calls an API - dataReport

Bug Fixes
^^^^^^^^^

* #11430 / phpSpreadsheet throws exception that '' is not numeric
* #10257 / Delete AS _link only worked with certain parameter order.
* #11511 / Tablesorter: fix encoding error, sanitize base64 encoding
* #11146 / Sendmail dynamic PDF broken
* #10554 / Fix extrabuttonlock also for select, radio and checkbox
* #11245 / If forwardMode column is set to '', set forwardMode to 'auto'

Version 20.9.0
--------------

Date: 06.09.2020

Notes
^^^^^

* New SIP protected AJAX calls.
* Report now fires calls to websocket (remote hosts).
* Report now fires REST calls to remote hosts.

Features
^^^^^^^^

* #10979 / Report: do SIP protected AJAX calls to typo3conf/ext/qfq/Classes/Api/dataReport.php.
* #11076 / Report: trigger call to websockets.
* #11119 / Report: REST Client calls - incl. processing of answer.
* Add CodingGuideline.rst.

Bug Fixes
^^^^^^^^^

* #10919 / AutoCron: Fix missing FillStoreSystemBySql.
* #11075 / Form: Missing SQL error message in FE Action Elements.
* #11039 / Fix CSS for Checkbox.

Version 20.6.2
--------------

Date: 25.06.2020

Bug Fixes
^^^^^^^^^

 * #10641 / TypeAheadTag: Fehler beim gleichzeitigen anlegen mehrerer neuer Tags
 * #10794 / Documentation: Crontab entry more clearly


Version 20.6.1
--------------

Date: 24.06.2020

Features
^^^^^^^^

 * #10778 / Upload ZIP and unpack


Version 20.6.0
--------------

Date: 14.06.2020

Notes
^^^^^

 * Add note in Installation.rst to start Apache with Locale en_US.UTF-8. This helps to support Umlaut and other characters
   in filenames and wkhtml commandline options (like header/footer).
 * Migrate documentation from T3 to ReadTheDocs.io - looks older but 'search' is much more better. New: chapters separated
   in individual files.
 * For the image to PDF feature, installation of `img2pdf` is required (please check :ref:`preparation`).

Features
^^^^^^^^

 * #10751 / Allow images to be concatenated for PDF download.
 * Fontawesome updated 5.13.
 * Extend FE.label size to 1023.
 * Local documentation rendering directly via Sphinx.
 * Manual: Search is working, table width not truncated anymore, PDF & epub export, redirect qfq.io/doc to docs.qfq.io.
 * Update copyright notice.

Bug Fixes
^^^^^^^^^

 * #10507 / FormElement.type: 'annotate' is defined two times in Enum
 * #10705 / New function 'HelperFile::joinPathFilename($pre, $post)'. Joins only if $post is without leading slash.


Version 20.4.1
--------------

Date: 30.04.2020

Notes
^^^^^

* Developer: update local npm/font awesome packages via ``make bootstrap``.

Features
^^^^^^^^

* #10433 / Update to Font Awesome 5.0
* #10379 / Stored Procedure: SLUGIFY()
* Manual.rst: Example Report 'render'. Update several places to fit latest ReST layout rules.

Version 20.4.0
--------------

Date: 05.04.2020

Notes
^^^^^

* New Feature: :ref:`type-ahead-tag` - extend regular input with multiple values via typeAhead. _
* MySQL StoredProcedure:

  * strip_tags() - Simple strip html tags.
  * QCC() - Escape colon / coma. Useful for QFQ link arguments like 'text' or 'tooltip'.

Features
^^^^^^^^

* #9686 / Download: sanitize output filename.
* #10358 / Configure path/environment via QFQ config: qpdf, gs, pdfunite.
* #9517, #10145, #10177, #10117 / typeAheadTag.
* #10152 / QCC() - Stored Procedure to escape colon / coma.
* FabricJS: replaced glyphicons with font awesome.
* Rename config.qfq.example.php config-example.qfq.php.

Bug Fixes
^^^^^^^^^

* #6798 / Close didn't worked with r=0.
* #10199 / Form.forwardMode: missing mode 'Close' / 'Auto'.
* #10173 / Dynamic Update: Readonly element can't be activated via dynamic update.
* Fix broken default value for Form.forwardMode.
* Fix problem with reporting broken TG-FormElements.
* Add error message if primary table does not exist.

Version 20.2.0
--------------

Date: 02.02.2020

Notes
^^^^^

* Add new keyword 'render' in tt-content Report and QFQ config. 'render' will control if a) only Form OR Report will be
  rendered  (render=single) or b) as previous Form AND Report together (render=both).

  * Advantage: with 'render=single' no more SELECT ... FROM (SELECT '') AS fake WHERE '{{form:SE}}'=''.

  * Attention: NEW default behaviour in new QFQ installations - render=single. Behaviour in old installations is unchanged.

* tt-content records with 'render = api' can stay on the same page as the link to get the content (e.g. Excel Export).
* Change default doc page to qfq.io/doc.
* Add new specialColumnName: '_noWrap' - skips wrapping of fbeg,fsep,fend.
* First version of 'FullCalendar.io' - new SpecialColumnName will follow in the future.

Features
^^^^^^^^

* #9929 / New keyword '_noWrap' for column names (alias) - skips wrapping of fbeg/fskip/fend.
* #9905 / Keyword 'render' in Report. Final implementation. Doc updated.
* #9959 / Update QFQ Config on the fly.
* #9990 / Describe order of FormElement processing - :ref:`form-process-order`.
* #8658 / FullCalendar.io V3 implemented.
* #9535 / VerticalText new implementation.
* Manual.rst: Add list of icons. Enhance sendmail doc.
* Change color of qfq-info-* from blue to light-blue. Add qfq-primary, qfq-danger.

Bug Fixes
^^^^^^^^^

* #10010 / FE.type=sendmail will now be fired together with fe.type=after* (not after).
* #5869 / Table names not properly escaped.
* #9638 / TextArea: Autosize - broken when using clipboard,
* Fixed problem with border showing when qfq-color-white is set.
* Fix selenium tests, remove chromedriver from npm.
* Log problem that crashes qfq when calendar dependencies are missing.
* Fixed gruntfile problem.


Version 20.1.1
--------------

Date: 13.01.2020

Bug Fixes
^^^^^^^^^

* #7705 / Fix problem with wrong value after save and form update.
* #8587 / A form triggers a save only, if there are real table columns.

Version 20.1.0
--------------

Date: 09.01.2020

Notes
^^^^^

* Deprecated: Form.parameter.mode. Use Form.parameter.formModeGlobal

Features
^^^^^^^^

* #9805 / Form.parameter.activateFirstRequiredTab.
* #9858 / Form.parameter: replace 'mode' by 'formModeGlobal'
* #9860 / SQL function qmore(): change text '...' to '[...]'.
* Update Developer doc for record locking.
* Mockup for error handling.

Bug Fixes
^^^^^^^^^

* #7925 / Error in split PDF file during upload. Fix the cwd error in Logger.
* #9789 / Record lock release to early on 'leave page'. QfqJS: Moved release lock to before unload.
* #9861 / Fix problem with broken sql.log filename.
* #8851 / Revert implementation: LogMode 'modify' vs. 'modifyAll'.
* #9859 / Database Update: check for 'Update specialColumnName needed' breaks new QFQ install.
* #9813 / During QFQ database update, skip errors like 'Error 1060 - Duplicate Column'.
* Manual.rst: Fix various broken table layouts.

Version 19.12.0
---------------

Date: 17.12.2019

Notes
^^^^^

* Switch the whole homepage to readonly: FormModeGlobal and STORE_USER

Features
^^^^^^^^

* TinyMCE: grey out controls when readonly.
* Mockup:

  * Update files to get CSS & JS files from their own directory structure (not an installed QFQ extension).
  * Add fontawesome, tablesorter to mockup 'formCheckbox.html'.

* CI: Download selenium logs (only failed) under artifacts.
* Dev: .gitignore: exclude some docker & selenium.
* Merge Selenium Python Checks into Master.
* #9686 / html decode and sanitize an export filename to become the 'save as'-filename.
* #9666 / min-width for extraButtonInfo.
* FormEditor: optimize minWidth for 'rowLabelInputNote' field.

Bug Fixes
^^^^^^^^^

* #9720 / Checkbox dynamic update varoious settings:

  * Multi Plain Vertical & Horizontal, Checkbox Multi BS.
  * Fixed that label of 'checkbox' are bold and label of 'checkbox-inline' are normal.

* #7974 / TinyMCE: ReadOnly.
* #9424 / modeSql: skip if it starts with '#'.
* #9674 / Select Required Dynamic Update.
* #9678 / textarea now trigger DynamicUpdate.
* #9679 / FormModeGlobal: add STORE_USER - system wide readonly.
* #9690 / Select Required.
* #9691 / Checkbox: dynamic update > readonly. HTML ID for checkbox elements. Dynamic update switch 'readonly' for 'checkbox plain multi' and 'radio plain multi'.
* #9692 / Keyboard Select Checkbox.
* #9720 / Checkbox: Various setups with dynamic update.
* #9733 / Identify different tabs. Record lock for same tab will always be granted.
* #9734 / Fix 'dirty lock release' - leaving a dirty form without closing, leaves a stale lock record. Added a releaselock() before window.unload. Dirty remove on goBack.
* #9735 / File Delete: no dirty trigger.

* Download / PDF merge: skip leading errors, interpret only 'Could not merge encrypted files'.
* DragAndDrop broken: after refactoring Support.php, the dragAndDrop was broken - missed init of '$store'.

Version 19.11.3
---------------

Date: 29.11.2019

Features
^^^^^^^^

* #8886 / Check pattern: after focus lost.
* #9655 / Checkboxes and radios now defined with a min-width in horizontal plain mode.
* #9617 / formModeGlobal:

  * Two modes of 'formModeGlobal' available: 'requiredOff' and 'requiredOffButMark'.
  * 'requiredOffButMark':

    * Renamed temporary 'skipRequiredCheck' to 'requiredOffButMark'.
    * Keep required marks after save.
    * Stop hiding helpblocks per default, set with class qfq-only-active-error.

* Radio: new class 'qfq-disabled' if readonly is set. Softer blue. Mark disabled - changed hover. Text in darker orange.
  Simple-error renamed to qfq-notify - removed box around error.
* New default class for 'form' tag: 'qfq-notify'.
* Manual.rst: Add info for 'letter-no-break'.
* Add validator.js to list of used packages.

Bug Fixes
^^^^^^^^^

* #9670 / If `qpdf` fails to decrypt a PDF, try `gs`.
* #3995 / Implemented partly: CheckBox and Radio can now be locked.
* #8091 / Checkbox required:

  * If radio or checkbox is required and empty on submit, form save brings the element to front.
  * Fix radio plain vertical.
  * Fix label2 not to be bold.
  * Checkbox Plain Vertical: forces 'font-weight: 400;'.
  * Updated colors for checkboxes/radios.

* #9638 / Textarea Sizing: Now also listens for paste.
* #7891 / Added missing 'type="button"' to button element.
* Remove ' style="font-size: 1em;"' in extraButton - this causes extra space between multiple extraButton inline in one input element.

Version 19.11.2
---------------

Date: 25.11.2019

Notes
^^^^^

* Enhance formModeGlobal=requiredOff/-ButMark (temporarily skipRequiredCheck): fill's '{{allRequiredGiven:V}}' before
  save to 1 (all given) else 0.
* Offers user to save form, even if not all required data are given and offers application logic to check easily if all
  required fields has been filled.

Features
^^^^^^^^

* #9526 / Mark required fields more visible.
* #9617 / Improve 'formModeGlobal=requiredOff'.

  * Feature `Form.formModeGlobal` implemented - STORE_SIP overwrites form definition.
  * New STORE_VAR variable 'allRequiredGiven'. Becomes '1' if all required fields are given, else 0.

* Add param 'L' & 'type' automatically to form save.
* Manual.rst: Procedure to find an irreproducible error.
* Change definition of QFQ system tables for 'modified' and 'created'. Use DATETIME instead of TIMESTAMP.

Bug Fixes
^^^^^^^^^

* #7639 / subrecord drag n drop:

  * `orderInterval` has not been respected.
  * Update Manual.rst.
  * Fake STORE_SIP so it can be used during processing sql1.
  * The record, currently loaded into form, is available via STORE_RECORD.
  * Check for id/_id and ord/_ord.
  * Throw meaningful exception if missing 'id' or 'ord'.

* Fixes bug that no mime_type_content is called if there is on file.
* Fix broken regex101 url.

Version 19.11.1
---------------

Date: 11.11.2019

Bug Fixes
^^^^^^^^^

* #9532 / 'Advanced Upload' broken -  slaveId/sqlUpdate/... have been processed two times, after multiform code changes.

Version 19.11.0
---------------

Date: 08.11.2019

Notes
^^^^^

New CSS Class:

* 'qfq-sticky' - to make an element sticky.

Update/new stored procedures:

* QMORE: change symbols from '..more' / '..less' to '...' / '<<'.
* QIFEMPTY: add empty detection for a) date, b) datetime, c) '0'.
* QDATE_FORMAT(timestamp). Return text in 'dd.mm.yyyy hh:mm' format or '-' if timestamp is empty.

Features
^^^^^^^^

* #9521 / Textarea auto-grow. Update Manual.rst. New class qfq-auto-grow for textareas.
* Update FormEditor to 80,1,350.
* Alerts a) changed overlay to blur and white, b) optimized to better reading for developer - ':hover' inside of error messages: black text and blue highlight.
* Add new CSS class 'qfq-sticky-element' - to stick individual elements.

Bug Fixes
^^^^^^^^^

* #9354 / Missing border around form if there are no pills / no title
* #9053 / Using the tablesorter filter in form triggers dirty detection for save. Set qfq-skip-dirty on all tablesorter-filter.
* #2720 / Formelement 'radio' - required failed.
* #9512 / PDF merge fails on encrypted PDFs. Try to use qpdf to decrypt.
* #6232 / Missing required: Pill/Input not 'bring to front' - Textarea, Editor, Radio.
* #9300 / Fix Name restMethod-FormElement.
* Add '@' to various PHP/IO function to suppress generic OS exception - now QFQ will report customized messages.
* FormEditor / error message: fix missing formId in STORE_SIP on calling FE directly from error message.
* Manual.rst: Tip for wkhtml added. Add description for 'fileButtonText'. Adjustments for 'slaveId' concept.


Version 19.10.0
---------------

Date: 17.10.2019

Notes
^^^^^

* Background color of popups & error messages changed.
* slaveId/sqlInsert/sqlUpdate/sqlDelete are now available for all FormElements.
* New MySQL stored procedure strip_tags() function.

Features
^^^^^^^^

* #5695 / First implementation of multiform.
* #7495 / Removed dirty flag when 'enable-save-button' is set.
* Add MySQL strip_tags() function.

Bug Fixes
^^^^^^^^^

* #9329 / Fabric annotations. Fixed Scaling Problem on Static Canvas instances.
* #9298 / Fix timeout of file_get_contents. Extend timeout for downloadPage to 10min.
* #9274 / PHP 7.3 reports: switch statement with 'continue 2'.
* #9269 / fillStoreForm now fired two times in API calls. The first time during loadFormDefinition and the second time after the STORE_TYPO3 has been faked via SIP.
* Manual.rst: Add '!' to fillStoreVar Query
* Increase z-index in CSS 'dropdown-menu' class to 1060. The 'tablesorter > columnselector' will be hidden with 'qfq-sticky' by values < 1000.
* Reduce z-index in CSS 'qfq-sticky' class from 9999 to 1000. The 'tablesorter > columnselector' will be hidden with values > 1060.

Version 19.9.1
--------------

Date: 21.09.2019

Notes
^^^^^

* Use the CSS class 'qfq-sticky' in `<thead>` to make a table header 'sticky' - on long pages such tables headers are always
  visible.
* The page with the list of all forms: a new best practice report includes useful statistics :ref:`Form-Editor-Usage` - best
  is to replace the old code.
* The DB User needs privileges to the Typo3 database of at least table `tt_content` with SELECT.

Features
^^^^^^^^

* #9203 / Pin the header of table (CCS 'sticky'), to make it always visible even if the page scrolls down.
* #9172 / AutoCron: new colum 'autoGenerated', 'xId'
* #9089 / Move Stored Procedure to SECURITY=INVOKER
* Manual.rst: Best practice :ref:`Form-Editor-Usage`
* Reduce BS legend.font-size from 21 to 17.
* Change doc of tablesorter to use 'sorter-false' as class.

Bug Fixes
^^^^^^^^^

* #9074 / QFQ query with nested QFQ query failed, if the outer QFQ query is a multi column query ( ='{{!' ). Fixed.

Version 19.9.0
--------------

Date: 09.09.2019

Notes
^^^^^

* Size of input elements now might be specified dynamically (with min and max height).
* Twig converts JSON objects to an array.

Features
^^^^^^^^

* Report.php: Twig, convert JSON object into associative array.
* Test SQL stored procedure in Form report.
* qfq-bs.css.less: a) reduce 'qfq-note' padding-top from 7 to 2 px, b) reduce 'legend' margin-bottom from 25 to 0.
* Debug output sendmail redirect all: addresses now always space delimited.
* FormEditor:

  * Remove FormElement 'tabindex'.
  * Change FormElement.class from 'Select' to 'Radio'.

* Manual.rst:

  * Clean syntax highlight.
  * Update realtime log file QFQ code.
  * Add 'Best Practice' code to show QFQ log files in realtime. Reformat some content.

* #7849 / New option 'fileTrash' and 'fileTrashText'.
* #7682 / 'Input textarea auto height'
* #4434 / Special column names now have to start with underscore. Earlier it was recognised even if there was no underscore.

Bug Fixes
^^^^^^^^^

* #7860 / Special column name 'mailto' no handles text correctly if multi byte encoded. Fixed.
* #7849 / Missed filename after the file chooser selected an file. Fixed.
* #1201 / FE.parameter option 'tabindex' has never been implemented. Removed.
  According https://developer.mozilla.org/en-US/docs/Web/HTML/Global_attributes/tabindex only the values '0' and '-1' are good.
* Add table html-id to subrecords, created by QFQ. Needed for tablesorter.
* Add TinyMCE to list of 'Software distributed together with QFQ'

Version 19.8.0
--------------

Date: 28.08.2019

Features
^^^^^^^^

* Manual.rst:

  * Update tablesorter ``class="sorter-false"``.
  * Add note to include font-awesome.
  * QFQ_LOG documentation.
  * Enhance wkhtml debug info.
  * Add link to https://mariadb.com/kb/en/library/stored-routine-privileges/

* Increase Length of column Form.forwardPage limit from 255 to 511.
* Index.rst: Add Rafi, Elias, Nicola as further contributors.
* Add SQL stored procedure QIFEMPTY().
* #8806 / Add SQL stored procedure QNL2BR().
* #8851 / Add sqlLogMode modifyAll and restrict sqlLogMode modify.
* #8859 / FormEditor: Filter + ColumnSelector.
* #8856 / AutoCron: SQL logMode should be defined separately.

Bug Fixes
^^^^^^^^^

* #8933 / Broken record lock: lock extend does not work - fixed.
* #8846 / FormEditor: subrecord of FormElement might be wider than Form.
* #8853 / fe.class=action: container should be hidden - hidden is wrong - FE-action might be assigned to templateGrou
  Container. New solution: if FE.class='action' only templateGroups are in the 'container' list.
* #6656 / Merge DragnDrop into 'master'
* Update compatibility: API change in T3 makes QFQ incompatible with Typo3 >=9.4. Change compatibility back to <9.3.
  Problem: sys_language_uid
* Update QFQ from earlier/equal version than 0.19.2 fails to create table 'Cron'.


Version 19.7.1
--------------

Date: 17.07.2019

Notes
^^^^^

* TWIG integration

Features
^^^^^^^^

* TWIG:

  * Add Twig Extension to parse QFQ Links
  * Pass assoc-array of query result as context
  * allow to pass template as string

* Database.php: extend function sql error message
* #8179 / extraButtonLock and extraButtonPassword might be specified without a value or with 0 or with 1.

Bug Fixes
^^^^^^^^^

* Database.php: fix CodeException
* Fabric: Readonly now displays annotations again.

Version 19.7.0
--------------

Date: 02.07.2019

Notes
^^^^^

* Settings for tablesorter can now be saved.
* Selenium docker based is integrated now.

Features
^^^^^^^^

* #7284 / tablesorter save sort order
* #8592 / Fixed button display, added Alert instead of disabled button.
* #8204 / position required mark
* Excel.php: Delete superficial autoloader require
* Cleanup: hashPassword.php moved from Api to External.
* Cleanup unwanted git tracked files: Documentation-develop/jsdoc|...
* Selenium + Docker
* Update .gitignore - documentation directory moved several days ago.

Bug Fixes
^^^^^^^^^

* #6917 / Fix Monitor does not work.
* #8098 / Fix Language specific retype label or note has not been set correctly.
* Fix undefined index and potential undefined index.
* Fix Autoloader for External/AutoCron.php.
* Small fixes Manual.rst.
* Fix broken Manual: unwanted '<' after '{{!' lead to fully broken Manual.
* Fix path Source/api to Source/Api.

Version 19.6.2
--------------

Date: 21.06.2019

Notes
^^^^^

The Rest API path changed:

* old: typo3conf/ext/qfq/Source/api/rest.php
* new: typo3conf/ext/qfq/Classes/Api/rest.php

QFQ is now PSR4 compliant.

Features
^^^^^^^^

* #8520 / Switch to psr4 composer.
* #8272 / Disable 'save' button as long as an upload is running.
* #7529 / Guarantee Sip Action plays only once.
* #8577 / Documentation enhanced for behaviour of SELECT '_test'.

Bug Fixes
^^^^^^^^^

* #7903 / Delete with 'table' as parameter doesn't work anymore.
* #8571 / Primary Key: report error if lower/uppercase don't match - in general if given primary key is not found in table definition.
* #8465 / Var substitute: '{{name:R:::0}}' default not used if it is '0'.

Version 19.6.1
--------------

Date: 16.06.2019