package RPS::Import::RXMusic::v1;

use strict;

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

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

sub _fieldMap {
    {
            serviceID        => 'C',
            countryCode      => 'D',
            dateBegin        => 'A',
            dateEnd          => 'B',
            serviceProductID => 'E',
            artistName       => 'K',
            isrc             => 'F',
            trackName        => 'L',
            units            => 'H',
            price            => 'J',
            mediaType        => 'G',
    }
}

sub _headerIdentifier { ( dateBegin => 'Sales Period Start Date' ) }

sub _processSheet {
    my ($self, $sheet, $sheetnum) = @_;

    return $self->SUPER::_processSheet( $sheet, $sheetnum ) if ( $self->{sheetname} !~ /^Financials$/i );
}

sub productType  { RPS::File::Sale::TYPE_TRACK }
sub formatType   { RPS::File::Sale::FORMAT_BACKGROUNDMUSIC }
sub currencyCode { 'USD' }

sub serviceID {
    my $self = shift;
    my $service = $self->_getByFieldName('serviceID') || "";

    my $serviceID = $self->getServiceID( lc($service) ) || $RPS::Import::ServiceMap::SERVICE_ALIASES{ lc $service };
    return $serviceID if $serviceID;

    $self->fail("Unable to determine service id from '$service'");
}

sub countryCode {
    my $self  = shift;
    my $country = $self->_getByFieldName('countryCode');
    my $code       = Common::Country->Get($country);
    return ( defined $code ) ? $code->alpha2() : $country;
}

sub saleDates {
    my $self = shift;

    my $dateBegin = $self->_getByFieldName('dateBegin');
    my $dateEnd = $self->_getByFieldName('dateEnd');
    my ($startDate, $endDate);

    if ( $dateBegin =~ /^(\d{1,2})\/(\d{1,2})\/(\d{4}).*$/ )    # MM/DD/YYYY
    {
        my $year  = $3;
        my $month = $1;
        my $day   = $2;
        $startDate = sprintf( "%04d-%02d-%02d", $year, $month, $day );
    }

    if ( $dateEnd =~ /^(\d{1,2})\/(\d{1,2})\/(\d{4}).*$/ )    # MM/DD/YYYY
    {
        my $year  = $3;
        my $month = $1;
        my $day   = $2;
        $endDate = sprintf( "%04d-%02d-%02d", $year, $month, $day );
    }

    return ( $startDate, $endDate );
}


sub mediaType {
    my $self = shift;

    my $mediaType = $self->_getByFieldName('mediaType') || '';

    return RPS::DB::Item::MediaType::kMediaTypeAudio if $mediaType =~ /^audio$/i;
    return RPS::DB::Item::MediaType::kMediaTypeVideo if $mediaType =~ /^video$/i;

    $self->fail("Unable to determine media type from '$mediaType'");
}

1;                                                                          #