diff options
| author | Jonathan Prykop <jonathan@freeside.biz> | 2015-09-19 19:36:55 -0500 |
|---|---|---|
| committer | Jonathan Prykop <jonathan@freeside.biz> | 2015-09-19 21:46:54 -0500 |
| commit | 0f3af066f679296c0f4c563f6f8a850072f949f6 (patch) | |
| tree | 7774c561783f08fa970f5d6e0296c5818fa964d1 /httemplate/view | |
| parent | 64a2c644f1cb10cf1c37ef1941dc3406f21d94ed (diff) | |
RT#36813: Monthly Recurring Total [fixed order by]
Diffstat (limited to 'httemplate/view')
| -rw-r--r-- | httemplate/view/cust_main/billing.html | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/httemplate/view/cust_main/billing.html b/httemplate/view/cust_main/billing.html index f7ea68a65..0c9f74a7c 100644 --- a/httemplate/view/cust_main/billing.html +++ b/httemplate/view/cust_main/billing.html @@ -44,7 +44,7 @@ % 'hashref' => { 'custnum' => $cust_main->custnum, }, % 'extra_sql' => 'AND ( cancel IS NULL OR cancel = 0 ) % AND freq = '. dbh->quote($freq), -% 'order_by' => 'ORDER BY pkgnum', # to ensure old pkgs come before change_to_pkg +% 'order_by' => 'ORDER BY COALESCE(start_date,0), pkgnum', # to ensure old pkgs come before change_to_pkg % }) or next; % % my $freq_pretty = $cust_pkg[0]->part_pkg->freq_pretty; |