mysql - Laravel 7 - 需要构建查询字符串

Question

我是 Laravel 的新手。我的简单 mysql 查询如下所示。我需要使用带有查询生成器的多个和/或条件的 Laravel 7 进行更改。

select `me`.`*`,`elo`.`*` from `employees_leave_od` as `elo` 
left join `master_employees` as `me` on `elo`.`master_code` = `me`.`master_code`
where (`elo`.`leave_start` >= '2021-08-21' and `elo`.`leave_start` <= '2021-08-28' 
or `elo`.`leave_end` >= '2021-08-21' and `elo`.`leave_end` <= '2021-08-28')
and me.master_code is not null;

标签： mysqllaravel-7