Adding short description to order information in virtuemart

Hello,

I have a client who needs the short description shown in cart, order details and in the confirmation email.

I have been able to add the short description to the cart!
http://www.maxtemp.com.au/vm/

How do I get the short description shown up in the account.order_details of a user and in the order.order_print in the admin backend?

Can anybody please help me on this matter!
I appreciate your help.

Using VM 1.1.5/1.1.6 and Joomla 1.5.22
LVL 11
Amanda WatsonWeb DeveloperAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Amanda WatsonWeb DeveloperAuthor Commented:
I know it has to do with the account.order_details.tpl.php page but I don't know how do change the order_item_sku to s_description?
<?php

if( !defined( '_VALID_MOS' ) && !defined( '_JEXEC' ) ) die( 'Direct Access to '.basename(__FILE__).' is not allowed.' );

/**

*

* @version $Id: account.order_details.tpl.php 1860 2009-07-29 08:57:52Z soeren_nb $

* @package VirtueMart

* @subpackage html

* @copyright Copyright (C) 2004-2009 soeren - All rights reserved.

* @license http://www.gnu.org/copyleft/gpl.html GNU/GPL, see LICENSE.php

* VirtueMart is free software. This version may have been modified pursuant

* to the GNU General Public License, and as distributed it includes or

* is derivative of works licensed under the GNU General Public License or

* other free or open source software licenses.

* See /administrator/components/com_virtuemart/COPYRIGHT.php for copyright notices and details.

*

* http://virtuemart.net

*/

mm_showMyFileName( __FILE__ );



