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