[Contribution] Step-By-Step Manual Order

October 31, 2003

the one thing this mod does not do that I would love to see in a future release is have it update the # of products ordered in the product table.

B)

GIZMO-XL · November 2, 2003

To make the product Qty update look for the following section of code and add the //Stock Update and // Update products_ordered sections to your edit_orders.php file so it looks like the following.

if(IsSet($add_product_options))
	 {
   foreach($add_product_options as $option_id => $option_value_id)
   {
  	 $Query = "insert into " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " set
     orders_id = $oID,
     orders_products_id = $new_product_id,
     products_options = '" . $option_names[$option_id] . "',
     products_options_values = '" . $option_values_names[$option_value_id] . "',
     options_values_price = '" . $option_value_details[$option_id][$option_value_id]["options_values_price"] . "',
     price_prefix = '+';";
  	 tep_db_query($Query);
   }
	 }

	 // Stock Update
	 $stock_chk_query = tep_db_query("select products_quantity from products where products_id = '" . $add_product_products_id . "'");
	 $stock_chk_values = tep_db_fetch_array($stock_chk_query);
     $stock_chk_left = $stock_chk_values['products_quantity'] - $add_product_quantity;
	 tep_db_query("update products set products_quantity = '" . $stock_chk_left . "' where products_id = '" . $add_product_products_id . "'");

	 // Update products_ordered (for bestsellers list)
	 tep_db_query("update products set products_ordered = products_ordered + " . $add_product_quantity . " where products_id = '" . $add_product_products_id . "'");


	 // Calculate Tax and Sub-Totals
	 $order = new order($oID);
	 $RunningSubTotal = 0;
	 $RunningTax = 0;

I hope that helps.

November 2, 2003

To make the product Qty update look for the following section of code and add the //Stock Update and // Update products_ordered sections to your edit_orders.php file so it looks like the following.

I hope that helps.

perfect!

thanks much!

B)

GIZMO-XL · November 2, 2003

Ok I have made some changes some people may want so I have posted them.

Changes made:

I have added two tables to the data base used to store payment methods and shipping methods.

I have added three columns to the orders table to support PO orders.

I have added the above columns on the edit forum when PO payment type is selected.

I have added the logic to update store stock levels when adding product.

I have added the logic to update products_ordered (for bestsellers list).

I have added the logic to provide a discount in the orders totals.

I have fixed the forum layout.

Make sure you backup you old files

Ok to add the customer discount find the following code in your /admin/create_order_process.php

    $sql_data_array = array('orders_id' => $insert_id,
                           'title' => "Sub-Total:",
                           'text' => $temp_amount,
                           'value' => "0.00",
                           'class' => "ot_subtotal",
                           'sort_order' => "1");
   tep_db_perform(TABLE_ORDERS_TOTAL, $sql_data_array);

And add the following:

    $sql_data_array = array('orders_id' => $insert_id,
                            'title' => "Customer Discount:",
                            'text' => $temp_amount,
                            'value' => "0.00",
                            'class' => "ot_customer_discount",
                            'sort_order' => "2");
   tep_db_perform(TABLE_ORDERS_TOTAL, $sql_data_array);

OK now you have to add the fields for the PO payment method

Changes to database:

#Add these 3 fields to table orders by running these lines in phpmyadmin or what ever you prefer.

ALTER TABLE `orders` ADD `account_name` VARCHAR( 32 ) NOT NULL AFTER `currency_value`;
ALTER TABLE `orders` ADD `account_number` VARCHAR ( 20 ) AFTER `account_name`;
ALTER TABLE `orders` ADD `po_number` VARCHAR ( 12 ) AFTER `account_number`;

OK now you have to add the table for payment methods

#
# Table structure for table `orders_pay_methods`
#

CREATE TABLE orders_pay_methods (
 pay_methods_id int(11) NOT NULL auto_increment,
 pay_method varchar(255) NOT NULL default '',
 date_added datetime NOT NULL default '0000-00-00 00:00:00',
 PRIMARY KEY  (pay_methods_id)
) TYPE=InnoDB;

#
# Dumping data for table `orders_pay_methods`
#

INSERT INTO orders_pay_methods VALUES (1, 'Bank Transfer Payments', '2003-11-01 13:00:34');
INSERT INTO orders_pay_methods VALUES (2, 'PayPal', '2003-11-01 13:01:00');
INSERT INTO orders_pay_methods VALUES (3, 'Check/Money Order', '2003-11-01 13:01:36');
INSERT INTO orders_pay_methods VALUES (4, 'Purchase Order', '2003-11-01 13:02:07');

OK now you have to add the table for shipping methods

#
# Table structure for table `orders_ship_methods`
#

CREATE TABLE orders_ship_methods (
 ship_methods_id int(11) NOT NULL auto_increment,
 ship_method varchar(255) NOT NULL default '',
 date_added datetime NOT NULL default '0000-00-00 00:00:00',
 PRIMARY KEY  (ship_methods_id)
) TYPE=InnoDB;

#
# Dumping data for table `orders_ship_methods`
#

