package RPS::Import::Sunnyside;

use strict;

#use Date::Calc qw(Days_in_Month Decode_Month);
use Date::Calc qw(Days_in_Month);

use lib '/app/tools/common/lib';
use Common::Util;
use Common::Consts;

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

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

use constant FIELD_SERVICE   => 1;
use constant FIELD_MONTH     => 2;
use constant FIELD_UPC       => 3;
use constant FIELD_ISRC      => 4;
use constant FIELD_UNITS     => 6;
use constant FIELD_PRICE     => 7;
use constant FIELD_ARTIST    => 8;
use constant FIELD_ALBUM     => 9;
use constant FIELD_TRACK     => 10;
use constant FIELD_PROD_TYPE => 12;
use constant FIELD_COUNTRY   => 13;
use constant FIELD_LABEL     => 15;
use constant FIELD_PROD_ID   => 17;

sub _importLines {
    my $self  = shift;
    my %args  = @_;
    my $lines = $args{lines};

    return undef unless $lines;

    my %dateCache = ();
    my $linenum   = 2;
    shift @$lines;    # skip first row

    foreach my $line (@$lines) {
        unless ( $dateCache{ $line->[FIELD_MONTH] } ) {
            my ( $y, $m ) = split( '-', $line->[FIELD_MONTH] );
            unless ( $y && $m ) {
                $self->errstr("couldn't get dates");
                print STDERR "date cell: $line->[FIELD_MONTH]\n";
                return undef;
            }

            #$y += 2000;
            #$m = Decode_Month($m);

            @{ $dateCache{ $line->[FIELD_MONTH] } } =
              ( sprintf( "%04d-%02d-01", $y, $m ), sprintf( "%04d-%02d-%02d", $y, $m, Days_in_Month( $y, $m ) ) );
        }
        my ( $dateBegin, $dateEnd ) = @{ $dateCache{ $line->[FIELD_MONTH] } };

        my $prodtype =
            $line->[FIELD_PROD_TYPE] =~ /a/i ? RPS::File::Sale::TYPE_ALBUM
          : $line->[FIELD_PROD_TYPE] =~ /t/i ? RPS::File::Sale::TYPE_TRACK
          :                                    '';

        my $format  = RPS::File::Sale::FORMAT_DOWNLOAD;
        my $prod_id = $line->[FIELD_PROD_ID];
        my $upc     = $line->[FIELD_UPC];
        my $isrc    = $line->[FIELD_ISRC];
        my $artist  = $line->[FIELD_ARTIST];
        my $album   = $line->[FIELD_ALBUM];
        my $track   = $line->[FIELD_TRACK];
        my $label   = $line->[FIELD_LABEL];
        my ($units) = $line->[FIELD_UNITS] =~ m/^(-?\d+)$/;
        $line->[FIELD_PRICE] =~ s/,//g;
        my ($price) = $line->[FIELD_PRICE] =~ m/^(-?\$?\d+\.?\d*)$/;
        my $country = $line->[FIELD_COUNTRY];

        $country = $Common::Consts::COUNTRY_CODE{ lc $country } if ( length $country > 2 );

        if ( $units && $price && ( $artist || $album ) ) {
            $price =~ s/\$//;
            $units *= -1 if ( $price < 0 && $units > 0 );
            $price /= $units;
            $price = abs($price);

            my $sale = RPS::Import::SaleRec->new();

            $sale->productType($prodtype);
            $sale->formatType($format);
            $sale->dateBegin($dateBegin);
            $sale->dateEnd($dateEnd);
            $sale->clientProductID($prod_id);
            $sale->upc($upc);
            $sale->isrc($isrc);
            $sale->artistName($artist);
            $sale->albumName($album);
            $sale->trackName($track);
            $sale->units($units);
            $sale->price($price);
            $sale->countryCode($country);
            $sale->lineNum($linenum);

            #$args{dumper}($sale);
            $self->_insertSale( sale => $sale );
        }
        $linenum++;
    }
    return $linenum;
}

#
# Private methods
#

sub _get_dates {
    my $cell = shift;

    my ( $month, $year ) = split( '-', $cell );
    return undef unless ( $month && $year );
    $year += 2000;
    $month = Decode_Month($month);

    return ( sprintf( "%04d-%02d-01", $year, $month ), sprintf( "%04d-%02d-%02d", $year, $month, Days_in_Month( $year, $month ) ) );
}

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