Laravel Pivot with multiple values

Question

I am trying to build a (slightly complex) subscription service using Laravel.

The subscriptions would be of the type: Breakfast Subscription for 20 breakfasts to be used within 30 days of enrolment.

For example, If user enrols for the breakfast subscription on 1st of April, he can avail for any 20 days of his choice, until April 30.

I've made the following tables and corresponding Models:

User Model and table

Users: 
- id
- name
- email
etc

Subscriptions table and Model

Subscriptions: 
- id
- name
- price
- validity 
- meals_available

subscription_user pivot (?) table with softDeletes

- subscription_id
- user_id
- start_date
- end_date
- created_at
- updated_at
- deleted_at

I've updated the corresponding models with belongsToMany relations ships

User:

class User extends Authenticatable
{
     ...
    /*
     * User can have many subscriptions
     */

    public function subscriptions()
    {
        return $this->belongsToMany('App\Subscription')->withTimestamps();
    }
}

Subscriptions Model

class Subscription extends Model
{
     ...
    /*
     * Subscription can have many Users
     */

    public function users()
    {
        return $this->belongsToMany('App\User')->withTimestamps();
    }
}

Issues that I need help with 1. Is the database/model structure correct way to solve the problem?

While I can use attach() and detach() methods, I am not able to fill in start_date and end_date values in the subscription_table. How to do this?
I want to use soft deletes on the pivot table. How I can use it?

Thanks in Advance.

Jose Rojas · Accepted Answer · 2016-04-22 20:11:28Z

1

To set a value from the pivot table you can use :

$user->subscriptions()->updateExistingPivot($subscriptionId, ['start_date' => '2016-01-01', 'end_date' => '2016-01-01']);

or

$user->subscriptions()->attach([1 => ['start_date' => '2016-01-01', 'end_date' => '2016-01-01'], 2, 3]);

and to use softDelete you can use whichever of these methods to update deteled_at and retrieve the data constraining the relationship this way

$this->belongsToMany('App\Subscription')->wherePivot('deleted_at','null');

answered Apr 22, 2016 at 20:11

Jose Rojas

3,5403 gold badges29 silver badges43 bronze badges

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

1 Comment

Santosh Achari Over a year ago

How to fetch a specific record with a specific date?

Santosh Achari · Accepted Answer · 2016-04-22 20:17:00Z

0

Not sure yet.
Attach method with additional columns. set models as:

public function subscriptions()
{
return $this->belongsToMany('App\Subscription')
->withTimestamps()
->whereNull('subscription_user.deleted_at')
->withPivot('start_date','end_date');
}

You can update the rows as

$user->subscriptions()->attach([1 => ['start_date' => '2016-04-01', 'end_date' => '2016-04-30'], 2, 3]);

You can't use detach method for soft deletes. Update using a DB query.

Optionally you may want to add methods like these to retrieve deleted rows for a give user.

 public function subscriptionsWithTrashed()
    {
        return $this->belongsToMany('App\Subscription')->withTimestamps()->withPivot('start_date','end_date');
    }

    public function subscriptionsOnlyTrashed()
    {
        return $this->belongsToMany('App\Subscription')->whereNotNull('subscription_user.deleted_at')->withTimestamps()->withPivot('start_date','end_date');
    }

answered Apr 22, 2016 at 20:17

Santosh Achari

3,0167 gold badges34 silver badges53 bronze badges

1 Comment

Santosh Achari Over a year ago

Yes, a user can subscribe simultaneously to say a Breakfast and Lunch subscription.

Collectives™ on Stack Overflow

Laravel Pivot with multiple values

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related