jQuery Grid Plugin - jqGrid

Thanks Tony,

That looks to be just the job. I tried it quickly but couldn't get it to work - what version to I need to be running for this?

Cheers

Romyn

Hi,

The relevant bits are:-

The col model:

{name:'sdelay', index:'sdelay', width:60, align:'center',editable:true, editoptions:{dataInit:function(el){$(el).mask(”99:99:99″);}, defaultValue:'00:00:00'}, formatter: fmt_HMS, unformat: unfmt_HMS},

The format function:

var fmt_HMS = function(cellval,options,rowdata) {
    formatted_cellval = secsToHMS(cellval);
    return formatted_cellval;
}

The unformat function:

var unfmt_HMS = function(cellval,options) {
    unformatted_cellval = HMSToSecs(cellval);
    return unformatted_cellval;
}

Support functions:

function HMSToSecs(duration) {
    var d_array = duration.split(”:”);
    var s = (parseInt(d_array[0],10)*3600) + (parseInt(d_array[1],10)*60) + parseFloat(d_array[2]);
    return s;
}

function secsToHMS(secs) {
var h = parseInt(secs/3600,10);
var m = parseInt((secs-(3600*h))/60,10);
var s = parseInt((secs-(3600*h)-(60*m)),10);
var hms = PadDigits(h,2) + ':' + PadDigits(m,2) + ':' + PadDigits(s,2);
return hms;
}

PadDigits just adds leading 0's when needed – and the .mask is a masked edit plugin.

I believe I'm running the last version for which a min'ed pack was available – not the latest from GitHub – it doesn't even get into the unformat function (an alert in there doesn't fire) so this could be why.

Romyn

I've just downloaded the latest pack again (not the GitHub one) and it is different so I'm not completely up-to-date on that by the looks of things.

However using the latest a TreeGrid I have gets stuck on “Loading” so something has changed in that that I need to fix first – new syntax or something?

I'll try and do that and then see if the unformat function gets called. (Can't get to it until I fix the TreeGrid as that is the launch point for the other grids with the meat in them)

Regards

Romyn

edit - just seen your other reply. Thx - I'll download again in a few days.

I'll admit to being pretty confused myself now.

I've downloaded the latest GitHub files and made the changes to how the functions are defined - (don't know where the var versions came from - must have been done that way in the examples I used).

Anyway with those changes made I'm still having some trouble. The ideal scenario I want to get to is to store as Seconds, display as HH:MM:SS and edit using a Mask in the for __:__:__

To that end I've put together a simple page with a grid that has various differently configured columns - and celleditting enabled so just clicking in and out of the cell should show the effects.

http://www.thekmz.co.uk/GEPlug.....dtest4.htm

Simple - no formatting at all

fmt - just the formatter

fmt/unfmt - formatter and unformatter

fmt/mask - formatter and mask

fmt/unfmt/mask - formatter, unformatter and mask

The fmt/unfmt column works as designed (except when the value is 0 which I can't suss out?) - but I want to then add the mask to that but that doesn't seem to work. I also appreciate that some of the columns shouldn't work correctly but they are there just to show how I build up through adding the various options)

(also tried the var myval = $(cellval).html(); thing you mentioned but that didn't work for me at all so I went back to the old style).

Sorry this is so confused but it reflects the state of my little brain...

(I might be better off going back to storing the value as a HH:MM:SS string but I want to avoid that if I can)

Regards

Romyn