Index: openacs-4/packages/ecommerce/ecommerce.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/ecommerce.info,v
diff -u -r1.30 -r1.31
--- openacs-4/packages/ecommerce/ecommerce.info	27 Nov 2002 00:38:11 -0000	1.30
+++ openacs-4/packages/ecommerce/ecommerce.info	30 Nov 2002 17:30:42 -0000	1.31
@@ -71,6 +71,7 @@
             <file type="query_file" db_type="postgresql" path="tcl/ecommerce-procs-postgresql.xql"/>
             <file type="tcl_procs" path="tcl/ecommerce-procs.tcl"/>
             <file type="query_file" path="tcl/ecommerce-procs.xql"/>
+            <file type="tcl_init" path="tcl/ecommerce-scheduled-init.tcl"/>
             <file type="query_file" db_type="oracle" path="tcl/ecommerce-scheduled-procs-oracle.xql"/>
             <file type="query_file" db_type="postgresql" path="tcl/ecommerce-scheduled-procs-postgresql.xql"/>
             <file type="tcl_procs" path="tcl/ecommerce-scheduled-procs.tcl"/>
@@ -402,6 +403,8 @@
             <file type="query_file" path="www/admin/orders/items-void-2.xql"/>
             <file type="content_page" path="www/admin/orders/items-void.tcl"/>
             <file type="query_file" path="www/admin/orders/items-void.xql"/>
+            <file type="query_file" db_type="oracle" path="www/admin/orders/one-oracle.xql"/>
+            <file type="query_file" db_type="postgresql" path="www/admin/orders/one-postgresql.xql"/>
             <file type="content_page" path="www/admin/orders/one.tcl"/>
             <file type="query_file" path="www/admin/orders/one.xql"/>
             <file type="query_file" db_type="oracle" path="www/admin/orders/refunds-oracle.xql"/>
