Jump to content
dev osCommerce
Forum
  • Checkout
  • Login
  • Contact Us
  • Get in touch

osCommerce

The e-commerce.

New Demo
Our Partners

Add time and order number to invoices

Khemikal

By Khemikal
in General Support

Recommended Posts

Khemikal

Khemikal

Posted
Posted

Is there a contribution to do this? Could it be setup to automatically do so through the DB? Anyone done this before?

 

Thanks!

 

Kevin

bobg7

bobg7

Posted
Posted

Here is what I did to get the date/time to display:

 

In admin.invoice.php at around line 85 find:

 

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

 

And after add:

 

<td><table border="0" cellspacing="0" cellpadding="2">
   <tr>
   <td class="main"><b>Date/Time Purchased:</b> <?php echo $order->info['date_purchased']; ?></td>
   </tr>
	 <tr>
	 </tr>
	 </table></td>
   </tr>

 

Here is the complete admin/invoice.php with a print button at the bottom:

 

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

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

<!-- 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 tep_image(DIR_WS_IMAGES . 'logo1.jpg', 'Color Your Grout', '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, '', '
'); ?></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>
				 <tr>
				   <td class="main"> </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>
	 <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, '', '
'); ?></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">
   <tr>
	 <td class="main"><b><?php echo ENTRY_PAYMENT_METHOD; ?></b></td>
	 <td class="main"><?php echo $order->info['payment_method']; ?></td>
	 </tr>
	 <tr>
	 </tr>
	 <tr>
	 </tr>
	 </table></td>
   </tr>
   <td><table border="0" cellspacing="0" cellpadding="2">
   <tr>
   <td class="main"><b>Date/Time Purchased:</b> <?php echo $order->info['date_purchased']; ?></td>
   </tr>
	 <tr>
	 </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>
	 <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TAX; ?></td>
	 <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_PRICE_EXCLUDING_TAX; ?></td>
	 <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_PRICE_INCLUDING_TAX; ?></td>
	 <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TOTAL_EXCLUDING_TAX; ?></td>
	 <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TOTAL_INCLUDING_TAX; ?></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'] . ' 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 '
<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>
	 <td align="right" colspan="8"><table border="0" cellspacing="0" cellpadding="2">
<?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>
<!-- body_text_eof //-->



<tr>Comments:
<TEXTAREA NAME="comment" ROWS=6 COLS=50>
</TEXTAREA></tr><p>
<script Language="Javascript">

/*
This script is written by Eric ([email protected])
For full source code, installation instructions,
100's more DHTML scripts, and Terms Of
Use, visit dynamicdrive.com
*/

function printit(){  
if (window.print) {
 window.print();  
} else {
 var WebBrowser = '<OBJECT ID="WebBrowser1" WIDTH=0 HEIGHT=0 CLASSID="CLSID:8856F961-340A-11D0-A96B-00C04FD705A2"></OBJECT>';
document.body.insertAdjacentHTML('beforeEnd', WebBrowser);
 WebBrowser1.ExecWB(6, 2);//Use a 1 vs. a 2 for a prompting dialog box	WebBrowser1.outerHTML = "";  
}
}
</script>

<script Language="Javascript">  
var NS = (navigator.appName == "Netscape");
var VERSION = parseInt(navigator.appVersion);
if (VERSION > 3) {
 document.write('<form><input type=button value="Print this Page" name="Print" onClick="printit()"></form>');		
}
</script>

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

 

Hope this at least partly helps

Installed Contributions: CCGV, Close Popup, Dynamic Meta Tags, Easy Populate, Froogle Data Feeder, Google Position, Infobox Header Entire Row, Live Support for OSC, PayPal Seal with CC images, Report_m Sales, Shop by Price Revised, SQL Updater, Who's Online Enhancement, Footer, GNA EP Assistant and still going.

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...