RMA Returns error for 2.2 MS2

DVBHardware · June 28, 2005

Keith , I have one small problem with 2.5c, whenever I click any of the html bar predefined text to insert, a message "ticket has sucessfuly updated" and a email is sent out to the customer.

I would think that the customer or ticket should be updated only when the update is pressed.

Jimmy

Gidgidonihah · June 28, 2005

Okay so I have got everything installed but the account_history_info.php and this is because I have the "Fancier Invoice & Packingslip v1.0" contrib installed.

The installation instructions say:

Find:

for ($i=0, $n=sizeof($order->products); $i<$n; $i++) {

Further below is another line:

if (sizeof($order->info['tax_groups']) > 1) {

Replace everything in between with:

// Begin RMA Returns

if ($order->products[$i]['return'] == '1') {

$rma_query_one = tep_db_query("SELECT returns_id FROM " . TABLE_RETURNS_PRODUCTS_DATA . " where products_id = '" . $order->products[$i]['id'] . "' and order_id = '" . $HTTP_GET_VARS['order_id'] . "'");

$rma_query = tep_db_fetch_array($rma_query_one);

$rma_number_query = tep_db_query("SELECT rma_value FROM " . TABLE_RETURNS . " where returns_id = '" . $rma_query['returns_id'] . "'");

$rma_result = tep_db_fetch_array($rma_number_query);

$return_link = '' . TEXT_RMA . ' # <a href="' . tep_href_link(FILENAME_RETURNS_TRACK, 'action=returns_show&rma=' . $rma_result['rma_value'], 'NONSSL') . '">' . $rma_result['rma_value'] . '</a>';

} else {

$return_link = '<a href="' . tep_href_link(FILENAME_RETURN, 'order_id=' . $HTTP_GET_VARS['order_id'] . '&products_id=' . ($order->products[$i]['id']), 'NONSSL') . '">' . TEXT_RETURN_PRODUCT .'</a>';

}

// Don't show Return link if order is still pending or processing

// You can change this or comment it out as best fits your store configuration

if (($orders_status == '1') OR ($orders_status == '2') ) {

$return_link = '';

}

echo ' <tr>' . "\n" .

' <td class="main" align="right" valign="top" width="30">' . $order->products[$i]['qty'] . ' x</td>' . "\n" .

' <td class="main" valign="top">' . $order->products[$i]['name'];

if ( (isset($order->products[$i]['attributes'])) && (sizeof($order->products[$i]['attributes']) > 0) ) {

for ($j=0, $n2=sizeof($order->products[$i]['attributes']); $j<$n2; $j++) {

echo ' - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value'] . '';

}

}

echo $return_link;

// JLM: End RMA Returns

echo '</td>' . "\n";

Which I don't have in my file because of the contrib. This is what my code looks like:

<?php
/*
 $Id: account_history_info.php,v 6.1 2005/06/05 23:03:52 PopTheTop Exp $

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2003 osCommerce

 Released under the GNU General Public License
*/

// BEGIN Fancier Order Details & Print Invoice

 require('includes/application_top.php');
 define('IMAGE_BUTTON_PRINT_ORDER', 'Print Invoice');

 if (!tep_session_is_registered('customer_id')) {
   $navigation->set_snapshot();
   tep_redirect(tep_href_link(FILENAME_LOGIN, '', 'SSL'));
 }

 if (!isset($HTTP_GET_VARS['order_id']) || (isset($HTTP_GET_VARS['order_id']) && !is_numeric($HTTP_GET_VARS['order_id']))) {
   tep_redirect(tep_href_link(FILENAME_ACCOUNT_HISTORY, '', 'SSL'));
 }
 
// Begin RMA Returns System - added order status ID to query
 $customer_info_query = tep_db_query("select customers_id, orders_status from " . TABLE_ORDERS . " where orders_id = '". (int)$HTTP_GET_VARS['order_id'] . "'");
 $customer_info = tep_db_fetch_array($customer_info_query);
 $orders_status = $customer_info['orders_status'];
 if ($customer_info['customers_id'] != $customer_id) {
   tep_redirect(tep_href_link(FILENAME_ACCOUNT_HISTORY, '', 'SSL'));
 }
// End RMA Returns System

 require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_ACCOUNT_HISTORY_INFO);

 $breadcrumb->add(NAVBAR_TITLE_1, tep_href_link(FILENAME_ACCOUNT, '', 'SSL'));
 $breadcrumb->add(NAVBAR_TITLE_2, tep_href_link(FILENAME_ACCOUNT_HISTORY, '', 'SSL'));
 $breadcrumb->add(sprintf(NAVBAR_TITLE_3, $HTTP_GET_VARS['order_id']), tep_href_link(FILENAME_ACCOUNT_HISTORY_INFO, 'order_id=' . $HTTP_GET_VARS['order_id'], 'SSL'));

 require(DIR_WS_CLASSES . 'order.php');
 $order = new order($HTTP_GET_VARS['order_id']);
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<?php
// BOF: WebMakers.com Changed: Header Tag Controller v1.0
// Replaced by header_tags.php
if ( file_exists(DIR_WS_INCLUDES . 'header_tags.php') ) {
 require(DIR_WS_INCLUDES . 'header_tags.php');
} else {
?> 
<title><?php echo HEADING_TITLE; ?> :: <?php echo TITLE; ?></title>
<?php
}
// EOF: WebMakers.com Changed: Header Tag Controller v1.0
?>
<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
<link rel="stylesheet" type="text/css" href="stylesheet.css">
<script language="javascript">
<!--
function popupPrintReceipt(url) {
 window.open(url,'popupPrintReceipt','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,re
sizable=yes,copyhistory=no,width=750')
}
//-->
</script>
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" width="100%" cellspacing="3" cellpadding="3">
 <tr>
   <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
   </table></td>
<!-- body_text //-->
  <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
  <TD ALIGN="right" VALIGN="top" class="order_history_top"><?php echo HEADING_ORDER_NUMBER; ?> <?php echo $HTTP_GET_VARS['order_id']; ?><BR><?php echo tep_date_long($order->info['date_purchased']); ?></TD>
</tr>
<tr>
   <td VALIGN="top">
 <table border="0" width="100%" cellspacing="0" cellpadding="0">
	 <tr>
   <TD>
   <table width="100%" border="0" cellspacing="0" cellpadding="2">
         <tr>
     <td colspan="4">
     <table width="100%" border="0" cellspacing="0" cellpadding="2">
          <tr>
            <td width="10%"><hr size="2"></td>
            <td align="center" class="pageHeading" NOWRAP><em><b><?php echo HEADING_TITLE2; ?></b></em></td>
            <td width="100%"><hr size="2"></td>
          </tr>
         </table>
         </td>
      </tr>
      <tr>
       <td colspan="4"><?php echo tep_draw_separator('pixel_trans.gif', '100', '5'); ?></td>
      </tr>
        <tr>
         <td valign="top">
           <table width="100%" border="0" cellpadding="0" cellspacing="0">
               <tr>
                 <td width="11"><img src="images/borders/maingrey_01.gif" width="11" height="16" alt=""></td>
                 <td background="images/borders/maingrey_02.gif"><img src="images/borders/maingrey_02.gif" width="24" height="16" alt="" ></td>
                 <td width="19"><img src="images/borders/maingrey_03.gif" width="19" height="16" alt=""></td>
               </tr>
               <tr>
                 <td background="images/borders/maingrey_04.gif"><img src="images/borders/maingrey_04.gif" width="11" height="21" alt=""></td>
                 <td align="center" bgcolor="#F2F2F2">
      	 <table width="100%" border="0" cellspacing="0" cellpadding="0" class="main">
                     <tr>
                       <td align="left" valign="top" class="order_infobox_heading"><b><?php echo HEADING_BILLING_ADDRESS; ?></b></td>
                     </tr>
                     <tr>
                       <td class="order_infobox_data">    <?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td>
                     </tr>
                     <tr>
                       <td class="order_infobox_data">    <?php echo tep_address_format($order->customer['format_id'], $order->customer, 1, '', '<br>    '); ?></td>
                     </tr>
                     <tr>
                       <td class="order_infobox_data">    <?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
                     </tr>
                     <tr>
                       <td class="order_infobox_data">    <?php echo $order->customer['telephone']; ?></td>
                     </tr>
                     <tr>
                       <td class="order_infobox_data">    <?php echo $order->customer['email_address']; ?></td>
                     </tr>
                     <tr>
                       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '7'); ?></td>
                     </tr>
                   </table>
       </td>
                 <td background="images/borders/maingrey_06.gif"><img src="images/borders/maingrey_06.gif" width="19" height="21" alt=""></td>
               </tr>
               <tr>
                 <td><img src="images/borders/maingrey_07.gif" width="11" height="18" alt=""></td>
                 <td background="images/borders/maingrey_08.gif"><img src="images/borders/maingrey_08.gif" width="24" height="18" alt=""></td>
                 <td><img src="images/borders/maingrey_09.gif" width="19" height="18" alt=""></td>
               </tr>
           </table>
           </td>
             <td width="15"> </td>
          	 <td valign="top">
             <table width="100%" border="0" cellpadding="0" cellspacing="0">
               <tr>
                 <td width="11"><img src="images/borders/mainwhite_01.gif" width="11" height="16" alt=""></td>
                 <td background="images/borders/mainwhite_02.gif"><img src="images/borders/mainwhite_02.gif" width="24" height="16" alt=""></td>
                 <td width="19"><img src="images/borders/mainwhite_03.gif" width="19" height="16" alt=""></td>
               </tr>
               <tr>
                 <td background="images/borders/mainwhite_04.gif"><img src="images/borders/mainwhite_04.gif" width="11" height="21" alt=""></td>
                 <td align="center" bgcolor="#FFFFFF">
        <table width="100%" border="0" cellpadding="0" cellspacing="0" class="main">
                     <tr>
                       <td align="left" valign="top" class="order_infobox_heading"><b><?php if (($order->info['shipping_method'])== METHOD_WILL_CALL){echo ENTRY_PICKUP_AT;}else echo HEADING_DELIVERY_ADDRESS; ?></b></td>
                     </tr>
                     <tr>
                       <td class="order_infobox_data">    <?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td>
                     </tr>
                     <tr>
                       <td class="order_infobox_data">    <?php if (($order->info['shipping_method'])== METHOD_WILL_CALL){echo STORE_NAME_ADDRESS_INVOICE;}else echo tep_address_format($order->delivery['format_id'], $order->delivery, 1, '', '<br>    '); ?></td>
                     </tr>
                     <tr>
                       <td class="order_infobox_data">    <?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
                     </tr>
                     <tr>
                       <td class="order_infobox_data">    </td>
                     </tr>
                     <tr>
                       <td class="order_infobox_data">    </td>
                     </tr>
                     <tr>
                       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '7'); ?></td>
                     </tr>
        </table>
       </td>
                 <td background="images/borders/mainwhite_06.gif"><img src="images/borders/mainwhite_06.gif" width="19" height="21" alt=""></td>
               </tr>
               <tr>
                 <td><img src="images/borders/mainwhite_07.gif" width="11" height="18" alt=""></td>
                 <td background="images/borders/mainwhite_08.gif"><img src="images/borders/mainwhite_08.gif" width="24" height="18" alt=""></td>
                 <td><img src="images/borders/mainwhite_09.gif" width="19" height="18" alt=""></td>
               </tr>
             </table>
           </td>
           </tr>
      </table>
    </TD>
   </tr>
   <tr>
   <TD><?php echo tep_draw_separator('pixel_trans.gif', '100', '15'); ?></td>
   </tr>
   <tr>
   <TD>
           <table width="100%" border="0" cellpadding="0" cellspacing="0">
           <tr>
             <td width="2"> </td>
               <td>
           <table width="100%" border="0" cellpadding="0" cellspacing="0">
            <tr>
                <td width="11"><img src="images/borders/maingrey_01.gif" width="11" height="16" alt=""></td>
                <td background="images/borders/maingrey_02.gif"><img src="images/borders/maingrey_02.gif" width="24" height="16" alt="" ></td>
                <td width="19"><img src="images/borders/maingrey_03.gif" width="19" height="16" alt=""></td>
            </tr>
            <tr>
                <td background="images/borders/maingrey_04.gif"><img src="images/borders/maingrey_04.gif" width="11" height="21" alt=""></td>
                <td align="center" bgcolor="#F2F2F2">
    	 <table width="100%" border="0" cellpadding="0" cellspacing="0" class="main">
      	 <tr>
                <td class="order_infobox_data"> <b><?php echo HEADING_ORDER_NUMBER; ?>:</b> <?php echo $HTTP_GET_VARS['order_id']; ?><br><?php echo tep_draw_separator('pixel_trans.gif', '100', '6'); ?><br> <b><?php echo HEADING_ORDER_DATE; ?></b> <?php echo tep_date_short($order->info['date_purchased']); ?></td>
