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

use strict;
use warnings;

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

use constant kIncomeSourceCD				    => 1;
use constant kIncomeSourceLP				    => 2;
use constant kIncomeSourceCassette			    => 3;
use constant kIncomeSourceDigitalAlbum		    => 4;
use constant kIncomeSourceDigitalTrack		    => 5;
use constant kIncomeSourceDigitalStream		    => 6;
use constant kIncomeSourceDigitalTethered	    => 7;
use constant kIncomeSourceRingtone			    => 8;
use constant kIncomeSourceMasterLicense		    => 9;
use constant kIncomeSourceSyncLicense		    => 10;
use constant kIncomeSourceJukebox               => 11;
use constant kIncomeSourceDualDownload          => 12;
use constant kIncomeSourceBackground            => 13;
use constant kIncomeSourceDVDCDSet              => 14;
use constant kIncomeSourceCDSingle              => 15;
use constant kIncomeSourceDblCD                 => 16;
use constant kIncomeSourceVPD                   => 17;
use constant kIncomeSourceDigitalAlbumPremium   => 18;
use constant kIncomeSourceDigitalTrackPremium   => 19;
use constant kIncomeSourceDigitalAlbumUpgrade   => 20;
use constant kIncomeSourceDigitalTrackUpgrade   => 21;
use constant kIncomeSourceDVD                   => 22;
use constant kIncomeSourceVHS                   => 23;
use constant kIncomeSourceLP5                   => 24;
use constant kIncomeSourceCassette5			    => 25;
use constant kIncomeSourceBluRay                => 26;
use constant kIncomeSourcePerformanceIncome     => 27;

use constant kFormatPhysical	=> 1;
use constant kFormatDigital		=> 2;
use constant kFormatOther		=> 3;

use constant kTable => 'income_source';
use constant kDB => Common::DB::Item::kCommonDB();




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

	my $sql = "SELECT * FROM ".kTable." ORDER BY format,name";
    return $class->SUPER::GetAll($sql);
}


1;