GitLab

AbstractBuildFrom.php: Add new symbol 'show'. Honor switch between Edit and Show for subrecord elements.
QuickFormQuery.php: If F_MODE is not set, check if there is a SIP var with F_MODE_GLOBAL=F_MODE_READONLY

#4278 / Language: Check that language settings respect inside of container / pill / fieldset / templateGroup
HelperFormElement.php,AbstractBuildForm.php,BuildFormBootstrap.php,QuickFormQuery.php: function setLanguage() moved from QuickFormQuery.php to HelperFormElement.php

Check if Record is already exclusive locked. If yes, show Form in readonly mode.

Manual.rst: how to use the multi language forms.
DatabaseUpdateData.php: Update DB with new language fields.
HelperFormElement.php: modify explodeParameter() to not check already existing definitions.
QuickFormQuery.php: new setLanguage().

Check if Record is already exclusive locked. If yes, show Form in readonly mode.

save.php, QuickFormQuery.php: fixed malformed array for JSON
Dirty.js, QfqForm.js: replace instance variable 'additionalQueryparameters' against parameter by call: optionalQueryParameters.

Fixed broken implementation on server side.

modifiedRecord.pu: State Diagram
Dirty.php: implement $recordHashMd5 to detect modified records.
OnArray.php: new getMd5()
AbstractBuildForm.php: implemented but not working update of hidden input 'recordHashMd5'. Add hidden input 'recordHashMd5'.
BuildFormBootstrap:  Add hidden input 'recordHashMd5'.
formEditor.sql: Rename 'Dirty.recordModified' to 'Dirty.recordHashMd5'.

delete.php: process json answer of qfq-delete()
Dirty.php: More specific error message. In case of locking problem during form delete - return json and not an exception.
QuickFormDirty.php: Code cleanup. Interpret answer of dirty->checkDirtyAndRelease

Implemented: New > Close (save) now closes correctly the current page. Addtional, #1930 has been solved implizit.

AbstractBuildForm.php: Removed some unused comments. Bug fix: do htmlspecialchar_decode() always when FE_ENCODE is set to encodeSpecialchar.
QuickFormQuery.php: mv necessary systemStoreUpdate() closer to instantiating of classs Store.

Manual.rst: Doc update for periodId.
DatabaseUpdateData.php, formEditor.sql: Table 'Period' and sample record.
Store.php: Implement systemStoreUpdate()
QuickFormQuery.php: call to store->systemStoreUpdate() - might solved in a better way..

Dirty.php: workaround for #4127

DatabaseUpdateData.php: Table Form: recordLockTimeoutSeconds - default changed from 0 to 900 secs. Existing forms get the default timeout timout interval.
Dirty.php, QuickFormQuery.php: recordLockTimeoutSeconds will be retrieved from the Form.recordLockTimeoutSeconds definition (instead of parsing config.qfq.ini). Therefore a definition per form ist possible.

file.php, load.php, Html2Pdf.php: minor updates.
Dirty.php, QuickFormQuery.php: optional $lockTimeout as parameter during instantiating. Return $lockTimeout where necessary. Otherwise read qfq.config.ini. Refactor process(), acquireDirty(), checkDirtyAndRelease().

Dirty.php: record delete is handled - if lock exist, delete is not allowed.

Dirty.php, QuickFormQuery.php: Update user messages. Renamed releaseDirty() to checkDirtAndRelease()

Manual.rst: add documentation for record locking
DatabaseUpdateData.php: Add new column 'dirtyMode'
Dirty.php, Config.php, formEditor.sql: remove dirtyMode=readonly. Rename 'timeout' to 'exclusive' and 'overwrite' to 'advisory'.

First version for save - not working now.
Manual.rst: document config var SYSTEM_DIRTY_RECORD_TIMEOUT_SECONDS.
QuickFormQuery.php, Dirty.php: extend to support QFQ/save().
Client.php: fixed broken PHP Unit test
Config.php: set default for dirtyRecordTimeout.
BuildFormBootstrap.php: No dirtyUrl if dirtyMode=none.
formEditor.sql: extend definition to Form.dirtyMode, new table 'Dirty'
Fixed several unit tests for new tables.

Fixed by implementing an $correctDeleteIndex.
FormAction.php: extended elements(), doSlave() from RC=bool to 3 states, it's now possible to detect a deletion and correct the index of any further array processing.

Manual.rst: various topics undocumented.
DatabaseUpdate.php: New table Clipboard, New FE.type='paste', New Form.forwardMode='url-sip' - will be applied for 0.18.3.
FormAction.php: New: doAllFormElementPaste(), prepareDuplicate(), checkNCopyFiles(), copyRecord()
Store.php: New member in STORE_CLIENT 'CLIENT_COOKIE_QFQ' - might be used to identify current user.
BuildFormBootstrap.php: New buildButtonCopyForm().
QuickFormQuery.php: Calculating the target page now happens after saving the current record and processing all after save actions. New: pasteClipboard()
formEditor.sql: New form 'copyForm'. New table 'Clipboard'

