set_col_currency()

  • Parameter(s):
    • $col_name: column name
    • $prefix: currency prefix. The default is USD symbol, $
    • $suffix: currency suffix. The default is blank.
    • $thousandsSeparator: The character as the thousands separator. The default is the comma character “,”.
    • $decimalSeparator: The character as the decimal separator. The default is the dot character.
    • $decimalPlaces: The number of digital is displayed after the decimal point. The default is two.
    • $defaultValue: The value display when the value return from database is null or empty string. The default is 0.00
  • Description:
    • This is helper method to display currency value. It formats column as currency when displayed. The value is automatically unformatted during CRUD operations.
  • Example:
1
$dg -> set_col_currency("price", "EUR", "", ",", 2, "0.00");

How to enter comma as decimal separator during data entry

The function set_col_currency() is a specialized formatter for displaying currency only. During data entry, it is still required to use the dot/period symbol is as the decimal separator.

To allow some countries that use a comma (,) instead of decimal to indicate that separation, a common workaround is replacing “,” with “.” as soon as “,” is entered during data entry using jqGridAddEditAfterShowForm event handler that evokes onkeyup javascript keyboard event.

1
2
3
4
5
6
$afterShowForm = <<<AFTERSHOWFORM
function (){
    $("#MSRP").attr("onkeyup","replacekomma()");
}
AFTERSHOWFORM
;
$dg->add_event("jqGridAddEditAfterShowForm", $afterShowForm);