RADICORE v2.23.0 released

This version includes some new columns in the DICT_TABLE table in the DICT database plus a variety of bug fixes and small updates.

This version contains the following changes:

Database changes:

- amended the DICT database to add new columns to the ‘dict_table’ table. Please run script dict\sql\mysql\alter_table(2022-08-11).sql to implement these changes.

Other changes:

  • modified ‘audit_ssn_s01.class.inc’ in the AUDIT subsystem to correct the way in which the time period is reported in the log file.
  • updated ‘audit_tbl.class.inc’ so that any dates and times entered in the search screen are converted from the user’s timezone to the server timezone before the database lookup.
  • modified the DICT subsystem to add new columns to the ‘dict_table.class.inc’ and ‘dict_table.detail.screen.inc’.
  • updated ‘std.table.class.inc’ to fix bug in the custom_initialise() method where the 2nd argument should be passed by reference.
  • updated ’std.table.class.inc’ to fix bug in getColumnNames() method where it reset $this->fieldspec in the wrong place.
  • updated ‘std.table.class.inc’ to move some code in the getExtraData() method to a separate method.
  • updated ‘std.table.class.inc’ so that the _cm_getForeignKeyValues() method is called on the child object with the parent object as an argument instead of being called on the parent object with the child object as an argument.
  • updated ‘std.table.class.inc’ so that the getInitialData() method will not ignore entries in $this->fieldspec if both the ‘nondb’ and ‘mustvalidate’ attributes are set.
  • updated ‘std.table.class.inc’ so that the getOrderBySeq() and setOrderBy() methods work more accurately.
  • updated ‘std.table.class.inc’ to remove the call to the setJavaScript() method. This has been moved to ‘include.xml.php5.inc’.
  • updated ‘std.table.class.inc’ so that the insertRecord() and updateRecord() methods deal properly with fields which have the ‘nondb’ attribute set in $this->fieldspec.
  • updated ‘std.table.class.inc’ so that the loadFieldSpec() method deals with the new data which is available in the ‘<table>.dict.inc’ file.
  • updated ‘std.table.class.inc’ so that the popupReturn() method will initialise any fields to be returned from parent table.
  • updated ‘std.table.class.inc’ so that the set_column_scale() method will set the scale of the functional currency to the correct value.
  • updated ‘std.table.class.inc’ so that the setJavaScript() method will return an empty array instead of NULL.
  • updated ’std.table.class.inc’ so that the sqlSelectInit() method will deal properly with any SQL variables passed into scripts using the LINK1 pattern.
  • updated ‘std.table.class.inc’ so that the _sqlAssembleWhere() method will call the selectAllColumns() method using the $fieldspec array from the correct object.
  • updated ‘std.search1.inc’ to remove a redundant call to the getExtraDataMethod().
  • updated ‘include.library.inc’ so that the extractOperatorValue() function will return the default values for $operator and $delimiter if none are found in the input string.
  • updated ‘include.library.inc’ so that the getForeignKeyValues() function will call the getForeignKeyValues() method on the cgild object instead of the parent object.
  • updated ‘include.library.inc’ to include a function called round_up() which can be used to round ndecimal numbers UP instead of DOWN with the standard PHP round() function.
  • updated ‘include.library.inc’ so that the selectAllColumns() function will work properly if the subject table has been given an alias name in the SELECT list.
  • updated ‘include.library.inc’ so that the splitNameOperatorValue() function will detect and deal with more regex patterns.
  • updated ‘include.library.inc’ so that the splitWhereByRow() function will detect and deal with more regex patterns.
  • updated ‘include.xml.php5.inc’ so that the addData2XMLdoc() method calls $dbobject->setJavaScript().
  • updated ‘include.xml.php5.inc’ so that the addData2XMLdoc() method will not call $dbobject->formatData() if the pattern is ‘OUTPUT4’.
  • updAted ‘std.multi4.inc’ so that if $return_from is not empty it will set $dbouter->skip_getdata to TRUE.
  • updated ‘dml.mysqli/oracle/pgsql/sqlsrv.class.inc’ to add the $tablename argument to the adjust_derived_query() method.
  • updated ‘dml.mysqli/oracle/pgsql/sqlsrv.class.inc’ to set $sort_str to the correct value before performing a SELECT query.
  • updated ‘include.session.inc’ to output the correct error message if the unserialize of the session data obtained from the database fails.
  • updated ‘output4.header.class.inc’ tests the corect variable $before setting rowdata[’selected’] to the relevant value.
  • updated ‘std.link1.inc’ so that it calls the initialise() method on the $dblink object.
  • updated ‘std.output4.inc’ so that it does not reset $dbinner->fieldspec.
  • updated ‘std.list2.inc’ so that when used in a POPUP2 task and returning from a POPUP1 task in which ‘choosenull’ was selected it will stop processing the current POPUP2 task and return to the previous task instead.
  • updated ‘std.currency.class.inc’ so that it will not replace a zero value with blanks.
  • updated ‘std.update1.inc’ so that it will call $dbobject->setPageNo() with the correct value before calling $dbobject->getData().
  • updated ‘std.add1/2/5/6/7.inc’ to ensure that a call to $dbobject->getExtraData() is made after the $_POST array has been processed.

Published: 01 November 2022