ZenCart_Documentation  1.5.0
http://www.collinsharper.com
C:/xampp/htdocs/zen-cart/admin/packingslip.php
Go to the documentation of this file.
00001 <?php
00010   require('includes/application_top.php');
00011 
00012   require(DIR_WS_CLASSES . 'currencies.php');
00013   $currencies = new currencies();
00014 
00015   $oID = zen_db_prepare_input($_GET['oID']);
00016   $orders = $db->Execute("select orders_id
00017                           from " . TABLE_ORDERS . "
00018                           where orders_id = '" . (int)$oID . "'");
00019 
00020   include(DIR_WS_CLASSES . 'order.php');
00021   $order = new order($oID);
00022 
00023   // prepare order-status pulldown list
00024   $orders_statuses = array();
00025   $orders_status_array = array();
00026   $orders_status = $db->Execute("select orders_status_id, orders_status_name
00027                                  from " . TABLE_ORDERS_STATUS . "
00028                                  where language_id = '" . (int)$_SESSION['languages_id'] . "'");
00029   while (!$orders_status->EOF) {
00030     $orders_statuses[] = array('id' => $orders_status->fields['orders_status_id'],
00031                                'text' => $orders_status->fields['orders_status_name'] . ' [' . $orders_status->fields['orders_status_id'] . ']');
00032     $orders_status_array[$orders_status->fields['orders_status_id']] = $orders_status->fields['orders_status_name'];
00033     $orders_status->MoveNext();
00034   }
00035 ?>
00036 <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
00037 <html <?php echo HTML_PARAMS; ?>>
00038 <head>
00039 <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
00040 <title><?php echo TITLE; ?></title>
00041 <link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
00042 <script language="javascript" src="includes/menu.js"></script>
00043 </head>
00044 <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">
00045 <!-- body_text //-->
00046 <table border="0" width="100%" cellspacing="0" cellpadding="2">
00047   <tr>
00048     <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
00049       <tr>
00050         <td class="pageHeading"><?php echo nl2br(STORE_NAME_ADDRESS); ?></td>
00051         <td class="pageHeading" align="right"><?php echo zen_image(DIR_WS_IMAGES . HEADER_LOGO_IMAGE, HEADER_ALT_TEXT); ?></td>
00052       </tr>
00053     </table></td>
00054   </tr>
00055   <tr>
00056     <td><table width="100%" border="0" cellspacing="0" cellpadding="2">
00057       <tr>
00058         <td colspan="2"><?php echo zen_draw_separator(); ?></td>
00059       </tr>
00060 
00061 <?php
00062       $order_check = $db->Execute("select cc_cvv, customers_name, customers_company, customers_street_address,
00063                                     customers_suburb, customers_city, customers_postcode,
00064                                     customers_state, customers_country, customers_telephone,
00065                                     customers_email_address, customers_address_format_id, delivery_name,
00066                                     delivery_company, delivery_street_address, delivery_suburb,
00067                                     delivery_city, delivery_postcode, delivery_state, delivery_country,
00068                                     delivery_address_format_id, billing_name, billing_company,
00069                                     billing_street_address, billing_suburb, billing_city, billing_postcode,
00070                                     billing_state, billing_country, billing_address_format_id,
00071                                     payment_method, cc_type, cc_owner, cc_number, cc_expires, currency,
00072                                     currency_value, date_purchased, orders_status, last_modified
00073                              from " . TABLE_ORDERS . "
00074                              where orders_id = '" . (int)$oID . "'");
00075   $show_customer = 'false';
00076   if ($order_check->fields['billing_name'] != $order_check->fields['delivery_name']) {
00077     $show_customer = 'true';
00078   }
00079   if ($order_check->fields['billing_street_address'] != $order_check->fields['delivery_street_address']) {
00080     $show_customer = 'true';
00081   }
00082   if ($show_customer == 'true') {
00083 ?>
00084       <tr>
00085         <td class="main"><b><?php echo ENTRY_CUSTOMER; ?></b></td>
00086       </tr>
00087       <tr>
00088         <td class="main"><?php echo zen_address_format($order->customer['format_id'], $order->customer, 1, '', '<br>'); ?></td>
00089       </tr>
00090 <?php } ?>
00091       <tr>
00092         <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">
00093          <tr>
00094             <td class="main"><b><?php echo ENTRY_SOLD_TO; ?></b></td>
00095           </tr>
00096           <tr>
00097             <td class="main"><?php echo zen_address_format($order->billing['format_id'], $order->billing, 1, '', '<br>'); ?></td>
00098           </tr>
00099           <tr>
00100             <td><?php echo zen_draw_separator('pixel_trans.gif', '1', '5'); ?></td>
00101           </tr>
00102           <tr>
00103             <td class="main"><?php echo $order->customer['telephone']; ?></td>
00104           </tr>
00105           <tr>
00106             <td class="main"><?php echo '<a href="mailto:' . $order->customer['email_address'] . '">' . $order->customer['email_address'] . '</a>'; ?></td>
00107           </tr>
00108         </table></td>
00109         <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">
00110           <tr>
00111             <td class="main"><b><?php echo ENTRY_SHIP_TO; ?></b></td>
00112           </tr>
00113           <tr>
00114             <td class="main"><?php echo zen_address_format($order->delivery['format_id'], $order->delivery, 1, '', '<br>'); ?></td>
00115           </tr>
00116         </table></td>
00117       </tr>
00118     </table></td>
00119   </tr>
00120   <tr>
00121     <td><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
00122   </tr>
00123   <tr>
00124     <td class="main"><b><?php echo ENTRY_ORDER_ID . $oID; ?></b></td>
00125   </tr>
00126   <tr>
00127     <td><table border="0" cellspacing="0" cellpadding="2">
00128       <tr>
00129         <td class="main"><strong><?php echo ENTRY_DATE_PURCHASED; ?></strong></td>
00130         <td class="main"><?php echo zen_date_long($order->info['date_purchased']); ?></td>
00131       </tr>
00132       <tr>
00133         <td class="main"><b><?php echo ENTRY_PAYMENT_METHOD; ?></b></td>
00134         <td class="main"><?php echo $order->info['payment_method']; ?></td>
00135       </tr>
00136     </table></td>
00137   </tr>
00138   <tr>
00139     <td><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
00140   </tr>
00141   <tr>
00142     <td><table border="0" width="100%" cellspacing="0" cellpadding="2">
00143       <tr class="dataTableHeadingRow">
00144         <td class="dataTableHeadingContent" colspan="2"><?php echo TABLE_HEADING_PRODUCTS; ?></td>
00145         <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_MODEL; ?></td>
00146       </tr>
00147 <?php
00148     for ($i=0, $n=sizeof($order->products); $i<$n; $i++) {
00149       echo '      <tr class="dataTableRow">' . "\n" .
00150            '        <td class="dataTableContent" valign="top" align="right">' . $order->products[$i]['qty'] . '&nbsp;x</td>' . "\n" .
00151            '        <td class="dataTableContent" valign="top">' . $order->products[$i]['name'];
00152 
00153       if (isset($order->products[$i]['attributes']) && (sizeof($order->products[$i]['attributes']) > 0)) {
00154         for ($j=0, $k=sizeof($order->products[$i]['attributes']); $j<$k; $j++) {
00155           echo '<br><nobr><small>&nbsp;<i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . nl2br(zen_output_string_protected($order->products[$i]['attributes'][$j]['value']));
00156           echo '</i></small></nobr>';
00157         }
00158       }
00159 
00160       echo '        </td>' . "\n" .
00161            '        <td class="dataTableContent" valign="top">' . $order->products[$i]['model'] . '</td>' . "\n" .
00162            '      </tr>' . "\n";
00163     }
00164 ?>
00165     </table></td>
00166   </tr>
00167 
00168 <?php if (ORDER_COMMENTS_PACKING_SLIP > 0) { ?>
00169       <tr>
00170         <td class="main"><table border="0" cellspacing="0" cellpadding="5">
00171           <tr>
00172             <td class="smallText" align="center"><strong><?php echo TABLE_HEADING_DATE_ADDED; ?></strong></td>
00173             <td class="smallText" align="center"><strong><?php echo TABLE_HEADING_STATUS; ?></strong></td>
00174             <td class="smallText" align="center"><strong><?php echo TABLE_HEADING_COMMENTS; ?></strong></td>
00175           </tr>
00176 <?php
00177     $orders_history = $db->Execute("select orders_status_id, date_added, customer_notified, comments
00178                                     from " . TABLE_ORDERS_STATUS_HISTORY . "
00179                                     where orders_id = '" . zen_db_input($oID) . "' and customer_notified >= 0
00180                                     order by date_added");
00181 
00182     if ($orders_history->RecordCount() > 0) {
00183       $count_comments=0;
00184       while (!$orders_history->EOF) {
00185         $count_comments++;
00186         echo '          <tr>' . "\n" .
00187              '            <td class="smallText" align="center" valign="top">' . zen_datetime_short($orders_history->fields['date_added']) . '</td>' . "\n";
00188         echo '            <td class="smallText" valign="top">' . $orders_status_array[$orders_history->fields['orders_status_id']] . '</td>' . "\n";
00189         echo '            <td class="smallText" valign="top">' . ($orders_history->fields['comments'] == '' ? TEXT_NONE : nl2br(zen_db_output($orders_history->fields['comments']))) . '&nbsp;</td>' . "\n" .
00190              '          </tr>' . "\n";
00191         $orders_history->MoveNext();
00192         if (ORDER_COMMENTS_PACKING_SLIP == 1 && $count_comments >= 1) {
00193           break;
00194         }
00195       }
00196     } else {
00197         echo '          <tr>' . "\n" .
00198              '            <td class="smallText" colspan="5">' . TEXT_NO_ORDER_HISTORY . '</td>' . "\n" .
00199              '          </tr>' . "\n";
00200     }
00201 ?>
00202         </table></td>
00203       </tr>
00204 <?php } // order comments ?>
00205 
00206 </table>
00207 <!-- body_text_eof //-->
00208 <br>
00209 </body>
00210 </html>
00211 <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
 All Data Structures Namespaces Files Functions Variables Enumerations