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

package RPS::Import::Orange::v1;

use strict;

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

use lib '/app/tools/rps/lib';
use base 'RPS::Import::Importer';

# Orange has three sheets that need to be processed, fortunately
# the columns of interest on those sheets are all in same location.
#
sub _fieldMap {
    {
        labelName    => 'U',
        dateBegin    => 'E',
        dateEnd      => 'F',
        productType  => 'J',
        formatType   => 'G',
        artistName   => 'N',
        upc          => 'K',
        isrc         => 'L',
        trackName    => 'O',
        albumName    => 'O',
        price        => 'W',
        units        => 'P',
        currencyCode => 'T',
        countryCode  => 'C',
    };
}

sub _headerIdentifier { ( dateBegin => 'initial date' ) }

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, type => 'eur' );
    }

    return ( $dateBegin, $dateEnd );
}

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

    if ( $type =~ /^a$/i ) {
        return RPS::File::Sale::TYPE_ALBUM;
    } elsif ( $type =~ /^s$/i ) {
        return RPS::File::Sale::TYPE_TRACK;
    } else {
        $self->fail("Could not parse product type from '$type'");
    }
}

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 formatType {
    return RPS::File::Sale::FORMAT_DOWNLOAD;
}

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

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

    if ( $self->{sheetname} =~
        /^(mobile_fichier_detail_singles|mobile_fichier_detail_albums|internet_fichier_detail_singles|internet_fichier_detail_albums)$/i ) {
        return $self->SUPER::_processSheet( $sheet, $sheetnum );
    }

    #else { print STDERR "Skipping sheet '". $self->{sheetname} . "'\n"; }
}

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