pRieStaKos

BS is old fashion...It's hilarious that WHMCS is still using 3.4.1

Maybe because you have access to testing.whmcs.community.

You got the point 😃

\WHMCS\Database\Capsule::table("tblhosting") ->join("tblclients", "tblhosting.userid", "=", "tblclients.id") ->join("tblproducts", "tblhosting.packageid", "=", "tblproducts.id") ->select("tblclients.email", "tblclients.phonenumber") ->whereIn("tblhosting.domainstatus", ["Cancelled", "Terminated"]) ->where("tblhosting.domain", "<>", "") ->whereIn("tblproducts.gid", [1, 2]) # Add product group id here ->get(); SELECT `tblclients`.`email`, `tblclients`.`phonenumber`, `tblproducts`.`name` FROM `tblhosting` INNER JOIN `tblclients` ON `tblhosting`.`userid` = `tblclients`.`id` INNER JOIN `tblproducts` ON `tblhosting`.`packageid` = `tblproducts`.`id` WHERE `tblhosting`.`domainstatus` ON ("Cancelled", "Terminated") AND `tblhosting`.`domain` <> "" AND `tblproducts`.`gid` in (1, 2) # Add product group id here You can always modify it, as your desire.

AND `tblhosting`.`id` IN (2, 3) # Add here your service ids Replace `tblhosting`.`packageid` with `tblhosting`.`id`

Maybe Completed product status is what you want.

\WHMCS\Database\Capsule::table("tblhosting") ->join("tblclients", "tblhosting.userid", "=", "tblclients.id") ->select("tblclients.email", "tblclients.phonenumber") ->whereIn("tblhosting.domainstatus", ["Cancelled", "Terminated"]) ->where("tblhosting.domain", "<>", "") ->whereIn("tblhosting.packageid", [2, 3]) # Add here your product ids ->get(); # The above is actually this query SELECT `tblclients`.`email`, `tblclients`.`phonenumber` FROM `tblhosting` INNER JOIN `tblclients` ON `tblhosting`.`userid` = `tblclients`.`id` WHERE `tblhosting`.`domainstatus` IN ("Cancelled", "Terminated") AND `tblhosting`.`domain` <> "" AND `tblhosting`.`packageid` IN (2, 3) # Add here your product ids

Check an email if it contains "value=". Or your check will fall to else. Query is OK. You message content you need to check.

You have to use one of there hook indexes and you have invoiceid in both. Then you can call GetInvoice API for all invoice information.

InvoiceCreated or InvoiceCreationPreEmail What information ?

Is this what you are looking for;

You need a hook to set `ordernum` on every new (or old) order. https://developers.whmcs.com/hooks-reference/shopping-cart/#overrideordernumbergeneration

You need to use GetUsers. I you see the example results, you get his clients.

Prices up, actual needed features down...

I hope this was made on a staging/development environment...