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