WDF/BA Updates:

- Faster searching on the date in GP000, PFD000 and PFD001.

- Added the name, and a description, of the cron job to GP002.

- GP002 now also shows if the job is actually running or not, by showing a red number next to Yes/No in column 'Running'.

- Added a function 'mv_checkVATID', which checks a VAT-ID format and then at VIES.

- Added the hostname to the HEAD section of each app.

- Added a 'Log All' switch, which overrides the log level when on a development server, or for a super user on any server.

- Added Chamber of Commerce, Bank data and Payment Term to MD001, and removed it from MD000, where applicable.

- Moved variables used in both interactive and batch applications into a single file.

- Added system variable 'DEFAULTCOUNTRY' (GP006) to GP008, GP011, GP014, MD000 and MD001.

- Added currency data (name, abbreviation, symbol, decimal separator) to countries (GP007).

- Added currency variables, which are read from 'countries', initially with variable 'DEFAULTCOUNTRY'.

- Formatting masks are now formatted after reading currency data.

- Added VAT or GST data (type, high/middle/low %, valid from date) to countries (GP007).

- Added a new function 'mv_generateSerialNumber' to generate a serial number that can be en-/decoded in PHP and Xojo (and other languages if needed).

- Changed database tables and columns from latin1 to utf8. All tables and columns are now utf8.

- Various CSS and Code improvements, and bug fixes.

 WDF/BA Updates:

- Created better webbrowser-tab-titles.

- New masks to display numbers and amounts.

- Added extra currency defaults: $s_CURRENCYxxxx.

- Removed the SDS82-only restriction on GP000/2/5/7, GP010, MD000/1/2/5/6/7.

- New: Introducing a licensing model. If you want to sell your WDF/BA product, in according with our policies, you can now use a license code for your customers. When the license expires, their WDF/BA implementation cannot be used anymore, until they renew via you. License keys are maintained in GP006 and the customer's implementation calls the license-API to check for a valid license.

- Changed the standard upcase function into a multi-byte capable upcase function. This ensures ü is upcased to Ü, ñ to Ñ, etc.. This is done only for customers running PHP v7 or higher.

- Introduced 'excluded keys' for GP006. For excluded keys, separate GP006-variants exist, especially tailored for a specific type of key. With excluded-keys, you cannot change the data of these keys via GP006.

- Corrected various Help-texts.

- Code improvements.

 WDF/BA Updates:

- Added CSS classes '...gray' next to '...grey' to avoid UK/US typos.

- Added server check for (not) displaying the SSL logo.

- If an app is started from the URL-bar:

• default date values are now added correctly.
• default sort column is applied correctly

- Added default date of today for GP000.

- New: expiration date and/or period for user profiles. After a given date, or a number of days since last login, or both, the user profile expires and the user cannot login anymore. An admin-user must set a new date, reset last login or allow for a longer period.

- Encryption default permanently changed from 'BF-CFB' to 'aes-256-ctr'.

- Various code and speed improvements.

 WDF/BA Updates:

- Timeout of application and 2FA: when logged in via 2FA, the application now times out after 12 hours of inactivity. Note: this can be overridden by the web browser, which can put the inactive tab or window to 'sleep', which means that nothing runs on that page anymore, until it is activated again.

- Improved the Google GPS API call & GP014: remove cq. replace UTF-16 characters or certain ranges of extended UTF-8 characters from a street name.

- GP000: Improved search on short dates/times, like '2022-09-12 05'.

- GP010: Widened the text display of the task description.

 WDF/BA Updates:

- Preparations to replace the current encryption method to a more modern one.

- New: Using <, >, =, <=, >= in search fields in list view is now available. If you want this, contact me with the applications and in which column(s) you would like to have this functionality.

- Improved the Google GPS API call.

- Add ALT-ENTER to TEXTAREAs.

- Added user-specific 2FA-type in MD005. If you do not have 2FA enabled, but want it, contact me for a quote.

- Blocked deletion of your own profile in MD005.

- Improved CSS with dropdown menus. The highlight border would often hide itself behind input fields below it.

- Improved CSS on mobile devices with multiple select input fields.

- Various under the hood improvements and fixes in GP000, GP010, a.o.

WDF/BA updates:

- GP000: Improved search on record-ID; you can now use '%' to limit the search, for example 100000% lists all records starting with 100000.

- Replaced deprecated PHP code with new syntax.

- Hide hamburger menu when user has only access to just one application.

- GP009: E-mail address priorities changed to '1', '2', '3', 'CC' and 'No'. Priorities 1-3 places the email address in that order in an email. CC places the address into the CC-field, regardless the order. 'No' means not to use the email address.

- Removed the 'for SDS82-only' restriction in GP001, GP003, GP005 (changed to 'view-only'), GP007 (changed to 'view-only' when not role 'Admin'), GP008 and GP011.

- Source code clean-up and removed jQuery and JavaScript-tools that are not used anymore.

WDF/BA update:

- GP000: Improved query speed.