if( $db->f('order_number')) {

?>	



	<?php if (empty( $print )) : ?>

	<div class="pathway"><?php echo $vmPathway; ?></div>

	<div class="buttons_heading">

	<?php echo vmCommonHTML::PrintIcon(); ?>

	</div>

	<br /><br />

	 <?php endif; ?>



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

	  <tr>

	    <td valign="top">

	     <h2><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_PO_LBL') ?></h2>

	     <p><?php echo ps_vendor::formatted_store_address(true) ?></p>

	    </td>

	    <td valign="top" width="10%" align="right"><?php echo $vendor_image; ?></td>

	  </tr>

	</table>

	<?php

	if ( $db->f("order_status") == "P" ) {

		// Copy the db object to prevent it gets altered

		$db_temp = ps_DB::_clone( $db );

	 /** Start printing out HTML Form code (Payment Extra Info) **/ ?>

	<table width="100%">

	  <tr>

	    <td width="100%" align="center">

	    <?php 

	    @include( CLASSPATH. "payment/".$dbpm->f("payment_class").".cfg.php" );

	

	    echo DEBUG ? vmCommonHTML::getInfoField('Beginning to parse the payment extra info code...' ) : '';

	

	    // Here's the place where the Payment Extra Form Code is included

	    // Thanks to Steve for this solution (why make it complicated...?)

	    if( eval('?>' . $dbpm->f("payment_extrainfo") . '<?php ') === false ) {

	    	echo vmCommonHTML::getErrorField( "Error: The code of the payment method ".$dbpm->f( 'payment_method_name').' ('.$dbpm->f('payment_method_code').') '

	    	.'contains a Parse Error!<br />Please correct that first' );

	    }

	      ?>

	    </td>

	  </tr>

	</table>

	<?php

		$db = $db_temp;

	}

	// END printing out HTML Form code (Payment Extra Info)

	?>

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

	  <!-- begin customer information --> 

	  <tr class="sectiontableheader"> 

	    <th align="left" colspan="2"><?php echo $VM_LANG->_('PHPSHOP_ACC_ORDER_INFO') ?></th>

	  </tr>

	  <tr> 

	    <td><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_PO_NUMBER')?>:</td>

	    <td><?php printf("%08d", $db->f("order_id")); ?></td>

	  </tr>

	

	  <tr> 

		<td><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_PO_DATE') ?>:</td>

	    <td><?php echo vmFormatDate($db->f("cdate")+$time_offset); ?></td>

	  </tr>

	  <tr> 

	    <td><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_PO_STATUS') ?>:</td>

	    <td><?php echo ps_order_status::getOrderStatusName( $db->f("order_status") ); ?></td>

	  </tr>

	  <!-- End Customer Information --> 

	  <!-- Begin 2 column bill-ship to --> 

	  <tr class="sectiontableheader"> 

	    <th align="left" colspan="2"><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_CUST_INFO_LBL') ?></th>

	  </tr>

	  <tr valign="top"> 

	    <td width="50%"> <!-- Begin BillTo -->

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

	        <tr> 

	          <td colspan="2"><strong><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_BILL_TO_LBL') ?></strong></td>

	        </tr>

	        <?php 

		foreach( $registrationfields as $field ) {

			if( $field->type == 'captcha') continue;

			if( $field->name == 'email') $field->name = 'user_email';

			?>

		  <tr> 

			<td align="right"><?php echo $VM_LANG->_($field->title) ? $VM_LANG->_($field->title) : $field->title ?>:</td>

			<td><?php

				switch($field->name) {

		          	case 'country':

		          		require_once(CLASSPATH.'ps_country.php');

		          		$country = new ps_country();

		          		$dbc = $country->get_country_by_code($dbbt->f($field->name));

	          			if( $dbc !== false ) echo $dbc->f('country_name');

		          		break;

		          	default: 

		          		echo $dbbt->f($field->name);

		          		break;

		          }

		          ?>

			</td>

		  </tr>

		  <?php

			}

		   ?>

	      </table>

	      <!-- End BillTo --> </td>

	    <td width="50%"> <!-- Begin ShipTo --> <?php

	    // Get ship_to information

	    $dbbt->next_record();

	    $dbst =& $dbbt;

	

	  ?> 

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

	        <tr> 

	          <td colspan="2"><strong><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_SHIP_TO_LBL') ?></strong></td>

	        </tr>

	        <?php 

		foreach( $shippingfields as $field ) {

			if( $field->name == 'email') $field->name = 'user_email';

			?>

		  <tr> 

			<td width="35%" align="right">&nbsp;<?php echo $VM_LANG->_($field->title) ? $VM_LANG->_($field->title) : $field->title ?>:</td>

			<td width="65%"><?php

				switch($field->name) {

		          	case 'country':

		          		require_once(CLASSPATH.'ps_country.php');

		          		$country = new ps_country();

		          		$dbc = $country->get_country_by_code($dbst->f($field->name));

		          		if( $dbc !== false ) echo $dbc->f('country_name');

		          		break;

		          	default: 

		          		echo $dbst->f($field->name);

		          		break;

		          }

		          ?>

			</td>

		  </tr>

		  <?php

			}

		   ?>

	      </table>

	      <!-- End ShipTo --> 

	      <!-- End Customer Information --> 

	    </td>

	  </tr>

	  <tr> 

	    <td colspan="2">&nbsp;</td>

	  </tr>

	  <?php if ( $PSHOP_SHIPPING_MODULES[0] != "no_shipping" && $db->f("ship_method_id")) { ?> 

	  <tr> 

	    <td colspan="2"> 

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

	        

	        <tr class="sectiontableheader"> 

	          <th align="left"><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_CUST_SHIPPING_LBL') ?></th>

	        </tr>

	        <tr> 

	          <td> 

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

	              <tr> 

	                <td><strong><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_SHIPPING_CARRIER_LBL') ?></strong></td>

	                <td><strong><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_SHIPPING_MODE_LBL') ?></strong></td>

	                <td><strong><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_PRICE') ?>&nbsp;</strong></td>

	              </tr>

	              <tr> 

	                <td><?php 

	                $details = explode( "|", $db->f("ship_method_id"));

	                echo $details[1];

	                    ?>&nbsp;

	                </td>

	                <td><?php 

	                echo $details[2];

	                    ?>

	                </td>

	                <td><?php 

	                     echo $CURRENCY_DISPLAY->getFullValue($details[3], '', $db->f('order_currency'));

	                    ?>

	                </td>

	              </tr>

	            </table>

	          </td>

	        </tr>

	        

	      </table>

	    </td>

	  </tr><?php

	  }

	

	  ?> 

	  <tr>

	    <td colspan="2">&nbsp;</td>

	  </tr>

	  <!-- Begin Order Items Information --> 

	  <tr class="sectiontableheader"> 

	    <th align="left" colspan="2"><?php echo $VM_LANG->_('PHPSHOP_ORDER_ITEM') ?></th>

	  </tr>

	  <tr>

	    <td colspan="4">

	<?php

	$dbdl = new ps_DB;

	/* Check if the order has been paid for */

	if ($db->f("order_status") == ENABLE_DOWNLOAD_STATUS && ENABLE_DOWNLOADS) {

	

		$q = "SELECT `download_id` FROM #__{vm}_product_download WHERE";

		$q .= " order_id =" .(int)$vars["order_id"];

		$dbdl->query($q);

	

		// $q = "SELECT * FROM #__{vm}_product_download WHERE order_id ='" . $db->f("order_id")

		// $dbbt->query($q);

	

	

		// check if download records exist for this purchase order

		if ($dbdl->next_record()) {

			echo "<b>" . $VM_LANG->_('PHPSHOP_DOWNLOADS_CLICK') . "</b><br /><br />";

	

			echo($VM_LANG->_('PHPSHOP_DOWNLOADS_SEND_MSG_3').DOWNLOAD_MAX.". <br />");

	

			$expire = ((DOWNLOAD_EXPIRE / 60) / 60) / 24;

			echo(str_replace("{expire}", $expire, $VM_LANG->_('PHPSHOP_DOWNLOADS_SEND_MSG_4')));

			

			echo "<br /><br />";

		}

		//else {

			//echo "<b>" . $VM_LANG->_('PHPSHOP_DOWNLOADS_EXPIRED') . "</b><br /><br />";

		//}

	}

	?>

	    </td>

	  </tr>

	  <!-- END HACK EUGENE -->

	  <tr> 

	    <td colspan="2"> 

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

	        <tr align="left">

	          <th><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_QTY') ?></th>

	            <th><?php echo 'CODE' ?></th>

        <th><?php echo 'DESCRIPTION' ?>xxx</th>

	          <th><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_PRICE') ?></th>

	          <th align="right"><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_TOTAL') ?>&nbsp;&nbsp;&nbsp;</th>

	        </tr>

	        <?php

	        $dbcart = new ps_DB;

	        $q  = "SELECT * FROM #__{vm}_order_item ";

	        $q .= "WHERE #__{vm}_order_item.order_id='$order_id' ";

	        $dbcart->query($q);

	        $subtotal = 0;

	        $dbi = new ps_DB;

			$dbdel = new ps_DB;



	        while ($dbcart->next_record()) {

	

	        	if ($db->f("order_status") == ENABLE_DOWNLOAD_STATUS && ENABLE_DOWNLOADS) {

	        		/* search for download record that corresponds to this order item */

	        		$q = "SELECT `download_id`, `file_name`, `download_max`, `end_date` FROM #__{vm}_product_download WHERE";

	        		$q .= " `order_id`=" . intval($vars["order_id"]);

	        		$q .= " AND `product_id`=". intval($dbcart->f("product_id"));

	        		$dbdl->query($q);

	

	        	}

	        	/* END HACK EUGENE */



	        	$product_id = null;



// ***** Add product_publish to SELECT statement.



	        	$dbi->query( "SELECT product_id, product_publish FROM #__{vm}_product WHERE product_sku='".$dbcart->f("order_item_sku")."'");

	        	$dbi->next_record();

	        	$product_id = $dbi->f("product_id" );



// ***** Set new flag to guard against the output of the product link by checking existance of product and its published status.



				$link_to_product = (!empty( $product_id ) && ($dbi->f('product_publish') == 'Y'));

	?>

	        <tr align="left">

	          <td valign="top"><?php $dbcart->p("product_quantity"); ?></td>

	          <td valign="top"><?php

	              if ($dbdl->next_record()) {



					// First output a link to the product or just the product name if the product has been removed.



					if( $link_to_product) {

						echo '<a href="'.$sess->url( $mm_action_url."index.php?page=shop.product_details&product_id=$product_id") .'" title="'.$dbcart->f("order_item_name").'">';

					}



				  	echo $dbcart->f("order_item_name");



					if( $link_to_product) {

						echo "</a>";

					}



// ***** This is all new code to output multiple links and download expiration details.



					// Now loop through each download and output links to each filename.



					do {



						$download_id = $dbdl->f('download_id');

						$download_max = (int)$dbdl->f('download_max');

						$end_date = (int)$dbdl->f('end_date');

						$time = time();

					

						// If the download has maxed out or expired then delete it from the database and don't display it.

					

						if (($download_max < 1) || (($end_date != 0) && ($time > $end_date))) {

							$q ="DELETE FROM #__{vm}_product_download";

							$q .=" WHERE download_id = '" . $download_id . "'";

							$dbdel->query($q);

							$dbdel->next_record();

						} else {

					

							// Hyperlink the downloadable order item direct to the downloadFunction.



// ***** NOTE: URL changed to directly access download file.

// ***** NOTE: May wish to consider adding classname to <p> for easier control of layout and maybe change <p> to <div>.

						

							$url = $sess->url( $mm_action_url."/index.php?option=com_virtuemart&page=shop.downloads&func=downloadRequest");

							echo '<p><a href="'."$url&download_id=".$download_id.'" title="'.$VM_LANG->_('PHPSHOP_DOWNLOADS_LINK').'">'

									. '<img src="'.VM_THEMEURL.'images/download.png" alt="'.$VM_LANG->_('PHPSHOP_DOWNLOADS_LINK').'" align="left" border="0" />'

									. $dbdl->f('file_name')

									. '</a><br/>(';

						

							// Output downloads remaining and expiration date.						



// ***** NOTE: May wish to set this up as a configuration option or leave it to the developer as it is in a theme template.

						

							if ($download_max > 1)

								echo str_replace("{count}", $download_max, $VM_LANG->_('PHPSHOP_DOWNLOADS_REMAINING'));

							else

								echo str_replace("{count}", $download_max, $VM_LANG->_('PHPSHOP_DOWNLOAD_REMAINING'));

						

							if ($end_date > 0)

								echo str_replace("{date}", date('d/m/y', $end_date), $VM_LANG->_('PHPSHOP_DOWNLOAD_VALID_UNTIL'));



						

							echo ')<p>';

						}

				  	} while ($dbdl->next_record());

				  }

	        		else {



// ***** Change guard to use new flag $link_to_product instead of !empty( $product_id )



			        	if( $link_to_product) {

			          		echo '<a href="'.$sess->url( $mm_action_url."index.php?page=shop.product_details&product_id=$product_id") .'" title="'.$dbcart->f("order_item_name").'">';

			          	}

			          	$dbcart->p("order_item_name");

			          	echo " <div style=\"font-size:smaller;\">" . $dbcart->f("product_attribute") . "</div>";



// ***** Change guard to use new flag $link_to_product instead of !empty( $product_id )



			          	if( $link_to_product) {

			          		echo "</a>";

			          	}

	        		}

			?>

	          </td>

	          <td valign="top"><?php $dbcart->p("order_item_sku"); ?></td>

	          <td valign="top"><?php /*

			$price = $ps_product->get_price($dbcart->f("product_id"));

			$item_price = $price["product_price"]; */

			if( $auth["show_price_including_tax"] ){

				$item_price = $dbcart->f("product_final_price");

			}

			else {

				$item_price = $dbcart->f("product_item_price");

			}

			echo $CURRENCY_DISPLAY->getFullValue($item_price, '', $db->f('order_currency'));

	

	           ?></td>

	          <td valign="top" align="right"><?php $total = $dbcart->f("product_quantity") * $item_price; 

	          $subtotal += $total;

	          echo $CURRENCY_DISPLAY->getFullValue($total, '', $db->f('order_currency'));

	           ?>&nbsp;&nbsp;&nbsp;</td>

	        </tr><?php

	        }

	?> 

	        <tr> 

	          <td colspan="4" align="right">&nbsp;&nbsp;</td>

	          <td>&nbsp;</td>

	        </tr>

	        <tr> 

	          <td colspan="4" align="right"><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_SUBTOTAL') ?> :</td>

	          <td align="right"><?php echo $CURRENCY_DISPLAY->getFullValue($subtotal, '', $db->f('order_currency')) ?>&nbsp;&nbsp;&nbsp;</td>

	        </tr>

	<?php 

	/* COUPON DISCOUNT */

	$coupon_discount = $db->f("coupon_discount");

	$order_discount = $db->f("order_discount");

	

	if( PAYMENT_DISCOUNT_BEFORE == '1') {

		if (($db->f("order_discount") != 0)) {

	?>

	          <tr>

	              <td colspan="4" align="right"><?php 

	              if( $db->f("order_discount") > 0)

	              echo $VM_LANG->_('PHPSHOP_PAYMENT_METHOD_LIST_DISCOUNT');

	              else

	              echo $VM_LANG->_('PHPSHOP_FEE');

	                ?>:

	              </td> 

	              <td align="right"><?php

	              if ($db->f("order_discount") > 0 ) {

	              	echo "- ".$CURRENCY_DISPLAY->getFullValue(abs($db->f("order_discount")), '', $db->f('order_currency'));

	              }

	              elseif ($db->f("order_discount") < 0 )  {

	              	echo "+ ".$CURRENCY_DISPLAY->getFullValue(abs($db->f("order_discount")), '', $db->f('order_currency'));

	              } 

	              ?>

	              &nbsp;&nbsp;&nbsp;</td>

	          </tr>

	        

	        <?php 

		}

		if( $coupon_discount > 0 ) {

	?>

	        <tr>

	          <td colspan="4" align="right"><?php echo $VM_LANG->_('PHPSHOP_COUPON_DISCOUNT') ?>:

	          </td> 

	          <td align="right"><?php

	            echo "- ".$CURRENCY_DISPLAY->getFullValue( $coupon_discount, '', $db->f('order_currency') ); ?>&nbsp;&nbsp;&nbsp;

	          </td>

	        </tr>

	<?php

		}

	}

	?>

	  <?php

	  $tax_total = $db->f("order_tax") + $db->f("order_shipping_tax");

	  if ($auth["show_price_including_tax"] == 0) {

	  ?>

	        <tr> 

	          <td colspan="4" align="right"><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_TOTAL_TAX') ?> :</td>

	          <td align="right"><?php 

	

	          echo $CURRENCY_DISPLAY->getFullValue($tax_total, '', $db->f('order_currency'));

	            ?>&nbsp;&nbsp;&nbsp;</td>

	        </tr>

	<?php

	  }

	  if( PAYMENT_DISCOUNT_BEFORE != '1') {

	  	if (($db->f("order_discount") != 0)) {

	?>

	          <tr>

	              <td colspan="4" align="right"><?php 

	              if( $db->f("order_discount") > 0)

	              echo $VM_LANG->_('PHPSHOP_PAYMENT_METHOD_LIST_DISCOUNT');

	              else

	              echo $VM_LANG->_('PHPSHOP_FEE');

	                ?>:

	              </td> 

	              <td align="right"><?php

	              if ($db->f("order_discount") > 0 )

	              echo "- ".$CURRENCY_DISPLAY->getFullValue(abs($db->f("order_discount")), '', $db->f('order_currency'));

	              elseif ($db->f("order_discount") < 0 )

	                 echo "+ ".$CURRENCY_DISPLAY->getFullValue(abs($db->f("order_discount")), '', $db->f('order_currency')); ?>

	              &nbsp;&nbsp;&nbsp;</td>

	          </tr>

	        

	        <?php 

	  	}

	  	if( $coupon_discount > 0 ) {

	?>

	        <tr>

	          <td colspan="4" align="right"><?php echo $VM_LANG->_('PHPSHOP_COUPON_DISCOUNT') ?>:

	          </td> 

	          <td align="right"><?php

	            echo "- ".$CURRENCY_DISPLAY->getFullValue( $coupon_discount, '', $db->f('order_currency') ); ?>&nbsp;&nbsp;&nbsp;

	          </td>

	        </tr>

	<?php

	  	}

	  }

	?>      <tr> 

	          <td colspan="3" align="right">&nbsp;</td>

	          <td colspan="2" align="right"><hr/></td>

	        </tr>

	        <tr> 

	          <td colspan="4" align="right">

	          <strong><?php echo $VM_LANG->_('PHPSHOP_CART_TOTAL') .": "; ?></strong>

	          </td>

	          

	          <td align="right"><strong><?php  

	          $total = $db->f("order_total");

	          echo $CURRENCY_DISPLAY->getFullValue($total, '', $db->f('order_currency'));

	          ?></strong>&nbsp;&nbsp;&nbsp;</td>

	        </tr>

	  <?php

	  if ($auth["show_price_including_tax"] == 1) {

	  ?>

	        

	        <tr> 

	          <td colspan="3" align="right">&nbsp;</td>

	          <td colspan="2" align="right"><hr/></td>

	        </tr>

	        <tr> 

	          <td colspan="4" align="right"><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_TOTAL_TAX') ?> :</td>

	          <td align="right"><?php 

	

	          echo $CURRENCY_DISPLAY->getFullValue($tax_total, '', $db->f('order_currency'));

			  

	            ?>&nbsp;&nbsp;&nbsp;</td>

	        </tr>

	<?php

	  }

	  ?>    <tr> 

	          <td colspan="3" align="right">&nbsp;</td>

	          <td colspan="2" align="right"><hr/></td>

	        </tr>

	        <tr> 

	          <td colspan="3" align="right">&nbsp;</td>

	          <td colspan="2" align="right"><?php 

					echo ps_checkout::show_tax_details( $db->f('order_tax_details'), $db->f('order_currency') );

	            ?>&nbsp;&nbsp;&nbsp;</td>

	        </tr>

	      </table>

	    </td>

	  </tr>

	 </table>

	  <!-- End Order Items Information --> 

	

	<br />

	

	  <!-- Begin Payment Information --> 

	

	      <table width="100%">

	      <tr class="sectiontableheader"> 

	        <th align="left" colspan="2"><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_PAYINFO_LBL') ?></th>

	      </tr>

	      <tr> 

	        <td width="20%"><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_PAYMENT_LBL') ?> :</td>

	        <td><?php $dbpm->p("payment_method_name"); ?> </td>

	      </tr>

		  <?php

		  require_once(CLASSPATH.'ps_payment_method.php');

		  $ps_payment_method = new ps_payment_method;

		  $payment = $dbpm->f("payment_method_id");

	

		  if ($ps_payment_method->is_creditcard($payment)) {

	

		  	// DECODE Account Number

		  	$dbaccount = new ps_DB;

		  	$q = 'SELECT '.VM_DECRYPT_FUNCTION.'(order_payment_number,\''.ENCODE_KEY.'\') as account_number 

		  				FROM #__{vm}_order_payment WHERE order_id=\''.$order_id.'\'';

		  	$dbaccount->query($q);

	        $dbaccount->next_record();

	        if( $dbaccount->f("order_payment_name")) {

		        ?>	        

		      <tr> 

		        <td width="10%"><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_ACCOUNT_NAME') ?> :</td>

		        <td><?php $dbpm->p("order_payment_name"); ?> </td>

		      </tr>

		      <?php 

		  }

	      if( $dbaccount->f("account_number")) {?>

		      <tr> 

		        <td><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_ACCOUNT_NUMBER') ?> :</td>

		        <td> <?php echo ps_checkout::asterisk_pad($dbaccount->f("account_number"),4);

		    ?> </td>

		      </tr>

		      <?php 

	      }

	      if( $dbpm->f("order_payment_expire") ) {

		      ?>

		      <tr> 

		        <td><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_EXPIRE_DATE') ?> :</td>

		        <td><?php echo $dbpm->f("order_payment_expire") ? strftime("%m - %Y", $dbpm->f("order_payment_expire")) : ''; ?> </td>

		      </tr>

			  <?php

	      } 

	   } ?>

	      <!-- end payment information --> 

	      </table>

	

	<?php // }

	

	    /** Print out the customer note **/

	    if ( $db->f("customer_note") ) {

	    ?>

	    <table width="100%">

	      <tr>

	        <td colspan="2">&nbsp;</td>

	      </tr>

	      <tr class="sectiontableheader">

	        <th align="left" colspan="2"><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_CUSTOMER_NOTE') ?></th>

	      </tr>

	      <tr>

	        <td colspan="2">

	         <?php echo nl2br($db->f("customer_note"))."<br />"; ?>

	       </td>

	      </tr>

	    </table>

	    <?php

	    }

}

