Invoice modification

[led24ee]

Hi. I need modify invoice template (actually this file is invoice.summary-tab.tpl). I need to add one extra field. This is easy. But this field must contain date which is calculated from to variables. One is invoice generated date and this is already existing value. The other on must be invoice date + max_payment_days from table "customer". Can somebody tell me how to construct this ?

 

Thank You

[wakabayashi]

Are you from germany? Is this "max_payment_days" a constant?

I use something similar... My code looks like:

{"+13 days"|date_format:'%d.%m.%Y'}

Of course this only works with a constant.

[led24ee]

Hi

 

I'm from Estonia and here I need Due Date on invoice. Sometimes customer need Invoice before payment and in this case I need to put this Due Date on invoice

About max_payment_days. This max_payment_days is in SQL table (customer) and is marked as INT. It is for every customer. Now i try to modify file invoice.summary-tab.tpl (root/pdf) but I don't know how to tell TB that there is need to add INT to DATETIME and then show this as date.  I add if condition, that this DUE date is visible only when max_payment_days value is not 0. And this is working. But I don't know how to add this to invoice date. So far I got only errors or unwanted result. File is added. All this is from TB1.1.x   At the moment Due Date result is "0" which is definitely not what I need. If  i replace both  values with numbers, then everything is working. So this summation is working. I'm not sure but i think that because one is DATETIME and another is INT then result is something what TB can't understand.

invoice.summary-tab.tpl

Edited July 6, 2020 by led24ee

[wakabayashi]

I guess you can not use "due date" without modifying a php file. But my question is still the same. Is the payment time a constant? Is it always like 14 days?

[led24ee]

No. You can set this different for every customer.

[wakabayashi]

Ok I understand your idea. Why don't you use:

{$customer->max_payment_days}

This should be available on invoice.tpl

[led24ee]

This put only days on invoice, but they need date. Not 10 days but, due date 25-08-2020.

[wakabayashi]

Who is they? Are you a dev? 😎

What about this:

{"{$order_invoice->date_add}+{$customer->max_payment_days} days"|date_format:'%d.%m.%Y'}

 

[led24ee]

"They" are my clients. And I'm not developer but some little changes must be done.

And YES, This solution is working.

 

Thank You