Add support for searching payment/transaction based on First or second reference ID

[daliwei]

No description provided.

[pierre]

Note that since killbill/killbill@461fcc8, both reference ids aren't stored in Kill Bill anymore. They're only exposed through the payment plugin APIs.

To implement this search, first of all, the searchPayments and / or searchPaymentMethods need to be correctly implemented in the plugin(s) (a default search criteria is typically generated in the plugin frameworks, to be tweaked as needed). See how the Litle plugin does it for instance to search Litle transaction ids.

I would suggest focusing on this first, making sure this search is correctly implement and performs at scale (I'm expecting new indexes to be needed in the plugin tables).

Once this is done, it could easily be integrated in Kaui, since the main search APIs can be delegated to plugins when withPluginInfo=true. For instance, if payment:FOO is searched, we could first search in Kill Bill, and if there is no match, then perform the search again in the plugins (

killbill-admin-ui/app/controllers/kaui/payments_controller.rb

Line 28 in 0c47983

payments = Kaui::Payment.list_or_search(search_key, offset, limit, options_for_klient)

). That way, we could look-up payments given a gateway reference id, even if the plugin name isn't known for instance.