Messages

1

Suggest new features / Re: Drag drop ability to drag from an entire row or a cell and better drop indicator

« on: October 21, 2024, 05:32:24 pm »

Is there any update in new release?

2

Help for ParamQuery Pro / Issue with Filter Textbox on Android Tablet (Chrome Browser)

« on: October 18, 2024, 09:09:30 pm »

I'm experiencing an issue when using a filter textbox on my Android tablet in the Chrome browser. When I tap on the textbox, the on-screen keyboard briefly pops up but then immediately closes, making it impossible to enter any text.

Has anyone encountered a similar problem? Any suggestions for a fix would be greatly appreciated.

Thanks in advance for your help!

3

Help for ParamQuery Pro / Re: horizontal scroll

« on: January 19, 2024, 03:36:49 pm »

i want, when i open grid it scrolled on right end side

4

Help for ParamQuery Pro / horizontal scroll

« on: January 16, 2024, 11:01:43 pm »

Hello

I am currently working on some task and i have some difficulties regarding horizonatal scrolling,in my grid everyday its create new column and i wanted to show that grid with by default horizontal scroll with right end

please give some solution for that.

thank you.

5

Help for ParamQuery Pro / Re: Export excel hidden column width

« on: January 10, 2024, 07:55:00 pm »

Thanks its wrk

6

Help for ParamQuery Pro / Display grid hidden columns in exported Excel or spreadsheet

« on: January 09, 2024, 08:32:15 pm »

Hello
right now i have facing some issue regarding export to excel,
have some dynamic coulms which are hidden and  that is okay while export its there in export but issue is only column width is 0.

i have tried with set width in colmodel, in eachcell function set manually width but its not working
please give some solution for set hidden column width in export excel

thank you

7

Help for ParamQuery Pro / Re: v9.1.0 bug

« on: December 11, 2023, 06:01:32 pm »

https://jsfiddle.net/hirakwebguru/ot57shnq/18/

please check above jsfiddle

8

Help for ParamQuery Pro / ColModel return object

« on: November 20, 2023, 09:27:43 pm »

In column model

Code: [Select]

filter: {                     
crules: [{condition: 'range'}],
gridOptions: {
stripeRows: false,
filterModel: {header: false}
},
options: [                 
{"": lang.allTxt},
{"0:1": "days <= 1"},
{"1:7": "1 < days <= 7"},
{"7:14": "7 < days <= 14"},
{"14:21": "14 < days <= 21"},
{"21:30": "21 < days <= 30"}
],
//override range compare.
conditions: {
range: {
compare: function (cellData, val) {
console.log("cellData", cellData, "val", val);
return true;
}
}
}
}
If cellData is an object it returns a [OBJECT OBJECT] (see red)....

9

Help for ParamQuery Pro / Re: tree grid and dragg and drop

« on: September 25, 2023, 06:35:18 pm »

Thank you very much its work nice but i wanted to do drag and drop with selected row
becuse right now its dragg and drop with left column 1st column

i wanted to click and hold selected row and then drag and drop

10

Help for ParamQuery Pro / Re: tree grid and dragg and drop

« on: September 21, 2023, 09:07:48 pm »

Thank you very much

11

Help for ParamQuery Pro / tree grid and dragg and drop

« on: September 19, 2023, 04:37:18 pm »

Here i would like to attach my video of tree view grid with drag and drop features
#================
1 - Ctrl + click ------ select multiple rows
2 - click select ------ drag and drop
3-  multiple selected --- drag and drop
4-  could have drag and drop any root node or child node
5- single click select row
6- colleps and expand features

please check below link video

https://drive.google.com/file/d/1fzVtEwdC053lcX15TBlKv-HGcj2h0XpX/view?usp=drive_link

thank you

12

Help for ParamQuery Pro / Re: Move row selection along with focus

« on: August 08, 2023, 07:59:30 pm »

yes row selectiion is work but i wanted to select multiple row if poosible select with shift or ctrl key like
with shift key select bunch of row and ctrl key select multiple rows from grid

13

Help for ParamQuery Pro / Drag and drop selected rows

« on: August 08, 2023, 07:50:09 pm »

Hello
How to set drag and drop bunch of selected rows?

https://paramquery.com/pro/demos/dnd_group

above link is working but only single row at time and I wanted to drag and drop selected bunch of rows.

thank you

14

Bug Report / Re: type datetime render

« on: August 01, 2023, 08:11:48 pm »

i have did it some other way please check below

Code: [Select]

