package RPS::Import::SonyConnectEur;

use strict;

use Date::Calc qw(Decode_Month Days_in_Month);

use lib '/app/tools/common/lib';
use Common::Util;
use Common::Consts;

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

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

#private constants
use constant DATEBEGIN_ROW => 2;
use constant DATEBEGIN_COL => 3;
use constant DATEEND_ROW   => 2;
use constant DATEEND_COL   => 4;

use constant FIELD_COUNTRY  => 1;
use constant FIELD_ISRC_UPC => 2;
use constant FIELD_VENDORID => 3;
use constant FIELD_TITLE    => 4;
use constant FIELD_ARTIST   => 5;
use constant FIELD_PRICE    => 7;
use constant FIELD_UNITS    => 8;
use constant FIELD_CURRENCY => 10;

#public methods

sub _importLines {
    my $self  = shift;
    my %args  = @_;
    my $lines = $args{lines};

    return undef unless ($lines);

    my $prodtype = RPS::File::Sale::TYPE_TRACK;
    my $format   = RPS::File::Sale::FORMAT_DOWNLOAD;

    my ( $dateBegin, $dateEnd ) = $self->_getDates( $lines->[DATEBEGIN_ROW]->[DATEBEGIN_COL], $lines->[DATEEND_ROW]->[DATEEND_COL] );

    unless ( $dateBegin && $dateEnd ) {
        $self->errstr( "can't get dates from " . $lines->[DATEBEGIN_ROW]->[DATEBEGIN_COL] . " , " . $lines->[DATEEND_ROW]->[DATEEND_COL] );
        return undef;
    }

    my $linenum = 1;
    foreach my $line (@$lines) {
        if ( $line->[0] =~ m/^bundles \(albums\)$/i ) {
            $prodtype = RPS::File::Sale::TYPE_ALBUM;
            next;
        }

        my ( $isrc, $upc );
        if ( $prodtype eq RPS::File::Sale::TYPE_ALBUM ) {
            $upc = Common::Util::normalize_upc( $line->[FIELD_ISRC_UPC] );
        } elsif ( $prodtype eq RPS::File::Sale::TYPE_TRACK ) {
            $isrc = Common::Util::normalize_isrc( $line->[FIELD_ISRC_UPC] );
        }
        my $artist     = $line->[FIELD_ARTIST];
        my $title      = $line->[FIELD_TITLE];
        my $vendorid   = $line->[FIELD_VENDORID];
        my ($country)  = $line->[FIELD_COUNTRY] =~ m/^([A-Z]{2})$/;
        my ($currency) = $line->[FIELD_CURRENCY] =~ m/^([A-Z]{3})$/;
        my ($units)    = $line->[FIELD_UNITS] =~ m/^(-?\d+)$/;
        my ($price)    = $line->[FIELD_PRICE] =~ m/^(\d*\.?\d*)$/;
        if ( $units && $price && $title && $country && $currency ) {
            my $sale = RPS::Import::SaleRec->new();

            $sale->productType($prodtype);
            $sale->formatType($format);
            $sale->dateBegin($dateBegin);
            $sale->dateEnd($dateEnd);
            $sale->serviceProductID($vendorid);
            $sale->upc($upc)   if ( $prodtype eq RPS::File::Sale::TYPE_ALBUM );
            $sale->isrc($isrc) if ( $prodtype eq RPS::File::Sale::TYPE_TRACK );
            $sale->artistName($artist);
            $sale->albumName($title) if ( $prodtype eq RPS::File::Sale::TYPE_ALBUM );
            $sale->trackName($title) if ( $prodtype eq RPS::File::Sale::TYPE_TRACK );
            $sale->units($units);
            $sale->price($price);
            $sale->countryCode($country);
            $sale->currencyCode($currency);
            $sale->lineNum($linenum);

            #$args{dumper}($sale);
            $self->_insertSale( sale => $sale );
        }    #else { print STDERR "skip ($linenum) u: $units p: $price t: $title c: $country \$: $currency\n"; }
        $linenum++;
    }

    return $linenum;
}

sub _getDates {
    my $self  = shift;
    my $date1 = shift;
    my $date2 = shift;

    if ( $date1 =~ m/^\d{8}$/ && $date2 =~ m/^\d{8}$/ ) {
        $date1 =~ s/^(\d\d\d\d)(\d\d)(\d\d)$/$1-$2-$3/;
        $date2 =~ s/^(\d\d\d\d)(\d\d)(\d\d)$/$1-$2-$3/;
        return ( $date1, $date2 );
    }
    return undef;
}

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