Index: openacs-4/packages/ecommerce/tcl/ecommerce-state-changes-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/tcl/ecommerce-state-changes-procs.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/ecommerce/tcl/ecommerce-state-changes-procs.xql	10 Jul 2001 20:38:43 -0000	1.1
+++ openacs-4/packages/ecommerce/tcl/ecommerce-state-changes-procs.xql	26 May 2002 04:36:50 -0000	1.2
@@ -1,60 +1,83 @@
 <?xml version="1.0"?>
+
 <queryset>
 
-<fullquery name="ec_update_state_to_in_basket.credit_user_select">      
-      <querytext>
-      select creditcard_id, user_id from ec_orders where order_id=:order_id
-      </querytext>
-</fullquery>
+  <fullquery name="ec_update_state_to_in_basket.credit_user_select">      
+    <querytext>
+      select creditcard_id, user_id 
+      from ec_orders 
+      where order_id=:order_id
+    </querytext>
+  </fullquery>
+  
+  <fullquery name="ec_update_state_to_in_basket.order_state_update">      
+    <querytext>
+      update ec_orders 
+      set order_state='in_basket', confirmed_date=null 
+      where order_id=:order_id
+    </querytext>
+  </fullquery>
+  
+  <fullquery name="ec_update_state_to_in_basket.creditcard_update">      
+    <querytext>
+      update ec_creditcards 
+      set failed_p='t' 
+      where creditcard_id=:creditcard_id
+    </querytext>
+  </fullquery>
+  
+  <fullquery name="ec_update_state_to_authorized.transaction_select">      
+    <querytext>
+      select max(transaction_id) 
+      from ec_financial_transactions 
+      where order_id=:order_id
+    </querytext>
+  </fullquery>
+  
+  <fullquery name="ec_update_state_to_in_basket.order_state_update">      
+    <querytext>
+      update ec_orders 
+      set order_state='in_basket', confirmed_date=null 
+      where order_id=:order_id
+    </querytext>
+  </fullquery>
+  
+  <fullquery name="ec_update_state_to_authorized.set_soft_goods_shipped">
+    <querytext>
+      update ec_items
+      set item_state = 'shipped', shipment_id = :shipment_id
+      from ec_products p
+      where ec_items.order_id = :order_id
+      and ec_items.product_id = p.product_id
+      and p.no_shipping_avail_p = 't'
+    </querytext>
+  </fullquery>
 
- 
-<fullquery name="ec_update_state_to_in_basket.order_state_update">      
-      <querytext>
-      update ec_orders set order_state='in_basket', confirmed_date=null where order_id=:order_id
-      </querytext>
-</fullquery>
+  <fullquery name="ec_update_state_to_authorized.set_hard_goods_to_be_shipped">      
+    <querytext>
+      update ec_items 
+      set item_state = 'to_be_shipped' 
+      from ec_products p
+      where ec_items.order_id = :order_id
+      and ec_items.product_id = p.product_id
+      and p.no_shipping_avail_p = 'f'
+    </querytext>
+  </fullquery>
 
- 
-<fullquery name="ec_update_state_to_in_basket.creditcard_update">      
-      <querytext>
-      update ec_creditcards set failed_p='t' where creditcard_id=:creditcard_id
-      </querytext>
-</fullquery>
-
- 
-<fullquery name="ec_update_state_to_authorized.transaction_select">      
-      <querytext>
-      select max(transaction_id) from ec_financial_transactions where order_id=:order_id
-      </querytext>
-</fullquery>
-
- 
-<fullquery name="ec_update_state_to_in_basket.order_state_update">      
-      <querytext>
-      update ec_orders set order_state='in_basket', confirmed_date=null where order_id=:order_id
-      </querytext>
-</fullquery>
-
- 
-<fullquery name="ec_update_state_to_authorized.set_to_be_shipped">      
-      <querytext>
-      update ec_items set item_state='to_be_shipped' where order_id=:order_id
-      </querytext>
-</fullquery>
-
- 
-<fullquery name="ec_update_state_to_confirmed.user_id_select">      
-      <querytext>
-      select user_id from ec_orders where order_id=:order_id
-      </querytext>
-</fullquery>
-
- 
-<fullquery name="ec_update_state_to_in_basket.order_state_update">      
-      <querytext>
-      update ec_orders set order_state='in_basket', confirmed_date=null where order_id=:order_id
-      </querytext>
-</fullquery>
-
- 
+  <fullquery name="ec_update_state_to_confirmed.user_id_select">      
+    <querytext>
+      select user_id 
+      from ec_orders 
+      where order_id=:order_id
+    </querytext>
+  </fullquery>
+  
+  <fullquery name="ec_update_state_to_in_basket.order_state_update">      
+    <querytext>
+      update ec_orders 
+      set order_state='in_basket', confirmed_date=null 
+      where order_id=:order_id
+    </querytext>
+  </fullquery>
+  
 </queryset>