@@ -969,53 +972,53 @@
             <file type="query_file" path="www/update-user-classes.xql"/>
         </files>
         <parameters>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="CreditCardsAccepted"  default="VISA {American Express} MasterCard" description="A list of accepted credit card types" section_name="payment information"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="ECTemplatesMayContainTclFunctionsP"  default="1" description="Set to 1 if Tcl functions are allowed in the product and e-mail templates. Set to 0 if not." section_name="style"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="ShippingGateway"  description="The shipping gateway that should be used to calculate the shipping charges instead of the default ecommerce calculations." section_name="shipping"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="httpModule"  description="The AOLserver module that implements &quot;normal&quot; communications (usually nsunix or nssock) Typical behavior favors nsunix over nssock, if both are present.  You only need to set this parameter if your site supports both nsunix and nssock, but you prefer nssock." section_name="SSL"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="InsecureLocation"  description="A URL fragment (protocol, hostname, and port) appended before &quot;insecure&quot; transactions URLs. Defaults to &quot;&quot;" section_name="SSL"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="SecureLocation"  description="A URL fragment (protocol, hostname, and port) appended before transactions URLs.  Defaults to &quot;&quot;.  If the value is &quot;&quot; ecommerce will examine the values of httpModule and httpsModule to determine the secure location." section_name="SSL"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="WeightUnits"  default="lbs" description="weight units such as pounds, carats, ounces, etc." section_name="units"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="Currency"  default="USD" description="currency units, USD, dollars, lira, etc." section_name="units"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="ProductsToDisplayPerPage"  default="10" description="this is used on the category browse page (and for subcategories/subsubcategories)" section_name="display"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="ProductCommentsAllowP"  default="1" description="whether to allow user comments on products" section_name="display"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="ProductCommentsNeedApprovalP"  default="1" description="whether user comments on products (if allowed) need approval before becoming live" section_name="display"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="CalcProductRelationshipsP"  default="0" description="whether the system should calculate additional product relationships" section_name="display"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="UserClassUserViewP"  default="1" description="whether users can see what user classes they are in" section_name="display"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="UserClassAllowSelfPlacement"  default="1" description="whether a user can request to be a member of a user class" section_name="display"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="UserClassApproveP"  default="1" description="if a user requests to be in a user class, is approval required before that user becomes a member of the user class" section_name="display"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="ShippingRefundPercent"  default="0" description="percentage refunded if an item is returned" section_name="associated charges"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="EnabledP"  default="1" description="set this to 1 if you're using the ecommerce module"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="ThumbnailWidth"  default="100" description="for thumbnails of products, specify either width or height (whichever is more important, and then the other will be determined based on the original image size, keeping aspect ratio constant) -- if both are specified, the width setting will take precedence, and if neither is specified, the thumbnail will be width default=100" section_name="display"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="ThumbnailHeight"  default="100" description="for thumbnails of products, specify either width or height (whichever is more important, and then the other will be determined based on the original image size, keeping aspect ratio constant) -- if both are specified, the width setting will take precedence, and if neither is specified, the thumbnail will be width default=100" section_name="display"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="StockMessageO"  default="Out of Stock" description="text of out of stock message" section_name="messages"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="StockMessageQ"  default="Usually Ships Within 24 Hours" description="text of ships quickly message" section_name="messages"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="StockMessageM"  default="Usually Ships Within 2-3 Days" description="text of hips moderately quickly message" section_name="messages"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="StockMessageS"  default="Usually Ships Within 2-4 Weeks" description="text of ships slowly message" section_name="messages"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="StockMessageI"  default="In Stock" description="in stock" section_name="messages"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="CartDuration"  default="30" description="# of days an 'in_basket' order will remain in the system before a cron job expires it" section_name="shopping cart"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="AllowPreOrdersP"  default="1" description="whether customers will be able to place orders for items whose available_date has not yet come" section_name="shopping cart"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="CustomerServiceEmailAddress"  default="service@yourdomain.com" description="all outgoing email is sent from this address" section_name="technical"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="CustomerServiceEmailDescription"  default="Ecommerce Customer Service" description="the description of the outgoing email address" section_name="technical"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="DisplayTransactionMessagesDuringFulfillmentP"  default="1" description="you may or may not wish to have the people recording shipments receive messages like 'unable to authorize payment for shipment' -- depending on whether they they're in a position to do anything about the problem (e.g. abort shipment)" section_name="fulfillment"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="SellGiftCertificatesP"  default="1" description="whether to allow users to buy gift certificates" section_name="gift certificates"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="MinGiftCertificateAmount"  default="5" description="minimum gift certificate amount they can buy (this does not impose minimum amount for administrators giving users gift certificates)" section_name="gift certificates"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="MaxGiftCertificateAmount"  default="300" description="maximum gift certificate amount they can buy" section_name="gift certificates"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="GiftCertificateMonths"  default="12" description="number of months until user-purchased gift certificates expire" section_name="gift certificates"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="EcommerceDataDirectory"  default="/web/yourservername/data/ecommerce/" description="path to Product data directories (where product files like images are kept).  It is useful to keep this away from the normal pageroot so that uploaded .tcl or .adp files cannot be executed with a URL. IF YOU DON'T SET THIS CORRECTLY, YOUR SYSTEM WON'T WORK!  Make sure to replace yourservername with the correct name.  You also have to create the directories you specify in the file-system.  See technical setup document." section_name="technical"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="ProductDataDirectory"  default="product/" description="This path goes on the end of the EcommerceDataDirectory. IF YOU DON'T SET THIS CORRECTLY, YOUR SYSTEM WON'T WORK!  Make sure to replace yourservername with the correct name.  You also have to create the directories you specify in the file-system.  See technical setup document." section_name="technical"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="MultipleRetailersPerProductP"  default="0" description="Set to 1 if you have a comparison shopping service -- Note: support for multiple retailers does not work yet in Version 1.0 of the Ecommerce Module, so leave it as 0" section_name="technical"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="OfferTaxExemptStatusP"  default="0" description="Should we ask people if their organization is tax exempt?" section_name="associated charges"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="CacheRefresh"  default="600" description="Seconds between cache (util_memoize) updates" section_name="technical"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="SystemOwner"  description="email address of owner of shop" section_name="technical"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="SystemName"  default="Store" description="name of ecommerce system"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="httpsModule"  default="nsopenssl" description="The preferred AOLserver module that implements SSL.  Typical behavior favors nsopenssl over nsssl.  This parameter is only important if your site, for some unusual reason supports both nsopenssl as well as nsssl and you prefer nsssl." section_name="SSL"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="ImageMagickPath"  default="/usr/local/bin/convert" description="ImageMagick's Convert utility is required to make thumbnails of products.  This parameter points to the path of convert" section_name="technical"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="SaveCreditCardDataP"  default="1" description="Whether to save credit card data (you have to save it if you're going to do manual billing) -- if you save it, then your users can reuse their credit card with one click" section_name="payment information"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="PaymentGateway"  description="The package-key of the payment  gateway to use. Leave empty if you don't want to use a gateway." section_name="payment information"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="PaymentRetryPeriod"  default="8" description="The time in hours that temporarily failed transactions should be repeated for. Transactions that do not receive a definitive answer from the gateway with this period fail at the end of the period." section_name="payment information"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="PickupP"  default="0" description="Can orders be picked up from your location by customers?" section_name="shipping"/>
             <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="ExpressShippingP"  default="1" description="Is express shipping available to your customers?" section_name="shipping"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="PickupP"  default="0" description="Can orders be picked up from your location by customers?" section_name="shipping"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="PaymentRetryPeriod"  default="8" description="The time in hours that temporarily failed transactions should be repeated for. Transactions that do not receive a definitive answer from the gateway with this period fail at the end of the period." section_name="payment information"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="PaymentGateway"  description="The package-key of the payment  gateway to use. Leave empty if you don't want to use a gateway." section_name="payment information"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="SaveCreditCardDataP"  default="1" description="Whether to save credit card data (you have to save it if you're going to do manual billing) -- if you save it, then your users can reuse their credit card with one click" section_name="payment information"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="ImageMagickPath"  default="/usr/local/bin/convert" description="ImageMagick's Convert utility is required to make thumbnails of products.  This parameter points to the path of convert" section_name="technical"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="httpsModule"  default="nsopenssl" description="The preferred AOLserver module that implements SSL.  Typical behavior favors nsopenssl over nsssl.  This parameter is only important if your site, for some unusual reason supports both nsopenssl as well as nsssl and you prefer nsssl." section_name="SSL"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="SystemName"  default="Store" description="name of ecommerce system"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="SystemOwner"  description="email address of owner of shop" section_name="technical"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="CacheRefresh"  default="600" description="Seconds between cache (util_memoize) updates" section_name="technical"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="OfferTaxExemptStatusP"  default="0" description="Should we ask people if their organization is tax exempt?" section_name="associated charges"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="MultipleRetailersPerProductP"  default="0" description="Set to 1 if you have a comparison shopping service -- Note: support for multiple retailers does not work yet in Version 1.0 of the Ecommerce Module, so leave it as 0" section_name="technical"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="ProductDataDirectory"  default="product/" description="This path goes on the end of the EcommerceDataDirectory. IF YOU DON'T SET THIS CORRECTLY, YOUR SYSTEM WON'T WORK!  Make sure to replace yourservername with the correct name.  You also have to create the directories you specify in the file-system.  See technical setup document." section_name="technical"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="EcommerceDataDirectory"  default="/web/yourservername/data/ecommerce/" description="path to Product data directories (where product files like images are kept).  It is useful to keep this away from the normal pageroot so that uploaded .tcl or .adp files cannot be executed with a URL. IF YOU DON'T SET THIS CORRECTLY, YOUR SYSTEM WON'T WORK!  Make sure to replace yourservername with the correct name.  You also have to create the directories you specify in the file-system.  See technical setup document." section_name="technical"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="GiftCertificateMonths"  default="12" description="number of months until user-purchased gift certificates expire" section_name="gift certificates"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="MaxGiftCertificateAmount"  default="300" description="maximum gift certificate amount they can buy" section_name="gift certificates"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="MinGiftCertificateAmount"  default="5" description="minimum gift certificate amount they can buy (this does not impose minimum amount for administrators giving users gift certificates)" section_name="gift certificates"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="SellGiftCertificatesP"  default="1" description="whether to allow users to buy gift certificates" section_name="gift certificates"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="DisplayTransactionMessagesDuringFulfillmentP"  default="1" description="you may or may not wish to have the people recording shipments receive messages like 'unable to authorize payment for shipment' -- depending on whether they they're in a position to do anything about the problem (e.g. abort shipment)" section_name="fulfillment"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="CustomerServiceEmailDescription"  default="Ecommerce Customer Service" description="the description of the outgoing email address" section_name="technical"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="CustomerServiceEmailAddress"  default="service@yourdomain.com" description="all outgoing email is sent from this address" section_name="technical"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="AllowPreOrdersP"  default="1" description="whether customers will be able to place orders for items whose available_date has not yet come" section_name="shopping cart"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="CartDuration"  default="30" description="# of days an 'in_basket' order will remain in the system before a cron job expires it" section_name="shopping cart"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="StockMessageI"  default="In Stock" description="in stock" section_name="messages"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="StockMessageS"  default="Usually Ships Within 2-4 Weeks" description="text of ships slowly message" section_name="messages"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="StockMessageM"  default="Usually Ships Within 2-3 Days" description="text of hips moderately quickly message" section_name="messages"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="StockMessageQ"  default="Usually Ships Within 24 Hours" description="text of ships quickly message" section_name="messages"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="StockMessageO"  default="Out of Stock" description="text of out of stock message" section_name="messages"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="ThumbnailHeight"  default="100" description="for thumbnails of products, specify either width or height (whichever is more important, and then the other will be determined based on the original image size, keeping aspect ratio constant) -- if both are specified, the width setting will take precedence, and if neither is specified, the thumbnail will be width default=100" section_name="display"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="ThumbnailWidth"  default="100" description="for thumbnails of products, specify either width or height (whichever is more important, and then the other will be determined based on the original image size, keeping aspect ratio constant) -- if both are specified, the width setting will take precedence, and if neither is specified, the thumbnail will be width default=100" section_name="display"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="EnabledP"  default="1" description="set this to 1 if you're using the ecommerce module"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="ShippingRefundPercent"  default="0" description="percentage refunded if an item is returned" section_name="associated charges"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="UserClassApproveP"  default="1" description="if a user requests to be in a user class, is approval required before that user becomes a member of the user class" section_name="display"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="UserClassAllowSelfPlacement"  default="1" description="whether a user can request to be a member of a user class" section_name="display"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="UserClassUserViewP"  default="1" description="whether users can see what user classes they are in" section_name="display"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="CalcProductRelationshipsP"  default="0" description="whether the system should calculate additional product relationships" section_name="display"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="ProductCommentsNeedApprovalP"  default="1" description="whether user comments on products (if allowed) need approval before becoming live" section_name="display"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="ProductCommentsAllowP"  default="1" description="whether to allow user comments on products" section_name="display"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="ProductsToDisplayPerPage"  default="10" description="this is used on the category browse page (and for subcategories/subsubcategories)" section_name="display"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="Currency"  default="USD" description="currency units, USD, dollars, lira, etc." section_name="units"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="WeightUnits"  default="lbs" description="weight units such as pounds, carats, ounces, etc." section_name="units"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="SecureLocation"  description="A URL fragment (protocol, hostname, and port) appended before transactions URLs.  Defaults to &quot;&quot;.  If the value is &quot;&quot; ecommerce will examine the values of httpModule and httpsModule to determine the secure location." section_name="SSL"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="InsecureLocation"  description="A URL fragment (protocol, hostname, and port) appended before &quot;insecure&quot; transactions URLs. Defaults to &quot;&quot;" section_name="SSL"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="httpModule"  description="The AOLserver module that implements &quot;normal&quot; communications (usually nsunix or nssock) Typical behavior favors nsunix over nssock, if both are present.  You only need to set this parameter if your site supports both nsunix and nssock, but you prefer nssock." section_name="SSL"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="ShippingGateway"  description="The shipping gateway that should be used to calculate the shipping charges instead of the default ecommerce calculations." section_name="shipping"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="ECTemplatesMayContainTclFunctionsP"  default="1" description="Set to 1 if Tcl functions are allowed in the product and e-mail templates. Set to 0 if not." section_name="style"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="CreditCardsAccepted"  default="VISA {American Express} MasterCard" description="A list of accepted credit card types" section_name="payment information"/>
         </parameters>
 
     </version>