package RPS::Import::Estore;

use strict;

use Date::Calc qw(Days_in_Month Decode_Month);

use lib '/app/tools/common/lib';
use Common::Consts qw(%COUNTRY_TO_CODE);

use lib '/app/tools/data_classes/lib';

use lib '/app/tools/rps/lib';
use RPS::File::Sale;
use base 'RPS::Import::Importer';

use Client::Service;

my %field_map = (
    1 => {
        isrc  => 0,
        track => 1,
        price => 2,
        units => 3,
    },
);

#
# public methods
#

sub _importLines {
    my $self  = shift;
    my %args  = @_;
    my $lines = $args{lines};
    return undef unless ($lines);

    #my $version = $args{version}; # cmd-line testing
    #my $fileName = $args{OrigFileName}; # cmd-line testing
    my $version  = $args{file}->VersionNum();
    my $fileName = $args{file}->OrigFileName();

    my $format          = RPS::File::Sale::FORMAT_DOWNLOAD;
    my $linenum         = 1;
    my $was_album_title = 0;
    my ( %errors, $passed_format, $album, $total_columns, $fee_percentage );
    my $country       = "US";
    my $currency_code = "USD";
    my ( $dateBegin, $dateEnd ) = _get_dates($fileName);
    foreach my $line (@$lines) {
        my $isrc  = $line->[ $field_map{$version}{isrc} ];
        my $title = $line->[ $field_map{$version}{track} ];
        my $units = $line->[ $field_map{$version}{units} ];
        my $price = $line->[ $field_map{$version}{price} ];

        if ( ( $units ne "" && $price ne "" && $title ne "" && $title ne "PROD_NAME" ) ) {
            my $sale = RPS::Import::SaleRec->new();
            $sale->productType(RPS::File::Sale::TYPE_TRACK);
            $sale->trackName($title);
            $sale->formatType($format);
            $sale->dateBegin($dateBegin);
            $sale->dateEnd($dateEnd);
            $sale->isrc($isrc);
            $sale->price($price);
            $sale->units($units);

            #$sale->currencyCode($currency_code);
            $sale->countryCode($country);
            $sale->lineNum($linenum);

            #$args{dumper}($sale); ## for cmd-line testing
            $self->_insertSale( sale => $sale );
        }

        #else { print STDERR "skip line number: ". $linenum . " : " . join(',', @$line) . "\n"; }
        $linenum++;
    }
    return $linenum;
}

#
# Private methods
#

sub _get_dates {
    my $passed_date = shift;
    $passed_date =~ s/^.*_//;
    $passed_date =~ s/\.xls//;
    my ( $month, $year ) = split( " ", $passed_date );
    $year += 2000;
    return undef if ( !$month || !$year );
    return ( sprintf( "%04d-%02d-01", $year, Decode_Month($month) ),
        sprintf( "%04d-%02d-%02d", $year, Decode_Month($month), Days_in_Month( $year, Decode_Month($month) ) ) );
}

###
1;    # Play nicely.
###