Guriddo » tony's Replies

tony

Guriddo

Forum Replies Created

Viewing 15 replies - 61 through 75 (of 7,981 total)

← 1 2 3 4 5 6 … 531 532 533 →

Author

Replies

May 25, 2016 at 10:16 am in reply to: jqGrid – Freezing columns with row spanning #125204

tony

Keymaster

Hello,

Thank you for remind us to test the changes in all popular browsers.

I have fixed the problem. You can get the code from github. Also I have updated your demo too.

Please let us know if the problem is fixed.

Kind Regards,

May 25, 2016 at 9:18 am in reply to: Typescript definition for JqGrid #125202

tony

Keymaster

Hello,

Sorry that we do not post our final decision here.

Actually what is TypeScript?
As per definition : TypeScript is a superset of JavaScript, that compiles to plain JavaScript

Actually when we have a TypScript code we compile it to JavaScript again, so the final result is the same.

We have made a long discussion and have made a decision to stop for now writing TypeScript code for jqGrid. This will cost us too much (note that we are small company).

If we begin to write jqGrid from the beginning we will definitely use TypeScript, but to do the inverse to have the same as we have – it will cost us too much.

Hope I express myself clear.

For now we stop with this and I can not commit to any ceratain date when we will have TypeScript jqGrid

Kind Regards,

May 25, 2016 at 8:57 am in reply to: Master Detail grid and inline editing #125201

tony

Keymaster

Hello,

No. Most of operations like retrieving data, sorting, paging, searching are performed at PHP end. The build of grid is based and some descriptions of the php script and the script generates automatically the java script code.

For clarification in master grid we use onselectRow, onPaging, onSortCol events,

The javascript for onSelectRow is:


