Edit Orders v4.0 Support Thread

[lhungil]

... "Failed opening '/path_I_know/includes/modules/shipping/ups.php'" ...

Basically, that error message is PHP stating it was unable to load the specified file.

If "path_I_know" is your "catalog" (/) directory:
The usual cause is the "old" store had a "ups" shipping module installed and enabled. I'd guess the "new" store does not have the "ups" shipping module installed. I'd also guess before exporting / upgrading the database the shipping modules were not removed using the Zen Cart admin. When this sequence of events occurs, the Zen Cart database still thinks the modules exists and are enabled. This triggers the shipping class to load the corresponding files (which are not present) and thus the above error message.

Potential Fixes: Install the "ups" module (files, then remove and install from the Zen Cart admin interface to clean up the database). Or manually remove the entry for "ups.php" from the list of installed modules in the Zen Cart database. "SELECT * FROM `configuration` WHERE `configuration_key`='MODULE_SHIPPING_INSTALLED'".

If "path_I_know" is your "admin" (/admin) directory:
Most likely one of the paths in "/admin/includes/configure.php" is not right or when merging files during the installation of "Edit Orders" a merge was bungled (possibly in "/includes/classes/shopping.php").

[Three Sisters]

Simple fix! Thanks a million for explaining. It was the catalog directory. Sorry - didn't mean to be ambiguous. Thought if I didn't write "admin" it was assumed. But then, I guess it's never safe to assume. :)

So everything works now (Super Orders and Edit Orders). Is it too late to add the TY Package Tracker?

[DivaVocals]

Simple fix! Thanks a million for explaining. It was the catalog directory. Sorry - didn't mean to be ambiguous. Thought if I didn't write "admin" it was assumed. But then, I guess it's never safe to assume. :)

So everything works now (Super Orders and Edit Orders). Is it too late to add the TY Package Tracker?

No.. follow the readme instructions pay particular attention the the integration with other modules..

[lat9]

Never mind, I'm not sure what I saw.

[lat9]

Back again (sigh). Running Edit Orders 1.4.4 (all forum-specified updates applied) on Zen Cart v1.5.1 for a store that uses a bunch of dropdown attributes to include onetime-charges for various product features.

If I edit an order and change one of these attributes (clicking the "Update" button), the proper onetime charge is recorded in the orders_products_attributes table, but the orders_products table's onetime_charges field does not get updated. The following code fragment is in the edit_orders_functions.php module's eo_get_new_product function; I'm thinking that this is where I need to make the change, given the fact that the DROPDOWN type attribute is being handled by the do-nothing default clause. Any guidance would be appreciated!

	// Handle attributes
	if(is_array($product_options) && count($product_options > 0))
	{
		$retval['attributes'] = array();

		include_once(DIR_WS_CLASSES . 'attributes.php');
		$attributes = new attributes();

		foreach($product_options as $option_id => $details) {
			$attr = array();
			switch($details['type']) {
				case PRODUCTS_OPTIONS_TYPE_TEXT:
				case PRODUCTS_OPTIONS_TYPE_FILE:
					$attr['option_id'] = $option_id;
					$attr['value'] = $details['value'];
					if($attr['value'] == '') continue 2;

					// There should only be one text per name.....
					$get_attr_id = $attributes->get_attributes_by_option($product_id, $option_id);
					if(count($get_attr_id) == 1) $details['value'] = $get_attr_id[0]['products_attributes_id'];
					unset($get_attr_id);
					break;
				case PRODUCTS_OPTIONS_TYPE_CHECKBOX:
					if(!array_key_exists('value', $details)) continue 2;
					$tmp_id = array_shift($details['value']);
					foreach($details['value'] as $attribute_id) {
						// We only get here if more than one checkbox per
						// option was selected.
						$tmp = $attributes->get_attribute_by_id($attribute_id, 'order');
						$retval['attributes'][] = $tmp;

						// Handle pricing
						$prices = eo_get_product_attribute_prices(
							$attribute_id, $tmp['value'], $product_qty
						);
						unset($tmp);
						if(!$query->EOF) {
							$retval['onetime_charges'] += $prices['onetime_charges'];
							$retval['final_price'] += $prices['price'];
						}
					}
					$details['value'] = $tmp_id;
					$attr = $attributes->get_attribute_by_id($details['value'], 'order');
					unset($attribute_id); unset($attribute_value); unset($tmp_id);
					break;
				default:
					$attr = $attributes->get_attribute_by_id($details['value'], 'order');
			}
			$retval['attributes'][] = $attr;

			if(!$query->EOF) {
				// Handle pricing
				$prices = eo_get_product_attribute_prices(
					$details['value'], $attr['value'], $product_qty
				);
				$retval['onetime_charges'] += $prices['onetime_charges'];
				$retval['final_price'] += $prices['price'];
			}
		}
		unset($query, $attr, $prices, $option_id, $details);
	}

