jQuery Grid Plugin – jqGrid

Hello,

We are glad to anounce the immediate availability of Guriddo jqGrid JavaScript version 5.2.0.
This version is a major release and add a support of jQuery 3.x.
Another usefull addition is true export to Excel, PDF and CSV with our new export module. See our updated demo

Below is the list of additions and fixes:

Additions and Updates

• Support to jQuery 3.x
• Added a export to CSV, Excel (open excel format) and pdf. For excel we need additionally jsZip and for pdf pdfMake libs.
• Add saveAs function in util module, which do a browser save dialog for saving diffrent data type.
• Update Portugase translation file grid.locale-pt.js
• Add a new event – validationCell which may occur (if defined) when a validation error. Parameters – element, error message, iRow and iCol. When restoreCellonFail is set to false now we focus the cell when info dialog is closed
• Added method setSortIcon. the method changes the position of the sort icon at left or right. The first parameter is the column name or the position of the column in colModel starting from zero. The second parameter is left or right(or empty or nothing).
• Update of lang files for the serch dilogs
• Update for the language spanish file.
• Update of Bulgarin, German and Russian lang files according to the new search text
• Adding validationCell event custom message in inline edit. Parameters passed to this are the element, error message, row index and column index.
• Update Chinese Translate for v5.1.1
• Adding custom aggregate function in pivot grid. In the aggregates array the aggregator now can be a function.
  Parameters passed to this function are: value, field name, data record
• Making possible to run addLocalData as grid method. Added a parameter(boolean) which set if we need all the data (and not paged one)

Bug Fixes

• Fixes in import module.
• Fix cc variable in cell edit to be a jQuery object causing error. See https://github.com/tonytomov/jqGrid/issues/812
• Fix pivot in case yDimension is not set
• Fix getRowData when the second paraneter is not set
• More tolerante checking of isEmpty function in formedit validations
• Fix for beforedrop event in the gridDnD method.
• Fix for avg function in pivot
• Fix: Data in pivot should be array.
• Fix cacheUrl to accept empty values in case in case they are defined in option value.
• Fix getting the cell data in cell edit mode
• Fix: Added missed translation text in serach dialogs for the button rules.
• Fix get cell to return the right content of the ExpandColumn field when treeGrid is on
• Fix for Bootstrap horizontall scroll bar when height auto/100%
• Fixed misspelling of “inline-block”
• Fix info dilog when error from the server – position the dialog ner to the cell and focus a field if restoronCellFail is false
• Try to focus the field in inline edit when a validation error occur
• Fix finding the position of the objec. We need the cuurent position of the screen.
• Fix pivot initial sorting when set in grid options as sortname
• Fix pager info for loaded records when adding new one and virtual scroll is enabled.
• Formatting changes
• Fix adding non empty id in editGridRow (fix is for treegrid)
• Fix German locale toolbar search options

Enjoy the new version.
Trirand Team

Hello All,

We are pleased to announce the release of Guriddo Suito PHP 5.1.1. This is a bug fix release and includes the following additions and fixes:

PHP

Additions and Updates

• Add possibility to save the exported result (csv, excel, pdf) to a server.
  Added 3 new parameters in the appropriate csv, pdf excel options
  – save_to_disk (boolean default false)
  – save_to_disk_only (boolean default false) ,
  – disk_file (string default empty string)
• Added custom function in scheduler public $customFunc = null;.
  The function work the same way as in grid. The first parameter is the operation
  and the second is the data for that operation.
  The operation can be: ‘editEvent’,’removeEvent’,’newEvent’,’resizeEvent’, ‘moveEvent’
• Added error messaging in Scheduler when error occur

Bug Fixes

• Fix scheduler form search function
• Fix the /e modifier is deprecated in preg_replace in jqGridArray
• Fix date formatting for true excel export

JavaScript

Addition and Updates

• SetLabel method accept now column name or index of the coulmn.
• Remove the local _savedData parameter from editRow and replace it with
  the global savedData (like savedRow) which now part of Grid parameter for easy access
