Skip to content
Snippets Groups Projects
CHANGELOG.md 91.6 KiB
Newer Older
Carsten  Rose's avatar
Carsten Rose committed
* #6563 / Accept 0 as required.
Carsten  Rose's avatar
Carsten Rose committed

Bug Fixes
^^^^^^^^^

* DatabaseUpdateData.php: add missed 'on the fly' update for Form.title, changed in FormEditor.sql in 18.8.1
* 6562 / sendmail: redirect all mail - the sender is replaced too.
* Manual.rst: several typos fixed

Version 18.8.1
Carsten  Rose's avatar
Carsten Rose committed
---------------

Date: 26.08.2018

Features
^^^^^^^^
* #4432 / Every 'form submit' will be logged with raw data.
* #4763 / Render vertical text more stable: '... AS _vertical'
* #4996 / Log QFQ Version update
* #5403 / Tooltip on pills are now supported
* #5876 / Subrecord title of column 'Edit' & 'Delete' are now customizable.
* #6249 / Subrecords can now be reordered via drag and drop.
* #6333 / Add to qfq.log: IP Address, User Agent, QFQ Cookie, FE User

Bug Fixes
^^^^^^^^^

* #6401 / Handle Backticks in sendmail
* #6452 / Empty form title: no title row will be rendered anymore.

Carsten  Rose's avatar
Carsten Rose committed
Version 18.8.0
--------------

Carsten  Rose's avatar
Carsten Rose committed
Date: 25.08.2018
Carsten  Rose's avatar
Carsten Rose committed
* Excel export
* Copy to clipboard
Carsten  Rose's avatar
Carsten Rose committed

Features
^^^^^^^^

* #4922 / Excel Export - create Excel sheets from scratch or based on a template.
* #3294 / Improve Typo3 QFQ backend layout. Add sparql syntax highlighting.
* #5878 / Formelement.type=note with #!report - whitespace is trimmed.
Carsten  Rose's avatar
Carsten Rose committed
* #6314 / HTML Mails enabled by specifying flag 'mode=html'.
Carsten  Rose's avatar
Carsten Rose committed
* Import/Merge form: A new form 'copyFormFromExt' (see file `copyFormFromExt.sql`) offers a one click import of external
  QFQ forms (incl. renumbering of id's).
* formEditor.sql: resized Form.title from 255 to 511 (requested by IK Tool)
* Drag and Drop now offers the possibility to show the renumbered values.
* Manual.rst: security hints, T3 Setup best practice, text input retype, charactercountwrap.
* Config.qfq: central defaults for DATA_MATCH, DATA_ERROR
* Bootstrap QFQ development: switched from bower to npm only.

Carsten  Rose's avatar
Carsten Rose committed
Bug Fixes
Carsten  Rose's avatar
Carsten Rose committed
^^^^^^^^^

Carsten  Rose's avatar
Carsten Rose committed
* #5843 / File upload: limitation to file extensions are no case insensitive.
* #6247 / Replace deprecated each function
* #6281 / FormElement / column 'note': token '#!report' - STORE_RECORD does not work.
* #6331 / File Upload: Wrong error message if filesize is much too big.
* #6229 / Add QFQ icon to content element and content element wizard
* AbstractException.php: fixed problem with htmlEntities() on link to 'Edit Form' and 'Edit FormElement'.


Carsten  Rose's avatar
Carsten Rose committed
Version 18.6.1
--------------

Date: 21.06.2018

Notes
^^^^^

Carsten  Rose's avatar
Carsten Rose committed
* Configuration QFQ: form-config.formDataPatternError. New behaviour: If this field is empty, a more specific default
  message is shown (instead of one message for all situations). Best is to clear this field.

Carsten  Rose's avatar
Carsten Rose committed
Features
^^^^^^^^

Carsten  Rose's avatar
Carsten Rose committed
* sqlHint / Note if a query fails and contains some not replaced variables.
Carsten  Rose's avatar
Carsten Rose committed
* #4438 / Log attack detected: will be logged now to fileadmin/protected/log/qfq.log.
* #4041 / Subrecord: Spalte 'id' automatisch mit '<span class="text-muted">' wrappen.
* #5885 / show 'sql.log' in FE.
* #6121 / Formular: ID per Default in Titel.
Carsten  Rose's avatar
Carsten Rose committed

Bug Fixes
^^^^^^^^^

Carsten  Rose's avatar
Carsten Rose committed
* #6283 / Form: hide title frame if empty.
* #4299 / HiddenSelect' into 'master'.
* #6276 / default data-required-error moved to central Config.php.
* #5884 / sql.log by default public - protect against access.
* #6276 / Default check_type messages not shown.
* #6233 / Alert 'Form incomplete' - stays until click - auto disappear would be better.
Carsten  Rose's avatar
Carsten Rose committed
Version 18.6.0
--------------

Date: 13.06.2018

Notes
^^^^^

* config.qfq.ini migrated to config.qfq.php - the old config.qfq.ini get's `chmod 000`.
* Most of config.qfq.ini migrated to Typo3 / Extension Manager - all but the DB /LDAP credentials.
* Keep in config.qfq.ini: ::

    # Rename DB credentials from DB_<key> to DB_1_<key>, with key = 'NAME|HOST|USER|PASSWORD'
    DB_1_USER = ...
    DB_1_SERVER = ...
    DB_1_PASSWORD = ...
    DB_1_NAME = ...

* NEW: Drag and drop to sort elements! Check the Manual.
* `URL forwardMode`

  * `client` renamed to `auto`.
  * `close` added.

Features
^^^^^^^^

Carsten  Rose's avatar
Carsten Rose committed
* #6100 / Url Forward Auto: Update Manual.rst. The F.parameter.saveAndClose has been removed again. Mode 'close' can be assigned statically or dynamic.
* #6178 / Input: Step: New option 'step' for FE.parameter.
* Download.php: references to non existing files now reported as missing file, not 'wrong mimetype' anymore.
* #4918 / Drag'n'Drop reorder elements DRAGANDDROP.md, PROTOCOL.md: Doc for "drag'n' drop" implementation.
* dragAndDrop.php: API endpoint DragAndDrop.php: Class for implementing drag'n' drop functionality.
* Link.php: implement new renderMode=8 - returning only the sip. QuickFormQuery.php: New entry point for processing "drag'n' drop".
Carsten  Rose's avatar
Carsten Rose committed
* #3971 / Form title: new design from form title.
Carsten  Rose's avatar
Carsten Rose committed

Bug Fixes
^^^^^^^^^

* #5077 / Dynamic Update & FE.type=required: Server fixed -

Carsten  Rose's avatar
Carsten Rose committed
a) dynamic calculated modeSql respected,
b) formModeGlobal=requiredOff respected,
c) dynamic FE with mode='hidden' are not saved anymore.

