我需要以下sql语句转换为Laravel口才。尝试了几种方法,但实际上失败了。
SELECT * FROM `conversations` where `type` = 'open'
AND `sender_id`=2 AND ((`deleted_by_sender` IS NULL )
AND (`deleted_by_sender` IS NULL OR `deleted_by_receiver` IS NULL ))
OR `receiver_id` = 2 AND ((`deleted_by_sender` IS NULL )
AND (`deleted_by_sender` IS NULL OR `deleted_by_receiver` IS NULL ))
先感谢您。
您可以通过这种方式雄辩地执行查询,我假设您有一个称为“对话”的模型
Conversation::where('type', 'open')
->where('sender_id', 2)
->whereNull('deleted_by_sender')
->where(function ($query) {
return $query->whereNull('deleted_by_sender')
->orWhereNull('deleted_by_receiver');
})->orWhere('receiver_id', 2)
->whereNull('deleted_by_sender')
->where(function ($query) {
return $query->whereNull('deleted_by_sender')
->orWhereNull('deleted_by_receiver');
})->get();
这些代码未经测试,直接从您的sql查询翻译而来
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句