Guriddo » guriddo.support's Replies

guriddo.support

Guriddo

Forum Replies Created

Viewing 15 replies - 271 through 285 (of 1,092 total)

← 1 2 3 … 18 19 20 … 71 72 73 →

Author

Replies

January 28, 2019 at 11:35 pm in reply to: Export to Excel Rounding Values Again #127062

guriddo.support

Participant

Hello,

Since this is urgently you can make quick fix if you set excelParser to empty array.

After loading the jqGrid file do

....
$.jgrid.excelParsers = [];
...

....

$.jgrid.excelParsers = [];

...

Kind Regards
Will

Guriddo Support Team

January 28, 2019 at 12:52 pm in reply to: inline editing with Boolean objects #127059

guriddo.support

Participant

Hello,

If you use custom formatter, then maybe you may need to use a unformat function too. See the docs here

Kind Regards,

Will

Guriddo Support Team

January 25, 2019 at 11:48 am in reply to: inline add #127057

guriddo.support

Participant

Hello,

Direct no, but you can use footerrow to place with custom code the input elements and prepare a button for saving the data

Hint: You can easy add any content in footer row using the footerData method with set parameter and the third parameter (format) set to false.

Eaxmple.

To set a input element in footer field ProductName do

$(&quot;#jqGrid&quot;).jqGrid({
...
footerrow: true,
userDataOnFooter: false
...
});