<?php 
 if (tep_not_null($order->info['cc_number'])) {
   $this->cc_card_number_less_middle_digits = substr($order->info['cc_number'], 0, 4) . str_repeat('x', (strlen($order->info['cc_number']) - 8)) . substr($order->info['cc_number'], -4);
?>
                <td align="right" class="order_infobox_data"> <b><?php echo HEADING_PAYMENT_METHOD; ?></b> <?php echo $order->info['payment_method']; ?> (<?php echo $order->info['cc_type']; ?>)<br><?php echo tep_draw_separator('pixel_trans.gif', '100%', '6'); ?><br> <b><?php echo ENTRY_PAYMENT_CC_NUMBER; ?></b> <?php echo $this->cc_card_number_less_middle_digits; ?></td>
<?php 
 } else {
?>
                <td align="right" class="order_infobox_data"> <b><?php echo HEADING_PAYMENT_METHOD; ?></b> <?php echo $order->info['payment_method']; ?> </td>
<?php 
 }
?>
             </tr>
               <tr>
              	 <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '7'); ?></td>
               </tr>
    	 </table>
    	 </td>
             <td background="images/borders/maingrey_06.gif"><img src="images/borders/maingrey_06.gif" width="19" height="21" alt=""></td>
            </tr>
            <tr>
             <td><img src="images/borders/maingrey_07.gif" width="11" height="18" alt=""></td>
             <td background="images/borders/maingrey_08.gif"><img src="images/borders/maingrey_08.gif" width="24" height="18" alt=""></td>
             <td><img src="images/borders/maingrey_09.gif" width="19" height="18" alt=""></td>
            </tr>
         </table>
               </td>
           </tr>
           </table>
   </td>
   </tr>
   <tr>
   <TD><?php echo tep_draw_separator('pixel_trans.gif', '100%', '20'); ?></td>
   </tr>
     <tr>
   <td align="center">
   <table border="0" width="99%" cellspacing="0" cellpadding="2">
      	 <tr class="product_infobox_heading_row">
           <td class="product_infobox_heading" colspan="2"> <font color="#000000"><?php echo PRODUCTS; ?></font></td>
           <td WIDTH="80" class="product_infobox_heading"><font color="#000000"><?php echo SKU_OR_MODEL; ?></font></td>
           <td WIDTH="80" class="product_infobox_heading" align="right"><font color="#000000"><?php echo UNIT; ?></font></td>
           <TD WIDTH="80" ALIGN="right" CLASS="product_infobox_heading"><font color="#000000"><?php echo TOTAL; ?></font> </TD>
      	 </tr>
