doucai9270 2018-03-27 09:09
浏览 46
已采纳

Laravel雄辩,模型中的条件(Constraining Eager Loads)不起作用

Here is My Controller's Code to get Order list with Condition apply in join table

$orders = Order::whereHas('order_carpets', function($q){
            $q->where('carpent_no', '1345');
        })->get();

Model Code looks something like this

class Order extends Model
{
    protected $table = 'orders';
    public function order_carpets()
    {
        return $this->belongsToMany(Order_carpet::class, 'orders', 'id', 'order_carpet_id');
    }

    public function customers()
    {
        return $this->belongsToMany(Customer::class, 'orders', 'id', 'customer_id');
    }
}

class Order_carpet extends Model
{
    public function orders()
    {
        return $this->hasMany(Order::class);
    }
}

The result I'm getting now is all data of table Order

  • 写回答

1条回答 默认 最新

  • dpa55065 2018-03-28 00:11
    关注

    The orders table appears in your main query and your subquery, without aliases.
    So where orders.id = orders.id refers to the same table twice and so is always true.

    The problem is the order_carpets relationship. It's actually a BelongsTo relationship:

    public function order_carpets()
    {
        return $this->belongsTo(Order_carpet::class, 'order_carpet_id');
    }
    

    The same goes for the customers relationship:

    public function customers()
    {
        return $this->belongsTo(Customer::class, 'customer_id');
    }
    

    You should probably rename them to order_carpet and customer.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥40 如果update 一个列名为参数的value
  • ¥15 基于51单片机的水位检测系统设计中LCD1602一直不显示
  • ¥15 OCS2安装出现问题,请大家给点意见
  • ¥15 有没有大能能帮我出个适应度函数图,T_T
  • ¥15 ros小车启动launch文件报错
  • ¥15 vs2015到期想登陆但是登陆不上
  • ¥15 IPQ5018制作烧录固件,boot运行失败(操作系统-linux)(相关搜索:操作系统)(相关搜索:操作系统)
  • ¥20 icefall在librispeech基础上加入个人数据集
  • ¥30 keepalive高可用故障运维配置询问
  • ¥15 求帮助!国家电网内网u盘突然识别不出来了。