package RPS::Import::AMIEStreet;

use strict;

use Date::Calc qw(Days_in_Month);

use lib '/app/tools/common/lib';
use Common::Consts qw(%COUNTRY_TO_CODE);
use Common::Log;

use lib '/app/tools/data_classes/lib';

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

use constant FIELD_TITLE    => 0;

#
# public methods
#

sub _importLines
{
    my $self = shift;
    my %args = @_;
    my $sheet = $args{sheets};
    my $version = $args{file}->VersionNum();
    my $fileName = $args{file}->OrigFileName();
    my $lines = $sheet->[0] if($version == 1);
    my $lines = $sheet->[1] if($version == 4);
    return undef unless ($lines);
    my $format = RPS::File::Sale::FORMAT_VPD;
    my $linenum = 1;
    my $country = "US";
    my ($album,$artist,$title,$track,$dateBegin,$dateEnd);
    my ($non_free_units,$non_free_royalty,$non_free_price,$free_units);
    foreach my $line (@$lines)
    {
        if((!$dateBegin)&&(!$dateEnd)&&($line->[0] =~ /(\d{4})\D(\d{2})\D(\d{2})/)) {
            ($dateBegin,$dateEnd) = _get_dates($line->[0]);
            unless ($dateBegin && $dateEnd)
            {
                $self->errstr("couldn't get dates");
                print STDERR "file name: $fileName\n";
                return undef;
            }
        }
        elsif($line->[0] =~ /Artist\:/i) {
            $artist = $line->[0];
            $artist =~ s/^.*\: //;;
        }
        elsif($line->[0] =~ /Album\:/i) {
            $album = $line->[0];
            $album =~ s/^.*\: //;
        }
        elsif($line->[0] ne "" && $line->[0] !~ /catalog total/i) {
            $track = $line->[0];
            $non_free_units = $line->[1];
            $non_free_royalty = $line->[3];
            $free_units = $line->[4];
            if($artist ne "" && $album ne "" && $track ne "") {
                if($non_free_units>0) {
                    $non_free_price = sprintf("%.8f",($non_free_royalty/$non_free_units));
                    my $sale = RPS::Import::SaleRec->new();
                    $sale->productType(RPS::File::Sale::TYPE_TRACK);
                    $sale->trackName($track);
                    $sale->formatType($format);
                    $sale->dateBegin($dateBegin);
                    $sale->dateEnd($dateEnd);
                    $sale->artistName($artist);
                    $sale->albumName($album);
                    $sale->price($non_free_price);
                    $sale->units($non_free_units);
                    $sale->countryCode($country);
                    $sale->lineNum($linenum);
                    $self->_insertSale(sale => $sale);
                }
                #else { print STDERR "skip non-free units: l:".$linenum." :" . join(",",@$line) . "\n"; }
                if($free_units>0) {
                    my $sale = RPS::Import::SaleRec->new();
                    $sale->productType(RPS::File::Sale::TYPE_TRACK);
                    $sale->trackName($track);
                    $sale->formatType($format);
                    $sale->dateBegin($dateBegin);
                    $sale->dateEnd($dateEnd);
                    $sale->artistName($artist);
                    $sale->albumName($album);
                    $sale->units($free_units);
                    $sale->free(1);
                    $sale->countryCode($country);
                    $sale->lineNum($linenum);
                    $self->_insertSale(sale => $sale);
                }
                #else { print STDERR "skip free units: " . join(",",@$line) . "\n";; }
            }
        }
        $linenum++;
    }
    return $linenum;
}

#
# Private methods
#

sub _get_dates
{
    my $passed_date = shift;
    my ($month,$day,$year,$end_month,$end_year);

    $passed_date =~ s/^.*Ending //;
    return undef unless ($passed_date =~ m/(\d{4})\D(\d{2})\D(\d{2})/);
    ($year, $month, $day) = ($1, $2, $3);
    if($month == 1 && $day == 1) {
        $end_month = 10;
        $end_year = $year - 1;
    }
    elsif ($day > 1) {
        $end_year = $year;
        $end_month = $month - 2;
    }
    else
    {
        $end_year = $year;
        $end_month = $month - 3;
    }
    return (sprintf("%04d-%02d-01",$end_year,$end_month),
            sprintf("%04d-%02d-%02d", $year, $month,$day)
    );
}

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