jQuery Grid Plugin – jqGrid

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