<?php
   for ($i = 0, $n = sizeof($order->products); $i < $n; $i++) {
 echo '      <tr class="product_infobox_data_row">' . "\n" .
      '        <td class="product_infobox_data" valign="top" align="right">' . $order->products[$i]['qty'] . ' x</td>' . "\n" .
      '        <td class="product_infobox_data" 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 '<br><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 WIDTH="80" class="product_infobox_data" valign="top">' . $order->products[$i]['model'] . '</td>' . "\n";
     echo '          <td WIDTH="80" class="product_infobox_data" align="right" valign="top">' . $currencies->format($order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value']) . '</td>' . "\n" .
          '          <td WIDTH="80" class="product_infobox_data" 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";
     echo '       	 </tr>' . "\n";
   }
?>
  	 <tr>
     <td align="right" colspan="5">
   <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>


<?php
 if (DOWNLOAD_ENABLED == 'true') include(DIR_WS_MODULES . 'downloads.php');
?>
     <tr>
       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '18'); ?></td>
     </tr>
     <tr>
       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '18'); ?></td>
     </tr>
     <tr>
    	 <TD>
        <table width="100%" border="0" cellpadding="0" cellspacing="0">
   <tr>
  	 <td width="2"> </td>
              <td>
          <table width="100%" border="0" cellpadding="0" cellspacing="0">
          <tr>
                <td width="11"><img src="images/borders/maingrey_01.gif" width="11" height="16" alt=""></td>
              <td background="images/borders/maingrey_02.gif"><img src="images/borders/maingrey_02.gif" width="24" height="16" alt="" ></td>
              <td width="19"><img src="images/borders/maingrey_03.gif" width="19" height="16" alt=""></td>
          </tr>
          <tr>
              <td background="images/borders/maingrey_04.gif"><img src="images/borders/maingrey_04.gif" width="11" height="21" alt=""></td>
              <td align="center" bgcolor="#F2F2F2">
      <table width="100%" border="0" cellpadding="0" cellspacing="0" class="main">
               <tr>
                    <td colspan="3" align="left" valign="top" class="order_infobox_heading"><b><?php echo ORDER_STATUS; ?></b></td>
               </tr>
