Adding Field to Checkout

[spid3r1987]

There are a couple of ways you can achieve this. Firstly, do you offer frequent buyer discount? If so, the best thing to do is to create a new order_total module, which checks the card validity, and if valid, gives a discount. But thats another topic, related, but different.

Ok, so adding the fields to the checkout.

BACKUP EVERYTHING BEFORE EDITTING ANY OF THESE FILES

Firstly, you need to decide which page you are going to add the field to. If its the shipping page, then edit includes/templates/YOUR ACTIVE TEMPLATE/templates/tpl_checkout_shipping_default.php . If its the payment page, then edit tpl_checkout_payment_default.php in the same folder. Here you just need to add the field.

The field needs to be as follows:
<?php echo zen_draw_input_field('frequent_code'); ?>

Next is the difficult bit.

Firstly, you need to add a new column to the orders database table. Use phpmyadmin, and navigate to the table. Add a new column called order_frequent_code.

Next, alter the order.php class file, found in includes/classes/order.php
There are a fair number of bits to add, but bare with me:

Line 43, add order_frequent_code, to the sql statement.

Line 114, before 'ip_address' insert the following line:
'frequent_code' => $order->fields['order_frequent_code'],

Line 343, before 'ip_address' insert the following line:
'frequent_code' => $_SESSION['frequent_code'],

Line 587, before 'ip_address', insert the following line:
'order_frequent_code' => $this->info['frequent_code'],

Ok, nearly there. So far, we've added the field to the template, added the column to the database, and editted the order class to record the value. We now need to get the input and pass it to the order class.


All you need to do now is work out how to display the extra information where you need it. If you want it on the orders page in the admin, then you will need to edit admin/orders.php as a starter.

Good luck and hope it helps

Absolute
PS - I have used this before, but just to let you know its not a direct copy and paste, so I may have missed a ';' or two. If you have any issues, let me know

hey there, right iv copied the steps up to the end of "order class"
the box i required is now showing on the "checkout_payment" page
but it is not showing on the order confirmation.....how do i get this data to be sent to me via the email....


also, how do i make it so that this field HAS to be filled to complete the order?

[spid3r1987]

ok well iv set it up exactly as mentioned, but i still cant seem to get it to show on the order confirmation page or the email


PLEASE HELP MEEEEE!!!

[spid3r1987]

Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou


My way did seem to work, but I dont trust my coding on 0 sleep..
i have used the new code and it works perfectly

tried using this to make the field REQUIRED

if (isset($_POST['frequent_code']) && !zen_not_null($_POST['frequent_code'])) {  //perform ALL checks on relevancy here
    $messageStack->add_session($_GET['main_page'], TEXT_ERROR_VARIABLE_MISSING, 'error');
    zen_redirect(zen_href_link($_GET['main_page']));
  }
if (zen_not_null($_POST['frequent_code'])) {
$_SESSION['frequent_code'] = zen_db_prepare_input($_POST['frequent_code']);
}
$frequent_code = $_SESSION['frequent_code'];

please tell me if this is wrong??
because it dont seem to make the field required :S

[Absolute]

It's really very hard to advise you as to what you've missed, without actually seeing the code, but things to check are that you have changed all the "frequent_code" references to the name of the variable you are actually using.

With the order confirmation page, you will need to add this variable to the header_php.php file, or the template file, where the order is looked up within the database.

And finally, within the Order class, you'll find the send email function, where the body of the email is built. You'll need to either tack this varialbe onto the end of the message body, or create a new tag within the email template, and then assign the varialbe to the HTML_MSG array as required.

Good luck,
Absolute

[spid3r1987]

It's really very hard to advise you as to what you've missed, without actually seeing the code, but things to check are that you have changed all the "frequent_code" references to the name of the variable you are actually using.

With the order confirmation page, you will need to add this variable to the header_php.php file, or the template file, where the order is looked up within the database.

And finally, within the Order class, you'll find the send email function, where the body of the email is built. You'll need to either tack this varialbe onto the end of the message body, or create a new tag within the email template, and then assign the varialbe to the HTML_MSG array as required.

