doo58088
2018-08-02 06:39
浏览 274
已采纳

Laravel在WhereHas中更新关系列

I wanted to update a column in my model with a wherehas. However, I'm not sure how to do this. Here's my query below

$unused = Sale::whereHas('salesdetails',function($query) {
             $query->where('product_id', '<=', 24)->where('switch', 1);
        })->where(DB::raw("(DATE_FORMAT(transaction_date,'%Y-%m-%d'))"), '<', $now)->update(['switch' => 0]);

Sale Model

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Sale extends Model
{
    protected $table = 'sales';

    protected $primaryKey = 'id';
    public $timestamps = false;

    public function user()
    {
        return $this->belongsTo('App\User', 'member_id', 'id');
    }

    public function guest()
    {
        return $this->belongsTo('App\Guest', 'guest_id', 'id');
    }

    public function salesdetails()
    {
        return $this->hasOne('App\Sales_details','sales_id', 'id');  
    }

    public function discount()
    {
        return $this->hasOne('App\Discount','id', 'discount_id');  
    }
}

Salesdetails Model

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Sales_details extends Model
{
    protected $table = 'sales_details';

    protected $primaryKey = 'id';
    public $timestamps = false;

    public function sale()
    {
        return $this->belongsTo('App\Sale', 'sales_id', 'id');
    }

    public function product()
    {
        return $this->belongsTo('App\Product', 'product_id');
    }


}

In the query above, I want to update all the switches to '0' from the salesdetails relationship. How can I do this one?

图片转代码服务由CSDN问答提供 功能建议

我想用wherehas更新模型中的列。 但是,我不知道该怎么做。 这是我在下面的查询

  $ unused = Sale :: whereHas('salesdetails',function($ query){
 $ query-&gt; where('product_id','  &lt; =',24) - &gt; where('switch',1); 
}) - &gt; where(DB :: raw(“(DATE_FORMAT(transaction_date,'%Y-%m-%d')  )“),'&lt;',$ now) - &gt; update(['switch'=&gt; 0]); 
   
 
 

销售模型

 &lt;?php 
 
namespace App; 
 
use Illuminate \ Database \ Eloquent \ Model; 
 
class Sale扩展Model 
 {
 protected $ table ='  sales'; 
 
 protected $ primaryKey ='id'; 
 public $ timestamps = false; 
 
公共函数user()
 {
返回$ this-&gt; belongsTo('App \ User'  ,'member_id','id'); 
} 
 
公共函数guest()
 {
返回$ this-&gt; belongsTo('App \ Guest','guest_id','id');  
 
 
 
公共函数salesdetails()
 {
返回$ this-&gt; hasOne('App \ Sales_details','sales_id','id');  
 
 
 
公共功能折扣()
 {
返回$ this-&gt; hasOne('App \ Discount','id','discount_id');  
} 
} 
   
 
 

Salesdetails模型

 &lt;?php 
 
namespace App; \  n 
use Illuminate \ Database \ Eloquent \ Model; 
 
class Sales_details扩展Model 
 {
 protected $ table ='sales_details'; 
 
 protected $ primaryKey ='id'; 
 public $ timestamps = false  ; 
 
公共功能销售()
 {
返回$ this-&gt; belongsTo('app \ Sale','sales_id','id'); 
} 
 
公共功能产品()  
 {
返回$ this-&gt; belongsTo('App \ Product','product_id'); 
} 
 
 
} 
   
 
 

在上面的查询中,我想将所有开关从salesdetails关系更新为'0'。 我怎么能这样做?

  • 写回答
  • 好问题 提建议
  • 关注问题
  • 收藏
  • 邀请回答

2条回答 默认 最新

  • dquh37673 2018-08-02 10:15
    已采纳

    Since you are updating the SalesDetails and not the Sale, I would reverse the query so that the update is actually on the SalesDetails instead of the Sale:

    Sales_details::whereHas('sale', function($query) use ($now){
        $query->where(DB::raw("(DATE_FORMAT(transaction_date,'%Y-%m-%d'))"), '<', $now)
    })->where('product_id', '<=', 24)->where('switch', 1)->update(['switch' => 0]);
    
    已采纳该答案
    评论
    解决 无用
    打赏 举报
  • dongya1228 2018-08-02 07:30

    What you are trying is wrong, You should try like this

    Sale::where(DB::raw("(DATE_FORMAT(transaction_date,'%Y-%m-%d'))"), '<', $now)->salesdetails()->where('product_id', '<=', 24)->where('switch', 1)->update(['switch' => 0]);
    

    I assume transaction_date column is in the Sale Model.

    评论
    解决 无用
    打赏 举报

相关推荐 更多相似问题