<?php
 $statuses_query = tep_db_query("select os.orders_status_name, osh.date_added, osh.comments from " . TABLE_ORDERS_STATUS . " os, " . TABLE_ORDERS_STATUS_HISTORY . " osh where osh.orders_id = '" . (int)$HTTP_GET_VARS['order_id'] . "' and osh.orders_status_id = os.orders_status_id and os.language_id = '" . (int)$languages_id . "' order by osh.date_added");
 while ($statuses = tep_db_fetch_array($statuses_query)) {
     echo '                <tr>' . "\n";
     echo '                     <td valign="top" class="product_infobox_data" width="114"><br>    <strong>' . tep_date_short($statuses['date_added']) . '</strong></td>' . "\n";
     echo '                     <td valign="top" class="product_infobox_data" width="85"><br>' . $statuses['orders_status_name'] . '</td>' . "\n";
     echo '                     <td valign="top" class="product_infobox_data"><br>' . (empty($statuses['comments']) ? ' ' : nl2br(tep_output_string_protected($statuses['comments']))) . '</td>' . "\n";
     echo '                </tr>' . "\n";
 }
?>
               <tr>
                    <td colspan="3"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '7'); ?></td>
               </tr>
      </table>
      </td>
      <td background="images/borders/maingrey_06.gif"><img src="images/borders/maingrey_06.gif" width="19" height="21" alt=""></td>
          </tr>
          <tr>
            <td><img src="images/borders/maingrey_07.gif" width="11" height="18" alt=""></td>
            <td background="images/borders/maingrey_08.gif"><img src="images/borders/maingrey_08.gif" width="24" height="18" alt=""></td>
            <td><img src="images/borders/maingrey_09.gif" width="19" height="18" alt=""></td>
          </tr>
          </table>
          </td>
   </tr>
  </table></td>
