App\Ninja\Repositories\DashboardRepository::payments PHP Method

    public function payments($accountId, $userId, $viewAll)
    {
        $payments = DB::table('payments')->leftJoin('clients', 'clients.id', '=', 'payments.client_id')->leftJoin('contacts', 'contacts.client_id', '=', 'clients.id')->leftJoin('invoices', 'invoices.id', '=', 'payments.invoice_id')->where('payments.account_id', '=', $accountId)->where('payments.is_deleted', '=', false)->where('invoices.is_deleted', '=', false)->where('clients.is_deleted', '=', false)->where('contacts.deleted_at', '=', null)->where('contacts.is_primary', '=', true)->whereNotIn('payments.payment_status_id', [PAYMENT_STATUS_VOIDED, PAYMENT_STATUS_FAILED]);
        if (!$viewAll) {
            $payments = $payments->where('payments.user_id', '=', $userId);
        }
        return $payments->select(['payments.payment_date', DB::raw('(payments.amount - payments.refunded) as amount'), 'invoices.public_id', 'invoices.invoice_number', 'clients.name as client_name', 'contacts.email', 'contacts.first_name', 'contacts.last_name', 'clients.currency_id', 'clients.public_id as client_public_id', 'clients.user_id as client_user_id'])->orderBy('payments.payment_date', 'desc')->take(50)->get();
    }