NBILL_EM_NEW_INVOICE_PAR_2_USERNAME

[Mimmi]

Using nBill 2.0, haven't had time to upgrade to 2.1.1.

I would like to change my custom e-mailtemplate so that the following text appear in the mail:

"You can see all of your invoices online by logging in at %s (your username is %s). If you no longer wish to receive your invoices by e-mail, simply log in and click on `My Profile` in the `My Account` area to set your preferences."

(now this is the text: You can see all of your invoices online by logging in at %s. If you no longer wish to receive your invoices by e-mail, simply log in and click on `My Profile` in the `My Account` area to set your preferences)

I have to change the code in invoice_email_custom_attach.php from:

Code: [Select]

<p><?php echo sprintf(NBILL_EM_NEW_INVOICE_PAR_2, nbf_cms::$interop->live_site); ?></p>
to something like

Code: [Select]

<p><?php echo sprintf(NBILL_EM_NEW_INVOICE_PAR_2_USERNAME, nbf_cms::$interop->live_site, $username); ?></p>
But that doesn't make the username appear. I guess I have to do something more with the code, but what?

[netshine]

I'm afraid the username is not currently loaded at the time the invoice template is executed, so if you want to pick up the username, you would have to write some code to look it up in the database yourself. The username is stored on the contact record, so you would need to look up the primary_contact_id on the jos_nbill_entity table using the entity_id from the jos_nbill_document table as the key.

[Mimmi]

I'm afraid the username is not currently loaded at the time the invoice template is executed, so if you want to pick up the username, you would have to write some code to look it up in the database yourself. The username is stored on the contact record, so you would need to look up the primary_contact_id on the jos_nbill_entity table using the entity_id from the jos_nbill_document table as the key.

Thank you for your quick reply. This is odd because I just received an e-mail from "Joomla i Norge" that has this, and they can't remember changing a lot of code to achieve this.

[Mimmi]

This is very strange. I double-checked with Joomla-i-Norge and they are certain they are only using the normal files, no alterations.

Is there a difference in behavior if the e-mail is created by clicking the envelope in administrator/index.php?option=com_nbill&action=invoices or if it is auto-created?

[Mimmi]

It seems to me that n.richard in User Name in email templates requested the same thing as I do.
http://www.nbill.co.uk/forum/index.php/topic,1671.0.html

Maybe I just asked the question wrong? Anyway, I don't have the skills to neither find $document_id variables nor the looking the username up in the database, so I guess I'm just lost!  I guessed it was a standard simple feature since the NBILL_EM_NEW_INVOICE_PAR_2_USERNAME is in the language file and Joomla-i-Norge use it. But if it's not I'll survive 

[netshine]

At present, it will show the username only if you are NOT using an HTML email template (ie. when you are just using a plain text email). I will see if I can easily accommodate including the username on HTML emails as well (needs a bit of jiggery-pokery in the core to make the username available to the template).

[Mimmi]

At present, it will show the username only if you are NOT using an HTML email template (ie. when you are just using a plain text email). I will see if I can easily accommodate including the username on HTML emails as well (needs a bit of jiggery-pokery in the core to make the username available to the template).

Thank you! I love it when it's an easy explanation! :-D No worries, I just use the plain text :-)