Empty Packing List

**torweb** · 06-12-2006, 02:05 PM

I trying to finish my client's cart. I have an invlice with Ship To and Bill To all displaying properly along with product quantity, prices and descriptions, however my Packing List only show the Ship To and Bill To information. I've built an invoice and went through the complete process to include shipping the item via FedEx.

Thanks for any pointers on this.

**torweb** · 06-13-2006, 09:23 AM

The packingslip.php file seems to have all the field information to display item and etc., but they don't appear. Could this be a bug. Here is a copy of the packingslip.php. Also, I'm using the latest version of OSCmax and am hosted on AABOX, which had OSCMax installed.

<?php

/*

$Id: packingslip.php,v 1.1.1.1.2.1.2.2 2005/09/21 20:58:01 Michael Sasek Exp $

osCMax Power E-Commerce

http://oscdox.com

Copyright (c) 2003 osCommerce

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">

<html <?php echo HTML_PARAMS; ?>>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">

<title><?php echo TITLE; ?></title>

<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">

</head>

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">



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

<tr>

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

<tr>

<td class="pageHeading"><?php echo nl2br(STORE_NAME_ADDRESS); ?></td>

<td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'oscommerce.gif', 'osCommerce', '204', '50'); ?></td>

</tr>

</table></td>

</tr>

<tr>

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

<tr>

<td colspan="2"><?php echo tep_draw_separator(); ?></td>

</tr>

<tr>

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

<tr>

<td class="main"><b><?php echo ENTRY_SOLD_TO; ?></b></td>

</tr>

<tr>

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

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td>

</tr>

<tr>

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

</tr>

<?php

// BOF: MOD - Download Controller - Extra order info

if ($the_customers_fax) {

?>

<tr>

<td class="main"><b><?php echo 'FAX #:'; ?></b></td>

<td class="main"><?php echo $the_customers_fax; ?></td>

</tr>

<?php

}

// EOF: MOD - Download Controller - Extra order info

?>

<tr>

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

</tr>

</table></td>

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

<tr>

<td class="main"><b><?php echo ENTRY_SHIP_TO; ?></b></td>

</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>

<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>

</tr>

<tr>

<td><table border="0" cellspacing="0" cellpadding="2">

<?php

// BOF: MOD - Download Controller - Extra order info

?>



<tr>

<td class="main"><b>Customers # </b></td>

<td class="main"><?php echo $the_customers_id; ?></td>

</tr>



<tr>

<td class="main"><b>Order # </b></td>

<td class="main"><?php echo tep_db_input($oID); ?></td>

</tr>



<tr>

<td class="main"><b>Date & Time</b></td>

<td class="main"><?php echo tep_datetime_short($order->info['date_purchased']); ?></td>

</tr>

<tr>

<td class="main"><b>Shipping Method:</b></td>

<td class="main"><?php echo tep_get_orders_shipping_method($oID); ?></td>

</tr>

<?php

// EOF: MOD - Download Controller - Extra order info

?>

<tr>

<td class="main"><b><?php echo ENTRY_PAYMENT_METHOD; ?></b></td>

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

</tr>

</table></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>

</tr>

<tr>

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

<tr class="dataTableHeadingRow">

<td class="dataTableHeadingContent" colspan="2"><?php echo TABLE_HEADING_PRODUCTS; ?></td>

<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_MODEL; ?></td>

</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'] . '&nbsp;x</td>' . "\n" .

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

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

for ($j=0, $k=sizeof($order->products[$i]['attributes']); $j<$k; $j++) {

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

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

}

}

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

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

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

}

?>

</table></td>

</tr>

</table>



<br>

</body>

</html>

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

**michael_s** · 06-13-2006, 08:49 PM

It has some issues. I will not have time to look at it, but if you need a working packingslip, use the original code from osc:

Code:

&lt;?php
/*
  $Id&#58; packingslip.php,v 1.7 2003/06/20 00&#58;40&#58;10 hpdl Exp $

  osCommerce, Open Source E-Commerce Solutions
  http&#58;//www.oscommerce.com

  Copyright &#40;c&#41; 2003 osCommerce

  Released under the GNU General Public License
*/

  require&#40;'includes/application_top.php'&#41;;

  require&#40;DIR_WS_CLASSES . 'currencies.php'&#41;;
  $currencies = new currencies&#40;&#41;;

  $oID = tep_db_prepare_input&#40;$HTTP_GET_VARS&#91;'oID'&#93;&#41;;
  $orders_query = tep_db_query&#40;"select orders_id from " . TABLE_ORDERS . " where orders_id = '" . &#40;int&#41;$oID . "'"&#41;;

  include&#40;DIR_WS_CLASSES . 'order.php'&#41;;
  $order = new order&#40;$oID&#41;;
