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

# !!! DEPRECATED

use strict;
use warnings;
use lib '/app/tools/common/lib';
use Common::DB::Item;
use base 'Common::DB::Item';

my $gConfig =
{
	_db => Common::DB::Item::kClientDB(),
	'artist_contract_term_id' =>
	{
		_table => 'artist_contract_term_reserve_liquidation',
		_key => 1,
	},
	'period' =>
	{
		_table => 'artist_contract_term_reserve_liquidation',
		_key => 1,
	},
	'liquidation_percentage' =>
	{
		_table => 'artist_contract_term_reserve_liquidation',
	},
};


sub _config
{
	return $gConfig;
}

sub GetByTermID
{
    my ($id, $type) = @_;

	my $sql = "SELECT * FROM artist_contract_term_reserve_liquidation WHERE artist_contract_term_id=$id ORDER BY period";

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

	return $collection;
}

sub GetByTermIDAndPeriod
{
    my ($id, $period) = @_;

    my $sql = "SELECT * FROM artist_contract_term_reserve_liquidation WHERE artist_contract_term_id=$id AND period=$period";

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

    if ($collection->size() == 0)
    {
        return undef;
    }
    return $collection->next();
}


###
1;#
###