Add telephone # on the Invoice

lamur · January 26, 2006

I want to add a customers Telephone # on the invoice. Just right below their address.. I checked out invoice.php and found this:

*********

<tr>

<td class="main"><?php echo $order->customer['telephone']; ?></td>

</tr>

**********

Why doesnt it show up? Never the less. How could I do that?

January 26, 2006

Look in catalog/admin/includes/classes/order.php There should be "customers_telephone" in the order query. If it's not there, add it.

lamur · January 26, 2006

Look in catalog/admin/includes/classes/order.php There should be "customers_telephone" in the order query. If it's not there, add it.

Yea it's in there..

Flyer5 · January 26, 2006

Yea it's in there..

It works fine in the following code, it may help...

---------------------------------------------------------

<?php

/*

$Id: invoice.php,v 1.6 2003/06/20 00:37:30 hpdl Exp $

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

Released under the GNU General Public License

*/

require('includes/application_top.php');

require(DIR_WS_CLASSES . 'currencies.php');

$currencies = new currencies();

$oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);

$orders_query = tep_db_query("select orders_id from " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'");

include(DIR_WS_CLASSES . 'order.php');

$order = new order($oID);

?>

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<head>

</head>

<tr>

<tr>

</tr>

</table></td>

</tr>

<tr>

<tr>

</tr>

<tr>

<tr>

</tr>

<tr>

<td class="main"><?php echo tep_address_format($order->customer['format_id'], $order->customer, 1, '', '<br>'); ?></td>

</tr>

<tr>

</tr>

<tr>

<td class="main"><?php echo $order->customer['telephone']; ?></td>

</tr>

<tr>

<td class="main"><?php echo '<a href="mailto:' . $order->customer['email_address'] . '"><u>' . $order->customer['email_address'] . '</u></a>'; ?></td>

</tr>

</table></td>

<tr>

</tr>

<tr>

<td class="main"><?php echo tep_address_format($order->delivery['format_id'], $order->delivery, 1, '', '<br>'); ?></td>

</tr>

</table></td>

</tr>

</table></td>

</tr>

<tr>

</tr>

<tr>

<tr>

<td class="main"><?php echo $order->info['payment_method']; ?></td>

</tr>

</table></td>

</tr>

<tr>

</tr>

<tr>

</tr>

<?php

for ($i = 0, $n = sizeof($order->products); $i < $n; $i++) {

echo ' <tr class="dataTableRow">' . "n" .

' <td class="dataTableContent" valign="top" align="right">' . $order->products[$i]['qty'] . ' x</td>' . "n" .

' <td class="dataTableContent" valign="top">' . $order->products[$i]['name'];

if (isset($order->products[$i]['attributes']) && (($k = sizeof($order->products[$i]['attributes'])) > 0)) {

for ($j = 0; $j < $k; $j++) {

echo '<br><nobr><small> <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value'];

if ($order->products[$i]['attributes'][$j]['price'] != '0') echo ' (' . $order->products[$i]['attributes'][$j]['prefix'] . $currencies->format($order->products[$i]['attributes'][$j]['price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . ')';

echo '</i></small></nobr>';

}

echo ' </td>' . "n" .

' <td class="dataTableContent" valign="top">' . $order->products[$i]['model'] . '</td>' . "n";

echo ' <td class="dataTableContent" align="right" valign="top">' . tep_display_tax_value($order->products[$i]['tax']) . '%</td>' . "n" .

' <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format($order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "n" .

' <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']), true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "n" .

' <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format($order->products[$i]['final_price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "n" .

' <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']) * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "n";

echo ' </tr>' . "n";

}

?>

<tr>

<?php

for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {

echo ' <tr>' . "n" .

' <td align="right" class="smallText">' . $order->totals[$i]['title'] . '</td>' . "n" .

' <td align="right" class="smallText">' . $order->totals[$i]['text'] . '</td>' . "n" .

' </tr>' . "n";

}

?>

</table></td>

</tr>

</table></td>

</tr>

</table>

<br>

</body>

</html>

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

lamur · January 27, 2006

