From: levinse <levinse>
Date: Tue, 28 Dec 2010 20:14:19 +0000 (+0000)
Subject: add cust_pkg.order_date, RT6628
X-Git-Tag: freeside_2_3_0~807
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=d1da7fd0b1f1f15abf3552652e2607d39c934663

add cust_pkg.order_date, RT6628
---

diff --git a/FS/FS/cust_pkg.pm b/FS/FS/cust_pkg.pm
index d1c3f3bf8..324dbba43 100644
--- a/FS/FS/cust_pkg.pm
+++ b/FS/FS/cust_pkg.pm
@@ -3402,6 +3402,10 @@ sub _upgrade_data {  # class method
   'UPDATE cust_pkg SET bill = bill + (365*24*60*60) WHERE bill < last_bill
   AND bill > 1259654400 AND bill < 1262332800 AND (SELECT plan FROM part_pkg 
   WHERE part_pkg.pkgpart = cust_pkg.pkgpart) = \'prorate\'',
+    # RT6628, add order_date to cust_pkg
+    'update cust_pkg set order_date = (select history_date from h_cust_pkg 
+	where h_cust_pkg.pkgnum = cust_pkg.pkgnum and 
+	history_action = \'insert\') where order_date is null',
   );
   foreach my $sql (@statements) {
     my $sth = dbh->prepare($sql);