GitLab

B5077 Dynamic Update & FE.type=required: Server fixed - a) dynamic calculated modeSql respected, b) formModeGlobal=requiredOff respected, c) dynamic FE with mode='hidden' are not saved anymore.

Feature #5571 / File Upload: save filesize and mimetype automatically in 'upload mode simple',if those columns exist.

- 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=....

Link.php: SIP Links get automatically parameter '__dbIndexData'
Report.php: can select DB via 'dbIndex' directive (global)
AbstractBuildForm.php: dbIndexData now based on setting in Form (before on config.qfq.ini)
formEditor.sql: FormEditor update on Form 'form' and 'formElements'

HelperFormElement.php: AppendFormElementNameImageCut()
Support.php: Force Sanatize Class fuer FE.type=imageCut.
AbstractBuildForm.php: Add source filename to SIP
QuickFormQuery.php: Call $save->processAllImageCutFE();
Save.php: processAllImageCutFE(), extractImageDataReplaceFile()

Store.php, AbstractBuildForm.php, QuickFormQuery.php, Save.php: change signature of appendToStore() to be eqal to setStore().
Unittests for appendToStore.php

Bug 5004 FormElement with state 'ReadOnly' will be saved with empty value - existing values will be overwritten.

Feature 4901 / PDF Split: Preparation - new STORE_VAR variable {{filenameBase:V}}, {{filenameExt:V}}

Save.php: replace constant

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'

During expanding of templateGroups, existing FE with no meaning for save (like note, subrecord, ...) has been created, filled with empty values and saved. Fixed for FEs with type 'subrecord' and 'note' - needs more investigation to check for further sideeffects.

The new implementation creates empty fake instances of all copies of templateGroup FormElements. Those are empty. Before save, the submitted form values will be expanded with the empty fake templateGroup FormElements and such empty values will be saved.
FormAction.php: Rename constant SQL_FORM_ELEMENT_TEMPLATE_GROUP to SQL_FORM_ELEMENT_TEMPLATE_GROUP_FE_ID - to be more precise.
HelperFormElement.php, Database.php: new function explodeTemplateGroupElements()

#3253: STORE_TYPO3: steht waehrend Update / Save nicht zur Verfuegung - wird aber benoetigt. Bsp: feUser, beUser, pageId, ...

Thought that problem of #2064 is based on #3253 - that was wrong.
#3253 implemented, but not heavily tested.

#2064: problem was that for a non existing tablecolumn, has been searched for a default value - which obviously does not exist. In AbstractBuildForm.php, Line 419, a check implemented if the current FormElement is an existing tablecolumn. If not, do not change the empty value.

FormAction.php, FillStoreForm.php, Store.php, QuickFormQuery.php, Save.php: Refactor setVarArray() to setStore()

#3253
FillStoreForm.php: If there is no STORE_TYPO3, get the old values from SIP: CLIENT_TYPO3VARS.
Store.php: new function fillTypo3StoreFromSip(), copyT3VarstToSip()

Support.php, AbstractBuildForm.php: new function falseemptyToZero().
Constants.php: New UPLOAD_MODE_*
Evaluate.php: fixed bug in 'skip' logic of evaluate->parseArray()
Save.php: doUpload() now returns $modeUpload, which are needed in doUploadSlave(), rewrote logic of doUploadSlave(),

Default fuer Store Prioritaet hat sich geaendert: alt='FSRD', neu='FSRVD' - damit wird ist es ueberfluessig den V Store anzugeben.
Variable '_filename' umbenannt in 'filename' und verschoben von STORE_FORM nach STORE_VARS. Damit ist es ueberfluessig eine Sanatize Klasse anzugeben.
STORE_VAR hat zwei neue Variablen: 'filename', 'fileDestination'.
Bei Form-Action Elemente gibt es zwei neue Typen: 'sqlBefore' und 'sqlAfter'

Index.rst: Dokumentation auf V2 angepasst. Doku fuer V1 hat es nie gegeben.
FormAction.php: Moved function initActionFormElement to HelperFormElement::initActionFormElement(), Implement sqlBefore & sqlAfter for Action Elemente.
HelperFormElement.php: new class initActionFormElement(), initUploadFormElement().
FillStoreForm.php, AbstractBuildForm.php, Evaluate.php: Implemented the $skip parameter to suppress unwanted variable expansion during form load.
Constants.php: New STORE_USE_DEFAULT, VAR_FILE_DESTINATION, VAR_FILENAME,FE_SQL_AFTER, FE_SQL_BEOFRE, FE_TYPE_UPLOAD.
Evaluate.php: moved 'decryptCurlyBraces()' up, in order to  create better error messages.
Save.php: new doUploadSlave(), implement 'Upload advanced mode'.

- fix problem when more than one file uploaded - there was only one variable {{_filename}}, which was not sufficient for more than one upload element per form. New: {{_filename_<FE_NAME>:FE:allbut}}.
- implemented {{_deleted_<FE_NAME>:F0}}: if exist and is '1', than this means that the previous uploaded file has been trashed through the user by clicking on the trash.

Index.rst: update doc. Some more notes are needed. See one of the upcomming commits.
Constants.php: Renamed CLIENT_UPLOAD_FILENAME and created CLIENT_FILE_DELETED.
Save.php: Set var CLIENT_FILE_DELETED and use renamed CLIENT_UPLOAD_FILENAME.

1) '{{id:R0}}' now gives the correct record id, even on records which are 'new' (id is 0 at time of save) - '{{id:R0}}' can be used 'fileDestination' to build pathFilename.
2) Fixed problem with non existing uploads: in the past a sip has been saved instead of an empty string in the current record.
3) Fixed problem with a) choosing an upload file, b) deleting them immediately and c) pressing 'save'. Non existing temporary uploaded file has been tried to move to final destination.

Documentation/UsersManual: FormElement 'File' update
AbstractBuildForm.php: Extend upload structure with EXISTING_PATH_FILE_NAME.
QuickFormQuery.php: 'late save' of uploads implemented.
Save.php: upload columns are not saved during the first save - instead they are saved later.

During save of a record, if column 'modifed' and/or ' created' exist, set them.

Save.php: For Uploads the 'target' variable name renamed (name collison with native column 'pathFileName') from 'pathFileName' to 'fileDestination'.

AbstractBuildForm.php, BuildFormBootstrap.php, BuildFormTable.php, Constants.php, QuickFormQuery.php, Save.php: Replace string 'tableName' through constant F_TABLE_NAME.

Store.php: typo.
AbstractBuildForm.phhp: for all real form elements a fith't has been added: 'mode'.

CODING.md: edited to be more clearly.
AbstractBuildForm.php: doc
Save.php: If there is no upload, do not save the filename again (which needs to be calculated instead of using the sip)

save: Fixed not to save SIP values without corresponding FormElement or values from FormElements which are hidden or readonly.
Save.php: removed code to get FormElement - no benefit of this information.

Recode: fromelement.mode='readonly' new implemented on client, by using CSS attribute 'disabled'. The HTML atrribute 'readonly' is fine for pure 'input' elements, but does not work sufficient for 'select', 'checkbox', 'radio'. Also, the label (left of input) and note (right of input) are now grayed out if set to 'disable'.
FillStoreForm.php, Save.php: strings replaced by constants. New central function getfeMode() used by getJsonFeMode() and getAttributeFeMode()

Formelement.mode='lock': removed, cause it seems that there is no difference to 'readonly'. Inside the code, there is no difference
UserManual/Index.rst: doc updated
FillStoreForm.php, Save.php: same functionality like FE_MODE_READONLY - removed.
formEditor.sql: definition updated