Guriddo » Topic: using jqgrid formatter as utility function externally

using jqgrid formatter as utility function externally

Guriddo
using jqgrid formatter as utility function externally

This topic has 4 replies, 2 voices, and was last updated 13 years, 11 months ago by mcslayton.

Creator

Topic
May 9, 2012 at 2:39 pm #79930

mcslayton
Participant

I have occasion when it would be helpful to hook into jqGrid's format matter from outside a jqGrid. Using it to format an integer, number, currency, etc. Something like:

var integerOut = $.fn.fmatter(“integer”, 76543.21);

So integerOut would be equal to '76,543' if in USA after the call.

Can this be done somehow?

What would be the proper calling syntax?
Creator

Topic

Viewing 4 replies - 1 through 4 (of 4 total)

Author

Replies

May 11, 2012 at 2:08 pm #99814

tony

Keymaster

Hello,

This should work, but there is a bug in the formatter checking for colModel format options.

I will fix this and replay when done.

Thanks.

Best Regards

Tony

May 12, 2012 at 2:48 am #99818

mcslayton

Participant

Devised my own solution that allows for formatting integers, numbers and currency using jqGrid's localization configurations:

<br />
function isNumeric(number) {<br />
return !isNaN(parseFloat(number)) &amp;&amp; isFinite(number);<br />
}<br />
function formatInteger(number) {<br />
return isNumeric(number) ? $.fmatter.util.NumberFormat(Math.floor(number), $.jgrid.formatter.integer) : number;<br />
}<br />
function formatNumber(number) {<br />
return isNumeric(number) ? $.fmatter.util.NumberFormat(number, $.jgrid.formatter.number) : number;<br />
}<br />
function formatCurrency(number) {<br />
return isNumeric(number) ? $.fmatter.util.NumberFormat(number, $.jgrid.formatter.currency) : number;<br />
}<br />

function isNumeric(number) {

return !isNaN(parseFloat(number)) && isFinite(number);

}

function formatInteger(number) {

return isNumeric(number) ? $.fmatter.util.NumberFormat(Math.floor(number), $.jgrid.formatter.integer) : number;

}

function formatNumber(number) {

return isNumeric(number) ? $.fmatter.util.NumberFormat(number, $.jgrid.formatter.number) : number;

}

function formatCurrency(number) {

return isNumeric(number) ? $.fmatter.util.NumberFormat(number, $.jgrid.formatter.currency) : number;

}

May 12, 2012 at 9:35 am #99821

tony

Keymaster

Hello,

I just fixed the problem.

https://github.com/tonytomov/jqGrid/commit/b919a66806297a8249114c8f555a526ef57bd88f

You can download the source from GitHub and use it. Please let me know if there is a problem.

Regards

May 13, 2012 at 1:26 am #99825

mcslayton

Participant

Tony,

Thank you that change worked great! I needed the unformat as well so I implemented them as shown below.

Can the unformats be called from $.fn.fmatter somehow as well?

Marv

function isNumeric(number) {<br />
return !isNaN(parseFloat(number)) &amp;&amp; isFinite(number);<br />
}<br />
function formatInteger(number) {<br />
return isNumeric(number)<br />
? $.fn.fmatter("integer", number)<br />
: $.jgrid.formatter.integer.defaultValue;<br />
}<br />
function formatNumber(number) {<br />
return isNumeric(number)<br />
? $.fn.fmatter("number", number)<br />
: $.jgrid.formatter.number.defaultValue;<br />
}<br />
function formatCurrency(number) {<br />
return isNumeric(number)<br />
? $.fn.fmatter("currency", number)<br />
: $.jgrid.formatter.currency.defaultValue;<br />
}<br />
function unformatInteger(number) {<br />
var parts = number.split($.jgrid.formatter.number.decimalSeparator);<br />
var out = parseInt(parts[0].replace(/[^0-9-]/g, &#039;&#039;));<br />
return isNumeric(out) ? out : 0;<br />
}<br />
function unformatNumber(number) {<br />
var op = $.jgrid.formatter.number;<br />
var re = /([.*_&#039;(){}+?])/g;<br />
var sep = op.thousandsSeparator.replace(re, "$1");<br />
var stripTag = new RegExp(sep, "g");<br />
var out = number.replace(stripTag, "").replace(op.decimalSeparator, &#039;.&#039;);<br />
return isNumeric(out) ? out : 0.0;<br />
}<br />
function unformatCurrency(ret) {<br />
var op = $.jgrid.formatter.currency;<br />
var re = /([.*_&#039;(){}+?])/g;<br />
var sep = op.thousandsSeparator.replace(re, "$1");<br />
var stripTag = new RegExp(sep, "g");<br />
if (op.prefix &amp;&amp; op.prefix.length &amp;&amp; ret.indexOf(op.prefix) &gt; -1) {<br />
ret = ret.substr(op.prefix.length);<br />
}<br />
if (op.suffix &amp;&amp; op.suffix.length &amp;&amp; ret.indexOf(op.suffix) &gt; -1) {<br />
ret = ret.substr(0, ret.length - op.suffix.length);<br />
}<br />
ret = ret.replace(stripTag, &#039;&#039;).replace(op.decimalSeparator, &#039;.&#039;);<br />
return isNumeric(ret) ? ret : 0.0;<br />
}<br />
<br />

function isNumeric(number) {

return !isNaN(parseFloat(number)) && isFinite(number);

}

function formatInteger(number) {

return isNumeric(number)

? $.fn.fmatter("integer", number)

: $.jgrid.formatter.integer.defaultValue;

}

function formatNumber(number) {

return isNumeric(number)

? $.fn.fmatter("number", number)

: $.jgrid.formatter.number.defaultValue;

}

function formatCurrency(number) {

return isNumeric(number)

? $.fn.fmatter("currency", number)

: $.jgrid.formatter.currency.defaultValue;

}

function unformatInteger(number) {

var parts = number.split($.jgrid.formatter.number.decimalSeparator);

var out = parseInt(parts[0].replace(/[^0-9-]/g, ''));

return isNumeric(out) ? out : 0;

}

function unformatNumber(number) {

var op = $.jgrid.formatter.number;

var re = /([.*_'(){}+?])/g;

var sep = op.thousandsSeparator.replace(re, "$1");

var stripTag = new RegExp(sep, "g");

var out = number.replace(stripTag, "").replace(op.decimalSeparator, '.');

return isNumeric(out) ? out : 0.0;

}

function unformatCurrency(ret) {

var op = $.jgrid.formatter.currency;

var re = /([.*_'(){}+?])/g;

var sep = op.thousandsSeparator.replace(re, "$1");

var stripTag = new RegExp(sep, "g");

if (op.prefix && op.prefix.length && ret.indexOf(op.prefix) > -1) {

ret = ret.substr(op.prefix.length);

}

if (op.suffix && op.suffix.length && ret.indexOf(op.suffix) > -1) {

ret = ret.substr(0, ret.length - op.suffix.length);

}

ret = ret.replace(stripTag, '').replace(op.decimalSeparator, '.');

return isNumeric(ret) ? ret : 0.0;

}

Author

Replies

Viewing 4 replies - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.

Stay connected with us in your favorite flavor!

using jqgrid formatter as utility function externally

Search Forum

Recent Replies

Forum Statistics

UserOnline