2

I'm working on an application that accepts various payment methods via different payment providers.

One of the payment methods is Mobile Money. Mobile Money is accepted in a number of different countries and I have a settings table that holds the different mobile networks and currencies for each country.

All countries only accept one currency but can have different mobile networks.

For example, Ireland could have two different mobile networks and one currency.

My database structure is as follows:

payment_methods

id name
1 Mobile Money

countries

id name iso_code
1 Ireland IE
2 UK UK

country_payment_method

id country_id payment_method_id is_active
1 1 1 true
2 2 1 true

mobile_networks

id name
1 Eir
2 Three
3 02

currencies

id name code
1 Euro EUR
2 Pound GBP

payment_method_configurations

id country_payment_method_id config_key config_value
1 1 mobile_network_id 1
2 1 mobile_network_id 2
3 1 currency_id 1
4 2 mobile_network_id 2
5 2 mobile_network_id 3
6 2 currency_id 2

My question is, how do I access the configurations for a country/payment_method using either Eloquent relationship or DB query if I know the country?

Improve this question

2 Answers 2

Reset to default
1

You can do this using laravel eloquant. First create these modals

Country, PaymentMethod, CountryPaymentMethod, PaymentMethodConfiguration

And then create these relationships inside modals.

// Country.php public function countryPaymentMethods() { return $this->hasMany(CountryPaymentMethod::class); } // PaymentMethod.php public function countryPaymentMethods() { return $this->hasMany(CountryPaymentMethod::class); } // CountryPaymentMethod.php public function configurations() { return $this->hasMany(PaymentMethodConfiguration::class); } public function country() { return $this->belongsTo(Country::class); } public function paymentMethod() { return $this->belongsTo(PaymentMethod::class); } // PaymentMethodConfiguration.php public function countryPaymentMethod() { return $this->belongsTo(CountryPaymentMethod::class); }

And you can query them like this

$country = Country::where('name', 'Ireland')->first(); $paymentMethod = PaymentMethod::where('name', 'Mobile Money')->first(); $configurations = PaymentMethodConfiguration::whereHas('countryPaymentMethod', function ($query) use ($country, $paymentMethod) { $query->where('country_id', $country->id) ->where('payment_method_id', $paymentMethod->id) ->where('is_active', true); })->get();

Study about this more here

Laravel - Eloquent "Has", "With", "WhereHas" - What do they mean?

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

0

you can

  • create a pivot model so you can define "hasMany" and "belongsToMany" off of it.
  • hook that pivot into your Country - PaymentMethod relation
  • fetch

app/Models/CountryPaymentMethod.php

use Illuminate\Database\Eloquent\Relations\Pivot; class CountryPaymentMethod extends Pivot { # all configs (network IDs + currency IDs) public function configurations() { return $this->hasMany(PaymentMethodConfiguration::class, 'country_payment_method_id'); } # only the mobile networks public function mobileNetworks() { return $this->belongsToMany( MobileNetwork::class, 'payment_method_configurations', 'country_payment_method_id', 'config_value' )->wherePivot('config_key', 'mobile_network_id'); } # the single currency public function currency() { return $this->belongsTo( Currency::class, 'config_value' )->wherePivot('config_key', 'currency_id'); } }

app/Models/Country.php

class Country extends Model { public function paymentMethods() { return $this->belongsToMany( PaymentMethod::class, 'country_payment_method' ) ->using(CountryPaymentMethod::class) ->withPivot('is_active'); } }

In controller

$country = Country::where('iso_code', 'IE') ->with(['paymentMethods' => function($q) { $q->where('name', 'Mobile Money') ->with(['mobileNetworks', 'currency']); }])->first(); $pmPivot = $country->paymentMethods->first()->pivot; $networks = $pmPivot->mobileNetworks; # Ex: Eir, Three $currency = $pmPivot->currency; # Ex: Euro
Improve this answer

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.