#------------------------------------------------------------
# Copyright (C) 2007 RoyaltyShare, Inc.   All Rights Reserved
#------------------------------------------------------------
package RPS::Report::AlbumsWithoutContracts;
use strict;
use warnings;

use lib '/app/tools/common/lib';
use Common::FormObject;
use Common::Assert;

use lib '/app/tools/rps/lib';
use RPS::DB::Item::ReportQueries;
use RPS::DB::Item::ReportQueries::AlbumWithoutContracts;

use base 'RPS::Report';

sub _baseXMLName { 'Album' }

sub _getDBItem() {
    my $self = shift;
    return RPS::DB::Item::ReportQueries::AlbumWithoutContracts->GetAlbumsWithoutContracts();
}

sub _reportColumns {
    my $self = shift;

    return (
        "LabelName"       => "Label",
        "CatalogNumber"   => "Catalog #",
        "AlbumTitle"      => "Album Title",
        "AlbumArtistName" => "Album Artist",
        "AlbumID"         => "RS Album ID",
        "AlbumStatus"     => "Album Status",
        "TrackOrder"      => "Track No",
        "TrackTitle"      => "Track Title",
        "TrackArtistName" => "Track Artist",
        "TrackISRC"       => "ISRC",
        "TrackID"         => "RS Track ID"
    );
}

sub _fillInHash {
    my ( $self, $album ) = @_;

    my %data;

    $data{LabelName}       = $album->label_name;
    $data{CatalogNumber}   = $album->catalog_number;
    $data{AlbumTitle}      = $album->album_title;
    $data{AlbumArtistName} = $album->album_artist_name;
    $data{AlbumID}         = $album->album_id;
    $data{AlbumStatus}     = $album->album_status == 1 ? "Active" : "Inactive";
    $data{TrackTitle}      = $album->track_title;
    $data{TrackArtistName} = $album->track_artist_name;
    $data{TrackOrder}      = $album->track_order;
    $data{TrackISRC}       = $album->track_isrc;
    $data{TrackID}         = $album->track_id;

    return \%data;
}

###
1;    #
###