#------------------------------------------------------------
# Copyright (C) 2006 RoyaltyShare, Inc.   All Rights Reserved
#------------------------------------------------------------
package RPS::DB::Item::ArtistContract;

use strict;
use warnings;

use lib '/app/tools/common/lib';
use Common::Util qw(escape_mysql_regexp);
use Common::DB::ItemCollection;

use Common::DB::Item;
use base 'Common::DB::Item';

use constant kModeUnit				=> 1;
use constant kModeNetRevenue		=> 2;
use constant kModeUnitDigital		=> 3; # albums
use constant kModeUnitDigitalSingle	=> 4; # single downloads

use constant kRateTypePercent	=> 1;
use constant kRateTypeFlat		=> 2;

use constant kTable => 'artist_contract';
use constant kDB => Common::DB::Item::kClientDB();

# !!! THIS IS DEPRECATED



sub GetAll
{
	my %args = @_;

	my $order = "artist_contract.title, artist_payee.name";

	my $sql = "SELECT artist_contract.* FROM artist_contract"
		. " LEFT JOIN artist_payee ON artist_payee.artist_payee_id=artist_contract.artist_payee_id ORDER BY $order";

	my $collection = Common::DB::ItemCollection->new(
	 class => "RPS::DB::Item::ArtistContract",
	 query => $sql,
	 dbID => $gConfig->{_db},
	);

	return $collection;
}


sub Search
{
	my ($searchTerm) = @_;

	my $where;
	if($searchTerm)
	{
		$where = Common::DB::Item->SearchSyntax(field => "artist_payee.name", value => $searchTerm)
			. " OR " . Common::DB::Item->SearchSyntax(field => "artist_contract.title", value => $searchTerm);
	}
	else
	{
		die "no valid param passed to artist_contract search";
	}

	my $order = "artist_contract.title, artist_payee.name";

	my $sql = "SELECT artist_contract.* FROM artist_contract"
		. " LEFT JOIN artist_payee ON artist_payee.artist_payee_id=artist_contract.artist_payee_id"
		. " WHERE $where"
		. " ORDER BY $order";

	my $collection = Common::DB::ItemCollection->new(
	 class => "RPS::DB::Item::ArtistContract",
	 query => $sql,
	 dbID => $gConfig->{_db},
	);

	return $collection;
}

sub GetByPayorID
{
	my ($payorID) = @_;

	my $dbo = Common::RSApp::GetClientDB();

	my $sql = "SELECT * FROM ".kTable." WHERE payor_id=$payorID";

	my $collection = Common::DB::ItemCollection->new(
	 class => "RPS::DB::Item::ArtistContract",
	 query => $sql,
	 dbID => $gConfig->{_db},
	);

	return $collection;
}


1;