jQuery Grid Plugin – jqGrid

Hello All,

We are pleased to announce the release of Guriddo jqGrid JavaScript 5.3.2. 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.

Additions and Updates

• Added option preserveSelection which allow to preserve selected rows in multiselect mode.
• Support for searchOperators im refreshToolBar method
• Add option editNextRowCell to continued editing of cells when Tab/shift Tab is pressed and the end of row is reached. The option works only when cell editing is enabled.
• Add tooltip property in colModel to set different title in headers. See: https://github.com/tonytomov/jqGrid/issues/909
• Add second parameter rowPos (last inserted row index) in onBeforeExport event in exportToExcel method
• Selection preserver (scroll 1 or true) works now in multiselect mode
• Add onInitPivot and onCompletePivot events to indicate the start and end process of building the pivot.
• Added option loadMsg in pivot options parameters which enables a loading message during pivot build. Default is true

Bug Fixes

• Fix rounding numbers in certain situations. See https://github.com/tonytomov/jqGrid/issues/905
• Fix *cellattr* event to omit strings which contain style word
• Fix subgrid option expandOnLoad when multiselect and/or rownumbers true. See https://github.com/tonytomov/jqGrid/issues/892
• Fix position of multiselect box on bootstrap 4
• Fix border of toppager (when enabled) when bootstrap 4
• Fix positioning of column menu.
• Fix conversion the value to number in case a octal values is present in search toolbar
• Fix exporting hidden columns in all export modules. We set a property exportcol which will then overwrite dynamically set hidden column
• Fix setGridWidth method in case grid overflow-y is set to scroll.
• Fix bindKey method to select a row only if it is jqgrid row and when there is a id.
• Fix multiselect in toolbar search filtering
• Fix position of column menu according to the new changes connected with the styling. See here: https://github.com/tonytomov/jqGrid/issues/913
• Fix subgrid to read correct data using getAccessor in case mapping is set in subGridModel and there is a complex data
• Fix bindKey to prevent focus in inputs in case of inline edit is activated.
• Fix passing the right parameter to reader function in JSONReder in order to overcome wrong detecting of keyName. See: https://github.com/tonytomov/jqGrid/issues/918
• Fix resetting the selected row(s) in selection preserver to keep the selection active over all the scroll time
• Fix bootstrap pixel problem in case height is set to auto or 100%
• Prevent bad position of column menu when it is activated and user scroll horizontally https://github.com/tonytomov/jqGrid/issues/920

Sincerely Yours,
Guriddo Team

We are pleased to announce the release of Guriddo jqGrid JavaScript 5.3.1. This is a bug fix release with improved support of Bootstrap 4 and adding Font Awesome support.

Below is the list of the additions and fixes:

Addition and Updates

• Bootstrap 4 improvements. Updated demo
• Support for Font Awesome when Bootstrap 4
• Add new option useNameForSearch to search by name on local data and not on index when set.

Bug fixes

• Do not include subgrid and other internal columns in addlocaldata for manipulating
• Removing badly added grouping == true when set frozen columns.
• Fix in addXmlData to add empty string in case CDATA (when set) does not contain data.
• Fix grouping when grouSummaryPos = header and there are hidden fields at beginning of colModel. Small optimization in buildSummaryTd.
• Fix excluding subgrid column in exportToHtml
• Fix exportToHtml to get the labels of header from colNames
• Fix apperaing print preview dialog in Chrome (method exportToHtml)
• Fix Drag and drop rows (gridDnD method) when drop by name is false.
• Fix loadState method when a subgrid has open subgrids as grids
• Fix all exporting methods when grouping is enabled
• Fix vertical scroolbar for bootstrap 4
• Fix setAttributes function in CreateEl to be called as last one when a editable element is created, so that the developer can overwrite the defaults.
• Fix subgrid with parent as altRows set for Bootstrap 4

The documentation is up to date.

Enjoy the new version.

Kind Regards
Guriddo Team

Hello,

We are happy to introduce the new release of Guriddo Suito PHP version 5.3.
This version is a major release and add a support of Bootstrap 4, local export to HTML with print options, Tree Grid paging, menu bar and much more.

For a full list of additions and fixes read the text below:

Additions and Updates

• Add JavaScript serailizeSubGridData event to the setSubGridGrid in order to extend the parameters. It can be defined as grid event.
• Add mapping parameter to subgrid (setSubgrid method) in order to display a labels in the simple sub-grid
  public function setSubGrid ($suburl=”, $subnames=false, $subwidth=false, $subalign=false, $subparams=false, $mapping=false)