INSERT INTO orders_ship_methods VALUES (1, 'FedEx Priority to Canada', '2003-11-01 09:40:19');
INSERT INTO orders_ship_methods VALUES (2, 'FedEx Priority to USA', '2003-11-01 09:40:56');
INSERT INTO orders_ship_methods VALUES (3, 'FedEx Priority International', '2003-11-01 09:41:33');
INSERT INTO orders_ship_methods VALUES (4, 'Canada Xpresspost Post shipping', '2003-11-01 09:42:08');
INSERT INTO orders_ship_methods VALUES (5, 'Canada USA Xpresspost shipping USA', '2003-11-01 09:43:27');
INSERT INTO orders_ship_methods VALUES (6, 'Canada Post Standard Airmail shipping', '2003-11-01 09:44:00');

<?php

/*

$Id: edit_orders.php,v 1.2 2003/08/08 13:50:00 jwh Exp $

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

Released under the GNU General Public License

Written by Jonathan Hilgeman of SiteCreative.com (osc@sitecreative.com)

Version History

---------------------------------------------------------------

08/08/03

1.2a - Fixed a query problem on osC 2.1 stores.

08/08/03

1.2 - Added more recommendations to the instructions.

Added "Customer" fields for editing on osC 2.2.

Corrected "Billing" fields so they update correctly.

Added Company and Suburb Fields.

Added optional shipping tax variable.

First (and hopefully last) fix for currency formatting.

08/08/03

1.1 - Added status editing (fixed order status bug from 1.0).

Added comments editing. (with compatibility for osC 2.1)

Added customer notifications.

Added some additional information to the instructions file.

Fixed bug with product names containing single quotes.

08/07/03

1.0 - Original Release.

To Do in Version 1.3

---------------------------------------------------------------

Note from the author

---------------------------------------------------------------

This tool was designed and tested on osC 2.2 Milestone 2.2,

but may work for other versions, as well. Most database changes

were minor, so getting it to work on other versions may just

need some tweaking. Hope this helps make your life easier!

- Jonathan Hilgeman, August 7th, 2003

*/

require('includes/application_top.php');

require(DIR_WS_CLASSES . 'currencies.php');

$currencies = new currencies();

include(DIR_WS_CLASSES . 'order.php');

// New "Status History" table has different format.

$OldNewStatusValues = (tep_field_exists(TABLE_ORDERS_STATUS_HISTORY, "old_value") && tep_field_exists(TABLE_ORDERS_STATUS_HISTORY, "new_value"));

$CommentsWithStatus = tep_field_exists(TABLE_ORDERS_STATUS_HISTORY, "comments");

$SeparateBillingFields = tep_field_exists(TABLE_ORDERS, "billing_name");

// Optional Tax Rate/Percent

$AddShippingTax = "0.0"; // e.g. shipping tax of 17.5% is "17.5"

$orders_statuses = array();

$orders_status_array = array();

$orders_status_query = tep_db_query("select orders_status_id, orders_status_name from " . TABLE_ORDERS_STATUS . " where language_id = '" . (int)$languages_id . "'");

while ($orders_status = tep_db_fetch_array($orders_status_query)) {

$orders_statuses[] = array('id' => $orders_status['orders_status_id'],

'text' => $orders_status['orders_status_name']);

$orders_status_array[$orders_status['orders_status_id']] = $orders_status['orders_status_name'];

}

$orders_ship_method = array();

$orders_ship_method_array = array();

$orders_ship_method_query = tep_db_query("select ship_method from orders_ship_methods");

while ($orders_ship_methods = tep_db_fetch_array($orders_ship_method_query)) {

$orders_ship_method[] = array('id' => $orders_ship_methods['ship_method'],

'text' => $orders_ship_methods['ship_method']);

$orders_ship_method_array[$orders_ship_methods['ship_method']] = $orders_ship_methods['ship_method'];

}

$orders_pay_method = array();

$orders_pay_method_array = array();

$orders_pay_method_query = tep_db_query("select pay_method from orders_pay_methods");

while ($orders_pay_methods = tep_db_fetch_array($orders_pay_method_query)) {

$orders_pay_method[] = array('id' => $orders_pay_methods['pay_method'],

'text' => $orders_pay_methods['pay_method']);

$orders_pay_method_array[$orders_pay_methods['pay_method']] = $orders_pay_methods['pay_method'];

}

$action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : 'edit');

