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

use constant kTable => 'bonus_track';
use constant kDB => Common::DB::Item::kClientDB;


sub GetByProductTrackID
{
	my ($class, $productID, $trackID) = @_;
	return undef if(!$productID || !$trackID);

	my $sql = "SELECT * FROM bonus_track WHERE product_id=$productID AND track_id=$trackID";

    return $class->GetAll($sql);

}


sub GetByProductID
{
	my ($class, $productID) = @_;

	my $sql = "SELECT * FROM bonus_track WHERE product_id=$productID";

    return $class->GetAll($sql);
}


sub DeleteByTrackAndProductID
{
	my ($class, $trackID, $productID) = @_;

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

	my $sql = "DELETE FROM bonus_track WHERE track_id=$trackID AND product_id=$productID";

    $dbo->DoCmd($sql);
    
    return 1;
}


sub DeleteByProductID
{
	my ($class, $productID) = @_;


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

	my $sql = "DELETE FROM bonus_track WHERE product_id=$productID";

    $dbo->DoCmd($sql);
    
    return 1;
}

1;