• Add Support for Bootstrap 4. Demo
• Support validation in filterToolbar via searchrules
• Adding parameter errorcheck to enable/disable the validation of the search inputs in the toolbar searching
• Update Stronger check for number in case of strict mode prevent entering a octal values when local searching.
• Adding jqGridInitGrid triggered event, which can replace initGrid event
• Add exportToHtml method with ability to print. Demo
• Extend excel export to recognize more numeric types. Support for ISO date only at the moment
• Add 3 parameter returnobject in getCell method which set to true return the cell as jQuery object
• Add menubar on caption layer. Added new option menubar which place a icon on left (or right) and the user can add actions. Added two new methods for this purpose menubarAdd and menubarDelete to add and delete items. Demo
• Added new options in colModel – minResizeWidth, which defines minimal re-sizing width per column. When set this option have higher priority of minColWidth
• Add possibility to define user defined buttons in editGridRow, delGridRow and viewGridRow forms. Demo
• Add $.jgrid.buildButtons function in common module to return a string with a buttons defined in buttons array in the different modules.
• Add support for html5 in form edit Demo
• Add a treeGrid paging based on the code of Vyacheslav N. Boyko See here. For more information documentation information. Demo
• Add buttons array in order allow to add custom buttons in the searchGrid form. The button item object contain the following properties – side, position, text, icon, click, id. To the click function is passed the search form, search parameters and click event. See here. Demo
• Remove z-index from jqgrid-overlay class and add jqgrid-overlay-modal class to serve separate modals.
• Add possibility to create the search dialog as first child of body setting the layer option to true.
• Add event colMenuColumnDone as grid options which executes on reordering of the columns when colMenu columns options is on – the event is similar to in columnChooser.
• Adding onEnter and onEscape events in editRow in order to get possibility for custom save cancel code – by example pop-up to ask for saving and etc. Demo
• Enlarge mousedown area in jqModal in case some other components like datepicker are outside the modal dialog. Added two new parameters heightOffset and widthOffset.
• In inline saveRow method the deletion of the saved row is moved after aftersavefunc so that this row can be available for comparing
• In method gridDnD droppable now applied to table’s closest ui-jqgrid-bdiv for greater drop area Added “tolerance” setting to default drop_opts
• Add parameter previous selected rowid in bindkeys onUpKey and onDownKey events
• Add onUpKey and onDownKey check events in bindKeys method. Also to all events is added second parameter the event
• Add custom column menu. This is done via the two new methods colMenuAdd to add a new column menu and colMenuDelete to delete it. More can be found in the methods list Demo
• Add two additional parameters to summaryTpl in colModel for grouping – the name of the summary field and the value of the summary field – respectively the can be added as {2} and {3} in the template.
• Added isExported and exporttype in the formatter options in colModel when local export to pdf, csv or excel occur. This allow to conditionally format the value depending if it is exported.
• Update Spain translation
• Return empty pivot grid when no data, rather than to expose a exception
• Update Portuguese translation

Bug Fixes