if (tep_not_null($action)) {

switch ($action) {

// Update Order

case 'update_order':

$oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);

$order = new order($oID);

$status = tep_db_prepare_input($HTTP_POST_VARS['status']);

$comments = tep_db_prepare_input($HTTP_POST_VARS['comments']);

// Update Order Info

$UpdateOrders = "update " . TABLE_ORDERS . " set

customers_name = '" . tep_db_input(stripslashes($update_customer_name)) . "',

customers_company = '" . tep_db_input(stripslashes($update_customer_company)) . "',

customers_street_address = '" . tep_db_input(stripslashes($update_customer_street_address)) . "',

customers_suburb = '" . tep_db_input(stripslashes($update_customer_suburb)) . "',

customers_city = '" . tep_db_input(stripslashes($update_customer_city)) . "',

customers_state = '" . tep_db_input(stripslashes($update_customer_state)) . "',

customers_postcode = '" . tep_db_input($update_customer_postcode) . "',

customers_country = '" . tep_db_input(stripslashes($update_customer_country)) . "',

customers_telephone = '" . tep_db_input($update_customer_telephone) . "',

customers_email_address = '" . tep_db_input($update_customer_email_address) . "',";

if($SeparateBillingFields)

{

$UpdateOrders .= "billing_name = '" . tep_db_input(stripslashes($update_billing_name)) . "',

billing_company = '" . tep_db_input(stripslashes($update_billing_company)) . "',

billing_street_address = '" . tep_db_input(stripslashes($update_billing_street_address)) . "',

billing_suburb = '" . tep_db_input(stripslashes($update_billing_suburb)) . "',

billing_city = '" . tep_db_input(stripslashes($update_billing_city)) . "',

billing_state = '" . tep_db_input(stripslashes($update_billing_state)) . "',

billing_postcode = '" . tep_db_input($update_billing_postcode) . "',

billing_country = '" . tep_db_input(stripslashes($update_billing_country)) . "',";

}

$UpdateOrders .= "delivery_name = '" . tep_db_input(stripslashes($update_delivery_name)) . "',

delivery_company = '" . tep_db_input(stripslashes($update_delivery_company)) . "',

delivery_street_address = '" . tep_db_input(stripslashes($update_delivery_street_address)) . "',

delivery_suburb = '" . tep_db_input(stripslashes($update_delivery_suburb)) . "',

delivery_city = '" . tep_db_input(stripslashes($update_delivery_city)) . "',

delivery_state = '" . tep_db_input(stripslashes($update_delivery_state)) . "',

delivery_postcode = '" . tep_db_input($update_delivery_postcode) . "',

delivery_country = '" . tep_db_input(stripslashes($update_delivery_country)) . "',

payment_method = '" . tep_db_input($update_info_payment_method) . "',

account_name = '" . tep_db_input($account_name) . "',

account_number = '" . tep_db_input($account_number) . "',

po_number = '" . tep_db_input($po_number) . "',

cc_type = '" . tep_db_input($update_info_cc_type) . "',

cc_owner = '" . tep_db_input($update_info_cc_owner) . "',";

if(substr($update_info_cc_number,0,8) != "(Last 4)")

$UpdateOrders .= "cc_number = '$update_info_cc_number',";

$UpdateOrders .= "cc_expires = '$update_info_cc_expires',

orders_status = '" . tep_db_input($status) . "'";

if(!$CommentsWithStatus)

{

$UpdateOrders .= ", comments = '" . tep_db_input($comments) . "'";

}

$UpdateOrders .= " where orders_id = '" . tep_db_input($oID) . "';";

tep_db_query($UpdateOrders);

$Query1 = "update orders set last_modified = now() where orders_id = '" . tep_db_input($oID) . "';";

tep_db_query($Query1);

$order_updated = true;

$check_status_query = tep_db_query("select customers_name, customers_email_address, orders_status, date_purchased from " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'");

$check_status = tep_db_fetch_array($check_status_query);

// Update Status History & Email Customer if Necessary

if ($order->info['orders_status'] != $status)

{

// Notify Customer

$customer_notified = '0';

if (isset($HTTP_POST_VARS['notify']) && ($HTTP_POST_VARS['notify'] == 'on'))

{

$notify_comments = '';

if (isset($HTTP_POST_VARS['notify_comments']) && ($HTTP_POST_VARS['notify_comments'] == 'on')) {

$notify_comments = sprintf(EMAIL_TEXT_COMMENTS_UPDATE, $comments) . "\n\n";

}

$email = STORE_NAME . "\n" . EMAIL_SEPARATOR . "\n" . EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "\n" . EMAIL_TEXT_INVOICE_URL . ' ' . tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "\n" . EMAIL_TEXT_DATE_ORDERED . ' ' . tep_date_long($check_status['date_purchased']) . "\n\n" . $notify_comments . sprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]);

tep_mail($check_status['customers_name'], $check_status['customers_email_address'], EMAIL_TEXT_SUBJECT, $email, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);

$customer_notified = '1';

}

// "Status History" table has gone through a few

// different changes, so here are different versions of

// the status update.

// NOTE: Theoretically, there shouldn't be a

// orders_status field in the ORDERS table. It

// should really just use the latest value from

// this status history table.

if($CommentsWithStatus)

{

tep_db_query("insert into " . TABLE_ORDERS_STATUS_HISTORY . "

(orders_id, orders_status_id, date_added, customer_notified, comments)

values ('" . tep_db_input($oID) . "', '" . tep_db_input($status) . "', now(), " . tep_db_input($customer_notified) . ", '" . tep_db_input($comments) . "')");

}

else

{

if($OldNewStatusValues)

{

tep_db_query("insert into " . TABLE_ORDERS_STATUS_HISTORY . "

(orders_id, new_value, old_value, date_added, customer_notified)

values ('" . tep_db_input($oID) . "', '" . tep_db_input($status) . "', '" . $order->info['orders_status'] . "', now(), " . tep_db_input($customer_notified) . ")");

}

else

{

tep_db_query("insert into " . TABLE_ORDERS_STATUS_HISTORY . "

(orders_id, orders_status_id, date_added, customer_notified)

values ('" . tep_db_input($oID) . "', '" . tep_db_input($status) . "', now(), " . tep_db_input($customer_notified) . ")");

}

// Update Products

$RunningSubTotal = 0;

$RunningTax = 0;

foreach($update_products as $orders_products_id => $products_details)

{

// Update orders_products Table

if($products_details["qty"] > 0)

{

$Query = "update " . TABLE_ORDERS_PRODUCTS . " set

products_model = '" . $products_details["model"] . "',

products_name = '" . str_replace("'", "'", $products_details["name"]) . "',

final_price = '" . $products_details["final_price"] . "',

products_tax = '" . $products_details["tax"] . "',

products_quantity = '" . $products_details["qty"] . "'

where orders_products_id = '$orders_products_id';";

tep_db_query($Query);

// Update Tax and Subtotals

$RunningSubTotal += $products_details["qty"] * $products_details["final_price"];

$RunningTax += (($products_details["tax"]/100) * ($products_details["qty"] * $products_details["final_price"]));

// Update Any Attributes

if(IsSet($products_details[attributes]))

{

foreach($products_details["attributes"] as $orders_products_attributes_id => $attributes_details)

{

$Query = "update " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " set

products_options = '" . $attributes_details["option"] . "',

products_options_values = '" . $attributes_details["value"] . "'

where orders_products_attributes_id = '$orders_products_attributes_id';";

tep_db_query($Query);

}

else

{

// 0 Quantity = Delete

$Query = "delete from " . TABLE_ORDERS_PRODUCTS . " where orders_products_id = '$orders_products_id';";

tep_db_query($Query);

$Query = "delete from " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " where orders_products_id = '$orders_products_id';";

tep_db_query($Query);

}

// Shipping Tax

foreach($update_totals as $total_index => $total_details)

{

extract($total_details,EXTR_PREFIX_ALL,"ot");

if($ot_class == "ot_shipping")

{

$RunningTax += (($AddShippingTax / 100) * $ot_value);

}

// Update Totals

$RunningTotal = 0;

$sort_order = 0;

// Do pre-check for Tax field existence

$ot_tax_found = 0;

foreach($update_totals as $total_details)

{

extract($total_details,EXTR_PREFIX_ALL,"ot");

if($ot_class == "ot_tax")

{

$ot_tax_found = 1;

break;

}

foreach($update_totals as $total_index => $total_details)

{

extract($total_details,EXTR_PREFIX_ALL,"ot");

if( trim(strtolower($ot_title)) == "tax" || trim(strtolower($ot_title)) == "tax:" )

{

if($ot_class != "ot_tax" && $ot_tax_found == 0)

{

// Inserting Tax

$ot_class = "ot_tax";

$ot_value = "x"; // This gets updated in the next step

$ot_tax_found = 1;

}

if( trim($ot_title) && trim($ot_value) )

{

$sort_order++;

// Update ot_subtotal, ot_tax, and ot_total classes

if($ot_class == "ot_subtotal")

$ot_value = $RunningSubTotal;

if($ot_class == "ot_tax")

{

$ot_value = $RunningTax;

// print "ot_value = $ot_value<br>\n";

}

if($ot_class == "ot_total")

$ot_value = $RunningTotal;

// Set $ot_text (display-formatted value)

// $ot_text = "\$" . number_format($ot_value, 2, '.', ',');

$order = new order($oID);

$ot_text = $currencies->format($ot_value, true, $order->info['currency'], $order->info['currency_value']);

if($ot_class == "ot_total")

$ot_text = "<b>" . $ot_text . "</b>";

if($ot_total_id > 0)

{

// In Database Already - Update

//print "ot_title = $ot_title<br>\n";

//print "ot_text = $ot_text<br>\n";

//print "ot_value = $ot_value<br>\n";

//print "sort_order = $sort_order<br>\n";

$Query = "update " . TABLE_ORDERS_TOTAL . " set

title = '$ot_title',

text = '$ot_text',

value = '$ot_value',

sort_order = '$sort_order'

where orders_total_id = '$ot_total_id'";

tep_db_query($Query);

}

else

{

// New Insert

$Query = "insert into " . TABLE_ORDERS_TOTAL . " set

orders_id = '$oID',

title = '$ot_title',

text = '$ot_text',

value = '$ot_value',

class = '$ot_class',

sort_order = '$sort_order'";

tep_db_query($Query);

}

$RunningTotal += $ot_value;

}

elseif($ot_total_id > 0)

{

// Delete Total Piece

$Query = "delete from " . TABLE_ORDERS_TOTAL . " where orders_total_id = '$ot_total_id'";

tep_db_query($Query);

}

if ($order_updated)

{

$messageStack->add_session(SUCCESS_ORDER_UPDATED, 'success');

}

tep_redirect(tep_href_link("edit_orders.php", tep_get_all_get_params(array('action')) . 'action=edit'));

break;

// Add a Product

case 'add_product':

if($step == 5)

{

// Get Order Info

$oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);

$order = new order($oID);

$AddedOptionsPrice = 0;

// Get Product Attribute Info

if(IsSet($add_product_options))

{

foreach($add_product_options as $option_id => $option_value_id)

{

$result = tep_db_query("SELECT * FROM " . TABLE_PRODUCTS_ATTRIBUTES . " pa LEFT JOIN " . TABLE_PRODUCTS_OPTIONS . " po ON po.products_options_id=pa.options_id LEFT JOIN " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov ON pov.products_options_values_id=pa.options_values_id WHERE products_id='$add_product_products_id' and options_id=$option_id and options_values_id=$option_value_id");

$row = tep_db_fetch_array($result);

extract($row, EXTR_PREFIX_ALL, "opt");

$AddedOptionsPrice += $opt_options_values_price;

$option_value_details[$option_id][$option_value_id] = array ("options_values_price" => $opt_options_values_price);

$option_names[$option_id] = $opt_products_options_name;

$option_values_names[$option_value_id] = $opt_products_options_values_name;

}

// Get Product Info

$InfoQuery = "select p.products_model,p.products_price,pd.products_name,p.products_tax_class_id from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on pd.products_id=p.products_id where p.products_id='$add_product_products_id'";

$result = tep_db_query($InfoQuery);

$row = tep_db_fetch_array($result);

extract($row, EXTR_PREFIX_ALL, "p");

// Following functions are defined at the bottom of this file

$CountryID = tep_get_country_id($order->delivery["country"]);

$ZoneID = tep_get_zone_id($CountryID, $order->delivery["state"]);

$ProductsTax = tep_get_tax_rate($p_products_tax_class_id, $CountryID, $ZoneID);

$Query = "insert into " . TABLE_ORDERS_PRODUCTS . " set

orders_id = $oID,

products_id = $add_product_products_id,

products_model = '$p_products_model',

products_name = '" . str_replace("'", "'", $p_products_name) . "',

products_price = '$p_products_price',

final_price = '" . ($p_products_price + $AddedOptionsPrice) . "',

products_tax = '$ProductsTax',

products_quantity = $add_product_quantity;";

tep_db_query($Query);

$new_product_id = tep_db_insert_id();

if(IsSet($add_product_options))

{

foreach($add_product_options as $option_id => $option_value_id)

{

$Query = "insert into " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " set

orders_id = $oID,

orders_products_id = $new_product_id,

products_options = '" . $option_names[$option_id] . "',

products_options_values = '" . $option_values_names[$option_value_id] . "',

options_values_price = '" . $option_value_details[$option_id][$option_value_id]["options_values_price"] . "',

price_prefix = '+';";

tep_db_query($Query);

}

// Stock Update

$stock_chk_query = tep_db_query("select products_quantity from products where products_id = '" . $add_product_products_id . "'");

$stock_chk_values = tep_db_fetch_array($stock_chk_query);

$stock_chk_left = $stock_chk_values['products_quantity'] - $add_product_quantity;

tep_db_query("update products set products_quantity = '" . $stock_chk_left . "' where products_id = '" . $add_product_products_id . "'");

// Update products_ordered (for bestsellers list)

tep_db_query("update products set products_ordered = products_ordered + " . $add_product_quantity . " where products_id = '" . $add_product_products_id . "'");

// Calculate Tax and Sub-Totals

$order = new order($oID);

$RunningSubTotal = 0;

$RunningTax = 0;

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

{

$RunningSubTotal += ($order->products[$i]['qty'] * $order->products[$i]['final_price']);

$RunningTax += (($order->products[$i]['tax'] / 100) * ($order->products[$i]['qty'] * $order->products[$i]['final_price']));

}

// Tax

$Query = "update " . TABLE_ORDERS_TOTAL . " set

text = '\$" . number_format($RunningTax, 2, '.', ',') . "',

value = '" . $RunningTax . "'

where class='ot_tax' and orders_id=$oID";

tep_db_query($Query);

// Sub-Total

$Query = "update " . TABLE_ORDERS_TOTAL . " set

text = '\$" . number_format($RunningSubTotal, 2, '.', ',') . "',

value = '" . $RunningSubTotal . "'

where class='ot_subtotal' and orders_id=$oID";

tep_db_query($Query);

// Total

$Query = "select sum(value) as total_value from " . TABLE_ORDERS_TOTAL . " where class != 'ot_total' and orders_id=$oID";

$result = tep_db_query($Query);

$row = tep_db_fetch_array($result);

$Total = $row["total_value"];

$Query = "update " . TABLE_ORDERS_TOTAL . " set

text = '<b>\$" . number_format($Total, 2, '.', ',') . "</b>',

value = '" . $Total . "'

where class='ot_total' and orders_id=$oID";

tep_db_query($Query);

tep_redirect(tep_href_link("edit_orders.php", tep_get_all_get_params(array('action')) . 'action=edit'));

}

break;

}

if (($action == 'edit') && isset($HTTP_GET_VARS['oID'])) {

$oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);

$orders_query = tep_db_query("select orders_id from " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'");

$order_exists = true;

if (!tep_db_num_rows($orders_query)) {

$order_exists = false;

$messageStack->add(sprintf(ERROR_ORDER_DOES_NOT_EXIST, $oID), 'error');

}

?>

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<head>

</head>

<?php

require(DIR_WS_INCLUDES . 'header.php');

?>

<tr>

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">

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

</table></td>

<?php

if (($action == 'edit') && ($order_exists == true)) {

$order = new order($oID);

?>

<tr>

<tr>

<td class="pageHeading" align="right"><?php echo '<a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action'))) . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a>'; ?></td>

</tr>

</table></td>

</tr>

<tr>

</tr>

<tr>

<tr>

</tr>

<tr>

<tr>

<td><input name='update_customer_name' size='37' value='<?php echo tep_html_quotes($order->customer['name']); ?>'></td>

</tr>

<tr>

<td><font size="1" face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular"><b>Company: </b></font></td>

<td><input name='update_customer_company' size='37' value='<?php echo tep_html_quotes($order->customer['company']); ?>'></td>

</tr>

<tr>

<td><font size="1" face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular"><b>Address: </b></font></td>

<td><input name='update_customer_street_address' size='37' value='<?php echo tep_html_quotes($order->customer['street_address']); ?>'></td>

</tr>

<tr>

<td><font size="1" face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular"><b>Suburb: </b></font></td>

<td><input name='update_customer_surburb' size='37' value='<?php echo tep_html_quotes($order->customer['suburb']); ?>'></td>

</tr>

<tr>

<td><input name='update_customer_city' size='15' value='<?php echo tep_html_quotes($order->customer['city']); ?>'> </td>

</tr>

<tr>

<td><font size="1" face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular"><b>State: </b></font></td>

<td><input name='update_customer_state' size='15' value='<?php echo tep_html_quotes($order->customer['state']); ?>'> </td>

</tr>

<tr>

<td><input name='update_customer_postcode' size='5' value='<?php echo $order->customer['postcode']; ?>'></td>

</tr>

<tr>

<td><font size="1" face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular"><b>Country: </b></font></td>

<td><input name='update_customer_country' size='37' value='<?php echo tep_html_quotes($order->customer['country']); ?>'></td>

</tr>

</table>

</td>

<? if($SeparateBillingFields) { ?>

<td>

<tr>

<tr>

<td><input name='update_billing_name' size='37' value='<?php echo tep_html_quotes($order->billing['name']); ?>'></td>

</tr>

<tr>

<td><font size="1" face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular"><b>Company: </b></font></td>

<td><input name='update_billing_company' size='37' value='<?php echo tep_html_quotes($order->billing['company']); ?>'></td>

</tr>

<tr>

<td><font size="1" face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular"><b>Address: </b></font></td>

<td><input name='update_billing_street_address' size='37' value='<?php echo tep_html_quotes($order->billing['street_address']); ?>'></td>

</tr>

<tr>

<td><font size="1" face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular"><b>Suburb: </b></font></td>

<td><input name='update_billing_surburb' size='37' value='<?php echo tep_html_quotes($order->billing['suburb']); ?>'></td>

</tr>

<tr>

<td><input name='update_billing_city' size='15' value='<?php echo tep_html_quotes($order->billing['city']); ?>'> </td>

</tr>

<tr>

<td><font size="1" face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular"><b>State: </b></font></td>

<td><input name='update_billing_state' size='15' value='<?php echo tep_html_quotes($order->billing['state']); ?>'> </td>

</tr>

<tr>

<td><input name='update_billing_postcode' size='5' value='<?php echo $order->billing['postcode']; ?>'></td>

</tr>

<tr>

<td><font size="1" face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular"><b>Country: </b></font></td>

<td><input name='update_billing_country' size='37' value='<?php echo tep_html_quotes($order->billing['country']); ?>'></td>

</tr>

</table>

</td>

</tr>

</table>

</td>

<? } ?>

</tr>

</table>

</td>

</tr>

<tr>

<tr>

</tr>

<tr>

<tr>

<td><input name='update_delivery_name' size='37' value='<?php echo tep_html_quotes($order->delivery['name']); ?>'></td>

</tr>

<tr>

<td><font size="1" face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular"><b>Company: </b></font></td>

<td><input name='update_delivery_company' size='37' value='<?php echo tep_html_quotes($order->delivery['company']); ?>'></td>

</tr>

<tr>

<td><font size="1" face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular"><b>Address: </b></font></td>

<td><input name='update_delivery_street_address' size='37' value='<?php echo tep_html_quotes($order->delivery['street_address']); ?>'></td>

</tr>

<tr>

<td><font size="1" face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular"><b>Suburb: </b></font></td>

<td><input name='update_delivery_surburb' size='37' value='<?php echo tep_html_quotes($order->delivery['suburb']); ?>'></td>

</tr>

<tr>

<td><input name='update_delivery_city' size='15' value='<?php echo tep_html_quotes($order->delivery['city']); ?>'> </td>

</tr>

<tr>

<td><font size="1" face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular"><b>State: </b></font></td>

<td><input name='update_delivery_state' size='15' value='<?php echo tep_html_quotes($order->delivery['state']); ?>'> </td>

</tr>

<tr>

<td><input name='update_delivery_postcode' size='5' value='<?php echo $order->delivery['postcode']; ?>'></td>

</tr>

<tr>

<td><font size="1" face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular"><b>Country: </b></font></td>

<td><input name='update_delivery_country' size='37' value='<?php echo tep_html_quotes($order->delivery['country']); ?>'></td>

</tr>

</table>

</td>

<font size="2" face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular" color="red"><b>!!! INSTRUCTIONS !!!</b></font><br><br>

Note: If you edit the orders product quanities<br>

they will not update your stock levels with the<br>

changes. So make sure you update them after this<br>

edit section.<br>

</td>

</tr>

</table>

</td>

</tr>

</table></td>

</tr>

<tr>

</tr>

<tr>

<tr>

<td class="main"><input name='update_customer_telephone' size='15' value='<?php echo $order->customer['telephone']; ?>'></td>

</tr>

<tr>

<td class="main"><input name='update_customer_email_address' size='35' value='<?php echo $order->customer['email_address']; ?>'></td>

</tr>

</table></td>

</tr>

<tr>

</tr>

<tr>

<td class="main"><?php echo tep_draw_pull_down_menu('update_info_payment_method', $orders_pay_method, $order->info['payment_method']); ?>

<?php echo tep_image_submit('button_update.gif', IMAGE_UPDATE); ?>

<?php

if($order->info['payment_method'] != "Credit Card")

echo ' To View CC Fields';

?>

<?php

if($order->info['payment_method'] != "Purchase Order")

echo ' or View PO Fields';

?>

</td>

</tr>

<?php if ($order->info['cc_type'] || $order->info['cc_owner'] || $order->info['payment_method'] == "Credit Card" || $order->info['cc_number']) { ?>

<tr>

</tr>

<tr>

</tr>

<tr>

<td class="main"><input name='update_info_cc_owner' size='20' value='<?php echo $order->info['cc_owner']; ?>'></td>

</tr>

<tr>

<td class="main"><input name='update_info_cc_number' size='20' value='<?php echo "(Last 4) " . substr($order->info['cc_number'],-4); ?>'></td>

</tr>

<tr>

<td class="main"><?php ech

GIZMO-XL · November 2, 2003

Well it did not save the complete edit_orders.php so here is a link to download it.

Now you need to download the new edit_orders.php file

Click here to download

Edited November 2, 2003 by GIZMO-XL

November 3, 2003

Hey Shawn

Installed u'r updates,, love them, Thanks for all the work u put in on these,,

I am however,, having some problems.

When the order is on screen. and you select the payment option and click update,, I am getting errors on each option selected.

error as follows

(select any/all payment options, and click update button)

Warning: Invalid argument supplied for foreach() in /home/pencilb/public_html/admin/edit_orders.php on line 222

Warning: Cannot modify header information - headers already sent by (output started at /home/pencilb/public_html/admin/edit_orders.php:222) in /home/pencilb/public_html/admin/includes/functions/general.php on line 18

Any thought on this ?

Regards

Tom

November 3, 2003

Shawn

I also figured out that if I type an amount into the customer discount box it is actaully added instead of subtracted.

Regards

Tom

GIZMO-XL · November 3, 2003

enter it as a -2.00 for a two dollar discount

GIZMO-XL · November 3, 2003

error as follows

(select any/all payment options, and click update button)

Warning: Invalid argument supplied for foreach() in /home/pencilb/public_html/admin/edit_orders.php on line 222

Warning: Cannot modify header information - headers already sent by (output started at /home/pencilb/public_html/admin/edit_orders.php:222) in /home/pencilb/public_html/admin/includes/functions/general.php on line 18

Any thought on this ?

Regards

Tom

Tom I have checked all the code and that section is from the base code.... Not sure what to tell you..

You are not using the beta version of the manual order are you?

November 3, 2003

Shawn,,

Thanks for taking time to reply.

nope,, updated to release version 1.1 on fri,,,

regards

Tom

GIZMO-XL · November 3, 2003

email me your edit_orders.php from before you added my version and let me check some things.

email to systems@microheli.com

Kristofor · November 8, 2003

Ok, i installed this contribution, and i have one problem, now my column left does not show up. it is only since i installed this contribution, wat could be causing this???

let me know

thanks

kristofor

Kristofor · November 9, 2003

I just checked some of the code, and it is a problem with the column left or the actual box itself, i think it is just the box. but i cant figure out what is wrong with the box code, can someone help me?

GIZMO-XL · November 9, 2003

This is what your manual_order.php should look like

it is located in the admin/includes/box dir

<?php
/*
?$Id: manual_order.php,v 1 7:09 PM 14/08/2003 frank Exp $

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

?Copyright (c) 2002 osCommerce

?Released under the GNU General Public License
*/
?>
<!-- manual_order //-->
? ? ? ? ?<tr>
? ? ? ? ? ?<td>
<?php
?$heading = array();
?$contents = array();

?$heading[] = array('text' ?=> BOX_HEADING_MANUAL_ORDER,
? ? ? ? ? ? ? ? ? ? 'link' ?=> tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('selected_box')) . 'selected_box=manual_order'));

?if ($selected_box == 'manual_order') {
? ?$contents[] = array('text' ?=> '<a href="' . tep_href_link(FILENAME_CREATE_ACCOUNT, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_MANUAL_ORDER_CREATE_ACCOUNT . '</a><br>' .
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? '<a href="' . tep_href_link(FILENAME_CREATE_ORDER, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_MANUAL_ORDER_CREATE_ORDER . '</a>');
?}

?$box = new box;
?echo $box->menuBox($heading, $contents);
?>
? ? ? ? ? ?</td>
? ? ? ? ?</tr>
<!-- taxes_eof //-->

My guess is it is a problem with your column_left.php file the following is a sample of how it should look.

<?php
/*
 $Id: column_left.php,v 1.15 2002/01/11 05:03:25 hpdl Exp $

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

 Copyright (c) 2002 osCommerce

 Released under the GNU General Public License
*/

 require(DIR_WS_BOXES . 'configuration.php');
 require(DIR_WS_BOXES . 'catalog.php');
 require(DIR_WS_BOXES . 'modules.php');
 require(DIR_WS_BOXES . 'customers.php');
 require(DIR_WS_BOXES . 'manual_order.php');
 require(DIR_WS_BOXES . 'taxes.php');
 require(DIR_WS_BOXES . 'localization.php');
 require(DIR_WS_BOXES . 'reports.php');
 require(DIR_WS_BOXES . 'tools.php');
 require(DIR_WS_BOXES . 'articles.php');
// Polls
 require(DIR_WS_BOXES . 'polls.php');
//BEGIN Information pages unlimited
 require(DIR_WS_BOXES . 'information.php');
//END Information pages unlimited


?>

Edited November 9, 2003 by GIZMO-XL

Kristofor · November 9, 2003

mmmmm..... so it could be because i have the admin access accounts installed, thing is if i put the stuff from the manual_order.php into any other box that box wont show up. im not sure what i have done wrong

November 19, 2003

Hi installed the mod and works well.

One problem though I have 26 categories and about 5500 products, when I hit add product it takes for every for the categories dropdown to come up and when I select the categorie it takes the same amount of time for the product dropdown to come up.

I am using mysql on openbsd 3.4 fast machine lots of ram. This is the only page that takes for every to come up

Any ideas would be helpful

Thanks

gunwalt · November 20, 2003

Hi,

the contribution works great. Now I have a small problem that I have to change the Adress in a german form.

When I start a new order, I would like to get the Postcode und the city in the order.php und afterwards in the invoive.php in such a way:

"40699 Erkrath" and not "Erkrath, 40699".

Can anyone help me.

Guntram

frankl · November 20, 2003

I would like to get the Postcode und the city in the order.php und afterwards in the invoive.php in such a way:
"40699 Erkrath" and not "Erkrath, 40699".

You need to edit the SQL entry.

I am using address format 1, so to get this format:

Customer Firstname Lastname

Street Address

Suburb State Postcode

Country

my address format 1 is:

$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country

($cr is a new line, ',' - is a comma)

You can play around with it, but you would probably need to use

$firstname $lastname$cr$streets$cr$postcode $city$cr$state $country

gunwalt · November 20, 2003

Hi Frank,

thanks for your answer.

>>$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country

>>($cr is a new line, ',' - is a comma)

>>You can play around with it, but you would probably need to use

>>$firstname $lastname$cr$streets$cr$postcode $city$cr$state $country

But I would like to know, where the adress format is defined and where I have to change 1 to 5. 5 seems to be the german adress format.

Guntram

gunwalt · November 21, 2003

Hi Frank,

I've discovered the mistake. I' ve to change in the "create_order_process.php" the format_id to 5. Now it works.

But there is a very small problem in the "edit_orders.php". Step 2 Choose a product - here you can choose all products in the group. But you can choose all the products too, which are deactivated in the catalog.

Guntram

thomasf1 · November 24, 2003

Hello,

You might write into your readme-File that you hardcoded the $currency = "AUD"; in the file create_order_process.php :-).

Greetings from Germany,

Thomas

PS: I used "step_by_step_orders_v1.1", it seemed to be the latesd Version ?!

JonCloud · November 24, 2003

Hello,

I installed the contribution and I almost have it working. When I try to create a new account, I get a page not found with a URL that looks like this http://deeptronics.com/admin/HTTPS_SERVER/...unt_process.php.

Also, when I try to create an order, I select the customer from the drop down and hit conifm, I then get the following error.

1054 - Unknown column 'new_value' in 'field list'

insert into orders_status_history (orders_id, new_value, date_added) values ('11', '1', now())

[TEP STOP]

What doe it all mean? Can anyone assist?

Jason

November 30, 2003

I am really looking forward to getting the contrib working, so we can take phone orders.

I have installed this and am testing it. the create order module seems to work. I can edit and create orders. When will the contrib be updated with the customer discount, shipping and payment additions? will these changes work with osc 2.2MS1? I would like to add them from this discussion.

I do have a problem with creating accounts. The name is saveed and that is all (so non of the other fiends entered show up under the account), also the customer can not login with the password they are emailed. If they request a new one the new one works. then if I click the link to do a manual oder after creating the account I get redirected to http://https_serveradmin/create_order.php instead of the correct server

Thank you

MLu · November 30, 2003

The choice of currency has been hard-coded like this:

admin/create_order_process.php

43 $temp_amount = number_format($temp_amount, 2, '.', '');
44 $currency = "USD";
45 $currency_value = "1";

But in this way all manually created orders are born with eg. USD as currency. I have orders in varying currencies, GBP, DKK, NOK, SEK, EUR, so it would be convenient to have an option to select the currency when creating the order. Otherwise, the only alterntive is to manually edit create_order_process.php each time. Could someone please advice on how this could be done?

Thanks

Mogens

Morbantokk · November 30, 2003

I am really looking forward to getting the contrib working, so we can take phone orders.

I have installed this and am testing it. the create order module seems to work. I can edit and create orders. When will the contrib be updated with the customer discount, shipping and payment additions? will these changes work with osc 2.2MS1? I would like to add them from this discussion.

I do have a problem with creating accounts. The name is saveed and that is all (so non of the other fiends entered show up under the account), also the customer can not login with the password they are emailed. If they request a new one the new one works. then if I click the link to do a manual oder after creating the account I get redirected to http://https_serveradmin/create_order.php instead of the correct server

Thank you

thats my problem too: the new created customer cannot login with the password in the email.

whats the error?

[Contribution] Step-By-Step Manual Order

Recommended Posts

Guest

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

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

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

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

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

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation