Scriptcase V9.7.x

Released: Oct 28, 2021

Aggiornamenti in V9.7.x

9.7.023

Updated Jun 21, 2022

Fixes

  • Fixed issue in the Application List interface of tab applications.

9.7.022

Updated Jun 15, 2022

Fixes

  • Removed "get_magic_quotes_gpc" function call in PHP 7.4 environment. The function has been removed from versions 7.4 or higher.
  • Fixed issue when uploading with filename containing "ç" in projects with ISO8859-1 charset.

9.7.021

Updated Jun 7, 2022

Fixes

  • Fixed problem in displaying background color of "Mac" layout in menu application.
  • Fixed problem with use theme background flag in menu application.
  • Fixed problem in displaying iframe properties in application links opening in modal.
  • Fixed problem in Excel export, when the title of the total contained a global variable.
  • Fixed problem in setting the width of layers in the menu.
  • Fixed problem when using tab navigation in menu applications.

9.7.020

Updated Jun 1, 2022

Features

  • Added support for hiding grid detail headers via sc_head_hide macro.

Fixes

  • Fixed problem in displaying grouped buttons after search result without records in grid.
  • Fixed problem in image preview when informing file upload using the storage API. The error occurred when using the same file name with different content.
  • Fixed problem with horizontal menu alignment.
  • Fixed problem when viewing the link application opening in iframe in a mobile grid.
  • Fixed problem with Quicksearch overlapping in grid when using advanced search label.
  • Fixed problem in the "label" view when selecting the calendar from the date field. The error only occurred on horizontal forms.
  • Fixed problem with horizontal alignment of the advanced search, when configuring and having an effect on the grid.
  • Fixed problem when displaying the title and collapse icon in the slide grid block on mobile.
  • Fixed problem after criticizing required fields in the last step of the form.
  • Fixed problem in shortcut to image directory for label icon on forms in advanced theme mode.
  • Fixed problem when viewing dropdown fields from mobile.
  • Fixed problem when viewing images in grid on mobile.

9.7.019

Updated May 19, 2022

Features

  • Added the option to view forms with multiple steps on mobile devices.
  • Added options to remove header, footer, border and margin when opening grid details in an iframe.
  • Added options to remove header, footer, border and margin from master/detail links.
  • Added options to remove header, footer, border and margin from grid links and open forms in iframe and modal modes.
  • Added new 'sc_head_hide' and 'sc_foot_hide' macros.

Fixes

  • Fixed problem when viewing select2 in form fields on mobile devices.
  • Fixed problem when closing capture application after registration selection on mobile devices.
  • Fixed problem with editable grid (view) form modal on mobile devices.
  • Fixed problem when viewing the "date" field in the dashboard application index, using the DBLIB connection.
  • Fixed "Uncaught ArgumentCountError: Too few arguments to function", when performing the totalization of a virtual field configured with lookup.
  • Fixed problem with block title display in advanced search when the option to display block title is unchecked.
  • Fixed problem in validating group by, when selecting the automatic lookup method without informing the SQL command.
  • Fixed problem in displaying the header of an application redirected by the edit link when using mobile optimizations.
  • Fixed problem with Progress PDO connection failure.
  • Fixed problem in display of fixed label in "Select" column of applications with capture link.
  • Fixed problem in quicksearch result, using fields with reserved words or protected by double quotes.
  • Fixed problem when using the "date" field calendar in modal, in versions 8 and 9 themes. This type of visualization is available when the "New Calendar" option in the "date" field settings is deselected.

9.7.018

Updated May 9, 2022

Features

  • Added support for 'fixed column' and 'form ordering' options when creating applications.

