How to get Order ID using Invoice ID

[Cloud is My Home]

Hello,

I wanted to get the Order ID using the invoice ID with API (Internal) or with by Interacting with the database

I would love it if someone helps me with this.

 

Thanks!

[Kian]

This query provides Order ID and Order Number using Invoice ID as input parameter.

SELECT id, ordernum FROM tblorders WHERE invoiceid = '{YOUR_INVOICE_ID}' LIMIT 1

[Cloud is My Home]

Thanks Kian this has worked for me.
But I was wondering how can I achieve using Capsule 

https://developers.whmcs.com/advanced/db-interaction/

[brian!]

4 hours ago, Cloud is My Home said:

But I was wondering how can I achieve using Capsule 

the capsule equivalent would be...

$orderid = Capsule::table('tblorders')->where('invoiceid','{YOUR_INVOICE_ID}')->value('id');

if you wanted ordernum instead, you would change ->value('id') to ->value('ordernum')

[Cloud is My Home]

On 7/23/2019 at 10:47 AM, brian! said:

the capsule equivalent would be...

$orderid = Capsule::table('tblorders')->where('invoiceid','{YOUR_INVOICE_ID}')->value('id');

if you wanted ordernum instead, you would change ->value('id') to ->value('ordernum')

This worked just fine, Thanks!