package RPS::Import::VirginMega;

use strict;


use Date::Calc qw(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 FIELD_DATE	    => 2;
use constant FIELD_RETAILER => 4;
use constant FIELD_UPC_ISRC => 5;
use constant FIELD_ARTIST   => 6;
use constant FIELD_TITLE    => 7;
use constant FIELD_UNITS    => 8;
use constant FIELD_CSTMRPRC => 9;
use constant FIELD_DLRPRICE => 11;
use constant FIELD_CURRENCY => 12;
use constant FIELD_SUBTOTAL => 14;

my %product_map = (
    '099'   => RPS::File::Sale::TYPE_TRACK,
    99      => RPS::File::Sale::TYPE_TRACK,
    186     => RPS::File::Sale::TYPE_TRACK,
    200     => RPS::File::Sale::TYPE_TRACK,
    2       => RPS::File::Sale::TYPE_TRACK,
    300     => RPS::File::Sale::TYPE_TRACK,
    3       => RPS::File::Sale::TYPE_TRACK,
    999     => RPS::File::Sale::TYPE_ALBUM,
    1499    => RPS::File::Sale::TYPE_ALBUM,
    1998    => RPS::File::Sale::TYPE_ALBUM,
);

#public methods

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

	my $lines = $args{lines};
    my $version = $self->_version;

    return undef unless ($lines);

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

	my $linenum = 1;
	foreach my $line (@$lines) {
        if ($line->[FIELD_DATE] =~ m/date of record/i ||
            $line->[FIELD_DATE] =~ m/period/i ||
            $line->[FIELD_DATE] =~ m/total royalties/i ||
            $line->[FIELD_DATE] =~ m/^\s*$/) {
            $linenum++;
            next;
        }

        my ($dateBegin, $dateEnd) = $self->_getDates($line->[FIELD_DATE]);

        my ($country,$track_num,$isrc,$upc);
        if ($line->[FIELD_RETAILER] eq "www.virginmega.fr") {
            $country = "FR";
        } else {
            $self->errstr("unknown retailer: ".$line->[FIELD_RETAILER]);
            return undef
        }

        my $prodcode = $line->[FIELD_UPC_ISRC];
        my $prodtype;
        if ($prodcode =~ m/\-(\d+)\_(\d+)$/) {  ## upc/ean
            #$prodtype   = RPS::File::Sale::TYPE_TRACK;
            $track_num  = $2;
            $upc        = $prodcode;
            $upc        =~ s/\-(\d+)\_(\d+)$//;
        } else {  ## isrc
            #$prodtype   = RPS::File::Sale::TYPE_ALBUM;
        }

		my $artist     = $line->[FIELD_ARTIST];
		my $title      = $line->[FIELD_TITLE];
		my ($currency) = $line->[FIELD_CURRENCY] =~ m/^([A-Z]{3})$/;
		my ($units)    = $line->[FIELD_UNITS] =~ m/^(-?\d+)$/;
        my $price;
        if ($version == 1) {
		    ($price) = $line->[FIELD_DLRPRICE] =~ m/^(\d*[\.,]?\d*)$/;
        } elsif ($version == 2) {
		    ($price) = $line->[FIELD_SUBTOTAL] =~ m/^(-?\d*[\.,]?\d*)$/;
        }

        $price =~ s/,/\./g;

        if ($version == 2) {
            $price = ($units != 0)?($price/$units):0;
        }
        $prodtype = RPS::File::Sale::TYPE_ALBUM;
        if ($line->[FIELD_CSTMRPRC] ne "") {
            my $end_user_price = $line->[FIELD_CSTMRPRC];
            #$end_user_price =~ s/(\.?\,)//g;
            #$prodtype = $product_map{$end_user_price} if($product_map{$end_user_price} ne "");
            $end_user_price =~ s/\,/\./g;
            $prodtype = RPS::File::Sale::TYPE_TRACK if ($end_user_price <= 3);
        }


		if ($units && $price && $title !~ /Product Title/ && $country && $currency)
		{
            unless ($dateBegin && $dateEnd) {
                $self->errstr("can't get dates");
                print STDERR $line->[FIELD_DATE] . "\n";
                return undef;
            }


			my $sale = RPS::Import::SaleRec->new();

			$sale->productType($prodtype);
			$sale->formatType($format);
			$sale->dateBegin($dateBegin);
			$sale->dateEnd($dateEnd);
            $sale->trackNum($track_num) if($prodtype eq RPS::File::Sale::TYPE_TRACK);
            $sale->upc($upc) if($upc);
            $sale->serviceProductID($prodcode);
			$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);

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

	return $linenum;
}

sub _getDates {
    my $self = shift;
    my $date = shift;

    if ($date =~ m/^(\d\d\d\d)(\d\d)\d\d$/) {
        my $dateBegin = sprintf("%04d-%02d-%02d", $1, $2, 1);
        my $dateEnd   = sprintf("%04d-%02d-%02d", $1, $2, Days_in_Month($1,$2));
        return ($dateBegin, $dateEnd);
    }
    return undef;
}


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