Get Service Name (Domain) From Invoice Id

[SSy]

Hi there - very simple question.

 

I want to add a column to the invoices list for clients that displays the domain name the package that invoice is attached to so they know more about the invoice.

 

I know how to add a column and what page to edit, but I don't know the proper syntax to extract that information from Blesta's backend.

 

Right now I have an $invoices variable but it does not contain the URL of the package it is attached to. It does have invoice IDs and what not.

 

Thanks.

[Blesta Addons]

You need to update the core file and update the query to join the services table .

[SSy]

Can you tell me which tables are related and how? I know there is an invoice ID - where is this referenced with regards to services?