#!/usr/bin/perl

use strict;
use vars qw( $opt_s $opt_e $opt_r $opt_u $opt_c );
use Getopt::Std;
use Date::Parse qw(str2time);
use Date::Format;
use FS::UID qw(adminsuidsetup dbh);
use FS::Record qw(qsearch qsearchs);
use FS::cust_pkg;
use FS::h_cust_pkg;

getopts('s:e:ruc');

my $user = shift or &usage;
adminsuidsetup $user;

my $sdate = $opt_s ? str2time($opt_s) : 0;
my $edate = $opt_e ? str2time($opt_e) + 86399 #not strictly correct on time zone boundary days, but good enough for this purpose
                   : 2147397248;

my $oldAutoCommit = $FS::UID::AutoCommit;
local $FS::UID::AutoCommit = 0;
my $dbh = dbh;

#my $fuzz = 2;

my $changed = 0;

foreach my $cust_pkg (
  qsearch({ table       => 'cust_pkg',
            hashref     => { 
                             setup          => '',
                           },
         })
) {

  my $h_cust_pkg =
    qsearchs({ table       => 'h_cust_pkg',
               hashref     => { 
                                pkgnum         => $cust_pkg->pkgnum,
                                setup          => { op=>'!=', value=>'' },
                                ($opt_u ? ('susp' => { op=>'!=', value=>'' })
                                        : ()
                                ),
                                ($opt_c ? ('cancel' => { op=>'!=', value=>'' })
                                        : ()
                                ),
                              },
               extra_sql   => " AND history_action IN ('insert','replace_old')".
                              ' AND history_date >= ? AND history_date <= ? ',
               extra_param => [ [$sdate,'int'], [$edate,'int'] ],
               order_by    => 'ORDER BY history_date DESC LIMIT 1',
            })
    or next;

  $changed++;

  #if ( $opt_r ) {
    #print "restoring setup for pkgnum ". $cust_pkg->pkgnum.
    #      " (custnum ". $cust_pkg->custnum.
    #      ") to ". time2str('%D', $h_cust_pkg->setup). "\n";
    print $cust_pkg->pkgnum. ','.
          time2str('%D', $h_cust_pkg->setup). ','.
          $cust_pkg->custnum. ','.
          '"'. $cust_pkg->cust_main->name. '"'. "\n";
  #}

  #don't actually do it yet ...
  #$cust_pkg->set('setup', $h_cust_pkg->setup);
  #my $error = $cust_pkg->replace;
  ##die $error if $error;
  #warn "error changing pkgnum ". $cust_pkg->pkgnum.': '. $error."\n";

}

if ( $opt_r ) {
  $dbh->rollback or die $dbh->errstr; #if $oldAutoCommit;
} else {
  $dbh->commit or die $dbh->errstr; #if $oldAutoCommit;
}

print "changed $changed packages\n";

sub usage {
  die "usage: cust_pkg-restore_setup [ -s history_start ] [ -e history_end ] [-r ]  employee_username\n";
}

=head1 NAME

cust_pkg-restore_setup

=head1 SYNOPSIS

  cust_pkg-restore_setup -d date -u history_username [ -r ] employee_username

=head1 DESCRIPTION

Command-line tool to restore removed setup dates.

-s: Start date of time period to restore changes from

-e: End date of time period to restore changes from

-u: sUspended packages only

-c: Cancelled packages only

-r: dRy run

employee_username

=head1 BUGS

=head1 SEE ALSO

L<FS::part_pkg>

=cut

1;