• Add support in loadState for Subgrid
• Add support in loadState for Tree Grid
• getFormData have the same ruled obtaining the values as in createData and syncSavedData
• Update French localization
• Added beforeSetTreeNode and afterSetTreeNode events (grid parameters) in setTreeNode method
• Added method setLeaf, which visually change the icons and data (isLeaf) parameter
• reloadNode method now support updating the current node Leaf status depending if there is a data or not
• Added debug option in saveState method to generate dump grid file with options and data.
  (very useful for test and support)
• Added option editselected (default false) in form edit module which allow to edit only the selected rows in multi select mode
• Set $.jgrid.useJSON by default true
• In custom sort function we add the full sort objects as 4 and 5 parameter in order to overcome some Chrome unexpected sort behaviour
• Add paremeter saveAfterSelect (default false) in inline navigator (inlineNav) to save the row if another is selected
• RTL support for column menu. The column menu is positioned near to column icon

Bug Fixes

• Fix for search operators and search oper menu
• Fix checking compareData function to work properly when checkOnUpdate and/or checkOnSubmit is on
• Fix saveSatate to export correct the data
• Fix savedData array in form editing to have fields only if they are found in template
• Fix the position of column menu with actions
• Fix column menu sort to work with multisort
• Fix for inline saveRow method to show the validation UI dialog.
• Fix for info_dialog syling
• Fix using checkOnUpdate with dataUrl in edit options.
• Fix binding click events in treeGrid after loadState is called. The _index should be refreshed in order to get right positions
• Removing not needed code in grouping
• Fixes in getRowData
• Fix jqGridExport not to delete the additional tree Columns
• Fix toppager css
• Fix for frozen Columns in IE11
• Fix check in our jsoon parse function
• Fix for right border when bootstarp is used with alternate row collor
• Fix for loadState to check selected checkboxes of selected rows when multiselect is set
• Fix for cbox class to not be added two times
• Fix for bootstrap border problems in diffrent grid elements
• Fix prevent click for the disabled check boxes in multiselect mode in IE browsers
• Fix jumping to the top of page when a colmenu is clicked
• Fix multiselect when a checkbox is checked
• Fix setFrozenColumns heigh inconsitencies when the height is not default and/or a rowspan is used
• Fix detecting MS IE <=11. Note that MS Edge is not IE browser
• Fix uniqueSearchFields in filter string
• Fix for RTL scrollbar
• Bootstrap CSS fix for RTL
• Fix semicolon in base module.
• Fix inlineNav when beforeAddRow and beforeEditRow return false not to show the save cancel buttons in inline navigator

Kind Regards,
The TriRand Team

Hello All,

We are glad to inform you that the new Guriddo jqGrid JavaScript version 5.1.1 is available. This is a bug fix release with more than 30 fixes and a lot of useful additions. Bellow is the detailed description of them.

Additions and Updates

• SetLabel method accept now column name or index of the coulmn.
• Remove the local _savedData parameter from editRow and replace it with
  the global savedData (like savedRow) which now part of Grid parameter for easy access
• Add support in loadState for Subgrid
• Add support in loadState for Tree Grid
• getFormData have the same ruled obtaining the values as in createData and syncSavedData
• Update French localization
• Added beforeSetTreeNode and afterSetTreeNode events (grid parameters) in setTreeNode method
• Added method setLeaf, which visually change the icons and data (isLeaf) parameter
• reloadNode method now support updating the current node Leaf status depending if there is a data or not
• Added debug option in saveState method to generate dump grid file with options and data.
  (very useful for test and support)
• Added option editselected (default false) in form edit module which allow to edit only the selected rows in multi select mode
• Set $.jgrid.useJSON by default true
• In custom sort function we add the full sort objects as 4 and 5 parameter in order to overcome some Chrome unexpected sort behavior
• Add parameter saveAfterSelect (default false) in inline navigator (inlineNav) to save the row if another is selected
• RTL support for column menu. The column menu is positioned near to column icon

Bug Fixes

