laravel select with pivot table code example
Example 1: laravel pivot select fields
public function products()
{
return $this->belongsToMany('\Duplicolor\Models\Product\Line', 'project_products', 'project_post_id', 'product_line_id')->withPivot('id');
}
Example 2: laravel pivot table model
public function customer(){
return $this->belongsToMany('customer')->withPivot(
'start_date',
'stop_date',
'rem_date',
'due_date',
'status'
);
}
public function services(){
return $this->belongsToMany('Service')->withPivot(
'start_date',
'stop_date',
'rem_date',
'due_date',
'status'
);
}
public function staff(){
return $this->belongsToMany('Staff');
}
public function custservs(){
return $this->belongsToMany('Custserv');
}
Schema::create('customer_service_user', function(Blueprint $table)
{
$table->increments('id');
$table->integer('customer_service_id')->unsigned()->index();
$table->foreign('customer_service_id')->references('id')->on('customer_service')->onDelete('cascade');
$table->integer('staff_id')->unsigned()->index();
$table->foreign('staff_id')->references('id')->on('staff')->onDelete('cascade');
$table->timestamps();
});