#---------------------------------------------------------------
# ____                   _ _         ____  _
#|  _ \ ___  _   _  __ _| | |_ _   _/ ___|| |__   __ _ _ __ ___
#| |_) / _ \| | | |/ _` | | __| | | \___ \| '_ \ / _` | '__/ _ \
#|  _ < (_) | |_| | (_| | | |_| |_| |___) | | | | (_| | | |  __/
#|_| \_\___/ \__, |\__,_|_|\__|\__, |____/|_| |_|\__,_|_|  \___|
#            |___/             |___/
#
# Copyright (C) 2012 RoyaltyShare, Inc.   All Rights Reserved
#---------------------------------------------------------------

package RPS::DB::Item::CAPublisherTrackLicense;

use strict;
use warnings;
use lib '/app/tools/common/lib';
use lib '/app/tools/rps/lib';
use Common::Log;
use Common::DB::Item;
use Common::DB::ItemCollection;
use Common::Assert;

use base 'Common::DB::Item';

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

# We are joining some tables, so we need a custom configuration.
#
sub _config {
    my ($class) = @_;

    return {
        'track_license_id' => {},
        'album_title'      => {},
        'album_id'         => {},
        'track_title'      => {},
        'track_id'         => {},
        'track_order'      => {},
        'crossed'          => {},
        'region_id'        => {},
        'region_name'      => {},
        'share'            => {},
        'admin_id'         => {},
        'agent_id'         => {},
        'admin_name'       => {},
        'agent_name'       => {},
        'type'             => {},
        'product_type_id'  => {},
        'inactive'         => {},
    };
}

sub GetListSorted {
    my ( $class, $publisherID, $payorID, $directOrIndirect ) = @_;

    assert($publisherID);
    assert($payorID);

    my @select;
    push @select, "ca_track_license.ca_track_license_id AS track_license_id";
    push @select, "album.title AS album_title";
    push @select, "album.album_id AS album_id";
    push @select, "track.title AS track_title";
    push @select, "track.track_id AS track_id";
    push @select, "track.track_order AS track_order";
    push @select, "ca_track_license.cross_collateralized AS crossed";
    push @select, "ca_track_license.share AS share";
    push @select, "ca_track_license.type AS type";
    push @select, "ca_track_license.inactive AS inactive";
    push @select, "ca_track_license.product_type_id AS product_type_id";
    push @select, "region.region_id AS region_id";
    push @select, "region.name AS region_name";
    push @select, "track_license_publisher.admin_id AS admin_id";
    push @select, "track_license_publisher.agent_id AS agent_id";
    push @select, "publisher_admin.publisher_name as admin_name";
    push @select, "publisher_agent.publisher_name as agent_name";

    my @join;
    push @join, "LEFT JOIN track ON (ca_track_license.track_id = track.track_id)";
    push @join, "LEFT JOIN album ON (track.album_id = album.album_id)";
    push @join, "LEFT JOIN region ON (ca_track_license.region_id = region.region_id)";
    push @join,
      "LEFT JOIN ca_publisher AS track_license_publisher ON (ca_track_license.ca_publisher_id = track_license_publisher.ca_publisher_id)";
    push @join, "LEFT JOIN ca_publisher AS publisher_admin ON (track_license_publisher.admin_id = publisher_admin.ca_publisher_id)";
    push @join, "LEFT JOIN ca_publisher AS publisher_agent ON (track_license_publisher.agent_id = publisher_agent.ca_publisher_id)";

    my @where;
    push @where, "ca_track_license.ca_publisher_id=" . $class->quote($publisherID);
    push @where, "ca_track_license.payor_id=" . $class->quote($payorID);
    if ( 'direct' eq $directOrIndirect ) {
        push @where, "publisher_direct = 1";
    }
    if ( 'indirect' eq $directOrIndirect ) {
        push @where, "publisher_direct = 0";
    }

    my $sql =
        "SELECT "
      . join( ',', @select )
      . " FROM ca_track_license "
      . join( ' ', @join )
      . " WHERE "
      . join( ' AND ', @where )
      . " ORDER BY album_title,track_order,product_type_id,region_id";

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

1;