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