#------------------------------------------------------------
# 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;    #
###