| RADICORE V2.10.0 released [message #7188] |
Wed, 01 August 2018 10:16 |
AJM
Messages: 2363
Registered: April 2006
Location: Surrey, UK
|
Senior Member |
|
|
This version contains a mixture of small updates and bug fixes. It also includes a fix for a BC break which appeared in PHP version 7.2 without warning, plus an update for when MySQL version 8 is in use so that it can use a Common Table Expression (CTE) for reading hierarchical structures.
Database changes:
- none
Other changes:
- updated std.help.inc to add flush() just before exit so that the buffer is cleared before it enters the shutdown_handler() function (which is defined in file error.inc).
- updated std.output3.inc and std.filedownload1.inc to flush the output buffer so that nothing is left over for processing by the shutdown_handler() function.
- updated std.datevalidation.class to improve validation in the getInternalDate() method.
- updated audit_tbl_s01.class.inc and audit_tbl_s02.class.inc to change addslashes() to addcslashes() so as not to escape double-quotes in the WHERE string.
- updated audit_trn.class.inc and audit_ssn.class.inc to fix a missing value in the trn/ssn_datetime field.
- updated php_session.class.inc to change arguments on calls to the logstuff() function.
- updated dml.mysqli.class.inc to set the correct size value for unsigned numbers.
- updated output4.screen.inc in DEFAULT folder to incorporate changes made to the OUTPUT4 pattern.
- updated _cm_pre_getData() method in dict_table.class.inc to deal with the possibility of using an alias name.
- updated logon.class.inc to look for a value to populate $_SESSION['party_id_functional'] in those installations which have a PARTY subsystem.
- updated mnu_task_s02.class.inc to move processing from the _cm_validateUpdate() method to the _cm_pre_updateRecord() method.
- fixed bug in mnu_task_s04.class.inc which did not allow for a user having multiple roles.
- fixed bug in mnu_nav_button.class.inc where the getNavButtons() method selected the 'task_desc' field instead of the 'task_name' field.
- fixed minor bugs in wf_workflow.class.inc, wf_workitem.class.inc and wf_arc.class.inc.
- updated workflow_engine.class.inc so that error messages are obtained from the language file in the correct directory.
- updated include.library.inc to fix bug in array_update_indexed() function.
- updated include.library.inc to cause the array2where() and selection2where() functions to use addcslashes() instead of addslashes() so that only single quotes are escaped.
- updated include.library.inc to allow the getForeignKeyValues() function to work in the direction child-to-parent as well as parent-to-child.
- updated include.library.inc to fix bug in the getPostArray() function.
- updated include.library.inc to allow the getTimeStamp() function to optionally use the user's timezone instead of the server's timezone.
- updated include.library.inc to allow the logStuff() function to deal with the $input argument as an array as well as a string.
- updated include.library.inc to force the logSqlQuery() function to write to the correct directory.
- updated include.library.inc to force the pasteData() function to not overwrite a date with an earlier date.
- updated std.tree_view1.inc and std.tree_view2.inc to call getExtraData() method, and to accept search criteria.
- updated std.tree_view1.inc and std.tree_view2.inc to call the getCollapsed() method.
- updated std.search1.inc to put the call to getInternalDate() in a try/catch block so that it can deal with invalid dates correctly.
- updated std.search1.inc so that if the output from $dbobject->post_search() is an indexed array it will be converted into an associative array.
- updated include.session.inc and include.batch.inc to deal with a BC break that was introduced in version 7.2 (see http://www.tonymarston.net/php-mysql/bc-break-in-7.2.html for details).
- updated include.batch.inc so that the batchScriptSequence() function can properly handle the situation when the scriptSequence() function is used in a CLI/background task.
- updated error.inc to change the sequence in which the data is output to the screen and written to the disk file.
- updated std.pdf.class.inc to allow a field definition in the ???.report.inc file to override the border settings for the current style. This will allow the top/bottom/left/right borders of a cell to be either added or removed.
- updated include.xml.php5.inc so that if a checkbox field does not have a value specified for optionlist it will default to the standard 'boolean' optionlist.
- updated output4_header.class.inc so that the _cm_updateFieldarray() method will allow unwanted values to be removed from the $postarray argument.
- updated std.add1/2.inc to include a call to $dbobject->changeActionButtons() to see if any buttons have been changed or deleted.
- updated std.add1/2.inc to include a call to $dbobject->quitButton() before returning to the previous script.
- updated std.csv.class.inc so that the outputCSV() method will nullify the $csvouth variable after it has been closed so that the controller (std.output1.inc) will not try to close it itself.
- fixed bug in std.link1.inc where it used $fieldarray instead of $outer_data.
- updated std.update1.inc so that if the CANCEL button is pressed it will call $dbobject->quitButton() before returning to the previous script.
- updated std.multi6.inc so that the calls to ->setFieldArray() do not reset $pageno and $numrows.
- updated std.multi6.inc so that the calls to ->updateFieldArray() include the switch which causes the call to _cm_commonValidation() to be skipped. This validation method will instead be called after the data has been re-fetched.
- updated std.multi6.inc to fix the pagination/scrolling issues caused by the $middle entity being allowed to contain either a single row (detail view) or several rows (list view).
- updated std.table.class.inc to include the array variable $drop_from_sql_select which will cause the nominated fields to be dropped from the SELECT clause of the SQL query when the _sqlAssembleWhere() method is called.
- updated std.table.class.inc to include the changeActionButtons() and _cm_changeActionButtons() methods to deal with the circumstances where action buttons are renamed.
- updated std.table.class.inc so that the clearEditableData() method will not clear any field which has the 'noclear' attribute set.
- updated std.table.class.inc to fix bug in currentOrHistoric() method so that it will not fail if the current table does not actually have a start_date and end_date field.
- updated std.table.class.inc so that the fetchRowChild() method will populate the object's $parent_data so that a call to getParentData() will provide the data for this child's parent.
- updated std.table.class.inc so that the formatData() method can handle date and datetime fields properly.
- updated std.table.class.inc so that the getColumnNames() method (as used in output4 patterns) will show a checkbox instead of a dropdown for the 'selected' field.
- updated std.table.class.inc to that the getData_raw() method will call the qualifyWhere() function on the $sql_search variable if it is not empty.
- updated std.table.class.inc so that the getParentData() method now includes an argument ($first_row_only=false) which can be set to TRUE so that the first row is returned as an associative array instead of a possible indexed array.
- updated std.table.class.inc so that when the getData_serial() method calls getParentData() it causes it to return an associative array instead of an indexed array.
- updated std.table.class.inc so that the getExtraData() method includes an extra argument ($no_foreign_data=false) which can be set to TRUE to cause the call to getForeignData() to be skipped.
- updated std.table.class.inc so that the getFieldArray() method includes an argument ($first_row_only=false) which can be set to TRUE to cause it return the first row as an associative array instead of all available rows in an indexed array.
- updated std.table.class.inc so that the getForeigndata() method can correctly handle the situation where an entry in $parent_relations contains a value for 'alias'.
- updated std.table.class.inc to comment out redundant code in the getNodeData() method.
- updated std.table.class.inc to include the getCollapsed() method for use in the tree1 and tree2 patterns.
- updated std.table.class.inc so that the initialise() method will ignore any values in the $_SESSION['search'] array which are not strings.
- updated std.table.class.inc so that the insertRecord() method will not supply the $old_data argument on the call to the _cm_commonValidation() method.
- updated std.table.class.inc so that the setFieldarray() method includes an extra argument ($reset_numrows=true) which can be set to FALSE so that the value in $this->numrows is not reset.
- updated std.table.class.inc so that the updateFieldArray() method includes an extra argument ($perform_validation=true) which can be set to FALSE so that the call to _cm_commValidation() will be skipped.
- updated std.table.class.inc so that the updateMultiple() method will ignore fields which do not exist in $this->fieldspec when copying data from the POST array to the object's $fieldarray.
- updated std.table.class.inc so that the _dml_getData() and _dml_getData_serial() methods can pass the data for Common Table Expressions to the database object.
- updated std.table.class.inc by adding the findDBVersion() method. This is to allow the use of MySQL version 8 to be detected so that an SQL query which is a Common Table Expression (CTE) can be used to traverse hierarchical structures.
- updated dml.mysql/sqlsrv/pgsql/oracle.class.inc to allow a Common Table Expressions (CTE) to be used in hierarchical structures which are displayed using std.tree_view1/2.inc. Note that this is not available for MySQL unless you are using version 8.
- updated _cm_getNodeData() method in x_tree_structure(tree2).php (XAMPLE subsystem) to show how Common Table Expressions can be used.
Tony Marston
http://www.tonymarston.net
http://www.radicore.org
|
|
|
|
Radicore Forum
Search
Help
Members
Register
Login
Home
