package RPS::Import::FoundationMedia::v1;

use strict;
use warnings;

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

use parent qw/RPS::Import::MapFaceBase RPS::Import::ImporterMixed/;
use Date::Calc qw(Add_Delta_Days Days_in_Month);

sub physical { 0 }

sub _fieldMapExtended {
    my $self = shift;

    my %map = (
        1 => {
            digital => {
                option1 => {
                    labelName   => 'A',
                    serviceID   => 'L',
                    countryCode => 'N',
                    dateBegin   => 'B4',
                    dateEnd     => 'B4',
                    productType => 'E',
                    formatType  => 'O',
                    artistName  => 'C',
                    upc         => 'G',
                    isrc        => 'H',
                    units       => 'U',
                    price       => 'Z',
                },
            },
        },
        2 => {
            digital => {
                option1 => {
                    labelName   => 'A',
                    serviceID   => 'L',
                    countryCode => 'N',
                    dateBegin   => 'B4',
                    dateEnd     => 'B4',
                    productType => 'E',
                    formatType  => 'O',
                    artistName  => 'C',
                    upc         => 'G',
                    isrc        => 'H',
                    units       => 'V',
                    price       => 'AA',
                    mediaType   => 'E',
                },
            },
        },
    );

    return $map{ $self->_version };
}

sub _unverifiedFieldMapExtended {
    my $self = shift;

    my %map = (
        1 => {
            digital => {
                option1 => {
                    _release_title => 'D',
                    _release_type  => 'E',
                },
            },
        },
        2 => {
            digital => {
                option1 => {
                    _release_title => 'D',
                    _release_type  => 'E',
                },
            },
        },
    );

    return $map{ $self->_version };
}

sub _headerIdentifierExtended {
    my $self = shift;

    my %map = (
        1 => {
            digital => {
                option1 => {
                    upc => 'UPC',
                },
            },
        },
        2 => {
            digital => {
                option1 => {
                    upc => 'UPC',
                },
            },
        },
    );

    return $map{ $self->_version };
}

sub currencyCode { 'USD' }
sub mediaType    {
    my $self = shift;

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

    return RPS::DB::Item::MediaType::kMediaTypeAudio if $type =~ /^(?:album|track|ep|single)$/i;
    return RPS::DB::Item::MediaType::kMediaTypeVideo if $type =~ /^video$/i;

    $self->handleError( "Unknown media type: '$type'", RPS::DB::Item::SaleImportError::kErrorMediaType );
}

sub serviceID {
    my $self = shift;

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

    if ( $self->_version == 1 ) {
        $self->fail("Unable to determine service from: '$service'");
    }

    $self->handleError( "Unknown service: '$service'", RPS::DB::Item::SaleImportError::kErrorService );
}

sub saleDates {
    my $self = shift;

    return $self->_getDates( date_begin => $self->{_date_begin}, date_end => $self->{_date_end} );
}

sub countryCode {
    my $self = shift;

    my $country = $self->_getByFieldName('countryCode') || '';
    my $oCountry = Common::Country->Get($country);
    return $oCountry->alpha2 if $oCountry;

    if ( $self->_version == 1 ) {
        $self->fail("Unable to determine country code from: '$country'");
    }

    $self->handleError( "Unknown country: '$country'.", RPS::DB::Item::SaleImportError::kErrorCountry );
    return $country;
}

sub productType {
    my $self = shift;

    my $type = $self->_getByFieldName('productType') || '';
    return RPS::File::Sale::TYPE_TRACK if $type =~ /^(?:Track|Video)$/;
    return RPS::File::Sale::TYPE_ALBUM if $type =~ /^(?:Album|EP|Single)$/;

    if ( $self->_version == 1 ) {
        $self->fail("Unable to determine product type from: '$type'");
    }

    $self->handleError( "Unknown product type: '$type'", RPS::DB::Item::SaleImportError::kErrorProductType );
}

sub formatType {
    my $self = shift;

    my $type = $self->_getByFieldName('formatType') || '';
    return RPS::File::Sale::FORMAT_STREAM      if $type =~ /^Stream$/i;
    return RPS::File::Sale::FORMAT_DOWNLOAD    if $type =~ /^Download$/i;
    return RPS::File::Sale::FORMAT_PERFORMANCE if $type =~ /^Performance$/i;

    if ( $self->_version == 1 ) {
        $self->fail("Unable to determine format type from: '$type'");
    }

    $self->handleError( "Unknown format type: '$type'", RPS::DB::Item::SaleImportError::kErrorFormatType );
}

sub albumName {
    my $self = shift;

    my $rerleasType = $self->_getByFieldName('_release_type') || '';
    if ( $rerleasType =~ /^Album$/i ) {
        return $self->_getByFieldName('_release_title');
    }

    return;
}

sub trackName {
    my $self = shift;

    my $rerleasType = $self->_getByFieldName('_release_type') || '';
    if ( $rerleasType =~ /^Track$/i ) {
        return $self->_getByFieldName('_release_title');
    }

    return;
}

sub price     { sprintf( "%.8f", abs( shift->_getByFieldName('price') || 0 )) }
sub unitPrice { abs shift->SUPER::unitPrice }
sub units {
    my $self = shift;

    my $units = $self->_getByFieldName('units') || 0;
    my $price = $self->_getByFieldName('price') || 0;

    if ( $price > 0 ) {
        $units = $units ? abs($units) : 1;
    } elsif ( $price < 0 ) {
       $units = $units ? -1 * abs($units) : -1;
    }

    # math round
    $units += .00000001 if $units =~ /^\d+\.5\d*$/;
    $units = sprintf "%.0f", $units;

    return $units;
}

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

    my $sheetname = $self->{sheetname};
    # get sales period from the 'B4' cell on the 'Statement Summary' sheet
    if ( $sheetname =~ /^Statement Summary$/i ) {
        my $period = $sheet->[3][1];
        if ( $period =~ /Period: (\d{1,2})[-\/](\d{1,2})[-\/](\d{4}) - (\d{1,2})[-\/](\d{1,2})[-\/](\d{4})/i ) {
            $self->{_date_begin} = sprintf "%04d-%02d-%02d", $3, $1, $2;
            $self->{_date_end} = sprintf "%04d-%02d-%02d", $6, $4, $5;
        } else {
            $self->fail("Unable to determine sales period from '$period'");
        }
    }

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

sub _isValidSaleRecord {
    my $self = shift;

    my $labelName = $self->_getByFieldName('labelName') || '';
    return if $labelName =~ /^Totals$/i;
    return ($self->units || $self->price) && $self->_getByFieldName('productType');
}

# mapFace
sub _mapFaceServiceID   { 'serviceID' }
sub _mapFaceCountryCode { 'countryCode' }
sub _mapFaceFormatType  { 'formatType' }
sub _mapFaceProductType { 'productType' }
sub _mapFaceMediaType   { 'mediaType' }

1;