function pane_content($tab) { global $VM_LANG; if (vmGet($_REQUEST, 'order_edit_page') == '1') { ?> <script type="text/javascript"> var current = document.getElementById( "order_edit_page" ); current.tabPage.select(); </script> <?php } if (vmGet($_REQUEST, 'delete_product') != '') { $this->delete_product(); } elseif (vmGet($_REQUEST, 'add_product') != '') { $this->add_product(); } elseif (vmGet($_REQUEST, 'update_quantity') != '') { $this->update_quantity(); } elseif (vmGet($_REQUEST, 'update_coupon_discount') != '') { $this->update_coupon_discount(); } elseif (vmGet($_REQUEST, 'update_discount') != '') { $this->update_discount(); } elseif (vmGet($_REQUEST, 'update_standard_shipping') != '') { $this->update_standard_shipping(); } elseif (vmGet($_REQUEST, 'update_shipping') != '') { $this->update_shipping(); } elseif (vmGet($_REQUEST, 'update_bill_to') != '') { $this->update_bill_to(); } elseif (vmGet($_REQUEST, 'update_ship_to') != '') { $this->update_ship_to(); } elseif (vmGet($_REQUEST, 'update_shipping_tax') != '') { } ?> <form method="post" name="editForm" action="<?php echo $_SERVER['PHP_SELF']; ?> "> <table class="adminlist"> <tr> <th><?php echo $VM_LANG->_('VM_ORDER_EDIT_EDIT_ORDER'); ?> </th> </tr> </table> <table class="adminlist"> <tr> <th><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_SKU'); ?> </th> <th><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_NAME'); ?> </th> <th width="5%" align="left"><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_QUANTITY'); ?> </th> <th width="5%" align="left" colspan="2"><?php echo $VM_LANG->_('VM_ORDER_EDIT_ACTIONS'); ?> </th> </tr> <?php $dbt = new ps_DB(); $db = new ps_DB(); $qt = "SELECT order_item_id, product_quantity,order_item_name,order_item_sku FROM `#__{vm}_order_item`" . "WHERE #__{vm}_order_item.order_id='" . $this->order_id . "' "; $q = "SELECT * FROM #__{vm}_orders WHERE order_id='" . $this->order_id . "'"; $dbt->query($qt); $db->query($q); $db->next_record(); $i = 0; $rate_details = explode("|", $db->f("ship_method_id")); while ($dbt->next_record()) { if ($i++ % 2) { $bgcolor = 'row0'; } else { $bgcolor = 'row1'; } ?> <tr class="<?php echo $bgcolor; ?> " valign="top"> <td><?php $dbt->p("order_item_sku"); ?> </td> <td><?php $dbt->p("order_item_name"); ?> </td> <td> <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?> "> <input type="text" value="<?php $dbt->p("product_quantity"); ?> " name="product_quantity" size="5" /> </td> <td align="left"> <input type="image" title="<?php echo $VM_LANG->_('PHPSHOP_UPDATE'); ?> " src="<?php echo VM_THEMEURL; ?> images/edit_f2.gif" border="0" alt="<?php echo $VM_LANG->_('PHPSHOP_UPDATE'); ?> " /> <input type="hidden" value="1" name="update_quantity" /> <input type="hidden" name="order_edit_page" value="1" /> <input type="hidden" name="page" value="order.order_print" /> <input type="hidden" name="option" value="com_virtuemart" /> <input type="hidden" name="func" value="" /> <input type="hidden" name="order_item_id" value="<?php $dbt->p("order_item_id"); ?> " /> <input type="hidden" name="order_id" value="<?php echo $this->order_id; ?> " /> </form> </td> <td> <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?> "> <input type="image" title="<?php echo $VM_LANG->_('PHPSHOP_DELETE'); ?> " src="<?php echo IMAGEURL; ?> ps_image/delete_f2.gif" border="0" alt="<?php echo $VM_LANG->_('PHPSHOP_DELETE'); ?> " /> <input type="hidden" value="1" name="delete_product" /> <input type="hidden" name="order_edit_page" value="1" /> <input type="hidden" name="page" value="order.order_print" /> <input type="hidden" name="option" value="com_virtuemart" /> <input type="hidden" name="func" value="" /> <input type="hidden" name="order_item_id" value="<?php $dbt->p("order_item_id"); ?> " /> <input type="hidden" name="order_id" value="<?php echo $this->order_id; ?> " /> </form> </td> </tr> <?php } ?> </table> <table class="adminlist"> <tr> <th><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_SHIPPING') . " & " . $VM_LANG->_('PHPSHOP_PAYMENT_METHOD_LIST_DISCOUNT'); ?> </th> <th width="5%" align="left"> </th> <th width="5%" align="left" colspan="1"><?php echo $VM_LANG->_('VM_ORDER_EDIT_ACTIONS'); ?> </th> </tr> <?php if ($db->f('ship_method_id') == "" or preg_match('/^standard_shipping/', $db->f('ship_method_id'))) { ?> <tr> <td align="right"><strong><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_SHIPPING'); ?> : </strong></td> <td> <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?> "> <?php $dbs = new ps_DB(); $q = 'SELECT shipping_rate_id, shipping_rate_name, shipping_rate_weight_start, shipping_rate_weight_end, shipping_rate_value, shipping_rate_package_fee, tax_rate, currency_name FROM #__{vm}_shipping_rate, #__{vm}_currency, #__{vm}_tax_rate WHERE currency_id = shipping_rate_currency_id AND ( tax_rate_id = shipping_rate_vat_id OR shipping_rate_vat_id = 0 ) ORDER BY shipping_rate_list_order'; $dbs->query($q); while ($dbs->next_record()) { $rates[$dbs->f('shipping_rate_id')] = $dbs->f('shipping_rate_name') . "; (" . $dbs->f('shipping_rate_weight_start') . " - " . $dbs->f('shipping_rate_weight_end') . "); " . " " . ($dbs->f('shipping_rate_value') * (1 + $dbs->f('tax_rate')) + $dbs->f('shipping_rate_package_fee')) . " " . $dbs->f('currency_name'); } ps_html::dropdown_display('shipping', $rate_details[4], $rates); ?> </select> </td> <td> <input type="image" title="<?php echo $VM_LANG->_('PHPSHOP_UPDATE'); ?> " src="<?php echo VM_THEMEURL; ?> images/edit_f2.gif" border="0" alt="<?php echo $VM_LANG->_('PHPSHOP_UPDATE'); ?> " /> <input type="hidden" value="1" name="update_standard_shipping" /> <input type="hidden" name="order_edit_page" value="1" /> <input type="hidden" name="page" value="order.order_print" /> <input type="hidden" name="option" value="com_virtuemart" /> <input type="hidden" name="func" value="" /> <input type="hidden" name="order_id" value="<?php echo $this->order_id; ?> " /> </form> </td> </tr> <?php } else { ?> <tr> <td align="right"><strong><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_SHIPPING'); ?> : </strong></td> <td> <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?> "> <input type="text" value="<?php $db->p("order_shipping"); ?> " size="5" name="order_shipping" /> </td> <td> <input type="image" title="<?php echo $VM_LANG->_('PHPSHOP_UPDATE'); ?> " src="<?php echo VM_THEMEURL; ?> images/edit_f2.gif" border="0" alt="<?php echo $VM_LANG->_('PHPSHOP_UPDATE'); ?> " /> <input type="hidden" value="1" name="update_shipping" /> <input type="hidden" name="order_edit_page" value="1" /> <input type="hidden" name="page" value="order.order_print" /> <input type="hidden" name="option" value="com_virtuemart" /> <input type="hidden" name="func" value="" /> <input type="hidden" name="order_id" value="<?php echo $this->order_id; ?> " /> </form> </td> </tr> <tr> <td align="right"><strong><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_SHIPPING_TAX'); ?> : </strong></td> <td> <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?> "> <input type="text" value="<?php $db->p("order_shipping_tax"); ?> " name="order_shipping_tax" size="5" /> </td> <td> <input type="image" title="<?php echo $VM_LANG->_('PHPSHOP_UPDATE'); ?> " src="<?php echo VM_THEMEURL; ?> images/edit_f2.gif" border="0" alt="<?php echo $VM_LANG->_('PHPSHOP_UPDATE'); ?> " /> <input type="hidden" value="1" name="update_shipping_tax" /> <input type="hidden" name="order_edit_page" value="1" /> <input type="hidden" name="page" value="order.order_print" /> <input type="hidden" name="option" value="com_virtuemart" /> <input type="hidden" name="func" value="" /> <input type="hidden" name="order_id" value="<?php echo $this->order_id; ?> " /> </form> </td> </tr> <?php } ?> <tr> <td align="right"><strong><?php echo $VM_LANG->_('PHPSHOP_COUPON_DISCOUNT'); ?> : </strong></td> <td> <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?> "> <input type="text" value="<?php $db->p("coupon_discount"); ?> " size="5" name="coupon_discount" /> </td> <td> <input type="image" title="<?php echo $VM_LANG->_('PHPSHOP_UPDATE'); ?> " src="<?php echo VM_THEMEURL; ?> images/edit_f2.gif" border="0" alt="<?php echo $VM_LANG->_('PHPSHOP_UPDATE'); ?> " /> <input type="hidden" value="1" name="update_coupon_discount" /> <input type="hidden" name="order_edit_page" value="1" /> <input type="hidden" name="page" value="order.order_print" /> <input type="hidden" name="option" value="com_virtuemart" /> <input type="hidden" name="func" value="" /> <input type="hidden" name="order_id" value="<?php echo $this->order_id; ?> " /> </form> </td> </tr> <tr> <td align="right"><strong><?php echo $VM_LANG->_('PHPSHOP_PAYMENT_METHOD_LIST_DISCOUNT'); ?> : </strong></td> <td> <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?> "> <input type="text" value="<?php $db->p("order_discount"); ?> " size="5" name="order_discount" /> </td> <td> <input type="image" title="<?php echo $VM_LANG->_('PHPSHOP_UPDATE'); ?> " src="<?php echo VM_THEMEURL; ?> images/edit_f2.gif" border="0" alt="<?php echo $VM_LANG->_('PHPSHOP_UPDATE'); ?> " /> <input type="hidden" value="1" name="update_discount" /> <input type="hidden" name="order_edit_page" value="1" /> <input type="hidden" name="page" value="order.order_print" /> <input type="hidden" name="option" value="com_virtuemart" /> <input type="hidden" name="func" value="" /> <input type="hidden" name="order_id" value="<?php echo $this->order_id; ?> " /> </form> </td> </tr> </table> <table class="adminlist"> <tr> <th><?php echo $VM_LANG->_('PHPSHOP_USER_FORM_BILLTO_LBL') . " & " . $VM_LANG->_('PHPSHOP_USER_FORM_SHIPTO_LBL'); ?> </th> <th width="5%" align="left"> </th> <th width="5%" align="left" colspan="1"><?php echo $VM_LANG->_('VM_ORDER_EDIT_ACTIONS'); ?> </th> </tr> <tr> <td align="right"><strong><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_BILL_TO_LBL'); ?> : </strong></td> <td align="right"> <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?> "> <select name="bill_to"> <?php $dbs = new ps_DB(); $q = "SELECT user_id, last_name, first_name FROM #__{vm}_user_info WHERE address_type = 'BT' ORDER BY last_name ASC"; $dbs->query($q); while ($dbs->next_record()) { if (!is_null($dbs->f('last_name'))) { print '<option value="' . $dbs->f('user_id') . '"'; if ($dbs->f('user_id') == $db->f("user_id")) { print " selected "; } print '>'; print $dbs->f('last_name'); print ", " . $dbs->f('first_name'); print '</option>'; } } ?> </select> </td> <td> <input type="image" title="<?php echo $VM_LANG->_('PHPSHOP_UPDATE'); ?> " src="<?php echo VM_THEMEURL; ?> images/edit_f2.gif" border="0" alt="<?php echo $VM_LANG->_('PHPSHOP_UPDATE'); ?> " /> <input type="hidden" value="1" name="update_bill_to" /> <input type="hidden" name="order_edit_page" value="1" /> <input type="hidden" name="page" value="order.order_print" /> <input type="hidden" name="option" value="com_virtuemart" /> <input type="hidden" name="func" value="" /> <input type="hidden" name="order_id" value="<?php echo $this->order_id; ?> " /> </form> </td> </tr> <?php /* Change ship to form */ ?> <tr> <td align="right"><strong><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_SHIP_TO_LBL'); ?> : </strong></td> <td align="right"> <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?> "> <select name="ship_to"> <?php $dbs = new ps_DB(); $q = "SELECT user_info_id, address_type_name FROM #__{vm}_user_info WHERE user_id = '" . $db->f("user_id") . "' ORDER BY address_type_name ASC"; $dbs->query($q); while ($dbs->next_record()) { if (!is_null($dbs->f('user_info_id'))) { print '<option value="' . $dbs->f('user_info_id') . '">'; print $dbs->f('address_type_name'); print '</option>'; } } ?> </select> </td> <td> <input type="image" title="<?php echo $VM_LANG->_('PHPSHOP_UPDATE'); ?> " src="<?php echo VM_THEMEURL; ?> images/edit_f2.gif" border="0" alt="<?php echo $VM_LANG->_('PHPSHOP_UPDATE'); ?> " /> <input type="hidden" value="1" name="update_ship_to" /> <input type="hidden" name="order_edit_page" value="1" /> <input type="hidden" name="page" value="order.order_print" /> <input type="hidden" name="option" value="com_virtuemart" /> <input type="hidden" name="func" value="" /> <input type="hidden" name="order_id" value="<?php echo $this->order_id; ?> " /> </form> </td> </tr> </table> <?php $this->display_form_add_product(); ?> <?php }
$sectioncolor = "sectiontableentry2"; $i += 1; } else { $sectioncolor = "sectiontableentry1"; $i -= 1; } if( !$db->f('category_flypage') ) { $flypage = ps_product::get_flypage( $db->f('product_id')); } else { $flypage = $db->f('category_flypage'); } $tt_item++; $pid = $db->f("product_parent_id") ? $db->f("product_parent_id") : $db->f("product_id"); ?> <tr class="<?php echo $sectioncolor ?>"> <td width="12%"><?php printf( $tt_item); ?>.</td> <td width="85%"> <a class="bestseller" href="<?php $sess->purl(URL . "index.php?page=shop.product_details&flypage=$flypage&product_id=" . $pid . "&category_id=" . $db->f("category_id")) ?>"> <?php $db->p("product_name"); ?> </a> </td> </tr> <?php } ?> </table> <!--Top 10 End-->
echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_ACCOUNT_NUMBER'); ?> </th> <th width="17%"><?php echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_EXPIRE_DATE'); ?> </th> </tr> <tr> <td width="13%"> <?php $ps_order_change_html->html_change_payment($dbpm->f("payment_method_id")); ?> </td> <td width="40%"><?php $dbpm->p("order_payment_name"); ?> </td> <td width="30%"><?php echo ps_checkout::asterisk_pad($dbaccount->f("account_number"), 4, true); if ($dbaccount->f('order_payment_code')) { echo '<br/>(' . $VM_LANG->_('VM_ORDER_PAYMENT_CCV_CODE') . ': ' . $dbaccount->f('order_payment_code') . ') '; } ?> </td> <td width="17%"><?php echo $dbpm->f("order_payment_expire") ? vmFormatDate($dbpm->f("order_payment_expire"), '%b-%Y') : ''; ?> </td> </tr> <tr class="sectiontableheader">
function html_change_coupon_discount() { global $VM_LANG; $db = new ps_DB(); $q = "SELECT * FROM #__{vm}_orders WHERE order_id='" . $this->order_id . "'"; $db->query($q); $db->next_record(); ?> <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?> "> <?php echo $VM_LANG->_('PHPSHOP_COUPON_DISCOUNT'); ?> : <input type="text" value="<?php $db->p("coupon_discount"); ?> " size="5" name="coupon_discount" /> <input type="image" title="<?php echo $VM_LANG->_('PHPSHOP_UPDATE'); ?> " src="<?php echo VM_THEMEURL; ?> images/edit_f2.gif" border="0" alt="<?php echo $VM_LANG->_('PHPSHOP_UPDATE'); ?> " /> <input type="hidden" value="1" name="change_coupon_discount" /> <input type="hidden" name="page" value="order.order_print" /> <input type="hidden" name="option" value="com_virtuemart" /> <input type="hidden" name="func" value="" /> <input type="hidden" name="order_id" value="<?php echo $this->order_id; ?> " /> </form> <?php }
} ?> <tr class="<?php echo $bgcolor; ?> "> <td><?php $db->p("order_date"); ?> </td> <td><?php $db->p("number_of_orders"); ?> </td> <td><?php $dbis->p("items_sold"); ?> </td> <td><?php $db->p("revenue"); ?> </td> </tr> <?php $weekNum = 0; //CT.need this for weekly viewing of products // BEGIN product listing if (!empty($show_products)) { ?> <tr><td> </td><td colspan="2"> <table class="adminlist">
$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 {
<?php if (!defined('_VALID_MOS') && !defined('_JEXEC')) { die('Direct Access to ' . basename(__FILE__) . ' is not allowed.'); } /** * * @version $Id: shop.tos.php 1095 2007-12-19 20:19:16Z soeren_nb $ * @package VirtueMart * @subpackage html * @copyright Copyright (C) 2004-2007 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__); $db = new ps_DB(); $ps_vendor_id = $_SESSION['ps_vendor_id']; $q = "SELECT `vendor_id`, `vendor_terms_of_service` FROM `#__{vm}_vendor` "; $q .= "WHERE `vendor_id`='" . $ps_vendor_id . "'"; $db->query($q); $db->next_record(); $db->p("vendor_terms_of_service");
$dbpm = new ps_DB(); $q = "SELECT * FROM #__{vm}_payment_method, #__{vm}_order_payment, #__{vm}_orders "; $q .= "WHERE #__{vm}_order_payment.order_id='{$order_id}' "; $q .= "AND #__{vm}_payment_method.payment_method_id=#__{vm}_order_payment.payment_method_id "; $q .= "AND #__{vm}_orders.user_id='" . $db->f("user_id") . "' "; $q .= "AND #__{vm}_orders.order_id='{$order_id}' "; $dbpm->query($q); $dbpm->next_record(); ?> <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 ($dbpm->f("order_payment_name")) {
<fieldset> <legend><strong><?php echo $VM_LANG->_('PHPSHOP_PRODUCT_FORM_ITEM_ATTRIBUTES_LBL'); ?> </strong></legend> <?php while ($db2->next_record()) { ?> <div class="formLabel"><?php $db2->sp("attribute_name"); ?> :</div> <div class="formField" ><?php $db2->p("attribute_value"); ?> </div> <?php } ?> </fieldset> </div> <?php } ?> <div style="width:90%;float:left;"> <fieldset>
} } ?> <tr class="<?php echo $bgcolor; ?> " valign="top"> <?php $ps_order_change_html->html_change_delete_item($dbt->f("order_item_id")); ?> <?php $ps_order_change_html->html_change_item_quantity($dbt->f("order_item_id"), $dbt->f("product_quantity")); ?> <td width="30%" align="left"> <?php $dbt->p("order_item_name"); echo "<br /><span style=\"font-size: smaller;\">" . ps_product::getDescriptionWithTax($dbt->f("product_attribute")) . "</span>"; if ($downloadable) { echo '<br /><br /> <div style="font-weight:bold;">' . $VM_LANG->_('VM_DOWNLOAD_STATS') . '</div>'; if (empty($files)) { echo '<em>- ' . $VM_LANG->_('VM_DOWNLOAD_NOTHING_LEFT') . ' -</em>'; $enable_download_function = $ps_function->get_function('insertDownloadsForProduct'); if ($perm->check($enable_download_function['perms'])) { echo '<form action="' . $_SERVER['PHP_SELF'] . '" method="post"> <input type="hidden" name="page" value="' . $page . '" /> <input type="hidden" name="order_id" value="' . $order_id . '" /> <input type="hidden" name="product_id" value="' . $dbt->f('product_id') . '" /> <input type="hidden" name="user_id" value="' . $db->f('user_id') . '" /> <input type="hidden" name="func" value="insertDownloadsForProduct" /> <input type="hidden" name="vmtoken" value="' . vmSpoofValue($sess->getSessionId()) . '" />
$flypage = $db->f('category_flypage'); } $tt_item++; $pid = $db->f("product_parent_id") ? $db->f("product_parent_id") : $db->f("product_id"); ?> <tr class="<?php echo $sectioncolor; ?> "> <td width="15%"><?php printf("%02d", $tt_item); ?> </td> <td width="85%"> <a href="<?php $sess->purl(URL . "index.php?page=shop.product_details&flypage={$flypage}&product_id=" . $pid . "&category_id=" . $db->f("category_id")); ?> "> <?php $db->p("product_name"); ?> </a> </td> </tr> <?php } ?> </table> <!--Top 10 End-->