package RPS::Import::Moontaxi;

use strict;

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';

# map version num to the field order
my %field_map =
(
    1 =>
    {
        'date'			=> 0,
        'units' 		=> 1,
        'extprice'     	=> 5,
        'selection'		=> 6,
        'artist'		=> 7,
        'title'			=> 8,
        'label'			=> 9,
    },
);

#public methods

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

	my $retval = undef;
	my $sheets = $args{sheets};
	my $fileObj = $args{file};
	my $version = $fileObj->VersionNum;

	my $summary_sheet;
	my $lines;
	if($sheets)
	{
		$summary_sheet = $sheets->[0];
		$lines = $sheets->[1];
	}
	else
	{
        $self->errstr("missing sheets");
		return 0;
	}

	if ($lines && $summary_sheet && $version)
	{
		my $offsets;
		if($version && exists $field_map{$version})
		{
			$offsets = $field_map{$version};
		}
		else
		{
            $self->errstr("wrong version");
			return 0;
		}

        my $linenum = 1;
        foreach my $line(@$lines)
        {
            if ($linenum > 1)
            {
                my $date;
                my $dateBegin;
                my $dateEnd;

                $date = Common::Util::normalize_date($line->[$offsets->{'date'}]);
                if ($date)
                {
                    ($dateBegin, $dateEnd) = Common::Util::normalize_sales_month_dates($date, $date);
                }

                my $prodtype;
                my $album;
                my $track;
                if ($line->[$offsets->{'selection'}])
                {
                    $prodtype = RPS::File::Sale::TYPE_ALBUM;
                    $album    = $line->[$offsets->{'title'}];
                }
                else
                {
                    $prodtype = RPS::File::Sale::TYPE_TRACK;
                    $track    = $line->[$offsets->{'title'}];
                }

                my $format      = RPS::File::Sale::FORMAT_DOWNLOAD;
                my ($upc)       = $line->[$offsets->{'selection'}] =~ m/^indy_(\d+)$/;
                $upc            = Common::Util::normalize_upc($upc);
                my $artist		= $line->[$offsets->{'artist'}];
                my $label		= $line->[$offsets->{'label'}];
                my ($units)		= $line->[$offsets->{'units'}] =~ m/^(-?\d+)$/;
                my ($extprice)  = $line->[$offsets->{'extprice'}] =~ m/^(\d*\.?\d*)$/;
                my $price;
                if ($units && $extprice)
                {
                    $price = $extprice / $units;
                }

                if ($units && $price && $artist && ($album || $track))
                {
                    if (!($dateBegin && $dateEnd))
                    {
                        $self->errstr("couldn't get dates");
                        return undef;
                    }

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

                    $sale->productType($prodtype);
                    $sale->formatType($format);
                    $sale->dateBegin($dateBegin);
                    $sale->dateEnd($dateEnd);
                    $sale->upc($upc);
                    $sale->artistName($artist);
                    $sale->albumName($album);
                    $sale->trackName($track);
                    $sale->labelName($label);
                    $sale->units($units);
                    $sale->price($price);
                    $sale->lineNum($linenum);
                    $sale->countryCode("US");

                    $self->_insertSale(sale => $sale);
                }
            }
            $linenum++;
        }
        $retval = $linenum;
	}

	return $retval;
}

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