Jump to content
Sign in to follow this  
spoiledRHOtten

Problem with RMA Return contribution

Recommended Posts

dave just pm me if you need a hand, i'll do my best to help out, ability and time permitting :wink: .

 

 

cheers

barry


"A lie gets halfway around the world before the truth has a chance to get its pants on."

 

"I don't want to achieve immortality through my work; I want to achieve immortality through not dying."

Share this post


Link to post
Share on other sites

okay,

 

try placing that same line of code between the following

 

if ($HTTP_POST_VARS['notify'] == 'on') {

and

 $notify_comments = '';

 

in the admin/returns.php file

 

should be lines 136-137


Instant idiot......Just add mud !!

Share this post


Link to post
Share on other sites

nope......not that either....

 

I think I'm gonna cry......

 

can you just email me your file? *giggle* have you tested yours?

 

as far as sending the email?

Share this post


Link to post
Share on other sites

Hey Dave, Thank you for all of your great help. I have noticed though, that the RMA once completed and accepted does not update the order history. Shouldn't there be a new record in the Order History table?

Share this post


Link to post
Share on other sites

Hi There,

 

I was wondering if anyone found a fix to this problem yet. It only occurs when there is a Return Product in adminreturns.php

 

Warning: unexpected error in date() in c:nusphereapachehtdocsadminincludesfunctionsgeneral.php on line 111

 

Thanks,

David

Share this post


Link to post
Share on other sites

Fix to the datetime problem causing errors in general.php,

 

Just run the below query on your database, and it should solve your problems

 

ALTER TABLE returned_products CHANGE returns_date_finished returns_date_finished DATETIME DEFAULT "00-00-00 00:00:00";


Instant idiot......Just add mud !!

Share this post


Link to post
Share on other sites

Hi!

 

I was wondering...for some reason...in account_history_info.php

 

 

the RMA # does not show up so i had to change it to the word "RETURNED" instead of "Return #"...

 

I'd really like the return # to show up...is there a fix for this?

Share this post


Link to post
Share on other sites

Hey Dave,

 

one more thing...

 

for some reason, when a product is returned....

the attributes are not included into what is returned.

 

Is there a way to fix that? If so, that'd be great cause most of my products have Addon Attributes...w/ extra pricing...

 

thanks,

 

court

Share this post


Link to post
Share on other sites

After battling hard with this code, ive followed all instruction and had lots of different errors, ive changed the code as described in this forum but to no avail.

 

I have the admin section working (i think) But shouldnt there be a returns link from the main page or is it just accessable from the order history?

 

The problem below happens when i click order history

 

Parse error: parse error, unexpected '.' in /home/domecomp/public_html/shop/account_history_info.php on line 140

 

Thanks in advance

Share this post


Link to post
Share on other sites

here is a copy of my account_history_info.php

 

I indicated my line 140 here...i dont know if it will help...and it might not...but i thought i'd try to help ya anyway.....;)

 

<?php

/*

 $Id: account_history_info.php,v 1.87 2002/08/08 22:36:45 hpdl Exp $

 

 osCommerce, Open Source E-Commerce Solutions

 http://www.oscommerce.com

 

 Copyright © 2002 osCommerce

 

 Released under the GNU General Public License

*/

 

 require('includes/application_top.php');

 

 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'])) {

   tep_redirect(tep_href_link(FILENAME_HISTORY, '', 'SSL'));

 }

 

 $customer_number_query = tep_db_query("select customers_id from " . TABLE_ORDERS . " where orders_id = '". tep_db_input(tep_db_prepare_input($HTTP_GET_VARS['order_id'])) . "'");

 $customer_number = tep_db_fetch_array($customer_number_query);

 if ($customer_number['customers_id'] != $customer_id) {

   tep_redirect(tep_href_link(FILENAME_ACCOUNT_HISTORY, '', 'SSL'));

 }

 

 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(NAVBAR_TITLE_3, 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>

<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">

<title><?php echo TITLE; ?></title>

<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">

<link rel="stylesheet" type="text/css" href="stylesheet.css">

</head>

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">

<!-- 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><table border="0" width="100%" cellspacing="0" cellpadding="0">

         <tr>

           <td class="pageHeading"><?php echo HEADING_TITLE; ?></td>

           <td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_history.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>

         </tr>

       </table></td>

     </tr>

     <tr>

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

     </tr>

     <tr>

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

         <tr>

           <td class="main" colspan="2"><b><?php echo sprintf(HEADING_ORDER_NUMBER, $HTTP_GET_VARS['order_id']) . ' <small>(' . $order->info['orders_status'] . ')</small>'; ?></b></td>

         </tr>

         <tr>

           <td class="smallText"><?php echo HEADING_ORDER_DATE . ' ' . tep_date_long($order->info['date_purchased']); ?></td>

           <td class="smallText" align="right"><?php echo HEADING_ORDER_TOTAL . ' ' . $order->info['total']; ?></td>

         </tr>

       </table></td>

     </tr>

     <tr>

       <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">

         <tr class="infoBoxContents">

<?php

 if ($order->delivery != false) {

?>

           <td width="30%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">

             <tr>

               <td class="main"><b><?php echo HEADING_DELIVERY_ADDRESS; ?></b></td>

             </tr>

             <tr>

               <td class="main"><?php echo tep_address_format($order->delivery['format_id'], $order->delivery, 1, ' ', '<br>'); ?></td>

             </tr>

<?php

 if ($order->info['shipping_method']) {

?>

             <tr>

               <td class="main"><b><?php echo HEADING_SHIPPING_METHOD; ?></b></td>

             </tr>

             <tr>

               <td class="main"><?php echo $order->info['shipping_method']; ?></td>

             </tr>

<?php

 }

?>

           </table></td>

<?php

 }

?>

           <td width="<?php echo (($order->delivery != false) ? '70%' : '100%'); ?>" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">

             <tr>

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

<?php

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

?>

                 <tr>

                   <td class="main" colspan="2"><b><?php echo HEADING_PRODUCTS; ?></b></td>

                   <td class="smallText" align="right"><b><?php echo HEADING_TAX; ?></b></td>

                   <td class="smallText" align="right"><b><?php echo HEADING_TOTAL; ?></b></td>

                 </tr>

<?php

 } else {

?>

                 <tr>

                   <td class="main" colspan="3"><b><?php echo HEADING_PRODUCTS; ?></b></td>

                 </tr>

<?php

 }

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

