Index: openacs-4/packages/value-based-shipping/www/admin/rates.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/value-based-shipping/www/admin/rates.adp,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/value-based-shipping/www/admin/rates.adp 21 May 2002 18:35:37 -0000 1.1
+++ openacs-4/packages/value-based-shipping/www/admin/rates.adp 16 Aug 2002 00:06:56 -0000 1.2
@@ -55,8 +55,8 @@
@shipping_rates.to_zip_code@ |
@shipping_rates.shipping_rate@ |
|
- [ edit ] |
- [ delete ] |
+ [ edit ] |
+ [ delete ] |
Index: openacs-4/packages/value-based-shipping/www/admin/rates.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/value-based-shipping/www/admin/rates.tcl,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/value-based-shipping/www/admin/rates.tcl 21 May 2002 18:35:37 -0000 1.1
+++ openacs-4/packages/value-based-shipping/www/admin/rates.tcl 16 Aug 2002 00:06:56 -0000 1.2
@@ -51,4 +51,4 @@
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"
+ order by l.service_level_description, c.default_name, r.from_value, coalesce(r.to_value, 0), coalesce(r.from_zip_code, '0')"
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.1 -r1.2
--- openacs-4/packages/value-based-shipping/www/admin/rates.xql 21 May 2002 18:35:37 -0000 1.1
+++ openacs-4/packages/value-based-shipping/www/admin/rates.xql 16 Aug 2002 00:06:56 -0000 1.2
@@ -17,7 +17,7 @@
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
+ order by l.service_level_description, c.default_name, r.from_value, coalesce(r.to_value, 0), coalesce(r.from_zip_code, '0')