Home > jQuery > Guriddo Suito PHP 5.2.1 released

Guriddo Suito PHP 5.2.1 released


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:


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.

  • 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

  1. Pedro
    May 17th, 2017 at 19:01 | #1

    You might want to fix the typo on the topic’s subject to “Guriddo Suito PHP 5.2.1 released” instead of “Guriddo Suito PHP 5.1.1 released”.

  2. May 17th, 2017 at 19:50 | #2

    Thank you very much. Fixed.

  3. June 16th, 2017 at 06:35 | #3

    Thank you very much. Fixed.

  4. Vladimir
    July 5th, 2017 at 07:55 | #4

    methods ExportToExcel don’t work with jquery.jqGrid.min.js. But work with jquery.jqGrid.js ! This is bug!

  5. July 5th, 2017 at 10:24 | #5


    Which product do you mean? and which version?

    Best Regards

  6. Alexandr
    July 13th, 2017 at 06:15 | #6

    Demonstration example by grouping -> the total amount in the group.
    Counting the last group is not correct

  7. Alexandr
    July 13th, 2017 at 08:05 | #7
  8. July 13th, 2017 at 09:45 | #8


    Thank you for the note. Summary grouping when performed with local data loaded at once work this way. We display the total sum of the group and not the sum of the displayed items into the group. You can easy determine the right summary if you increase the number of visible records from 15 to 50 – note that in this case there is a only one page.

    Kind Regards,

  9. Yash
    July 20th, 2017 at 10:15 | #9

    Hello Support,

    I am using jqGrid JS – v5.2.1.

    And i have found that event “afterInsertRow” is not getting fired even though i have set gridview = true.

    Please help as soon as possible.

  10. July 20th, 2017 at 10:17 | #10


    Could you please send us your code to support at guriddo dot net

    Thank you

  11. July 20th, 2017 at 10:17 | #11



    Could you please send us your code to support at guriddo dot net

    Thank you

  12. Yash
    July 20th, 2017 at 12:18 | #12

    Hello Support,

    My JQgrid code is as below.

    data: revenuegridDataSource,
    datatype: “local”,
    height: ‘auto’,
    rowNum: 10000,
    //rowList: [10, 20, 30],
    colNames: [‘Invoice Id’, ‘InvoiceNo’, ‘Customer Name’, ‘InvoiceDate’, ‘SDM’, ‘From’, ‘To’, ‘Discount’, ‘Amount’, ‘Currency’, ‘Duration’, ‘Project Name’, ‘Recurring’, ‘Note’],//
    colModel: [

    { name: ‘InvoiceId’, width: 100, hidden: true, key: true },
    { name: ‘InvoiceNo’, width: 66 },
    { name: ‘Customer_Name’, width: 251 },
    { name: ‘InvoiceDate’, width: 80, sorttype: ‘date’, formatter: ‘date’, formatoptions: { newformat: ‘d M Y’ }, datefmt: ‘d-M-Y’ },
    { name: ‘SDM_Name’, width: 111 },
    { name: ‘From_Date’, width: 80, sorttype: ‘date’, formatter: ‘date’, formatoptions: { newformat: ‘d M Y’ }, datefmt: ‘d-M-Y’ },
    { name: ‘To_Date’, width: 80, sorttype: ‘date’, formatter: ‘date’, formatoptions: { newformat: ‘d M Y’ }, datefmt: ‘d-M-Y’ },
    { name: ‘Discount’, width: 65, formatter: ‘number’, align: ‘right’, sorttype: ‘number’ },
    { name: ‘Final_Amount’, width: 65, formatter: ‘number’, align: ‘right’, sorttype: ‘number’ },
    { name: ‘Currency’, width: 80 },
    { name: ‘Inv_Duration’, width: 80 },
    { name: ‘ProjectName’, width: 100 },
    { name: ‘Recurring’, width: 50 },
    { name: ‘Invoice_note’, width: 240 },
    //pager: ‘#pager’,
    //rownumbers: true,
    viewrecords: true,
    sortname: ‘name’,
    gridview: true,
    width: 1319,
    caption: “Search“,
    subGrid: true,
    afterInsertRow: function (rowid, rowdata, rawdata) {
    //emptyrecords: “No records found.”,
    subGridOptions: {
    plusicon: “ui-icon-plus”,
    minusicon: “ui-icon-minus”,
    openicon: “ui-icon-carat-1-sw”,
    expandOnLoad: false,
    selectOnExpand: false,
    reloadOnExpand: true
    subGridRowExpanded: function (subgrid_id, row_id) {
    if (row_id > 0) {
    var subgridfilterdata = [];
    var subgrid_table_id, pager_id; subgrid_table_id = subgrid_id + “_t”;
    pager_id = “p_” + subgrid_table_id;
    $(“#” + subgrid_id).html(“”);
    $(“#” + subgrid_table_id).jqGrid({
    datatype: “local”,
    colNames: [‘Developer Name’, ‘Manager Name’, ‘Technology’, ‘Efforts’, ‘Rate’, ‘Amount’, ‘Note’],
    colModel: [
    { name: ‘Developer_Name’, width: 250 },
    { name: ‘Manager_Name’, width: 250 },
    { name: ‘Technology’, width: 250 },
    { name: ‘Efforts’, width: 88, formatter: ‘int’, align: ‘right’, sorttype: ‘int’ },
    { name: ‘Rate’, width: 88, formatter: ‘number’, align: ‘right’, sorttype: ‘number’ },
    { name: ‘Amount’, width: 88, formatter: ‘number’, align: ‘right’, sorttype: ‘number’ },
    { name: ‘Developer_Note’, width: 250 },
    rowNum: 10000,
    //pager: pager_id,
    sortname: ‘Developer_Name’,
    sortorder: “asc”,
    height: ‘100%’,
    width: ‘1290’,
    viewrecords: true,
    //emptyrecords: ‘No records to display’,
    if (revenueSubgridDataSource != null) {
    $.grep(revenueSubgridDataSource, function (n, i) {
    if (n.ParentId == row_id) {
    if (subgridfilterdata.length > 0) {
    for (var i = 0; i <= subgridfilterdata.length; i++) {
    $("#" + subgrid_table_id).jqGrid('addRowData', i + 1, subgridfilterdata[i]);
    //$("#" + subgrid_table_id).setGridParam({ rowNum: 1000 }).trigger("reloadGrid");


    When I am executing this code my alert is not firing in event of “afterInsertRow”.

    Please review this code and help me as soon as possible.

    I am also attaching JQgrid.js which I am using into my project.

  13. July 20th, 2017 at 14:24 | #13

    Please check this demo here:

  14. July 20th, 2017 at 14:24 | #14
  15. September 20th, 2017 at 15:56 | #15

    Guriddo jqGrid Bootstrap Demo 

    Editing Dialog..

    Why Horizontal and Vertical Scrolls Are Created? at Chrome..

    It’s Uncomfortable

  1. No trackbacks yet.

Privacy Policy   Terms and Conditions   Contact Information