46
Bug Report / Re: Too many item in select, make select editor out of function
« on: October 27, 2022, 06:49:09 pm »
this is functional case
ParamQuery Grid
Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
47
Bug Report / Re: Too many item in select, make select editor out of function
« on: October 27, 2022, 06:34:43 pm »
Here are three screen shot for fuctional, partially fucntional and malfunction cases.
48
Bug Report / Too many item in select, make select editor out of function
« on: October 27, 2022, 01:32:45 pm »
If there are 5 or 10 items in select, pqgrid runs well, if there are 40 items or more in select editor, the select couldn't dropdow.
I'm using this way to bind data:
options: [
{ "SE": "Speedy Express" },
{ "UP": "United Package" },
{ "FS": "Federal Shipping" }
],
Here is part of my code:
var arrSelect = new Array(["/admin/codegen/tablesAutocomplete?datasource=main", 'mainTableName','name','name' ]
,["/admin/permission/dataAll", 'permissionId' ,'id','title']
,["/admin/permission/options", 'pid' ,'id','title']
);
var obj = {
height: 300,
colModel:gridColModel,
width:1700,
stripeRows: false,
saveUrl:saveUrl,
pageSize:pageSizeHyh,
create: function (evt, ui) {
var grid = this,column;
$.ajaxSettings.async = false
arrSelect.forEach(function(item){
$.getJSON(item[0], function (response) {
column = grid.getColumn({ dataIndx: item[1] });
var a = new Array();
var remoteData=(response.data.list?response.data.list:response.data);
if(remoteData==undefined ||remoteData== null) return;
for(let j=0,len=remoteData.length;j<len;j++){
var myObj={};
myObj[remoteData[j][item[2]]]= remoteData[j][item[3]];
if(j<30)
a.push(myObj);
}
column.cls='pq-drop-icon pq-side-icon';
column.editor={
type: 'select',
options: a,
init: function (ui) {
ui.$cell.find("select").pqSelect();
setTimeout(function () {
ui.$cell.find("select").pqSelect('open');
})
}
};
column.render=function (ui) {
var option = ui.column.editor.options.find(function (obj) {
return (obj[ui.cellData] != null);
});
return option ? option[ui.cellData] : "";
}
});
});
$.ajaxSettings.async = true;
this.widget().pqTooltip();
},
When I debug it, I find datasoure of select editor is OK, but they couldn't be show in browser. The reason is that too many items make select editor too long and out of the interface. But I couldn't find the solution.
I'm using this way to bind data:
options: [
{ "SE": "Speedy Express" },
{ "UP": "United Package" },
{ "FS": "Federal Shipping" }
],
Here is part of my code:
var arrSelect = new Array(["/admin/codegen/tablesAutocomplete?datasource=main", 'mainTableName','name','name' ]
,["/admin/permission/dataAll", 'permissionId' ,'id','title']
,["/admin/permission/options", 'pid' ,'id','title']
);
var obj = {
height: 300,
colModel:gridColModel,
width:1700,
stripeRows: false,
saveUrl:saveUrl,
pageSize:pageSizeHyh,
create: function (evt, ui) {
var grid = this,column;
$.ajaxSettings.async = false
arrSelect.forEach(function(item){
$.getJSON(item[0], function (response) {
column = grid.getColumn({ dataIndx: item[1] });
var a = new Array();
var remoteData=(response.data.list?response.data.list:response.data);
if(remoteData==undefined ||remoteData== null) return;
for(let j=0,len=remoteData.length;j<len;j++){
var myObj={};
myObj[remoteData[j][item[2]]]= remoteData[j][item[3]];
if(j<30)
a.push(myObj);
}
column.cls='pq-drop-icon pq-side-icon';
column.editor={
type: 'select',
options: a,
init: function (ui) {
ui.$cell.find("select").pqSelect();
setTimeout(function () {
ui.$cell.find("select").pqSelect('open');
})
}
};
column.render=function (ui) {
var option = ui.column.editor.options.find(function (obj) {
return (obj[ui.cellData] != null);
});
return option ? option[ui.cellData] : "";
}
});
});
$.ajaxSettings.async = true;
this.widget().pqTooltip();
},
When I debug it, I find datasoure of select editor is OK, but they couldn't be show in browser. The reason is that too many items make select editor too long and out of the interface. But I couldn't find the solution.
49
Help for ParamQuery Pro / How to update related cells without using formula (or mapped to a select list)
« on: October 10, 2022, 07:12:55 am »
When the name of a product is changed, in old sales order the old name should be expected to show but in the new created order the new name is expected to show. If formula is used, the old sales order will show the new name, even old name is recorded in the table of sales order lines in database. If there is a solution for this condition? Is there afterchanged and afterupdated for pqgrid cells?
50
Help for ParamQuery Pro / Re: Keyboard movement does not work after adding group model summary to grid options
« on: July 23, 2022, 11:35:19 am »
Should we put these js into another js file and import it?
51
Suggest new features / Re: Default value in colModel
« on: June 29, 2022, 08:14:51 am »
Million thanks!
52
Suggest new features / Re: Default value in colModel
« on: June 28, 2022, 08:51:56 am »
Dear Daramvir:
This code is too complicate, it will be better if pqgrid can add default value property in colModel.
var colModel= [
{title: "ID", dataIndx: "id", width: 200,dataType: "string", editable: false },
{title: "Country", dataIndx: "Country",width: 260, dataType: "string",defaultValue:"USA"},
{title: "City", dataIndx: "City",width: 260, dataType: "string",defaultValue:"New York"}
]
Long and complicate java-like code really frustrates me, json-like concise code can really save coding time and reduce debug time.
This code is too complicate, it will be better if pqgrid can add default value property in colModel.
var colModel= [
{title: "ID", dataIndx: "id", width: 200,dataType: "string", editable: false },
{title: "Country", dataIndx: "Country",width: 260, dataType: "string",defaultValue:"USA"},
{title: "City", dataIndx: "City",width: 260, dataType: "string",defaultValue:"New York"}
]
Long and complicate java-like code really frustrates me, json-like concise code can really save coding time and reduce debug time.
53
Suggest new features / Re: Default value in colModel
« on: June 21, 2022, 01:16:32 pm »
Dear Daramvir:
If this function has been provided in new version?
If this function has been provided in new version?
54
Help for ParamQuery Pro / Re: Saving event sample for treegrid batch editing
« on: May 18, 2022, 07:29:28 am »
It will be better if pqGrid can make it a build-in function, I'm surprised for having to do it manully.
55
Help for ParamQuery Pro / Readonly grid
« on: May 17, 2022, 08:28:39 am »
Would you like to show me how to make pqgrid a readonly spreadsheet conveniencely?
Now I have to set editable property as false one col by one col.
Now I have to set editable property as false one col by one col.
56
Help for ParamQuery Pro / Saving event sample for treegrid batch editing
« on: May 17, 2022, 07:00:28 am »
In the code of demo, I didn't find the code for saving envent.Would you like to provide save event sample code for treegrid batch editing?
When I use saving mothod of common grid, pqGrid send json of all records to server when I changed the topnode. It seems that the item property of json is unnesassary.
Here is the json that pqGrid sent to server:
{"oldList":[{"sn":"ZJL"},{"sn":"SCYYZJ"}],"save":[],
"update":[
{"eachLevel":1,"id":"3"
,"items":[{"eachLevel":2,"id":"5"
,"items":[{"eachLevel":3,"id":"6"
,"items":[{"eachLevel":4,"id":"7"
,"items":[{"eachLevel":5,"id":"8","name":" Planner ","pid":"7","sn":"SCJHY","pq_level":4,"parentId":"7","pq_ri":4,"pq_hidden":false,"pq_ht":35}]
,"name":" Planning Supervisor ","pid":"6","sn":"SCJHZG","pq_level":3,"parentId":"6","pq_ri":3,"pq_hidden":false,"pq_ht":35}]
,"name":" Planning Manager ","pid":"5","sn":"SCJHJL","pq_level":2,"parentId":"5","pq_ri":2,"pq_hidden":false,"pq_ht":35}]
,"name":" Operation Director","pid":"3","sn":"SCYYZJ2","pq_level":1,"parentId":"3","pq_ri":1,"pq_hidden":false,"pq_ht":35,"pq_cellcls":{"sn":"pq-cell-dirty"}}]
,"name":"GM","pid":"0","sn":"ZJL1"}
,{"eachLevel":2,"id":"5"
,"items":[{"eachLevel":3,"id":"6"
,"items":[{"eachLevel":4,"id":"7"
,"items":[{"eachLevel":5,"id":"8","name":"Planner","pid":"7","sn":"SCJHY","pq_level":4,"parentId":"7","pq_ri":4,"pq_hidden":false,"pq_ht":35}]
,"name":"Planning Supervisor","pid":"6","sn":"SCJHZG","pq_level":3,"parentId":"6","pq_ri":3,"pq_hidden":false,"pq_ht":35}]
,"name":"Planning Manager","pid":"5","sn":"SCJHJL","pq_level":2,"parentId":"5","pq_ri":2,"pq_hidden":false,"pq_ht":35}]
,"name":"Operation Director","pid":"3","sn":"SCYYZJ2","parentId":"3"}]
,"delete":[]}
When I use saving mothod of common grid, pqGrid send json of all records to server when I changed the topnode. It seems that the item property of json is unnesassary.
Here is the json that pqGrid sent to server:
{"oldList":[{"sn":"ZJL"},{"sn":"SCYYZJ"}],"save":[],
"update":[
{"eachLevel":1,"id":"3"
,"items":[{"eachLevel":2,"id":"5"
,"items":[{"eachLevel":3,"id":"6"
,"items":[{"eachLevel":4,"id":"7"
,"items":[{"eachLevel":5,"id":"8","name":" Planner ","pid":"7","sn":"SCJHY","pq_level":4,"parentId":"7","pq_ri":4,"pq_hidden":false,"pq_ht":35}]
,"name":" Planning Supervisor ","pid":"6","sn":"SCJHZG","pq_level":3,"parentId":"6","pq_ri":3,"pq_hidden":false,"pq_ht":35}]
,"name":" Planning Manager ","pid":"5","sn":"SCJHJL","pq_level":2,"parentId":"5","pq_ri":2,"pq_hidden":false,"pq_ht":35}]
,"name":" Operation Director","pid":"3","sn":"SCYYZJ2","pq_level":1,"parentId":"3","pq_ri":1,"pq_hidden":false,"pq_ht":35,"pq_cellcls":{"sn":"pq-cell-dirty"}}]
,"name":"GM","pid":"0","sn":"ZJL1"}
,{"eachLevel":2,"id":"5"
,"items":[{"eachLevel":3,"id":"6"
,"items":[{"eachLevel":4,"id":"7"
,"items":[{"eachLevel":5,"id":"8","name":"Planner","pid":"7","sn":"SCJHY","pq_level":4,"parentId":"7","pq_ri":4,"pq_hidden":false,"pq_ht":35}]
,"name":"Planning Supervisor","pid":"6","sn":"SCJHZG","pq_level":3,"parentId":"6","pq_ri":3,"pq_hidden":false,"pq_ht":35}]
,"name":"Planning Manager","pid":"5","sn":"SCJHJL","pq_level":2,"parentId":"5","pq_ri":2,"pq_hidden":false,"pq_ht":35}]
,"name":"Operation Director","pid":"3","sn":"SCYYZJ2","parentId":"3"}]
,"delete":[]}
57
Suggest new features / Default value in colModel
« on: May 12, 2022, 03:56:13 am »
Now it seems that default value couldn't be set in colModel for new row of every column. Can it be added?
Then developer may get better experience in programing like following:
var colModel= [
{title: "ID", dataIndx: "id", width: 200,dataType: "string", editable: false },
{title: "Country", dataIndx: "Country",width: 260, dataType: "string",default:"USA"},
{title: "City", dataIndx: "City",width: 260, dataType: "string",default:"New York"}
]
Then developer may get better experience in programing like following:
var colModel= [
{title: "ID", dataIndx: "id", width: 200,dataType: "string", editable: false },
{title: "Country", dataIndx: "Country",width: 260, dataType: "string",default:"USA"},
{title: "City", dataIndx: "City",width: 260, dataType: "string",default:"New York"}
]
58
Help for ParamQuery Pro / Re: Head filter listenner
« on: May 03, 2022, 05:37:48 am »
Thank you for kindly help, I will try it.
59
Help for ParamQuery Pro / Re: Head filter listenner
« on: April 30, 2022, 06:53:06 pm »
In head filter, filter action is triggered automatically even when filterbox got one letter change , this is will send server many unnesessary requests. Can it be stopped? Then it can be trigger in need.
60
Help for ParamQuery Pro / Re: Head filter listenner
« on: April 29, 2022, 01:51:16 pm »
In head filter, filter action is triggered when filterbox got change automatically, this is a problem. Can it be stopped? Then it can be trigger in need.