Good luck,
Absolute

lol that confused me

1. Yeah im using frequent_code as my reference

2. which variable to the header_php.php??

3. again which variable lol.

complete noob with php

[cpannek]

Okay, so I've been struggling to get my added fields to post into my data base. I've tried a bunch of different things with this entire post and nothing... before I post my code this is what I'm trying to accomplish:

Need to add 4 fields onto the checkout payment page to take in customer specific information for their order, in my case it's flight information.

Now, heres exactly what I've done following the original instructions provided:

If its the payment page, then edit tpl_checkout_payment_default.php in the same folder. Here you just need to add the field.

The field needs to be as follows:
<?php echo zen_draw_input_field('frequent_code'); ?>

My Code on tpl_checkout_payment_default.php

<fieldset>
<legend><?php echo TABLE_HEADING_FLIGHT_INGO; ?></legend>
<div><?php echo TEXT_FLIGHT_INFO;?></div><br />
<?php echo TEXT_FLIGHT_AIRLINE;?><?php echo zen_draw_input_field('flight_airline'); ?><br />
<?php echo TEXT_FLIGHT_NUMBER;?><?php echo zen_draw_input_field('flight_num'); ?><br />
<?php echo TEXT_FLIGHT_ARV;?><?php echo zen_draw_input_field('flight_arv'); ?><?php echo TEXT_FLIGHT_EX_ARV;?><br />
<?php echo TEXT_FLIGHT_DEP;?><?php echo zen_draw_input_field('flight_dep'); ?><?php echo TEXT_FLIGHT_EX_ARV;?>
</div>
</fieldset>

Firstly, you need to add a new column to the orders database table. Use phpmyadmin, and navigate to the table. Add a new column called order_frequent_code.

Added columns to database:
order_flight_airline
order_flight_num
order_flight_arv
order_flight_dep

Next, alter the order.php class file, found in includes/classes/order.php
There are a fair number of bits to add, but bare with me:

Line 43, add order_frequent_code, to the sql statement.

My Code added to order.php

$order_query = "... order_flight_airline, order_flight_num, order_flight_arv, order_flight_dep, ...

Line 114, before 'ip_address' insert the following line:
'frequent_code' => $order->fields['order_frequent_code'],

My Code added

$this->info = array( ...
'flight_airline' => $order->fields['order_flight_airline'],
'flight_num' => $order->fields['order_flight_num'],
'flight_arv' => $order->fields['order_flight_arv'],
'flight_dep' => $order->fields['order_flight_dep'],
'ip_address' => $order->fields['ip_address']);

Line 343, before 'ip_address' insert the following line:
'frequent_code' => $_SESSION['frequent_code'],

My Code added

$this->info = array( ...
'comments' => (isset($_SESSION['comments']) ? $_SESSION['comments'] : ''),
'flight_airline' => $_SESSION['flight_airline'],
'flight_num' => $_SESSION['flight_num'],
'flight_arv' => $_SESSION['flight_arv'],
'flight_dep' => $_SESSION['flight_dep'],
'ip_address' => $_SESSION['customers_ip_address'] . ' - ' . $_SERVER['REMOTE_ADDR']);

Line 587, before 'ip_address', insert the following line:
'order_frequent_code' => $this->info['frequent_code'],

My Code added

$sql_data_array = array( ...
'order_flight_airline' => $this->info['flight_airline'],
'order_flight_num' => $this->info['flight_num'],
'order_flight_arv' => $this->info['flight_arv'],
'order_flight_dep' => $this->info['flight_dep'],
'ip_address' => $_SESSION['customers_ip_address'] . ' - ' . $_SERVER['REMOTE_ADDR']);

We now need to get the input and pass it to the order class.

If you placed the new field in the shipping page, then you need to edit includes/modules/pages/checkout_shipping/header_php.php

After line 116 add:
if (isset($_SESSION['frequent_code'])) {
$frequent_code = $_SESSION['frequent_code'];
}

My Code added on includes/modules/pages/checkout_payment/header_php.php

require(DIR_WS_CLASSES . 'order.php');
$order = new order;

