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.


Messages - tbum

Pages: [1]
1
How can I express rows fixed to the first line always without being affected by sorting?
I implemented summary at the bottom. Therefore, one row is fixed for each of the top and bottom.

3
How can I access the dom object for the grid-overay of the selectionModel?
I want to set different colors depending on the selected area position.

4
Help for ParamQuery Pro / about selectionModel's block
« on: June 30, 2022, 02:12:46 pm »
Code: [Select]

            selectionModel: {type: 'cell', mode: 'block', row: true, toggle: true,},

I have specified selectionModel as above.
What I want to do is make a block so that only cells in the same row as the cell that started the first selection are selected.
What can I do?
And no event handlers like beforeSelectChange ? This is to be able to invalidate when an unwanted area is selected.


The exact function I want to make is that I want the selectModel to work only for a specific area. Do you offer such a feature as an option?
Otherwise, I tried to develop it using an event handler.

5
I solved it! thanks for your reply :)

6
Hi,
I want to export only selected(cb: checked) rows to excel.

This works fine. However, after exporting data, it moves to page 1.
How can I avoid moving pages?

Code: [Select]
colModel: [
        { dataIndx: "selectRow", maxWidth: 30, minWidth: 30, align: "center", resizable: false,
          title: "",
          menuIcon: false,
          type: 'checkbox',
          sortable: false,
          editor: false,
          dataType: 'bool',
          copy: false,
          cb: {
            all: false,
            header: true
          }
        },
       ...
      ],
selectionModel: { type: 'row' },
toolbar: {
        items: [
          {
            type: "button",
            label: 'export',
            cls: 'btn btn-success my-1',
            listener: function () {
              let dateStr = $.datepicker.formatDate('yymmdd', new Date());
              let format = 'xlsx';

              if( this.Checkbox('selectRow').getCheckedNodes().length >= 1 ) { //If checked, export selected rows.
                this.filter({
                  oper: 'replace',
                  rules: [{ dataIndx: "selectRow", condition: "equal", value: true}]
                });
              }

              let blob = this.exportData({
                sheetName: dateStr,
                format: format,
                render: false
              });
              if(typeof blob === "string"){
                blob = new Blob([blob]);
              }
              this.filter({
                oper: 'replace',
                rules: [],
              });
              saveAs(blob, `${dateStr}.${format}`);
            }
          }
        ]
      }

7
I have two questions. Please help.

First, when exporting tree to excel, a '-' character is appended.
Can you change this character to another character?

The second is to create a function that expands only to level 2 nodes among all nodes in the tree and collapses below that level. Which method is the best way? Wouldn't it be better to collapse all nodes and then use expandTo to show level 2?


Code: [Select]

  datagrid = this.getData();
                            var target = 2;
                            var targetLevel = target -1;
                            var targetItem = [];
                            $.each(datagrid,function(i,v){
                                if(targetLevel > v.pq_level){
                                    targetItem.push(v);
                                }
                            });


                            var tree = this.Tree();
                            tree.collapseAll();
                            if(targetItem.length > 0){
                                tree.expandNodes(targetItem);
                            }

8
ParamQuery Pro Evaluation Support / Re: Paramquery Pro License registration
« on: September 18, 2021, 09:12:36 am »
Thanks !
Hi Taebum Um

Your account has been upgraded to Pro Ultimate.

Regards
Paramvir

9
ParamQuery Pro Evaluation Support / Paramquery Pro License registration
« on: September 18, 2021, 07:19:10 am »
Hello,

We purchased a ParamQuery Pro License for my company use, please upgrade this account to pro with:

Transaction ID: XXXXXXXXXXX005825R

Thanks!

Pages: [1]