* #6176 / Icon not aligned when error text: Buttons now wrapped in one 'input-group'.
Carsten  Rose's avatar
Carsten Rose committed
* Manual.rst: reformat autocron QFQ code.
* #5880 / Skip Error Message during dynamicUpdate.
* #5870 / Missing file config.qfq.ini: Clean QFQ message.
* #5924 / config.qfq.ini/LocalConfiguration.php: several places in formEditor.sql still contained the 'dbIndex...'.
Carsten  Rose's avatar
Carsten Rose committed
* #6168 Configuration language setting ignored: Form and FormElement editor still used uppercase config values for
  language configuration. Updated to the new camel case notation.
* #5890 / config.qfq.ini is public readable. Renamed file to config.qfq.php. Implement a basic migration assistant to
  copy DB credentials to new config.qfq.php. All other values have to be copied to extmanager/qfq-configuration manually.
* #6216 / Oops, an error occurred! Code - unhandled exception will be caught now.
Carsten  Rose's avatar
Carsten Rose committed
Version 18.4.4
--------------

Date: 28.04.18

Bug Fixes
^^^^^^^^^

* Fix broken ext_emconf.php

Carsten  Rose's avatar
Carsten Rose committed
Version 18.4.3
--------------

Date: 28.04.18

Bug Fixes
^^^^^^^^^

* Version Number ...04... not supported by TE. Changing naming scheme to omit leading zero.

Carsten  Rose's avatar
Carsten Rose committed
Version 18.04.1
---------------

Date: 28.04.2018

Bug Fixes
^^^^^^^^^

Carsten  Rose's avatar
Carsten Rose committed
* config: broken dbIndexQfq, dbIndexData.
Carsten  Rose's avatar
Carsten Rose committed
Version 18.04.0
---------------

Date: 26.04.2018

Notes
^^^^^

* QFQ marked as 'stable'
* New version numbering: Year.Month.Index
* Manual.rst:

  * AutoCron documentation enhanced.
  * Replace '{{form:S}}' against '{{form:SE}}'.
  * Check list for 'new installations'.
  * Description for config variables enhanced.
  * Details 'how record locking' is done.
Carsten  Rose's avatar
Carsten Rose committed
  * Details: extraButtonInfo.
  * Replace config.qfq.ini on most places with 'configuration'.
Carsten  Rose's avatar
Carsten Rose committed

* Path of 'sql.log' / 'mail.log' are now relative to <site path> (not <ext path> as before).

Features
^^^^^^^^

* formEditor.sql: update table cron.
* AutoCron.php: allow https connections with invalid certificate (e.g. 'localhost' is not listed as a valid hostname).
* ext_conf_template.txt: Extension manager configuration setup.

Bug Fixes
^^^^^^^^^

* AutoCron:

Carsten  Rose's avatar
Carsten Rose committed
  * Update form 'cron' to load/save records in DB_INDEX_QFQ.
Carsten  Rose's avatar
Carsten Rose committed
  * Fix problem with array in checkForOldJobs().
  * Implement check that re-trigger asynchronous cron jobs are handled correctly.


Carsten  Rose's avatar
Carsten Rose committed

Version 0.25.15
---------------

Date: 20.03.2018

Features
^^^^^^^^

Carsten  Rose's avatar
Carsten Rose committed
* Fabric Read Only mockup.
Carsten  Rose's avatar
Carsten Rose committed

Bug Fixes
^^^^^^^^^

Carsten  Rose's avatar
Carsten Rose committed
* #5706 / Fixed that problematic characters in 'fileDestination' has not been sanatized.
Carsten  Rose's avatar
Carsten Rose committed
* Fixed problem with buttons clipping trough alert.
* Client: wrong variable, updated CSS for long errors.
Carsten  Rose's avatar
Carsten Rose committed
Version 0.25.14a
----------------

Date: 15.03.2018

Features
^^^^^^^^

* Change getMimeType() in Report in case file is missing or `file` beaks: instead to throw an exception, an empty string is returned.
Carsten  Rose's avatar
Carsten Rose committed
* Updated protocol.md with Alert description.
Carsten  Rose's avatar
Carsten Rose committed
* Update Status message for save/delete.
* Makefile: 1) remove sonar, add dependency to let update-qfq-doc run. 2) do qfq doc commit inside of the Makefile.
Carsten  Rose's avatar
Carsten Rose committed
* Client: Changed save timeout from 1500 to 3000.
* Client: removing the blackout screen when modal gets dismissed.
Carsten  Rose's avatar
Carsten Rose committed
* Client: modal alerts are now blocking everything.
* Manual.rst: fix RST syntax errors.

