Finding all active orders for a specific product

[jonhubbard]

Hi Everyone, 

I'm a newbie to WHMCS Dev so please be gentle!

I'm trying to work out how I can get a list of all active orders for a specific product in the internal API, or simply just get such a list anyway.

looking at things I'm thinking I'm going to have to perform some pretty recursive searches which don't seem very efficient and wondered if anyone could point me to a simple method for getting this information.

Many thanks

Jon

[twhiting9275]

It's possible to do . A query like this will do it:

$productid = "INSERT PRODUCT ID HERE";

foreach (Capsule::table('tblhosting')->WHERE('packageid', '=', $productid)-> WHERE('domainstatus', '=', 'Active')->get() as $orderlist) {
                        $userid = $orderlist->userid;
                        $server = $orderlist->server;
                        $domain = $orderlist->domain;
                        $paymentmethod = $orderlist->paymentmethod;
                        $billingcycle = $orderlist->billingcycle;
                        $nextinvoicedate = $orderlist->nextinvoicedate;
                        $amount = $orderlist->amount;
                        print ("$userid: $server : $domain: $paymentmethod: $billingcycle: $nextinvoice: $amount<br />");

}

Implementation is going to be on you, but this will get you started

Edited February 15, 2023 by twhiting9275