Using 1.3.9h with Master Encrypted Password, Image Handler, newsletter subscribe and little more.
Got tired of mucking up orders and played with the packingslip.php to show a thumbnail of each item ordered. Modified the css to properly place the information and promptly messed up the comments portion of the file.
With the broken ankle and requisite drugs, my head is not working.
Please take a look and tell me where I made themistake.
THANX
PHP Code:<?php
/**
* @package admin
* @copyright Copyright 2003-2010 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
* @version $Id: packingslip.php 15788 2010-04-02 10:44:40Z drbyte $
* modified by dbltoe 2010-11-20 to include images on the Packing Slip
*/
require('includes/application_top.php');
require(DIR_WS_CLASSES . 'currencies.php');
$currencies = new currencies();
$oID = zen_db_prepare_input($_GET['oID']);
$orders = $db->Execute("select orders_id
from " . TABLE_ORDERS . "
where orders_id = '" . (int)$oID . "'");
include(DIR_WS_CLASSES . 'order.php');
$order = new order($oID);
// prepare order-status pulldown list
$orders_statuses = array();
$orders_status_array = array();
$orders_status = $db->Execute("select orders_status_id, orders_status_name
from " . TABLE_ORDERS_STATUS . "
where language_id = '" . (int)$_SESSION['languages_id'] . "'");
while (!$orders_status->EOF) {
$orders_statuses[] = array('id' => $orders_status->fields['orders_status_id'],
'text' => $orders_status->fields['orders_status_name'] . ' [' . $orders_status->fields['orders_status_id'] . ']');
$orders_status_array[$orders_status->fields['orders_status_id']] = $orders_status->fields['orders_status_name'];
$orders_status->MoveNext();
}
?>
<!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">
<script language="javascript" src="includes/menu.js"></script>
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">
<!-- body_text //-->
<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 zen_image(DIR_WS_IMAGES . HEADER_LOGO_IMAGE, HEADER_ALT_TEXT); ?></td>
</tr>
</table></td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td colspan="2"><?php echo zen_draw_separator(); ?></td>
</tr>
<?php
$order_check = $db->Execute("select cc_cvv, 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, billing_name, billing_company,
billing_street_address, billing_suburb, billing_city, billing_postcode,
billing_state, billing_country, billing_address_format_id,
payment_method, cc_type, cc_owner, cc_number, cc_expires, currency,
currency_value, date_purchased, orders_status, last_modified
from " . TABLE_ORDERS . "
where orders_id = '" . (int)$oID . "'");
$show_customer = 'false';
if ($order_check->fields['billing_name'] != $order_check->fields['delivery_name']) {
$show_customer = 'true';
}
if ($order_check->fields['billing_street_address'] != $order_check->fields['delivery_street_address']) {
$show_customer = 'true';
}
if ($show_customer == 'true') {
?>
<tr>
<td class="main"><b><?php echo ENTRY_CUSTOMER; ?></b></td>
</tr>
<tr>
<td class="main"><?php echo zen_address_format($order->customer['format_id'], $order->customer, 1, '', '<br>'); ?></td>
</tr>
<?php } ?>
<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 zen_address_format($order->billing['format_id'], $order->billing, 1, '', '<br>'); ?></td>
</tr>
<tr>
<td><?php echo zen_draw_separator('pixel_trans.gif', '1', '5'); ?></td>
</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'] . '">' . $order->customer['email_address'] . '</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 zen_address_format($order->delivery['format_id'], $order->delivery, 1, '', '<br>'); ?></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
</tr>
<tr>
<td class="main"><b><?php echo ENTRY_ORDER_ID . $oID; ?></b></td>
</tr>
<tr>
<td><table border="0" cellspacing="0" cellpadding="2">
<tr>
<td class="main"><strong><?php echo ENTRY_DATE_PURCHASED; ?></strong></td>
<td class="main"><?php echo zen_date_long($order->info['date_purchased']); ?></td>
</tr>
<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 zen_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"><?php echo "Image"; ?></td>
<td class="dataTableHeadingContent"><?php echo "Qty"; ?></td>
<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++) {
$products_query_raw = "select p.products_image from " . TABLE_PRODUCTS . " p where products_model =" . "'" . $order->products[$i]['model'] . "'";
$products = $db->Execute($products_query_raw);
// For showing images in pack slip
echo ' <tr class="dataTableRow">' . "\n" .
' <td class="dataTableContent">' . zen_image(DIR_WS_CATALOG . DIR_WS_IMAGES . $products->fields['products_image'] , $listing_values['products_image'], SMALL_IMAGE_HEIGHT) . '</a> </td>' .
' <td class="dataTableContent">' . $order->products[$i]['qty'] . ' </td>' . "\n" .
' <td class="dataTableContent">' . $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> <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . nl2br(zen_output_string_protected($order->products[$i]['attributes'][$j]['value']));
echo '</i></small></nobr>';
}
}
echo ' </td>' . "\n" .
' <td class="dataTableContent" colspan="2">' . $order->products[$i]['model'] . '</td>' . "\n" .
' </tr>' . "\n";
}
?>
</table></td>
</tr>
<?php if (ORDER_COMMENTS_PACKING_SLIP > 0) { ?>
<tr>
<td class="main"><table border="0" cellspacing="0" cellpadding="5">
<tr>
<td class="smallText" align="center"><strong><?php echo TABLE_HEADING_DATE_ADDED; ?></strong></td>
<td class="smallText" align="center"><strong><?php echo TABLE_HEADING_STATUS; ?></strong></td>
<td class="smallText" align="center"><strong><?php echo TABLE_HEADING_COMMENTS; ?></strong></td>
</tr>
<?php
$orders_history = $db->Execute("select orders_status_id, date_added, customer_notified, comments
from " . TABLE_ORDERS_STATUS_HISTORY . "
where orders_id = '" . zen_db_input($oID) . "' and customer_notified >= 0
order by date_added");
if ($orders_history->RecordCount() > 0) {
$count_comments=0;
while (!$orders_history->EOF) {
$count_comments++;
echo ' <tr>' . "\n" .
' <td class="smallText" align="center" valign="top">' . zen_datetime_short($orders_history->fields['date_added']) . '</td>' . "\n";
echo ' <td class="smallText" valign="top">' . $orders_status_array[$orders_history->fields['orders_status_id']] . '</td>' . "\n";
echo ' <td class="smallText" valign="top">' . ($orders_history->fields['comments'] == '' ? TEXT_NONE : nl2br(zen_db_output($orders_history->fields['comments']))) . ' </td>' . "\n" .
' </tr>' . "\n";
$orders_history->MoveNext();
if (ORDER_COMMENTS_PACKING_SLIP == 1 && $count_comments >= 1) {
break;
}
}
} else {
echo ' <tr>' . "\n" .
' <td class="smallText" colspan="5">' . TEXT_NO_ORDER_HISTORY . '</td>' . "\n" .
' </tr>' . "\n";
}
?>
</table></td>
</tr>
<?php } // order comments ?>
</table>
<!-- body_text_eof //-->
<br />
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
Results 1 to 5 of 5
Threaded View
-
31 Dec 2010, 06:40 PM #1
Totally Zenned
- Join Date
- Jan 2004
- Location
- N of San Antonio TX
- Posts
- 9,695
- Plugin Contributions
- 11
Problem with Modified Packing Slip
A little help with colors.
myZenCartHost.com - Zen Cart Certified, PCI Compatible Hosting by JEANDRET
Free SSL & Domain with semi-annual and longer hosting. Updating 1.5.2 and Up.
Reply With QuoteSimilar Threads
-
v155 Problem Adding Data to Packing Slip
By dbltoe in forum Customization from the AdminReplies: 2Last Post: 8 Aug 2016, 11:04 PM -
Packing slip problem
By Sharx in forum Managing Customers and OrdersReplies: 2Last Post: 1 Apr 2008, 10:09 PM -
Packing Slip with images
By seanscully in forum All Other Contributions/AddonsReplies: 3Last Post: 31 Aug 2007, 02:31 PM -
Problem Printing Packing Slip
By mrrcomp in forum Templates, Stylesheets, Page LayoutReplies: 1Last Post: 9 Jun 2007, 05:41 AM
