Index: openacs-4/packages/value-based-shipping/value-based-shipping.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/value-based-shipping/value-based-shipping.info,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/value-based-shipping/value-based-shipping.info 12 Sep 2002 02:10:01 -0000 1.2
+++ openacs-4/packages/value-based-shipping/value-based-shipping.info 12 Sep 2002 20:11:05 -0000 1.3
@@ -21,6 +21,10 @@
<requires url="shipping-gateway" version="4.5b"/>
<files>
+ <file type="data_model_create" db_type="oracle" path="sql/oracle/value-based-shipping-create.sql"/>
+ <file type="data_model_drop" db_type="oracle" path="sql/oracle/value-based-shipping-drop.sql"/>
+ <file type="data_model" db_type="oracle" path="sql/oracle/value-based-shipping-sc-create.sql"/>
+ <file type="data_model" db_type="oracle" path="sql/oracle/value-based-shipping-sc-drop.sql"/>
<file type="data_model_create" db_type="postgresql" path="sql/postgresql/value-based-shipping-create.sql"/>
<file type="data_model_drop" db_type="postgresql" path="sql/postgresql/value-based-shipping-drop.sql"/>
<file type="data_model" db_type="postgresql" path="sql/postgresql/value-based-shipping-sc-create.sql"/>
@@ -40,12 +44,16 @@
<file type="content_page" path="www/admin/levels.adp"/>
<file type="content_page" path="www/admin/levels.tcl"/>
<file type="query_file" path="www/admin/levels.xql"/>
+ <file type="query_file" db_type="oracle" path="www/admin/rate-delete-oracle.xql"/>
+ <file type="query_file" db_type="postgresql" path="www/admin/rate-delete-postgresql.xql"/>
<file type="content_page" path="www/admin/rate-delete.adp"/>
<file type="content_page" path="www/admin/rate-delete.tcl"/>
<file type="query_file" path="www/admin/rate-delete.xql"/>
<file type="content_page" path="www/admin/rate-edit.adp"/>
<file type="content_page" path="www/admin/rate-edit.tcl"/>
<file type="query_file" path="www/admin/rate-edit.xql"/>
+ <file type="query_file" db_type="oracle" path="www/admin/rates-oracle.xql"/>
+ <file type="query_file" db_type="postgresql" path="www/admin/rates-postgresql.xql"/>
<file type="content_page" path="www/admin/rates.adp"/>
<file type="content_page" path="www/admin/rates.tcl"/>
<file type="query_file" path="www/admin/rates.xql"/>
Index: openacs-4/packages/value-based-shipping/www/admin/level-edit.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/value-based-shipping/www/admin/level-edit.tcl,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/value-based-shipping/www/admin/level-edit.tcl 12 Sep 2002 19:45:01 -0000 1.4
+++ openacs-4/packages/value-based-shipping/www/admin/level-edit.tcl 12 Sep 2002 20:11:09 -0000 1.5
@@ -54,7 +54,7 @@
# The request didn't include a service level ID.
- template::element::set_value level_edit service_level_id [db_nextval vbs_service_level_id_sequence]
+ template::element::set_value level_edit service_level_id [db_nextval vbs_service_level_id_seq]
} else {
Index: openacs-4/packages/value-based-shipping/www/admin/rate-delete.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/value-based-shipping/www/admin/rate-delete.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/value-based-shipping/www/admin/rate-delete.xql 21 May 2002 18:35:37 -0000 1.1
+++ openacs-4/packages/value-based-shipping/www/admin/rate-delete.xql 12 Sep 2002 20:11:09 -0000 1.2
@@ -18,15 +18,4 @@
</querytext>
</fullquery>
-
- <fullquery name="get_shipping_rate">
- <querytext>
- select l.service_level_description, c.default_name as country, round(r.from_value, 2) as from_value, round(r.to_value, 2) as to_value,
- r.from_zip_code, r.to_zip_code, round(r.shipping_rate, 2) as shipping_rate
- from vbs_rates r left join countries c on (r.country_iso = c.iso), vbs_service_levels l
- where r.shipping_rate_id = :shipping_rate_id
- and r.service_level_id = l.service_level_id
- </querytext>
- </fullquery>
-
</queryset>
Index: openacs-4/packages/value-based-shipping/www/admin/rate-edit.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/value-based-shipping/www/admin/rate-edit.tcl,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/value-based-shipping/www/admin/rate-edit.tcl 12 Sep 2002 19:45:01 -0000 1.3
+++ openacs-4/packages/value-based-shipping/www/admin/rate-edit.tcl 12 Sep 2002 20:11:09 -0000 1.4
@@ -116,7 +116,7 @@
# The request didn't include a shipping rate ID.
- template::element set_value rate_edit shipping_rate_id [db_nextval vbs_shipping_rate_id_sequence]
+ template::element set_value rate_edit shipping_rate_id [db_nextval vbs_shipping_rate_id_seq]
} else {
Index: openacs-4/packages/value-based-shipping/www/admin/rates.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/value-based-shipping/www/admin/rates.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/value-based-shipping/www/admin/rates.xql 16 Aug 2002 00:06:56 -0000 1.2
+++ openacs-4/packages/value-based-shipping/www/admin/rates.xql 12 Sep 2002 20:11:09 -0000 1.3
@@ -11,14 +11,4 @@
</querytext>
</fullquery>
- <fullquery name="get_shipping_rates">
- <querytext>
- select r.shipping_rate_id, l.service_level_description, c.default_name as country, round(r.from_value, 2) as from_value, round(r.to_value, 2) as to_value,
- r.from_zip_code, r.to_zip_code, round(r.shipping_rate, 2) as shipping_rate
- from vbs_rates r left join countries c on (r.country_iso = c.iso), vbs_service_levels l
- where r.service_level_id = l.service_level_id
- order by l.service_level_description, c.default_name, r.from_value, coalesce(r.to_value, 0), coalesce(r.from_zip_code, '0')
- </querytext>
- </fullquery>
-
</queryset>