#---------------------------------------------------------------
# ____                   _ _         ____  _
#|  _ \ ___  _   _  __ _| | |_ _   _/ ___|| |__   __ _ _ __ ___
#| |_) / _ \| | | |/ _` | | __| | | \___ \| '_ \ / _` | '__/ _ \
#|  _ < (_) | |_| | (_| | | |_| |_| |___) | | | | (_| | | |  __/
#|_| \_\___/ \__, |\__,_|_|\__|\__, |____/|_| |_|\__,_|_|  \___|
#            |___/             |___/
#
# Copyright (C) 2013 RoyaltyShare, Inc.   All Rights Reserved
#---------------------------------------------------------------

package RPS::Import::Fuga::v2;

use strict;

use lib '/app/tools/common/lib';
use Common::Assert;

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

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

sub _fieldMap {
    my $self = shift;
    my %field_map = (
        2 => {
            labelName        => 'I',
            serviceID        => 'G',
            countryCode      => 'N',
            dateBegin        => 'A',
            dateEnd          => 'B',
            productType      => 'M',
            formatType       => 'O',
            artistName       => 'J',
            upc              => 'L',
            albumName        => 'K',
            isrc             => 'M',
            trackName        => 'K',
            units            => 'Q',
            price            => 'AD',
        },
        3 => {
            labelName        => 'I',
            serviceID        => 'G',
            countryCode      => 'N',
            dateBegin        => 'A',
            dateEnd          => 'B',
            productType      => 'M',
            formatType       => 'O',
            artistName       => 'J',
            upc              => 'L',
            albumName        => 'K',
            isrc             => 'M',
            trackName        => 'K',
            units            => 'Q',
            price            => 'Y',
        },
    );
    return $field_map{$self->_version};
}

sub _headerIdentifier { ( upc => 'UPCCode' ) }

sub currencyCode { 'EUR' }

sub mediaType { RPS::DB::Item::MediaType::kMediaTypeAudio }

sub productType {
    my $self = shift;
    my $productType = $self->_getByFieldName( 'productType' );

    if( !$productType || $productType eq '' )
    {
        return RPS::File::Sale::TYPE_ALBUM;
    } 
    else
    {
        return RPS::File::Sale::TYPE_TRACK;
    } 
}

sub formatType  {
    my $self = shift;
    my $fmt = $self->_getByFieldName( 'formatType' );
    if( $fmt =~ /^download$/i )
    {
        return RPS::File::Sale::FORMAT_DOWNLOAD;
    }
    elsif( $fmt =~ /^streaming$/i )
    {
        return RPS::File::Sale::FORMAT_STREAM;
    }
    $self->fail("Unrecognized format '$fmt'");
}

sub albumName {
    my $self = shift;
    my $name = $self->_getByFieldName( 'albumName' );

    return $name if( $self->productType eq RPS::File::Sale::TYPE_ALBUM );
}

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

sub saleDates {
    my $self = shift;

    my $dateBegin;
    my $dateEnd;

    my $startDate = $self->_getDateBegin();
    my $endDate   = $self->_getDateEnd();

    if( $startDate && $endDate )
    {
        ($dateBegin,$dateEnd) = $self->_getDates( date_begin => $startDate, date_end => $endDate  );
    }

    return ($dateBegin, $dateEnd);
}

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( "Unknown service '$service'" );
}

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

    # Process only if this is not an Excel file (e.g. text) or if there's a sheet named 'details' ...
    #
    if( $self->filename !~ /\.xls/  ||  $self->{sheetname} =~ /^details$/i )
    {
        return $self->SUPER::_processSheet( $sheet, $sheetnum );
    }
    #else { print STDERR "Skipping sheet '". $self->{sheetname} . "'\n"; }
}

sub units {
    my $self = shift;
    my $units = $self->SUPER::units() || return;
    my $price = $self->SUPER::price();

    # The 'sign' of the units is driven by the price.
    # If the price is negative, we'll store negative units,
    # regardless of whether the units were positive or negative
    # in the sale file.  Accordingly, the price is always
    # positive.  This ensures that returns are recorded correctly.
    #
    if( defined($price) )
    {
        return $price < 0 ? abs($units) * -1 : $units;
    }
    else
    {
        return $units;
    }
}

sub unitPrice {
    return abs( shift->SUPER::unitPrice() );
}

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