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.

Topics - hyh888

Pages: [1] 2
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.

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:
,"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":"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"}]

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"}

Help for ParamQuery Pro / Head filter listenner
« on: April 28, 2022, 11:21:50 am »
In head filter, filter action is triggered when filterbox got change. Is it possible to trigger filter action when TAB or ENTER keys are pressed?
Could you like to show me how to intercept the listenner of head filter change envent

Help for ParamQuery Pro / How to shrink size the delete button
« on: January 31, 2022, 11:10:53 am »
I have tried to shrink the size of delete button to reduce the height of every row, but got failed even tried many times.
Is there any solution for it?

In the demo Editors & validations(, for column ShipVia2 there is no limit-in-list for value in select. Would you like to help to show how to make? And use Ctrl+v, user can copy almost any unexpected data to select(s) and save them to database by batch(When user does this, there is only blank in select, in fact the data has be stored in value of select). Is there a solution for it? Here is the code from demo:

              title: "Shipping Via2", dataIndx: "ShipVia2", width: 110,
              cls: 'pq-dropdown pq-side-icon',
              editor: {
                  type: 'select',
                  init: function (ui) {
                      setTimeout(function () {
                  options: [                       
                        { "SE": "Speedy Express" },
                        { "UP": "United Package" },
                        { "FS": "Federal Shipping" }
              //render required to display options text corresponding to value stored in the cell.
              render: function (ui) {                 
                  var option = ui.column.editor.options.find(function (obj) {
                      return (obj[ui.cellData] != null);
                  return option ? option[ui.cellData] : "";

I hope to add new row automatically, when the DownArrow Key is pressed in the last row.
Following code works well when there is no filter used. But after filtering, pressing DownArrow Key couldn't add new row automatically when the cell in last row is selected. Would you like to provide help kindly?

              beforeCellKeyDown: function( event, ui ) {
                if(event.key=="Delete" ){
                var nodes = [];
                var type = this.Selection().address()[0].type
                if(type == 'row'){
                   var Sel = this.Selection().eachRow(function(rowData){
                   return false; //to prevent default behaviour.                    
                 if(!this.isValid( { rowData: ui.rowData } ).valid)
                if(event.key=="ArrowDown" && ui.rowIndx==this.getTotalRows()-1){
                        var rowIndx = this.addRow({ rowData: defaultRowData(), checkEditable: true });
                        // this.goToPage({ rowIndx: rowIndx });
                        this.editFirstCellInRow({ rowIndx: rowIndx });   

Help for ParamQuery Pro / How to add new option or event in grid
« on: December 27, 2021, 07:42:09 am »
To saving code and reduce bugs, I hope to add saveUrl(url to save data) and getUrl(url to get the json data) for grid, and also hope to add inbuild SaveChanges event to grid for saving data with saveUrl.
Would you like to provide help?
Thank you very much.

Help for ParamQuery Pro / cell get focus event
« on: December 01, 2021, 05:35:13 pm »
Would you like kindly show me how to get cell value when a cell get focus whenever using keyboard or mouse?

Bug Report / TAB doesn't work in select editor
« on: November 24, 2021, 05:03:21 am »
In select editor of  pqgrid demo, when TAB is pressed, the next cell will get focus.  But in my code, TAB doesn't work. Would you like to tell me which css or js file will effect on it? I will add them.
For pqgrid confilicts with bootstrap 4.6.0(make a lot of trouble) ,I have to remove it from my project. But in the demo, I find bootstrap3 is imported. Is this the reason?

Bug Report / Copy and paste problem
« on: November 22, 2021, 02:20:41 pm »
When I add a new row in grid and let editor open, then copy data of another row(Ctrl+C) to the new-added row((Ctrl+V), the cells with delete buttons all lost there style(css and the scissors disappeared). If you click the delete button in the cell, the delete function could not work. But when rows  overflow the grid, the problem will not come out, you'd better set the height of grid is 600 and place less than 8 records in the grid to keep enough place in the grid for the new row.
The screen-shot are as follow:

Help for ParamQuery Pro / DELETE problem
« on: November 19, 2021, 04:56:07 pm »
When I select a row in treegrid and press DELETE ,all data in grid are deleted.
When I select a row in grid and press DELETE in common grid, the data in the row(s) are deleted, but the empty row is still there. Is it possible to delete whole row (or rows)?

Help for ParamQuery Pro / How hide maximize button
« on: November 19, 2021, 08:28:22 am »
I hope to hide maximize and minimize button and put the title("shipping orders") before the "toggle filter fow" button to save space in interface,is it possible?

Help for ParamQuery Pro / How to remove tree grid border color
« on: November 03, 2021, 08:10:35 am »
When using tree grid, there is a color border around the grid. Would you like to help to get rid of it?
When tree node is clicked, user can see a block as the background of the cell, can the block be removed?
The following picture is the current interface:

Help for ParamQuery Pro / Bootstrap conflict
« on: October 29, 2021, 07:28:40 am »
For tooltips js file of pqGrid  conflicts with bootstrap's, is it possible to modify pqGrid's tooltips js file to avoid confliction? Then many troubles may be avoided. So as the button click conflict problem.

Pages: [1] 2