How to Send Different Notices for New Orders / Renew

[chiehkai]

Hi,

 

I just realized that sometimes you don't want invoice overdue notices sent to *new orders* containing some text such as "Your service with us would be suspended anytime after this notice...etc".

 

So I asked Matt and came up with the following solution :

There's no simple way of doing this but the idea would be that you use a custom PHP code block and run a query to select from tblorders where invoiceid=xxx and if there is a match, then this is the first invoice for an item, eg.

 

{php}
$invoiceid = $this->_tpl_vars["invoice_id"];
$result = mysql_query("SELECT id FROM tblorders WHERE invoiceid='$invoiceid'");
etc...
{/php}

 

I understand the theory of how it works, but not really sure how to actually use it in my email templates. Can sometime point me out?

 

Thanks!