Fixes

  • Fixed problem when in Quicksearch using the Progress connection.
  • Fixed error Call to undefined function nm_psq_liga_cons, when running a grid application with the filter module disabled and the fields in Quicksearch selected.
  • Fixed problem in generating PDF in Alma Linux 8.5 environment.
  • Fixed problem in synchronizing data dictionary langs in applications that have group by.
  • Fixed problem when viewing edit buttons on horizontal forms on mobile.
  • Fixed a problem with the fixed label working on mobile horizontal forms.
  • Fixed problem with text preview in mobile vertical grids (using more than one column per page).
  • Fixed problem with displaying the height of form page tabs on mobile.
  • Fixed problem in displaying records in XLS and XLSX export in grid applications with nested grids and left text alignment.
  • Fixed problem with initial value in the filter when configuring with zero.
  • Fixed issue of overlapping menu application theme color by project theme color.

9.7.017

Updated Apr 27, 2022

Features

  • Chart applications now have the option to display progress bars when exporting to PDF. The user will be able to choose whether or not to display a progress bar when generating the PDF.
  • Added new property for the 'Open in another browser tab' link in grid applications.

Fixes

  • Fixed Fatal error: Call to undefined method :gera_icone() when enabling the "Icon" option in document type virtual fields in grid applications.
  • Fixed problem with browser window opening when enabling "Display progress bar" option. From this release, the PDF will be generated in another browser tab.
  • Fixed problem displaying discarded changes message when using signature type field in forms.
  • Fixed problem with loading the HTML editor when browsing editable grid forms.
  • Fixed conflict problem using the same field name with Scriptcase's internal function.
  • Fixed problem in displaying the modal window in the application toolbar button group interface.
  • Fixed problem with displaying "Print" and "Horizontal Line" buttons in the HTML Editor.
  • Fixed problem with the height of the HTML editor when the field is configured to be displayed on a form page.
  • Fixed problem in displaying grid fields in the side menu of the interface even after the option is disabled in the form.

9.7.016

Updated Apr 13, 2022

Features

  • Added new option within the PDF Grid export to include a progress bar for following the data export.
  • Field “HTML Editor” has been updated with mobile support, new HTML, new options, and faster rendering on screen.
    (You will need to update the production environment).
  • Added fixed columns in the Form application (multiple records, editable grid, and editable grid view).
  • Added editable Grid view horizontal form with editing and inclusion option using a modal window.
  • Added selection of fields that will be part of the editable grid (view), allowing different configuration of form fields.
  • Added new sorting icon type options on forms (set by theme or Font Awesome).

Fixes

  • Changed the text content of the advanced, dynamic and summary filter buttons to "Reset", in the English language.
  • Fixed problem in onGroupByAll event when performing calculations on fields.
  • Fixed problem when viewing the grid and summary export modules when the initial module was configured for PDF.
  • Fixed problem with Z-index of the option to save grid that was behind the application label.
  • Fixed problem when saving the option "Definition of the fields that will be displayed in the group by" in the group by field configuration.
  • Fixed problem in totaling a virtual field with negative values.
  • Fixed problem when viewing chart themes in the grid fields interface.
  • Fixed JS problem when using named fields with reserved words.
  • Fixed Parse error: syntax error, unexpected '\' (T_NS_SEPARATOR), expecting identifier (T_STRING), when using global variables in "where" clause using JOIN in SQL. The error occurred when selecting some fields in the refined filter.
  • Fixed error when running application with theme for button that contains quote.
  • Fixed problem with lifetime setting of files in tmp directory.

9.7.015

Updated Mar 19, 2022

Fixes

  • Fixed PHP error in array_map() and array_fill_keys() Expected parameter, when using tcpdf library in blank application.
  • Fixed problem in field mask for different phone digits in the grid.
  • Fixed problem when adding the same regional setting using different charsets in the project language.
  • Fixed problem with refined filter when filtering a field with empty value in postgresql.

9.7.014

Updated Mar 14, 2022

Fixes

  • Fixed Parse error: syntax error, unexpected '(int)' (int) (T_INT_CAST) in grid and chart applications if using only one dimension.
  • Fixed Fatal error: Uncaught Error: Call to undefined function initializeFixedColumnsSummary, when enabling fixed column option in summary.

9.7.013

Updated Mar 4, 2022

