Index: openacs-4/packages/ecommerce/www/admin/orders/items-add-2.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/orders/items-add-2.tcl,v diff -u -r1.1 -r1.2 --- openacs-4/packages/ecommerce/www/admin/orders/items-add-2.tcl 20 Apr 2001 20:51:14 -0000 1.1 +++ openacs-4/packages/ecommerce/www/admin/orders/items-add-2.tcl 29 Jan 2002 00:11:46 -0000 1.2 @@ -7,7 +7,7 @@ @author ported by Jerry Asher (jerry@theashergroup.com) } { order_id:integer,notnull - product_id:integer,optional + sku:optional product_name:optional } @@ -22,8 +22,8 @@
" -if { [exists_and_not_null product_id] } { - set additional_query_part "product_id=:product_id" +if { [exists_and_not_null sku] } { + set additional_query_part "sku=:sku" } else { set additional_query_part "upper(product_name) like '%' || upper(:product_name) || '%'" } @@ -38,7 +38,6 @@ " } incr product_counter -# doc_body_append "
  • $product_name\n" doc_body_append "
  • $product_name
    [ec_add_to_cart_link $product_id "Add to Order" "Add to Order" "items-add-3" $order_id]