php - Complicated Laravel Query

Solution:

Try something like this:

$results = \DB::select( \DB::raw("
    SELECT
        SUM(T1.total) AS Total,
        SUM(T1.received) AS Received,
        T1.EventName,
        T1.CurrencyType
    FROM
        (
            SELECT
                event_invoice.Id,
                event_invoice.Amount AS total,
                SUM(payments.recieved_amount + payments.adjust_amount) AS received,
                event_invoice.EventName,
                event_invoice.CurrencyType
            FROM
                event_invoice
            LEFT JOIN payments ON event_invoice.Id = payments.invoice_id
            GROUP BY
                event_invoice.Id
            ORDER BY
                event_invoice.Id
        ) T1
    GROUP BY
        T1.EventName,
        T1.CurrencyType
") );
Copy code