• Fix in “in” search clause to support more than one item when search with items separated with comma
• Fix parsing dates in grid utils
• Fix preg_replace_callback in utils to work in PHP 5.x
• Fix for saveState not to save the data when saveData is on and datatype is local.
• Fix creating the ids of the grid with the build in generator randId in case local data and scroll is on (virtual scrolling)
• Fix building the id row when a add operation in method editGridRow. The comparing of the empty row missed the idPreffix
• Fix column menu in case the searchbox and cols menu are outside the view port
• Fix setCell to get right row unformatted data. If the datatype is local no unformat function is needed
• Fix setCell to find the right cell in case the cell contain another table data.
• Fix correct dropping row in gridDnD when both grids have equal colModel’s and dropbyname parameter is false
• Fix exportcol property in exportToCsv, exportToExcel, exportToPdf methods when hidden is false, but exportcol is true
• Fix exportToCsv, exportToExcel, exportToPdf methods to export all the data when datatype is local
• Fix for csv export summary data to skip not exported column. Fix export to excel to skip the same column
• Fix typo “inine-block” in ui.jqgrid.css
• Fix exportTo excel to interpret virtual values not as part of the data array
• Fix remove not needed comma from jqGridFilter parameters
• Fix grid width in bootstrap in different situations when shrinkToFit changes. Calculation of width methods is now synchronized. Fixed small issues when autowidth is on and responsive is on too
• Fix add missed parameter in editCell – the event, which is used in onCellSelect
• Fix previous navigator button in viewGridRow method to work correct. See
• Fix for minColWidth
• Fix Albanian translation to get the right two code See
• Fix checkOnUpdate in Chrome [See] (https://github.com/tonytomov/jqGrid/issues/881)
• Fix when subgrid and grouping are on again with loadonce true thanks to preethi koochana
• Fix jqFilter getParameter method.
• Fix loadui grid parameter when set to block
• Create separate modal overlay in viewMoodal and hide it in hideModal. Fix viewModal to get the overlay class depending on style.
• Fix for viewModal parameters when called in searchGrid method. The id of entire grid box was wrong set
• Fix height of the frozen div.
• Fix inconsistent state if saveAfterSelect is true but method saveRow fails
• Fix when styleUI is Bootstrap and altRows is on
• Fix typo when calling onCellSelect grid event
• Fix removing not needed href=’#/’ when build column menu
• Fix bindKeys method to work when grid drag and drop method gridDnD method is activated
• Fix exportToExcel when the number length is > 15 (know problem in Microsoft Excel)
• Fix resting grouping values when clearGroupData is called
• Fix determine the vertical scroll-bar dynamically and fix the issue when Bootstrap in Windows
• Fix for showSummaryOnHide when grouping is enabled
• Fix in JSON.parse in utility module to parse correct all cases when function is available.
• Fix multisorting issues.
• Fix bug with big select element in modal dialog
• Fix celledit to support subgrid and any additional rows content added during editing
• Fix width of column when exportToExcel and the data is number.

Enjoy the new version.
Trirand Team

Hello,

We are glad to announce the new release of Guriddo jqGrid JavaScript version 5.3.0.
This version is a major release and add a support of Bootstrap 4, export to HTM with print options, Tree Grid paging, menu bar and much more.

For a full list of additions and fixes look below:

Additions and Updates

• Add Support for Bootstrap 4. Demo
• Add support for sortable columns and frozen columns to work in sync
• Support validation in filterToolbar via searchrules
• Adding parameter errorcheck to enable/disable the validation of the search inputs in the toolbar searching
• Update Stronger check for number in case of strict mode prevent entering a octal values when local searching.
• Adding jqGridInitGrid triggered event, which can replace initGrid event
• Add exportToHtml method with ability to print. Demo
• Extend excel export to recognize more numeric types. Support for ISO date only at the moment
• Add 3 parameter returnobject in getCell method which set to true return the cell as jQuery object
• Add menubar on caption layer. Added new option menubar which place a icon on left (or right) and the user can add actions. Added two new methods for this purpose menubarAdd and menubarDelete to add and delete items. Demo
• Added new options in colModel – minResizeWidth, which defines minimal re-sizing width per column. When set this option have higher priority of minColWidth
• Add possibility to define user defined buttons in editGridRow, delGridRow and viewGridRow forms. Demo
• Add $.jgrid.buildButtons function in common module to return a string with a buttons defined in buttons array in the different modules.
• Add support for html5 in form edit Demo
• Add a treeGrid paging based on the code of Vyacheslav N. Boyko See here. For more information documentation information. Demo
• Add buttons array in order allow to add custom buttons in the searchGrid form. The button item object contain the following properties – side, position, text, icon, click, id. To the click function is passed the search form, search parameters and click event. See here. Demo
• Remove z-index from jqgrid-overlay class and add jqgrid-overlay-modal class to serve separate modals.
• Add possibility to create the search dialog as first child of body setting the layer option to true.
• Add event colMenuColumnDone as grid options which executes on reordering of the columns when colMenu columns options is on – the event is similar to in columnChooser.
• Adding onEnter and onEscape events in editRow in order to get possibility for custom save cancel code – by example pop-up to ask for saving and etc. Demo
• Enlarge mousedown area in jqModal in case some other components like datepicker are outside the modal dialog. Added two new parameters heightOffset and widthOffset.
• In inline saveRow method the deletion of the saved row is moved after aftersavefunc so that this row can be available for comparing
• In method gridDnD droppable now applied to table’s closest ui-jqgrid-bdiv for greater drop area Added “tolerance” setting to default drop_opts
• Add parameter previous selected rowid in bindkeys onUpKey and onDownKey events
• Add onUpKey and onDownKey check events in bindKeys method. Also to all events is added second parameter the event
• Add custom column menu. This is done via the two new methods colMenuAdd to add a new column menu and colMenuDelete to delete it. More can be found in the methods list Demo
• Add two additional parameters to summaryTpl in colModel for grouping – the name of the summary field and the value of the summary field – respectively the can be added as {2} and {3} in the template Demo
• Added isExported and exporttype in the formatter options in colModel when export to pdf, csv or excel occur. This allow to conditionally format the value depending if it is exported. Demo
• Update Spain translation
• Return empty pivot grid when no data, rather than to expose a exception
• Update Portuguese translation

Bug Fixes

• Fix for saveState not to save the data when saveData is on and datatype is local.
• Fix creating the ids of the grid with the build in generator randId in case local data and scroll is on (virtual scrolling)
• Fix building the id row when a add operation in method editGridRow. The comparing of the empty row missed the idPreffix
• Fix column menu in case the searchbox and cols menu are outside the view port
• Fix setCell to get right row unformatted data. If the datatype is local no unformat function is needed
• Fix setCell to find the right cell in case the cell contain another table data.
• Fix correct dropping row in gridDnD when both grids have equal colModel’s and dropbyname parameter is false
• Fix exportcol property in exportToCsv, exportToExcel, exportToPdf methods when hidden is false, but exportcol is true
• Fix exportToCsv, exportToExcel, exportToPdf methods to export all the data when datatype is local
• Fix for csv export summary data to skip not exported column. Fix export to excel to skip the same column
• Fix typo “inine-block” in ui.jqgrid.css
• Fix exportTo excel to interpret virtual values not as part of the data array
• Fix remove not needed comma from jqGridFilter parameters
• Fix grid width in bootstrap in different situations when shrinkToFit changes. Calculation of width methods is now synchronized. Fixed small issues when autowidth is on and responsive is on too
• Fix add missed parameter in editCell – the event, which is used in onCellSelect
• Fix previous navigator button in viewGridRow method to work correct. See
• Fix for minColWidth
• Fix Albanian translation to get the right two code See
• Fix checkOnUpdate in Chrome [See] (https://github.com/tonytomov/jqGrid/issues/881)
• Fix when subgrid and grouping are on again with loadonce true thanks to preethi koochana
• Fix jqFilter getParameter method.
• Fix loadui grid parameter when set to block
• Create separate modal overlay in viewMoodal and hide it in hideModal. Fix viewModal to get the overlay class depending on style.
• Fix for viewModal parameters when called in searchGrid method. The id of entire grid box was wrong set
• Fix height of the frozen div.
• Fix inconsistent state if saveAfterSelect is true but method saveRow fails
• Fix when styleUI is Bootstrap and altRows is on
• Fix typo when calling onCellSelect grid event
• Fix removing not needed href=’#/’ when build column menu
• Fix bindKeys method to work when grid drag and drop method gridDnD method is activated
• Fix exportToExcel when the number length is > 15 (know problem in Microsoft Excel)
• Fix resting grouping values when clearGroupData is called
• Fix determine the vertical scroll-bar dynamically and fix the issue when Bootstrap in Windows
• Fix for showSummaryOnHide when grouping is enabled
• Fix in JSON.parse in utility module to parse correct all cases when function is available.
• Fix multisorting issues.
• Fix bug with big select element in modal dialog
• Fix celledit to support subgrid and any additional rows content added during editing
• Fix width of column when exportToExcel and the data is number.

Enjoy the new version.
Trirand Team

Hello,

We are glad to announce the availability of our Suito PHP 5.2.1 release. This version is a bug fix release, but contain very useful additions. Below is a list of the additions and changes:

PHP

Additions and Changes

• In excel options added default format types as follow:
  “format_int”=>”#0”, “format_num”=>”#.00″,”format_text”=>”@”, “format_date”=>”YYYY-MM-DD”
  with this option the default types are formatted correct in excel.
  To overwrite the default excel formating the excel option can be set or to define a custom formatter
  in excel use excel_format property in formatoptions like in the code below:
  $grid->setColProperty(‘myfield’, array(“formatoptions”=>array(“excel_format”=>”#.0”)));
• Add customwhere element in tableconfig array where is possible to add a additional condition in getLeafNodes where clause for adjacency model
• Added new public variable summaryalias (default true) – summary data is calculated using alias.
  if we have $sql then adding the needed summary fields to $s as SUM(a) AS a… , then we do
  SELECT COUNT(*) AS COUNTR “.$s.” FROM ($sql) gridalias.

Fixes

• Fix bug with summary fields
• Fix pass by reference error in PHP 7
• Fix _buildSearch() function for Cannot use string offset as an array.
• Fix when formatter (select) parameter is true in setSelect we update formatoptions instead of editoptions
• Default values parameter (defvals) in setSelect now is available in all modes – formatter, editing and searching

Java Script

Addition and Updates

• Add a showSaveCancelButtons() method in inline editiong to enable save and cancel buttons
• Add saveData parameter in saveState method, which enables/disables saving the data. Default true.
• Add restoreData option in loadState method which enables/disables restoring the saved data state. Default true.
• Removed a grid option altclass. Added definition for striped table in the styleUI object. The striped table is now build (option altRows : true) only when add a class to the main table. This add a speed improvements when loading the data. Removed the not needed code in delRowData and addRowdata
• Add onBeforeExport event in exportToExcel method
• Add parameter forceresize to resizeColumn methods
• Added triggred event jqGridBeforeProcessing which is equivalent of beforeProcessing
• Add triggered events jqGridLoadError = loadError and jqGridLoadBeforeSend = loadBeforeSend
• Add triggered event jqGridPaging = onPaging
• Remove global object jqGridUtils and add all the functions in $.jgrid object removing a need to have two global jqGrid objects.
• Exclude more attributes not needed to be add in input element in createEl function
• Add triggered event jqGridErrorCell = errorCell in cell editing
• Add new property in colModel exportcol which enables disables the export in the methods exportToPdf and ExportToExcel exportToCsv.
• Add saveui and savetext parameters to the editRow method
• Added missed triggered events in viewGridRow method see documentation
• Adding missed triggred evenents in delGridRow see documentation
• Added replaceStr event in exportToExcel parameters in order to control the formatting of the exported text.
• Add onSubmitCell event in cell edit
• Removing not used option delayOnLoad in subgrid
• Adding the missing triggered events in treeGrid
• Adding option multimail
• Adding count parameter to summaryTpl -> {1}
• Add option scrollMaxBuffer to prevent memory problems when using virtual scrolling in local mode using the mouse wheel

Bug Fixes

• Fix: small fixes according to eslint
• Fix: comparing with equal data types in getNodeParent
• Selector fixes the addJSONData and addXMLData
• Fix: Support autoencode grid option to prevent XSS in jqFilter
• Fix restoreRow to restore all the data saved into the savedRow array and not only the editable. This fixes calling of depended formatter custom function. See here
• Fix: Unreadable content in MS Excel when open the generated excel file generated with exportToExcel method`
• Fix: saveAs function in exportToExcel to work correct in IE11 (Access denied error fix)
• Fix: set search option to false when we reset the seasrch in column menu
• Fix: fixes in normalizeData function to read correct the unique name.
• Fix setFrozenColumns when box-sizing=border-box is used.
• Fix: add beforeProcessing event to every datatype.
• Small fix in beforeRequest event. The triggered event and option event should be one after other.
• Fix according to the documentation if datatype is function beforeRequest does not fire
• Fix: More strict check in setColProp for the type object
• Fix jqgroup class to have same height as jqgrow class.
• Fix calling custom_element in search modules with the right html element.
• Fix delGridRow view modal dialogue in case first time beforeInitData return false.
• Fix: remove the parameter searchurl in filterToolbar it is never used
• Fix: get correct label from colNames instead of colModel.label in buildColMenu
• Fix: When exporting we should use the colNames and not colModel.label
• Fix remove bad set counter for service fields: row numbers and multiselect.
• Fix frozen columns when zooming.
• Fix calling triggered event jqGridAddEditAfterComplete in editGridRow.
• Fix add missed parameter postdata in jqGridAddEditBeforeCheckValues
• Fix setGroupHeader method in case it is called 2 or more times with colspan : true
• Fix export to excel allowing quotes in the values.
• Fix Bootstrap css dispearing icons
• Fix: colmenu search options operands replaced with groupOps common to all search modules
• Fix columnChooser – setting height causes selection list not to overflow correct.
• Fix sortable columns to perform sort when the column is sorted to its original position
• Fix reading data in case key colModel option is set and repeatitems in jsonReader is true.
• Fix passing parameters in editRow
• Fix stop function in sortablColumns method to be executed within delay
• Fix deselectAfterSort to not highlight the remaining rows
• Fix exportToExcel method to order properly the columns. The bug originally come for the reason that object properties are ordered and do not follow natural insert order
• Fix exportToPdf to order correctly the columns in case some of them have a number as name
• Fix exportToCsv to order correct column names in header when they are numbers.
• Fix timeoffset in parseDate function.
• Fix it is possible to search when select has a multiple property in dialogue search
• Fix toggleToolbar method when frozenColumns are set
• Fix filterInput to use ! correct

Kind Regards,
Guriddo Team