Bug Fixes
^^^^^^^^^

Carsten  Rose's avatar
Carsten Rose committed
* #5677-TinyMCE broken - fixed.
Carsten  Rose's avatar
Carsten Rose committed
Version 0.25.14
---------------

Date: 14.03.2018

Features
^^^^^^^^

Carsten  Rose's avatar
Carsten Rose committed
* Change notification from 'save: success' to 'Save' and 'delete: success' to 'Delete'.
Carsten  Rose's avatar
Carsten Rose committed
* DB update: write intermediate QFQ version after every step.

Bug Fixes
^^^^^^^^^

* #5652 / TypeAheadSql: destroyed SQL statement. Fixed broken compare and missing init of $sqlTest.
* #5668 / Fix Broken SIP after login.


Carsten  Rose's avatar
Carsten Rose committed
Version 0.25.13
---------------

Date: 08.03.18

Features
^^^^^^^^
Carsten  Rose's avatar
Carsten Rose committed
* AutoCron: Added doc for autocron. Extend AutoCron.php to be MultiDB aware. Update der AutoCron form.
* #4720 / Separate Database for Form & FormElement - Multi DB - fixed problem that 'Quick Edit Form / FormElement' has been broken in MultiDB Setup.
Carsten  Rose's avatar
Carsten Rose committed
* #5603 / Report: final value of report columns (special column name).
* Fabric / delete now triggers form.changed / emojis work again.
Carsten  Rose's avatar
Carsten Rose committed
* #5571 / File Upload: save filesize and mimetype automatically in 'upload mode simple',if those columns exist.
Carsten  Rose's avatar
Carsten Rose committed
* #5423 / two new column names 'filesize', 'mimetype'.
* #5571 / File Upload: save filesize and mimetype.
Carsten  Rose's avatar
Carsten Rose committed

  * STORE_VARS contains now 'mimeType' and 'fileSize'.
  * sqlBefore and sqlAfter will be fired in Upload Advanced and new in Upload Simple as well.
  * STORE_VARS contains now `filenameOnly`. It can be used in downloadButton=....

Bug Fixes
Carsten  Rose's avatar
Carsten Rose committed
^^^^^^^^^

Carsten  Rose's avatar
Carsten Rose committed
* Fabric: Corrected resizing with changed width in editor.
* #5640 / UTF8 encoded strings: MAX LENGTH wrong.
Carsten  Rose's avatar
Carsten Rose committed

Version 0.25.12
---------------

Date: 18.02.2018

Notes
^^^^^

* New

  * FE.parameter:

    * timeIsOptional
    * enterAsSubmit

  * FE.checkType: Auto
  * Thumbnail rendering. Public or secure.

* Update

  * Multi DB Support: Form & Report

Features
^^^^^^^^

* #5064 / Throw user form exception on invalid date.
* #5308 / TimeIsOptional parameter.
* #5318 / Allow sendmail speaking word token, adjust documentation and fix some typos.
* #5347 / Error Message (Exception): BS colored box for report error messages. Hide technical informations, show it on click.
* #5392 / Violate message with expected date format.
* #5414 / Add checkType Auto, refactor setDefault methods, add smart detection of defaults, extend documentation and rules.
* #3470 / Enter As Submit= on/off - implemented.
* #4437 / violate sanitize message.
* #4542 / input-type-decimal' into 'master'.
* #5298 / Update docs for HTML mails.
* #5333 / Thumbnail: implementation.
Carsten  Rose's avatar
Carsten Rose committed
* #5425 / Thumbnail: render mode 7 - implemented, rewrite - secure thumbnails are now rendered on first access, not when
  'AS _thumbnail' is called.
Carsten  Rose's avatar
Carsten Rose committed
* Implemented $dbIndex for Report.
Carsten  Rose's avatar
Carsten Rose committed
* Implemeted two new STORE_SYSTEM variables: '_dbNameData' and '_dbNameQfq' - those will be automatically filled qfq
  during instantiation QuickFormQuery(). They can be used in Report to easily access the needed DB.
* Increased Formelement.label from 255 to 511.
Carsten  Rose's avatar
Carsten Rose committed
* Make DB_INIT in config.qfq.ini set by default.
* Notes how to optimize PDF thumbnailing.
Carsten  Rose's avatar
Carsten Rose committed
* Reformat manual for config.qfq.ini. Copy config.qfq.example.ini to MANUAL.rst. Migrate config defaults from
  setIfNotSet() to array_merge().
Carsten  Rose's avatar
Carsten Rose committed
* Security: hide $SQL in error messages to regular user.
Carsten  Rose's avatar
Carsten Rose committed
* New FE.parameter 'inputType'. Can optional be given by webmaster. Additional, the 'type="number"' will be automatically
  set, if the column is of type 'int' or if 'min' and 'max' is numerically.
Bug Fixes
^^^^^^^^^

Carsten  Rose's avatar
Carsten Rose committed
* #3192 / Fill STORE_RECORD before loading table title.
* #5285 / Make typeAheadPedantic the default.
* #5348 / Exception/Report: level key missing.
Carsten  Rose's avatar
Carsten Rose committed
* #5367 / Error Report: reworked alerts, updated css for alerts, 'full level' missing, content too much escaped: Fixed
  too much escaping. Form / FormElement Links in error messages now with BS Buttons.
