{"id":126134,"date":"2017-05-17T12:21:24","date_gmt":"2017-05-17T10:21:24","guid":{"rendered":"http:\/\/guriddo.net\/?p=126134"},"modified":"2017-05-17T12:21:24","modified_gmt":"2017-05-17T10:21:24","slug":"guriddo-suito-php-5-2-1-is-released","status":"publish","type":"post","link":"http:\/\/guriddo.net\/?p=126134","title":{"rendered":"Guriddo Suito PHP 5.2.1 is released"},"content":{"rendered":"<p>Hello,<\/p>\n<p>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:<\/p>\n<h2>PHP<\/h2>\n<h3>Additions and Changes<\/h3>\n<ul>\n<li>\n\t\t\t\t\tIn excel options added default format types as follow:<br \/>\n\t\t\t\t\t&#8220;format_int&#8221;=>&#8221;#0&#8221;, &#8220;format_num&#8221;=>&#8221;#.00&#8243;,&#8221;format_text&#8221;=>&#8221;@&#8221;, &#8220;format_date&#8221;=>&#8221;YYYY-MM-DD&#8221;<br \/>\n\t\t\t\t\twith this option the default types are formatted correct in excel.<br \/>\n\t\t\t\t\tTo overwrite the default excel formating the excel option can be set or to define a custom formatter<br \/>\n\t\t\t\t\tin excel use <b>excel_format<\/b> property in formatoptions like in the code below:<br \/>\n\t\t\t\t\t$grid->setColProperty(&#8216;myfield&#8217;, array(&#8220;formatoptions&#8221;=>array(&#8220;excel_format&#8221;=>&#8221;#.0&#8221;)));\n\t\t\t\t<\/li>\n<li>\n\t\t\t\t\tAdd <b>customwhere<\/b> element in tableconfig array where is possible to add a additional condition in getLeafNodes where clause for adjacency model\n\t\t\t\t<\/li>\n<li>\n\t\t\t\t\tAdded new public variable <b>summaryalias<\/b> (default true) &#8211; summary data is calculated using alias.<br \/>\n    if we have $sql then adding the needed summary fields to $s as SUM(a) AS a&#8230; , then we do<br \/>\n    SELECT COUNT(*) AS COUNTR &#8220;.$s.&#8221; FROM ($sql) gridalias.\n\t\t\t\t<\/li>\n<\/ul>\n<h3>Fixes<\/h3>\n<ul>\n<li>\n\t\t\t\t\tFix bug with summary fields\n\t\t\t\t<\/li>\n<li>\n\t\t\t\t\tFix pass by reference error in PHP 7\n\t\t\t\t<\/li>\n<li>\n\t\t\t\t\tFix _buildSearch() function for Cannot use string offset as an array.\n\t\t\t\t<\/li>\n<li>\n\t\t\t\t\tFix when formatter (select) parameter is true in setSelect we update formatoptions instead of editoptions\n\t\t\t\t<\/li>\n<li>\n\t\t\t\t\tDefault values parameter (defvals) in setSelect now is available in all modes &#8211; formatter, editing and searching\n\t\t\t\t<\/li>\n<\/ul>\n<h2>Java Script<\/h2>\n<h3>Addition and Updates<\/h3>\n<ul>\n<li>Add a showSaveCancelButtons() method in inline editiong to enable save and cancel buttons<\/li>\n<li>Add saveData parameter in saveState method, which enables\/disables saving the data. Default true.<\/li>\n<li>Add restoreData option in loadState method which enables\/disables restoring the saved data state. Default true.<\/li>\n<li>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<\/li>\n<li>Add onBeforeExport event in exportToExcel method<\/li>\n<li>Add parameter forceresize to resizeColumn methods<\/li>\n<li>Added triggred event jqGridBeforeProcessing which is equivalent of beforeProcessing<\/li>\n<li>Add triggered events jqGridLoadError = loadError and jqGridLoadBeforeSend = loadBeforeSend<\/li>\n<li>Add triggered event jqGridPaging = onPaging<\/li>\n<li>Remove global object jqGridUtils and add all the functions in $.jgrid object removing a need to have two global jqGrid objects.<\/li>\n<li>Exclude more attributes not needed to be add in input element in createEl function<\/li>\n<li>Add triggered event jqGridErrorCell = errorCell in cell editing<\/li>\n<li>Add new property in colModel <em>exportcol<\/em> which enables disables the export in the methods exportToPdf and ExportToExcel exportToCsv.<\/li>\n<li>Add saveui and savetext parameters to the editRow method<\/li>\n<li>Added missed triggered events in viewGridRow method see documentation<\/li>\n<li>Adding missed triggred evenents in delGridRow see documentation<\/li>\n<li>Added replaceStr event in exportToExcel parameters in order to control the formatting of the exported text.<\/li>\n<li>Add onSubmitCell event in cell edit<\/li>\n<li>Removing not used option delayOnLoad in subgrid<\/li>\n<li>Adding the missing triggered events in treeGrid<\/li>\n<li>Adding option multimail<\/li>\n<li>Adding count parameter to summaryTpl -&gt; {1}<\/li>\n<li>Add option scrollMaxBuffer to prevent memory problems when using virtual scrolling in local mode using the mouse wheel<\/li>\n<\/ul>\n<h3>Bug Fixes<\/h3>\n<ul>\n<li>Fix: small fixes according to eslint<\/li>\n<li>Fix: comparing with equal data types in getNodeParent<\/li>\n<li>Selector fixes the addJSONData and addXMLData<\/li>\n<li>Fix: Support autoencode grid option to prevent XSS in jqFilter<\/li>\n<li>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 <a href=\"https:\/\/github.com\/tonytomov\/jqGrid\/issues\/819\">here<\/a><\/li>\n<li>Fix: Unreadable content in MS Excel when open the generated excel file generated with exportToExcel method`<\/li>\n<li>Fix: saveAs function in exportToExcel to work correct in IE11 (Access denied error fix)<\/li>\n<li>Fix: set search option to false when we reset the seasrch in column menu<\/li>\n<li>Fix: fixes in normalizeData function to read correct the unique name.<\/li>\n<li>Fix setFrozenColumns when box-sizing=border-box is used.<\/li>\n<li>Fix: add beforeProcessing event to every datatype.<\/li>\n<li>Small fix in beforeRequest event. The triggered event and option event should be one after other.<\/li>\n<li>Fix according to the documentation if datatype is function beforeRequest does not fire<\/li>\n<li>Fix: More strict check in setColProp for the type object<\/li>\n<li>Fix jqgroup class to have same height as jqgrow class.<\/li>\n<li>Fix calling custom_element in search modules with the right html element.<\/li>\n<li>Fix delGridRow view modal dialogue in case first time beforeInitData return false.<\/li>\n<li>Fix: remove the parameter searchurl in filterToolbar it is never used<\/li>\n<li>Fix: get correct label from colNames instead of colModel.label in buildColMenu<\/li>\n<li>Fix: When exporting we should use the colNames and not colModel.label<\/li>\n<li>Fix remove bad set counter for service fields: row numbers and multiselect.<\/li>\n<li>Fix frozen columns when zooming.<\/li>\n<li>Fix calling triggered event jqGridAddEditAfterComplete in editGridRow.<\/li>\n<li>Fix add missed parameter postdata in jqGridAddEditBeforeCheckValues<\/li>\n<li>Fix setGroupHeader method in case it is called 2 or more times with colspan : true<\/li>\n<li>Fix export to excel allowing quotes in the values.<\/li>\n<li>Fix Bootstrap css dispearing icons<\/li>\n<li>Fix: colmenu search options operands replaced with groupOps common to all search modules<\/li>\n<li>Fix columnChooser &#8211; setting height causes selection list not to overflow correct.<\/li>\n<li>Fix sortable columns to perform sort when the column is sorted to its original position<\/li>\n<li>Fix reading data in case key colModel option is set and repeatitems in jsonReader is true.<\/li>\n<li>Fix passing parameters in editRow<\/li>\n<li>Fix stop function in sortablColumns method to be executed within delay<\/li>\n<li>Fix deselectAfterSort to not highlight the remaining rows<\/li>\n<li>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<\/li>\n<li>Fix exportToPdf to order correctly the columns in case some of them have a number as name<\/li>\n<li>Fix exportToCsv to order correct column names in header when they are numbers.<\/li>\n<li>Fix timeoffset in parseDate function.<\/li>\n<li>Fix it is possible to search when select has a multiple property in dialogue search<\/li>\n<li>Fix toggleToolbar method when frozenColumns are set<\/li>\n<li>Fix filterInput to use ! correct<\/li>\n<\/ul>\n<p>Kind Regards,<br \/>\nGuriddo Team<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0},"categories":[21,22,1],"tags":[],"_links":{"self":[{"href":"http:\/\/guriddo.net\/index.php?rest_route=\/wp\/v2\/posts\/126134"}],"collection":[{"href":"http:\/\/guriddo.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/guriddo.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/guriddo.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/guriddo.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=126134"}],"version-history":[{"count":3,"href":"http:\/\/guriddo.net\/index.php?rest_route=\/wp\/v2\/posts\/126134\/revisions"}],"predecessor-version":[{"id":126137,"href":"http:\/\/guriddo.net\/index.php?rest_route=\/wp\/v2\/posts\/126134\/revisions\/126137"}],"wp:attachment":[{"href":"http:\/\/guriddo.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=126134"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/guriddo.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=126134"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/guriddo.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=126134"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}