ParamQuery grid support forum
General Category => Help for ParamQuery Pro => Topic started by: altyra on November 22, 2019, 10:22:26 pm
-
Hi,
I have an issue, i need to introduce the date in my paramquery with the format "dd-mm-yyyy", but the only solutions i am finding are to change the date from "mm-dd-yyyy" to "dd-mm-yyyy" and everytime i try to put "dd-mm-yyyy" it clears my text, is there anyway that i can introduce the format that i want from the start?
Thamk you for your time
-
Initially the date data types should be in "mm/dd/yy" or "yy-mm-dd" format in json data.
https://paramquery.com/pro/api#option-column-dataType
If your dates are in "dd-mm-yy" format initially, you can convert them into "mm/dd/yy" format in dataModel.getData callback with help of jQueryUI datepicker methods $.datepicker.parseDate( format, value) and $.datepicker.formatDate(format, val)
Then set column.format = "dd-mm-yy"
Rest is same as done for "OrderDate" column in this demo: https://paramquery.com/pro/demos/editing_custom
-
But the main problem is that i cant even introduce the date with the format "dd-mm-yyyy" it automatically clears out my text, in my context i need to copy/past a larger portion of data into my paramquery.
Thank you for your time
-
Also in case of copy / paste the dates should be in "mm/dd/yy" or "yy-mm-dd" format.
If pasted dates are in any other format, then they have to be converted to above format in beforePaste event:
https://paramquery.com/pro/api#event-beforePaste
Please let me know if you need further assistance on this.
-
Now my code looks like this and works perfectly
beforePaste: function (evt, ui) {
//sanitize pasted data.
var CM = this.getColModel(),
rows = ui.rows,
area = ui.areas[0],
c1 = area.c1;
for (var i = 0; i < rows.length; i++) {
var row = rows[i];
for (var j = 0; j < row.length; j++) {
var column = CM[j + c1],
dt = column.dataType;
if (dt == "date") {
var $m = row[j].match(/^(\d+)-(\d+)-(\d+)$/);
var $new = $m[2] + "-" + $m[1] + "-" + $m[3];
row[j] = $new;
}
}
}
},
But i have one last question, is there a way to do the same but with the cell click and cell submit?
-
is there a way to do the same but with the cell click and cell submit?
cell click doesn't change the data in grid.
can you please elaborate it a little bit?
-
When i click to edit the cell it displays the date as "mm-dd-yy" and i want to change it to the format "dd-mm-yy", and when i submit the changes to the cell transform it back in to the format "mm-dd-yy" so that it can be recognized by the grid as a valid date.
I am thinking of using the functions beforeFillHandle (to display) and cellBeforeSave (to save) to achieve these results, but i am having trouble applying them, could you send me an example or should i use other functions?
Thak you for your time once again.
-
That's quite simple, you have to define column format as "dd-mm-yy" and define dateEditor as in this demo:
https://paramquery.com/pro/demos/editing_custom
jsfiddle: https://jsfiddle.net/nby2arfk/1/