Hook Get service id in Invoice Creation hook

[Kamran]

Hi,

I want to perform some tasks that require the service id on a hook(specifically invoice creation) the paramters there are limited all I get is the invoice id.

Is there a way to fetch service id using that invoice id any indication/help/solution would be highly appreciated. The hook must trigger either before or after invoice generation.

Thanks. 👍

[brian!]

5 minutes ago, Kamran said:

Is there a way to fetch service id using that invoice id any indication/help/solution would be highly appreciated.

if you know the invoiceid, then you could look at the tblinvoiceitems database table, if the type = 'Hosting', then the relid value should equal the service ID.

though bear in mind that an invoice could contain multiple services, so you might need to be more specific in the query if you have some specific product/service to look for.

an alternative would be to use the Billing model (if you're more familiar with that).