Add Live Exchange Rate

[aljawaid]

Found this https://www.exchangerate-api.com/docs/free which does not require an API

• [x] Add helper function to retrive live currency rate from ExchangeRateAPI (will need the currency codes and the last updated I think)
• [x] Show helper function (live rate inc. last updated) in currency/show.php against each kanboard currency code the user has added
• [x] #3
• [x] Use the helper to show the live rate based on the kanboard base currency around other parts of the site

I think the last updated date might be a seperate helper

[aljawaid]

@creecros could you please help?

I have got as far as this:

class LiveRateHelper extends Base
{
    // https://www.exchangerate-api.com/docs/php-currency-api
    // https://www.exchangerate-api.com/docs/free

    public static function getLiveRate($application_currency, $rate_currency)
    {
        // Fetching JSON
        //$req_url = 'https://open.er-api.com/v6/latest/USD';
        $req_url = 'https://open.er-api.com/v6/latest/'.$application_currency;
        $response_json = file_get_contents($req_url);

        // Continuing if we got a result
        if(false !== $response_json) {
            // Try/catch for json_decode operation
            try {
                // Decoding
                $response = json_decode($response_json);

                // Check for success
                if('success' === $response->result) {

                // YOUR APPLICATION CODE HERE, e.g.
                    //$base_price = 1; // Your price in USD
                    // $EUR_price = round(($base_price * $response->conversion_rates->EUR), 2);
                    //$live_rate = round(($base_price * $response->conversion_rates->$rate_currency), 2);

                    $base_currency = $application_currency;
                    foreach ($response as $key => $value) {}
                }

                return $live_rate
            }

            catch(Exception $e) {
            // Handle JSON parse error...
                return 'Error retrieving live rate';
            }
        }
    }
}

I don't know how to do the foreach

This is how I am calling the helper...

<?= $this->helper->liveRateHelper->getLiveRate($application_currency, $rate_currency = $this->text->e($rate['currency'])) ?>

[aljawaid]

ok so I get no errors now but the result is always ZWL and I cant figure out how to do #2 in the same function. would try a new function but there is a rate limit of 24hrs which must be avoided.

Kind of regret deeply into this but I badly need a live currency in kanboard for my daily work

[aljawaid]

its always the last currency code and rate, no matter what i try

[aljawaid]

@creecros any feedback on where i am going wrong?

[aljawaid]

https://stackoverflow.com/questions/75924468/how-can-i-fix-this-helper-function-in-kanboard-to-get-specific-data-from-a-json