#------------------------------------------------------------
# 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 kIncomeSourceEphemeral           => 28;
use constant kIncomeSourceNonEphemeral        => 29;
use constant kIncomeSourceOrchardSync         => 30;

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;