The Sql Query For this given image tables to take records is:
select
x.date,
sum(x.invoiceTotal) as invoiceTotal,
sum(x.paymentsMade) as paymentMade
from
(select
i.date,
sum(i.rate * i.quantity /*?*/) as invoiceTotal,
null as paymentMade
from
invoice i
inner join invoiceitem ii on ii.invoiceId = i.invoiceId
group by
i.date
union all
select
p.date,
null as invoiceTotal,
sum(p.amount) as paymentMade
from
payment p
group by
p.date) x
group by
x.date
order by
x.date
Now I want to write this query in laravel query builder how can i do that, I am new to laravel.
The output of the given my sql query
Here is the output of the given my sql query