沃梦达 / 编程问答 / php问题 / 正文

L5.6 - 数据透视表的关系

L5.6 - Relation on pivot table(L5.6 - 数据透视表的关系)

本文介绍了L5.6 - 数据透视表的关系的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我在枢轴表上有一个关系;我如何扩展它?

I've a relation on a pivot table; how I can expand It?

例如:

商店:

  • id
  • 姓名

产品:

  • id
  • 姓名

product_shop:

  • product_id
  • shop_id
  • field_1
  • field_2
  • field_3
  • table_A_id

table_A:

  • id
  • 姓名

Shops 模型中的多对多关系是:

The relation Many-to-Many in the Shops Model is:

class Shops extends Model {
    public function products()
    {
        return $this->belongsToMany('Products', 'product_shop', 'product_id', 'shop_id')->withPivot(
            'field_1',
            'field_3',
            'field_3',
            'table_A_id'
            )
            ->as('product_shop')
            ->withTimestamps();
    }

}

检索所有数据的查询是:

and the query to retrieve all data is:

class GetData extends Model {
     public static function getAll() {
         $query = Shops::with(
            'products'
            )->get();
     }
}

这会返回product_shop.table_A_id,但我想扩展外键并检索table_A.name;有办法吗?

This return the product_shop.table_A_id but I'd like to expand the foreign key and retrieve table_A.name; is there a way?

谢谢.

推荐答案

您可以使用枢轴模型:

class ProductShopPivot extends IlluminateDatabaseEloquentRelationsPivot
{
    public function tableA()
    {
        return $this->belongsTo(TableA::class);
    }
}

class Shops extends Model
{
    public function products()
    {
        return $this->belongsToMany('Products', 'product_shop', 'product_id', 'shop_id')
            ->withPivot(
                'field_1',
                'field_3',
                'field_3',
                'table_A_id'
            )
            ->as('product_shop')
            ->withTimestamps()
            ->using(ProductShopPivot::class);
    }
}

然后像这样访问它:

$shop->product_shop->tableA->name

不幸的是,没有办法预先加载 tableA 关系.

Unfortunately, there is no way to eager load the tableA relation.

这篇关于L5.6 - 数据透视表的关系的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持编程学习网!

本文标题为:L5.6 - 数据透视表的关系

基础教程推荐