onSelectRow : function(rowid, selected)
{
    if(rowid != null) {
        jQuery(&quot;#detail&quot;).jqGrid(&#039;setGridParam&#039;,{postData:{EmployeeID:rowid}});
        jQuery(&quot;#detail&quot;).jqGrid(&#039;setColProp&#039;,&#039;EmployeeID&#039;,{editoptions:{defaultValue:rowid}});
        jQuery(&quot;#detail&quot;).trigger(&quot;reloadGrid&quot;);
        // Enable CRUD buttons in navigator when a row is selected
        jQuery(&quot;#add_detail&quot;).removeClass(&quot;ui-state-disabled&quot;);
        jQuery(&quot;#edit_detail&quot;).removeClass(&quot;ui-state-disabled&quot;);
        jQuery(&quot;#del_detail&quot;).removeClass(&quot;ui-state-disabled&quot;);
    }
},

onPaging : function(rowid, selected)
{
   // clear the grid data and footer data
    jQuery(&quot;#detail&quot;).jqGrid(&#039;clearGridData&#039;,true);
    // Disable CRUD buttons in navigator when a row is not selected
    jQuery(&quot;#add_detail&quot;).addClass(&quot;ui-state-disabled&quot;);
    jQuery(&quot;#edit_detail&quot;).addClass(&quot;ui-state-disabled&quot;);
    jQuery(&quot;#del_detail&quot;).addClass(&quot;ui-state-disabled&quot;);
},
onSortCol : function(rowid, selected)
{
   // clear the grid data and footer data
    jQuery(&quot;#detail&quot;).jqGrid(&#039;clearGridData&#039;,true);
    // Disable CRUD buttons in navigator when a row is not selected
    jQuery(&quot;#add_detail&quot;).addClass(&quot;ui-state-disabled&quot;);
    jQuery(&quot;#edit_detail&quot;).addClass(&quot;ui-state-disabled&quot;);
    jQuery(&quot;#del_detail&quot;).addClass(&quot;ui-state-disabled&quot;);
},
....

onSelectRow : function(rowid, selected)

{

if(rowid != null) {

jQuery("#detail").jqGrid('setGridParam',{postData:{EmployeeID:rowid}});

jQuery("#detail").jqGrid('setColProp','EmployeeID',{editoptions:{defaultValue:rowid}});

jQuery("#detail").trigger("reloadGrid");

// Enable CRUD buttons in navigator when a row is selected

jQuery("#add_detail").removeClass("ui-state-disabled");

jQuery("#edit_detail").removeClass("ui-state-disabled");

jQuery("#del_detail").removeClass("ui-state-disabled");

}

onPaging : function(rowid, selected)

{

// clear the grid data and footer data

jQuery("#detail").jqGrid('clearGridData',true);

// Disable CRUD buttons in navigator when a row is not selected

jQuery("#add_detail").addClass("ui-state-disabled");

jQuery("#edit_detail").addClass("ui-state-disabled");

jQuery("#del_detail").addClass("ui-state-disabled");

onSortCol : function(rowid, selected)

{

// clear the grid data and footer data

jQuery("#detail").jqGrid('clearGridData',true);

// Disable CRUD buttons in navigator when a row is not selected

jQuery("#add_detail").addClass("ui-state-disabled");

jQuery("#edit_detail").addClass("ui-state-disabled");

jQuery("#del_detail").addClass("ui-state-disabled");

....

In the detail grid we use beforShowForm for adding and recreateForm : true for add and edit.

These options should be set in navigator add, edit events

The code for beforeShowForm is:


beforeShowForm : function(formid)
{
   var srow = jQuery(&quot;#grid&quot;).jqGrid(&#039;getGridParam&#039;,&#039;selrow&#039;);
   if(srow) {
       var gridrow = jQuery(&quot;#grid&quot;).jqGrid(&#039;getRowData&#039;,srow);
       $(&quot;#EmployeeID&quot;,formid).val(gridrow.EmployeeID);
   }
}

beforeShowForm : function(formid)

{

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

if(srow) {

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

$("#EmployeeID",formid).val(gridrow.EmployeeID);

}

Kind Regards,

May 25, 2016 at 8:46 am in reply to: Spinner in JQGrid Bootstrap #125200

tony

Keymaster

Hello,

If you use html5 definition in your page you can do this without any additional plugin.

You will need to set in the field in colModel

...

colModel : [ 
...,
{name : &#039;spinner&#039;,...,editoptions : { type: &#039;number&#039;, min: 1, max :1000 },..}
...,
],
...

...

colModel : [

...,

{name : 'spinner',...,editoptions : { type: 'number', min: 1, max :1000 },..}

...,

...

I have tested this definition in Bootstrap and it works fine for me.

Kind Regards,

May 25, 2016 at 8:37 am in reply to: JQGrid bootstrap with column filter not working #125199

tony

Keymaster

Hello,

Thank you for the feedback.

Kind Regards,

May 24, 2016 at 10:37 am in reply to: Sometimes fields remain as blue(selected) when saving the row #125191

tony

Keymaster

Hello,

Thank you for getting back to us.

As I every time explain – it is very difficult to reproduce the client problem.

From my point of view jqGrid work correct, since we have similar example which work fine. See it here

Please understand that if you want help resolving the problem, you should post a code which demonstrates the problem – otherwise we can nothing to do.

Kind Regards,

May 24, 2016 at 10:30 am in reply to: jqGrid – Freezing columns with row spanning #125190

tony

Keymaster

Hello,

This is strange. Do you have clear the browser cache? Sometimes this help.

I have re created your example, which uses the code from GitHub.

Here is the link to your demo

It seems it is fixed here.

Kind Regards

May 20, 2016 at 11:11 am in reply to: jqGrid – Freezing columns with row spanning #125184

tony

Keymaster

Hello,

I have fixed the problem here.

You can download the code from GitHub and test it. See my previous instructions how to use the code from GitHub.

The code needs to be optimized, but I will do this when the bug fix will be published.

Please let us know if the problem is fixed for you.

Thank you.

Kind Regards,

May 20, 2016 at 10:37 am in reply to: Unable to get pagination in Jqgrid, Page 1 of 0 is shown #125183

tony

Keymaster

Hello,

By the way which version of jqGrid is used? It seems it is old, since you use
GridUnload instead of $.jgrid.gridUnload.

The below code works for me

function GridSearchText() {
//$.jgrid.gridUnload(&#039;Tracking&#039;);
var text = 3;//$(&#039;#txttext&#039;).val().trim(); //my text to be searched
$(&quot;#Tracking&quot;).jqGrid({
datatype: &#039;json&#039;,
prmNames: {
search: &quot;isSearch&quot;,
nd: null,
rows: &quot;numRows&quot;,
page: &quot;page&quot;,
sort: &quot;sortField&quot;,
order: &quot;sortOrder&quot;
},
url : &quot;myddata.json&quot;,
postData: { PO_txt: text },
autowidth: true,
height: &quot;500px&quot;,
colNames: [&quot;ID&quot;, &quot;Title&quot;, &quot;Desc&quot;],
colModel: [
{ name: &quot;ID&quot;, align: &#039;center&#039;, width: &quot;1500px&quot; },
{ name: &quot;Title&quot;, align: &#039;center&#039;, width: &quot;2000px&quot;, sortable: false },
{ name: &quot;Desc&quot;, align: &#039;center&#039;, width: &quot;1500px&quot;, sortable: false },
],
jsonReader: { 
	root: &quot;d.rows&quot;, 
	page: &quot;d.page&quot;, 
	total: &quot;d.total&quot;,
	records: &quot;d.records&quot;,
	cell: &quot;cell&quot;,
	id: &quot;ID&quot;, //index of the column with the PK in it
	userdata: &quot;userdata&quot;,
	repeatitems: true 
},
shrinktofit: true,
rowNum: 3,
rowList: [3, 6],
pager: &#039;#TrackingPager&#039;,
sortname: &quot;Title&quot;,
sortorder: &quot;asc&quot;,
viewrecords: true,
gridview: true,datatype: &#039;json&#039;,
autoencode: true,
loadonce: true,
pgtext: &quot;Page {0} of {1}&quot;,
loadtext: &quot;Searching  Text …!!!&quot;
});
$(&quot;#Tracking&quot;).jqGrid(&#039;gridResize&#039;, &#039;#TrackingPager&#039;);
}

function GridSearchText() {

//$.jgrid.gridUnload('Tracking');

var text = 3;//$('#txttext').val().trim(); //my text to be searched

$("#Tracking").jqGrid({

datatype: 'json',

prmNames: {

search: "isSearch",

nd: null,

rows: "numRows",

page: "page",

sort: "sortField",

order: "sortOrder"

url : "myddata.json",

postData: { PO_txt: text },

autowidth: true,

height: "500px",

colNames: ["ID", "Title", "Desc"],

colModel: [

{ name: "ID", align: 'center', width: "1500px" },

{ name: "Title", align: 'center', width: "2000px", sortable: false },

{ name: "Desc", align: 'center', width: "1500px", sortable: false },

jsonReader: {

root: "d.rows",

page: "d.page",

total: "d.total",

records: "d.records",

cell: "cell",

id: "ID", //index of the column with the PK in it

userdata: "userdata",

repeatitems: true

shrinktofit: true,

rowNum: 3,

rowList: [3, 6],

pager: '#TrackingPager',

sortname: "Title",

sortorder: "asc",

viewrecords: true,

gridview: true,datatype: 'json',

autoencode: true,

loadonce: true,

pgtext: "Page {0} of {1}",

loadtext: "Searching Text …!!!"

});

$("#Tracking").jqGrid('gridResize', '#TrackingPager');

}

The response is like this

{&quot;d&quot;:{
&quot;total&quot;:2,
&quot;page&quot;:1,
&quot;records&quot;:6,
&quot;rows&quot;:
[{&quot;ID&quot;:&quot;1&quot;,&quot;Title&quot;:&quot;1&quot;,&quot;Desc&quot;:&quot;one&quot;},
{&quot;ID&quot;:&quot;2&quot;,&quot;Title&quot;:&quot;2&quot;,&quot;Desc&quot;:&quot;two&quot;},
{&quot;ID&quot;:&quot;3&quot;,&quot;Title&quot;:&quot;3&quot;,&quot;Desc&quot;:&quot;three&quot;},
{&quot;ID&quot;:&quot;4&quot;,&quot;Title&quot;:&quot;4&quot;,&quot;Desc&quot;:&quot;four&quot;},
{&quot;ID&quot;:&quot;5&quot;,&quot;Title&quot;:&quot;5&quot;,&quot;Desc&quot;:&quot;five&quot;},
{&quot;ID&quot;:&quot;6&quot;,&quot;Title&quot;:&quot;6&quot;,&quot;Desc&quot;:&quot;six&quot;}
]}
}

{"d":{

"total":2,

"page":1,

"records":6,

"rows":

[{"ID":"1","Title":"1","Desc":"one"},

{"ID":"2","Title":"2","Desc":"two"},

{"ID":"3","Title":"3","Desc":"three"},

{"ID":"4","Title":"4","Desc":"four"},

{"ID":"5","Title":"5","Desc":"five"},

{"ID":"6","Title":"6","Desc":"six"}

]}

}

P.S. You use eval in your code in addJSONData. The using of eval is not recommended – you may use the build in JSON.parse

Kind Regards,

May 19, 2016 at 9:40 am in reply to: not found error 404 with editurl #125178

tony

Keymaster

Hello,

Thank you for posting the solution.
If possible, please explain why is this needed.

Thank you

Kind Regards,

May 19, 2016 at 9:38 am in reply to: Unable to get pagination in Jqgrid, Page 1 of 0 is shown #125177

tony

Keymaster

Hello,

The nutshell of the problem is the using of addRowData. This method does not take in account the pagination – it take in account the count of the records only.

There is more than one possible solution.

use reload grid after adding the data trigger(‘reloadGrid);
It is highly recommended to use addRowData to add not more than 1-2 records. In your case you can use addJsonData – see here how to use this function
I see you parse the JSON to get the d response. It is not necessary to make it so complex. You can direct use response and just configure the jsonReader

like this:

First you should not use datatype as function, but just a regular jqGrid. Add in your grid options this

jsonReader: { root: &quot;d.rows&quot;, page: &quot;d.page&quot;, total: &quot;d.total&quot;,
              records: &quot;d.records&quot; };

1 2	jsonReader: { root: "d.rows", page: "d.page", total: "d.total", records: "d.records" };

Kind Regards,

May 16, 2016 at 10:18 am in reply to: jqgrid and material design plans #125167

tony

Keymaster

Hello Kris,

Thank you for the question.

You are right – jQuery Mobile seems to be dead project. There is nothing on it about a year in GitHub.

As you can see we have made the first step – Bootstrap support. It is not too much, but it is a beginning.

Our plans are to reconsider our Mobile jqGrid to another base – I mean Bootstrap or other, but we should carefully do this, since we have a bad experience with jQuery Mobile.

Currently we make our plans on what we will do to the end of year and one of this is the Mobile jqGrid version. We will let you know or you may want look recently on our Roadmap

Kind Regards,

May 16, 2016 at 10:06 am in reply to: jqGrid – Freezing columns with row spanning #125166

tony

Keymaster

Hello,

Currently I do not find a appropriate solution for this. Let me try another approach.

Will let you know ASAP.

Thank you

Kind Regards,

May 13, 2016 at 1:40 pm in reply to: dependent dropdown in subgrid #125164

tony

Keymaster

Hello,

If this work as expected it is ok to get the variable this way.

Maybe Your ajax which get unitest2 does not have async = false. Try to add this to this ajax request.

Kind Regards

May 12, 2016 at 10:20 am in reply to: Submit button focus on last field #125161

tony

Keymaster

Hello,

There is a property in dialog called savekey – the first param enables/disables the second is the key code

...
$grid-&gt;setNavOptions(&#039;edit&#039;,array( &quot;savekey&quot;=&gt;array(true,13) ));
...

...

$grid->setNavOptions('edit',array( "savekey"=>array(true,13) ));

...

This will save the form on when Enter key is pressed.

Kind Regards,

Author

Replies

Viewing 15 replies - 61 through 75 (of 7,981 total)

← 1 2 3 4 5 6 … 531 532 533 →