Thread Details
  • State Not Answered
  • Replies 2 replies
  • Subscribers 353 subscribers
  • Views 177 views
  • Users 0 members are here
Forum Actions
Related

smarty regex_replace no longer working in PHP8.030 (Smarty 3?)

Francesca Shiekh

in PDF manager I was using a regex_replace to remove the currency symbol (which varies) and check for non-zero shipping costs to print/not print some terms.

{if $fields.annual_shipping_cost_c|regex_replace:"/^./":"" gt 0} print this {/if}

After the upgrade to PHP 8.0.30 this no longer works and always returns true even when the value is $0.00 or empty.

What is the correct way to check for a non zero currency value in smarty?

All the suggestions I am finding online explicitly remove a "$" (or other individual currency symbol) but the currency can be one of four or five different ones and I would much rather have a cleaner solution that checking for each of the allowed currencies.

When tested

{$fields.annual_shipping_cost_c|regex_replace:"/^./":""}

or 

{$fields.annual_shipping_cost_c|regex_replace:"/^[^\d]/":""}

Prints a 

Thanks,
Francesca

Parents
  • 0 Sugar Employee Badge

     Hi  , could share some "input values" for the annual_shipping_cost_c? how about something like:

    {if $fields.annual_shipping_cost_c|regex_replace:"/^[^\d]*([0-9\.]+)/":"$1" gt 0}

    or even yours:

    {if $fields.annual_shipping_cost_c|regex_replace:"/^./":"$1" gt 0} print this {/if}

    SugarCRM | Principal Developer Advocate

  • 0 in reply to Rafael Fernandes

    The values passed in are things like $10.00 or ¥1500.00 

    The idea was to remove the symbol and check the value to see if it was gt 0 and it worked fine until the PHP upgrade in preparation for 13->14 upgrade.

    I tried to do a regexp with the specific currency symbols we use: $, ¥, €, £ but when I save the HTML everything except $ gets replaced with HTML encoding and messes everything up.

    I manage all my PDFManager code in the HTML format (not the WYSIWYG) because i have a customization to use CSS to format the final document (I struggled too hard for too long to get the OOTHB to render properly), but when I save the HTML it sometimes, not always, it converts random things, including quotes,  into HTML encoding, which drives me nuts!

    In the end, after a three hour struggle with every attempt under the sun and every piece of documentation I could find for smarty, I added a calculated Float field that copies the amount and use that to check gt 0 avoiding quotes and symbols.

    Because I'm on premise I can easily copy the amount to that new column for every record with a quick update statement from the back-end.

    I can tell you I am not looking forward to finding an alternative for this, since it doesn't look like DocMerge will fit our needs and PDF manager is becoming less and less reliable.

Reply
  • 0 in reply to Rafael Fernandes

    The values passed in are things like $10.00 or ¥1500.00 

    The idea was to remove the symbol and check the value to see if it was gt 0 and it worked fine until the PHP upgrade in preparation for 13->14 upgrade.

    I tried to do a regexp with the specific currency symbols we use: $, ¥, €, £ but when I save the HTML everything except $ gets replaced with HTML encoding and messes everything up.

    I manage all my PDFManager code in the HTML format (not the WYSIWYG) because i have a customization to use CSS to format the final document (I struggled too hard for too long to get the OOTHB to render properly), but when I save the HTML it sometimes, not always, it converts random things, including quotes,  into HTML encoding, which drives me nuts!

    In the end, after a three hour struggle with every attempt under the sun and every piece of documentation I could find for smarty, I added a calculated Float field that copies the amount and use that to check gt 0 avoiding quotes and symbols.

    Because I'm on premise I can easily copy the amount to that new column for every record with a quick update statement from the back-end.

    I can tell you I am not looking forward to finding an alternative for this, since it doesn't look like DocMerge will fit our needs and PDF manager is becoming less and less reliable.

Children
No Data