Fixes

  • Fixed problem with sorting when grid has an INNER JOIN.
  • Fixed problem with fixed column when using nested grid configured with display below records.
  • Fixed problem in the option "fix column of options", when the detail module was disabled.
  • Fixed problem when using the "sc_redir" macro using the target as "modal" in the search application.

9.7.012

Updated Feb 24, 2022

Fixes

  • Fixed problem when making changes to the grid sorting tab.
  • Fixed problem displaying refined search labels in grid when exporting PDF.
  • Fixed error in the fix log when setting a directory in open_basedir.
  • Fixed Fatal error: Cannot redeclare initializeFixedColumnsGrid() when using fixed columns option in nested grid application.
  • Fixed problem displaying refined search labels after loading saved grid state.

9.7.011

Updated Feb 21, 2022

Features

  • Added support for fixed columns to the grid allowing you to freeze data when scrolling horizontally.
  • Added the option to customize sort icons on field labels in grids.

Fixes

  • Fixed problem with grid label overlapping on search label.
  • Fixed problem in console in the grid.

9.7.010

Updated Jan 25, 2022

Fixes

  • Fixed problem in tab colors on pages in the form.
  • Fixed problem with displaying bottom edge of last tile in Google Chrome browser.
  • Fixed error display problem in grid when removing radio type field from advanced search.
  • Fixed problem using the escaped comma in the hint parameter of the sc_link macro.
  • Fixed problem in displaying ajax events in grid fields after refined search.
  • Fixed problem with displaying Font Awesome icons on form buttons when using RTL languages.

9.7.009

Updated Jan 3, 2022

Fixes

  • Fixed problem with help indexes in the interface.
  • Fixed problem in creating FTP publishing directories without common libraries.

9.7.008

Updated Dec 29, 2021

Fixes

  • Fixed problem on the searching of the "select" field in the dynamic filter, when the field was not available in the advanced filter.
  • Fixed issue with displaying refined filter on mobile when "start as" option is collapsed.

9.7.007

Updated Dec 22, 2021

Features

  • Added the functions "scHideUserField" and "scShowUserField" to enable or hide fields in the html control application through the macro "sc_field_display".
    NOTE: The documentation of the new functions is available in the application itself through the "CHECK" button.

Fixes

  • Fixed issue when starting the search in the tag filter.
  • Fixed problem sending the email from the application "app_form_add_users" in the security module. It will be necessary to recreate the module.
  • Fixed the login html templates in the external samples project library. The templates were modified to enable or hide the fields according to the settings informed in the security module.

9.7.006

Updated Dec 16, 2021

Features

  • Added a mobile optimized panel for the grid´s details module.
  • Added mobile options within the express edit.
  • Added a mobile bottom toolbar within the filter, detail, summary, and control module/applications.

Fixes

  • Fixed problem with the refined filter collapse/expand option, with the filter module unchecked.
  • Fixed problem with layout when exporting the chart application.
  • Fixed problem in the fixed label that was duplicated in the mobile grid application.
  • Fixed problem in the fixed label that was displayed above the refined filter button in the mobile grid application.
  • Fixed problem in the login html template in the external project samples library. The templates were modified for the new security module fields.
  • Fixed problem when using capture link with special character in the captured field value.
  • Fixed problem when opening quicksearch dropdown in form applications using mobile devices.
  • Fixed problem in updating the procedure in the Editable Grid View form. The value was not being updated.
  • Fixed problem when editing or deleting the example Business project.
  • Fixed problem in form printing export with mobile optimization.
  • Fixed problem when viewing the toolbar of applications from the security module on mobile. It will be necessary to recreate the module.
  • Fixed problem in the "cancel" button in the "grid save" with the mobile option disabled.

9.7.005

Updated Dec 2, 2021

Features

  • Added option to generate a mobile toolbar in simplified or full mode.
  • Added option to select year and month in mobile calendar.
  • Optimized mobile view when added to control, procedure, and search apps.
  • Added fixed bottom toolbar option for mobile viewing.

