Search options (Page 1 of 2)

@joe, as a workaround this is what I did for another website that needed the  money_format() function.

A proper refactoring to a supported library/function would be preferred, but this works as an interim solution.

Hope this helps

money_format.php

<?php

/**
* Implementation of money_format function for platforms that do not
* implictly support it
*
*
* @link       paulshipley.com.au
* @since      1.0.0
* @see        https://www.php.net/manual/en/function.money-format.php
*
* @package    Winesbydesign
* @subpackage Winesbydesign/includes
*/

if (!function_exists('money_format')) {
    /*
    That it is an implementation of the function money_format for the
    platforms that do not it bear.

    The function accepts to same string of format accepts for the
    original function of the PHP.

    (Sorry. my writing in English is very bad)

    The function is tested using PHP 5.1.4 in Windows XP
    and Apache WebServer.
    */
    function money_format($format, $number)
    {
        $regex  = '/%((?:[\^!\-]|\+|\(|\=.)*)([0-9]+)?'.
        '(?:#([0-9]+))?(?:\.([0-9]+))?([in%])/';
        if (setlocale(LC_MONETARY, 0) == 'C') {
            setlocale(LC_MONETARY, '');
        }
        $locale = localeconv();
        preg_match_all($regex, $format, $matches, PREG_SET_ORDER);
        foreach ($matches as $fmatch) {
            $value = floatval($number);
            $flags = array(
            'fillchar'  => preg_match('/\=(.)/', $fmatch[1], $match) ?
            $match[1] : ' ',
            'nogroup'   => preg_match('/\^/', $fmatch[1]) > 0,
            'usesignal' => preg_match('/\+|\(/', $fmatch[1], $match) ?
            $match[0] : '+',
            'nosimbol'  => preg_match('/\!/', $fmatch[1]) > 0,
            'isleft'    => preg_match('/\-/', $fmatch[1]) > 0
            );
            $width      = trim($fmatch[2]) ? (int)$fmatch[2] : 0;
            $left       = trim($fmatch[3]) ? (int)$fmatch[3] : 0;
            $right      = trim($fmatch[4]) ? (int)$fmatch[4] : $locale['int_frac_digits'];
            $conversion = $fmatch[5];

            $positive = true;
            if ($value < 0) {
                $positive = false;
                $value  *= -1;
            }
            $letter = $positive ? 'p' : 'n';

            $prefix = $suffix = $cprefix = $csuffix = $signal = '';

            $signal = $positive ? $locale['positive_sign'] : $locale['negative_sign'];
            switch (true) {
                case $locale["{$letter}_sign_posn"] == 1 && $flags['usesignal'] == '+':
                    $prefix = $signal;
                    break;
                case $locale["{$letter}_sign_posn"] == 2 && $flags['usesignal'] == '+':
                    $suffix = $signal;
                    break;
                case $locale["{$letter}_sign_posn"] == 3 && $flags['usesignal'] == '+':
                    $cprefix = $signal;
                    break;
                case $locale["{$letter}_sign_posn"] == 4 && $flags['usesignal'] == '+':
                    $csuffix = $signal;
                    break;
                case $flags['usesignal'] == '(':
                case $locale["{$letter}_sign_posn"] == 0:
                    $prefix = '(';
                    $suffix = ')';
                    break;
            }
            if (!$flags['nosimbol']) {
                $currency = $cprefix .
                ($conversion == 'i' ? $locale['int_curr_symbol'] : $locale['currency_symbol']) .
                $csuffix;
            } else {
                $currency = '';
            }
            $space  = $locale["{$letter}_sep_by_space"] ? ' ' : '';

            $value = number_format($value, $right, $locale['mon_decimal_point'],
            $flags['nogroup'] ? '' : $locale['mon_thousands_sep']);
            $value = @explode($locale['mon_decimal_point'], $value);

            $n = strlen($prefix) + strlen($currency) + strlen($value[0]);
            if ($left > 0 && $left > $n) {
                $value[0] = str_repeat($flags['fillchar'], $left - $n) . $value[0];
            }
            $value = implode($locale['mon_decimal_point'], $value);
            if ($locale["{$letter}_cs_precedes"]) {
                $value = $prefix . $currency . $space . $value . $suffix;
            } else {
                $value = $prefix . $value . $space . $currency . $suffix;
            }
            if ($width > 0) {
                $value = str_pad($value, $width, $flags['fillchar'], $flags['isleft'] ?
                STR_PAD_RIGHT : STR_PAD_LEFT);
            }

            $format = str_replace($fmatch[0], $value, $format);
        }
        return $format;
    }
}

