Return Reference Number at check_out (Easyjet..ish)

[seamuskane]

I am setting up a site to sell tickets on buses for special events. I can handle most of the functionality using attributes. However, I would like to return a reference number when some has completed a sale and add it to their order details. I think that this requires changes to checkout_success.pl and setting up a new table of reference numbers with an auto inc field.Can anyone point me in the right ditection as to what code I should change. I am comfortable with PHP. Also, how do I change the text

Your Order Has Been Processed!

 

Your order has been successfully processed! Your products will arrive at their destination within 2-5 working days.

 

Please notify me of updates to the products I have selected below:

 

 

Thanks for shopping with us online!

 

 

Is this changed through FILENAME_CHECKOUT_SUCCESS

[itsupport1]

Yes, checkout_sucecess.php is the file u will need to change to edit that text.

 

Best regards

 

it support 1

[seamuskane]

Yes, checkout_sucecess.php is the file u will need to change to edit that text.

 

Best regards

 

it support 1

Thanks

Can you advise how I change or access FILENAME_CHECKOUT_SUCCESS

[seamuskane]

I figured this out myself - interested in any comments

 

 

1. Booking References

 

To show reference number in account history add booking_ref to this query in account_history.php - This includes a random function

$history_query_raw = "select concat(o.orders_id,FLOOR( 10 + ( RAND( ) * 90 ) ) ,substring( customers_email_address,1,2)) as booking_ref,o.orders_id, o.date_purchased, o.delivery_name, o.billing_name, ot.text as order_total, s.orders_status_name from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_TOTAL . " ot, " . TABLE_ORDERS_STATUS . " s where o.customers

 

 

<table border="0" width="100%" cellspacing="0" cellpadding="2">

<tr>

<td class="main"><?php echo '<b>' . TEXT_ORDER_NUMBER . '</b> ' . $history['orders_id'];?><?php echo ' <b> BOOKING REF</b> ' . $history['booking_ref'];?></td>

 

NOTE - DUE TO USING THE RAND FUNCTION THIS SHOULD BE WRITTEN INTO THE ORDERS TABLE JUST BEFORE THE SUCCESSFUL ORDER PAGE

 

 

2. Changing the Successful Display

go to /store/catalog/includes/languages/english/checkout_success.php

 

and modify text_success

define('TEXT_SUCCESS', 'Please print out your reference number and present it to the driver of the bus at the time and location shown in your order');