New gateway module: how to populate the Subscription ID field

[gupi]

Happy New Year!

while working on a new gateway module, I have reached to the point of recurring payments.

Is there a simple way of accessing and populating the "Subscription ID" field from a gateway module ?

 

The logical flow is like this:

 

• customer initiates the card payment
  
• optionaly, customer may opt to initiate the recurrent payments (for instance, a checkbox);
  
• if customer chooses opts for recurrent payments, I need to store the first transaction ID as a recurrent payment initiator, in the Subscription ID field
  

The subscription process should be performed in the callback file (where initial payment is confirmed)

Can you please detail me the sql query needed to link the invoice and subscriptionID field ?

 

Thanks

[WHMCS John]

Hi,

The PayPal module handles this by making an SQL query in the callback file to write the Subscription ID value to the tblhosting.subscriptionid field.

[gupi]

Hi,

The PayPal module handles this by making an SQL query in the callback file to write the Subscription ID value to the tblhosting.subscriptionid field.

 

OK, I understood it, thanks.

[Acidburns]

Maybe a off-topic question, but its connected with "Subscription ID" - field.

Is it possible to show this field on pdf-invoice ?

And is it possible to populate with some other number`s (id) for another payment program instead for Paypal ?

Like my custom-number that i`ll use only to show to customer on my invoices.