# ABACUS DB QUERIES
GET_ACCOUNT_BY_IDS = """
    SELECT account_id
    FROM account WHERE account_id IN ({account_ids});
"""

GET_STATEMENT_PERIODS_BY_ID = """
    SELECT statement_period_id
    FROM  statement_period
    WHERE statement_period_id = %s AND statement_period_status = 'current' AND
    closed_date is NULL;
"""

GET_ADJUSTMENT_TYPES = """SELECT type_name FROM reference_adjustment_type;"""

GET_CONTRACTS_BY_IDS = """
    SELECT contract_id
    FROM contract WHERE contract_id IN ({contract_ids});
"""

GET_CONTRACT_TERMS_BY_TYPE_AND_CONTRACT_ID = """
    SELECT contract_id, term_type, attachments 
    FROM `contract_term` WHERE term_type=%s AND contract_id IN ({contract_ids});
"""

GET_STATEMENT_PERIODS_BY_STATEMENT_YEARS = """
    SELECT statement_year, statement_month
    FROM statement_period
    WHERE statement_period_status IN ('open', 'current') and statement_year IN ({statement_years});
"""


# ART-RELATIONS DB QUERIES
GET_UPCS = """
    SELECT display_upc, upc
    FROM releases WHERE deletions = 'N' AND upc != display_upc AND display_upc IN ({upcs}) ORDER BY display_upc;
"""

GET_VENDOR_UPC_OWNERSHIPS = """
    SELECT v.vendor_id, r.upc, r.display_upc FROM releases r
    INNER JOIN project p ON p.project_id = r.project_id
    INNER JOIN vendor v ON v.vendor_id = p.vendor_id
    WHERE v.vendor_id = %s
    AND (r.upc = %s OR r.display_upc = %s)
"""