求大神帮忙把原生的 sql 转换为 Laravel 格式,非常感谢🙏
select a.click_date,ifnull(b.income,0) as income
from (
SELECT curdate() as click_date
union all
SELECT "2020-04-30" as click_date
union all
SELECT "2020-05-01" as click_date
union all
SELECT "2020-05-02" as click_date
union all
SELECT "2020-05-03" as click_date
union all
SELECT "2020-05-04" as click_date
union all
SELECT "2020-05-05" as click_date
union all
SELECT "2020-05-06" as click_date
union all
SELECT "2020-05-08" as click_date
) a left join (
select DATE_FORMAT(ub_orders.pay_time,"%Y-%m-%d") days,
sum((IFNULL(ub_order_infos.distributors_income,0))-(IFNULL(ub_order_infos.merchant_income,0))) as income
from ub_orders left join ub_order_infos on ub_orders.id=ub_order_infos.order_id
group by days
) b on a.click_date = b.days
order by a.click_date asc;
laravel要活学活用,不要生搬硬套Eloquent ORM,这么复杂的语句就不要想着用ORM了