• Fix for search operators and search oper menu
• Fix checking compareData function to work properly when checkOnUpdate and/or checkOnSubmit is on
• Fix saveSatate to export correct the data
• Fix savedData array in form editing to have fields only if they are found in template
• Fix the position of column menu with actions
• Fix column menu sort to work with multisort
• Fix for inline saveRow method to show the validation UI dialog.
• Fix for info_dialog syling
• Fix using checkOnUpdate with dataUrl in edit options.
• Fix binding click events in treeGrid after loadState is called. The _index should be refreshed in order to get right positions
• Removing not needed code in grouping
• Fixes in getRowData
• Fix jqGridExport not to delete the additional tree Columns
• Fix toppager css
• Fix for frozen Columns in IE11
• Fix check in our json parse function
• Fix for right border when bootstrap is used with alternate row collor
• Fix for loadState to check selected checkboxes of selected rows when multiselect is set
• Fix for cbox class to not be added two times
• Fix for bootstrap border problems in different grid elements
• Fix prevent click for the disabled check boxes in multiselect mode in IE browsers
• Fix jumping to the top of page when a colmenu is clicked
• Fix multiselect when a checkbox is checked
• Fix setFrozenColumns heigh inconsitencies when the height is not default and/or a rowspan is used
• Fix detecting MS IE <=11. Note that MS Edge is not IE browser
• Fix uniqueSearchFields in filter string
• Fix for RTL scrollbar
• Bootstrap CSS fix for RTL
• Fix semicolon in base module.
• Fix inlineNav when beforeAddRow and beforeEditRow return false not to show the save cancel buttons in inline navigator

Hello,

We are glad to inform you that the long avaited 5.1.0 version of Guriddo Suito PHP is out. This is a major release that includes a lot of new features and fixes.

PHP

Additions and Updates

• Add possibility in Schedule to build selects dynamically – as SQL or array using the new setSelectOptions
• Develop a way to add custom fields easy in Scheduler. See Article
• Support for multi select in Scheduler
• It is possible to add/update additional data in Scheduler using the new setUserData method
• Added option currentHidden (default false) which allow to export the current hidden fields in grid. See demo

Bug Fixes

• Fix in Schedule html template to view the date range in calendar
• Fix in Schedule allDay to be parsed correct
• Fix for array driver in fetch_assoc and fetch_object functions where the counter does not initialize correct
• Fix export to excel if editoptions are not set
• Fix autocomplete to limit the number of results to those set in itemLength

JavaScript

Additions and Updates

• Add new event parameter in filterToolbar method – onClearSearchValue and corresponding jqGridToolbarClearVal . To this event are passed the following parameters: html element, column index, searchoptions, default value
• Added a options between. The option is valid only in filterToolbar method. To use this feature the values in search field should be separated with “…”. Example – to parse values between 1 and 10 the following should be entered: 1…10 in the search field. See demo.
• Added a possibility to use multiselect in toolbar searching. Any multiselect plugin can be used. For this purpose a new parameter is added in filterToolbar method – groupOpSelect to determine the group operand when multi select is on Can be AND or OR. Default is AND. See demo.
• Update Japanese translation
• Added new method refreshFilterToolbar This method only refresh the toolbar filter and does not use reload to reload data. It loads the values from filters parameter in postData
• Updated Italian translation
• Added option uniqueSearchFields (boolean – default false) in jqFilter respectively in searchGrid methods form searching which allow the searched field to appear only once in the search list. See demo
• Added search option searchOperMenu in colModel searchoptions property (valid only in filterToolbar method) which enable/disable the search operators menu for particular field in colModel. The option work with global searchOperator option
• Added event isHasSubGrid in grid parameters. To the event is passed the row id. If defined it is executed on every row before the subgrid is build. If the event return false the subgrid for that row is not builded. The plus icon disappear. See demo.
• searchTree method now return only the result founds with its parents
• Added sortable plugin not depended on jQuery UI lib.
• Added grid option colMenu which if set to true will enable column menus on every grid colum header with different actions. Added visual representation of colMenu for Bootstrap and jQuery UI. Added option colmenu in colModel to enable/disable the menu for particular column. The following actions are present in the menu – sorting, filtering, grouping, freeze, show/hide reorder columns. See demo.
• Add event parameter beforeExport in excelExport method to modify/add parameters in the export url.
• Added options exporthidden and exportgrouping in excelExport (default false) for exporting colModel hidden property and grouping options. Useful in server side exporting like PHP ASP and etc
• Add parameter reverse in getNodeAncestor method which if set to true will return the nodes in natural order – i.e first root , then first child and etc
• Add parameter expanded in getNodeAncestor method which if set to true will return the nodes with expanded property set to true
• Added simple filterInput method which allow with single value to filter on all fields in the grid. Works only when datatype is local or loadonce parameter is set to true. See demo
• Added new parameter in getNodeChildren method – currentview to get (walk) nodes from current view or whole local data