I tryed that code. Still nothing.. Could it be something wrong with the database?

January 27, 2006

Does the customer listed on the invoice have a phone number on file?

lamur · January 27, 2006

Does the customer listed on the invoice have a phone number on file?

Yea it's required.

I think it is a database error. I run another store and checked it out and the phone number does appear.. So I uploaded all the files from the working store to the other one and it still don't show the #....

Not sure what to check in the database...

lamur · January 27, 2006

Also, I added a modifcation that gives the customer the ability to have a shipping, and billing address. Which also messed with the database only really to add that information.. So i'm just not sure where to look for this..

January 27, 2006

Find

<?php echo $order->customer['telephone']; ?>

Replace with

<?php echo $order->delivery['telephone']; ?>

lamur · January 29, 2006

Find
<?php echo $order->customer['telephone']; ?>

Replace with

<?php echo $order->delivery['telephone']; ?>

Now that was in invoice.php correct?

I did that and no change...

lamur · January 29, 2006

Now, let me add this... After browsing around my database.. I see that in the "Customers" database, their is a customers_telephone that is blank.. No #'s in there...

So I go to "Orders" and since I added those add-ons. I got a customers_telephone a delivery_telephone and a billing_telephone. All of those have a phone #... So I am guessing that it's trying to pull the information from the "Customers" table when it should probably pull it from the "Orders" table... How can I re-arrage that one?

January 29, 2006

Did you install the Address Book Enhancer contribution?

lamur · January 29, 2006

Did you install the Address Book Enhancer contribution?

Yea I believe that was the one..

♥Monika in Germany · January 29, 2006

Yea I believe that was the one..

would need to see your class for order to decide where it's pulling from and where it's filling it ;-)

lamur · January 31, 2006

would need to see your class for order to decide where it's pulling from and where it's filling it ;-)

Sorry I am not very literate in this stuff here. Where would I find the class order so I could show you?

♥Monika in Germany · January 31, 2006

Sorry I am not very literate in this stuff here. Where would I find the class order so I could show you?

please post your

admin/includes/classes/order.php

lamur · February 1, 2006

please post your

admin/includes/classes/order.php

<?php
/*

$Id: order.php,v 1.7 2003/06/20 16:23:08 hpdl Exp $

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

Copyright © 2003 osCommerce

Released under the GNU General Public License

*/

