Radicore Forum: RADICORE announcements » RADICORE V2.23.0 released

Home » RADICORE » RADICORE announcements » RADICORE V2.23.0 released

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RADICORE V2.23.0 released [message #7764]

Tue, 01 November 2022 11:58

AJM
Messages: 2368
Registered: April 2006
Location: Surrey, UK

Senior Member

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.