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

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?

  • 写回答

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]);
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 Arcgis相交分析无法绘制一个或多个图形
  • ¥15 seatunnel-web使用SQL组件时候后台报错,无法找到表格
  • ¥15 fpga自动售货机数码管(相关搜索:数字时钟)
  • ¥15 用前端向数据库插入数据,通过debug发现数据能走到后端,但是放行之后就会提示错误
  • ¥30 3天&7天&&15天&销量如何统计同一行
  • ¥30 帮我写一段可以读取LD2450数据并计算距离的Arduino代码
  • ¥15 飞机曲面部件如机翼,壁板等具体的孔位模型
  • ¥15 vs2019中数据导出问题
  • ¥20 云服务Linux系统TCP-MSS值修改?
  • ¥20 关于#单片机#的问题:项目:使用模拟iic与ov2640通讯环境:F407问题:读取的ID号总是0xff,自己调了调发现在读从机数据时,SDA线上并未有信号变化(语言-c语言)