截至目前我有2個(gè)不同的ModelProductModel.php這是我的產(chǎn)品清單。ProductRelated.php這是每個(gè)特定產(chǎn)品分配的相關(guān)產(chǎn)品。場(chǎng)景是，如果我id = 1的ProductModel.id (primary key of Product Model)在我的ProductRelated.php我有這個(gè)prodID（這相當(dāng)于id (primary key of Product Model) 這將用于識(shí)別相關(guān)產(chǎn)品被分配的特定產(chǎn)品 ID。prodRelatedID這是與該產(chǎn)品相關(guān)的產(chǎn)品。所以我ProductModel會(huì)有這些數(shù)據(jù) id | prodTitle | prodDesc | More fields here... 1 | Product 1 | Description | More FIeld value here .. 2 | Product 2 | Description | More FIeld value here .. 3 | Product 3 | Description | More FIeld value here ..在我的ProductRelated遺囑中有這些數(shù)據(jù) id | prodID | prodRelatedID | More fields here... 1 | 1 | 2 | More FIeld value here .. 2 | 1 | 3 | More FIeld value here ..這意味著，id = 1來(lái)自ProductModel有 2 個(gè)不同的prodRelatedID這些是2 and 3我這樣做的想法是使用hasMany()這是我的ProductModelnamespace App\Models;use Illuminate\Database\Eloquent\Model;use App\User;class ProductModel extends Model{public $timestamps = true;protected $table = 'product';/** * The attributes that are mass assignable. * * @var array */protected $fillable = [ 'id', 'prodTitle', 'prodDesc', 'prodCategory', 'attachment', 'prodSize', 'prodPrice', 'created_by', 'is_best_seller', 'prod_included', 'prod_instruction',];}我的ProductRelatednamespace App\Models;use Illuminate\Database\Eloquent\Model;use App\User;class ProductRelated extends Model{public $timestamps = true;protected $table = 'product_related';/** * The attributes that are mass assignable. * * @var array */protected $fillable = [ 'id', 'prodID', 'prodRelatedID', 'created_by'];}
1 回答
梵蒂岡之花
TA貢獻(xiàn)1900條經(jīng)驗(yàn) 獲得超5個(gè)贊
如果您只想獲取每個(gè)特定產(chǎn)品的所有相關(guān)產(chǎn)品，我認(rèn)為您不需要ProductRelated。
在你的ProductModel
public function relatedProducts() {
return $this->belongsToMany(ProductModel::class, 'product_related', 'prodID', 'prodRelatedID');
}然后你應(yīng)該能夠獲取所有記錄，如下所示：
$relatedProducts = ProductModel::find(1)->relatedProducts()->get();
- 1 回答
- 0 關(guān)注
- 172 瀏覽
添加回答
舉報(bào)
0/150
提交
取消