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.
###