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

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

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



sub GetAll
{
    my ($class) = @_;
	my $sql = "SELECT * FROM label ORDER BY label_name";

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

sub GetDefault
{
    my ($class) = @_;
    return RPS::DB::Item::Label->Lookup(is_default => 1);
}

sub GetLabelNameFromTrackID
{
	my ($class, $trackID) = @_;
	
  my $dbo = Common::RSApp::GetClientDB();

	my $sql = "SELECT label_name FROM track t,album a,label l WHERE t.track_id=$trackID AND t.album_id=a.album_id AND a.label_id=l.label_id";

  my $sth = $dbo->DoCmd( $sql );

  my ($result) = $sth->fetchrow_array() if( $sth );

  return $result;
}

sub GetLabelsWithoutContracts 
{
	my ($class) = @_;

    my $sql = "select * from label left join label_contract_term using (label_id) where label_contract_term.label_id IS NULL";

    Common::Log::Debug( "QUERY: $sql" );

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

1;