dongpa6867
dongpa6867
2019-02-21 14:55
浏览 255
已采纳

Laravel 5.7雄辩地更新/删除多条记录

My table structure is like this:

invoices: 

        id, title, desciption, total_amount, --

products: 

        id, name, price, --

invoice_products

        id, invoice_id, product_id, --
  • One invoice can have multiple products, so,

  • I created an invoice with products, then data fills according to above DB structure.

  • When i update invoice (let say invoice_id = 2 ), then, i am confused what is the best way to update "invoice_products" table.

  • My approach is ( for "invoice_products" table):

    • delete * from invoice_products where invoice_id=2;
    • then insert modified products again.
  • I think this is not good approach, as i am force deleting the rows in "invoice_products" and again inserting new updated products.

  • is there any way to do via eloquent ?

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

2条回答 默认 最新

  • dswqz24846
    dswqz24846 2019-02-21 15:03
    已采纳

    I think invoice_products is pivot table. You should use sync method.

    $productIds = [1,2,3];
    $Invoice->products()->sync($productIds);
    

    Also in your invoice Model the relationship should be like this

    public function products()
    {
        return $this->belongsToMany(Invoice::class, 'invoice_products', 'invoice_id', 'product_id');
    }
    

    More Details

    点赞 评论
  • doukuanghuan7582
    doukuanghuan7582 2019-02-21 15:05

    You can use Laravel many to many relation to achieve this functionality:

    Invoice Model

    public function products()
    {
        return $this->belongsToMany('App\Product', 'invoice_products');
    }
    

    Product Model

    Though it is not required here but you can use this to get invoice for related products.

    public function invoices()
    {
        return $this->belongsToMany('App\Product', 'invoice_products');
    }
    

    To update the existing data you can use sync method:

    $products = [1, 2, 3, 4];
    $invoice->products()->sync($products);
    

    You can read more about relationship over https://laravel.com/docs/5.7/eloquent-relationships

    点赞 评论

相关推荐