WDF/BA Updates and improvements

 Permalink

 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.

Updates, improvements, fixes, etc.

 Permalink

 WDF/BA Updates:


- UI improvements for subfiles: title bar, field rows...

- UI improvements for list view: aligning buttons, background colors, ...


- Added VAT/ST-tiers to GP007, with 'Valid from'-date.

- Updated the countries table with regions and states, for example: 'US-AK' for Alaska, USA; 'CA-AB' for Alberta, Canada; 'IT-21' for Piemonte, Italy; etc.. Applications and database tables have been updated accordingly to accomodate for the longer country codes.


- You can now add translated country names in GP001. This will then show the country's name in the selected WDF/BA language.


- Searching in GP008 was standard with wildcards around the entered text. To speed up the search, this has been removed. If you want to search in 'contains'-mode, add a '%'-sign before the value you're searching for: '%nl'


- Stopped logging data that was never look at, and so save some disk space.


- In drop down menus with a search field, the search is now 'contains'-mode, instead of 'begins with'-mode.


- Loading text labels is faster. The underlying query to look for text in the current language has been improved.


- MD003 and its tables have been removed. An 10 year old idea, but never developed any further.


- Various code improvements and small bug fixes.

Changes, additions and updates

 Permalink

 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.

Various improvements and changes

 Permalink

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.

TagEditor styling and Date calculations

 Permalink

WDF/BA updates:

- TagEditor styling: set a maximum width.

- Fixes inside the date calculation routine that could cause 'Passing null to...' errors.

- GP008/10/13: An error message was not translated into the chosen language.

- MD005W: Bug fix.

- Added automatic amount formatting of fields on Excel/CSV export.