Based on this post and the wiki (https://frontaccounting.com/fawiki/index.php?n=Devel.CronJobSample), I have written a complete script for updating the exchange rates via cron. Be sure to change the 'user' & 'password' at the end of the script to a valid account that has FA security to access the Exchange Rates function. Creating a cron entry should be trivial.

The setup in the first part of the script would be a good template for other batch tasks, though it is not possible to call functions that are expecting a display to be present, which does limit what processes can be performed via cron.

Hope this helps

xr_load.php (assuming that this is in FA root directory)

<?php
/**********************************************************************
*
* Load current day Exchange Rates from external provider using cron
*
* run using:
* cd <fa root dir>
* php xr_load.php
*
***********************************************************************/

// set environment
$path_to_root=".";
$page_security = 'SA_EXCHANGERATE';

// configure fake server environment for cron
$_SERVER = array();
$_SERVER['REMOTE_ADDR']='batch';
$_SERVER['HTTP_USER_AGENT']='cron';
$_SERVER['REQUEST_URI']='';
$_SERVER['HTTPS']='';
define('FA_LOGOUT_PHP_FILE', 'cronjob');
include_once($path_to_root . "/includes/session.inc");
install_hooks();

// load rates function
include_once($path_to_root . "/includes/date_functions.inc");
include_once($path_to_root . "/includes/banking.inc");

/**
*
* Load Exchange Rates from external provider
*
* @param {object} $company The FA Company to by loaded
* @param {object} $usr     FA User
* @param {object} $pwd     FA Password
*
* @return
*
*/
function xr_load($company, $usr, $pwd)
{
    global $_SESSION;

    $_SESSION['wa_current_user']->login($company,$usr,$pwd);

    $date_ = Today();

    foreach (get_currencies() as $curr) {
        $curr_abrev = $curr['curr_abrev'];

        if (!is_company_currency($curr_abrev)) {
            $BuyRate = maxprec_format(retrieve_exrate($curr_abrev, $date_));

            if (get_date_exchange_rate($curr_abrev, $date_) == 0)
            {
                add_exchange_rate($curr_abrev, $date_, $BuyRate, $BuyRate);
            } else {
                update_exchange_rate($curr_abrev, $date_, $BuyRate, $BuyRate);
            }
        }
    }
}

// load rates
xr_load(0,'user',password');

Hi Nikunj, Poncho and others,

My extension is primarily to format the layout of the invoice to meet Australian Taxation Office (ATO) requirements, so I don't believe it will do what you are looking for. It might be possible to use a similar approach to develop an Indian GST Invoice but I am not an accountant or familiar with Indian tax law.

Hope this helps.

Paul

Thanks. Let me know if there are any issues. I have tried to make as few changes as possible that meets the ATO requirements.

I'm not sure if this could be made generic as each jurisdiction has it's own requirements. For example the ATO insists that all references are to 'GST', whereas the UK uses 'VAT'. I suspect that there would have to be several versions (eg: Australia, UK, India, USA, etc.) Happy to discuss further ideas.

I'm getting the same message (warning?) with code version 2.4.4 (de943e150d36f815a02d4996e532a5e4e7510bc8) and PHP 7.2.3 (XAMPP 2018-03-14) with debugging on.

This message seems to be related to trying to change the ini setting after the session has started, which was being silently ignored in earlier versions of PHP but is now being reported. Refer https://stackoverflow.com/questions/48209844/ini-set-fails-to-set-session-variables-php-7-2-0-and-higher

I propose that the ini_set be moved before the new SessionManager() [as follows]

-------------------------------------------------------
includes/session.inc | 5 ++++-
1 file changed, 4 insertions(+), 1 deletion(-)

diff --git a/includes/session.inc b/includes/session.inc
index 3f8c525d..779dc4e6 100644
--- a/includes/session.inc
+++ b/includes/session.inc
@@ -394,6 +394,9 @@ function login_timeout()
    if (file_exists($path_to_root.'/'.$ext['path'].'/hooks.php'))
        include_once($path_to_root.'/'.$ext['path'].'/hooks.php');
}
+
+ini_set('session.gc_maxlifetime', 36000); // 10hrs
+
$Session_manager = new SessionManager();
$Session_manager->sessionStart('FA'.md5(dirname(__FILE__)));

@@ -429,7 +432,7 @@ function login_timeout()
*/
// ini_set('session.save_path', VARLIB_PATH.'/');

-ini_set('session.gc_maxlifetime', 36000); // 10hrs
+// ini_set('session.gc_maxlifetime', 36000); // 10hrs

hook_session_start(@$_POST["company_login_name"]);
-------------------------------------------------------

Thanks.