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.
###