Server : ApacheSystem : Linux host.digitalbabaji.in 4.18.0-513.11.1.el8_9.x86_64 #1 SMP Wed Jan 17 02:00:40 EST 2024 x86_64 User : addictionfreeind ( 1003) PHP Version : 7.2.34 Disable Function : exec,passthru,shell_exec,system Directory : /home/addictionfreeind/public_html/admin1/app/Console/Commands/ |
Upload File : |
<?php
namespace App\Console\Commands;
use App\Models\Company;
use App\Models\Currency;
use App\Models\GlobalSetting;
use GuzzleHttp\Client;
use Illuminate\Console\Command;
class UpdateExchangeRates extends Command
{
/**
* The name and signature of the console command.
*
* @var string
*/
protected $signature = 'update-exchange-rate';
/**
* The console command description.
*
* @var string
*/
protected $description = 'Updates the exchange rates for all the currencies in currencies table.';
/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
$companies = Company::with(['currencies', 'currency'])->get();
$globalSetting = GlobalSetting::first();
$currencyApiKey = ($globalSetting->currency_converter_key) ?: config('app.currency_converter_key');
$currencyApiKeyVersion = $globalSetting->currency_key_version;
$client = new Client();
foreach ($companies as $company) {
$company->currencies->each(function ($currency) use ($currencyApiKey, $currencyApiKeyVersion, $company, $client) {
$response = $client->request('GET', 'https://' . $currencyApiKeyVersion . '.currconv.com/api/v7/convert?q=' . $company->currency->currency_code . '_' . $currency->currency_code . '&compact=ultra&apiKey=' . $currencyApiKey);
$response = json_decode($response->getBody(), true);
$currency->exchange_rate = $response[$company->currency->currency_code . '_' . $currency->currency_code];
$currency->saveQuietly();
});
}
}
}