<?php

namespace Database\Seeders;

use Illuminate\Database\Seeder;
use Illuminate\Support\Facades\DB;

class ExchangeRateSeeder extends Seeder
{
    /**
     * Run the database seeds.
     */
    public function run(): void
    {
                //Franc CFA
        //Same currency
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 1,
            'source_currency_id' => 1,
            'destination_currency_id' => 1,
        ]);

        DB::table('exchange_rates')->insert([
            'exchange_rate' => 0.0015,
            'source_currency_id' => 1,
            'destination_currency_id' => 2,
        ]);

        //Franc CFA to American Dollars
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 0.0016,
            'source_currency_id' => 1,
            'destination_currency_id' => 3,
        ]);

        //Franc CFA to Canadian dollar
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 0.0022,
            'source_currency_id' => 1,
            'destination_currency_id' => 4,
        ]);

        //Franc CFA to Swiss franc
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 0.0014,
            'source_currency_id' => 1,
            'destination_currency_id' => 5,
        ]);

        //Franc CFA to Pound sterling
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 0.0013,
            'source_currency_id' => 1,
            'destination_currency_id' => 6,
        ]);

        //Franc CFA to Rand
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 0.030,
            'source_currency_id' => 1,
            'destination_currency_id' => 7,
        ]);

        //Franc CFA to Tunisian dinar
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 0.00509,
            'source_currency_id' => 1,
            'destination_currency_id' => 8,
        ]);


                    //EURO
        //EURO to XAF
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 655.96,
            'source_currency_id' => 2,
            'destination_currency_id' => 1,
        ]);

        //Same currency
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 1,
            'source_currency_id' => 2,
            'destination_currency_id' => 2,
        ]);

        //EURO to American Dollars
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 1.06,
            'source_currency_id' => 2,
            'destination_currency_id' => 3,
        ]);

        //EURO to Canadian dollar
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 1.45,
            'source_currency_id'  => 2,
            'destination_currency_id' => 4,
        ]);

        //EURO to Swiss franc
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 0.95,
            'source_currency_id' => 2,
            'destination_currency_id' => 5,
        ]);

        //EURO to Pound sterling
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 0.87,
            'source_currency_id' => 2,
            'destination_currency_id' => 6,
        ]);

        //EURO to Rand
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 20.14,
            'source_currency_id' => 2,
            'destination_currency_id' => 7,
        ]);

        //EURO to Tunisian dinar
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 3.36,
            'source_currency_id' => 2,
            'destination_currency_id' => 8,
        ]);


                //USD
        //USD to XAF
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 618.56,
            'source_currency_id' => 3,
            'destination_currency_id' => 1,
        ]);

        //USD to EURO
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 0.94,
            'source_currency_id' => 3,
            'destination_currency_id' => 2,
        ]);

        //Same currency
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 1,
            'source_currency_id' => 3,
            'destination_currency_id' => 3,
        ]);

        //USD to Canadian dollar
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 1.37,
            'source_currency_id' => 3,
            'destination_currency_id' => 4,
        ]);

        //USD to Swiss franc
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 0.89,
            'source_currency_id' => 3,
            'destination_currency_id' => 5,
        ]);

        //USD to Pound sterling
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 0.82,
            'source_currency_id' => 3,
            'destination_currency_id' => 6,
        ]);

        //USD to Rand
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 18.39,
            'source_currency_id' => 3,
            'destination_currency_id' => 7,
        ]);

        //USD to Tunisian dinar
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 3.17,
            'source_currency_id' => 3,
            'destination_currency_id' => 8,
        ]);


                    //CAD
        //CAD to XAF
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 450.47,
            'source_currency_id' => 4,
            'destination_currency_id' => 1,
        ]);

        //CAD to EURO
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 0.69,
            'source_currency_id' => 4,
            'destination_currency_id' => 2,
        ]);

        //CAD to American Dollars
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 0.73,
            'source_currency_id' => 4,
            'destination_currency_id' => 3,
        ]);

        //Same currency
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 1,
            'source_currency_id' => 4,
            'destination_currency_id' => 4,
        ]);

        //CAD to Swiss franc
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 0.65,
            'source_currency_id' => 4,
            'destination_currency_id' => 5,
        ]);

        //CAD to Pound sterling
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 0.60,
            'source_currency_id' => 4,
            'destination_currency_id' => 6,
        ]);

        //CAD to Rand
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 13.40,
            'source_currency_id' => 4,
            'destination_currency_id' => 7,
        ]);

        //CAD to Tunisian dinar
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 2.31,
            'source_currency_id' => 4,
            'destination_currency_id' => 8,
        ]);


                    //CHF
        //CHF to XAF
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 692.67,
            'source_currency_id' => 5,
            'destination_currency_id' => 1,
        ]);

        //CHF to EURO
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 1.06,
            'source_currency_id' => 5,
            'destination_currency_id' => 2,
        ]);

        //CHF to American Dollars
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 1.12,
            'source_currency_id' => 5,
            'destination_currency_id' => 3,
        ]);

        //CHF to Canadian dollar
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 1.54,
            'source_currency_id' => 5,
            'destination_currency_id' => 4,
        ]);

        //Same currency
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 1,
            'source_currency_id' => 5,
            'destination_currency_id' => 5,
        ]);

        //CHF to Pound sterling
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 0.92,
            'source_currency_id' => 5,
            'destination_currency_id' => 6,
        ]);

        //CHF to Rand
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 20.60,
            'source_currency_id' => 5,
            'destination_currency_id' => 7,
        ]);

        //CHF to Tunisian dinar
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 3.55,
            'source_currency_id' => 5,
            'destination_currency_id' => 8,
        ]);


                    //GBP
        //GBP to XAF
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 751.62,
            'source_currency_id' => 6,
            'destination_currency_id' => 1,
        ]);

        //GBP to EURO
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 1.15,
            'source_currency_id' => 6,
            'destination_currency_id' => 2,
        ]);

        //GBP to American Dollars
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 1.22,
            'source_currency_id' => 6,
            'destination_currency_id' => 3,
        ]);

        //GBP to Canadian dollar
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 1.66,
            'source_currency_id' => 6,
            'destination_currency_id' => 4,
        ]);

        //GBP to Swiss franc
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 1.09,
            'source_currency_id' => 6,
            'destination_currency_id' => 5,
        ]);

        //Same currency
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 1,
            'source_currency_id' => 6,
            'destination_currency_id' => 6,
        ]);

        //GBP to Rand
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 22.35,
            'source_currency_id' => 6,
            'destination_currency_id' => 7,
        ]);

        //GBP to Tunisian dinar
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 3.85,
            'source_currency_id' => 6,
            'destination_currency_id' => 8,
        ]);


                    //ZAR
        //ZAR to XAF
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 33.63,
            'source_currency_id' => 7,
            'destination_currency_id' => 1,
        ]);

        //ZAR to EURO
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 0.051,
            'source_currency_id' => 7,
            'destination_currency_id' => 2,
        ]);

        //ZAR to American Dollars
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 0.054,
            'source_currency_id' => 7,
            'destination_currency_id' => 3,
        ]);

        //ZAR to Canadian dollar
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 0.072,
            'source_currency_id' => 7,
            'destination_currency_id' => 4,
        ]);

        //ZAR to Swiss franc
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 0.049,
            'source_currency_id' => 7,
            'destination_currency_id' => 5,
        ]);

        //ZAR to Pound sterling
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 0.045,
            'source_currency_id' => 7,
            'destination_currency_id' => 6,
        ]);

        //Same currency
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 1,
            'source_currency_id' => 7,
            'destination_currency_id' => 7,
        ]);

        //ZAR to Tunisian dinar
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 0.17,
            'source_currency_id' => 7,
            'destination_currency_id' => 8,
        ]);


                    //TND
        //TND to XAF
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 195.36,
            'source_currency_id' => 8,
            'destination_currency_id' => 1,
        ]);

        //TND to EURO
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 0.30,
            'source_currency_id' => 8,
            'destination_currency_id' => 2,
        ]);

        //TND to American Dollars
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 0.32,
            'source_currency_id' => 8,
            'destination_currency_id' => 3,
        ]);

        //TND to Canadian dollar
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 0.43,
            'source_currency_id' => 8,
            'destination_currency_id' => 4,
        ]);

        //TND to Swiss franc
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 0.28,
            'source_currency_id' => 8,
            'destination_currency_id' => 5,
        ]);

        //TND to Pound sterling
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 0.26,
            'source_currency_id' => 8,
            'destination_currency_id' => 6,
        ]);

        //TND to Rand
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 5.81,
            'source_currency_id' => 8,
            'destination_currency_id' => 7,
        ]);

        //Same currency
        DB::table('exchange_rates')->insert([
            'exchange_rate' => 1,
            'source_currency_id' => 8,
            'destination_currency_id' => 8,
        ]);


    }
}