Carsten  Rose's avatar
Carsten Rose committed
* #5382 / Double quotes in tooltips are now escaped with &quot;.
* #5390 / input validation decimal broken. fixed.
* #5430 / Add unique ID to each radio button for dynamic update.
* Form: 'FormElement' > 'Container' - relied on '{{formId:S}}' even if the FE record already exist - fixed.
* Subrecord Title - now wrapped with <label class='control-label'>.
Carsten  Rose's avatar
Carsten Rose committed
Version 0.25.11
---------------

Date: 31.01.2018

Notes
^^^^^

* Violating a sanitize class now returns '!!<sanitize class>!!' instead of an empty string.

Features
^^^^^^^^

Carsten  Rose's avatar
Carsten Rose committed
* #5022 / Variable violates sanatize class: 'msg' instead of empty string - new identifier "!!<sanitize class>!!".
Carsten  Rose's avatar
Carsten Rose committed
* #4813 / Exception during form load: show 'form edit link' if editor is logged in.
* formEditor.sql: Increas size of Form.title to give more room for SQL statements in.
* Manual.rst: enhance debug tipps.
Carsten  Rose's avatar
Carsten Rose committed
* #5321 / Plain Link - render mode- only url - implemented.
* Add regex101 link to checkPattern FormEditor.
Carsten  Rose's avatar
Carsten Rose committed

Bug Fixes
^^^^^^^^^

* Fixed some broken help links in formEditor.sql.
Carsten  Rose's avatar
Carsten Rose committed
* #5306 / Exception: tt_content_uid wrong - fixed.
* #4303 / Download von doc/docx-Dateien / Download.php - Mime type wird nicht mehr an Dateiname angehängt.
Carsten  Rose's avatar
Carsten Rose committed
* #5316 / Help on how to send an E-Mail is wrong - several places fixed.
Carsten  Rose's avatar
Carsten Rose committed
* #5311 / Error Msg SLQ_RAW != SQL_FINAL: Debug message shows outdated SQL_RAW.
* #5309 / min/max broken for date fields. Add min/max attributes to input and date input tag.
* Fabric now detects 'dirty'.
Carsten  Rose's avatar
Carsten Rose committed
* Manual.rst: Remove broken link to W3C file upload.


Carsten  Rose's avatar
Carsten Rose committed
Version 0.25.10
---------------

Date: 26.01.2018

Notes
^^^^^

Carsten  Rose's avatar
Carsten Rose committed
* PROTOCOL.md: update notes.
Carsten  Rose's avatar
Carsten Rose committed
* Form / Upload: new option 'downloadButton' - if given renders a download button instead of showing the pathFileName.

Features
^^^^^^^^

* #5023 / Fabric: Cut, rotate and enhance uploaded images. Update Manual.
Carsten  Rose's avatar
Carsten Rose committed
* All FE 'typeahead' fields are set to 'autocomplete="off"'. Respect user setting for 'autocomplete' - if none given
  (mostly), set it for FE 'typeahead' to 'off'.
* #5295 / Upload: check if given QFQ 'maxFileSize' is higher than php.in post_max_size, upload_max_filesize.
Carsten  Rose's avatar
Carsten Rose committed
* FE.Subrecord: rearranged column order, start columns with uppercase letter.
* New CSS class 'qfq-full-width-left': especially for buttons to become full width.
* New CSS class 'qfq-table-100' - 100% width, with auto width per column. FE.subrecord changed to  'qfq-table-100'.
Carsten  Rose's avatar
Carsten Rose committed
* #5302 / remove CSS class 'internal / external'.
Carsten  Rose's avatar
Carsten Rose committed

Bug Fixes
^^^^^^^^^

Carsten  Rose's avatar
Carsten Rose committed
* #5189 / BCC SendMail Problem - fixed missing double ticks.
Carsten  Rose's avatar
Carsten Rose committed
* Manual.rst: Update documentation that the default escape type is 'm'. Remove subrecord/list (have been removed long
  time ago). Fix enumeration problem FE.type=radio `classButton`. Add short note for typeahead.js. Remove never
  implemented 'keySemdId...', 'ANREDE'. Fixed typo - replace '\' by '\\' on most places (not in code sections).
  More generic SQL to extract filename from pathFileName. Fixed several phinx syntax errors. Add example for
  'recent list'-records.
* Fixed problem with missing 'if note exits' in CREATE TABLE `Split`.
* #5030 / Manual.rst: Fixed example with XSS vulnerability.
* #5275 / typeahead.bundle.min.js missing in Manual.rst: fixed.
* FormEditor: 'typeahead' for column 'name' fixed. Attention: only succeed if DB_1_NAME is the final DB (mostly given).
* #5048 / Default value NULL in pathFileName breaks uploads.
* #5028 / Links im FormularEditor zeigen ins Leere (Fehlende Ziel-Anker) - fixed.
Carsten  Rose's avatar
Carsten Rose committed
* Make readonly BS radio buttons non-selectable.
Carsten  Rose's avatar
Carsten Rose committed
Version 0.25.9
Carsten  Rose's avatar
Carsten Rose committed
--------------

Carsten  Rose's avatar
Carsten Rose committed
Date: 17.12.2017
Carsten  Rose's avatar
Carsten Rose committed

Features
^^^^^^^^

Carsten  Rose's avatar
Carsten Rose committed
* #5133 / sendmail: subject and body html entity decode: Introduce options for 'subject' and 'body' to switch on/off HTML encoding / decoding
* Manual.rst: Add notes to QFQ installation, wkhtml problems, paragraph on 'sendEmail' Html2Pdf.php: Add error codes and a hint on wkhtml fails.
Carsten  Rose's avatar
Carsten Rose committed
* Reformat table qfq-letter.css.less: redefined h1, letter-receiver.
Carsten  Rose's avatar
Carsten Rose committed

