1
Bug Report / Re: Row is Duplicated
« on: August 02, 2024, 09:46:35 am »
ok. I will edit it the way you suggested. thx
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.
Pages: [1]
2
Bug Report / Re: Row is Duplicated
« on: July 31, 2024, 01:58:03 pm »
I need to check if row is added or modified or normal
The example has been deleted except for the parts that cause bugs.
Besides the type of editable is boolean or function. And isn't it enough to just return a boolean through the function?
The example has been deleted except for the parts that cause bugs.
Besides the type of editable is boolean or function. And isn't it enough to just return a boolean through the function?
3
Bug Report / Row is Duplicated
« on: July 31, 2024, 12:25:49 pm »
Bug condition :
1. There must be enough data for scrolling
2. cls must be added dynamically - ex) editModel.addDisableCls = true
3. colModel.editable is function & function call method getChanges()
- maybe another method occurs same bug
Result :
1. If you scroll while editing, editing will end.
2. Newly rendered rows are duplicated(has same aria-rowindex).
3. Duplicated row has only first column
Example
https://paramquery.com/pro/demos/grid_jsonp
- add Grid Option
editModel : { addDisableCls : true }
- add Option for ColModel Column
editable: function (ui) {
this.getChanges();
return true;
}
full Javascript
/*
$(function () {
var colModel= [
{ title: "Product ID", dataType: "integer", dataIndx: "ProductID", editable: false, width: 80, editable: function (ui) {
this.getChanges()
return true;
}
},
{ title: "Product Name", width: 165, dataType: "string", dataIndx: "ProductName" },
{ title: "Quantity Per Unit", width: 140, dataType: "string", align: "right", dataIndx: "QuantityPerUnit" },
{ title: "Unit Price", width: 100, dataType: "float", align: "right", dataIndx: "UnitPrice" },
{ title: "Units In Stock", width: 100, dataType: "integer", align: "right", dataIndx: "UnitsInStock" },
{ title: "Discontinued", width: 100, dataType: "bool", align: "center", dataIndx: "Discontinued" }
];
var dataModel = {
location: "remote",
dataType: "jsonp",
method: "GET",
url: "/pro/products/get_jsonp"
//url: "/pro/products.php",//for PHP
};
$("#grid_jsonp").pqGrid({
height: 450,
scrollModel: {autoFit: true},
dataModel: dataModel,
colModel: colModel,
numberCell: { resizable: true, width: 30, title: "#" },
title: "Products",
resizable: true,
editModel : { addDisableCls : true }
});
});
*/
Result
real Row
<div class="pq-grid-row pq-striped" role="row" id="pq-body-row-u5-18-right" aria-rowindex="19" style="top:486px;height:27px;width:100%;"><div class="pq-grid-cell pq-align-right" role="gridcell" id="pq-body-cell-u5-18-0-right" style="left: 30px; width: 206px; height: 27px;"><div>31</div></div><div class="pq-grid-cell" role="gridcell" id="pq-body-cell-u5-18-1-right" style="left: 236px; width: 291px; height: 27px;"><div>Gorgonzola Telino</div></div><div class="pq-grid-cell pq-align-right" role="gridcell" id="pq-body-cell-u5-18-2-right" style="left: 527px; width: 265px; height: 27px;"><div>12 - 100 g pkgs</div></div><div class="pq-grid-cell pq-align-right" role="gridcell" id="pq-body-cell-u5-18-3-right" style="left: 792px; width: 226px; height: 27px;"><div>12.5</div></div><div class="pq-grid-cell pq-align-right" role="gridcell" id="pq-body-cell-u5-18-4-right" style="left: 1018px; width: 225px; height: 27px;"><div>0</div></div><div class="pq-grid-cell pq-align-center" role="gridcell" id="pq-body-cell-u5-18-5-right" style="left: 1243px; width: 226px; height: 27px;"><div>false</div></div></div>
duplicated row
<div class="pq-grid-row pq-striped" role="row" id="pq-body-row-u5-18-right" aria-rowindex="19" style="top:486px;height:27px;width:100%;"><div class="pq-grid-cell pq-align-right" role="gridcell" id="pq-body-cell-u5-18-0-right" style="left:30px;width:206px;height:27px;"><div>31</div></div></div>
1. There must be enough data for scrolling
2. cls must be added dynamically - ex) editModel.addDisableCls = true
3. colModel.editable is function & function call method getChanges()
- maybe another method occurs same bug
Result :
1. If you scroll while editing, editing will end.
2. Newly rendered rows are duplicated(has same aria-rowindex).
3. Duplicated row has only first column
Example
https://paramquery.com/pro/demos/grid_jsonp
- add Grid Option
editModel : { addDisableCls : true }
- add Option for ColModel Column
editable: function (ui) {
this.getChanges();
return true;
}
full Javascript
/*
$(function () {
var colModel= [
{ title: "Product ID", dataType: "integer", dataIndx: "ProductID", editable: false, width: 80, editable: function (ui) {
this.getChanges()
return true;
}
},
{ title: "Product Name", width: 165, dataType: "string", dataIndx: "ProductName" },
{ title: "Quantity Per Unit", width: 140, dataType: "string", align: "right", dataIndx: "QuantityPerUnit" },
{ title: "Unit Price", width: 100, dataType: "float", align: "right", dataIndx: "UnitPrice" },
{ title: "Units In Stock", width: 100, dataType: "integer", align: "right", dataIndx: "UnitsInStock" },
{ title: "Discontinued", width: 100, dataType: "bool", align: "center", dataIndx: "Discontinued" }
];
var dataModel = {
location: "remote",
dataType: "jsonp",
method: "GET",
url: "/pro/products/get_jsonp"
//url: "/pro/products.php",//for PHP
};
$("#grid_jsonp").pqGrid({
height: 450,
scrollModel: {autoFit: true},
dataModel: dataModel,
colModel: colModel,
numberCell: { resizable: true, width: 30, title: "#" },
title: "Products",
resizable: true,
editModel : { addDisableCls : true }
});
});
*/
Result
real Row
<div class="pq-grid-row pq-striped" role="row" id="pq-body-row-u5-18-right" aria-rowindex="19" style="top:486px;height:27px;width:100%;"><div class="pq-grid-cell pq-align-right" role="gridcell" id="pq-body-cell-u5-18-0-right" style="left: 30px; width: 206px; height: 27px;"><div>31</div></div><div class="pq-grid-cell" role="gridcell" id="pq-body-cell-u5-18-1-right" style="left: 236px; width: 291px; height: 27px;"><div>Gorgonzola Telino</div></div><div class="pq-grid-cell pq-align-right" role="gridcell" id="pq-body-cell-u5-18-2-right" style="left: 527px; width: 265px; height: 27px;"><div>12 - 100 g pkgs</div></div><div class="pq-grid-cell pq-align-right" role="gridcell" id="pq-body-cell-u5-18-3-right" style="left: 792px; width: 226px; height: 27px;"><div>12.5</div></div><div class="pq-grid-cell pq-align-right" role="gridcell" id="pq-body-cell-u5-18-4-right" style="left: 1018px; width: 225px; height: 27px;"><div>0</div></div><div class="pq-grid-cell pq-align-center" role="gridcell" id="pq-body-cell-u5-18-5-right" style="left: 1243px; width: 226px; height: 27px;"><div>false</div></div></div>
duplicated row
<div class="pq-grid-row pq-striped" role="row" id="pq-body-row-u5-18-right" aria-rowindex="19" style="top:486px;height:27px;width:100%;"><div class="pq-grid-cell pq-align-right" role="gridcell" id="pq-body-cell-u5-18-0-right" style="left:30px;width:206px;height:27px;"><div>31</div></div></div>
4
Help for ParamQuery Pro / Re: Is there any options to cascade checkboxes from multiple columns
« on: June 28, 2024, 02:27:33 pm »
ok. I'll do it by check events.
thx for your answer
thx for your answer
5
Help for ParamQuery Pro / Is there any options to cascade checkboxes from multiple columns
« on: June 28, 2024, 06:47:34 am »
example)
treeModel: {
id: 'id',
parentId: 'parentId',
dataIndx: 'id'
}
data : id / check1 / check2 / check3 / check4
have 4 checkbox column
each column needs tree cascade checkbox like attached image
If there is no such option, I will write it manually with the check events
treeModel: {
id: 'id',
parentId: 'parentId',
dataIndx: 'id'
}
data : id / check1 / check2 / check3 / check4
have 4 checkbox column
each column needs tree cascade checkbox like attached image
If there is no such option, I will write it manually with the check events
6
Help for ParamQuery Pro / Re: Ask about the Gird collapsible feature.
« on: November 15, 2021, 12:17:25 pm »
Thank you. It works fine.
7
Help for ParamQuery Pro / Re: Ask about the Gird collapsible feature.
« on: November 15, 2021, 11:36:26 am »
There is a misunderstanding when using Google Translate.
your answer =>
I am in pqgrid
To subscribe (override) the "complete" event.
It is difficult to show the related code in jsfiddle as it is not yet implemented.
---------
Just what I want is how can I subscribe to the [pqGrid:collapse,pqGrid:expand] event?
call grid.collapse() or
call grid.expand();
or
When the Collapse/Expand icon is clicked.
I wish I could see the example code.
your answer =>
I am in pqgrid
To subscribe (override) the "complete" event.
It is difficult to show the related code in jsfiddle as it is not yet implemented.
---------
Just what I want is how can I subscribe to the [pqGrid:collapse,pqGrid:expand] event?
call grid.collapse() or
call grid.expand();
or
When the Collapse/Expand icon is clicked.
I wish I could see the example code.
8
Help for ParamQuery Pro / Re: Ask about the Gird collapsible feature.
« on: November 15, 2021, 09:27:46 am »
2. Events are fired after collapse / expand is complete. <= not working
grid.collapse();
grid.expand();
from api guide : https://paramquery.com/pro/api77#event-complete
=> complete( event, ui ) Type: pqGrid:complete
=> Triggered when grid has completed data binding and view rendering. This event is generated once for each call to refreshDataAndView method.
is Right?
just collapse and expand..
grid.collapse();
grid.expand();
from api guide : https://paramquery.com/pro/api77#event-complete
=> complete( event, ui ) Type: pqGrid:complete
=> Triggered when grid has completed data binding and view rendering. This event is generated once for each call to refreshDataAndView method.
is Right?
just collapse and expand..
9
Help for ParamQuery Pro / Ask about the Gird collapsible feature.
« on: November 09, 2021, 01:46:51 pm »
I'm using the "options.collapsible.on=true" option to collapse the grid.
I have two questions.
1. Can the user define and make it work as a designated icon rather than the "jq-ui" icon at a specific location outside the grid, and if possible, can the folding height be completely or a user-specified size rather than the icon size?
2. As a result of analyzing the source, "pqGrid:collapse" and "pqGrid:expand" are used as event names. Can the user subscribe to the event before or after?
I have two questions.
1. Can the user define and make it work as a designated icon rather than the "jq-ui" icon at a specific location outside the grid, and if possible, can the folding height be completely or a user-specified size rather than the icon size?
2. As a result of analyzing the source, "pqGrid:collapse" and "pqGrid:expand" are used as event names. Can the user subscribe to the event before or after?
10
Help for ParamQuery Pro / Is there any events for manipulating data when importing excel?
« on: October 05, 2021, 11:38:18 am »
Hi.
I'm struggling with developing method for manipulating excel import using paramquery.
When importing excel data, it may have cells to be rendered or to be replaced with a map of other data.
so I want to engage with an event when importing excel.
is there any appropriate events for it?
I'm struggling with developing method for manipulating excel import using paramquery.
When importing excel data, it may have cells to be rendered or to be replaced with a map of other data.
so I want to engage with an event when importing excel.
is there any appropriate events for it?
11
Bug Report / Re: select event of autoCompleteEditor in column
« on: September 23, 2021, 10:42:13 am »
When could you reply to this post?
12
Help for ParamQuery Pro / Re: remote data model, delete row and don't refersh grid.
« on: September 06, 2021, 01:02:02 pm »
It's my fault. It's an infinite loading problem.
13
Help for ParamQuery Pro / remote data model, delete row and don't refersh grid.
« on: September 06, 2021, 11:17:19 am »
I want to know how to delete rows from grid.
The data model is using the remote model.
If the following command is executed, the row is deleted and reloaded at the same time.
ex)
grid.deleteRow({ rowIndx: 4 } );
Using the remote data model, grid.deleteRow is performed to delete the grid view, and when grid.getChanges() is called, how can the row be retrieved from the deleteList?
The data model is using the remote model.
If the following command is executed, the row is deleted and reloaded at the same time.
ex)
grid.deleteRow({ rowIndx: 4 } );
Using the remote data model, grid.deleteRow is performed to delete the grid view, and when grid.getChanges() is called, how can the row be retrieved from the deleteList?
14
Bug Report / select event of autoCompleteEditor in column
« on: September 01, 2021, 11:35:51 am »
on 8.0 version custom editor demo page, select event of 'autoCompleteEditor' is not fired when 'enter' key down on drop down list.
on 6.0 demo page, it works well.
the test code is below.
on 6.0 demo page, it works well.
the test code is below.
Code: [Select]
function autoCompleteEditor( source ) {
return function (ui) {
ui.$cell.addClass('ui-front');//so that dropdown remains with input.
//initialize the editor
ui.$editor.autocomplete({
//appendTo: ui.$cell, //for grid in maximized state.
source: source,
position: {
collision: 'flipfit',
within: ui.$editor.closest(".pq-grid")
},
selectItem: { on: true }, //custom option
highlightText: { on: true }, //custom option
minLength: 0,
select: function(){ //not fired when enter key down
console.log("select event");
},
}).focus(function () {
//open the autocomplete upon focus
$(this).autocomplete("search", "");
});
}
}
Pages: [1]