// BMC RMA Start  

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);

 

------------LINE 140----------->>>>>>>>>$return_link = '<font color=blue><b>Returned  <a href="returns_track.php?action=returns_show&rma=' . $rma_result['rma_value'] . '">' . $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']), 'SSL') . '"><font color=red><b>Return</a></b></font>';

}

 

// BMC RMA End  

   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'] . '   ' . $return_link. ' ' . $return_link_two .'<br><small><i>' . $desc['products_description'] . '</i></small>';

   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 '<br><nobr><small> <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value'] . '</i></small></nobr>';

     }

   }

 

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

 

   if (sizeof($order->info['tax_groups']) > 1) echo '            <td class="main" valign="top" align="right">' . tep_display_tax_value($order->products[$i]['tax']) . '%</td>' . "n";

 

   echo '            <td class="main" align="right" valign="top">' . $currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']) * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . '</td>' . "n" .

        '          </tr>' . "n";

 }

?>

               </table></td>

             </tr>

           </table></td>

         </tr>

       </table></td>

     </tr>

     <tr>

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

     </tr>

     <tr>

       <td class="main"><b><?php echo HEADING_BILLING_INFORMATION; ?></b></td>

     </tr>

     <tr>

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

     </tr>

     <tr>

       <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">

         <tr class="infoBoxContents">

           <td width="30%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">

             <tr>

               <td class="main"><b><?php echo HEADING_BILLING_ADDRESS; ?></b></td>

             </tr>

             <tr>

               <td class="main"><?php echo tep_address_format($order->customer['format_id'], $order->customer, 1, ' ', '<br>'); ?></td>

             </tr>

             <tr>

               <td class="main"><b><?php echo HEADING_PAYMENT_METHOD; ?></b></td>

             </tr>

             <tr>

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

             </tr>

           </table></td>

           <td width="70%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">

<?php

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

   echo '              <tr>' . "n" .

        '                <td class="main" align="right" width="100%">' . $order->totals[$i]['title'] . '</td>' . "n" .

        '                <td class="main" align="right">' . $order->totals[$i]['text'] . '</td>' . "n" .

        '              </tr>' . "n";

 }

?>

           </table></td>

         </tr>

       </table></td>

     </tr>

     <tr>

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

     </tr>

     <tr>

       <td class="main"><b><?php echo HEADING_ORDER_HISTORY; ?></b></td>

     </tr>

     <tr>

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

     </tr>

     <tr>

       <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">

         <tr class="infoBoxContents">

           <td width="30%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">

