"""Pass through related SQL queries and params."""

SQL_GET_EQ_AGGREGATED = """
SELECT
    SUM(amount) AS eq_bonus,
    SUM(original_price) as usd_eq_bonus
FROM ACCOUNTINGFLAT.PROD.passthru_processed
WHERE
    vendor_id = :vendor_id
    AND trans_type = 'EQ'
    AND period_id = :period_id
"""
SQL_GET_CURRENCY_ID_AND_EXCHANGE_RATE = """
SELECT
    payout_currency_id,
    fx_adjusted_exchange_rate
FROM ACCOUNTINGFLAT.PROD.passthru_processed
WHERE
    vendor_id = :vendor_id
    AND trans_type = 'EQ'
    AND period_id = :period_id
LIMIT 1
"""
SQL_GET_CURRENCY_SYMBOL = """
SELECT
    SYMBOL_HTML_ENTITY_CODE
FROM ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.currencies
WHERE id = :currency_id
"""
SQL_GET_EQ_CHECKS_PAID = """
SELECT
    check_amt AS amount,
    check_no,
    cut_date,
    comments
FROM spotify_equity_checkspaid
WHERE
    vendor_id = :vendor_id
    AND paidfor_period_id = :period_id
"""