package RPS::Import::FontanaDigital;

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';

my %field_map = (
    1 => {
        format              => 1,
        service             => 2,
        sale_unit           => 4,
        album_artist        => 5,
        album               => 6,
        track_artist        => 7,
        track               => 8,
        isrc                => 10,
        units               => 11,
        combined_revenue    => 12,
    },
    2 => {
        format              => 2,
        service             => 3,
        sale_unit           => 4,
        album_artist        => 6,
        album               => 7,
        track_artist        => 8,
        track               => 9,
        isrc                => 10,
        units               => 12,
        combined_revenue    => 13,
    },
);

my %delivery_formats = (
    'AD SUPPORTED STREAMS'              => RPS::File::Sale::FORMAT_STREAM,
    'KIOSK'                             => RPS::File::Sale::FORMAT_DOWNLOAD,
    'OTA PERMANENT DOWNLOADS'           => RPS::File::Sale::FORMAT_DOWNLOAD,
    'PERMANENT DOWNLOADS'               => RPS::File::Sale::FORMAT_DOWNLOAD,
    'PORTABLE SUB CLIENT PLAYS'         => RPS::File::Sale::FORMAT_STREAM,
    'PORTABLE SUB STREAMS'              => RPS::File::Sale::FORMAT_STREAM,
    'PORTABLE SUB DEVICE PLAYS'         => RPS::File::Sale::FORMAT_STREAM,
    'PROGRAMMED STREAMING'              => RPS::File::Sale::FORMAT_STREAM,
    'STREAMS'                           => RPS::File::Sale::FORMAT_STREAM,
    'TETHERED/CONDITIONAL DOWNLOADS'    => RPS::File::Sale::FORMAT_TETHERED,
    'VIDEO DOWNLOADS'                   => RPS::File::Sale::FORMAT_DOWNLOAD,
    'RINGBACKS'                         => RPS::File::Sale::FORMAT_RINGBACK,
    'STANDARD MOBILE RINGSOUNDS'        => RPS::File::Sale::FORMAT_RINGTONE,
    'SUBSCRIPTION MASTERTONES'          => RPS::File::Sale::FORMAT_RINGTONE, # was FORMAT_MASTERTONE (FB1324)
    'VIDEO STREAMS'                     => RPS::File::Sale::FORMAT_STREAM, # was FORMAT_VIDEOSTREAM (FB1324)
    'USER GENERATED STREAMS'            => RPS::File::Sale::FORMAT_STREAM, # was FORMAT_VIDEOSTREAM (FB1324)
);

my %service_map = (
    'apple digital sales'       => Client::Service::DSP_ITUNES,
    'listen/rhapsody'           => Client::Service::DSP_REAL,
    'full audio/musicnow'       => Client::Service::DSP_MUSICNOW,
);

#
# 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,$dateBegin,$dateEnd,$total_columns,$fee_percentage);
    my $country = "US";
    foreach my $line (@$lines)
    {
        my $artist      = $line->[$field_map{$version}{track_artist}];
        $artist         = $line->[$field_map{$version}{album_artist}] if ($line->[$field_map{$version}{track_artist}] eq "");
        my $isrc        = $line->[$field_map{$version}{isrc}];
        my $title       = $line->[$field_map{$version}{track}];
        my $album       = $line->[$field_map{$version}{album}];
        my $units       = $line->[$field_map{$version}{units}];
        my $price       = $line->[$field_map{$version}{combined_revenue}]/$units if ($units!=0);
        my $raw_format  = uc $line->[$field_map{$version}{format}];
        $raw_format     =~ s/\s\(.*\)//;
        my $format      = $delivery_formats{$raw_format}; 

        my $mediaType;
        if( $raw_format =~ /^VIDEO DOWNLOADS$/i ||
            $raw_format =~ /^VIDEO STREAMS$/i ||
            $raw_format =~ /^USER GENERATED STREAMS$/i )
        {
            $mediaType  = RPS::DB::Item::MediaType::kMediaTypeVideo;
        }
        else
        {
            $mediaType  = RPS::DB::Item::MediaType::kMediaTypeVideo;
        }

        my $serviceName = lc $line->[$field_map{$version}{service}];
        $serviceName =~ s/\s\(.*$//;
        my $serviceID   = $self->getServiceID($serviceName)|| $service_map{$serviceName};;
        $price          *= -1 if ($price<0);
        
        if(($artist ne "" && $units ne "" && $price ne "")) {
            unless ($format ne "") {
                $self->errstr("Unrecognized format: ". $line->[$field_map{$version}{format}]);
                print STDERR "Unrecognized format: ". $line->[$field_map{$version}{format}]. "\n";
                return undef;
            }

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

            my ($dateBegin,$dateEnd) = _get_dates($fileName);
            $sale->productType(RPS::File::Sale::TYPE_TRACK) if ($isrc ne "");
            $sale->productType(RPS::File::Sale::TYPE_ALBUM) if ($isrc eq "");
            $sale->isrc($isrc) if ($isrc ne "");
            $sale->trackName($title) if ($title ne "");
            $sale->albumName($album) if ($album ne "");
            $sale->serviceID($serviceID);
            $sale->formatType($format);
            $sale->dateBegin($dateBegin);
            $sale->dateEnd($dateEnd);
            $sale->artistName($artist);
            $sale->price($price);
            $sale->units($units);
            $sale->mediaType($mediaType);
            $sale->currencyCode('USD'); 
            $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/^.*Sales\s//;
    $passed_date =~ s/\.xls//;
    my $month = substr($passed_date,0,2);
    my $year = substr($passed_date,2,4);
    $year += 2000;
    return undef if (!$month||!$year);
    return (
        sprintf("%04d-%02d-01", $year, $month), 
        sprintf("%04d-%02d-%02d", $year, $month, Days_in_Month($year, $month))
    );
}

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