#------------------------------------------------------------
# Copyright (C) 2006 RoyaltyShare, Inc.   All Rights Reserved
# $Id$
#------------------------------------------------------------
package RPS::DB::Item::ArtistContractUnitEscalation;
use lib '/app/tools/common/lib';
use Common::DB::Item;
use Common::DB::ItemCollection;
use base 'Common::DB::Item';

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

sub GetByContractID {
    my ( $contractID, $mode ) = @_;

    my @params = ($contractID);
    my $where = "WHERE artist_contract_id = ?";
    if ($mode) {
        $where .= " AND contract_mode = ?";
        push @params, $mode;
    }

    my $sql = "SELECT * FROM " . kTable . " $where ORDER BY contract_mode, units";

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

    return $collection;
}

1;