Messages

1

Help for ParamQuery Pro / help for check box in the table

« on: June 08, 2022, 06:44:39 pm »

Hi

I have implemented check box in paramquery table as per below and it works well.

Code: [Select]

{
                    dataIndx: 'state',maxWidth: 30, minWidth: 30, align: "center", resizable: false, title: "",
                    menuIcon: false, sortable: false, editor: false, editable: true, menuInDisable: true,
                    type: 'checkbox', cls: 'ui-state-default',
                    dataType: 'bool',
                    cb: {
                        all: true, //checkbox selection in the header affect current page only.
                        header: true //show checkbox in header.
                    },
                    render: function (ui) {
                        if (ui.rowData.summaryRow) {
                            return "";
                        }
                        else
                        {
                            let column = this.getColumn({ dataIndx: 'state' }),
                                state = ui.rowData.state,
                                check = column.cb.check,
                                checked;
                           
                            if (state === check || ui.rowData.chkeod == 1)
                            {
                                checked = 'checked';
                            }
                            else
                            {
                                checked = '';
                            }

                            return {
                                text: "<label><input type='checkbox' " + checked + " /></label>"
                            }
                        }
                    }
                },

The issue is that it does not work with the below code as nothing come up with "rd".

Code: [Select]

Checkbox('state').getCheckedNodes().map(function (rd) {
                let obj = { id: rd.accountdetailid }
                result.push(obj);
            })


I have attached images that showing it actually selected but all check box on top has not checked as well.

Can you please adivse me how to bind actual check box from the begining?
(If I recheck it then looks like check box selected correctly)

Thanks,

2

Help for ParamQuery Pro / Pivot with tab on modal

« on: February 13, 2022, 06:30:05 pm »

HI

I am trying to use Pivot with tab example on modal, but it is not activate with pivot table initially.

It is okay if activated with data tab initially but no luck for pivot table.

I use the below code and it works well with data tab but no luck for pivot table tab.

                $("#modal_lg").on("shown.bs.modal", function () {
                    pq.Grid.refresh();

                });

(I use examtly same code on the example code (Pivot with tabs))

Thanks,

3

Help for ParamQuery Pro / checkbox and getCheckedNodes

« on: January 19, 2022, 10:07:10 am »

Hi ,

I am using checkbox and render it as per below.

In UI, it works as checked but when I use getCheckedNodes, it returns null value.
(All checked in checkbox in UI but no return for getCheckedNodes)

Am i missing something here?



 render: function (ui) {
                            const cards = $this.variables.vSetIDs ?? [];
                            let checked = '';
                            if (ui.cellData == null) {
                                //init
                                if (cards.includes(ui.rowData.cardid)) {
                                    checked = 'checked';
                                }
                            }
                            else {
                                if (ui.cellData) {
                                    checked = 'checked';
                                }
                            }

                            return {
                                text: "<label><input type='checkbox' " + checked + "/></label>"
                            }
                        }

4

Help for ParamQuery Pro / Re: SummaryData not working

« on: January 06, 2022, 09:49:26 am »

Thanks for your reply and I prefer to use refresh method after setting summaryData option but it doesn't work.

It works with using excecl formulas but don't want to use it as when it export it doesn't make sense. (Formula inherited in the excel template and looks funny... (e.g. SUM(G:G) means that it includes its cell self in the formula...)

I call refresh method after summaryData option like  $this.variables.vGrid.refresh(); and nothing shown up in the summary row...
My calcuateSummary function is as per below..


        calculateSummary: function () {
            const $this = this;
           
            let payhourTotal = 0,
                profitTotal = 0,
                data = $this.variables.vGrid.option('dataModel.data');

            for (var i = 0; i < data.length; i++) {
                payhourTotal += data.totalhours;
            }

            let totalData = ["Total: ", "", "", "", "", payhourTotal];
            return [totalData]; //2 dimensional array.
        }

5

Help for ParamQuery Pro / SummaryData not working

« on: January 05, 2022, 07:13:19 pm »

Hi,

I am trying to implement summary data at the bottom of grid (or Column total).

Paramquery is on the modal and I have the below code for paramquery to be shown on the modal.

   $("#modal_" + $this.variables.vModal).on("shown.bs.modal", function () {
                $this.variables.vGrid.refresh();
    });

Paramquery is working okay but doesn't show the total numbers.
(it caculates the total nubmers correctly in log but not showing the total numbers on the summary line.)
I can see the summary line but nothing shown up there.

Please help!




                    let obj = {
                        showTop: false,
                        height: 350,
                        resizable: true,
                        filterModel: { on: true, mode: "AND", header: false },
                        swipeModel: { on: 'touch' },
                        stripeRows: false,
                        editable: false,
                        dataModel: { data: responseData },
                        colModel: $this.variables.colM,
                        numberCell: { show: false },
                        wrap: true,
                        hwrap: true,
                        sortModel: { ignoreCase: true },
                        scrollModel: { autoFit: false },
                        menuIcon: true,
                        postRenderInterval: -1,
                        create: function () {
                            const $grid = this;
                            $.getJSON("/core/get/getParamQueryState?query=" + $this.variables.vPqGrid, function (response) {
                                $grid.loadState({ state: JSON.parse(response), refresh: true });
                            });
                        }
                    }

                    $this.variables.vGrid = pq.grid("#collectionSummaryGrid", obj);
                    $this.variables.vGrid.option('summaryData', $this.calculateSummary());

6

Help for ParamQuery Pro / Re: How to change sheet name when export excel with multiple tabs

« on: September 28, 2021, 06:18:59 am »

Hi ,

I am using ultimate version of SDK correctly.

what I mean is that if I am using multiple tabs, how can I change sheename for each when I export it.

If I don't use tab and only using single table, sheetName works correctly but not sure how it can be applied to multiple tabs.

Thanks,

7

Help for ParamQuery Pro / How to change sheet name when export excel with multiple tabs

« on: September 26, 2021, 04:49:07 pm »

Hi,

I am trying to implement tabs with pivot and data (example : https://paramquery.com/pro/demos/pivot_tabs)

When I export to excel, I want to set sheetname as tabs but it only states as 'ParamQuery Eval 1'.. 'ParamQuery Eval 2'

sheetName does not work here and please help...

8

Help for ParamQuery Pro / Hide the label for count of child data

« on: September 26, 2021, 11:43:31 am »

Hi,

Is there any way to hide the lable for count of child data in group row in pivot?

e.g. it displays as ... Argentina (16) <-- count of child data... but I just want to display as ... Argentina .