Welcome, Guest
Username: Password: Remember me
Forgot your password? Forgot your username? Create an account
Forum
Support forum
Coding inside your component
Formating Grid Decimals - Currency
  • Page:
  • 1

TOPIC:

Formating Grid Decimals - Currency 29 Jul 2021 12:44 #15851

Hi,
I'd like my currency values to hide the cents... so in the Grid - just show $99 and not $99.00.

(All those extra ".00" are taking up valuable width in my List).

I've set these fields to be type Decimal 10,0 - but the 2 decimal places show up in the JCook generated lists. (That could be a bug to fix one day).

In my default_grid.php is this JDom:
echo JDom::_('html.fly.decimal.financial', array(
						'currencyFormat' => '$ %s',
						'dataKey' => 'total_cost',
						'dataObject' => $row,
						'emptyZero' => true
					));

What do I add or change in here?
Just call me Chris :)

Please Log in or Create an account to join the conversation.

Formating Grid Decimals - Currency 02 Aug 2021 09:37 #15852

The decimals property should work - but there is a bug in the JDom.

This is the code that should work - to set the decimal in a financial decimal...
echo JDom::_('html.fly.decimal.financial', array(
						'currencyFormat' => '$ %s',
                                                'decimals' => '0',
						'dataKey' => 'total_cost',
						'dataObject' => $row,
						'emptyZero' => true
					));

But there is a problem with the JDOM code financial.php at line 52 here...

Bad code:
if (empty($this->decimals))
			$this->decimals = 2;

The code sees "decimal = 0" as empty - and defaults to 2 decimal places!

This code needs to be
if (!isset($this->decimals))
			$this->decimals = 2;

To fix this you need to manually edit line 52 of /public_html/libraries/jdom/html/fly/decimal/financial.php
Just call me Chris :)
The following user(s) said Thank You: Romkabouter

Please Log in or Create an account to join the conversation.
  • Page:
  • 1
Forum
Support forum
Coding inside your component
Formating Grid Decimals - Currency
Time to create page: 0.070 seconds
“
”

  Excellent Tool ! This tool will save you a lot of time writing the same old structure. I've used others but this is really nice for a quick start. Makes a 3 hour task a 15 minute one. Thanks for this extension
dickrundell (JED)
         

Get Started

Log In Sign In