?>
&lt;!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
&lt;html &lt;?php echo HTML_PARAMS; ?>>
&lt;head>
&lt;meta http-equiv="Content-Type" content="text/html; charset=&lt;?php echo CHARSET; ?>">
&lt;title>&lt;?php echo TITLE; ?>&lt;/title>
&lt;link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
&lt;/head>
&lt;body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">
&lt;!-- body_text //-->
&lt;table border="0" width="100%" cellspacing="0" cellpadding="2">
  &lt;tr>
    &lt;td>&lt;table border="0" width="100%" cellspacing="0" cellpadding="0">
      &lt;tr>
        &lt;td class="pageHeading">&lt;?php echo nl2br&#40;STORE_NAME_ADDRESS&#41;; ?>&lt;/td>
        &lt;td class="pageHeading" align="right">&lt;?php echo tep_image&#40;DIR_WS_IMAGES . 'oscommerce.gif', 'osCommerce', '204', '50'&#41;; ?>&lt;/td>
      &lt;/tr>
    &lt;/table>&lt;/td>
  &lt;/tr>
  &lt;tr>
    &lt;td>&lt;table width="100%" border="0" cellspacing="0" cellpadding="2">
      &lt;tr>
        &lt;td colspan="2">&lt;?php echo tep_draw_separator&#40;&#41;; ?>&lt;/td>
      &lt;/tr>
      &lt;tr>
        &lt;td valign="top">&lt;table width="100%" border="0" cellspacing="0" cellpadding="2">
          &lt;tr>
            &lt;td class="main">&lt;b>&lt;?php echo ENTRY_SOLD_TO; ?>&lt;/b>&lt;/td>
          &lt;/tr>
          &lt;tr>
            &lt;td class="main">&lt;?php echo tep_address_format&#40;$order->customer&#91;'format_id'&#93;, $order->customer, 1, '', '&lt;br>'&#41;; ?>&lt;/td>
          &lt;/tr>
          &lt;tr>
            &lt;td>&lt;?php echo tep_draw_separator&#40;'pixel_trans.gif', '1', '5'&#41;; ?>&lt;/td>
          &lt;/tr>
          &lt;tr>
            &lt;td class="main">&lt;?php echo $order->customer&#91;'telephone'&#93;; ?>&lt;/td>
          &lt;/tr>
          &lt;tr>
            &lt;td class="main">&lt;?php echo '&lt;a href="mailto&#58;' . $order->customer&#91;'email_address'&#93; . '">&lt;u>' . $order->customer&#91;'email_address'&#93; . '&lt;/u>&lt;/a>'; ?>&lt;/td>
          &lt;/tr>
        &lt;/table>&lt;/td>
        &lt;td valign="top">&lt;table width="100%" border="0" cellspacing="0" cellpadding="2">
          &lt;tr>
            &lt;td class="main">&lt;b>&lt;?php echo ENTRY_SHIP_TO; ?>&lt;/b>&lt;/td>
          &lt;/tr>
          &lt;tr>
            &lt;td class="main">&lt;?php echo tep_address_format&#40;$order->delivery&#91;'format_id'&#93;, $order->delivery, 1, '', '&lt;br>'&#41;; ?>&lt;/td>
          &lt;/tr>
        &lt;/table>&lt;/td>
      &lt;/tr>
    &lt;/table>&lt;/td>
  &lt;/tr>
  &lt;tr>
    &lt;td>&lt;?php echo tep_draw_separator&#40;'pixel_trans.gif', '1', '10'&#41;; ?>&lt;/td>
  &lt;/tr>
  &lt;tr>
    &lt;td>&lt;table border="0" cellspacing="0" cellpadding="2">
      &lt;tr>
        &lt;td class="main">&lt;b>&lt;?php echo ENTRY_PAYMENT_METHOD; ?>&lt;/b>&lt;/td>
        &lt;td class="main">&lt;?php echo $order->info&#91;'payment_method'&#93;; ?>&lt;/td>
      &lt;/tr>
    &lt;/table>&lt;/td>
  &lt;/tr>
  &lt;tr>
    &lt;td>&lt;?php echo tep_draw_separator&#40;'pixel_trans.gif', '1', '10'&#41;; ?>&lt;/td>
  &lt;/tr>
  &lt;tr>
    &lt;td>&lt;table border="0" width="100%" cellspacing="0" cellpadding="2">
      &lt;tr class="dataTableHeadingRow">
        &lt;td class="dataTableHeadingContent" colspan="2">&lt;?php echo TABLE_HEADING_PRODUCTS; ?>&lt;/td>
        &lt;td class="dataTableHeadingContent">&lt;?php echo TABLE_HEADING_PRODUCTS_MODEL; ?>&lt;/td>
      &lt;/tr>
