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

package RPS::Import::Integra::v7;

use strict;

use Date::Calc qw(Days_in_Month Decode_Month);

use Carp qw(croak);

use lib '/app/tools/common/lib';
use Common::Assert;
use Common::Util qw(normalize_date);

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

use base 'RPS::Import::Integra::v6';

sub _fieldMap {
    {
        productType => 'A',
        labelName   => 'G',
        artistName  => 'H',
        albumName   => 'I',
        isrc        => 'K',
        upc         => 'K',
        trackName   => 'J',
        units       => 'M',
        price       => 'P',
    };
}

sub _unverifiedFieldMap {
    { credits => 'O', };
}

sub saleDates {
    my $self = shift;

    # from filename; see _preProcess
    return ( $self->{_startDate}, $self->{_endDate} ) if ( $self->{_startDate} );
}

sub units {
    my $self    = shift;
    my $count   = $self->_getByFieldName('units');
    my $credits = $self->_getByFieldName('credits');
    return $count + $credits;
}

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

    if ( $self->{sheetname} =~ /^(dist report)$/i ) {

        # Get the date information from the filename
        #
        ( $self->{_startDate}, $self->{_endDate} ) = _getDates( $self->{filename} );

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

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

sub _getDates {
    my $filename = shift;

    return undef unless ( $filename =~ m/(\d{2})-(\d{2})-(\d{2})/ );
    my ( $year, $month, $day ) = ( $1, $2, $3 );
    $year += 2000;

    my ( $dateBegin, $dateEnd, $lastDay );
    $lastDay = Days_in_Month( $year, $month );
    $dateBegin = sprintf( "%04d-%02d-%02d", $year, $month, "1" );
    $dateEnd   = sprintf( "%04d-%02d-%02d", $year, $month, $lastDay );

    print STDERR "In _getDates dateBegin: " . $dateBegin . "\n";
    print STDERR "In _getDates dateEnd: " . $dateEnd . "\n";
    return ( $dateBegin, $dateEnd );
}

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