Refs #4018: Implement renamed keywords _ta_query, _ta_prefetch. Fix broken detection of typeahead mode.

Philipp Gröbelbauer authored 2 years ago and Philipp Gröbelbauer committed 2 years ago

check if array elements exist before accessing them, to make the code compatible with newer PHP versions

Fixes #14292. Upload: mode=required broken for advanced upload (non primary column) after first save

Implemented new php unit tests for encryption feature. Customized old unit tests to get them ready and work for the new feature (testConfigIniDefaultValues, TestFormEditor.sql). And corrected some typo.

QFQ encrypt/decrypt WIP: Feature implementation for Forms and Report finished. QFQ Variables are in progress

QFQ encrypt/decrypt WIP: created new class for encryption and decryption of strings. Implemented multiple functions to handle these data. Prepared formEditor.sql and formElement.json for new feature

#Refs 13722: Detect and fix pdfunite problems "Gen inside xref table too large (bigger than INT_MAX)" via pdf2ps, ps2pdf

Problem was a second exception. Prevent throwing 'invalid sip' a second time will show IP/feUser already in first exception handling.

F9052 CodeMirror changes: 1. header in extern window is sticky- 2. pagetitle,content header and content id is shown in header- 3. File (reportPathFileName) is only shown if given- 4. page in extern window no longer flickers at first load

B13677 Implemented variable to get required new from form and set status of formelement preview button correctly.

S13679 Multiple changes in php and js to get tablesorter-view-saver work in subrecord. Implemented new parameter for subrecord to give own attributes. Selecting views or columns doesn't impact browser history and record lock anymore. Only saving a new view or deleting an existing view still impacts browser history (but not record lock), It's impossible to prevent it because we need the page reload to get new existing views after deleting or saving a new one.

F9052: New feature implemented with js to edit content records in front end. Now a separate window will be shown for every content record to edit it. Extern edit window stays open until it will be closed. After refreshing main window changes are shown.

S13827: Added new font family to fake passwords. Using the font for formelement password. At the end we dont use the input type password anymore. Best solution to prevent offers of user credentials from browser.

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

B13842 Changed cookie params in session. Domain is not needed to give because we dont use subdomain. Better compatibility with qfqpdf.