#!/usr/bin/perl

use strict;
use Getopt::Std;

use lib '/app/tools/common/lib';
use Common::RSApp;
use Common::RSMath;

use lib '/app/tools/rps/lib';
use RPS::DB::Item::Track;
use RPS::DB::Item::Master;
use RPS::DB::Item::TrackLicense;
use RPS::DB::Item::Album;
use RPS::DB::Item::Publisher;

# Parse the command-line.
#
my ($clientID) =  parseCommandLine();

# Instantiate the application singleton object.
#
my $appSingleton = Common::RSApp->new(clientID => $clientID);

convertContracts();



#
# --- Subroutines
#

sub convertContracts
{
	my %seen = ();

	# get collection of contracts
	#
	my $licenseColl = RPS::DB::Item::TrackLicense->GetAll();

	while($licenseColl->hasNext())
	{
		my $licenseObj = $licenseColl->next();
		next if($licenseObj->type == RPS::DB::Item::TrackLicense::kPublicDomain());
		next if($seen{$licenseObj->track_id});

		my $track = RPS::DB::Item::Track->Lookup(track_id => $licenseObj->track_id);
		if($track)
		{
			my $master = RPS::DB::Item::Master->Lookup(master_id => $track->master_id);
			if($master && !$master->duration)
			{
				reportTrack($track, $licenseObj);
				$seen{$track->track_id} = 1;
			}
		}
	}
}


sub reportTrack
{
	my ($track, $license) = @_;

	my $album = RPS::DB::Item::Album->Lookup(album_id => $track->album_id);
	my $publisher = RPS::DB::Item::Publisher->Lookup(publisher_id => $license->publisher_id);

	my $type;
	if($license->product_type_id == 2)
	{
		$type = "CD";
	}
	else
	{
		$type = "D";
	}

	my $line = join("\t",
					$album->catalog_number,
					$album->title,
					$track->track_number,
					$track->title,
					$publisher->publisher_name,
					$license->date_issued,
					$type,
					$license->inactive,
					);

	reportLine($line);
}


sub reportLine
{
	my $line = shift;

	print $line ."\n";
}

sub parseCommandLine
{
    my %opt;
    getopts('c:f:p', \%opt);

    my $clientID = $opt{c};

    unless ($clientID =~ /^\d+$/ && $clientID > 0)
    {
	    die usage("You must specify a valid client ID");
    }

    return $clientID;
}


sub usage
{
	my $errstr = shift;
	my $text = ($errstr) ? "ERROR: $errstr\n" : '';
	$text .= "Usage: $0 -c <clientID> -f <inputFile>\n";
	return $text;
}