From 2f7205c859dd4d36aaa86c11e98ec1b48f4cc34b Mon Sep 17 00:00:00 2001 From: jeff Date: Mon, 12 Feb 2007 17:56:52 +0000 Subject: alpha sort packages in new package order SELECT (ticket 1446) --- httemplate/view/cust_main/order_pkg.html | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'httemplate') diff --git a/httemplate/view/cust_main/order_pkg.html b/httemplate/view/cust_main/order_pkg.html index 6edd18c05..f48bf0929 100644 --- 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 ? % ) %) { % -- cgit v1.2.1