jQuery Grid Plugin – jqGrid

We are pleased to announce the release of Guriddo jqGrid JavaScript and Guriddo Suito PHP versions 5.5.5. This is a bug fix release, with few useful additions. The documentation is updated according to the new release. Below is the list of additions and bug fixes.
 

PHP Changes

 

• Making easy work with dates when php >= 5.3.0
• Fix autocomplete to work with inline edit when 3 items are requiered

JavaScript Additions and Updates

 

• method GetFont now return more parameters to calculate precisely the width in canvas
• optimize intNum function and add new floatNum function for more compact calculations
• Add new colModel option autosize_headers – if set to true it will include the headers cells when calculation max width for auto re-sizing feature
• Add close button to search dialog in column menu
• Add aria-label=Close to elements without text which close the dialog s
• Add P option to date formatting . See https://www.php.net/manual/en/datetime.format.php
• Rename build.gradle to build_gradle
• Code and speed optimizations in filterToolbar method
• mergeSearch options is added in colMenu searching
• Add possibility to search in filter toolbar splitting the word separated with option splitSearchSeparator which produce or logic. By example entering a;b in search field will produce field == a or field == b
• Add grid option emptyRecordRow which enables or disables the No records to view row. Default is true.
• Add new parameter in dragEnd function to disable calling recreation of frozenColumns
• Add new common function – getElemByAttrVal to get element by attribute value from array of objects element
• Add new parameter in resizeColumn method to not recreate forzenColumns.
• Add possibility to use a predefined excel formatters again with possibility to format the excel value as true text – set exportoption excel_type =’text’. See: https://github.com/tonytomov/jqGrid/issues/984
• Add new utility function isJSON to check if the given value is (valid) JSON object.
• Changing parameter name in getGridParam which conflicts in some frameworks: https://github.com/tonytomov/jqGrid/issues/986
• Add a utility function dateToOADate to convert an ECMAScript Date to a Microsoft OADate. Used for export to excel for better date formatting.

JavaScript Bug Fixes

 

• Fix column name parameter in colMenuBeforeProcess when freeze
• Fix disable sortable columns with mouse on frozen columns.
• Fix for parameter disabledKeys in fillterToolbar method in order to prevent error in save/load-Sates methods.
• Fix for key-press in fillterToolbar when grid is restored from loadState
• Fix column grouping in state restoring loadState
• Fix column menu searching when reset is pushed and data is local with grouping
• Revert back the changes in setCell and setRowData methods so that we do not change the existing cell properties.
• Fix forzen column when re-sizing and calling it correct when rebuilding.
• Fix filterToolbar to restore correct the search in loadState when mergeSearch is on
• Fix for filterRefactor function to find correct the included fields
• Fix the _No records to view_ row to be not editable.
• Fix css presentation of custom element in filter Toolbar. Fix executing search on custom element in filterToolbar
• Fix auto re-sizing no to recreate frozenColumns on every column
• Fix toolbar search to keep the search values on frozen columns
• Fix showing sort icons on frozen columns
• Fix bug in setLabel method
• Fix for ie11 when using filterToolbar disabledKeys
• Fix gridResize method to work with bootstrap.
• Fix small problem in jquery ui resizable which should attach only one class with comma
• Fix export to excel when formatter return &nbsp
• Fix mergeSearch to work with single search in dialog searching (multipleSearch = false)
• Fix local sorting to work with local special characters https://github.com/tonytomov/jqGrid/issues/982
• Fix custom formatting in export to excel See: https://github.com/tonytomov/jqGrid/issues/983
• Fix forzen columns vertical synchronization when a new column is set to frozen.

Enjoy the new version.
Kind Regards
Guriddo Team

We are happy to inform you that the new release of Guriddo jqGrid JS version 5.5.4 is released. This is bug fix release, but add a full support of jQuery 3.5.X, has numerous important fixes and add a very useful additions. Below is the list of additions and bug fixes.

Additions and Updates

• Add new feature combined search – to combine search results in different searching modules. Added two new parameters – mergeSearch (boolen) and searchModules (object). See searching in documentation.
• Add two parameters to resizeGrid to enable responsibility on width and/or height
• $.jgrid.parseDate now can be used without to be applied to a grid object. Added new option parameter for validation
• Add colModel sizingStringFunc which is a user defined function to calculate the max width of column value. Parameters to it are cell value, font, options and row data object. Should return the width of cell value.
• Add grid event colMenuBeforeProcess to be executed before any action in any column menu defined. Parameters passed to it are module, action, and column name

Bug Fixes

