"""
Database configuration for margin calculator
"""

DB_CONFIG = {
    'central': {
        'host': 'localhost',
        'user': 'root',
        'password': ')V9IR<W:~4=HrqbL',
        'database': 'goparts',
        'charset': 'utf8mb4'
    },
    'data_warehouse': {
        'host': 'localhost',
        'user': 'root',
        'password': ')V9IR<W:~4=HrqbL',
        'database': 'gopartsdatawarehouse',
        'charset': 'utf8mb4'
    },
    'b2b': {
        'host': 'localhost',
        'user': 'root',
        'password': ')V9IR<W:~4=HrqbL',
        'database': 'b2bgopar_dev',
        'charset': 'utf8mb4'
    }
}

# USAuto supplier IDs that get 4% rebate
USAUTO_SUPPLIERS = [16, 17, 45, 48, 49, 54]

# All order item statuses (not filtering, syncing all)
ALL_ITEM_STATUSES = [1, 3, 4, 6, 12, 24, 31, 32, 35, 39, 43, 48, 50, 52, 53]

# Date range for August through current date
NOVEMBER_START = '2025-08-01 00:00:00'
NOVEMBER_END = '2025-11-22 23:59:59'