&lt;?php
    for &#40;$i=0, $n=sizeof&#40;$order->products&#41;; $i&lt;$n; $i++&#41; &#123;
      echo '      &lt;tr class="dataTableRow">' . "\n" .
           '        &lt;td class="dataTableContent" valign="top" align="right">' . $order->products&#91;$i&#93;&#91;'qty'&#93; . '&amp;nbsp;x&lt;/td>' . "\n" .
           '        &lt;td class="dataTableContent" valign="top">' . $order->products&#91;$i&#93;&#91;'name'&#93;;

      if &#40;isset&#40;$order->products&#91;$i&#93;&#91;'attributes'&#93;&#41; &amp;&amp; &#40;sizeof&#40;$order->products&#91;$i&#93;&#91;'attributes'&#93;&#41; > 0&#41;&#41; &#123;
        for &#40;$j=0, $k=sizeof&#40;$order->products&#91;$i&#93;&#91;'attributes'&#93;&#41;; $j&lt;$k; $j++&#41; &#123;
          echo '&lt;br>&lt;nobr>&lt;small>&amp;nbsp;&lt;i> - ' . $order->products&#91;$i&#93;&#91;'attributes'&#93;&#91;$j&#93;&#91;'option'&#93; . '&#58; ' . $order->products&#91;$i&#93;&#91;'attributes'&#93;&#91;$j&#93;&#91;'value'&#93;;
          echo '&lt;/i>&lt;/small>&lt;/nobr>';
        &#125;
      &#125;

      //ABS &#58; If custom_text exists, display it 
      if&#40;isset&#40;$order->products&#91;$i&#93;&#91;'custom_text'&#93;&#41; &amp;&amp; strlen&#40;$order->products&#91;$i&#93;&#91;'custom_text'&#93;&#41; > 0&#41;
      &#123;
	  echo '&lt;br>&lt;nobr>&lt;small>&amp;nbsp;&lt;i> - Custom Text&#58; ' . $order->products&#91;$i&#93;&#91;'custom_text'&#93; . '&lt;/i>&lt;/small>&lt;/nobr>';
      &#125;

      echo '        &lt;/td>' . "\n" .
           '        &lt;td class="dataTableContent" valign="top">' . $order->products&#91;$i&#93;&#91;'model'&#93; . '&lt;/td>' . "\n" .
           '      &lt;/tr>' . "\n";
    &#125;
?>
    &lt;/table>&lt;/td>
  &lt;/tr>
&lt;/table>
&lt;!-- body_text_eof //-->
&lt;br>
&lt;/body>
&lt;/html>
&lt;?php require&#40;DIR_WS_INCLUDES . 'application_bottom.php'&#41;; ?>

**torweb** · 06-14-2006, 09:20 AM

Fantastic...

That worked great. Thank you for the help on this. Also, I'm adding some additionl data fields in the Bill To / Ship To section such as purchase date, fax number, etc. It seems to work fine so I assume that is not a major modification and is ok to do.

Thanks again for the great support!!