WDF/BA Updates and improvements


 WDF/BA Updates:

- The key combination ALT/OPTION-ENTER now also works in EDIT-mode and puts the focus on the 'Submit'-button. This allows for quick and almost keyboard-only data entry.

- In listview, you can now use the arrow keys to select a record. The page will automatically scroll up or down when you reach the botoom or top. Hit ENTER to open the selected record in VIEW-mode, the hit ALT/OPTION-ENTER + ENTER to start EDIT-mode.

- Fixed a bug with the user's account expiration date.

- Improved the country-selection drop down menu contents, now that country codes have subcountry codes, like 'IT-21', 'US-AK', etc.. in GP008/11/14, MD000/1/2/5.

- Various other fixes and improvements.

Changes, additions and updates


 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.

Changes and updates


 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.

Various improvements


 WDF/BA Updates:

- Moved the config file and document folder outside the webroot into WDF/BA's own directory structure. This is done for almost all customers that host with us.

- Changed the uppercase function in apps that use it, into the multi-byte version. This transfroms ü correctly to Ü.

- Improved the check on which server (DEV, VOS, ANU, LOCAL) the application is running.

Various changes and additions


WDF/BA Updates:

- In GP004 or MD007, the 'Default Menu' button is now greyed out when there is no default menu defined.

A default menu can be defined in GP006, by using keys with prefix 'DFTMNU' followed by something you fancy, for example 'DTMNU10', 'DTMNU20', etc.. 

The alphanumeric field should contain only the name of the application, like 'gp006', and the numeric field should contain the sequence number for the order of the menu items.

- Added a 'Clear search fields' icon-button in list view, next to the 'Search' button.

- CSS changes for improved mobile display.

- For Excel exports, now we can define which names to use for column headings: the long or short ones.

- Added a password generator icon-button in MD005 next to the password field.

- Added an improved password tester to MD005, so a user can only use a good and strong password.

- Added 'Kind of customer' to MD000. You can choose from 'An own company', 'Customer', 'Supplier', 'Both (C & S)' or 'Other'. If you do not have this, or something similar, in your implementation, and you want it, contact me for a quote.

- Various under the hood changes and fixes.

Additions and changes


WDF/BA updates:

- NEW: Introducing background images. You can now add a background image to your WDF/BA:

In GP006, add a key 'BKGIMAGES', and in the text area, add links to images, each link on a new line.

The display of the background images is spread over 24 hours, in the following manner: for example, when you added 4 links, you have link 0, 1, 2 and 3 : int(current hour / (24 / number of links)) = int(15 / (24 / 4)) = int(15 / 6) = int(2,5) = 2, which means it will use link number 3.

This way, you can have special images for the morning, midday, afternoon, evening and night.

- Improved local development and test environment by installing local HTTPS and DNS .

- Changed the general log level from 9 to 7. Changed the log level of reading data for list views to 9 for interactive mode and 2 when exporting. This change will massively reduce the number log-entries.

- GP004: Renamed it to MD007, which is a better place for it.  This is implemented by default for new customers, and for existing customers who do already have an MD007 for something else.

- GP009: Improved auto-complete on the tags field.

- MD000: Added 'copy a record'-mode. This is implemented by default for new customers, and for existing customers who need it.

- MD001: Added a TagEditor to the 'Location type' field. This is implemented by default for new customers, and for existing customers who need it.

- Many CSS and under the hood fixes and updates, including removing or replacing PHP 8.1 deprecations. The final move to PHP 8.1 for the production servers, is planned to be done in April/May 2022