"""SQL queries for art_relations."""

# update encoding order status
UPDATE_ENCODING_ORDER_STATUS = """
    UPDATE encoding_order
    SET processed = "{status}"
    WHERE encoding_order_id = {order_id}
    """

GET_ENCODING_ORDERS = """
SELECT encoding_order_id
FROM encoding_order
WHERE encoder_id IN ({encoder_ids})
    AND order_status = "close"
    AND processed <> "Y"
    AND type = "track"
    AND encoder_delivery_date >= DATE_SUB(CURRENT_DATE, INTERVAL 1 MONTH)
ORDER BY priority LIMIT {limit}
"""

GET_ENCODING_ORDER_DETAILS = """
SELECT
    eo.encoding_order_id,
    eo.priority,
    eo.encoder_id,
    eo.meta_update,
    eo.entry_date,
    eo.orchadmin_user_id,
    eod.upc,
    cmm.customer_master_master_id,
    eo.processed,
    r.release_id,
    r.project_id
FROM encoding_order_detail eod
INNER JOIN encoding_order eo ON eo.encoding_order_id = eod.encoding_order_id
INNER JOIN customer_master_master cmm
    ON FIND_IN_SET(cmm.customer_master_master_id, eo.dms_list)
LEFT JOIN releases r ON r.upc = eod.upc
WHERE eo.encoding_order_id IN ({order_ids})
GROUP BY eo.encoding_order_id, eod.upc, cmm.customer_master_master_id;
"""