"""
Enums for the consumer logic.
"""

from enum import StrEnum, unique


@unique
class ColumnAlias(StrEnum):
    """Column aliases for the SQL queries and their output."""

    IPI = "IPI"
    PRO = "PRO"
    LEGAL_NAME = "LEGAL_NAME"
    PUB_WRITER_ID = "PUB_WRITER_ID"
    ADJUSTED_GROSS = "ADJUSTED_GROSS"
    NET_REVENUE = "NET_REVENUE"
    NET_REVENUE_PREFERRED_CURRENCY = "NET_REVENUE_PREFERRED_CURRENCY"
    PUB_SONG_ID = "PUB_SONG_ID"
    TITLE = "TITLE"
    SONG_NO = "SONG_NO"
    SONG = "SONG"
    WRITER = "WRITER"
    SOURCE1_NAME = "SOURCE1_NAME"
    SOURCE1_COUNTRY = "SOURCE1_COUNTRY"
    SOURCE2_NAME = "SOURCE2_NAME"
    SOURCE2_COUNTRY = "SOURCE2_COUNTRY"
    SOURCE3_NAME = "SOURCE3_NAME"
    SOURCE3_COUNTRY = "SOURCE3_COUNTRY"
    SOURCE4_NAME = "SOURCE4_NAME"
    SOURCE4_COUNTRY = "SOURCE4_COUNTRY"
    INCOME_TYPE = "INCOME_TYPE"
    SH_ID = "SH_ID"
    REPORTING_PERIOD = "REPORTING_PERIOD"
    SALES_PERIOD = "SALES_PERIOD"
    PRODUCT_NUMBER = "PRODUCT_NUMBER"
    ARTIST_PRODUCT_NUMBER = "ARTIST_PRODUCT_NUMBER"
    UNITS = "UNITS"
    SONG_SHARE_PCT = "SONG_SHARE_PCT"
    CONTROL_PCT = "CONTROL_PCT"
    AMOUNT = "AMOUNT"
    DF = "DF"
    SOURCE_PRODUCT = "SOURCE_PRODUCT"
    SOURCE_SONG = "SOURCE_SONG"
    ISWC_CD = "ISWC_CD"
    ARTIST = "ARTIST"
    ISRC = "ISRC"
    FEE_PCT = "FEE_PCT"
    VENDOR_ID = "VENDOR_ID"
    PREFERRED_CURRENCY = "PREFERRED_CURRENCY"
    CURRENCY_CONVERSION_RATE = "CURRENCY_CONVERSION_RATE"


@unique
class ReportTabNames(StrEnum):
    """Report tab names for the Excel report."""

    COMPOSER = "By Composer"
    FULL_DETAIL = "Full Detail"