#---------------------------------------------------------------
# ____                   _ _         ____  _
#|  _ \ ___  _   _  __ _| | |_ _   _/ ___|| |__   __ _ _ __ ___
#| |_) / _ \| | | |/ _` | | __| | | \___ \| '_ \ / _` | '__/ _ \
#|  _ < (_) | |_| | (_| | | |_| |_| |___) | | | | (_| | | |  __/
#|_| \_\___/ \__, |\__,_|_|\__|\__, |____/|_| |_|\__,_|_|  \___|
#            |___/             |___/
#
# 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.
###