else {

	echo '<h4>'._LOGIN_TEXT .'</h4><br/>';

	include(PAGEPATH.'checkout.login_form.php');

	echo '<br/><br/>';

}

Open in new window

0
Amanda WatsonWeb DeveloperAuthor Commented:
This hack works

<?php

if( !defined( '_VALID_MOS' ) && !defined( '_JEXEC' ) ) die( 'Direct Access to '.basename(__FILE__).' is not allowed.' );

/**

*

* @version $Id: account.order_details.tpl.php 1860 2009-07-29 08:57:52Z soeren_nb $

* @package VirtueMart

* @subpackage html

* @copyright Copyright (C) 2004-2009 soeren - All rights reserved.

* @license http://www.gnu.org/copyleft/gpl.html GNU/GPL, see LICENSE.php

* VirtueMart is free software. This version may have been modified pursuant

* to the GNU General Public License, and as distributed it includes or

* is derivative of works licensed under the GNU General Public License or

* other free or open source software licenses.

* See /administrator/components/com_virtuemart/COPYRIGHT.php for copyright notices and details.

*

* http://virtuemart.net

*/

mm_showMyFileName( __FILE__ );



if( $db->f('order_number')) {

?>	



	<?php if (empty( $print )) : ?>

	<div class="pathway"><?php echo $vmPathway; ?></div>

	<div class="buttons_heading">

	<?php echo vmCommonHTML::PrintIcon(); ?>

	</div>

	<br /><br />

	 <?php endif; ?>



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

	  <tr>

	    <td valign="top">

	     <h2><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_PO_LBL') ?></h2>

	     <p><?php echo ps_vendor::formatted_store_address(true) ?></p>

	    </td>

	    <td valign="top" width="10%" align="right"><?php echo $vendor_image; ?></td>

	  </tr>

	</table>

	<?php

	if ( $db->f("order_status") == "P" ) {

		// Copy the db object to prevent it gets altered

		$db_temp = ps_DB::_clone( $db );

	 /** Start printing out HTML Form code (Payment Extra Info) **/ ?>

	<table width="100%">

	  <tr>

	    <td width="100%" align="center">

	    <?php 

	    @include( CLASSPATH. "payment/".$dbpm->f("payment_class").".cfg.php" );

	

	    echo DEBUG ? vmCommonHTML::getInfoField('Beginning to parse the payment extra info code...' ) : '';

	

	    // Here's the place where the Payment Extra Form Code is included

	    // Thanks to Steve for this solution (why make it complicated...?)

	    if( eval('?>' . $dbpm->f("payment_extrainfo") . '<?php ') === false ) {

	    	echo vmCommonHTML::getErrorField( "Error: The code of the payment method ".$dbpm->f( 'payment_method_name').' ('.$dbpm->f('payment_method_code').') '

	    	.'contains a Parse Error!<br />Please correct that first' );

	    }

	      ?>

	    </td>

	  </tr>

	</table>

	<?php

		$db = $db_temp;

	}

	// END printing out HTML Form code (Payment Extra Info)

	?>

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

	  <!-- begin customer information --> 

	  <tr class="sectiontableheader"> 

	    <th align="left" colspan="2"><?php echo $VM_LANG->_('PHPSHOP_ACC_ORDER_INFO') ?></th>

	  </tr>

	  <tr> 

	    <td><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_PO_NUMBER')?>:</td>

	    <td><?php printf("%08d", $db->f("order_id")); ?></td>

	  </tr>

	

	  <tr> 

		<td><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_PO_DATE') ?>:</td>

	    <td><?php echo vmFormatDate($db->f("cdate")+$time_offset); ?></td>

	  </tr>

	  <tr> 

	    <td><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_PO_STATUS') ?>:</td>

	    <td><?php echo ps_order_status::getOrderStatusName( $db->f("order_status") ); ?></td>

	  </tr>

	  <!-- End Customer Information --> 

	  <!-- Begin 2 column bill-ship to --> 

	  <tr class="sectiontableheader"> 

	    <th align="left" colspan="2"><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_CUST_INFO_LBL') ?></th>

	  </tr>

	  <tr valign="top"> 

	    <td width="50%"> <!-- Begin BillTo -->

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

	        <tr> 

	          <td colspan="2"><strong><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_BILL_TO_LBL') ?></strong></td>

	        </tr>

	        <?php 

		foreach( $registrationfields as $field ) {

			if( $field->type == 'captcha') continue;

			if( $field->name == 'email') $field->name = 'user_email';

			?>

		  <tr> 

			<td align="right"><?php echo $VM_LANG->_($field->title) ? $VM_LANG->_($field->title) : $field->title ?>:</td>

			<td><?php

				switch($field->name) {

		          	case 'country':

		          		require_once(CLASSPATH.'ps_country.php');

		          		$country = new ps_country();

		          		$dbc = $country->get_country_by_code($dbbt->f($field->name));

	          			if( $dbc !== false ) echo $dbc->f('country_name');

		          		break;

		          	default: 

		          		echo $dbbt->f($field->name);

		          		break;

		          }

		          ?>

			</td>

		  </tr>

		  <?php

			}

		   ?>

	      </table>

	      <!-- End BillTo --> </td>

	    <td width="50%"> <!-- Begin ShipTo --> <?php

	    // Get ship_to information

	    $dbbt->next_record();

	    $dbst =& $dbbt;

	

	  ?> 

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

	        <tr> 

	          <td colspan="2"><strong><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_SHIP_TO_LBL') ?></strong></td>

	        </tr>

	        <?php 

		foreach( $shippingfields as $field ) {

			if( $field->name == 'email') $field->name = 'user_email';

			?>

		  <tr> 

			<td width="35%" align="right">&nbsp;<?php echo $VM_LANG->_($field->title) ? $VM_LANG->_($field->title) : $field->title ?>:</td>

			<td width="65%"><?php

				switch($field->name) {

		          	case 'country':

		          		require_once(CLASSPATH.'ps_country.php');

		          		$country = new ps_country();

		          		$dbc = $country->get_country_by_code($dbst->f($field->name));

		          		if( $dbc !== false ) echo $dbc->f('country_name');

		          		break;

		          	default: 

		          		echo $dbst->f($field->name);

		          		break;

		          }

		          ?>

			</td>

		  </tr>

		  <?php

			}

		   ?>

	      </table>

	      <!-- End ShipTo --> 

	      <!-- End Customer Information --> 

	    </td>

	  </tr>

	  <tr> 

	    <td colspan="2">&nbsp;</td>

	  </tr>

	  <?php if ( $PSHOP_SHIPPING_MODULES[0] != "no_shipping" && $db->f("ship_method_id")) { ?> 

	  <tr> 

	    <td colspan="2"> 

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

	        

	        <tr class="sectiontableheader"> 

	          <th align="left"><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_CUST_SHIPPING_LBL') ?></th>

	        </tr>

	        <tr> 

	          <td> 

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

	              <tr> 

	                <td><strong><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_SHIPPING_CARRIER_LBL') ?></strong></td>

	                <td><strong><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_SHIPPING_MODE_LBL') ?></strong></td>

	                <td><strong><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_PRICE') ?>&nbsp;</strong></td>

	              </tr>

	              <tr> 

	                <td><?php 

	                $details = explode( "|", $db->f("ship_method_id"));

	                echo $details[1];

	                    ?>&nbsp;

	                </td>

	                <td><?php 

	                echo $details[2];

	                    ?>

	                </td>

	                <td><?php 

	                     echo $CURRENCY_DISPLAY->getFullValue($details[3], '', $db->f('order_currency'));

	                    ?>

	                </td>

	              </tr>

	            </table>

	          </td>

	        </tr>

	        

	      </table>

	    </td>

	  </tr><?php

	  }

	

	  ?> 

	  <tr>

	    <td colspan="2">&nbsp;</td>

	  </tr>

	  <!-- Begin Order Items Information --> 

	  <tr class="sectiontableheader"> 

	    <th align="left" colspan="2"><?php echo $VM_LANG->_('PHPSHOP_ORDER_ITEM') ?></th>

	  </tr>

	  <tr>

	    <td colspan="4">

	<?php

	$dbdl = new ps_DB;

	/* Check if the order has been paid for */

	if ($db->f("order_status") == ENABLE_DOWNLOAD_STATUS && ENABLE_DOWNLOADS) {

	

		$q = "SELECT `download_id` FROM #__{vm}_product_download WHERE";

		$q .= " order_id =" .(int)$vars["order_id"];

		$dbdl->query($q);

	

		// $q = "SELECT * FROM #__{vm}_product_download WHERE order_id ='" . $db->f("order_id")

		// $dbbt->query($q);

	

	

		// check if download records exist for this purchase order

		if ($dbdl->next_record()) {

			echo "<b>" . $VM_LANG->_('PHPSHOP_DOWNLOADS_CLICK') . "</b><br /><br />";

	

			echo($VM_LANG->_('PHPSHOP_DOWNLOADS_SEND_MSG_3').DOWNLOAD_MAX.". <br />");

	

			$expire = ((DOWNLOAD_EXPIRE / 60) / 60) / 24;

			echo(str_replace("{expire}", $expire, $VM_LANG->_('PHPSHOP_DOWNLOADS_SEND_MSG_4')));

			

			echo "<br /><br />";

		}

		//else {

			//echo "<b>" . $VM_LANG->_('PHPSHOP_DOWNLOADS_EXPIRED') . "</b><br /><br />";

		//}

	}

	?>

	    </td>

	  </tr>

	  <!-- END HACK EUGENE -->

	  <tr> 

	    <td colspan="2"> 

	      <table width="100%" cellspacing="0" cellpadding="2" border="0">
        <tr align="left"> 
          <th><?php echo $VM_LANG->_PHPSHOP_ORDER_PRINT_QTY ?>QUANTITY</th>
          <th><?php echo $VM_LANG->_PHPSHOP_ORDER_PRINT_NAME ?>CODE</th>
          <th><?php echo $VM_LANG->_PHPSHOP_ORDER_PRINT_S_DESC ?>DESCRIPTION</th>
          <th><?php echo $VM_LANG->_PHPSHOP_ORDER_PRINT_PRICE ?>PRICE</th>
          <th align="right"><?php echo $VM_LANG->_PHPSHOP_ORDER_PRINT_TOTAL ?>TOTAL&nbsp;&nbsp;&nbsp;</th>
        </tr>
	        <?php
        $dbcart = new ps_DB;
        //$q  = "SELECT * FROM #__{vm}_order_item ";
        //$q .= "WHERE #__{vm}_order_item.order_id='$order_id' ";
	$q = "SELECT p.product_s_desc, o.* FROM #__{vm}_product p, #__{vm}_order_item o WHERE o.order_id='$order_id' AND p.product_id=o.product_id";
        $dbcart->query($q);

        $subtotal = 0;
        $dbi = new ps_DB;
        while ($dbcart->next_record()) {

	

	        	if ($db->f("order_status") == ENABLE_DOWNLOAD_STATUS && ENABLE_DOWNLOADS) {

	        		/* search for download record that corresponds to this order item */

	        		$q = "SELECT `download_id`, `file_name`, `download_max`, `end_date` FROM #__{vm}_product_download WHERE";

	        		$q .= " `order_id`=" . intval($vars["order_id"]);

	        		$q .= " AND `product_id`=". intval($dbcart->f("product_id"));

	        		$dbdl->query($q);

	

	        	}

	        	/* END HACK EUGENE */



	        	$product_id = null;
        	$dbi->query( "SELECT product_id FROM #__{vm}_product WHERE product_sku='".$dbcart->f("order_item_sku")."'");
        	$dbi->next_record();
        	$product_id = $dbi->f("product_id" );
 


// ***** Set new flag to guard against the output of the product link by checking existance of product and its published status.



				$link_to_product = (!empty( $product_id ) && ($dbi->f('product_publish') == 'Y'));

	?>

	        <tr align="left">

	          <td valign="top"><?php $dbcart->p("product_quantity"); ?></td>

	          <td valign="top"><?php

	              if ($dbdl->next_record()) {



					// First output a link to the product or just the product name if the product has been removed.



					if( $link_to_product) {

						echo '<a href="'.$sess->url( $mm_action_url."index.php?page=shop.product_details&product_id=$product_id") .'" title="'.$dbcart->f("order_item_name").'">';

					}



				  	echo $dbcart->f("order_item_name");



					if( $link_to_product) {

						echo "</a>";

					}



// ***** This is all new code to output multiple links and download expiration details.



					// Now loop through each download and output links to each filename.



					do {



						$download_id = $dbdl->f('download_id');

						$download_max = (int)$dbdl->f('download_max');

						$end_date = (int)$dbdl->f('end_date');

						$time = time();

					

						// If the download has maxed out or expired then delete it from the database and don't display it.

					

						if (($download_max < 1) || (($end_date != 0) && ($time > $end_date))) {

							$q ="DELETE FROM #__{vm}_product_download";

							$q .=" WHERE download_id = '" . $download_id . "'";

							$dbdel->query($q);

							$dbdel->next_record();

						} else {

					

							// Hyperlink the downloadable order item direct to the downloadFunction.



// ***** NOTE: URL changed to directly access download file.

// ***** NOTE: May wish to consider adding classname to <p> for easier control of layout and maybe change <p> to <div>.

						

							$url = $sess->url( $mm_action_url."/index.php?option=com_virtuemart&page=shop.downloads&func=downloadRequest");

							echo '<p><a href="'."$url&download_id=".$download_id.'" title="'.$VM_LANG->_('PHPSHOP_DOWNLOADS_LINK').'">'

									. '<img src="'.VM_THEMEURL.'images/download.png" alt="'.$VM_LANG->_('PHPSHOP_DOWNLOADS_LINK').'" align="left" border="0" />'

									. $dbdl->f('file_name')

									. '</a><br/>(';

						

							// Output downloads remaining and expiration date.						



// ***** NOTE: May wish to set this up as a configuration option or leave it to the developer as it is in a theme template.

						

							if ($download_max > 1)

								echo str_replace("{count}", $download_max, $VM_LANG->_('PHPSHOP_DOWNLOADS_REMAINING'));

							else

								echo str_replace("{count}", $download_max, $VM_LANG->_('PHPSHOP_DOWNLOAD_REMAINING'));

						

							if ($end_date > 0)

								echo str_replace("{date}", date('d/m/y', $end_date), $VM_LANG->_('PHPSHOP_DOWNLOAD_VALID_UNTIL'));



						

							echo ')<p>';

						}

				  	} while ($dbdl->next_record());

				  }

	        		else {



// ***** Change guard to use new flag $link_to_product instead of !empty( $product_id )



			        	if( $link_to_product) {

			          		echo '<a href="'.$sess->url( $mm_action_url."index.php?page=shop.product_details&product_id=$product_id") .'" title="'.$dbcart->f("order_item_name").'">';

			          	}

			          	$dbcart->p("order_item_name");

			          	echo " <div style=\"font-size:smaller;\">" . $dbcart->f("product_attribute") . "</div>";



// ***** Change guard to use new flag $link_to_product instead of !empty( $product_id )



			          	if( $link_to_product) {

			          		echo "</a>";

			          	}

	        		}

			?>

	          </td>

	          <td valign="top"><?php $dbcart->p("product_s_desc"); ?></td>

	          <td valign="top"><?php /*

			$price = $ps_product->get_price($dbcart->f("product_id"));

			$item_price = $price["product_price"]; */

			if( $auth["show_price_including_tax"] ){

				$item_price = $dbcart->f("product_final_price");

			}

			else {

				$item_price = $dbcart->f("product_item_price");

			}

			echo $CURRENCY_DISPLAY->getFullValue($item_price, '', $db->f('order_currency'));

	

	           ?></td>

	          <td valign="top" align="right"><?php $total = $dbcart->f("product_quantity") * $item_price; 

	          $subtotal += $total;

	          echo $CURRENCY_DISPLAY->getFullValue($total, '', $db->f('order_currency'));

	           ?>&nbsp;&nbsp;&nbsp;</td>

	        </tr><?php

	        }

	?> 

	        <tr> 

	          <td colspan="4" align="right">&nbsp;&nbsp;</td>

	          <td>&nbsp;</td>

	        </tr>

	        <tr> 

	          <td colspan="4" align="right"><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_SUBTOTAL') ?> :</td>

	          <td align="right"><?php echo $CURRENCY_DISPLAY->getFullValue($subtotal, '', $db->f('order_currency')) ?>&nbsp;&nbsp;&nbsp;</td>

	        </tr>

	<?php 

	/* COUPON DISCOUNT */

	$coupon_discount = $db->f("coupon_discount");

	$order_discount = $db->f("order_discount");

	

	if( PAYMENT_DISCOUNT_BEFORE == '1') {

		if (($db->f("order_discount") != 0)) {

	?>

	          <tr>

	              <td colspan="4" align="right"><?php 

	              if( $db->f("order_discount") > 0)

	              echo $VM_LANG->_('PHPSHOP_PAYMENT_METHOD_LIST_DISCOUNT');

	              else

	              echo $VM_LANG->_('PHPSHOP_FEE');

	                ?>:

	              </td> 

	              <td align="right"><?php

	              if ($db->f("order_discount") > 0 ) {

	              	echo "- ".$CURRENCY_DISPLAY->getFullValue(abs($db->f("order_discount")), '', $db->f('order_currency'));

	              }

	              elseif ($db->f("order_discount") < 0 )  {

	              	echo "+ ".$CURRENCY_DISPLAY->getFullValue(abs($db->f("order_discount")), '', $db->f('order_currency'));

	              } 

	              ?>

	              &nbsp;&nbsp;&nbsp;</td>

	          </tr>

	        

	        <?php 

		}

		if( $coupon_discount > 0 ) {

	?>

	        <tr>

	          <td colspan="4" align="right"><?php echo $VM_LANG->_('PHPSHOP_COUPON_DISCOUNT') ?>:

	          </td> 

	          <td align="right"><?php

	            echo "- ".$CURRENCY_DISPLAY->getFullValue( $coupon_discount, '', $db->f('order_currency') ); ?>&nbsp;&nbsp;&nbsp;

	          </td>

	        </tr>

	<?php

		}

	}

	?>

	  <?php

	  $tax_total = $db->f("order_tax") + $db->f("order_shipping_tax");

	  if ($auth["show_price_including_tax"] == 0) {

	  ?>

	        <tr> 

	          <td colspan="4" align="right"><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_TOTAL_TAX') ?> :</td>

	          <td align="right"><?php 

	

	          echo $CURRENCY_DISPLAY->getFullValue($tax_total, '', $db->f('order_currency'));

	            ?>&nbsp;&nbsp;&nbsp;</td>

	        </tr>

	<?php

	  }

	  if( PAYMENT_DISCOUNT_BEFORE != '1') {

	  	if (($db->f("order_discount") != 0)) {

	?>

	          <tr>

	              <td colspan="4" align="right"><?php 

	              if( $db->f("order_discount") > 0)

	              echo $VM_LANG->_('PHPSHOP_PAYMENT_METHOD_LIST_DISCOUNT');

	              else

	              echo $VM_LANG->_('PHPSHOP_FEE');

	                ?>:

	              </td> 

	              <td align="right"><?php

	              if ($db->f("order_discount") > 0 )

	              echo "- ".$CURRENCY_DISPLAY->getFullValue(abs($db->f("order_discount")), '', $db->f('order_currency'));

	              elseif ($db->f("order_discount") < 0 )

	                 echo "+ ".$CURRENCY_DISPLAY->getFullValue(abs($db->f("order_discount")), '', $db->f('order_currency')); ?>

	              &nbsp;&nbsp;&nbsp;</td>

	          </tr>

	        

	        <?php 

	  	}

	  	if( $coupon_discount > 0 ) {

	?>

	        <tr>

	          <td colspan="4" align="right"><?php echo $VM_LANG->_('PHPSHOP_COUPON_DISCOUNT') ?>:

	          </td> 

	          <td align="right"><?php

	            echo "- ".$CURRENCY_DISPLAY->getFullValue( $coupon_discount, '', $db->f('order_currency') ); ?>&nbsp;&nbsp;&nbsp;

	          </td>

	        </tr>

	<?php

	  	}

	  }

	?>      <tr> 

	          <td colspan="3" align="right">&nbsp;</td>

	          <td colspan="2" align="right"><hr/></td>

	        </tr>

	        <tr> 

	          <td colspan="4" align="right">

	          <strong><?php echo $VM_LANG->_('PHPSHOP_CART_TOTAL') .": "; ?></strong>

	          </td>

	          

	          <td align="right"><strong><?php  

	          $total = $db->f("order_total");

	          echo $CURRENCY_DISPLAY->getFullValue($total, '', $db->f('order_currency'));

	          ?></strong>&nbsp;&nbsp;&nbsp;</td>

	        </tr>

	  <?php

	  if ($auth["show_price_including_tax"] == 1) {

	  ?>

	        

	        <tr> 

	          <td colspan="3" align="right">&nbsp;</td>

	          <td colspan="2" align="right"><hr/></td>

	        </tr>

	        <tr> 

	          <td colspan="4" align="right"><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_TOTAL_TAX') ?> :</td>

	          <td align="right"><?php 

	

	          echo $CURRENCY_DISPLAY->getFullValue($tax_total, '', $db->f('order_currency'));

			  

	            ?>&nbsp;&nbsp;&nbsp;</td>

	        </tr>

	<?php

	  }

	  ?>    <tr> 

	          <td colspan="3" align="right">&nbsp;</td>

	          <td colspan="2" align="right"><hr/></td>

	        </tr>

	        <tr> 

	          <td colspan="3" align="right">&nbsp;</td>

	          <td colspan="2" align="right"><?php 

					echo ps_checkout::show_tax_details( $db->f('order_tax_details'), $db->f('order_currency') );

	            ?>&nbsp;&nbsp;&nbsp;</td>

	        </tr>

	      </table>

	    </td>

	  </tr>

	 </table>

	  <!-- End Order Items Information --> 

	

	<br />

	

	  <!-- Begin Payment Information --> 

	

	      <table width="100%">

	      <tr class="sectiontableheader"> 

	        <th align="left" colspan="2"><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_PAYINFO_LBL') ?></th>

	      </tr>

	      <tr> 

	        <td width="20%"><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_PAYMENT_LBL') ?> :</td>

	        <td><?php $dbpm->p("payment_method_name"); ?> </td>

	      </tr>

		  <?php

		  require_once(CLASSPATH.'ps_payment_method.php');

		  $ps_payment_method = new ps_payment_method;

		  $payment = $dbpm->f("payment_method_id");

	

		  if ($ps_payment_method->is_creditcard($payment)) {

	

		  	// DECODE Account Number

		  	$dbaccount = new ps_DB;

		  	$q = 'SELECT '.VM_DECRYPT_FUNCTION.'(order_payment_number,\''.ENCODE_KEY.'\') as account_number 

		  				FROM #__{vm}_order_payment WHERE order_id=\''.$order_id.'\'';

		  	$dbaccount->query($q);

	        $dbaccount->next_record();

	        if( $dbaccount->f("order_payment_name")) {

		        ?>	        

		      <tr> 

		        <td width="10%"><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_ACCOUNT_NAME') ?> :</td>

		        <td><?php $dbpm->p("order_payment_name"); ?> </td>

		      </tr>

		      <?php 

		  }

	      if( $dbaccount->f("account_number")) {?>

		      <tr> 

		        <td><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_ACCOUNT_NUMBER') ?> :</td>

		        <td> <?php echo ps_checkout::asterisk_pad($dbaccount->f("account_number"),4);

		    ?> </td>

		      </tr>

		      <?php 

	      }

	      if( $dbpm->f("order_payment_expire") ) {

		      ?>

		      <tr> 

		        <td><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_EXPIRE_DATE') ?> :</td>

		        <td><?php echo $dbpm->f("order_payment_expire") ? strftime("%m - %Y", $dbpm->f("order_payment_expire")) : ''; ?> </td>

		      </tr>

			  <?php

	      } 

	   } ?>

	      <!-- end payment information --> 

	      </table>

	

	<?php // }

	

	    /** Print out the customer note **/

	    if ( $db->f("customer_note") ) {

	    ?>

	    <table width="100%">

	      <tr>

	        <td colspan="2">&nbsp;</td>

	      </tr>

	      <tr class="sectiontableheader">

	        <th align="left" colspan="2"><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_CUSTOMER_NOTE') ?></th>

	      </tr>

	      <tr>

	        <td colspan="2">

	         <?php echo nl2br($db->f("customer_note"))."<br />"; ?>

	       </td>

	      </tr>

	    </table>

	    <?php

	    }

}

else {

	echo '<h4>'._LOGIN_TEXT .'</h4><br/>';

	include(PAGEPATH.'checkout.login_form.php');

	echo '<br/><br/>';

}

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Amanda WatsonWeb DeveloperAuthor Commented:
I found it
0
greserCommented:
Hi!!,

Thanks. Works OK
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Joomla

From novice to tech pro — start learning today.