• Fix no records message in frozen columns
• Fix group headers in case of autoresize is applied with double click
• Fixes for position dialog s (edit, view, search) when rtl is on and recreateForm is false
• Disable searching in filterToolbar when press special keys like alt, ctrl and etc. and autosearch is enabled.
• Fix exports in grouping
• Fix setGridWidth method when shrinkToFit parameter is set to false
• Fix getCol and getRowData methods in case of no records message appear.
• Replace the deprecated jQuery.isArray with Array.isArray
• Replace deprecated jQuery.isFunction with $.jgrid.isFunction
• Replace deprecated jQuery.type with $.jgrid.type
• Replace deprecated jQuery :first with first()
• Fix autoresizing when hidden columns are present.
• Fix frozen columns in certain situation when the first columns are hidden
• Fix icon position left in bootstrap4
• Replace deprecated jQuery :eq with eq()
• Replace deprecated jQuery :last with last()
• Replace deprecated :gt with slice
• Replace jQuery $.trim with $.jgrid.trim
• Fix pager when RTL.
• Fix transparency of header and footer rows in Boostrap4
• Fix frozen columns in various situations

Enjoy the new version
Happy coding
Guriddo jqGrid Team

We are pleased to announce the release of Guriddo jqGrid JavaScript 5.5.2. This is a bug fix release, with important fixes for Bootstrap 4. The documentation is updated according to the new release. Below is the list of additions and bug fixes.

Additions and Updates

• Add second parameter to setGridHeight, so that we set the entry grid height.

Bug Fixes

• Fix getDataIDs to not return “norecs” row
• Fix “norecs” row in case when add row with addRowData.
• Fix addRowData when add elements at certain positions in data array and fix reindexing of elements.
• Fine tune sort icons in bootstrap4
• Fix multiselect plugin to work with jQuery 3.5.x
• Fix pixel which causes scroll in Chrome in setGridWidth method when boostrap4
• Fixes for multibox header for jquery-ui css
• Fisxes for multisorting and sorting icons in Boostrap4
• resizeGrid now resizes to the parent/window height
• CSS Fixes for searchoperators in toolbar search
• Fix for the headerrow column in Bootstrap4
• Fixes for header row
• Fix find correct search operator in case there is a custom search element.
• Fixes for Frozen columns, stripped tables, group headers row hovering and row selecting in Bootstrap4
• Fixes for calling isGrouHeaderOn in filtering and exporting
• Fix icon position in navigator Bootstrap4 for fontAwesome
• Fix groupingHeaders when they are removed. Fix setGridWidth to remove/set frozen columns when it is executed. Fix position of data div of the frozen columns. Fix hovering in bootstrap
• Fix jquery UI css adding overflow hidden in navigator buttons with texts
• Fix remove centering of label cells when grouping. Add overflow hidden to long texts in navigator buttons
• Fix dirty-cell not being set and console error when saving using latest jQuery #972
• Fixes for boostrap4 modal-content class
• Fixed error “hasOwnProperty is not a function when saving data using jQuery 3.5.1
• Fix dirty-cell not being set on cells changed inline
• Fixing destroy group header function
• Fix Bootstrap4 warning dialog display property
• Fix grouping headers with frozen columns rebuilding.
• Bootstarp4 css fixes for group headers and frozen columns
• Fix hovering and highlighted selected row in Bootstrap 4 css
• Fix losing focus when setGroupHeaders is call.
• Fix sort icons in fontawesome and octicons css definition

Enjoy the new version.

Kind Regards
Guriddo Team

We are pleased to announce the release of Guriddo jqGrid JavaScript 5.5.1. This is a bug fix release with important fixes on tree grid.

Below is the list of the fixes:

Bug Fixes

• Fix preserving original values in method getRowData when using indent
• Fix reloading tree after search when treeModel is adjacency
• Fix for xml data when reloading tree node
• Fix formatting numbers in summary, header and footer data in excel export

Enjoy the new version.

Kind Regards
Guriddo Team

We are happy to inform you that the new release of Guriddo Suito PHP version 5.5.0 is released
This version is a minor release and add interbase SQL driver, improvements in TreeGrid, server and local exporting, unary searching, new method max grid height and much more.

PHP

Additions and Changes PHP

• Rewrite Intebase SQL database driver
• Support radio buttons in jqForm
• Added excel export options empty_date which set a empty date when the date is null or empty
• Use build in date functions when php >= 5.3.0

Bug fixes PHP

• Fix obfuscation error
• Fix deprecated function magic quotes to be compatible with php version 7.4
• Removing zoom property in css files

JavaScript

• For all additions and fixes see here

Enjoy new version
Guriddo Support Team