Bug Fixes

• Fix padding in toolbar search inputs
• More precise calculation of totaltime – time to put the data in grid
• Fix sort and search in treegrid.

All new features are demonstrated using jQuery UI CSS, but they are available if a Bootstrap CSS framework is ised.

Enjoy!

Guriddo Team

Hello,

We are glad to announce the immediate availability of Guriddo jqGrid JS 5.1.0 This is a major release and includes a lot of new features and fixes:

Additions and Updates

• Add new event parameter in filterToolbar method – onClearSearchValue and corresponding jqGridToolbarClearVal. To this event are passed the following parameters: html element, column index, searchoptions, default value
• Added a options between. The option is valid only in filterToolbar method. To use this feature the values in search field should be separated with “…”. Example – to parse values between 1 and 10 the following should be entered: 1…10 in the search field. Click for demo here
• Added a possibility to use multi select in toolbar searching. Any multiselect plugin can be used.For this purpose a new parameter is added in filterToolbar method – groupOpSelect to determine the group operand when multi select is on Can be AND or OR. Default is AND. Click for demo here
• Update Japanese translation
• Added new method refreshFilterToolbar This method only refresh the toolbar filter and does not use reload to reload data. It loads the values from filters parameter in postData
• Updated Italian translation
• Added option uniqueSearchFields (boolean – default false) in jqFilter respectively in searchGrid methods form searching which allow the searched field to appear only once in the search list. Click for demo here
• Added search option searchOperMenu in colModel searchoptions property (valid only in filterToolbar method) which enable/disable the search operators menu for particular field in colModel. The option work with global searchOperator option
• Added event isHasSubGrid in grid parameters. To the event is passed the row id. If defined it is executed on every row before the subgrid is build. If the event return false the subgrid for that row is not builded. The plus icon disappear. Click for demo here
• searchTree method now return only the result founds with its parents. Click for demo here.
• Added sortable plugin not depended on jQuery UI lib.
• Added grid option colMenu which if set to true will enable column menus on every grid colum header with different actions. Added visual representation of colMenu for Bootstrap and jQuery UI. Added option colmenu in colModel to enable/disable the menu for particular column. The following actions are present in the menu – sorting, filtering, grouping, freeze, show/hide reorder columns. Click for demo here
• Add event parameter beforeExport in excelExport method to modify/add parameters in the export url.
• Added options exporthidden and exportgrouping in excelExport (default false) for exporting colModel hidden property and grouping options. Useful in server side exporting like PHP ASP and etc
• Add parameter reverse in getNodeAncestor method which if set to true will return the nodes in natural order – i.e first root , then first child and etc
• Add parameter expanded in getNodeAncestor method which if set to true will return the nodes with expanded property set to true
• Added simple filterInput method which allow with single value to filter on all fields in the grid. Works only when datatype is local. Click for demo here
• Added new parameter in getNodeChildren method – currentview to get (walk) nodes from current view or whole local data

Bug Fixes

• Fix padding in toolbar search inputs
• More precise calculation of totaltime – time to put the data in grid
• Fix sort and search in treegrid.

Enjoy
Your Guriddo Team