<?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 = '" . $HTTP_GET_VARS['order_id'] . "' and osh.orders_status_id = os.orders_status_id and os.language_id = '" . $languages_id . "' order by osh.date_added");

 while ($statuses = tep_db_fetch_array($statuses_query)) {

   echo '              <tr>' . "n" .

        '                <td class="main" valign="top" width="70">' . tep_date_short($statuses['date_added']) . '</td>' . "n" .

        '                <td class="main" valign="top" width="70">' . $statuses['orders_status_name'] . '</td>' . "n" .

 

 

        '                <td class="main" valign="top">' . (empty($statuses['comments']) ? ' ' : nl2br(tep_db_output($statuses['comments']))) . '</td>' . "n" .

        '              </tr>' . "n";

 }

?>

           </table></td>

         

               

   

         </tr>

       </table></td>

     </tr>

<?php

/*Tracking contribution begin*/

   if ($order->info['fedex_track_num'] == NULL) {

?>

    <tr>

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '1'); ?></td>

     </tr>

<?php

} else {

?>

    <tr>

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

     </tr>

     <tr>

       <td class="main"><b><?php echo HEADING_TRACKING; ?></b></td>

     </tr>

     <tr>

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

     </tr>

     <tr>

       <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">

         <tr class="infoBoxContents">

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

             <tr>

               <td class="main"><a href="http://www.fedex.com/cgi-bin/tracking?tracknumbers=<?php echo $order->info['fedex_track_num']; ?>&action=track&language=english&cntry_code=us" target="_blank"><?php echo $order->info['fedex_track_num']; ?></a>  Fedex</td>

             </tr>

           </table></td>

         </tr>

       </table>

      </td>

     </tr>

<?php

}

   if ($order->info['ups_track_num'] == NULL) {

?>

    <tr>

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '1'); ?></td>

   </tr>

<?php

} else {

?>

   <tr>

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

     </tr>

     <tr>

       <td class="main"><b><?php echo HEADING_TRACKING; ?></b></td>

     </tr>

     <tr>

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

     </tr>

     <tr>

       <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">

         <tr class="infoBoxContents">

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

             <tr>

               <td class="main"><a href="http://wwwapps.ups.com/etracking/tracking.cgi?InquiryNumber1=<?php echo $order->info['ups_track_num']; ?>&InquiryNumber2=&InquiryNumber3=&InquiryNumber4=&InquiryNumber5=&TypeOfInquiryNumber=T&UPS_HTML_License=EB930E9723678ED4&UPS_HTML_Version=3.0&IATA=us&Lang=en&submit=Track+Package" target="_blank"><?php echo $order->info['ups_track_num']; ?></a>  UPS</td>

             </tr>

           </table></td>

         </tr>

       </table>

      </td>

     </tr>

<?php

}

   if ($order->info['usps_track_num'] == NULL) {

?>

    <tr>

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '1'); ?></td>

   </tr>

<?php

} else {

?>

   <tr>

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

     </tr>

     <tr>

       <td class="main"><b><?php echo HEADING_TRACKING; ?></b></td>

     </tr>

     <tr>

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

     </tr>

     <tr>

       <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">

         <tr class="infoBoxContents">

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

             <tr>

               <td class="main"><a href="http://trkcnfrm1.smi.usps.com/netdata-cgi/db2www/cbd_243.d2w/output?CAMEFROM=OK&strOrigTrackNum=<?php echo $order->info['usps_track_num']; ?>" target="_blank"><?php echo $order->info['usps_track_num']; ?></a>  USPS</td>

             </tr>

           </table></td>

         </tr>

       </table>

      </td>

     </tr>

<?php

}

/*Tracking contribution end*/

 if (DOWNLOAD_ENABLED == 'true') include(DIR_WS_BOXES . 'downloads.php');

?>

     <tr>

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

     </tr>

     <tr>

       <td align="right" class="main"><?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>'; ?></td>

     </tr>

<tr>

       <td align="right" class="main"><?php echo '<a href="' . tep_href_link(FILENAME_ORDERS_PRINTABLE, tep_get_all_get_params(array('order_id')) . 'order_id=' . $HTTP_GET_VARS['order_id'], 'SSL') . '" TARGET="_blank">' . tep_image_button('button_printorder.gif', IMAGE_BUTTON_PRINT_ORDER) . '</a>'; ?></td>

</tr>

   </table></td>

<!-- 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 //-->

<br>

</body>

</html>

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

Share this post


Link to post
Share on other sites

Thanks for the reply but now im getting the following

 

Parse error: parse error, unexpected T_DEC, expecting T_VARIABLE or '$' in /home/domecomp/public_html/shop/account_history_info.php on line 140

Share this post


Link to post
Share on other sites

