package RPS::Import::AMI::v9;

use strict;

use Data::Dumper;

use lib '/app/tools/common/lib';
use Common::Date;
use Common::Country;

use lib '/app/tools/rps/lib';

use base 'RPS::Import::Importer';

sub _headerIdentifier { ( upc => 'upc' ) }

sub _fieldMap {
    {
        countryCode      => 'D',
        dateBegin        => 'A',
        productType      => 'B',
        artistName       => 'H',
        upc              => 'E',
        albumName        => 'G',
        trackName        => 'G',
        isrc             => 'F',
        units            => 'I',
        price            => 'J',
    }
}

sub currencyCode { 'USD' }

sub mediaType { RPS::DB::Item::MediaType::kMediaTypeAudio; }

sub productType {
    my $self = shift;
    my $_productType = $self->_getByFieldName( 'productType' ) || return;

    if( $_productType =~ /^track$/i )
    {
        return RPS::File::Sale::TYPE_TRACK;
    }

    elsif( $_productType =~ /^playlist$/i )
    {
        return RPS::File::Sale::TYPE_ALBUM;
    }

    $self->fail("Unknown product type '$_productType'");
}

sub formatType {
    my $self = shift;
    return $self->{_formatType} if( $self->{_formatType} );

    $self->fail("Format not found");
}

sub saleDates {
    my $self = shift;
    my $dateBegin;
    my $dateEnd;

    my $startDate = $self->_getDateBegin();
    if( $startDate && $startDate =~ /(\d{4})(\d{1,2})/ ) # YYYYMM
    {
        my $dt = sprintf( "%04d-%02d-01", $1, $2 );
        ($dateBegin, $dateEnd) = $self->_getDates( date_begin => $dt );
    }
    return( $dateBegin, $dateEnd );
}

sub trackName {
    my $self = shift;
    return $self->productType eq RPS::File::Sale::TYPE_ALBUM ? undef : $self->SUPER::trackName;
}

sub albumName {
    my $self = shift;
    return $self->productType eq RPS::File::Sale::TYPE_TRACK ? undef : $self->SUPER::albumName;
}

sub _processSheet {
    my $self     = shift;
    my $sheet    = shift;
    my $sheetnum = shift;

    my %args = @_;

    if( $self->{sheetname} =~ /^sommaire$/i )
    {
        my $typeCell = $sheet->[0][0]; # A1
        if( $typeCell =~ /^select digital \(download\)$/i )
        {
            $self->{_formatType} = RPS::File::Sale::FORMAT_DOWNLOAD;
        }
        elsif( $typeCell =~ /^select digital \(streaming\)$/i )
        {
            $self->{_formatType} = RPS::File::Sale::FORMAT_STREAM;
        }
    }
    elsif( $self->{sheetname} =~ /^detail$/i )
    {
        return $self->SUPER::_processSheet( $sheet, $sheetnum );
    }
    #else { print STDERR "Skipping sheet '". $self->{sheetname} . "'\n"; }
}

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