needing to add a P.O. number field to the checkout process

[graper]

I'm needing to make a small addition to our template. I need to add a p.o. number field that can be used by customers to put in a p.o. number for accounting controls.

I know which tpl page to make changes to. I need to find the pages that accept the information and actually insert it into the database. Can anyone point to those files? and are they over-ridable?

[DrByte]

Order information is written to the database via the order class file.
Once you've collected and validated the collected data (probably via the header_php file for that particular page), you'll need to then store the information into the order by adapting the order class to save that information with the order record. In the order class, it saves the data using a zen_db_perform() call to store the $sql_data_array contents.

[graper]

I knew I was on the right path with the /includes/class/order.php but I didn't think to look at the /includes/modules/pages/* files.

If I made the field show up on the payment page, tpl_checkout_confirmation_default.php, which header would I need to work with, /includes/modules/pages/checkout_confirmation/header_php.php or would it /includes/modules/pages/checkout_payment/header_php.php?

[graper]

Actually Placed the field in tpl_checkout_payment_default.php, I have it showing up on the checkout_confirmation page.

[graper]

I got it to work, I put it in the header_php.php file for the checkout confirmation. thanks for the tip DrByte

[0be1]

Can you please post the code that you inserted into header_php.php file so others can learn from your findings? I needed to do something similar and would like to see how this was resolved.

Thanks...

0be1

[graper]

Can you please post the code that you inserted into header_php.php file so others can learn from your findings? I needed to do something similar and would like to see how this was resolved.

Thanks...

0be1

Sure No problem,

This method adds the P.O. Number field to the form so that it can be saved to the database in the order table, field name po_number If this P.O. Number is needed for a payment module for level 2 or 3 transaction, you'll need to modify the payment module to pull this information out.


in file /includes/modules/pages/checkout_confirmation/header_php.php
line 47, added

"//PO_number added by granville on 2007/12/10

if(isset($_POST['po_number'])) $_SESSION['po_number'] = zen_db_prepare_input($_POST['po_number']);"



to be able to save the p.o. number to the order in the database you have to do the following.
in file /includes/classes/order.php
line 54, added ",po_number"
line 123 added ",'po_number' => $order->fields['po_number']"
line 354 added ",'po_number' => (isset($_SESSION['po_number]) ? $_SESSION['po_number'] : '')"
line 615 added ",'po_number' => $_SESSION['po_number']"


the only thing I didn't do is to change the admin side to show the P.O. Number since I feel that the admin didn't need to know what the P.O. Number that the customer puts in. I imagine there could be a case where this would be needed, but I'm certain it's got to be easy to display it.

[schoolboy]

Granville... is it necessary to create a table in the dbase to store this PO data?

[schoolboy]

the only thing I didn't do is to change the admin side to show the P.O. Number since I feel that the admin didn't need to know what the P.O. Number that the customer puts in. I imagine there could be a case where this would be needed, but I'm certain it's got to be easy to display it.

I would imagine that the PO number is a very important part of the order record. I would like to use it, and mine would have to append to the order history in every respect. When a customer (or shop admin) calls up a transaction (order), it ought to be able to reconcile to a PO number, if the customer inserted such a number during checkout.

[graper]

Granville... is it necessary to create a table in the dbase to store this PO data?

No, just add the field name po_number to the existing order table. Here is some sql code to get it done.

ALTER TABLE `orders` ADD COLUMN `po_number` VARCHAR(15) AFTER `ip_address`;

should be able to run this from Tools > Install SQL patches.