</tr>
     <tr>
       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '25'); ?></td>
     </tr>
     <tr>
       <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
         <tr class="infoBoxContents">
           <td><table border="0" width="100%" cellspacing="0" cellpadding="2">
             <tr>
               <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
             <td><div style="float:left"><?php echo '<a href="' . tep_href_link(FILENAME_ACCOUNT_HISTORY, tep_get_all_get_params(array('order_id')), 'SSL') . '">' . tep_image_button('button_back.gif', IMAGE_BUTTON_BACK) . '</a></div><div style=float:right>'; ?><a href="javascript:popupPrintReceipt('<?php echo tep_href_link(FILENAME_ORDERS_PRINTABLE, tep_get_all_get_params(array('order_id')) . 'order_id=' . $HTTP_GET_VARS['order_id'], 'SSL'); ?>')"><?php echo tep_image_button('button_print_order.gif', IMAGE_BUTTON_PRINT_ORDER) . '</a>'; ?></div></td>
               <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
             </tr>
           </table></td>
         </tr>
       </table></td>
     </tr>
   </table></td>
</td>
 </tr>
</table><!-- body_text_eof //-->
   <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
<!-- right_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>
<!-- right_navigation_eof //-->
   </table></td>
 </tr>
</table>
<!-- body_eof //-->

<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
<?php
// END Fancier Order Details & Print Invoice
?>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

Any help with this would be great. Thanks!

Bigredman74 · June 29, 2005

You rock!!!!!!!!!!! :) that did the trick! Thanks for your help and time in figuring this out!
although I am still not able to get the RMA number to show up on the confirmation screen return_product.php- it just says "Your RMA Number is:" and then is blank. any ideas there? I have a fresh copy of return_product.php running....

<{POST_SNAPBACK}>

I'm having the same problem with the RMA number not showing up. I tried changing the colors and still nothing. Any thoughts?

Bigredman74 · June 29, 2005

almost done, most ofit works by now I guess

only thing is ater refunding and mailing the customer, customer gets an mail with a possibility to et some kinda voucher from the website called gv_redeem and something.

if I click it I get an error saying: 404 file not found.

If I look at the locale folder I can not find the GV_REDEEM.PHP file that should be there according to the mail sent.

someone please ? were can I find tis file ?

<{POST_SNAPBACK}>

Do you have the Credit Class & Gift Voucher contrib installed? (http://www.oscommerce.com/community/contributions,282). If not, that might be your reason.

I have this contrib installed and the link in email results in a 404 error. The link is correct and appears correct in the address bar too, but I still get the 404 error. The gift voucher code still works in the checkout process. Has anyone else experienced this or have a fix for it. Thanks.

homewetbar · June 29, 2005

Okay so I have got everything installed but the account_history_info.php and this is because I have the "Fancier Invoice & Packingslip v1.0" contrib installed.
The installation instructions say:

Which I don't have in my file because of the contrib. This is what my code looks like:

Any help with this would be great. Thanks!

<{POST_SNAPBACK}>

I'm guessing you would put it after:

for ($i = 0, $n = sizeof($order->products); $i < $n; $i++)

but you'll need to manually alter some of the code. I doubt many people reading this thread have that contrib but you might try posting it in the Invoice & Packingslip thread and see if anyone has any ideas or just think it through...

June 30, 2005

<{POST_SNAPBACK}>

Now the link is showing up correctly in the taskbar

--- oscommerce-testshop/admin/returns.php?order_id=6&products_id=26 ---

And I suppose it is correctly if I get sended to the product returns page ? without an opening of some kinda form to commit the actual RMA ?

PS, still if I alter the filename into return.php I keep getting an error, and I have searched everything ( including my inside pocket ) but I can not fian a file called return.php anywhere on my server install, so who is getting old here and doesn't see things right ?

PS2, It's possible that I can not answer you reactions rightaway because I am in and out of hospital almost on a weekly base right now, for my Crohn desease is getting worse as ever and I am in constant pain nowadays, so please have patience ;-)

Bigredman74 · June 30, 2005

I have this contrib installed and the link in email results in a 404 error. The link is correct and appears correct in the address bar too, but I still get the 404 error. The gift voucher code still works in the checkout process. Has anyone else experienced this or have a fix for it. Thanks.
<{POST_SNAPBACK}>

Please disregard this part of my previous post above. This is NOT a problem with this contribution. I apologize for my error. But I still haven't found a fix for the RMA number not showing up.

I am experiencing the email link problem with any link in an email when testing the site locally on my desktop. Once published to the web, the links in the email work. However, if a link refers to a page within a customer's account, it takes them to the login screen, even if they have previously logged in (i.e. just prior to clicking the link). Once they log in they are taken to the site's home page. I know this is not a discussion for this topic because it happens from every link, not just the RMA Returns links, but if anyone else has experienced this or seen a thread about it, please let me know. I'm off to the search the forums.

July 1, 2005

1109 - Onbekende tabel 'returns_status_ido' in field list

select o.returns_id, returns_status_ido.customers_name, o.contact_user_name, o.rma_value, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.return_reason_name, op.final_price, o.returns_date_finished from returned_products o left join returns_products_data op on (o.returns_id = op.returns_id), return_reasons s where o.returns_reason = s.return_reason_id and s.language_id = '4' and o.returns_status = '9' order by o.returns_id DESC limit -20, 20

[TEP STOP]

Keep getting this error if I select anything else then all rma in rma section, open, canceled and all other coices result in this error.

?????? anyone ?

July 1, 2005

Now the link is showing up correctly in the taskbar
--- oscommerce-testshop/admin/returns.php?order_id=6&products_id=26 ---

And I suppose it is correctly if I get sended to the product returns page ? without an opening of some kinda form to commit the actual RMA ?

PS, still if I alter the filename into return.php I keep getting an error, and I have searched everything ( including my inside pocket ) but I can not fian a file called return.php anywhere on my server install, so who is getting old here and doesn't see things right ?

PS2, It's possible that I can not answer you reactions rightaway because I am in and out of hospital almost on a weekly base right now, for my Crohn desease is getting worse as ever and I am in constant pain nowadays, so please have patience ;-)

<{POST_SNAPBACK}>

Gotcha, shame on me, thought I had return.php defined but misread my filenames.php and had only returns.php in it.

Okay, now link is showing me the RMA form

next problem ;-)

