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

# !!! DEPRECATED

use strict;
use warnings;

use lib '/app/tools/common/lib';
use Common::Assert;
use Common::DB::ItemCollection;


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

my $gConfig =
{
	_db => Common::DB::Item::kClientDB(),
	'artist_contract_term_id' =>
	{
		_table => 'artist_contract_term',
        _auto => 1,
		_key => 1,
	},
	'artist_contract_id' =>
	{
		_table => 'artist_contract_term',
	},
	'contract_mode' =>
	{
		_table => 'artist_contract_term',
	},
	'channel_id' =>
	{
		_table => 'artist_contract_term',
	},
	'product_format_id' =>
	{
		_table => 'artist_contract_term',
	},
	'price_level_id' =>
	{
		_table => 'artist_contract_term',
	},
	'percent' =>
	{
		_table => 'artist_contract_term',
	},
};


sub _config
{
	my ($self) = @_;

	return $gConfig;
}


sub GetByArtistContractID
{
    my ($artistContractID, $mode) = @_;
	assert($artistContractID);

	my $sql = "SELECT * FROM artist_contract_term WHERE artist_contract_id=$artistContractID";
    if ($mode)
    {
        $sql .= " AND contract_mode=$mode";
    }
	my $collection = Common::DB::ItemCollection->new(
	 class => "RPS::DB::Item::ArtistContractTerm",
	 query => $sql,
	 dbID => $gConfig->{_db},
	);

	return $collection;
}

1;