20907 - Pay outstanding balance switching from EFT payment method

Issue #: https://github.com/bcgov/entity/issues/20907

Description of changes:

removed hybrid properties from statement model, was causing circular dependency issues and the complexity was not working well with general queries
add statement search filter to get all statements with an amounting
add validation to block changing payment method away from EFT when there is an outstanding balance
extend create account payment to support paying an outstanding payment as the existing logic depends on existing failed payments for scenarios like NSF
add amount owing to invoices that are currently not part of a statement yet in account summary
reworked payment_methods query and optimization
moving statement search out of model into service

By submitting this pull request, I confirm that you can use, modify, copy, and redistribute this contribution, under the terms of the sbc-pay license (Apache 2.0).

bcgov / sbc-pay

20907 - Pay outstanding balance switching from EFT payment method #1573

Quality Gate passed