Index: openacs-4/packages/ecommerce/tcl/ecommerce-utilities-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/tcl/ecommerce-utilities-procs.xql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/ecommerce/tcl/ecommerce-utilities-procs.xql 23 Oct 2001 05:07:14 -0000 1.3 +++ openacs-4/packages/ecommerce/tcl/ecommerce-utilities-procs.xql 26 May 2002 04:36:50 -0000 1.4 @@ -1,77 +1,86 @@ + - - - select min(price) from ec_offers where product_id=:product_id - - + + + select min(price) + from ec_offers + where product_id = :product_id + + + + + + select retailprice + from ec_custom_product_field_values + where product_id = :product_id + + + + + + select min(price) + from ec_offers + where product_id = :product_id + + + + + + select user_id, first_names, last_name, email, other_id_info, postal_code + from ec_user_identification + where user_identification_id = :user_identification_id + + - - - - select retailprice from ec_custom_product_field_values where product_id=:product_id - - + + + + select first_names || ' ' || last_name + from cc_users + where user_id = :user_id + + + + + + select line1, line2, city, usps_abbrev, zip_code, country_code, full_state_name, attn, phone, phone_time + from ec_addresses + where address_id = :address_id + + + + + + select c.creditcard_type, c.creditcard_last_four, c.creditcard_expire, a.address_id + from ec_creditcards c, ec_addresses a + where creditcard_id = :creditcard_id + and c.billing_address = a.address_id + + - - - - select min(price) from ec_offers where product_id=:product_id - - - - - - - select user_id,first_names,last_name,email,other_id_info,postal_code from ec_user_identification where user_identification_id=:user_identification_id - - - - - - - select first_names || ' ' || last_name from cc_users where user_id=:user_id - - - - - - - select line1, line2, city, usps_abbrev, zip_code, country_code, full_state_name, attn, phone, phone_time from ec_addresses where address_id=:address_id - - - - - - - select creditcard_type, creditcard_last_four, creditcard_expire, billing_zip_code from ec_creditcards where creditcard_id=:creditcard_id - - - - - - - select default_name from countries where iso=:country_code - - - - - - - select case when shipping_method = 'no shipping' then 0 else 1 end as shippable_p from ec_orders where order_id=:order_id - - - - - - + + + select default_name from countries where iso = :country_code + + + + + + select case when shipping_method = 'no shipping' then 0 else 1 end as shippable_p + from ec_orders + where order_id = :order_id + + + + + select - gift_certificate_state, user_id - from ec_gift_certificates - where gift_certificate_id=:gift_certificate_id - - - - + gift_certificate_state, user_id + from ec_gift_certificates + where gift_certificate_id = :gift_certificate_id + + +