Introduce new config var 'DB_UPDATE' in config.qfq.ini. Update the handling, if there exist table 'form' and 'Form'.
Manual.rst:  document the new config option DB_UPDATE.
Database.php: Typo fixed.
DatabaseUpdate.php: Iterate over all found 'Form' tables, take the newest version number. Respect config option DB_UPDATE. Fixed a problem: if in the PHP DB updates a newer DB Version is configured than the PHP source itself is, such updates are now not played anymore.
Config.php, QuickFormQuery.php, config.example.ini: handle config setting DB_UPDATE.

#3568 / Form: fuer alle Buttons (save, close, new, delete) eine optionale class & text konfigurierbar machen
Manual.rst: new configuration options listed at config.qfq.ini and Form.paramtert.
Config.php: Defaults configured for F_SAVE|CLOSE|DELETE|NEW_BUTTON_TEXT|TOOLTIP|CLASS|GLYPH_ICON.
BuildFormBootstrap.php: Changed code to take values from config.qfq.ini or (if given) from form.parameter definitions.
QuickFormQuery.php: Copy new setup values from config.qfq.ini to Form.
StoreTest.php: update unit test for new global configuration values
config.qfq.example.ini: fill with new commented key/value pairs.

Manual.rst: update doc of 'url-skip-history'.
DatabaseUpdateData.php: update data structure as well as update given data from 'page' to 'url'.
QuickFormReport.php: remove temporarily fix page/url.
formEditor.sql: update table 'Form.forwardMode' to ('client', 'no', 'url', 'url-skip-history'). FormEditor now uses dynamicUpdate to hide/show FE 'forwardPage'.

QfqForm.js: Preparation for client, to handle window.location.replace() by new API status 'url-skip-history'. Also changed "(data.redirect === "url" || data['redirect-url'])" to "(data.redirect === "url" && data['redirect-url'])" - CR did not understand the former logic ('or' instead of 'and'). #OPEN#: window.location.replace = 'index.php....' throws an JS exception that it the attribute 'replace' is readonly. Instead "window.location.replace('index.php....')" works as expected.
PROTOCOL.md: add 'url-skip-history'.
save.php: recode to become more readable.
QuickFormQuery.php: getForwardMode() - temporarily fix to update status 'page' to 'url' (bug never caused a problem as long as '||' has been used on client side). Will change 'page' to 'url' asap.

Recode: new function buildNSetReloadUrl()

Partly remove unused code 'htmlNameIdZero'. Instead implement generation of a new SIP for the new record and reload the current page with the new SIP.
QuickFormQuery.php: remove newRecordUpdateSip(). Set URL redirection if none specific is configured. Skip creation of json code if page will be reloaded.

Database.php, QuickFormQuery.php: Initializing of native FormElements: _tgIndex
HelperFormElement.php: new function formElementSetDefault(). Add '%d' to id's of extraButtonInfo text elements.
Manual.rst: minor typos fixed

Add `sqlLog` and `sqlLogMode` to QFQ tt-content records.
Add mode 'error' and `none` to sqlLogMode.
Manual.rst: Added explanations for SQL_LOG, SQL_LOG_MODE, and tt-content pendants sqlLog, sqlLogMode. Update config.qfq.ini to latest attributes.
Database.php: rename $mode to $currentQueryMode to make it more descriptive. Recode dbLog().
Logger.php: do nothing if there is no file defined.
Report.php: new function checkUpdateLog().
Config.php: Set defaults for config.qfq.ini SQL_LOG and SQL_LOG_MODE
Store.php: Fix problem that an empty SQL_LOG will be prependad with SYSTEM_PATH_EXT.

DatabaseUpdateData.php, QuickFormQuery.php, formEditor.sql, TestFormEditor.sql: set new escapeDefaultSetting in Schema.

For updates of QFQ prior to 0.17.0, do:   ALTER TABLE  `Form` COMMENT =  'Version=<your old QFQ version>'
DatabaseUpdate.php, DatabaseUpdateData.php: new class.
QuickFormQuery.php: Add DB UpdateCheck
Database.php: moved to new subdirectory `database`. Add 'ALTER' as a new SQL command.
FormAction.php, TypeAhead.php, Report.php, Sendmail.php, FillStoreForm.php, Store.php, AbstractBuild.php, Delete.php, Evaluate.php: Update path to Database.php.

Html2Pdf.php: Fake the current 'user-agent' and add it as '--custom-header ...' AND '--custom-header-propagation' option to the wkhtmltopdf call. Without, T3 will deny FE Group access. The --custom-header-propagation seems to be necessary.

Implemented defaultEscapeType. configurable via config.qfq.ini (global) and per Form.
Implemented max GET parameter lenght. Default: 50. BTW: in phpunit test there have been a parameter 'file' which exceeds the limit of 32.

Config.qfq: Skip empty variable names - happens in phpunit tests. Read new `systemEscapeTypeDefault`.
Constants.php: renamed  TOKEN_LDAP_ESCAPE_* to TOKEN_ESCAPE_LDAP_*. Add TOKEN_ESCAPE_MYSQL, TOKEN_ESCAPE_NONE
Database.php: Set charset to real_escape_string() functions properly. Proxy for mysqli::real_escape_string()
Evaluate.php: Respect global escapeTypeDefault. Implement
formEditor.sql: add column `escapeTypeDefault`. Add FormElement 'escapeTypeDefault'.