Xataface Forums

I was wondering how to correctly use 'money_format' in my fields.ini file? I have read the wiki pages and cannot get it to function. I've been trying this:

[ListPrice]
money_format('%i', $ListPrice)

That should get me USD. I am actually looking for it to display in the format of $xxx,xxx.

Can anyone tell me what I am doing wrong?

Thanks!

I don't believe this directive is in 1.3.x... It is marked as requiring version 2.0 which isn't released yet.

The syntax would be something like:

Code: Select all

[ListPrice]
money_format="%i"


In 1.3.x you could achieve the same thing by implementing a ListPrice__display() method in your delegate class as follows:

Code: Select all

function ListPrice__display($record){
    return money_format('%i', $record->val('ListPrice'));
}


-Steve

Thanks Steve,

I tried the following in my /tables/SALE/SALE.php:

Code: Select all

<?php
function ListPrice__display($record){
    return money_format('%i', $record->val('ListPrice'));
}
?>

and php is generating this error:

Code: Select all

Fatal error: Class 'tables_SALE' not found in [rootPATHomitted]xataface/Dataface/Table.php on line 1116

Not sure what's happening.

That function has to be defined inside the table delegate class.
Please read the following section of the getting started guide for more info on how to create a table delegate class:
http://xataface.com/documentation/tutor ... te_classes

Thank you.

I was missing the class tables statement:

class tables_SALE {

However, the format function is not behaving as I'd like it to (I'm sure it is acting correctly as it is programmed, I need to modify the function.

It now displays the price as "5000.00". I am looking for it to display as "$5000".

Thanks for your help

Check out the php documentation page for money_format. There are some examples there.
http://www.php.net/money_format

The money_format will depend on the locale that is set. Sometimes I just use the number_format() function instead, and prepend a '$' to it.

-Steve

I use the following:

For version 1.5.x or 2.x, in fields.ini:

Code: Select all

[ListPrice]
locale = "en_US"
money_format = "%n"


For version 1.3.x, in the table delegate class:

Code: Select all

function ListPrice__display($record){
    setlocale(LC_MONETARY, 'en_US');
    return money_format('%n', $record->val('ListPrice'));
}

The %n (instead of %i) in this case prepends the '$', although Steve's solution to add it manually and use number_format instead may be easier if you only need to consider USD.

Thanks Adobkin!

The function you create works fine.

Is it possible to have it omit the decimals. All my values are whole numbers for the field in question.

Thanks again

Yes, you need the right precision parameter. Try the string "%.0n" as your money_format value. For more details, see:

http://php.net/money_format

Alan

Fantastic.

Thank you, Alan!!

-Rich

I am trying to format the output on my custom function. The following is from a table delegate function section.

Code: Select all

$childOrigListPrice = money_format('%.0n', $child->val('OrigListPrice'));

However, when I call $childOrigListPrice in my content array, the number is not formatted.

Any Ideas?

SOLVED

Missing the following

Code: Select all

setlocale(LC_MONETARY, 'en_US')