Messages

1

Help for ParamQuery Pro / Rich text or html editor for cells

« on: July 03, 2024, 06:16:44 pm »

Hi !
I figure out the idea to call an html editor on edit event of an html cell.

Does thios idez looks creepy ? Any idea of what kind of editor using ?

Did someone already try to do this and how ?

Thanks in advance

2

Help for ParamQuery Pro / Refresh return an error log : Cannot read properties of undefined (reading 'bind

« on: May 31, 2024, 08:27:03 pm »

Hi !
Complete log is:
Uncaught TypeError: Cannot read properties of undefined (reading 'bind')
    at A.callXHR (pqgrid.min.js:9:62743)
    at A.remoteRequest (pqgrid.min.js:9:63069)
    at A.refreshDataAndView (pqgrid.min.js:9:66121)
    at V.<computed>.<computed>.refresh (pqgrid.min.js:9:59938)
    at t._trigger (pqgrid.min.js:9:10940)
    at HTMLSpanElement.<anonymous> (pqgrid.min.js:9:35850)
    at HTMLSpanElement.<anonymous> (pqgrid.min.js:9:36930)
    at HTMLSpanElement.dispatch (jquery-3.7.1.min.js:2:40035)
    at v.handle (jquery-3.7.1.min.js:2:38006)

Any idea how I can fix that ?

3

Suggest new features / interface wsStyle

« on: September 21, 2023, 01:15:15 pm »

It would be great to add a cls option to interface wsStyle,
to allow to add some specific style for some cell, like beeing able to use rotation and different writing mode.

4

Help for ParamQuery Pro / Is this possible to export grid in PDF if grid have more than 1 tab

« on: September 20, 2023, 08:22:59 pm »

Everything is in the title, when I try, I receive a huge error from pdfMake

5

Help for ParamQuery Pro / Re: importWb return error

« on: September 15, 2023, 05:24:41 pm »

It works !!!

Thanks !!

6

Help for ParamQuery Pro / Re: importWb return error

« on: September 15, 2023, 02:22:08 pm »

I already add it,
hereunder the object code :

obj = {
        height: 700,
        width: '100%',
        scrollModel: {
            autoFit: 1,
        },
        wrap: 1,
        autofill: 1,
        numberCell: {
            show: 0,
        },
        showHeader: 1,
        showToolbar: 1,
        showTop: 1,
        resizable: 1,
        columnBorders: 0,
        collapsible: 0,
        freezeCols: 0,
        autoAddRow: 1,
        autoAddCol: 1,
        rowBorders: 0,
        stripeRows: 0,
        selectionModel: {
            type: 'cell',
        },
        editable: 1,
        editor: {
            style: {
                width: 1,
            },
        },
        showTitle: 0,
        fillHandle: 'all',
        filterModel: {
            hideRows: 1,
        },
        sortModel: {
            on: 0,
        },
        autoRowHead: 1,
        autoRow: 1,
        toolbar: {
            items: [{
                type: 'button',
                label: 'Export Excel',
                cls: 'ui-button ui-widget ui-state-default ui-corner-all ui-button-text-only',
                listener: exportXlsx,
            }, {
                type: 'button',
                label: 'Export PDF',
                cls: 'ui-button ui-widget ui-state-default ui-corner-all ui-button-text-only',
                listener: exportPDF,
            }, ],
        },
        complete: function() {
            window.dispatchEvent(new Event('resize'));
        },
       
        editModel: {
            addDisableCls: 1,
        },
        tabModel: {
            tabs: [],
        },
    };

But it's not working,

I notice that tabs are situated in a div .pq-tabs-strip, into the div .pq-grid-bottom, in my case   the div .pq-tabs-strip do not exist.

Any idea ?

7

Help for ParamQuery Pro / Re: importWb return error

« on: September 15, 2023, 12:58:03 pm »

Thanks It works

Only one thing, my wb json contain 2 "spreadsheet" tabs, I understood that tabs management relay to Ultimate or Enterprise package, I switch to ultimate.

Once json loaded, only the first tab appear. Withpout mention, and not the second one.

Any clue to fix it ??

8

Help for ParamQuery Pro / importWb return error

« on: September 14, 2023, 11:29:35 pm »

Hi !

I am trying to use importWb method without any success, original goal was to create a json var create a new grid, facing some issus, I came back to the most basic and unique exemple provided here :
https://paramquery.com/pro/api#method-importWb
But I always came back with the following error :

jquery-3.7.1.min.js:2 Uncaught TypeError: h.forEach is not a function
    at m.getRulesFromCM (pqgrid.min.js:9:196910)
    at m.filterLocalData (pqgrid.min.js:9:194997)
    at t._onDataAvailable (pqgrid.min.js:9:134996)
    at A.refreshDataAndView (pqgrid.min.js:9:63066)
    at E.cImport.importWb (pqgrid.min.js:9:267790)
    at E.pqGrid.importWb ....

Any idea to fix my issue, do I operate something wrong ??

Thanks in advance

9

Help for ParamQuery Pro / Re: Title or Heading of the column

« on: August 21, 2023, 03:55:33 pm »

Work liike a charm !

Much thanks !!

10

Help for ParamQuery Pro / Title or Heading of the column

« on: August 18, 2023, 10:31:41 pm »

Hi

on https://paramquery.com/pro/api#option-column-title

It is say that Title or Heading of the column. It can be a callback that returns html to be displayed as column title.

I have been trying different way to use a callback function without success.

And I can(t find nowhere a clear exmple,

Is there a way to get one ?

Thank in advance.

11

Help for ParamQuery Pro / column editorr textarea

« on: June 02, 2022, 04:11:14 pm »

Hi param Team !

I have a creepy question, I build a grid for translation purpose, theres 2 column, and as many row as fields to be translate. The first Row belongs to the orginal text, the second is editable and dedicated to fill with the translation in other language regarding the text on column 1.
The column 2 as of course an editor:
    { type: 'textarea'}.
The traditional result génerated is <textarea name="dataIndx"></textarea>
As the Grid is envelopped in a traditional form, the purpose of the question would be to render the textarea with a custom name="custom_name_relaying_on_text_to_translate".

Any idea how I could achieve this goal, I have been trying to rebuild the textarea with render option, without success.

Thanks for a piece of help if possible

12

Help for ParamQuery Pro / Re: Sequential ajaxRequest with too many records

« on: March 27, 2022, 01:47:36 am »

I solve my probleme !
I learn a lot 

13

Help for ParamQuery Pro / Re: Sequential ajaxRequest with too many records

« on: March 26, 2022, 04:08:38 pm »

Also, I am not sur to understand what the var totalRecords nelongs too ?
Is theres a way to get a kind of sheme on php request side, applying a limit in mysql request limit($pq_rpp, $pq_rpp * $pq_curpage ) increase the response time, but completely paralysed filter.

The goal would be to divide the dataModel request in two, a first one who would initially charge the 100 first records, for a super fast result, and a nother one who would get all opther request silently in the background who would feed the dataModel with all other records.

I am not sure to be super clear.

14

Help for ParamQuery Pro / Sequential ajaxRequest with too many records

« on: March 26, 2022, 01:27:22 am »

Hi !

We have large records in database, so I follow the exemple here : https://paramquery.com/pro/demos/virtual_scroll
Thats works well and It increase the user experience by loading much faster a large amount of data.

I would like to know if there is a way to use pageModel with a type remote at the same time and how to do it ?

15

Help for ParamQuery Pro / refresh method and filter

« on: March 19, 2022, 07:17:26 pm »

Hi Param Team !

I currently have a grid, who offer the ability to choose the diffferent the different header fields ( colModel) the want to display or not. The operation run through an ajax call, who rebuilt the col model affecting hidden or not depending of the quary. Tha ajax call return the new colmodel confoguration.
At this time on success function, I simply apply :
grid.option('colModel', data);
grid.refreshCM();

The probleme I am facing, is that all previous filter applied to the grid are totally reseting.

Any idea regarding an elegant way to refresh the grid by maintaining the selected filter, a little like the "ui-icon ui-icon-refresh" is doing ate the footer of the grid ? Or may I ask something impossible ?

Thanks in advance