alpha sort packages in new package order SELECT (ticket 1446)

[freeside.git] / httemplate / view / cust_main / order_pkg.html

diff --git a/httemplate/view/cust_main/order_pkg.html b/httemplate/view/cust_main/order_pkg.html
index 6edd18c..f48bf09 100644 (file)
--- a/httemplate/view/cust_main/order_pkg.html
+++ b/httemplate/view/cust_main/order_pkg.html
@@ -23,7 +23,8 @@ function enable_order_pkg () {
 %  qsearch( 'part_pkg', { 'disabled' => '' }, '',
 %           ' AND 0 < ( SELECT COUNT(*) FROM type_pkgs '.
 %           '             WHERE typenum = '. $cust_main->agent->typenum.
-%           '             AND type_pkgs.pkgpart = part_pkg.pkgpart )'
+%           '             AND type_pkgs.pkgpart = part_pkg.pkgpart )'.
+%           ' ORDER BY pkg'   # case ?
 %         )
 %) {
 %