July 1, 2005

1109 - Onbekende tabel 'returns_status_ido' in field list

select o.returns_id, returns_status_ido.customers_name, o.contact_user_name, o.rma_value, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.return_reason_name, op.final_price, o.returns_date_finished from returned_products o left join returns_products_data op on (o.returns_id = op.returns_id), return_reasons s where o.returns_reason = s.return_reason_id and s.language_id = '4' and o.returns_status = '9' order by o.returns_id DESC limit -20, 20

[TEP STOP]

Keep getting this error if I select anything else then all rma in rma section, open, canceled and all other coices result in this error.

?????? anyone ?

<{POST_SNAPBACK}>

any chance this could be the code for this ? and maybe some dev can find the problem ?

// NEW "IF ELSEIF ELSE" ADDED BY BURT SO REPLACE THE OLD ONE WITH THIS

     $orders_query_raw = "select o.returns_id, o.customers_name, o.contact_user_name, o.rma_value, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.return_reason_name, op.final_price, o.returns_date_finished from " . TABLE_RETURNS . " o left join " . TABLE_RETURNS_PRODUCTS_DATA . " op on (o.returns_id = op.returns_id), " . TABLE_RETURN_REASONS . " s where o.returns_reason = s.return_reason_id and s.language_id = '" . $languages_id . "' and o.rma_value = '" . $cID . "' order by o.returns_id DESC";
    } elseif ($HTTP_GET_VARS['status']) {
     $status = tep_db_prepare_input($HTTP_GET_VARS['status']);

    $orders_query_raw = "select o.returns_id, returns_status_ido.customers_name, o.contact_user_name, o.rma_value, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.return_reason_name, op.final_price, o.returns_date_finished from " . TABLE_RETURNS . " o left join " . TABLE_RETURNS_PRODUCTS_DATA . " op on (o.returns_id = op.returns_id), " . TABLE_RETURN_REASONS . " s where o.returns_reason = s.return_reason_id and s.language_id = '" . $languages_id . "' and o.returns_status = '" . $status . "' order by o.returns_id DESC";

     } else {
     $orders_query_raw = "select o.returns_id, o.customers_name, o.contact_user_name, o.rma_value, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.return_reason_name, op.final_price, o.returns_date_finished from " . TABLE_RETURNS . " o left join " . TABLE_RETURNS_PRODUCTS_DATA . " op on (o.returns_id = op.returns_id), " . TABLE_RETURN_REASONS . " s where o.returns_reason = s.return_reason_id and s.language_id = '" . $languages_id . "' order by o.returns_id DESC";
   }
// END BURT

July 1, 2005

any chance this could be the code for this ? and maybe some dev can find the problem ?

// NEW "IF ELSEIF ELSE" ADDED BY BURT SO REPLACE THE OLD ONE WITH THIS

? ? ?$orders_query_raw = "select o.returns_id, o.customers_name, o.contact_user_name, o.rma_value, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.return_reason_name, op.final_price, o.returns_date_finished [COLOR=red]from " . TABLE_RETURNS [/COLOR]. " o left join " . TABLE_RETURNS_PRODUCTS_DATA . " op on (o.returns_id = op.returns_id), " . TABLE_RETURN_REASONS . " s where o.returns_reason = s.return_reason_id and s.language_id = '" . $languages_id . "' and o.rma_value = '" . $cID . "' order by o.returns_id DESC";
? ? } elseif ($HTTP_GET_VARS['status']) {
? ? ?$status = tep_db_prepare_input($HTTP_GET_VARS['status']);

? ? $orders_query_raw = "select o.returns_id, returns_status_ido.customers_name, o.contact_user_name, o.rma_value, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.return_reason_name, op.final_price, o.returns_date_finished [COLOR=red]from " . TABLE_RETURNS [/COLOR]. " o left join " . TABLE_RETURNS_PRODUCTS_DATA . " op on (o.returns_id = op.returns_id), " . TABLE_RETURN_REASONS . " s where o.returns_reason = s.return_reason_id and s.language_id = '" . $languages_id . "' and o.returns_status = '" . $status . "' order by o.returns_id DESC";

? ? ?} else {
? ? ?$orders_query_raw = "select o.returns_id, o.customers_name, o.contact_user_name, o.rma_value, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.return_reason_name, op.final_price, o.returns_date_finished [COLOR=red]from " . TABLE_RETURNS [/COLOR]. " o left join " . TABLE_RETURNS_PRODUCTS_DATA . " op on (o.returns_id = op.returns_id), " . TABLE_RETURN_REASONS . " s where o.returns_reason = s.return_reason_id and s.language_id = '" . $languages_id . "' order by o.returns_id DESC";
? ?}
// END BURT