class order {

var $info, $totals, $products, $customer, $delivery;

function order($order_id) {

$this->info = array();

$this->totals = array();

$this->products = array();

$this->customer = array();

$this->delivery = array();

$this->query($order_id);

}

function query($order_id) {

$order_query = tep_db_query("select customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, delivery_telephone, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_telephone, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_cvv2, cc_expires, currency, currency_value, date_purchased, orders_status, last_modified from " . TABLE_ORDERS . " where orders_id = '" . (int)$order_id . "'");

$order = tep_db_fetch_array($order_query);

$totals_query = tep_db_query("select title, text from " . TABLE_ORDERS_TOTAL . " where orders_id = '" . (int)$order_id . "' order by sort_order");

while ($totals = tep_db_fetch_array($totals_query)) {

$this->totals[] = array('title' => $totals['title'],

'text' => $totals['text']);

}

$this->info = array('currency' => $order['currency'],

'currency_value' => $order['currency_value'],

'payment_method' => $order['payment_method'],

'cc_type' => $order['cc_type'],

'cc_owner' => $order['cc_owner'],

'cc_number' => $order['cc_number'],

'cc_cvv2' => $order['cc_cvv2'],

'cc_expires' => $order['cc_expires'],

'date_purchased' => $order['date_purchased'],

'orders_status' => $order['orders_status'],

'last_modified' => $order['last_modified']);

$this->customer = array('name' => $order['customers_name'],

'company' => $order['customers_company'],

'street_address' => $order['customers_street_address'],

'suburb' => $order['customers_suburb'],

'city' => $order['customers_city'],

'postcode' => $order['customers_postcode'],

'state' => $order['customers_state'],

'country' => $order['customers_country'],

'format_id' => $order['customers_address_format_id'],

'telephone' => $order['customers_telephone'],

'email_address' => $order['customers_email_address']);

$this->delivery = array('name' => $order['delivery_name'],

'company' => $order['delivery_company'],

'street_address' => $order['delivery_street_address'],

'suburb' => $order['delivery_suburb'],

'city' => $order['delivery_city'],

'postcode' => $order['delivery_postcode'],

'state' => $order['delivery_state'],

'country' => $order['delivery_country'],

'telephone' => $order['delivery_telephone'],

'format_id' => $order['delivery_address_format_id']);

$this->billing = array('name' => $order['billing_name'],

'company' => $order['billing_company'],

'street_address' => $order['billing_street_address'],

'suburb' => $order['billing_suburb'],

'city' => $order['billing_city'],

'postcode' => $order['billing_postcode'],

'state' => $order['billing_state'],

'country' => $order['billing_country'],

'telephone' => $order['billing_telephone'],

'format_id' => $order['billing_address_format_id']);

$index = 0;

$orders_products_query = tep_db_query("select orders_products_id, products_name, products_model, products_price, products_tax, products_quantity, final_price from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$order_id . "'");

while ($orders_products = tep_db_fetch_array($orders_products_query)) {

$this->products[$index] = array('qty' => $orders_products['products_quantity'],

'name' => $orders_products['products_name'],

'model' => $orders_products['products_model'],

'tax' => $orders_products['products_tax'],

'price' => $orders_products['products_price'],

'final_price' => $orders_products['final_price']);

$subindex = 0;

$attributes_query = tep_db_query("select products_options, products_options_values, options_values_price, price_prefix from " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " where orders_id = '" . (int)$order_id . "' and orders_products_id = '" . (int)$orders_products['orders_products_id'] . "'");

if (tep_db_num_rows($attributes_query)) {

while ($attributes = tep_db_fetch_array($attributes_query)) {

$this->products[$index]['attributes'][$subindex] = array('option' => $attributes['products_options'],

'value' => $attributes['products_options_values'],

'prefix' => $attributes['price_prefix'],

'price' => $attributes['options_values_price']);

$subindex++;

}

}

$index++;

}

}

}

?>

February 1, 2006

Did you run all of the SQL with the contribution, including the commented at the bottom?

♥Monika in Germany · February 1, 2006

The file looked ok to me.

Please double check your database table ORDERS for the column name for customers_telephone

any chance you spelled it minus the s for customers?

lamur · February 2, 2006

I backed up the database, and put in the SQL query that was edited out and it didnt display the telephone # then I went to view their profile and their phone # was not in there either so I hurried and restored the backup database.

I checked for mispelling and didnt see any....

What would be the next step you think?

lamur · February 2, 2006

I backed up the database, and put in the SQL query that was edited out and it didnt display the telephone # then I went to view their profile and their phone # was not in there either so I hurried and restored the backup database.

I checked for mispelling and didnt see any....

What would be the next step you think?

I re-upped the main files and now for my invoice it looks like this:

mikal bently

1451 mary jayne

NULL

rockwall, Texas 55555

United States

where did that NULL come from?

February 2, 2006

Look over catalog/includes/classes/order.php as well as catalog/checkout_process.php. Compare them with the files included with the ABE contribution. I think you may be missing an array somewhere.

lamur · February 5, 2006

Look over catalog/includes/classes/order.php as well as catalog/checkout_process.php. Compare them with the files included with the ABE contribution. I think you may be missing an array somewhere.

Just to update this. I couldnt find anything wrong, their is some bug somewhere that is screwing me up that I cannot figure out. So I am having an individual check it out and hopefully get it working for me.

Thanks for the help everyone!

Add telephone # on the Invoice

Recommended Posts

lamur

Guest

lamur

Flyer5

lamur

Guest

lamur

lamur

Guest

lamur

lamur

Guest

lamur

♥Monika in Germany

lamur

♥Monika in Germany

lamur

Guest

♥Monika in Germany

lamur

lamur

Guest

lamur

Archived

Browse

Activity