sorry , i removed your >>>>>>>>>>>>>>live 140 bit

 

but now get this.....

 

Parse error: parse error, unexpected T_DOUBLE_ARROW in /home/domecomp/public_html/shop/includes/classes/order.php on line 116

 

Fatal error: Cannot instantiate non-existent class: order in /home/domecomp/public_html/shop/account_history_info.php on line 37

Share this post


Link to post
Share on other sites

I am testing and using the RMA contribution and I am having a problem when I return any item with a quantity greater then 1.

 

The problem shows up in the following locations:

 

1. Customer tracks the return and the total shown there is much greater then it should be.

 

2. In the Admin panel if you go to "Customer Returns -> Returned Products" the total shown there on the line is correct, however if you select the return and go to edit, then the total shown in there is way off as well. The problem also shows up in the Invoice section of the Returns.

 

As long as the product being returned is not a quantity greater then 1 things appear to be fine.

 

Site is not live yet, and I would be willing to work with someone on resolving this and showing them what I am talking about. Hoping to go live shortly after resolving this, so the sooner the better for me.


RasnCain@TheHostingZone.com

www.TheHostingZone.com

Share this post


Link to post
Share on other sites

To solve the price problem on the customer side, look for the following line (approx 389)

 

echo '            <td class="main" align="right" valign="top">' . $currencies->format(($returned_products['final_price']) * ($returned_products['products_quantity'])) . '</td>' . "n" .

 

and change it to read

 

echo '            <td class="main" align="right" valign="top">' . $currencies->format(($returned_products['price']) * ($returned_products['products_quantity'])) . '</td>' . "n" .


Instant idiot......Just add mud !!

Share this post


Link to post
Share on other sites

Hi Court,

 

This should fix the total price displayed when returning more than one product on the customer side.

 

At present it is basing the price on the total price of the order, not the total price of each product.

 

Dave


Instant idiot......Just add mud !!

Share this post


Link to post
Share on other sites

Hey Dave,

 

one more thing...

 

for some reason, when a product is returned....

the attributes are not included into what is returned.

 

Is there a way to fix that? If so, that'd be great cause most of my products have Addon Attributes...w/ extra pricing...

 

thanks,

 

court

Share this post


Link to post
Share on other sites

BTW, carry out the same change to catalog->includes->modules->returns_track.php

 

and change line 74 (just change for the code above.

 

To correct the admin-> returns_invoice.php

 

look for line 207

 

           '            <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format(tep_add_tax($order->products['final_price'], $order->products['tax']) * $order->products['qty'], true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "n" .

 

and change to read

 

           '            <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format(tep_add_tax($order->products['price'], $order->products['tax']) * $order->products['qty'], true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "n" .

 

Dave


Instant idiot......Just add mud !!

Share this post


Link to post
Share on other sites

Just looking at the attributes now, will keep you posted


Instant idiot......Just add mud !!

Share this post


Link to post
Share on other sites

still trying to get RMA working but have followed the setup and look around the forums but still get this message..........please please help

 

 

Parse error: parse error, unexpected T_DOUBLE_ARROW in /home/domecomp/public_html/shop/includes/classes/order.php on line 116

 

Fatal error: Cannot instantiate non-existent class: order in /home/domecomp/public_html/shop/account_history_info.php on line 37

Share this post


Link to post
Share on other sites

Post the line around and including line 116 in you shop/includes/classes/order.php.

 

cheers

barry


"A lie gets halfway around the world before the truth has a chance to get its pants on."

 

"I don't want to achieve immortality through my work; I want to achieve immortality through not dying."

Share this post


Link to post
Share on other sites

Hi, thanks for the response....

 

here is the code you requested................................................

 

$orders_products_query = tep_db_query("select orders_products_id, products_id, products_name, products_model, products_price, products_returned, products_exchanged, products_exchanged_id, products_tax, products_quantity, final_price from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . tep_db_input($order_id) . "'");

 

 

while ($orders_products = tep_db_fetch_array($orders_products_query)) {

$this->products[$index] = array('qty' => $orders_products['products_quantity'],

'name' => $orders_products['products_name'],

'model' => $orders_products['products_model'],

'tax' => $orders_products['products_tax'],

'price' => $orders_products['products_price'],

'final_price' => $orders_products['final_price'],

'return' => $orders_products['products_returned'],

'exchange' => $orders_products['products_exchanged'],

'exchange_id' => $orders_products['products_exchanged_id'],

 

 

 

 

 

$subindex = 0;

$attributes_query = tep_db_query("select products_options, products_options_values,

 

 

Thanks

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×