eachCell:function(cell, ci, ri, column, rowData){
// get the orininal cell value;
cell["value"] = rowData[ column["dataIndx"] ];

// set date format to  create date , out date, and return date
if([ "OUT_DATE", "RETURN_DATE"].includes(cell.dataIndx))
{
var date = empty(cell["value"]) ? false : moment(cell["value"]),
days = date ? date.diff("1900/01/01", "days")+2 : false,
converted = date ? days + ((date.second() + (date.minute()*60) + (date.hour()*60*60)) / 86400) : false;
cell["format"] = "dd/mm/yyy";
if(converted)
cell.value = converted;
}
}

Initially we can set all kind of formats through this
please if we can get better way to render dates and other formats, it will be very fine.....

15

Help for ParamQuery Pro / Move row selection along with focus

« on: July 21, 2023, 03:20:34 pm »

1 - can navigate the row using keyboard like up/down arrow key or home/end button in the grid with selection  ?
2- In the format, it would be nice to have an extra option of nested with "lft" & "rgt" fields
3- tree grid filter issue - blow code ref. error in attach image

Code: [Select]

$("#tree").pqGrid({
            dataModel: {data: []},
            colModel : [
                {dataIndx:"TITLE", title:lang.itemTxt, halign:"center", sortable:false,
                    filter:{crules:[{condition: 'contain'}], style:"text-align:left;"},
                    render:function(ui){
                        return that.render_node_txt(ui);
                    }
                },
                ....
            ],
           
            numberCell: {show: false}, // The left number cell index column off
            animModel: {on: true, duration: 290}, // Turn on animation
            stripeRows: true, // Show stripes
            menuIcon: false,
            scrollModel:{autoFit:true}, // show scroll
            flex: {on:true}, // Width of headers auto fit
            width: "100%",
            dragColumns: {enabled:false},
            // DISPLAY
            hoverMode: "row", // on hover change color effect
            showTitle: false, // Hide table title
            wrap: false, // Cell content on one line
            hwrap: false, // header content on one line
            showTop: false, // Hide top  (including col move icons)
            selectionModel: {type:"row", mode:"single", column:false, all:false}, // Select rows
            editable: false, // not able to edit
            sortable: false,
            //virtualWin: true,    // Faster rendering - Causes a crash in TreeGrid
            rowInit: function(ui){
                var cls = "";
                // Is there anything left to assign
                if(
                    intval(ui.rowData["TYPE"])!==0 && intval(ui.rowData["TYPE"])!==5 &&
                    typeof(that.data.assigned)==="object" && !empty(ui.rowData["item_index"]) && typeof(that.data.assigned[ ui.rowData["item_index"] ])!=="undefined"
                )
                {
                    // Have all items been assigned
                    if(floatval(that.data.assigned[ ui.rowData["item_index"] ]) >= floatval(ui.rowData["QUANTITY"]))   
                        cls = "silvertext";
                    // Has every ordered item been checked out (none assigned, but all out)
                    else if(
                        typeof(that.data.quantities)==="object" && !empty(ui.rowData["index"]) && typeof(that.data.quantities[ ui.rowData["index"] ])!=="undefined" &&
                        floatval(that.data.quantities[ ui.rowData["index"] ]["remain"]) <= 0
                    )
                        cls = "silvertext";
                }
                // Return a class
                return {
                    cls: cls
                };
            },
            // filter colums
            filterModel: {
                on: true,
                header: true,
                menuIcon: false
            },
            // Tree
            treeModel: {
                dataIndx: "TITLE",           
                id: "item_index",
                filterShowChildren: true,
                icons: true,
                render: function(ui){
                    // If the item is an autopull, the icon is grey
                    var autopull = empty(ui.rowData["AUTOPULL"]) ? "" : " silvertext";
                    switch(intval(ui.rowData["TYPE"])) { // 4 = labour & 6=calculated (both not used here)
                        case 1: // Consumable
                            return {iconCls: "ui-icon-cart-b"+autopull};
                            break;
                        case 2: // Stock
                            return {iconCls: "ui-icon-gear"+autopull};
                            break;
                        case 3: // Custom
                            return {iconCls: "ui-icon-radio-off"+autopull};
                            break;
                        case 4: // Labour (not used)
                            return {iconCls: "ui-icon-person"+autopull};
                            break;
                        case 5: // Comment
                            return {iconCls: "ui-icon-comment"+autopull};
                            break;
                        case 6: // Calculated (not used)
                            return {iconCls: "ui-icon-calculator-b"+autopull};
                            break;
                    }
                }
            }
        });
    },