Jump to content
baymax

Services Report to include Product Name, Product Group & Currency

Recommended Posts

Hi all,

I've been trying to figure this out myself but I have failed 😞

Currently, the Sevices report page has a field called 'Product ID' but I need an option to display/filter:

  • Product Name (tblproducts.name field in this case)
  • Product Group it falls under (tblproducts.gid field in this case)
  • Currency based on the client's profile (tblclients.currency field in this case)

I've made a copy of the Services report and tried different things so now I am here. Any help would be appreciated!

Share this post


Link to post
Share on other sites

@brian! Any idea? 🙂  Aside from doing it from the db, I'd really like to be able to generate reports from WHMCS.

Share this post


Link to post
Share on other sites
11 hours ago, baymax said:

Any idea?

some. ☺️

it's been on the pending list since you posted... but sadly I only have one pair of hands and 24 hours in the day! 🙁

RqhCRvz.jpg

currency is relatively simple because you can get the currency ID value from tblclients and then it's just a case of looking up the value in tblcurrencies and getting the code (e.g USD, GBP etc).

aaxKuDz.png

then for product group, you'll have to decide if you just want the gid value, or if you need to convert it to a product group name.

if you're not used to laravel queries, then using sentq's report from the other thread might be a good starting point for you... and let me know if you get it working as it will save me wasting time looking at it if it's already done. 🙂

Share this post


Link to post
Share on other sites

You know what's messed up? I totally understand what we are trying to do here and where to get the information, but I've got zero clue how to get it into the Services report and make it show up (lol).

SQL newbie here...

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.

×

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated