Messages

76

Help for ParamQuery Pro / Re: Another select editor problem

« on: October 29, 2021, 07:18:10 am »

It will be better to let cell keep the original value when user choses nothing in select and clicks other cell( no mater it is editable cell or uneditable cell).

77

Help for ParamQuery Pro / Another select editor problem

« on: October 28, 2021, 06:38:36 pm »

When I clicked the select editor cell, the select editor will not disappear untill a editable cell is clicked. Even an uneditable cell is clicked, the select element is still there, and the original value in the select editor cell is cleared, this really make trouble when user clicks select editor cell occasionally.

78

Help for ParamQuery Pro / Re: select editor problem

« on: October 28, 2021, 06:32:46 pm »

I have setup a new project in which there is only pqGrid code, the problem disappeared, it seems there are some other js framework which conflicted with pqGrid. It is really a headache.  I got lost

79

Help for ParamQuery Pro / Re: select editor problem

« on: October 28, 2021, 11:49:24 am »

I have put all css and js file into the project as follow, but problem is still unsolved.

<script src="assets/plugins/jquery/jquery.min.js"></script>
 <link href="assets/plugins/paramquery811/jquery-ui-1.12.1/jquery-ui.min.css" rel="stylesheet" />
 <link href="assets/plugins/paramquery811/jquery-ui-1.12.1/jquery-ui.structure.css" rel="stylesheet" />
 <link href="assets/plugins/paramquery811/jquery-ui-1.12.1/jquery-ui.theme.css" rel="stylesheet" />
<link href="assets/plugins/paramquery811/pqgrid.min.css" rel="stylesheet" />

<link href="assets/plugins/paramquery811/pqgrid.ui.min.css" rel="stylesheet" />
<link rel="stylesheet" href="assets/plugins/paramquery811/themes/office/pqgrid.css" />
<script src="assets/plugins/paramquery811/jquery-ui-1.12.1/jquery-ui.min.js"></script>

<script src="assets/plugins/paramquery811/pqgrid.min.js"></script>
<link rel="stylesheet" href="assets/plugins/paramquery811/pqSelect/pqselect.min.css" />

<script src="assets/plugins/paramquery811/pqSelect/pqselect.min.js"></script>
<script src="assets/plugins/paramquery811/pqTouch/pqTouch.min.js"></script>
<script src="assets/plugins/paramquery811/localize/pq-localize-zh.js"></script>
<script src="assets/plugins/paramquery811/jsZip-2.5.0/jszip.min.js"></script>
<script src="assets/plugins/paramquery811/jsZip-utils-0.0.2/jszip-utils.min.js"></script>
<script src="assets/plugins/paramquery811/javascript-detect-element-resize/jquery.resize.js"></script>
<script src="assets/plugins/paramquery811/javascript-detect-element-resize/detect-element-resize.js"></script>

For I could not access jsfiddle website, I have to setup a new project for pqGrid(to avoid other js framework disturbing it ) only to find reason.
Or you can recommend a remote control software to find the problem by connecting my computer.

80

Help for ParamQuery Pro / Re: select editor problem

« on: October 27, 2021, 06:52:32 pm »

Even when click text cells, there are problems in "price" column as attached picture.

81

Help for ParamQuery Pro / Re: select editor problem

« on: October 27, 2021, 06:19:39 pm »

I add the pqSelect.min.js and pqselect.min.css files into my project, but there are still the same problems in browser. The error infos are as follow when I click the select editoe cells:
pqgrid.min.js:11 Uncaught TypeError: Cannot read properties of undefined (reading 'focus')
    at t.<computed>.<computed>.a._editCell (pqgrid.min.js:11)
    at t.<computed>.<computed>.<anonymous> (pqgrid.min.js:11)
    at pqgrid.min.js:10
    at pq.cRenderBody.scrollXY (pqgrid.min.js:20)
    at pq.cRenderBody.scrollCell (pqgrid.min.js:20)
    at t.<computed>.<computed>.a.scrollCell (pqgrid.min.js:10)
    at t.<computed>.<computed>.a.editCell (pqgrid.min.js:11)
    at t.<computed>.<computed>.a._onClickCell (pqgrid.min.js:10)