<{POST_SNAPBACK}>

Can't find a table returns anywhere in my Db, but clearly the sql selects from table returns ! as I read it, so where will this data be found ?

PS color tags don't work in qoute, sorry, tried it to illuminate what I mean, so between the tag code you'll find what is meant

Edited July 1, 2005 by jans

July 1, 2005

Can't find a table returns anywhere in my Db, but clearly the sql selects from table returns ! as I read it, so where will this data be found ?

PS color tags don't work in qoute, sorry, tried it to illuminate what I mean, so between the tag code you'll find what is meant

<{POST_SNAPBACK}>

Yessss, if I copy the old one from version 2.4.1 into place the selection works fine, so the section added by Burt contains the problem.

Can someone pleas look into this ?

July 1, 2005

Yessss, if I copy the old one from version 2.4.1 into place the selection works fine, so the section added by Burt contains the problem.

Can someone pleas look into this ?

<{POST_SNAPBACK}>

copy this into place and it's okay

// NEW "IF ELSEIF ELSE" ADDED BY BURT SO REPLACE THE OLD ONE WITH THIS

     $orders_query_raw = "select o.returns_id, o.customers_name, o.rma_value, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.return_reason_name, op.final_price, o.returns_date_finished from " . TABLE_RETURNS . " o left join " . TABLE_RETURNS_PRODUCTS_DATA . " op on (o.returns_id = op.returns_id), " . TABLE_RETURN_REASONS . " s where o.returns_reason = s.return_reason_id and s.language_id = '" . $languages_id . "' and o.rma_value = '" . $cID . "' order by o.returns_id DESC";
    } elseif ($HTTP_GET_VARS['status']) {
     $status = tep_db_prepare_input($HTTP_GET_VARS['status']);

    $orders_query_raw = "select o.returns_id, o.customers_name, o.rma_value, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.return_reason_name, op.final_price, o.returns_date_finished from " . TABLE_RETURNS . " o left join " . TABLE_RETURNS_PRODUCTS_DATA . " op on (o.returns_id = op.returns_id), " . TABLE_RETURN_REASONS . " s where o.returns_reason = s.return_reason_id and s.language_id = '" . $languages_id . "' and o.returns_status = '" . $status . "' order by o.returns_id DESC";

     } else {
     $orders_query_raw = "select o.returns_id, o.customers_name, o.rma_value, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.return_reason_name, op.final_price, o.returns_date_finished from " . TABLE_RETURNS . " o left join " . TABLE_RETURNS_PRODUCTS_DATA . " op on (o.returns_id = op.returns_id), " . TABLE_RETURN_REASONS . " s where o.returns_reason = s.return_reason_id and s.language_id = '" . $languages_id . "' order by o.returns_id DESC";
   }
// END BURT

July 1, 2005

In the product returns form you can choose credit method in one of the choice boxes.

In my case I see all the credit methods in every language I use and also see paypal and nochecks and all kinda other methods that I even did not install.

How come ?

homewetbar · July 1, 2005

Jans,

Just a little consideration for the other members, your 3,4,5,6 posts in a row really clutters the board up for people that are looking for answers.

Please try and condense your posts into one or two on a given problem instead of posting every time a thought comes to mind out of respect for others that are trying to use the board. :thumbsup:

Edited July 1, 2005 by homewetbar

July 4, 2005

Jans,

Just a little consideration for the other members, your 3,4,5,6 posts in a row really clutters the board up for people that are looking for answers.

Please try and condense your posts into one or two on a given problem instead of posting every time a thought comes to mind out of respect for others that are trying to use the board. :thumbsup:

<{POST_SNAPBACK}>

Not to be disrespectfull but give a user enough time to edit his own posts and this will not happen again.

I et for about two minutes to edit my own post and then I get an access error of some kind, I find this very userunfriendly here, that's why you get this kinda posts.

;-0 amazed but true

July 4, 2005

In the product returns form you can choose credit method in one of the choice boxes.

In my case I see all the credit methods in every language I use and also see paypal and nochecks and all kinda other methods that I even did not install.

How come ?

<{POST_SNAPBACK}>

bump

July 4, 2005