if (isset($_SESSION['flight_airline'])) {
$flight_airline = $_SESSION['flight_airline'];
}
if (isset($_SESSION['flight_num'])) {
$flight_num = $_SESSION['flight_num'];
}
if (isset($_SESSION['flight_arv'])) {
$flight_arv = $_SESSION['flight_arv'];
}
if (isset($_SESSION['flight_dep'])) {
$flight_dep = $_SESSION['flight_dep'];
}

After line 124, which starts $comments = $_SESS........ add

if (zen_not_null($_POST['frequent_code'])) {
$_SESSION['frequent_code'] = zen_db_prepare_input($_POST['frequent_code']);
}
$frequent_code = $_SESSION['frequent_code'];

My Code added

//  $_SESSION['comments'] = '';
$comments = $_SESSION['comments'];

if (zen_not_null($_POST['flight_airline'])) {
$_SESSION['flight_airline'] = zen_db_prepare_input($_POST['flight_airline']);
}
$flight_airline = $_SESSION['flight_airline'];

if (zen_not_null($_POST['flight_num'])) {
$_SESSION['flight_num'] = zen_db_prepare_input($_POST['flight_num']);
}
$flight_num = $_SESSION['flight_num'];

if (zen_not_null($_POST['flight_arv'])) {
$_SESSION['flight_arv'] = zen_db_prepare_input($_POST['flight_arv']);
}
$flight_arv = $_SESSION['flight_arv'];

if (zen_not_null($_POST['flight_dep'])) {
$_SESSION['flight_dep'] = zen_db_prepare_input($_POST['flight_dep']);
}
$flight_dep = $_SESSION['flight_dep'];

$total_weight = $_SESSION['cart']->show_weight();
$total_count = $_SESSION['cart']->count_contents();

// load all enabled payment modules
require(DIR_WS_CLASSES . 'payment.php');
$payment_modules = new payment;
$flagOnSubmit = sizeof($payment_modules->selection());

So, I have done all that those instructions stated and it wont populate in my database. I've tried tweaking a few things, but nothing seems to be working...

Please help!

[spid3r1987]

hi there
iv managed to get it to show on the orders etc(not the emails yet)

but im just wondering, how do i make it so that the "last" entry put into that box by the customer is forgotten...asin goes to that page and the box is blank again....

thanks in advance

[earlygrayte]

how did you make it work?
I am really trying my best and can't figure a way to make the form submit data to db. It probably has to do with the fact that I have 1.5 zen cart?
Also how can I name it on the checkout page? I only see the field.
Sorry for noob questions.

[xav2]

the code below only works on checkout_shipping, i get the $my_code value written to database when an order completed
but when i tried the same code to checkout_confirmation, nothing written to database
any ideas?

i'm using zen cart 1.51

<?php 

//File checkout_shipping/header_php.php
if (isset($_SESSION['my_code'])) {
$my_code = $_SESSION['my_code'];
}
if (zen_not_null($_POST['my_code'])) {
$_SESSION['my_code'] = zen_db_prepare_input($_POST['my_code']);
}
$my_code = $_SESSION['my_code'];


//File tpl_checkout_shipping_default.php
$my_code = something;
echo zen_draw_input_field('my_code', $my_code, $parameters = 'readonly', $type = 'text');

?>

[xav2]

the same code works on checkout_shipping and checkout_payment page
but it doesn't work on checkout_confirmation page
what do i use it for checkout confirmation?

the code below only works on checkout_shipping, i get the $my_code value written to database when an order completed
but when i tried the same code to checkout_confirmation, nothing written to database
any ideas?

i'm using zen cart 1.51

<?php 

//File checkout_shipping/header_php.php
if (isset($_SESSION['my_code'])) {
$my_code = $_SESSION['my_code'];
}
if (zen_not_null($_POST['my_code'])) {
$_SESSION['my_code'] = zen_db_prepare_input($_POST['my_code']);
}
$my_code = $_SESSION['my_code'];


//File tpl_checkout_shipping_default.php
$my_code = something;
echo zen_draw_input_field('my_code', $my_code, $parameters = 'readonly', $type = 'text');

?>