Bug Fixes
^^^^^^^^^

Carsten  Rose's avatar
Carsten Rose committed
* Bug in sendEmail: invalid SSL_version specified at /usr/share/perl5/IO/Socket/SSL.pm line 575. Patch for sendEmail
  (see https://unix.stackexchange.com/a/68952).
Carsten  Rose's avatar
Carsten Rose committed


Version 0.25.8
--------------

Date: 11.12.2017

Features
^^^^^^^^

Carsten  Rose's avatar
Carsten Rose committed
* #5080 / Dynamic PDF Letter.
Carsten  Rose's avatar
Carsten Rose committed
* #5083 / Bodytext / Report: join lines without spaces.

Bug Fixes
^^^^^^^^^

Carsten  Rose's avatar
Carsten Rose committed
* Fix problem with commit from 8.12.17 / Store.php: appendToStore.php stopped working - 'report' failed to replace
  '{{<column>:R}}'.
Carsten  Rose's avatar
Carsten Rose committed
* Store.php: fix problem with empty 'appendToStore()' call.

Carsten  Rose's avatar
Carsten Rose committed
Version 0.25.7
--------------

Date: 07.12.2017

Notes
^^^^^

* Report: parameter in '... AS _sendmail' needs token now - position dependent is removed now.
* Report: parameter 'a:' in '... AS _sendmail' replaced by 'F:' to be compatible with downloads. Do not separate files by comma.
* Manual: most occurences of 'U:' replaced by 'p:' - same meaning.

Features
^^^^^^^^

* #4255 / Attachments for emails implemented.

Bug Fixes
^^^^^^^^^

Carsten  Rose's avatar
Carsten Rose committed
* Bug - PHP Warning: Declaration of qfq\BuildFormTable::head() should be compatible with
  qfq\AbstractBuildForm::head($mode = qfq\FORM_LOAD) - fixed.
Carsten  Rose's avatar
Carsten Rose committed
Version 0.25.6
--------------

Date: 03.12.2017

Notes
^^^^^

Bigger changes in update form after save/dynamic update.

Bug Fixes
^^^^^^^^^

Carsten  Rose's avatar
Carsten Rose committed
* #4865 / Pill Dynamic Updates Show / Hide.
Carsten  Rose's avatar
Carsten Rose committed
* #5031 / Missing details in DbException: New definition of SYSTEM_SHOW_DEBUG_INFO: even after config.qfq.ini is parsed
Carsten  Rose's avatar
Carsten Rose committed
  and SIP Infos has been read - if there is no BE User logged in, the value stays on 'auto' (earlier it has been replaced
  to 'no'). Staying on 'auto' keeps the information that replacing is still open and not replaced means 'no'-BE User logged in.
Carsten  Rose's avatar
Carsten Rose committed
* #5016 / Loose checkbox value on save - Dirty workaround - better solution necessary.
* #5017 / STORE_RECORD used in FormElement and via '#!report' - save & restore STORE_RECORD.
* #5004 / FormElement with state 'ReadOnly' will be saved with empty value - existing values will be overwritten - fixed.
Carsten  Rose's avatar
Carsten Rose committed
* 'element-update' for type 'UPLOAD seems to make trouble. Exclude it like 'SELECT'.
Carsten  Rose's avatar
Carsten Rose committed
Version 0.25.5
--------------

Date: 23.11.17

Bug Fixes
^^^^^^^^^

* #4771: Workaround which switches off updates to SELECT lists, if they are part of a Multi-FE-Row.


Carsten  Rose's avatar
Carsten Rose committed
Version 0.25.4
--------------

Carsten  Rose's avatar
Carsten Rose committed
Date: 22.11.2017
Carsten  Rose's avatar
Carsten Rose committed

Notes
^^^^^

* New keywords / features in report:

Carsten  Rose's avatar
Carsten Rose committed
  * `altsql`: Fire the query if there is no record selected in `sql`. Shown after `althead`.
Carsten  Rose's avatar
Carsten Rose committed
  * `shead`: Static head - will always be shown (before `head`), independent of sql selects records or not.
  * `stail`: Static tail - will always be shown (after `tail`), independent of sql selects records or not.

Features
^^^^^^^^

Carsten  Rose's avatar
Carsten Rose committed
* #2948 / altsql, shead, stail - new directives in Report.
Carsten  Rose's avatar
Carsten Rose committed
* #4255 / Attachments fuer 'Email'. Static files can be attached to mails.

Bug Fixes
^^^^^^^^^

* #4980 / Variables in Report: a) nested not replaced, b) 'rbeg' not replaced, c) missing unit tests.


Carsten  Rose's avatar
Carsten Rose committed
Version 0.25.3
--------------

Date: 19.11.2017

Notes
^^^^^

* Report:

  * Special column name 'sendmail': the old way of position dependent parameter are deprecated. Instead use the new
Marc Egger's avatar
Marc Egger committed
    defined token. See https://docs.typo3.org/p/IMATHUZH/qfq/master/en-us/Manual.html#column_sendmail
Carsten  Rose's avatar
Carsten Rose committed

  * Every row is now merged in STORE_RECORD. Inner SQL statement can now retrieve outer values via STORE_RECORD.
    E.g. `{{column:R}}`. No more level keys!

* The config.qfq.ini directive `VAR_ADD_BY_SQL` is replaced by `FILL_STORE_SYSTEM_BY_SQL_?`. Up to 3 statements are possible.

Features
^^^^^^^^

* Report / sendmail: control via token.
* #4967 / config.qfq.ini: Rename 'VAR_ADD_BY_SQL' to 'FILL_STORE_SYSTEM_BY_SQL_1'. Handle up to 3 FILL_STORE_SYSTEM_SQL_x.
  Implement an optional error message together with a full stop.
Carsten  Rose's avatar
Carsten Rose committed
* #4766 / Set STORE_RECORD in Report per row.
Carsten  Rose's avatar
Carsten Rose committed

Bug Fixes
^^^^^^^^^

* #4966 / Variable {{feUser:T}} is not available in config.qfq.ini `FILL_STORE_SYSTEM_?` - changed ordering of store
  initialization. Now: TCY...
* #4944 / Delete: broken when using 'tableName' (instead of form).
* #4904 / Undefined Index: DIRTY_FE_USER - PHP problem that constants cant be replaced inside of single ticks. Fixed.
* #4965: insert path to QFQ cookie/session, to make usage of multiple QFQ installation on one host possible.


Carsten  Rose's avatar
Carsten Rose committed
Version 0.25.2
--------------

Carsten  Rose's avatar
Carsten Rose committed
Date: 8.11.2017
Carsten  Rose's avatar
Carsten Rose committed

Notes
^^^^^

* Starting with this release, the default escape mode is 'm' (mysql_real_escape).

Features
^^^^^^^^

* Default Escape Type changed from 's' to 'm'. DatabaseUpdateData.php: removed the DB update from last commit - not necessary.
  Config.php: New default 'm' Evaluate.php: Respect EscapeTypeDefault in form definition.
  QuickFormQuery.php: Replace 'EscapeTypeDefault' in form defintion very early.
Carsten  Rose's avatar
Carsten Rose committed
* #4049 / QFQ Variables '{{...}}' might now contain a default value.
Carsten  Rose's avatar
Carsten Rose committed
* If 'pageAlias:T' is empty, take 'pageId:T'.

Bug Fixes
^^^^^^^^^

Carsten  Rose's avatar
Carsten Rose committed
* #4836 / Multiple entries in table after several clicks on save. Created a saveInProgress Variable.
* Replaced latest project homepage URL in Manual.rst.
* Fix example SQL for periodId in config.qfq.ini in Manual.rst.
Carsten  Rose's avatar
Carsten Rose committed
* Remove multiple header 'RELEASE' - there has to be only one.

--------------

Carsten  Rose's avatar
Carsten Rose committed
Date: 3.11.2017
Carsten  Rose's avatar
Carsten Rose committed
* #4857 / broken (stale) download: multiple 'u:..' or 'u:...'.
* #4212 / Broken JSON on response to save new record 'Unknown index' fixed by isset().

Version 0.25.0
--------------

Date: 10.10.2017
* The config.qfq.ini directives DB_USER, DB_NAME, DB_HOST, DB_PASSWORD are replaced by DB_1_USER, DB_1_NAME, DB_1_HOST,
  DB_1_PASSWORD. The old directives are still used, as long as the new directives does not exist.

Carsten  Rose's avatar
Carsten Rose committed
* New config.qfq.ini directives: DB_INDEX_DATA, DB_INDEX_QFQ.
Carsten  Rose's avatar
Carsten Rose committed
* #4720 / Separate database handles for QFQ 'form' and QFQ 'data' - 'Form' might  now load/save from forign database/host/user.


Version 0.24.0
--------------

Date: 09.10.2017

Notes
^^^^^

* Change Remove SYSTEM_SECURITY_ABSOLUTE_GET_MAX_LENGTH - makes no sense to hardcode an upper limit.

Features
^^^^^^^^

Carsten  Rose's avatar
Carsten Rose committed
* Feature Manual.rst: Doc updated for latest subrecord column special names.
* Feature AbstractBuildForm.php: new function subrecordHead(). Replaced several hard coded subrecord column names against constants.
Carsten  Rose's avatar
Carsten Rose committed
* Feature #4456 / formModeGlobal=requiredOff - update Manual.rst.
* Feature #4606 / _link: qualifier to render bootstrap button - fix unit tests for tooltip. Add tooltip to button/text,
  even if there is no link. Implement token  'b:...' for link class. Manual is updated. Open: `pageX` should be recoded
  to use the new 'b:' instead of hardcoed behaviour to render a button.
* Feature: Upload Button - wrapped with Bootstrap Button. New option 'fileButtonText' to specify a button text.
Carsten  Rose's avatar
Carsten Rose committed
* Feature #3752 / Pills auf mode|modeSql=hidden|readonly setzen - implemented during 'form load' (not dynamic update).
* Feature: Neu wird nach dem Speichern das Formular nochmal komplett geladen. Das ist wichtig um die durch aftersave
  geaenderten Records in die Formularelemente zu bekommen.
* Feature #4511 / Form: URL Forward - mode dynamic computed - more generic implementation.

Bug Fixes
^^^^^^^^^

Carsten  Rose's avatar
Carsten Rose committed
* Bug #4731 / Dynamic Update: load(post) triggers 'check required' - makes no sense during filling a form - fixed.
* Bug #4730 / InvalidDate-00-00-2000 FE.type=date - detection of empty date was broken for '00.00.0000'.
* Bug Fixed problem in subrecord when no record is selected.
Carsten  Rose's avatar
Carsten Rose committed
* Bug #4620 / Easy Fix: saveButtonText / closeButtonText Formatierung.

Version 0.23.1
--------------

Date: 23.9.2017

Bug Fixes
^^^^^^^^^

Carsten  Rose's avatar
Carsten Rose committed
* #4620 / Easy Fix: saveButtonText / closeButtonText Formatierung.


Version 0.23.0
--------------

Date: 17.09.2017

Features
^^^^^^^^

Carsten  Rose's avatar
Carsten Rose committed
* #3752 / Pills auf mode|modeSql=hidden|readonly setzen - implemented during 'form load' (not dynamic update).
Carsten  Rose's avatar
Carsten Rose committed
* #4548 /Template Group: 'form-update' broken - Broken Redirect after Save - Broken same HTML ID for FE copies in a
  template group.
* #4548 /Template Group: 'form-update' broken - max tg element value/index shown after save instead of last user
  supplied value, but save is ok. Neu wird nach dem Speichern das Formular nochmal komplett geladen. Das ist wichtig um
  die durch aftersave geaenderten Records in die Formularelemente zu bekommen.

Version 0.22
------------

Date: 14.09.2017

Notes
^^^^^

* Form Editor: element 'forwardPage' is static again (no dynamic update) - see features in #4511.

Features
^^^^^^^^

Carsten  Rose's avatar
Carsten Rose committed
* #4511 / Form: URL Forward - mode dynamic computed.

Bug Fixes
^^^^^^^^^

* #4512 | SIP URL does not respect anker token '#'- fixed PLUS: L and type _GET Params included in links which contain a SIP (regular links still open).
* #4508 / Form: during Save with FE with 'report'-Note/Values an exception is thrown - report does not expect, to be called without typo3 - but this is the case during save and generating the JSON.
Carsten  Rose's avatar
Carsten Rose committed
* #4021 / "required" asterik does not handle multi column labels correctly.
* #4423 / Date inputs with readonly: label is grey.
Carsten  Rose's avatar
Carsten Rose committed
* Empty date might create '2001-00-00'.
* #4504 / Upload Button: required asterik missing after save - seems to be a problem for every element - should be fixed now.

Version 0.21.0
--------------

Date: 10.09.2017

Notes
^^^^^

* The Form-Editor now has two 'requiredParamter' fields: one for 'New' record and one 'Edit'. Existing settings will be
  automatically copied to both.
* The FormElement-Editor field 'Note' is not anymore a TinyMCE Editor. Instead a regular 'textarea' is used. Main reason
  are incompatibilities between TinyMCE HTML mode and the neede CR/LF linebreaks needed for 'Report' Syntax in the 'note'
  column.

Features
^^^^^^^^

Carsten  Rose's avatar
Carsten Rose committed
* #4431 / FE.type=note: QFQ Report Syntax in 'FE.value' and 'FE.note'.
* #4456 / formModeGlobal=requiredOff - Switches FormElement.mode=required to 'show' for all FE of the current Form.
Carsten  Rose's avatar
Carsten Rose committed
* #4356 / Form: required parameter - split between 'New' & 'Edit'.

Version 0.20.0
--------------

Changes
^^^^^^^

Carsten  Rose's avatar
Carsten Rose committed
* New configuration value EXTRA_BUTTON_INFO_POSITION in config.qfq.ini.
Carsten  Rose's avatar
Carsten Rose committed
* #4386 Fuer GRC: Optional Info Button bei 'input' wie bei 'textarea' - EXTRA_BUTTON_INFO_POSITION=below.
* #4429 / subrecord: new FE parameter 'subrecordTableCass' - a custom class for the subrecord table might be specified.
Carsten  Rose's avatar
Carsten Rose committed
* #4428 / subrecord: mode=readonly.
* #4421 / subrecord: column of the sql1 row should go into the edit link - implemented.
* #4399 / Do not render '_pdf' when r:5 or empty string.

Bug Fixes
^^^^^^^^^

* #4396 / FE: Justify DATE and TIME in case it's DATETIME on a non primary table.
Carsten  Rose's avatar
Carsten Rose committed
* #2414 / Deaktivieren von Option 'new' bei subrecord hat keine Folge.
* #4426 / Subrecord: mode=hidden - still shown.
* #4425 / Subrecords: Table head is not wrapped in <thead>.
* #4331 / SQL Statement 'REPLACE' not fired - Keyword missing in list of SQL Keywords.


Version 0.19.7
--------------

Changes
^^^^^^^

Carsten  Rose's avatar
Carsten Rose committed
* #4306 / Update Text Subrecord: Please save this record first.

Features
^^^^^^^^

Bug Fixes
^^^^^^^^^

* #4278 / Language: Check that language settings are respectet inside of container / pill / fieldset / templateGroup.
* #4310 / Fixed error where custom values wouldn't be saved, nor not found for non pedantic.
* #4311 / Record Lock: expired lock wird nicht geloescht bei form reload.
Carsten  Rose's avatar
Carsten Rose committed
* #4309 / typeahead: allow free entry.

Version 0.19.6
--------------

Features
^^^^^^^^

Carsten  Rose's avatar
Carsten Rose committed
* #4299 / HTML Element 'Select': Placeholder.
* Changes to the alert generation and added btn-group for multiple buttons.
* Should only show reload button and be modal when the conflict is mandatory.
Carsten  Rose's avatar
Carsten Rose committed
* #4144 / Close/New: bei acquireLock=false anschliessend keine Nachfrage ob gespeichert werden soll.
* #4120 / Removed Timeout from Dirty Alert Message.
* #4283 / FE.parameter=emptyMeansNull.

Bug Fixes
^^^^^^^^^

* #4281 Prevent save from being clicked multiple times. Save no turns orange when saving.

Version 0.19.5
--------------

Features
^^^^^^^^

* #3790 / Multilanguage: German/ English/ ...

Bug Fixes
^^^^^^^^^
* #4274 / ItemList: escape ',' ':'


Version 0.19.4
--------------

Features
^^^^^^^^

* Feature: Form Paste Records - skip columns during copy if they do not exist on the source side.

Bug Fixes
^^^^^^^^^

Carsten  Rose's avatar
Carsten Rose committed
* #4266 / FormElement Type=Editor: value not saved - fixed.
* #4253 / Record Lock not deleted, when window closes without save.

Version 0.19.3
--------------

Changes
^^^^^^^

Carsten  Rose's avatar
Carsten Rose committed
* Changing buttons for the dirty Events depending on status.

Bug Fixes
^^^^^^^^^

* #4257 / Dynamic update broken - after changing JSON data structure, update load.php has been missed.

Open
^^^^

Carsten  Rose's avatar
Carsten Rose committed
* #4253 / Record Lock not deleted when window closes without save.

Version 0.19.2
--------------

Features
^^^^^^^^

Carsten  Rose's avatar
Carsten Rose committed
* #4250 / autocron: sending mails.
* #4248 / FormElement: TypeAhead fuer den Spaltennamen - Implemented.
* #4144 / Close/New: bei acquireLock=false anschliessend keine Nachfrage ob gespeichert werden soll.
* #4120: Removed Timeout from Dirty Alert Message.

Version 0.19.1
--------------

Features
^^^^^^^^

Carsten  Rose's avatar
Carsten Rose committed
 * #4172 / record locking: Bob tries to delete a record and get 'status=error': Client should disable 'delete' button.
 * #4185 / Detect modified record.
 * #4143 / New alert removes old alert(s).
 * #4173 / Form: User open's a new tab and press close - alert to inform user that he has to close the tab.
 * #1930, #3980 /  Client: Bei Form Submit den Status 'submit_reason=save|save,close' mitsenden.
 * Implemented: New > Close (save) now closes correctly the current page. Addtional, #1930 has been solved implizit.

Bug Fixes
^^^^^^^^^

Carsten  Rose's avatar
Carsten Rose committed
 * Bug #4174 / record locking: error message if delete fails due to record locking.
 * Bug: SQL 'CREATE' implemented as a valid command.

Version 0.19.0
--------------

Changes
^^^^^^^

* bower.json: change bootstrap version number from micro to minor.
* Sip.php: Guarantee that uniqid() is unique at least for the current user.
* Makefile: change installation of phpDocumentor to --alldeps and remove 'phpdoc/'.

Features
^^^^^^^^

Carsten  Rose's avatar
Carsten Rose committed
* #3881 / Variables: Ex 'keySemId', New 'periodId' (System Store).
* AbstractBuildForm.php: if a datetime / timestamp has the string 'CURRENT_TIMESTAMP' it will be replaced by the current date/time.
Carsten  Rose's avatar
Carsten Rose committed
* Add new STORE_TYPO3 vars: pageAlias, pageTitle.
* Config.php: cleanup of checking GET variables.
Carsten  Rose's avatar
Carsten Rose committed
* #3981 / Record Locking.
* Manual.rst: add documentation for record locking.
* Manual.rst: more details about QFQ variables.
Carsten  Rose's avatar
Carsten Rose committed
* plantuml: sequence diagrams for record locking.

Bug Fixes
^^^^^^^^^

* Bug #4158 / Delete Button im Form fehlen die SIP Parameter.
* Bug #4159 / missing htmlspecialchar_decode() for FE.value supplied content.
Carsten  Rose's avatar
Carsten Rose committed
* Bug Makefile: fixed unwanted removing of whole 'doc' by 'maintainer-clean' - doc nowadays contains QFQ related
  manually created documentation.
* Bug typeahead.php: An exception catched in typeahead.php has been assigned as array element, instead of a whole array. Fixed.




Version 0.18.7
--------------

Changes
^^^^^^^

* Makefile: 'make bootstrap' udpates all JS Lib packages. Double npm install removed.

Features
^^^^^^^^

* #3947 / Attack detectect: logout current user (only QFQ, FE User still logged in).
* #3959 / Class _link: implement 'any' Bootstrap glyphicons. New token 'G:' for '_link'.

Bug Fixes
^^^^^^^^^

Carsten  Rose's avatar
Carsten Rose committed
* #3953 / Radio buttons: Auswahl nicht angezeigt, wenn per itemList definiert.
Carsten  Rose's avatar
Carsten Rose committed
* #3982 / Filename Sanatize: remove spaces. Filename not properbly enclosed by double ticks.

Version 0.18.6
--------------

Features
^^^^^^^^

Carsten  Rose's avatar
Carsten Rose committed
* #3460 / Report: new column types '_striptags, '_htmlentities', '_+Tag'.

Version 0.18.5
--------------

Features
^^^^^^^^

Carsten  Rose's avatar
Carsten Rose committed
* QuickFormQuery.php: added function to check if there are copyForm paste records.
* Manual.rst, formEditor.sql: add several links in Form 'FormEditor' to the online documentation. The FormEditor now
  contains links to the Online Documentation. Add missing explanations: Required Parameter, Forward.

Bug Fixes
^^^^^^^^^

Carsten  Rose's avatar
Carsten Rose committed
* #3912 / templateGroup: max. 5 instances are saved.
* Manual.rst: Fixed missing '{{' and '%' in examples.
Carsten  Rose's avatar
Carsten Rose committed
* #3925 / templateGroup / non primary / delete records: only one at a time.
* Makefile: Artifactory builds fails at chromedriver - temporary remove npm install of chromedriver.

Version 0.18.4
--------------

Bug Fixes
^^^^^^^^^
Carsten  Rose's avatar
Carsten Rose committed
* #3910 / 'submitButtonText' not shown.

Version 0.18.3b
---------------

Features
^^^^^^^^