In case someone trips over me again, you better post messages faster because els You only get messages from me after each other and the result will be more then 10 posts in a row ;-)

No joke;

The schedule return link in the customers order artikel list does now work correctly but now the red Returns link in the artikel list gets me to the same form, but without pre-filled data.

I know for shure it linked to the returns.php listing before but now it links to return_product.php.

Where can I find this link code ?

July 4, 2005

In case someone trips over me again, you better post messages faster because els You only get messages from me after each other and the result will be more then 10 posts in a row ;-)
No joke;

The schedule return link in the customers order artikel list does now work correctly but now the red Returns link in the artikel list gets me to the same form, but without pre-filled data.

I know for shure it linked to the returns.php listing before but now it links to return_product.php.

Where can I find this link code ?

<{POST_SNAPBACK}>

kill fido kill, found and repaired.

you can now safely kill and remove all my posts if it's getting to much for you ;-)

uberdragon · July 4, 2005

Hello there. I've installed RMA System 2.5c contributed by Keith W.

The only other mods installed are

QT Pro

Paypal IPN

While going through testing to return an item I got the following error:

Fatal error: Call to undefined function: tep_create_rma_value() in /home/dtkstore/public_html/cart/return_product.php on line 39

This error occurs when the customer completes the RMA form. Everything else appears to be working. I can initiate the RMA from admin side, the customer is then able to find and track their RMA, I'm able to process the RMA from start to finish (admin side).

The lines of code this error refers to is as follows:

38)         // carry out a query on all the existing orders tables, to get the required information
39)         $rma_create = tep_create_rma_value(11);
40)         $returns_status_query = tep_db_query("SELECT configuration_value FROM " . TABLE_CONFIGURATION . " where configuration_key = 'DEFAULT_RETURN_STATUS_ID'");

Thank you for any advice you can give on fixing up this error.

homewetbar · July 4, 2005

Hello there. I've installed RMA System 2.5c contributed by Keith W.

The only other mods installed are

QT Pro

Paypal IPN

While going through testing to return an item I got the following error:

Fatal error: Call to undefined function: tep_create_rma_value() in /home/dtkstore/public_html/cart/return_product.php on line 39

This error occurs when the customer completes the RMA form. Everything else appears to be working. I can initiate the RMA from admin side, the customer is then able to find and track their RMA, I'm able to process the RMA from start to finish (admin side).

The lines of code this error refers to is as follows:
38) ? ? ? ? // carry out a query on all the existing orders tables, to get the required information
39) ? ? ? ? $rma_create = tep_create_rma_value(11);
40) ? ? ? ? $returns_status_query = tep_db_query("SELECT configuration_value FROM " . TABLE_CONFIGURATION . " where configuration_key = 'DEFAULT_RETURN_STATUS_ID'");
Thank you for any advice you can give on fixing up this error.

<{POST_SNAPBACK}>

You are missing something in the includes directory. Go back over the install and make sure you did not forget anything or any files. Specific is looks like you are missing the tep_create_rma_value function...

uberdragon · July 4, 2005

Yup I found the problem. I had added a // infront of that function call during installation for some reason lol. So it was commented out. Thanks for the fast response though :)

fyfthelement · July 5, 2005

Need help plz. I have added the RMA onto my website and its working properly in the admin section but not at all in my catalog. Might have to do with the style im using on my site. WILL GET TO THAT PART LATER. But my main problem has to do with Returns.php is showing incorrect refund amount once i have scheduled a return. I have added attributes on all of the my products and I fixed the solution in the returned_products.php file and thats working properly now. I simply changed "products_price" with "final_price". But my "final price" on returns.php isnt showing that same price. Its showing original price of product w/o added attributes...NEED HELP PLZ!!! Thanks.

F DOT ELEMEMT

randm2005 · July 10, 2005

Just to clarify things a little. I am a little confused at the RMA install instructions. I downloaded 2.5c Version.

Do I need the Credit & Gift voucher Mod installed ?

I unzipped quite allot of files in this mod but the instructions talk about manually editing this file and that. Do I have to manually edit them or do I just replace my current files with the unzipped ones ?

I am a new now on 17 hours of code sorting my brain and eye's are fried. Please Help !

Rob

homewetbar · July 10, 2005

Just to clarify things a little. I am a little confused at the RMA install instructions. I downloaded 2.5c Version.

Do I need the Credit & Gift voucher Mod installed ?

I unzipped quite allot of files in this mod but the instructions talk about manually editing this file and that. Do I have to manually edit them or do I just replace my current files with the unzipped ones ?

I am a new now on 17 hours of code sorting my brain and eye's are fried. Please Help !

Rob

<{POST_SNAPBACK}>

Question 1: I don't know, but I would think you should be fine with no GV put pay attention during your install their might be a few things that reference it that you can leave out if you do not have the GV

Question 2: You should ALWAYS cut and paste code, I would never overwrite files unless it is a completely clean code, you're just asking for trouble if you do that...

RMA Returns error for 2.2 MS2

Recommended Posts

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

shaggy2dope2125

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation