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