Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

NEW! Complete Order Editing Tool!


jhilgeman

Recommended Posts

I just installed the new version of this contribution (v2.8.4), and get the following error when I try to install a product (after clicking on its name or model):

 

Fatal error: Call to undefined function: tep_html_no_oe_quote() in c:\program files\easyphp1-8\www\catalog\admin\edit_orders.php on line 2207

 

The 2.8.3 version was working just fine. Where should I add this function for the contribution to work?

 

Add the following function to admin/includes/functions/oe_functions.php:

 

 // Function	: tep_hml_no_oe_quote
 // Arguments   : string	any string
 // Return	  : strips apostrophes from strings
 //Used with Order Editor to workaround problem with apostrophes, double quotes, and line breaks

 function tep_html_no_oe_quote($string) {
 $string=str_replace(''', '', $string);
 $string=str_replace("'", "", $string);
 $string=str_replace('"', '', $string);
 $string=preg_replace("/\\r\\n|\\n|\\r/", "<BR>", $string); 
 return $string;

 }
///end function tep_html_no_oe_quote

 

I've uploaded a corrected package for v2.8.4 that includes the function.

Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Link to comment
Share on other sites

That's very strange, because ot_custom is used by Order Editor as the class value for additional fees added in by admin when using Order Editor. I've never heard of a shipping module using that class value. Shipping charges should be stored as ot_shipping. Are you sure this isn't one that you had to add back in using Order Editor after the original component disappeared?

No- I actually created a new test order when you asked for the information so I know it hadn't been edited/messed with at all.

Link to comment
Share on other sites

Thank you. I did this, but am getting a "parse error" in this code. :(

 

Please post the actual error that you're getting.

Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Link to comment
Share on other sites

hi DJ,

 

I have upload your new files but i have a trouble now with the search suggest.

My eplorer did not respons anymore.

 

xav

 

Could you please be more specific about the trouble that you're having and also tell me what browser you're using.

Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Link to comment
Share on other sites

No- I actually created a new test order when you asked for the information so I know it hadn't been edited/messed with at all.

 

That's bizarre- what shipping module are you using?

Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Link to comment
Share on other sites

USPSMethods2.6

 

Try this and see if it helps:

 

find in admin/edit_orders.php

	if (!trim($ot_value) && ($ot_class != "ot_shipping") && ($ot_class != "ot_subtotal") && ($ot_class != "ot_total")) { // value = 0 => Delete Total Piece

and change it to

	if (!trim($ot_value) && ($ot_class != "ot_shipping") && ($ot_class != "ot_custom") && ($ot_class != "ot_subtotal") && ($ot_class != "ot_total")) { // value = 0 => Delete Total Piece

Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Link to comment
Share on other sites

Try this and see if it helps:

 

find in admin/edit_orders.php

	if (!trim($ot_value) && ($ot_class != "ot_shipping") && ($ot_class != "ot_subtotal") && ($ot_class != "ot_total")) { // value = 0 => Delete Total Piece

and change it to

	if (!trim($ot_value) && ($ot_class != "ot_shipping") && ($ot_class != "ot_custom") && ($ot_class != "ot_subtotal") && ($ot_class != "ot_total")) { // value = 0 => Delete Total Piece

Nope- no change, still drops the shipping.

Link to comment
Share on other sites

Please post the actual error that you're getting.

 

As you told me a few posts above, I added the following code to \admin\includes\functions\oe_functions.php:

 

// Function	: tep_hml_no_oe_quote
 // Arguments   : string	any string
 // Return	  : strips apostrophes from strings
 //Used with Order Editor to workaround problem with apostrophes, double quotes, and line breaks

 function tep_html_no_oe_quote($string) {
 $string=str_replace(''', '', $string);
 $string=str_replace("'", "", $string);
 $string=str_replace('"', '', $string);
 $string=preg_replace("/\\r\\n|\\n|\\r/", "<BR>", $string); 
 return $string;

 }
///end function tep_html_no_oe_quote

 

And now, when I try to edit an order, I get:

 

Parse error: parse error in c:\program files\easyphp1-8\www\catalog\admin\includes\functions\oe_functions.php on line 26

 

