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

# !!! THIS IS DEPRECATED

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

my $gConfig = {
    _db => Common::DB::Item::kClientDB(),

    'artist_contract_term_deduction_id' => {
        _table => 'artist_contract_term_deduction',
        _auto  => 1,
        _key   => 1,
    },
    'artist_contract_term_id' => {
        _table => 'artist_contract_term_deduction',
    },
    'deduction_type_id' => {
        _table => 'artist_contract_term_deduction',
    },
    'amount' => {
        _table => 'artist_contract_term_deduction',
    },
};

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

    return $gConfig;
}

sub GetByTermID {
    my $termID = shift || return undef;

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

    my $sql =
      "SELECT * FROM artist_contract_term_deduction WHERE artist_contract_term_id=$termID ORDER BY artist_contract_term_deduction_id";

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

    return $collection;
}

1;