package RPS::Import::Universal;

use strict;


use Date::Calc qw(Days_in_Month Decode_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_COUNTRY    => 5;
use constant FIELD_ISRC       => 6;
use constant FIELD_START_DATE => 9;
use constant FIELD_END_DATE   => 10;
use constant FIELD_FORMAT     => 11;
use constant FIELD_UNITS      => 12;
use constant FIELD_CURRENCY   => 26;
use constant FIELD_PRICE      => 27;

#public methods

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

	my $retval = undef;
    my $lines = $args{lines};

    my $linenum = 1;
    foreach my $line (@$lines)
    {
        my $prodtype    = RPS::File::Sale::TYPE_TRACK;
        my $isrc        = $line->[FIELD_ISRC];
        my $format      = $line->[FIELD_FORMAT];
        my $country     = $line->[FIELD_COUNTRY];
        my $currency    = $line->[FIELD_CURRENCY];

        my $country_code = $Common::Consts::COUNTRY_CODE{lc $country};

        if ($format eq "DOWNL" || $format eq "DOWNP") {
            $format = RPS::File::Sale::FORMAT_DOWNLOAD;
        } elsif ($format eq "STREA") {
            $format = RPS::File::Sale::FORMAT_STREAM;
        } elsif ($format eq "MOBIL" || $format eq "M.ORD" || $format eq "U-MOB") {
            $format = RPS::File::Sale::FORMAT_RINGTONE;
        } else {
            $format = undef;
        }
   
        my ($dateBegin, $dateEnd) = $self->_getDates($line->[FIELD_START_DATE], $line->[FIELD_END_DATE]);

        my ($units)	   	= $line->[FIELD_UNITS] =~ m/^(-?\d+)$/;
        my ($price)    	= $line->[FIELD_PRICE] =~ m/^(-?\d*\.?\d*)$/;
        $price = ($units != 0)?($price / $units):0;

        if ($prodtype && $units && $isrc)
        {
            my $sale = RPS::Import::SaleRec->new();
 
            $sale->productType($prodtype);
            $sale->dateBegin($dateBegin);
            $sale->dateEnd($dateEnd);
            $sale->formatType($format);
            $sale->isrc($isrc);
            $sale->units($units);
            $sale->price($price);
            $sale->countryCode($country_code);
            $sale->currencyCode($currency);
            $sale->lineNum($linenum);
    
            ##$args{dumper}($sale);  ## for cmd-line testing
            $self->_insertSale(sale => $sale);
        }
        $linenum++;
    }
	return $linenum;
}

#
# Private methods
#


sub _getDates
{
	my $self = shift;
	my $date1 = shift;
	my $date2 = shift;

    my ($dateBegin, $dateEnd);

    if ($date1 =~ m/^(\d{4})(\d\d)$/) {

        $dateBegin = sprintf("%04d-%02d-%02d", $1, $2, 1);

        if ($date2 =~ m/^(\d{4})(\d\d)$/) {
            $dateEnd   = sprintf("%04d-%02d-%02d", $1, $2, Days_in_Month($1, $2));
        } else {
            return undef;
        }
    
    } else {
        return undef;
    }

	return ($dateBegin, $dateEnd);
}

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