App\Ninja\Repositories\PaymentRepository::findForContact PHP Method

    public function findForContact($contactId = null, $filter = null)
    {
        $query = DB::table('payments')->join('accounts', 'accounts.id', '=', 'payments.account_id')->join('clients', 'clients.id', '=', 'payments.client_id')->join('invoices', 'invoices.id', '=', 'payments.invoice_id')->join('contacts', 'contacts.client_id', '=', 'clients.id')->join('payment_statuses', 'payment_statuses.id', '=', 'payments.payment_status_id')->leftJoin('invitations', function ($join) {
            $join->on('invitations.invoice_id', '=', 'invoices.id')->on('invitations.contact_id', '=', 'contacts.id');
        })->leftJoin('payment_types', 'payment_types.id', '=', 'payments.payment_type_id')->where('clients.is_deleted', '=', false)->where('payments.is_deleted', '=', false)->where('invitations.deleted_at', '=', null)->where('invoices.is_deleted', '=', false)->where('invitations.contact_id', '=', $contactId)->select(DB::raw('COALESCE(clients.currency_id, accounts.currency_id) currency_id'), DB::raw('COALESCE(clients.country_id, accounts.country_id) country_id'), 'invitations.invitation_key', 'payments.public_id', 'payments.transaction_reference', DB::raw("COALESCE(NULLIF(clients.name,''), NULLIF(CONCAT(contacts.first_name, ' ', contacts.last_name),''), NULLIF(contacts.email,'')) client_name"), 'clients.public_id as client_public_id', 'payments.amount', 'payments.payment_date', 'payments.payment_type_id', 'invoices.public_id as invoice_public_id', 'invoices.invoice_number', 'contacts.first_name', 'contacts.last_name', 'contacts.email', 'payment_types.name as payment_type', 'payments.account_gateway_id', 'payments.refunded', 'payments.expiration', 'payments.last4', 'payments.email', 'payments.routing_number', 'payments.bank_name', 'payments.payment_status_id', 'payment_statuses.name as payment_status_name');
        if ($filter) {
            $query->where(function ($query) use($filter) {
                $query->where('clients.name', 'like', '%' . $filter . '%');
            });
        }
        return $query;
    }