When I add these CSS code in pqselect.min.css,


    .pq-grid .pq-editor-focus
    {
        outline:none;
        border:1px solid #bbb;   
        border-radius:6px;
        background-image: linear-gradient(#e6e6e6, #fefefe);

        filter: progid:DXImageTransform.Microsoft.gradient(startColorstr='#e6e6e6', endColorstr='#fefefe');
        background: -webkit-gradient(linear, left top, left bottom, from(#e6e6e6), to(#fefefe));
        background: -moz-linear-gradient(top,  #e6e6e6,  #fefefe); /* for firefox 3.6+ */          
    }

there are more error info in console as follow:
pqgrid.min.js:19 Uncaught TypeError: Cannot read properties of undefined (reading '0')
    at t.<computed>.<computed>.<anonymous> (pqgrid.min.js:19)
    at n (pqgrid.min.js:9)
    at t.<computed>.<computed>.e._trigger (pqgrid.min.js:9)
    at t.<computed>.<computed>.a.quitEditMode (pqgrid.min.js:11)
    at t.<computed>.<computed>.a._editCell (pqgrid.min.js:11)
    at t.<computed>.<computed>.<anonymous> (pqgrid.min.js:11)
    at pqgrid.min.js:10
    at pq.cRenderBody.scrollXY (pqgrid.min.js:20)
    at pq.cRenderBody.scrollCell (pqgrid.min.js:20)
    at t.<computed>.<computed>.a.scrollCell (pqgrid.min.js:10)

pqgrid.min.js:12 Uncaught TypeError: pq.getFn(...).call is not a function
    at t.<computed>.<computed>.i.callFn (pqgrid.min.js:12)
    at t.<computed>.<computed>.a._editCell (pqgrid.min.js:11)
    at t.<computed>.<computed>.<anonymous> (pqgrid.min.js:11)
    at pqgrid.min.js:10
    at pq.cRenderBody.scrollXY (pqgrid.min.js:20)
    at pq.cRenderBody.scrollCell (pqgrid.min.js:20)
    at t.<computed>.<computed>.a.scrollCell (pqgrid.min.js:10)
    at t.<computed>.<computed>.a.editCell (pqgrid.min.js:11)
    at t.<computed>.<computed>.a._onClickCell (pqgrid.min.js:10)
    at HTMLDivElement.<anonymous> (pqgrid.min.js:10)

82

Help for ParamQuery Pro / Re: select editor problem

« on: October 27, 2021, 08:25:21 am »

in this line, column is not declared, is it will make trouble?

                var grid = this,
                    column;

if it should be
                var grid = this;
                 var  column;

83

Help for ParamQuery Pro / select editor problem

« on: October 27, 2021, 08:04:50 am »

When using  select editor, the select element is unworkable(there is no select in grid), would you like to check my code to find problem?

    $(function () {
        //optional function used to create pqSelect and auto open it.
        function initSelect(ui) {
            ui.$cell.find("select").pqSelect();
            setTimeout(function () {
                ui.$cell.find("select").pqSelect('open');
            })
        }
        var colModel = [
            { title: "ID", width: 100, dataIndx: "id", editable: false },
            { title: "Unit", dataIndx: "goodsUnit",  width: 120,
                editor: {
                    type: "select",
                    init: initSelect,
                    options: []
                },
                validations: [
                    { type: 'minLen', value: 1, msg: "Required" }
                ]
            },
            { title: "Name", dataIndx: "name", editable: false },
       { title: "Price", dataIndx: "price", width: 110  }
      ];
        var dataModel = {
            dataType: "JSON",
            location: "remote",
            method: "GET",           
            url: "/demo/jbolttable/normalEditable5Datas"
        }
        $("div#grid_editing").pqGrid({
            colModel: colModel,
            create: function (evt, ui) {
                var grid = this,
                    column;
                //fetch options for ShipCountry column from server.
                $.getJSON("/admin/dictionary/datas?typeId=1&keywords=", function (response) {
                    column = grid.getColumn({ dataIndx: 'goodsUnit' });
                    column.editor.options = response;
                });

            },
            dataModel: dataModel,
            editModel: {
                saveKey: $.ui.keyCode.ENTER,
                keyUpDown: false,
                clicksToEdit: 1
            },
            historyModel: { checkEditable: false },
            numberCell: { show: false },
            resizable: true,
            scrollModel: { autoFit: true },           
            showBottom: false,
            title: "Shipping Orders <b>(Custom editing)</b>"
        });
    });


Here is the error log:
pqgrid.min.js:19 Uncaught TypeError: Cannot read properties of undefined (reading '0')
    at t.<computed>.<computed>.<anonymous> (pqgrid.min.js:19)
    at n (pqgrid.min.js:9)
    at t.<computed>.<computed>.e._trigger (pqgrid.min.js:9)
    at t.<computed>.<computed>.a.quitEditMode (pqgrid.min.js:11)
    at t.<computed>.<computed>.a._editCell (pqgrid.min.js:11)
    at t.<computed>.<computed>.<anonymous> (pqgrid.min.js:11)
    at pqgrid.min.js:10
    at pq.cRenderBody.scrollXY (pqgrid.min.js:20)
    at pq.cRenderBody.scrollCell (pqgrid.min.js:20)
    at t.<computed>.<computed>.a.scrollCell (pqgrid.min.js:10)
(anonymous) @ pqgrid.min.js:19
n @ pqgrid.min.js:9
e._trigger @ pqgrid.min.js:9
a.quitEditMode @ pqgrid.min.js:11
a._editCell @ pqgrid.min.js:11
(anonymous) @ pqgrid.min.js:11
(anonymous) @ pqgrid.min.js:10
scrollXY @ pqgrid.min.js:20
scrollCell @ pqgrid.min.js:20
a.scrollCell @ pqgrid.min.js:10
a.editCell @ pqgrid.min.js:11
a._onClickCell @ pqgrid.min.js:10
(anonymous) @ pqgrid.min.js:10
dispatch @ jquery.min.js:2
y.handle @ jquery.min.js:2
Show 15 more frames
pqgrid.min.js:12 Uncaught TypeError: pq.getFn(...).call is not a function
    at t.<computed>.<computed>.i.callFn (pqgrid.min.js:12)
    at t.<computed>.<computed>.a._editCell (pqgrid.min.js:11)
    at t.<computed>.<computed>.<anonymous> (pqgrid.min.js:11)
    at pqgrid.min.js:10
    at pq.cRenderBody.scrollXY (pqgrid.min.js:20)
    at pq.cRenderBody.scrollCell (pqgrid.min.js:20)
    at t.<computed>.<computed>.a.scrollCell (pqgrid.min.js:10)
    at t.<computed>.<computed>.a.editCell (pqgrid.min.js:11)
    at t.<computed>.<computed>.a._onClickCell (pqgrid.min.js:10)
    at HTMLDivElement.<anonymous> (pqgrid.min.js:10)
i.callFn @ pqgrid.min.js:12
a._editCell @ pqgrid.min.js:11
(anonymous) @ pqgrid.min.js:11
(anonymous) @ pqgrid.min.js:10
scrollXY @ pqgrid.min.js:20
scrollCell @ pqgrid.min.js:20
a.scrollCell @ pqgrid.min.js:10
a.editCell @ pqgrid.min.js:11
a._onClickCell @ pqgrid.min.js:10
(anonymous) @ pqgrid.min.js:10
dispatch @ jquery.min.js:2
y.handle @ jquery.min.js:2
Show 12 more frames
pqgrid.min.js:11 Uncaught TypeError: Cannot read properties of undefined (reading 'focus')
    at t.<computed>.<computed>.a._editCell (pqgrid.min.js:11)
    at t.<computed>.<computed>.<anonymous> (pqgrid.min.js:11)
    at pqgrid.min.js:10
    at pq.cRenderBody.scrollXY (pqgrid.min.js:20)
    at pq.cRenderBody.scrollCell (pqgrid.min.js:20)
    at t.<computed>.<computed>.a.scrollCell (pqgrid.min.js:10)
    at t.<computed>.<computed>.a.editCell (pqgrid.min.js:11)
    at t.<computed>.<computed>.a._onClickCell (pqgrid.min.js:10)
    at HTMLDivElement.<anonymous> (pqgrid.min.js:10)
    at HTMLDivElement.dispatch (jquery.min.js:2)
a._editCell @ pqgrid.min.js:11
(anonymous) @ pqgrid.min.js:11
(anonymous) @ pqgrid.min.js:10
scrollXY @ pqgrid.min.js:20
scrollCell @ pqgrid.min.js:20
a.scrollCell @ pqgrid.min.js:10
a.editCell @ pqgrid.min.js:11
a._onClickCell @ pqgrid.min.js:10
(anonymous) @ pqgrid.min.js:10
dispatch @ jquery.min.js:2
y.handle @ jquery.min.js:2
Show 11 more frames
pqgrid.min.js:11 Uncaught TypeError: Cannot read properties of undefined (reading 'focus')
    at t.<computed>.<computed>.a._editCell (pqgrid.min.js:11)
    at t.<computed>.<computed>.<anonymous> (pqgrid.min.js:11)
    at pqgrid.min.js:10
    at pq.cRenderBody.scrollXY (pqgrid.min.js:20)
    at pq.cRenderBody.scrollCell (pqgrid.min.js:20)
    at t.<computed>.<computed>.a.scrollCell (pqgrid.min.js:10)
    at t.<computed>.<computed>.a.editCell (pqgrid.min.js:11)
    at t.<computed>.<computed>.a._onClickCell (pqgrid.min.js:10)
    at HTMLDivElement.<anonymous> (pqgrid.min.js:10)
    at HTMLDivElement.dispatch (jquery.min.js:2)
a._editCell @ pqgrid.min.js:11
(anonymous) @ pqgrid.min.js:11
(anonymous) @ pqgrid.min.js:10
scrollXY @ pqgrid.min.js:20
scrollCell @ pqgrid.min.js:20
a.scrollCell @ pqgrid.min.js:10
a.editCell @ pqgrid.min.js:11
a._onClickCell @ pqgrid.min.js:10
(anonymous) @ pqgrid.min.js:10
dispatch @ jquery.min.js:2
y.handle @ jquery.min.js:2
Show 11 more frames

84

Help for ParamQuery Pro / Re: save change triggered error

« on: October 20, 2021, 01:03:16 pm »

It's really make a little trouble.

85

Help for ParamQuery Pro / Re: save change triggered error

« on: October 20, 2021, 06:14:39 am »

A new trouble come, afterI added the js patch, when other web page(without pgGrid) which use tooltips.js could not work.

jquery.min.js:2 Uncaught Error: no such method 'dispose' for tooltip widget instance
    at Function.error (jquery.min.js:2)
    at HTMLAnchorElement.<anonymous> (jquery-ui.min.js:6)
    at Function.each (jquery.min.js:2)
    at w.fn.init.each (jquery.min.js:2)
    at w.fn.init.t.fn.<computed> [as tooltip] (jquery-ui.min.js:6)
    at disposeTooltip (jbolt-admin.min.js?v=20211008101928009:2)
    at Object.openBy (jbolt-admin.min.js?v=20211008101928009:34)
    at HTMLAnchorElement.<anonymous> (jbolt-admin.min.js?v=20211008101928009:34)
    at HTMLBodyElement.dispatch (jquery.min.js:2)
    at HTMLBodyElement.y.handle (jquery.min.js:2)

86

Help for ParamQuery Pro / Re: save change triggered error

« on: October 19, 2021, 05:23:53 pm »

Thank you very much, it works.

87

Help for ParamQuery Pro / Re: save change triggered error

« on: October 19, 2021, 11:01:10 am »

jQuery v3.3.1
 <link href="assets/plugins/paramquery811/jquery-ui-1.12.1/jquery-ui.min.css" rel="stylesheet" />
<script src="assets/plugins/paramquery811/jquery-ui-1.12.1/jquery-ui.min.js"></script>

88

Help for ParamQuery Pro / save change triggered error

« on: October 18, 2021, 06:54:21 pm »

when I pressed the "save change" button in pqGrid of my own page, there are errors in Chrome console. I don't know how to fix it.  The error info in console are as follow:
tooltip.js:756 Uncaught TypeError: No method named "open"
    at HTMLDivElement.<anonymous> (tooltip.js:756)
    at Function.each (jquery.min.js:2)
    at w.fn.init.each (jquery.min.js:2)
    at w.fn.init.t._jQueryInterface [as tooltip] (tooltip.js:740)
    at e.cValid.onScrollCell (pqgrid.min.js:9)
    at t.<computed>.<computed>.<anonymous> (pqgrid.min.js:9)
    at pqgrid.min.js:10
    at pq.cRenderBody.scrollXY (pqgrid.min.js:20)
    at pq.cRenderBody.scrollCell (pqgrid.min.js:20)
    at t.<computed>.<computed>.a.scrollCell (pqgrid.min.js:10)
(anonymous) @ tooltip.js:756
each @ jquery.min.js:2
each @ jquery.min.js:2
t._jQueryInterface @ tooltip.js:740
onScrollCell @ pqgrid.min.js:9
(anonymous) @ pqgrid.min.js:9
(anonymous) @ pqgrid.min.js:10
scrollXY @ pqgrid.min.js:20
scrollCell @ pqgrid.min.js:20
a.scrollCell @ pqgrid.min.js:10
isValidCell @ pqgrid.min.js:9
isValid @ pqgrid.min.js:9
isValid @ pqgrid.min.js:9
a.isValid @ pqgrid.min.js:10
a.isValidChange @ pqgrid.min.js:10
saveChanges @ normalEditable2:295
(anonymous) @ pqgrid.min.js:13
dispatch @ jquery.min.js:2
y.handle @ jquery.min.js:2

89

Help for ParamQuery Pro / Re: Customize attribute of save changes json object

« on: October 18, 2021, 05:01:41 pm »

if I change attribute of pqGrid Json like you showed, should I changed the following code in sample?

                    success: function (changes) {
                        //debugger;
                        grid.commit({ type: 'add', rows: changes.addList });
                        grid.commit({ type: 'update', rows: changes.updateList });
                        grid.commit({ type: 'delete', rows: changes.deleteList });

                        grid.history({ method: 'reset' });
                    },

90

Help for ParamQuery Pro / Re: Can we add new row with keyboard?

« on: October 16, 2021, 04:19:14 pm »

It will be a very useful feature, if it is inbuilt.