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