[lhungil]

@lat9 Send you an email.

[lat9]

Thanks, lhungil. I found another "funny" with the dropdown (and possibly other flavors) of attributes; the ordering of the attribute values in the dropdown were all over the place, i.e. not in their defined sort-order. I made the following change to the /YOUR_ADMIN/includes/classes/attributes.php module to correct:

	/**
	 * Returns a multidimensional array containing the product attribute options
	 * id / name / value rows for the specified product sorted by option id.
	 *
	 * @param int|string $zf_product_id the specified product id.
	 * @param bool $readonly include readonly attributes not required to add a
	 *        product to the cart, defaults to false.
	 * @return array
	 */
	function get_attributes_options($zf_product_id, $readonly = false) {
		global $db;
		$query = 'SELECT attr.products_attributes_id, attr.products_id, attr.options_id, opt.products_options_name, val.products_options_values_name, opt.products_options_type, products_options_size, opt.products_options_rows ' .
			'FROM ' . TABLE_PRODUCTS_ATTRIBUTES . ' AS attr ' .
			'LEFT JOIN ' . TABLE_PRODUCTS_OPTIONS .
				' AS opt ON attr.options_id = opt.products_options_id ' .
			'LEFT JOIN ' . TABLE_PRODUCTS_OPTIONS_VALUES .
				' AS val ON attr.options_values_id = val.products_options_values_id ' .
			'WHERE attr.products_id = \'' . (int)$zf_product_id . '\' ' .
				'AND val.language_id = \'' . (int)$_SESSION['languages_id'] . '\' ' .
				'AND val.language_id = opt.language_id ';

		// Don't include READONLY attributes if product can be added to cart without them
		if(PRODUCTS_OPTIONS_TYPE_READONLY_IGNORED == '1' && $readonly === false) {
			$query .= 'AND opt.products_options_type != \'' . PRODUCTS_OPTIONS_TYPE_READONLY . '\' ';
		}

//-bof-20140712-lat9-Fix up attributes' sort order.
//		$query .= 'ORDER BY `opt`.`products_options_sort_order`, `attr`.`options_id`';
		$query .= 'ORDER BY `attr`.`options_id`, `attr`.`products_options_sort_order`';
//-eof-20140712-lat9

		if($this->cache_time == 0) $queryResult = $db->Execute($query);
		else $queryResult = $db->Execute($query, false, true, $this->cache_time);

		$retval = array();
		while (!$queryResult->EOF) {
			$retval[$queryResult->fields['products_attributes_id']] = array(
				'id' => $queryResult->fields['options_id'],
				'name' => $queryResult->fields['products_options_name'],
				'value' => $queryResult->fields['products_options_values_name'],
				'type' => $queryResult->fields['products_options_type'],
				'length' => $queryResult->fields['products_options_length'],
				'size' => $queryResult->fields['products_options_size'],
				'rows' => $queryResult->fields['products_options_rows']
			);
			$queryResult->MoveNext();
		}
		return $retval;
	}