Fixes

  • Fixed error of "grid_save_grid.php not found" in the browser console, when running the grid application using the Enable mobile optimization option.
  • Fixed problem in the display of the scrollbar, using the Firefox browser in the "Insert Code" of the events.

9.7.004

Updated Nov 29, 2021

Fixes

  • Fixed fatal error: Uncaught Error: Call to undefined function sc_logged_is_blocked() in security module generation. It will be necessary to recreate the security module.

9.7.003

Updated Nov 24, 2021

Features

  • Added mobile optimization for form and calendar applications.
  • Added User profile image upload option to security module.
  • Added new end user 'Settings' option to security module.

Fixes

  • Fixed problem in the filter's clear button, in the checkbox type field, configured as manual lookup.
  • Fixed problem in formatting numeric fields passed as a parameter in the link. The field was being formatted when using the open property in another window.
  • Fixed problem in the HTML printing of the grid, configured with static group by and the option to start treeview closed. At the time of printing it only displayed the first record.
  • Fixed issue in the mobile grid toolbar, which only worked when there were buttons configured on the desktop toolbar.
  • Fixed issue with advanced filter mobile toolbar buttons. It was only displayed in the mobile application if there were buttons on the desktop toolbar.
  • Fixed damaged file issue in macOS Scriptcase installer.
  • Fixed problem in redirecting "sc_redir" macro to the PDF report application.

9.7.002

Updated Nov 10, 2021

Fixes

  • Fixed Fatal error: Uncaught Error: Call to undefined function NM_is_utf8() when using modal option in refined filter search.
  • Fixed problem when using the option "Rule Ordering" in the configuration of the grid sorting rules. The sorting was not being applied.
  • Fixed problem in displaying the format of "date" type breaks in Spanish.
  • Fixed problem in the display of the Exit (Back) button in the grid summary.
  • Fixed problem in generating applications when enabling the new mobile flag. Error: substr() expects parameter 1 to be string, array given.

9.7.001

Updated Nov 5, 2021

Features

  • Added new sample project: "Restaurant".

Fixes

  • Fixed problem in assigning value to a lang in the generated application.
  • Fixed error "Undefined variable: arr_def_proj" when creating the calendar application.
  • Fixed problem with size of tab margin-top in menu application.
  • Fixed problem when using the detail application, from a master/detail, in a step of the step form.
  • Fixed problem in creating tables during manual installation with MySQL connection, in PHP 7.0 environment.
  • Fixed problem in displaying "show" option items in menu toolbar interface. When changing the button type, some options were disabled.
  • Fixed problem in recognizing global variables in tab applications.
  • Fixed download file issue for damaged macOS.
  • Fixed problem in displaying alert message when adding a new language in the project.
  • Fixed problem in viewing the help of macros in events.

9.7.000

Updated Oct 28, 2021

Features

  • Added mobile optimization for grid, menu and chart applications.
  • Added Form Multi-Steps.
  • Added Two-Factor Authentication (2FA) to the security module.
  • Added API email configuration support in security module.
  • Added improvements to Refined Search.
  • Added new chart options (Zoomline, Scrolling and Overlapping).
    • You will need to update the production environment.
  • Added new sc_btn_disabled macro.
  • Added new sc_btn_label macro.
  • Added new sc_get_wizard_step macro.
  • Added new parameter "reply_to" in sc_mail_send macro.
  • Added the option to display the data of the fixed column during horizontal scrolling, available within the form application.
  • Editable Grid view horizontal form’s type now includes editing and inclusion option using a modal window.
  • It is now possible to apply Font Awesome icons to labels.

Fixes

  • Fixed error when generating source code for Online Shop project.
  • Fixed connection issue in CRM project when using SQL Server Native SRV PDO driver.
  • Fixed problem when using reload button when adding records.
  • Fixed sorting problem with column type CBLOB, BLOB and LONG, using Oracle database.
  • Fixed problem saving API in production environment, due to webkit update in some browsers.
  • Fixed problem when returning to the query application when using sc_redir macro in advanced search.