mysql - Laravel 5.1 Eloquent orWhere 子查询

Question

我对这个查询失去了理智。我真的需要这方面的帮助:

SELECT COUNT(*) FROM customers
WHERE (SELECT count(*) FROM customerEmails WHERE email = :email) > 0 
OR (SELECT count(*) FROM customerPhoneNumbers WHERE phoneNumber = :cellphone) > 0 
OR cellphone = :cellphone 
OR email = :email

我不知道什么应该是 Eloquent 代码。 TIA!

Answer 1

你可以使用 Eloquent 的 whereHas (略高于该 anchor )方法根据与其他实体的关系有条件地加载 Customer。假设您有一个名为 Customer 的模型，您可以尝试:

$count = Customer::whereHas('customerEmails', function ($query) use ($email){
    $query->where('email', $email);
})
->orWhereHas('customerPhoneNumbers', function ($query) use ($cellphone){
    $query->where('phoneNumber', $cellphone);
})
->orWhere('cellphone', $cellphone)
->orWhere('email', $email)
->count();