package RPS::Import::OrchardPub3;

use strict;

use lib '/app/tools/rps/lib';
use RPS::File::Sale;
use RPS::Import::ServiceMap;
use RPS::DB::Item::MediaType;

use base 'RPS::Import::OrchardPub2';

sub _fieldMap {
    my $self = shift;

    my %fieldMap =
    (
        18 => {
            dateBegin        => 'A',
            serviceID        => 'B',
            countryCode      => 'C',
            labelName        => 'M',
            artistName       => 'E',
            albumName        => 'F',
            trackName        => 'G', # or 'F' if blank
            upc              => 'D',
            isrc             => 'D',
            units            => 'I',
            price            => 'O',
            currencyCode     => 'D', # From "Label DS" tab
            formatType       => 'H', # Transaction Type
        },
    );

    return $fieldMap{$self->_version()};
}

sub currencyCode {
    return shift->{_currencyCode};  # see _preProcess
}

sub labelName {
    return shift->{_labelName};  # see _processSheet
}

sub productType {
    my $self = shift;
    my $code = $self->_getByFieldName('upc'); # this can be upc or isrc
    if( $code =~ /^\d/ )
    {
        return RPS::File::Sale::TYPE_ALBUM;
    }
    else
    {
        return RPS::File::Sale::TYPE_TRACK;
    }
}

sub albumName {
    my $self = shift;
    my $albumName = $self->_getByFieldName('albumName');
    return $albumName if( $self->productType() eq RPS::File::Sale::TYPE_ALBUM );
}

sub trackName {
    my $self = shift;

    if( $self->productType() eq RPS::File::Sale::TYPE_TRACK )
    {
        my $albumName = $self->_getByFieldName('albumName');
        my $trackName = $self->_getByFieldName('trackName');
        return ( $trackName =~ /^\s*$/ ) ? $albumName : $trackName;
    }
}

sub upc {
    my $self = shift;
    my $upc = $self->_getByFieldName('upc');
    return ( $self->productType() eq RPS::File::Sale::TYPE_ALBUM ) ? $upc : undef;
}

sub isrc {
    my $self = shift;
    my $isrc = $self->_getByFieldName('isrc');
    return ( $self->productType() eq RPS::File::Sale::TYPE_TRACK ) ? $isrc : undef;
}

sub _preProcess {
    my $self = shift;
    my %args = @_;

    # Get the currency code information from the 'Label DS' tab
    #
    my $sheetNames = $args{sheet_names};

    my $sheetCount = 0;
    SHEET: foreach my $sheet(@{ $args{sheets} })
    {
        my $sheetName = $sheetNames->[$sheetCount];

        next if( $sheetName !~ /^label ds$/i );

        foreach my $line (@$sheet)
        {
            $self->{line} = $line;
            my $ccode = $self->_getByFieldName('currencyCode');

            if( $ccode =~ /^US Dollars \$/i )
            {
                $self->{_currencyCode} = 'USD';
                last;
            }
        }

        $sheetCount++;
    }

}

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

    # Skip the summary sheet
    #
    if( $self->sheetname =~ /^digital sales$/i )
    {
        $self->{_labelName} = '';
        foreach my $line (@$sheet)
        {
            $self->{line} = $line;

            my $label = $self->_getByFieldName('labelName');
            if( $label )
            {
                $self->{_labelName} = $label;
                last;
            }
        }

        return $self->SUPER::_processSheet( $sheet, $sheetnum );
    }
}

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