Adding fields to invoice in admin

[robinson]

Hello,

I made a vqmod to add some extra fields in the registration form.
Now I want some of those fields to appear in the order invoice as well as in the printed invoice.
The fields are in the "customer" table in database, but I don't know how to call them in "order_info.tlp" for example.

Any hint is highly appreciated.
Thanks.

[straightlight]

The getOrder method under the info from the order controller already uses the customers table. You would need to make the additional calls of the customers table fields you want from the order controller.

[robinson]

Thanks for your answer, straightlight, sorry for the late reply.
I was able to figure that, I saw I need to modify order.php from controllers and order_info.php. Maybe also order.php from models. But with my limited php knowledge, what ever I tried, I cannot call the variable I need, so far.

If somebody can help any further... please.

[straightlight]

I cannot call the variable I need, so far.

Would it be possible to send your XML file as an attachment ? I will take a look at it.

[robinson]

Hi straightlight,

I attached the xml with what I tried to do.

So, in the database, in the "customer" table, there are the fields 'cnp' and 'cui'. They are extra fields that I added to the registration form. I want those fields to appear in admin in the order info and in the invoice (when click on "print invoice").

Thanks a lot for your time and your kindness.

[straightlight]

Try this for the admin order invoice.

[robinson]

Thanks, but unfortunately there's still nothing displayed (other than "Notice: Undefined index cnp" messages).

[straightlight]

There are no index.cnp in OpenCart unless you're using a contribution. Would it be possible to elaborate that error message ?

[robinson]

No, no, it's not index.cnp. It's "Notice: Undefined index: cnp" in admin/model/sale/order.php.
Where 'cnp' is the field from database I want to display.

[straightlight]

Can you send the admin sale order from VQCache and the line number ? An error message from server always includes an error line.

[robinson]

The notice message is for the two lines added through xml:

Code: Select all

, 'cnp'                     => $order_query->row['cnp'],
   'cui'                     => $order_query->row['cui']

[straightlight]

XML file corrected above.

[robinson]

Same thing, not a change.

[straightlight]

Can you send the admin sale order from VQCache and the line number ?

[robinson]

The lines giving the "notice: Undefined index: cnp" and "notice: Undefined index: cui" are line 299 and 300.
I attached the file.

[straightlight]

Fixed.

[robinson]

Thanks, but $cnp in order_info.tpl still outputs nothing and the two "notice: undefined index..." messages are still there.

[straightlight]

$cnp ? It would probably be: $order['cnp'] from your template.

[robinson]

It doesn't work with $order['cnp'] either, doesn't output anything.

[straightlight]

Did you checked in PHPMyAdmin if this field related with that order actually contains any values ?