$(&quot;#jqGrid&quot;).jqGrid(&#039;footerData&#039;, &#039;set&#039;, {ProductName : &quot;&lt;input type=&#039;text&#039; id=&#039;myid&#039; size=&#039;3&#039; style=&#039;width:90%&#039;/&gt;&quot; }, false);

$("#jqGrid").jqGrid({

...

footerrow: true,

userDataOnFooter: false

...

});

$("#jqGrid").jqGrid('footerData', 'set', {ProductName : "<input type='text' id='myid' size='3' style='width:90%'/>" }, false);

Kind Regards,
Will

Guriddo Support Team

January 25, 2019 at 11:30 am in reply to: paging/infinite scroll #127056

guriddo.support

Participant

Hello,

Unfortunately it is very difficult to make this. When click on next page it is ok, but the problem will be with the previous page clicking.

Anyway we will look into this and see if we can do something.

Kind Regards,
WIll

Guriddo Support Team

January 23, 2019 at 9:15 am in reply to: Export to Excel Rounding Values Again #127053

guriddo.support

Participant

Hello,

Thanks. We noticed this bug and we work on it fixing. We will notify you when we are ready with this.

Kind Regards,
Will

Guriddo Support Team

January 22, 2019 at 12:44 pm in reply to: Dropdown with filter #127048

guriddo.support

Participant

Hello,

As far as I understand the problem you can use dataUrl option as function. In this case you can get the value from the other cell and pass it as parameter to the datUrl.

Here is a demo of this

Look at file detail.php. The related code is like this:


$select = &lt;&lt;&lt;SELECT
function(rowid, value, name) {
	var srow = jQuery(&quot;#grid&quot;).jqGrid(&#039;getGridParam&#039;,&#039;selrow&#039;);
	if(srow) {
                // get the row data based on the selected id
		var gridrow = jQuery(&quot;#grid&quot;).jqGrid(&#039;getRowData&#039;,srow);
                // pas it to the url
 		return &quot;select.php?id_emp=&quot;+gridrow.EmployeeID;
	}
}
SELECT;
$grid-&gt;setColProperty(&quot;EmployeeID&quot;,array(&quot;edittype&quot;=&gt;&quot;select&quot;, &quot;hidden&quot;=&gt;false,&quot;width&quot;=&gt;20,&quot;editoptions&quot;=&gt;array(&quot;dataUrl&quot;=&gt;&quot;js:&quot;.$select)));

$select = <<<SELECT

function(rowid, value, name) {

var srow = jQuery("#grid").jqGrid('getGridParam','selrow');

if(srow) {

// get the row data based on the selected id

var gridrow = jQuery("#grid").jqGrid('getRowData',srow);

// pas it to the url

return "select.php?id_emp="+gridrow.EmployeeID;

}

SELECT;

$grid->setColProperty("EmployeeID",array("edittype"=>"select", "hidden"=>false,"width"=>20,"editoptions"=>array("dataUrl"=>"js:".$select)));

The select.php look like this:

require_once &#039;../../jq-config.php&#039;;
// include the jqGrid Class
require_once ABSPATH.&quot;php/PHPSuito/jqGridUtils.php&quot;;
// include the driver class
require_once ABSPATH.&quot;php/PHPSuito/DBdrivers/jqGridPdo.php&quot;;
// Connection to the server
$conn = new PDO(DB_DSN,DB_USER,DB_PASSWORD);
// Tell the db that we use utf-8
jqGridDB::query($conn,&quot;SET NAMES utf8&quot;);
$empid = jqGridUtils::GetParam(&#039;id_emp&#039;);

// Get details
$SQL = &quot;SELECT * FROM employees WHERE EmployeeID &lt;=&quot;.(int)$empid;
$qres = jqGridDB::query($conn, $SQL);
// $result = jqGridDB::fetch_assoc($qres,$conn);
$s = &quot;&lt;select&gt;&quot;;
while($result = jqGridDB::fetch_assoc($qres,$conn) ) {
	$s .= &quot;&lt;option&gt;&quot;.$result[&#039;FirstName&#039;].&quot; &quot;.$result[&#039;LastName&#039;].&#039;&lt;/option&gt;&#039;;
}
$s .= &quot;&lt;/select&gt;&quot;;
echo $s;
jqGridDB::closeCursor($qres);

require_once '../../jq-config.php';

// include the jqGrid Class

require_once ABSPATH."php/PHPSuito/jqGridUtils.php";

// include the driver class

require_once ABSPATH."php/PHPSuito/DBdrivers/jqGridPdo.php";

// Connection to the server

$conn = new PDO(DB_DSN,DB_USER,DB_PASSWORD);

// Tell the db that we use utf-8

jqGridDB::query($conn,"SET NAMES utf8");

$empid = jqGridUtils::GetParam('id_emp');

// Get details

$SQL = "SELECT * FROM employees WHERE EmployeeID <=".(int)$empid;

$qres = jqGridDB::query($conn, $SQL);

// $result = jqGridDB::fetch_assoc($qres,$conn);

$s = "<select>";

while($result = jqGridDB::fetch_assoc($qres,$conn) ) {

$s .= "<option>".$result['FirstName']." ".$result['LastName'].'</option>';

}

$s .= "</select>";

echo $s;

jqGridDB::closeCursor($qres);

Please let us know if this solves your problem.

Kind Regards,
Will

This reply was modified 7 years, 3 months ago by guriddo.support.

Guriddo Support Team

January 15, 2019 at 10:56 am in reply to: inline editing with Boolean objects #127045

guriddo.support

Participant

Hello,

What you mean with “But it is passing default value of Boolean type(in Java) …”

I’m not sure that I understand the question. You set Yes/No value for bollean and this values is end to the server. Did you mean true/false?

Can you please be a more detailed?

Thank you

Kind Regards,

Will

Guriddo Support Team

January 11, 2019 at 11:42 am in reply to: Export to excel and others #127040

guriddo.support

Participant

Hello,

Thank you very much for the valued recommendations.

– Indicators (loading box) for all exports will be prepared for the next release

– In the current release the Dollar sign is hardcoded and it is not so easy to change. Custom formatting strings for excel export will be implemented in the next release too.

– About editing cells. If you do not know when the value in cell editing is changed we add a class dirty-cell. You can use this class to indicate that the value in cell is changed. This is described here

Usually we user this definition

	.dirty-cell {
		position: relative;
	}
	.dirty-cell:after {
		content: &quot;&quot;;
		position: absolute;
		top: 0;
		right: 0;
		width: 0; 
		height: 0; 
		display: block;
		border-left: 7px solid transparent;
		border-bottom: 7px solid transparent;
		border-top: 7px solid #f00;
	}

.dirty-cell {

position: relative;

}

.dirty-cell:after {

content: "";

position: absolute;

top: 0;

right: 0;

width: 0;

height: 0;

display: block;

border-left: 7px solid transparent;

border-bottom: 7px solid transparent;

border-top: 7px solid #f00;

}

which adds a red triangle in the upper right corner.

– We will try to make this autofilter for the next release.

I all cases we will let you know when some things are done, so that you can see if they meet your requierments.

Thank you very much

Kind REgards
Will

Guriddo Support Team

December 21, 2018 at 9:01 pm in reply to: Pager Not Properly Centered on Grid #127038

guriddo.support

Participant

Hello,

autowidth should not do any problem.

For me the problem my be in this code:

gridComplete : function() {
   if ($(&quot;#reportTable&quot;).jqGrid(&#039;getGridParam&#039;, &#039;datatype&#039;) == &quot;json&quot;) {
      $(&quot;#reportTable&quot;).setGridParam({datatype : &#039;local });
      maximizeTable();
      $(window).trigger(&#039;resize);
    }
},

gridComplete : function() {

if ($("#reportTable").jqGrid('getGridParam', 'datatype') == "json") {

$("#reportTable").setGridParam({datatype : 'local });

maximizeTable();

$(window).trigger('resize);

}

the first if


   if ($(&quot;#reportTable&quot;).jqGrid(&#039;getGridParam&#039;, &#039;datatype&#039;) == &quot;json&quot;) {
      $(&quot;#reportTable&quot;).setGridParam({datatype : &#039;local });

if ($("#reportTable").jqGrid('getGridParam', 'datatype') == "json") {

$("#reportTable").setGridParam({datatype : 'local });

is equivalent to:

loadonce : true

in grid settings.

My question is what do maximizeTable() and why do you resize the grid
Can you please revise what this function do? If you remove these two lines of code

      maximizeTable();
      $(window).trigger(&#039;resize);

1 2	maximizeTable(); $(window).trigger('resize);

does the problem exist?

Kind Regards,
Will

Guriddo Support Team

December 21, 2018 at 10:35 am in reply to: Pager Not Properly Centered on Grid #127035

guriddo.support

Participant

Hello,

It is very strange that the grid break the html content with grouping and it work fine without grouping – this is the reason that I have look deeper in your grouping settings and it seems you have incorrect written open and a close tag for the bold command here:

<b>{fraudCount}<b>

I think the problem is in this line:

...
groupText : [ &quot;Issuer Pcr: &lt;b&gt;{0}&lt;/b&gt; Fraud Total: &lt;b&gt;{fraudCount}&lt;b&gt;&quot;, &quot;Issuer Bin: &lt;b&gt;{0}&lt;/b&gt;&quot; ]
...

...

groupText : [ "Issuer Pcr: <b>{0}</b> Fraud Total: <b>{fraudCount}<b>", "Issuer Bin: <b>{0}</b>" ]

...

fix it with the following

...
groupText : [ &quot;Issuer Pcr: &lt;b&gt;{0}&lt;/b&gt; Fraud Total: &lt;b&gt;{fraudCount}&lt;/b&gt;&quot;, &quot;Issuer Bin: &lt;b&gt;{0}&lt;/b&gt;&quot; ]
...

...

groupText : [ "Issuer Pcr: <b>{0}</b> Fraud Total: <b>{fraudCount}</b>", "Issuer Bin: <b>{0}</b>" ]

...

and let us know if this fixes the problem

Kind Regards,
Will

This reply was modified 7 years, 4 months ago by guriddo.support.

Guriddo Support Team

December 21, 2018 at 10:30 am in reply to: Export Excel Null Date Become 1970-01-01 #127034

guriddo.support

Participant

Hello,

Actually this is a good recommendation. We have fixed the problem adding new option in the excel settings. Please write to support e-mail in order to send you a fix and instructions.

Kind Regards,

Will

Guriddo Support Team

December 10, 2018 at 10:19 am in reply to: Regarding Accessibility feature in JQGrid #127024

guriddo.support

Participant

Hello Meenakshi,

We hope to be ready with the beta at end of February 2019. I all cases we will let you know, since we need your opinion, experience and testing. I hope you will participate on this.

Kind Regards,

Will

Guriddo Support Team

December 7, 2018 at 11:35 am in reply to: Filter the editable value before submit to server #127014

guriddo.support

Participant

Hello,

There is a such event(s)

Depending on the editing module used you can use

serializeCellData – the event is defined as grid option for cell editing module

serializeRowData – the event is passed as param in editRow, saveRow function for inline editing

serializeEditData – the event is passed in navigator edit/add options , editRowdata method for form editing module

To all events is passes the data parameter, which is object wioth the posted data. You can analyze the fields and should return the object Example:

serializeEditData : function(data) {
    if(data.myfield === &quot;&quot;) {
        data.myfield = &#039;null&#039;;
    }
    return data;
}

serializeEditData : function(data) {

if(data.myfield === "") {

data.myfield = 'null';

}

return data;

}

Hope this helps. You can read the docs here

Just for your information if this is only the case we have a build in options to send nulls when the posted elements are empty string. The parameter is named : NullIfEmpty see the docs for it.

Kind Regards,
Will

Guriddo Support Team

November 29, 2018 at 1:26 pm in reply to: Regarding Accessibility feature in JQGrid #127010

guriddo.support

Participant

Hello Meenakshi,

Thank you for the recommendations. We discussed in our team these requirements and we have made a decision to implement it in our next release which is expecting March 2019.

We will let you know when we have a beta and maybe need your testing and new recommendations, since we do not have much experience in this direction

Thank you in advance

Kind Regards,

Will

Guriddo Support Team

November 6, 2018 at 11:05 am in reply to: Grouping Data questions #126995

guriddo.support

Participant

Hello,

cellattr should not be a problem. We have prepared similar example and it works. See here

The problem is maybe in another part of the code. Try to use no grouping, but with cellattr function.

Kind Regards,

Will

Guriddo Support Team

Author

Replies

Viewing 15 replies - 271 through 285 (of 1,092 total)

← 1 2 3 … 18 19 20 … 71 72 73 →