the line 26 is this one:

  $string=str_replace(''', '', $string);

Link to comment
Share on other sites

As you told me a few posts above, I added the following code to \admin\includes\functions\oe_functions.php:

 

// Function	: tep_hml_no_oe_quote
 // Arguments   : string	any string
 // Return	  : strips apostrophes from strings
 //Used with Order Editor to workaround problem with apostrophes, double quotes, and line breaks

 function tep_html_no_oe_quote($string) {
 $string=str_replace(''', '', $string);
 $string=str_replace("'", "", $string);
 $string=str_replace('"', '', $string);
 $string=preg_replace("/\\r\\n|\\n|\\r/", "<BR>", $string); 
 return $string;

 }
///end function tep_html_no_oe_quote

 

And now, when I try to edit an order, I get:

 

Parse error: parse error in c:\program files\easyphp1-8\www\catalog\admin\includes\functions\oe_functions.php on line 26

 

the line 26 is this one:

  $string=str_replace(''', '', $string);

 

The problem here is the way the osCommerce forum turns HTML code into the character it represents rather than leaving the code as is.

 

Since I can't post the code, in order for yours to work you'll have to download the corrected package for v2.8.4 and copy the correct code directly from the file included with that package.

Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Link to comment
Share on other sites

Nope- no change, still drops the shipping.

 

There's got to be something else wrong that we're not seeing. Does the orders_id for the shipping component match the orders_id for the rest of the order? Is the sort_order value greater than the sort_order total for the ot_total component?

Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Link to comment
Share on other sites

Since I can't post the code, in order for yours to work you'll have to download the corrected package for v2.8.4 and copy the correct code directly from the file included with that package.

 

Thank you. For some reason, my browser had cached the Contribution page, and I couldn't see the corrected package. I have it now, and all works fine.

 

Congratulations once again for this excellent contribution.

Link to comment
Share on other sites

There's got to be something else wrong that we're not seeing. Does the orders_id for the shipping component match the orders_id for the rest of the order? Is the sort_order value greater than the sort_order total for the ot_total component?

I've put through 4 test orders this morning (making sure to keep them under $25 so they won't qualify for free shipping) and all 4 of them show the right total WITH shipping but when I go to the database they only list the total (sort order 6) and sub-total (sort order 1) and no shipping (even as ot_custom) at all. When I go in to the edit_orders and click update they lose the shipping completely and nothing changes in the database. I thought maybe there was a conflict with something else so I searched for 'ot_custom' using Dreamweaver and edit_orders is the only file using it in the entire site.

Link to comment
Share on other sites

Hi,

I love this contrib, and update it always, but i have an idea, just wanted to throw it out there.

I have the address line2 contrib added is there anyway to have this incorporated? i can add it manually but Im sure Im not the only person who uses both contribs.

 

 

ie, if the DB field entry_street_address2 exists then add incorporate it into edit orders else leave it out?

Link to comment
Share on other sites

in this order editing tool, what would be quite handy is if you have the ability of adding on serial numbers, as well as been able to track stock,

 

let say a person is running a online shop as well as a retail store, it will be quite handy if they can put note in the stock, like *product #1* - reserved, or backordered, or picked up.

 

is there any way that it can be done.

 

this is an amazing tool, i only started to use it yesterday, but it seems top notch.

Link to comment
Share on other sites

I've put through 4 test orders this morning (making sure to keep them under $25 so they won't qualify for free shipping) and all 4 of them show the right total WITH shipping but when I go to the database they only list the total (sort order 6) and sub-total (sort order 1) and no shipping (even as ot_custom) at all. When I go in to the edit_orders and click update they lose the shipping completely and nothing changes in the database. I thought maybe there was a conflict with something else so I searched for 'ot_custom' using Dreamweaver and edit_orders is the only file using it in the entire site.

 

That's what I was thinking. I've never heard of a shipping module using ot_custom; in fact, as far as I know, it's unique to Order Editor. From what you've described, the ot_shipping component of your orders isn't being saved by the shipping module at all. The best you can do with Order Editor is add it in after the fact (as an ot_custom item).

 

You'll need to do some work on your shipping module to get it to pass the correct variables through the checkout process in order to save the data in the database properly.

 

Just a thought- is register_globals turned off on your server?

Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Link to comment
Share on other sites

Hi,

I love this contrib, and update it always, but i have an idea, just wanted to throw it out there.

I have the address line2 contrib added is there anyway to have this incorporated? i can add it manually but Im sure Im not the only person who uses both contribs.

 

 

ie, if the DB field entry_street_address2 exists then add incorporate it into edit orders else leave it out?

 

Yes, it's a pretty simple addition. You have to add street_address2 into the admin/includes/classes/oe_order.php in each of the customer, billing, and delivery arrays (this is so you pull the info from the database), then in edit_orders.php three times under

		// 1.1 UPDATE ORDER INFO #####

once again, once each for customer, billing, and delivery (this is so you post the info to the database), then finally starting at

 <!-- customer_info bof //-->

you'd add in one section of code for each of the three entries customer, billing and delivery (this is so you can edit the information).

Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Link to comment
Share on other sites

That's what I was thinking. I've never heard of a shipping module using ot_custom; in fact, as far as I know, it's unique to Order Editor. From what you've described, the ot_shipping component of your orders isn't being saved by the shipping module at all. The best you can do with Order Editor is add it in after the fact (as an ot_custom item).

 

You'll need to do some work on your shipping module to get it to pass the correct variables through the checkout process in order to save the data in the database properly.

 

Just a thought- is register_globals turned off on your server?

No- it's on, I had problems with that last year when I was running a cron job so if it goes off (for example, when they moved my site onto a new server without telling me) I always know right away because the cron doesn't work. I'm going to look into the free shipping/minimum amount mod- maybe there's something in there screwing things up with the edit. Thanks for trying though!

Link to comment
Share on other sites

in this order editing tool, what would be quite handy is if you have the ability of adding on serial numbers, as well as been able to track stock,

 

let say a person is running a online shop as well as a retail store, it will be quite handy if they can put note in the stock, like *product #1* - reserved, or backordered, or picked up.

 

is there any way that it can be done.

 

this is an amazing tool, i only started to use it yesterday, but it seems top notch.

 

This would also be a simple addition. You would have to add a column to the orders_products table, "products_status" for example, where the information can be stored.

 

Then you'd modify admin/includes/classes/oe_order.php to pull the info from the database. This would only require two additional lines. If you did use "products_status" you would add the line

op.products_status,

after

	 op.orders_products_id,

and then you would add

								'status' => $orders_products['products_status'],

after

								'qty' => $orders_products['products_quantity'],

 

 

Next in admin/edit_orders.php at about line 246 you would change

			   else { // if we don't delete, we update
			$Query = "UPDATE " . TABLE_ORDERS_PRODUCTS . " SET
				products_model = '" . $products_details["model"] . "',
				products_name = '" . tep_html_quotes($products_details["name"]) . "',
				products_price = '" . $products_details["price"] . "',
				final_price = '" . $products_details["final_price"] . "',
				products_tax = '" . $products_details["tax"] . "',
				products_quantity = '" . $products_details["qty"] . "'
				WHERE orders_id = '" . (int)$oID . "'
				AND orders_products_id = '$orders_products_id';";
			tep_db_query($Query);

to

			   else { // if we don't delete, we update
			$Query = "UPDATE " . TABLE_ORDERS_PRODUCTS . " SET
				products_model = '" . $products_details["model"] . "',
				products_name = '" . tep_html_quotes($products_details["name"]) . "',
				products_status = '" . $products_details["status"] . "'
				products_price = '" . $products_details["price"] . "',
				final_price = '" . $products_details["final_price"] . "',
				products_tax = '" . $products_details["tax"] . "',
				products_quantity = '" . $products_details["qty"] . "'
				WHERE orders_id = '" . (int)$oID . "'
				AND orders_products_id = '$orders_products_id';";
			tep_db_query($Query);

 

Finally you would need to edit the code so you would be able to view and edit the information. The HTML for that section starts at about line 1723 with

	<table border="0" width="100%" cellspacing="0" cellpadding="2"  style="border: 1px solid #C9C9C9;">
	<tr class="dataTableHeadingRow">

 

If, for example, you wanted to add in the products status in between Quantity and Product name, you would change

	  <td class="dataTableHeadingContent"><?php  echo TABLE_HEADING_QUANTITY; ?></td>
  <td class="dataTableHeadingContent"><?php  echo TABLE_HEADING_PRODUCTS; ?></td>

to

	  <td class="dataTableHeadingContent"><?php  echo TABLE_HEADING_QUANTITY; ?></td>
<td class="dataTableHeadingContent"><?php  echo TABLE_HEADING_PRODUCTS_STATUS; ?></td>
  <td class="dataTableHeadingContent"><?php  echo TABLE_HEADING_PRODUCTS; ?></td>

 

Then you would change

			  '		<td class="' . $RowStyle . '" valign="top">' . "<input name='update_products[$orders_products_id][name]' size='35' value='" . tep_html_quotes($order->products[$i]['name']) . "'>";

to

 '		<td class="' . $RowStyle . '" valign="top"><div align="center">' . "<input name='update_products[$orders_products_id][status]' size='10' value='" . $order->products[$i]['status'] . "' /></div></td>\n" .
		  '		<td class="' . $RowStyle . '" valign="top">' . "<input name='update_products[$orders_products_id][name]' size='35' value='" . tep_html_quotes($order->products[$i]['name']) . "'>";

 

I'm pretty sure that would do the trick.

Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Link to comment
Share on other sites

have installed last version: v2.8.5 with minor bug fix

there is a bug when adding product... it adds product with 0% tax.

 

around line 566 in edit_orders.php, lines refer to countryid and zoneid that haven't been defined yet,

just add:

		$countryid = $order->delivery['country_id'];
	$zoneid=$order->delivery['zone_id'];

before

 

			if ($new_price) 
		{ $p_products_price = $new_price['specials_new_products_price']; }

		// 2.2 UPDATE ORDER ####
		$Query = "INSERT INTO " . TABLE_ORDERS_PRODUCTS . " SET
		  orders_id = '" . (int)$oID . "',
		  products_id = '" . $_POST['add_product_products_id'] . "',
		  products_model = '" . $p_products_model . "',
		  products_name = '" . tep_html_quotes($p_products_name) . "',
		  products_price = '". $p_products_price . "',
		  final_price = '" . ($p_products_price + $AddedOptionsPrice) . "',
	 products_tax = '" . tep_get_tax_rate($p_products_tax_class_id, $countryid, $zoneid) . "',
		  products_quantity = '" . $_POST['add_product_quantity'] . "'";
		  tep_db_query($Query);
		  $new_product_id = tep_db_insert_id();

Edited by demoalt
Link to comment
Share on other sites

have installed last version: v2.8.5 with minor bug fix

there is a bug when adding product... it adds product with 0% tax.

 

around line 566 in edit_orders.php, lines refer to countryid and zoneid that haven't been defined yet,

just add:

		$countryid = $order->delivery['country_id'];
	$zoneid=$order->delivery['zone_id'];

before

 

			if ($new_price) 
		{ $p_products_price = $new_price['specials_new_products_price']; }

Order Editor determines the tax rate of each product based on the tax class that the product is in and the tax zone, if any, that the product is being delivered to.

 

The code that defines $countryid and $zoneid are in includes/classes/oe_order.php:

	$countryid = tep_get_country_id($this->delivery["country"]);
$zoneid = tep_get_zone_id($countryid, $this->delivery["state"]);

 

It shouldn't be necessary to re-define those variables.

Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Link to comment
Share on other sites

Order Editor determines the tax rate of each product based on the tax class that the product is in and the tax zone, if any, that the product is being delivered to.

 

The code that defines $countryid and $zoneid are in includes/classes/oe_order.php:

	$countryid = tep_get_country_id($this->delivery["country"]);
$zoneid = tep_get_zone_id($countryid, $this->delivery["state"]);

 

It shouldn't be necessary to re-define those variables.

 

I had to modify this way since it was not working for me... it was getting 0% for each new added product.

works for me :) strange behaviour :(

Link to comment
Share on other sites

I had to modify this way since it was not working for me... it was getting 0% for each new added product.

works for me :) strange behaviour :(

 

Interesting. What version of PHP are you running?

Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...